際際滷

際際滷Share a Scribd company logo

BALWANT SINGH_RESUME

Balwant Singh
Balwant Singh

Balwant Singh is a senior package solution consultant with over 5 years of experience in ETL, data warehousing, and reporting solutions using technologies such as ODI 11g, OBIEE 11g, and Oracle databases. He has extensive experience designing and implementing data integration projects for customers in various industries. Currently, he works for IBM India on an MSI project involving OBIEE, ODI, and BI applications.

1 of 9
Download to read offline
BALWANT SINGH +91-9686525462 chotu0190@gmail.com BALWANT SINGH Senior Package Solution Consultant Passport Number-M6430156 CAREER OBJECTIVE To be a part of an organization where process of learning never ends and at every step which provides an ample of opportunities to prove my worth .A place where initiative hard work and learning through constructive criticism is always promoted. Professional Summary: Having 5+ years of experience in ETL, Data warehousing and reporting solution. Strong knowledge on Data Warehouse and Oracle Data Integrator 11g. Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support. Well acquainted Knowledge of SQL, PL/SQL and Oracle APEX. Have implemented ODI mappings from Informatica code. Good Experience of source control systems SVN for maintaining the version. Knowledge of JIRA to update and log the task Good knowledge on OBIEE agents, ibots, KPI and security. Having good understanding on BI Apps and involved in SSO integration between Apps and BI user. Worked on OBIEE integration with MS office and smart view with Essbase. Extensive knowledge in developing business model mapping and deploying the repository in production. Extensive experience in designing of Package, Scenario, Interface, Procedures in ODI Expertise with all ODI tools - Topology, Security Manager, Designer and Operator. Designed Physical Schemas, Data Servers and Agents using Topology Manager. Good knowledge on developing RPD and designing business model for OBIEE reporting. Experienced in designing complex models with multiple facts using LTS, complex calculations with proper aggregates content definition. Experience in Designing level based/value based/parent child hierarchies, level based and time series based calculations.
Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI. Worked with multiple sources such as Relational database, Flat files for Extraction Transforming and Loading data into target tables. Involved in model creation which holds the data at ODI Designer level. Extensively worked in designing and monitoring ODI packages, Interfaces, Scenarios, sessions and procedures. Good knowledge in designing star schema and snowflake schema. Experienced in creating managing session/repository and presentation variables. 2 Year of extensive experience in Oracle Apps 11i and R12. Worked on Order management module in Oracle apps and resolved functional and technical issue. Having 6 month of experience in functional testing of Oracle apps all module using QTP, Load runner and OATS tool. Sound knowledge on KMs (Knowledge module) of ODI 11g. Hands on experience in creating standalone agent and J2EE agent. Having good knowledge on Unix and worked on SFTP server. Proficient in handling oracle Procedures, Functions and Packages and strong knowledge of SQL. Having knowledge on APEX. Developed Database and web based Application using Oracle Application Express(APEX) 4.2. . Possess good interpersonal, presentation and developmental skills with Strong analytical and problem solving approach and an excellent team player Technical Proficiency: Reporting tools & ETL tools: ODI 11g, OBIEE 11g, Essbase Database : Oracle 9i, 10G,11g Languages : SQL, PL/SQL.Unix Tools : OBIEE, ODI, TOAD, APEX, JIRA,SVN Operating Systems : Windows NT /2000 Server/XP and UNIX. PROFESONAL EXPERIENCE Current company IBM India 30 Sep 2015- Till date Previous Company Aditi Technologies 9 Sep 2014- 24 Sep 2015 Previous company Oracle India Pvt Ltd 26 May 2011-08-Sep 2014
PROJECT DETAILS 1 Project 1: MSI Greenfield Role: Senior Package Solution Consultant Duration: Sep 2015- Till Date Technology: OBIEE 11g, ODI 11g,BIAPPS Description Greenfield project could be one developing a system for a totally new environment, without concern for integrating with other systems, especially not legacy systems. Such projects are deemed higher risk, as they are often for new infrastructure, new customers, and even new owners. For this reason, agile software development is often deemed the best approach, as it proposes how to handle those risks by developing small slices of complete functionality and getting them in the hands of customers (internal or external) quickly for immediate feedback. Roles and Responsibilities: Working on design and development part of all modules of OBIA customizations type 1 and type 2. Worked on migrating the mapping from Informatica to ODI. Worked on Oracle EBS source and complex requirement. Interaction with client and onsite team to gather technical requirement on rice id. Working on ODI code migration from Dev to UAT. Responsible for Data load and load plan generation in BIACM. Working on SDE, SIL and PLP customization in ODI. Working on several defects raised by user on data issue by using HPQC tool. Working on complex lookup transformation, Data set in ODI interface.
Worked on implementation of new Dimension and Fact table from design, development to testing. Worked on various report in OBIEE for data validation and development side. PROJECT DETAILS 2 Project 1: Ladbrokes UK Role: Senior Development Engineer Duration: Sep 2014- Till Date Technology: OBIEE 11g, ODI 11g,JIRA Description Ladbrokes is large UK based company for Gaming and Batting Industries. Ladbrokes has EGAMING Digital retail betting 2,500 shops which is operates several online gambling websites offering sports book, poker, casino, games, bingo and backgammon. Ladbrokes uses the Open Bet system from Orbits Technology. Roles and Responsibilities: Worked on various source and target like file to oracle and oracle to file. Developed ODI packages, Interface, Procedure. Developed OBIEE RPD, worked on data level and object level securities. Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source server to a data warehouse on a target server and then preparing the information for downstream uses. Worked closely with solution architect and involved in Data Modeling. Involved in creating load plan and scenario and scheduling. Created control and outbound framework for Ladbroke project for high deliverable. Involved in end to end BI project development. Involved in creating OBIEE subject area and added new dimension and fact table. Developed Interface, joining and SCD implementation. Subproject 1.1: Dotmailer Description: Dotmailer is third party Company which provide the campaigning information about the customer who registered for Ladbrokes. Dotmailer need the outbound file from Ladbrokes which contains customer information with various attributes like, email, deposit information, registration information etc. Responsibilities: Created ODI procedure and Packages to provide outbound file to Dotmailer Company.
Developed various report on customer complaint, customer campaigning in OBIEE. Developed Quarterly, Weekly and Monthly report and Dashboard and scheduled through Agent. Worked on customer facing environment and delivered project on time. Worked on Financial report on BI Apps and created month end report. PROJECT DETAILS 3 Project 1: Selfridges UK Role: Technical Analyst Duration: June 2012- Aug2014 Technology: OBIEE 11g, ODI 11g, Essbase Description SHELFRIDGE is one of the world largest retailer company. Selfridge hasexpressed a requirement to replace a 300mb Excel document which provides the platformfor weekly Selfridges group reporting. This current reporting system is referred to as The Yellow Book SHEL is a relatively new entity that provides best practice and governance to the four trading companies within the group: Selfridges & Co (SL) in the UK Holt Renfrew (HR) in Canada De Bijenkorf (DB) in the Netherlands Brown Thomas (BT) in Ireland. This project implemented with a methodology to load many files into Oracle Database using oracle data integrator, achieving faster file uploads to the database with parallel execution and decreasing operational maintenance costs in the process Shelfridge using ODI 11g for ETL and Essbase for multidimensional cube and OBIEE for reporting. It is comprehensive solution to meet the high quality of data ware housing and reporting Roles and Responsibilities: Set up the Topology including physical architecture, logical architecture and context. Created new models for the data sources flat files, MS SQL server, Oracle. Did reverse engineering for the data sources and targets. Worked in ODI and APEX integration to give front end access to update and insert data to end user. Worked in OBIEE and APEX integration to support end user comments to the system. Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings. Created application understanding document on ODI and presented to team.
Coordinated with the offshore UK team. Helped them to define the source view for selfridge accounting system and in resolving the data issue. Developed interfaces and mappings to load the data from flat files to Oracle database. Created ODI packages, scenarios using interfaces, variables, procedure. Implemented logic to archive the source files with date stamp affixed after the successful load. Created Agents and job scheduling in OBIEE. Optimized the knowledge modules to improve the functionality of the process. Working on OBIEE answers to create the reports as per the client requirements. Developed many reports / Dashboards with different Analytics views(Drill down/Dynamic, Cascading style sheets, pivot tables, chart, column selector, tabular with global and local filters) using OBI analytics web. Implemented securities by creating roles & web groups, checks with external tables. Modified some of the existing CEMLI report and dashboard and fixing some of the issue related to performance. Designed and developed the Master Repository (.rpd) using OBIEE admin tool. Worked closely with users, Developers and Administrators to resolve ongoing production issues by reviewing design changes made to production system and made corresponding changes to OBIEE analytics Repository. Responsible for ODI data load and data validation in reporting. Creating complex report and dashboard and adding them to Briefing book. Checking file in SFTP location and responsible for load process end to end flow. Monitoring the ODI load process and resolving the data issue. Working on Service request raised by client using My oracle support tool. Delivered the assignments before the deadlines. Conducted code reviews and planned the knowledge transfer to client. Subproject 2.1: Brown Thomas (Financial and Supply chain report) Description: Brown Thomas is a departmental store of Selfridge group in Ireland. However BT needs their Financial and supply chain reports for their internal business requirement. Responsibilities: Developed RPD and created various dimension and facts for BT entity. Developed various reports and Dashboard for comparison of the profit over quarter, last year , week wise. Created ODI objects Interface to load multiple file to one single table. Involved in CEMLI enhancement request for existing Financial and Purchasing reports in OBIEE answers. Worked on different issue raised by customer on data validation error, report mismatch and slowness of reports. Project 4: Vale Brazil Role: Technical Analyst(BI-ODI Developer) Duration: May 2011- June 2012 Technology: ODI 11g, OBIEE 11g, EBS 11i Description Vale is a diversified mining multinational corporation and one of the largest logistics operators in Brazil.In addition to being the second-largest mining company in the world, Vale is also the
largest producer of iron ore, pellets, and second largest of nickel. Vale also produces manganese, ferroalloys, copper, bauxite, potash, kaolin, alumina and aluminum. Vale, besides being present in 16 Brazilian states is also present in 6 continents: South America, North America, Europe, Africa, Asia and Oceania. Oracle as a support and solution provider on Oracle EBS Applications 11i has spread its support across various applications and CEMLI customizations. Vale has one of the most complicated business requirements/processes which are supported by various CEMLI components. Vale is using ODI 11g for its data warehouse requirements. In this project OLTP data need to move to OLAP through ODI11g. Roles and Responsibilities: Much Involved in Source System and Target System. Involved in solving technical issue on order management and purchasing module raised by client. Involved in Upgrade project of Oracle EBS version 11.5.9 to 11.5.10. Developed web based application on oracle Apex. Working with Application Developer & System Administrator Responsibilities in oracle apps 11i Performed hands-on activities related to all Concurrent Processing and Programming, System Administration, Flex Field, Value Sets etc. Created various SM and worked on various functional and technical setups Involved in Post GO-Live support activity of R12 project Sony and Sprint. Involved in creating the mapping between source and target using oracle Data Integrator. Developed parallel jobs with collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join etc. Created ODI Interfaces for transforming Source data into Target data format. Involved in Functional testing of Oracle Apps using OATS, QTP and Load runner. Created and tested ODI packages and Scenarios for Unit and Integration process. Loading data from Production to development to generate test data. Involved in Unit Testing and Test plan preparation to meet proper testing activity. EDUCATIONAL QUALIFICATION Degree/Course Board/Institute/University Year Percentage B.TECH.(Computer Science) Dr.MGR Educational & Research Institute, Chennai 2007-2011 7.9 CGPA Intermediate CBSE 2007 63 Matriculation CBSE 2005 74 TRAINING AND CERTIFICATION UNDERGONE OBIA Implementation using ODI from Oracle University Live virtual class.
OBIEE Repository development from Oracle University. OBIEE 11g Dashboard and Analysis from Oracle University. Oracle APEX training from Oracle University. ODI 11g Development from Oracle University. ODI 12C implementation Live virtual class from Oracle University. Introduction and complete course on SQL and PL/SQL. 24 Days Training from Bharat Sanchar Nigam Limited (BSNL), PATNA Introduction to Procure to pay Functional and Technical Overview of 11i. ACHIVEMENTS Manager choice Award 2016 for Put client first by IBM . PACESETTER AWARD winner from oracle cloud services. Recognized by Oracle cloud service for significant contribution towards OMS Initiative Know your Customer Developed SOP (Standard operating procedure) Web based Application portal and Incident Management Tracker portal using Oracle Apex Application. An active member of TECHASTRA-a national level Tech Fest atDr.MGR University Selected as Best Table Topic Speaker ORATORS at Toast Master International. Educational Project Undertaken PROJECT: TITLE : virtual network computing (controlling & monitoring) DESCRIPTION :To control and monitor other system connected in LAN using VNC software. It uses RFB protocol (remote frame buffer). Monitoring: screen capture, system details, task manager, file browser. Controlling: shutdown, restart, and logoff, locking unlocking client system, clear track, alert message. Using .NET platform Based on CLIENT & SERVER PERSONAL DETAILS Fathers Name Mr. Suresh Singh Mothers Name Mrs. Bibha Singh Date of Birth 08thOct, 1990 Gender Male Nationality Indian Languages Known English, Hindi Marital Status Single Strengths Believe in myself, Punctual and have Steadfast approach towards achieving
goal. Permanent Address Current Address Bibha Singh Building, Vill: Murligunj, ward no.6 Dist: Madhepura, Bihar House No.11,Thimmarayaswamy Nilaya, 29th cross, Abbaiah Reddy Layout, J.P Nagar,6th phase, Bangalore-560078 Date: Sep 2016 Place: Bangalore (Balwant Singh)

