SUMMARY:

• Around 5+ years of experience, worked on local and international projects across Manufacturing, Banking/Finance, and Transportation Sectors with complete SDLC process in both iterative and agile models.
• Experience of data warehouse architecture, data modeling, data transformations, data profiling, dashboards and reports, using Kimball methodology including analysis, design, development, configuration, Customization, validation and deployment with documentation.
• Experience in converting business requirements into process flows, diagrams and data flow diagrams for better understanding and communication with the stakeholders.
• Design, develop, implement, troubleshoot, optimize, and tune ETL/BI processes and define coding standards.
• Experience in using ETL tools i.e. Informatica PowerCenter, Microsoft BI Stack (SSIS, SSAS, SSRS) and Oracle ODI 11g.
• Proficient in the Integration of various source systems like Oracle, SQL Server, Teradata, DB2, Flat Files, XML.
• Hands - on expertise on configuration of Oracle Business Intelligence Applications for EBS E-Business Suite.
• Experience in handling huge databases DBA tasks, DDL/DML SQL Queries, and OLAP queries (DAX & MDX), Performance tuning and optimization achievedSQLscripts.
• Data visualization experience using OBIEE 11g and Power BI Provide Ad-hoc analysis, reporting, and presentation materials to support the decision making of executives.
• Experience in UNIX Shell Scripting for automation batch and ETL jobs.
• Can-do attitude with proven record of multiple successful project executions and deliveries.
• Lead teams, demonstrated analytical and problem-solving skills, contributed to team effort, strong communication skills, excellent planning and organizational skills.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Integration Consultant

Responsibilities:

• Lead overall data integration strategy (sources, staging, data and process flows, business rules and transformations, and targets) for their in-house Data warehouse with team members from scratch using various source systems and automate tasks using PMCMD commands.
• Build interactive dashboards and BI reports for Finance, Sales and Operations departments.

Technical Environment: Informatica PowerCenter, SSIS, OBIEE 11g, Power BI (DAX), Visio, DAC, Oracle SQL, Ms SQL, Linux, Python, Google Big Query

Confidential

BI/ETL Technical Consultant

Responsibilities:

• Liaised with Core Banking Application Team and business analysts for DWH/BI solutions.
• Designed and customized data models for Data warehouse supporting data from multiple sources and perform data pre-processing and incorporated custom development by configured Oracle BIAPPS 11.1.1.9.2 .
• Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as DB2, Flat Files, XML.
• Designed the management reports and financial reports for decision making.

Technical Environment: Informatica PowerCenter, SSIS, SSAS, Oracle ODI, OBIEE 11g, Power BI, Oracle BI Apps 11.1.1.9.2 , Visio, Erwin, DAC, Oracle SQL, Ms SQL, Linux scripts, AWS environment, Oracle Fusion Cloud, Oracle EBS

Confidential

BI/ETL Technical Consultant

Responsibilities:

• As the Onshore Team Member, Developer data warehouse models and data mappings customization of OBIA-HR, Developed custom ETL objects/scripts to extract and cleanse data from source system and also created the tasks in DAC for the particular mappings.
• Develop workflows that could be used for carrying out the ETL jobs efficiently.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Excel) to SQL Server database.
• Designed the management reports and financial reports.
• Worked on Power BI Desktop files and Excel workbooks with data models
• As the Onshore Team Member, Involved in Data Modeling and upgraded Confidential (UK) custom model to extract and cleanse data from multiple disparate source databases DB2, XML, Excel, flat files.
• Created new mappings and workflows for Repository Redesign in which one aggregate fact holds the major information of sales and lots, as well as, the Bidders and Registrants information using Informatica.
• Created new Stars and aggregated fact, through which Client was able to do effective reporting of different sales and campaigns, Configuring DAC by Building different Client Requirement Based Execution Plans.
• Wrote LINUX shell Scripts for FTP files from remote server and backup of repository and folder.
• Designed data models for core banking symbol data source.
• Liaised with the Core Banking Application team and business analysts
• Designed and developed new ETL mappings and workflows to extract data from the OLTP and populate Star Schemas into Data Warehouse System using Informatica
• Involved in Configuration of Administration Tool (Repository), Web development (Dashboards and Reports), migrations and Security using OBIEE 11g.

Technical Environment: Informatica PowerCenter, OBIEE 11g, Oracle BI Apps 7.9.6.4, Visio, DAC, Oracle SQL, Ms SQL, Linux

Confidential

Junior BI Consultant

Responsibilities:

• Worked as a BI/ETL developer with a Senior resource, created the mappings and workflows in Informatica also created tasks in DAC for newly created mappings and add it up to the existing execution plan
• Providing Day to Day Support on implemented Solution.
• Designed the management reports and financial reports using Power BI.

Technical Environment: Informatica PowerCenter, OBIEE 11g, Power BI, Oracle BI Apps 7.9.6.4, Visio, DAC, Oracle SQL, Ms SQL, Linux

Confidential

Software Developer Trainee

Responsibilities:

• As a trainee, understand the Data warehouse principle through Kimball Methodologies worked on analysis of Source, existing OLTP system and identification of required dimensions and facts from the Database.
• Gained knowledge on ETL methodology of data extraction, transformation and loading of data into data warehouse and adding BI reporting

Technical Environment: Informatica PowerCenter, OBIEE 11g, SSIS, Power BI, Visio, DAC, Oracle SQL, Ms SQL