Highlights

• 5+ years of expertise in all aspects of Business Analytics Applications including analysis, design, development, configuration, Customization, validation, and deployment


• Skilled IT professional with around 4.5+ years of experience in areas of Data Engineering, Business Intelligence, ETL/ELT, Data & Cloud Integrations.


• Designed and implemented end-to-end scalable data pipelining solutions (Ingestion, Orchestration, Storage, Transforming, Processing, and Visualization) using ODI.


• Extensive Experience with Data Ingestion, Data Orchestration, Data Pipelines, Data Migration, ETL/ELT, SQL, RDBMS, Data lakes, Datawarehouse and Datamart.


• Extensive experience with Fact, dimensional tables, slowly changing dimensions


• Extensively used ODI to create Data ware Housing OLAP Model.


• Hands on Experience on Installation and Configuration of 12C.


• Proficiency in Migrating Code into production (Any Environment).


• Validating the User reports using Excel and SharePoint.


• Experience in ODI designer, Topology, Operator and ODI Tools.


• Performance Tuning in Oracle Data Integrator.


• Worked with multiple sources such as Relational database, Flat files for Extraction,


• Transforming and Loading data into target tables.


• Performed unit and integration testing. Created various test scenarios to test the application.


• Optimized the knowledge modules to improve the functionality of the process.


• Participated in business requirement gathering through interactive sessions with Business Teams and DB Architect teams.


• Identified Facts and Dimensions according to the design specifications


• Developed packages, scenarios using interfaces and variables.


• In all phases customizing prebuilt mappings, ELT Designing, Data Validation after load completion,


• As a part of performance tuning using various techniques reduced execution time.


• Hands on experience in Unix commands and worked on PowerShell commands 


• Sound Knowledge on MS- Office Family.


• Adept at working with internal and external teams including offshore teams and coordinating for on-time delivery of solutions and training end users.


• Excellent Presentation, Communication, Interpersonal, Leadership, Decision Making, Influencing, Problem Solving and Motivational Skills.

 

Skills

Primary Skills

ETL

ODI tools

SQL

Secondary Skills

ETL

SQL

Projects

Project-1 - IT Industry (24 months)

ODI Developer and Data Engineer





 






• Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.


• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.


• Used Oracle Data Integrator (ODI )11g/12c for extraction, loading and transformation ETL of data in the data warehouse.


• Gathered Requirements and translated them into a technical solution by creating source to target mappings.


• Developed interfaces to load the data from flat files, oracle to Oracle.


• Did SQL and PL/SQL programming for ODI and oracle.


• Developed Bitmap index and increased the performance of mapping.


• Created ODI packages, scenarios using interfaces, variables, procedure


• Successfully completed the ELT UAT with minor issues and no of iteration to fix the issues are mostly 1


• Performance tuned the ODI interfaces, Delivered the assignments before the deadlines.


• Optimized the knowledge modules to improve the functionality of the process.


• Performed unit and integration testing. Created various test scenarios to test the application.


• Involved in Unit Testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.


• Identify problems, develop ideas and propose solutions within different situations requiring analytical, evaluative or constructive thinking in daily work.


• Involvement with management in terms of supplying input for key design and architecture decisions, as well as work on estimation and resource planning.


• Integrated Custom Visuals based on business requirements using power BI desktop.


• Conducted code reviews and planned the knowledge transfer to client.


• Developing Construction after the design review.


• Involved in optimizing mappings And Monitoring Production system.


• Performed Incremental and Full Refresh load.


• Modifying Source Definition to reflect data warehouse and Worked on HDFS file system.


• Loading data from production to development to Generate Test Data.






 





 





Environment: Oracle Data Integrator 12c, Oracle 12c, SQL Developer,





MS-SQl, Power BI

Project-2 - IT Industry (13 months)

ODI Developer and Power BI Tester





 






• Participated in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications.


• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.


• Set up the Topology including physical architecture, logical architecture and context.


• Created new models for the data sources – flat files, Oracle.


• Worked on ALM and JIRA ticketing tools and run the test cases.


• Gathered Requirements and translated them into a technical solution by creating source to target mappings.


• Developed interfaces to load the data from flat files, oracle to Oracle.


• Scheduled the loads on a daily basis using Control-M and monitored them.


• Did SQL and PL/SQL programming for ODI and oracle.


• Developed Bitmap index and increased the performance of mapping.


• Created ODI packages, scenarios using interfaces, variables, procedure


• Successfully completed the ELT UAT with minor issues and no of iteration to fix the issues are mostly 1