More Related Content

BALWANT SINGH_RESUME

  • 1. BALWANT SINGH +91-9686525462 chotu0190@gmail.com BALWANT SINGH Senior Package Solution Consultant Passport Number-M6430156 CAREER OBJECTIVE To be a part of an organization where process of learning never ends and at every step which provides an ample of opportunities to prove my worth .A place where initiative hard work and learning through constructive criticism is always promoted. Professional Summary: Having 5+ years of experience in ETL, Data warehousing and reporting solution. Strong knowledge on Data Warehouse and Oracle Data Integrator 11g. Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support. Well acquainted Knowledge of SQL, PL/SQL and Oracle APEX. Have implemented ODI mappings from Informatica code. Good Experience of source control systems SVN for maintaining the version. Knowledge of JIRA to update and log the task Good knowledge on OBIEE agents, ibots, KPI and security. Having good understanding on BI Apps and involved in SSO integration between Apps and BI user. Worked on OBIEE integration with MS office and smart view with Essbase. Extensive knowledge in developing business model mapping and deploying the repository in production. Extensive experience in designing of Package, Scenario, Interface, Procedures in ODI Expertise with all ODI tools - Topology, Security Manager, Designer and Operator. Designed Physical Schemas, Data Servers and Agents using Topology Manager. Good knowledge on developing RPD and designing business model for OBIEE reporting. Experienced in designing complex models with multiple facts using LTS, complex calculations with proper aggregates content definition. Experience in Designing level based/value based/parent child hierarchies, level based and time series based calculations.
  • 2. Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI. Worked with multiple sources such as Relational database, Flat files for Extraction Transforming and Loading data into target tables. Involved in model creation which holds the data at ODI Designer level. Extensively worked in designing and monitoring ODI packages, Interfaces, Scenarios, sessions and procedures. Good knowledge in designing star schema and snowflake schema. Experienced in creating managing session/repository and presentation variables. 2 Year of extensive experience in Oracle Apps 11i and R12. Worked on Order management module in Oracle apps and resolved functional and technical issue. Having 6 month of experience in functional testing of Oracle apps all module using QTP, Load runner and OATS tool. Sound knowledge on KMs (Knowledge module) of ODI 11g. Hands on experience in creating standalone agent and J2EE agent. Having good knowledge on Unix and worked on SFTP server. Proficient in handling oracle Procedures, Functions and Packages and strong knowledge of SQL. Having knowledge on APEX. Developed Database and web based Application using Oracle Application Express(APEX) 4.2. . Possess good interpersonal, presentation and developmental skills with Strong analytical and problem solving approach and an excellent team player Technical Proficiency: Reporting tools & ETL tools: ODI 11g, OBIEE 11g, Essbase Database : Oracle 9i, 10G,11g Languages : SQL, PL/SQL.Unix Tools : OBIEE, ODI, TOAD, APEX, JIRA,SVN Operating Systems : Windows NT /2000 Server/XP and UNIX. PROFESONAL EXPERIENCE Current company IBM India 30 Sep 2015- Till date Previous Company Aditi Technologies 9 Sep 2014- 24 Sep 2015 Previous company Oracle India Pvt Ltd 26 May 2011-08-Sep 2014
  • 3. PROJECT DETAILS 1 Project 1: MSI Greenfield Role: Senior Package Solution Consultant Duration: Sep 2015- Till Date Technology: OBIEE 11g, ODI 11g,BIAPPS Description Greenfield project could be one developing a system for a totally new environment, without concern for integrating with other systems, especially not legacy systems. Such projects are deemed higher risk, as they are often for new infrastructure, new customers, and even new owners. For this reason, agile software development is often deemed the best approach, as it proposes how to handle those risks by developing small slices of complete functionality and getting them in the hands of customers (internal or external) quickly for immediate feedback. Roles and Responsibilities: Working on design and development part of all modules of OBIA customizations type 1 and type 2. Worked on migrating the mapping from Informatica to ODI. Worked on Oracle EBS source and complex requirement. Interaction with client and onsite team to gather technical requirement on rice id. Working on ODI code migration from Dev to UAT. Responsible for Data load and load plan generation in BIACM. Working on SDE, SIL and PLP customization in ODI. Working on several defects raised by user on data issue by using HPQC tool. Working on complex lookup transformation, Data set in ODI interface.
  • 4. Worked on implementation of new Dimension and Fact table from design, development to testing. Worked on various report in OBIEE for data validation and development side. PROJECT DETAILS 2 Project 1: Ladbrokes UK Role: Senior Development Engineer Duration: Sep 2014- Till Date Technology: OBIEE 11g, ODI 11g,JIRA Description Ladbrokes is large UK based company for Gaming and Batting Industries. Ladbrokes has EGAMING Digital retail betting 2,500 shops which is operates several online gambling websites offering sports book, poker, casino, games, bingo and backgammon. Ladbrokes uses the Open Bet system from Orbits Technology. Roles and Responsibilities: Worked on various source and target like file to oracle and oracle to file. Developed ODI packages, Interface, Procedure. Developed OBIEE RPD, worked on data level and object level securities. Extract, Load, Transform (ELT) is a data integration process for transferring raw data from a source server to a data warehouse on a target server and then preparing the information for downstream uses. Worked closely with solution architect and involved in Data Modeling. Involved in creating load plan and scenario and scheduling. Created control and outbound framework for Ladbroke project for high deliverable. Involved in end to end BI project development. Involved in creating OBIEE subject area and added new dimension and fact table. Developed Interface, joining and SCD implementation. Subproject 1.1: Dotmailer Description: Dotmailer is third party Company which provide the campaigning information about the customer who registered for Ladbrokes. Dotmailer need the outbound file from Ladbrokes which contains customer information with various attributes like, email, deposit information, registration information etc. Responsibilities: Created ODI procedure and Packages to provide outbound file to Dotmailer Company.
  • 5. Developed various report on customer complaint, customer campaigning in OBIEE. Developed Quarterly, Weekly and Monthly report and Dashboard and scheduled through Agent. Worked on customer facing environment and delivered project on time. Worked on Financial report on BI Apps and created month end report. PROJECT DETAILS 3 Project 1: Selfridges UK Role: Technical Analyst Duration: June 2012- Aug2014 Technology: OBIEE 11g, ODI 11g, Essbase Description SHELFRIDGE is one of the world largest retailer company. Selfridge hasexpressed a requirement to replace a 300mb Excel document which provides the platformfor weekly Selfridges group reporting. This current reporting system is referred to as The Yellow Book SHEL is a relatively new entity that provides best practice and governance to the four trading companies within the group: Selfridges & Co (SL) in the UK Holt Renfrew (HR) in Canada De Bijenkorf (DB) in the Netherlands Brown Thomas (BT) in Ireland. This project implemented with a methodology to load many files into Oracle Database using oracle data integrator, achieving faster file uploads to the database with parallel execution and decreasing operational maintenance costs in the process Shelfridge using ODI 11g for ETL and Essbase for multidimensional cube and OBIEE for reporting. It is comprehensive solution to meet the high quality of data ware housing and reporting Roles and Responsibilities: Set up the Topology including physical architecture, logical architecture and context. Created new models for the data sources flat files, MS SQL server, Oracle. Did reverse engineering for the data sources and targets. Worked in ODI and APEX integration to give front end access to update and insert data to end user. Worked in OBIEE and APEX integration to support end user comments to the system. Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings. Created application understanding document on ODI and presented to team.
  • 6. Coordinated with the offshore UK team. Helped them to define the source view for selfridge accounting system and in resolving the data issue. Developed interfaces and mappings to load the data from flat files to Oracle database. Created ODI packages, scenarios using interfaces, variables, procedure. Implemented logic to archive the source files with date stamp affixed after the successful load. Created Agents and job scheduling in OBIEE. Optimized the knowledge modules to improve the functionality of the process. Working on OBIEE answers to create the reports as per the client requirements. Developed many reports / Dashboards with different Analytics views(Drill down/Dynamic, Cascading style sheets, pivot tables, chart, column selector, tabular with global and local filters) using OBI analytics web. Implemented securities by creating roles & web groups, checks with external tables. Modified some of the existing CEMLI report and dashboard and fixing some of the issue related to performance. Designed and developed the Master Repository (.rpd) using OBIEE admin tool. Worked closely with users, Developers and Administrators to resolve ongoing production issues by reviewing design changes made to production system and made corresponding changes to OBIEE analytics Repository. Responsible for ODI data load and data validation in reporting. Creating complex report and dashboard and adding them to Briefing book. Checking file in SFTP location and responsible for load process end to end flow. Monitoring the ODI load process and resolving the data issue. Working on Service request raised by client using My oracle support tool. Delivered the assignments before the deadlines. Conducted code reviews and planned the knowledge transfer to client. Subproject 2.1: Brown Thomas (Financial and Supply chain report) Description: Brown Thomas is a departmental store of Selfridge group in Ireland. However BT needs their Financial and supply chain reports for their internal business requirement. Responsibilities: Developed RPD and created various dimension and facts for BT entity. Developed various reports and Dashboard for comparison of the profit over quarter, last year , week wise. Created ODI objects Interface to load multiple file to one single table. Involved in CEMLI enhancement request for existing Financial and Purchasing reports in OBIEE answers. Worked on different issue raised by customer on data validation error, report mismatch and slowness of reports. Project 4: Vale Brazil Role: Technical Analyst(BI-ODI Developer) Duration: May 2011- June 2012 Technology: ODI 11g, OBIEE 11g, EBS 11i Description Vale is a diversified mining multinational corporation and one of the largest logistics operators in Brazil.In addition to being the second-largest mining company in the world, Vale is also the
  • 7. largest producer of iron ore, pellets, and second largest of nickel. Vale also produces manganese, ferroalloys, copper, bauxite, potash, kaolin, alumina and aluminum. Vale, besides being present in 16 Brazilian states is also present in 6 continents: South America, North America, Europe, Africa, Asia and Oceania. Oracle as a support and solution provider on Oracle EBS Applications 11i has spread its support across various applications and CEMLI customizations. Vale has one of the most complicated business requirements/processes which are supported by various CEMLI components. Vale is using ODI 11g for its data warehouse requirements. In this project OLTP data need to move to OLAP through ODI11g. Roles and Responsibilities: Much Involved in Source System and Target System. Involved in solving technical issue on order management and purchasing module raised by client. Involved in Upgrade project of Oracle EBS version 11.5.9 to 11.5.10. Developed web based application on oracle Apex. Working with Application Developer & System Administrator Responsibilities in oracle apps 11i Performed hands-on activities related to all Concurrent Processing and Programming, System Administration, Flex Field, Value Sets etc. Created various SM and worked on various functional and technical setups Involved in Post GO-Live support activity of R12 project Sony and Sprint. Involved in creating the mapping between source and target using oracle Data Integrator. Developed parallel jobs with collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join etc. Created ODI Interfaces for transforming Source data into Target data format. Involved in Functional testing of Oracle Apps using OATS, QTP and Load runner. Created and tested ODI packages and Scenarios for Unit and Integration process. Loading data from Production to development to generate test data. Involved in Unit Testing and Test plan preparation to meet proper testing activity. EDUCATIONAL QUALIFICATION Degree/Course Board/Institute/University Year Percentage B.TECH.(Computer Science) Dr.MGR Educational & Research Institute, Chennai 2007-2011 7.9 CGPA Intermediate CBSE 2007 63 Matriculation CBSE 2005 74 TRAINING AND CERTIFICATION UNDERGONE OBIA Implementation using ODI from Oracle University Live virtual class.
  • 8. OBIEE Repository development from Oracle University. OBIEE 11g Dashboard and Analysis from Oracle University. Oracle APEX training from Oracle University. ODI 11g Development from Oracle University. ODI 12C implementation Live virtual class from Oracle University. Introduction and complete course on SQL and PL/SQL. 24 Days Training from Bharat Sanchar Nigam Limited (BSNL), PATNA Introduction to Procure to pay Functional and Technical Overview of 11i. ACHIVEMENTS Manager choice Award 2016 for Put client first by IBM . PACESETTER AWARD winner from oracle cloud services. Recognized by Oracle cloud service for significant contribution towards OMS Initiative Know your Customer Developed SOP (Standard operating procedure) Web based Application portal and Incident Management Tracker portal using Oracle Apex Application. An active member of TECHASTRA-a national level Tech Fest atDr.MGR University Selected as Best Table Topic Speaker ORATORS at Toast Master International. Educational Project Undertaken PROJECT: TITLE : virtual network computing (controlling & monitoring) DESCRIPTION :To control and monitor other system connected in LAN using VNC software. It uses RFB protocol (remote frame buffer). Monitoring: screen capture, system details, task manager, file browser. Controlling: shutdown, restart, and logoff, locking unlocking client system, clear track, alert message. Using .NET platform Based on CLIENT & SERVER PERSONAL DETAILS Fathers Name Mr. Suresh Singh Mothers Name Mrs. Bibha Singh Date of Birth 08thOct, 1990 Gender Male Nationality Indian Languages Known English, Hindi Marital Status Single Strengths Believe in myself, Punctual and have Steadfast approach towards achieving
  • 9. goal. Permanent Address Current Address Bibha Singh Building, Vill: Murligunj, ward no.6 Dist: Madhepura, Bihar House No.11,Thimmarayaswamy Nilaya, 29th cross, Abbaiah Reddy Layout, J.P Nagar,6th phase, Bangalore-560078 Date: Sep 2016 Place: Bangalore (Balwant Singh)