• Performance tuned the ODI interfaces.


• Optimized the knowledge modules to improve the functionality of the process.


• Performed unit and integration testing. Created various test scenarios to test the application.


• Delivered the assignments before the deadlines.


• Worked on power BI dash boards and done unit testing for DEV and UAT.


• Tested complex calculated measures using Data Analysis language (DAX).


• Integrated Custom Visuals based on business requirements using power BI desktop.


• Conducted code reviews and planned the knowledge transfer to client.


• Requirements analysis and preparing Design Document UTC and UTR.


• Developing Construction after the design review.


• Involved in optimizing mappings And Monitoring Production system.


• Performed Incremental, SCD-2 and Full Refresh load.


• Modifying Source Definition to reflect data warehouse.


• Loading data from production to development to Generate Test Data.






 





 





Environment: Oracle Data Integrator 12c, Oracle 12c, SQL Developer,





MS-SQl, Power BI, Control - M





 

Project-3 - IT Industry (36 months)

ODI Developer





 






• Set up the ODI connection with Oracle, SIEBEL and flat files.


• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.


• Set up the Topology including physical architecture, logical architecture and context.


• Created new models for the data sources – flat files, Oracle.


• Did reverse engineering for the data sources and targets.


• Gathered Requirements and translated them into a technical solution by creating source to target mappings.


• Developed interfaces to load the data from flat files, oracle to Oracle.


• Scheduled the loads on a daily basis and monitored them.


• Did SQL and PL/SQL programming for ODI and oracle.


• Developed interfaces for loading the lookup and transactional data.


• Created ODI packages, scenarios using interfaces, variables, procedure


• Used ODI commands like ODIFile_Move, odiFileAppend, odiFilecopyetc


• Successfully completed the ELT UAT with minor issues and no of iteration to fix the issues are mostly 1


• Performance tuned the ODI interfaces.


• Optimized the knowledge modules to improve the functionality of the process.


• Performed unit and integration testing. Created various test scenarios to test the application.


• Delivered the assignments before the deadlines.


• Conducted code reviews and planned the knowledge transfer to client.


• Requirements analysis and preparing Design Document.


• Developing Construction after the design review.


• Involved in optimizing mappings And Monitoring Production system.


• Performed Incremental, and Full Refresh load.


• Modifying Source Definition to reflect data warehouse and Sales data mart.


• Loading data from production to development to Generate Test Data.






 





 





Environment: Oracle Data Integrator 12c/11g, Oracle 12cDAC, SQL Developer, Unix





 

Project-4 - IT Industry (11 months)

• Participated in business requirement gathering through interactive sessions with Business Teams and DB Architect teams.


• Identified Facts and Dimensions according to the design specification.


• Designed and developed interfaces to load the data from multiple sources like


• Relational databases, flat files into oracle database.


• Design, Development, Testing and Implementation of ETL processes using Informatica Power Center.


• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.


• Extensively worked in areas of code debugging and Performance Tuning of Informatica ETL mappings. Identify root cause and implement resolution for production processing issues.


• Developed packages, scenarios using interfaces and variables.


• Good knowledge about Topology, Designer, Operator in Oracle Data Integrator.


• Debugging the master jobs and packages by using operator navigator.


• Implemented SCD Type2 on Dimension tables.


• Good Understanding about ODI Architecture.


• Worked with knowledge modules like LKM, IKM and CKM.


• Good Knowledge about Standalone Agent and J2EE Agent.


• Delivered the assignments before the deadlines.


• Ability to work individually as well as in a team with excellent problem-solving skills.


• Knowledge on data ware housing concepts like schemas and approaches.


• Implemented SCD type1 and SCD type2.


• Have knowledge about Changed Data Capture.


• Performed unit testing at various levels of ELT flows.


• Execute test cases with multiple data sets to attain exact test results and capture faulty






construction.





 





Environment: Informatica Power Center 9.5.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor), ORACLE 10G, TOAD, Windows XP, OBIEE 11G

Project-5 - IT Industry (37 months)

• Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.


• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.


• Gathering requirements from users/business to develop interfaces, procedures, packages, load plans.


• Used Yellow Interfaces in ODI 11g for developing most complex interfaces.


• Built and tested pipelines to implement Change Data Capture for Oracle tables.


• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.


• Involved in creating the design and technical specifications for the ETL process.






 






• Oracle Data Integrator 11g/12c, OAS, SQL Developer, Unix, OBIEE 11g & OBIEE 12C and OAS