SUMMARY

• Extensive experience in extraction, transformation, and loading (ETL) data from various sources into Datamart/ Datawarehouse using Informatica and Microsoft SSIS.
• 14 plus years of IT experience in Database design, development, and implementation in the field of Data Warehouse (OLAP), online transaction processing applications (OLTP), decision supporting systems (DSS).
• Responsible handling end to end data warehousing application in Informatica for the Extraction Transformation and Loading (ETL)and OBIEE Hyperion Reporting Studio for business intelligence reports in Development, UAT, Productions environments.
• Extensive SQL, PLSQL programming experience working on business applications, data migrations, custom Interfaces across various applications.
• Strong experience in Informatica Administration. Installations and configurations of Informatica server, repository maintenance, performing various upgrades and migration of the repositories across Informatica 7.1 to 8.1, 8.6.1, 9.1,9.6.1.
• Hands on experience identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, transformation, and sessions.
• Strong experience as Oracle Business Intelligence Hyperion Interactive Reporting Administrator (OBIEE) installation, migration, and maintenance. Designed and developed large number of Reports in OLAP environments using OBIEE Hyperion IR studio and worked on multiple reporting tools for several clients.
• Experience in ER tools like ERWIN, Oracle Modeler, worked extensively designing data models in both OLAP and OLTP. Worked on advance features in Erwin, writing custom functions in the objects comparison process, forward and backward engineering from Oracle and Sql server, maintaining domains effectively, worked on Conversion of data models across the tools from Erwin to Oracle modeler.
• Experience working with Visual Studio Team Foundation Server (TFS) and SharePoint.
• Conducted meetings and interacted with system experts, business, functional, technical and application users as part of business analysis, requirements gathering, development, testing, releases, and production support. Conducted several training sessions for business and other functional users.

TECHNICAL SKILLS

Operating System: Windows 2019/ 2010/2008/2003/98 , Unix, Linux, Windows CE.

Languages: SQL, PL/SQL, TSQL, C, C++, Vc++, Python, Java

Databases: Oracle 11gR2, 10g/9i / 8.x / 7.x, SQL Server, Postgres

Oracle Tools: SQL *Plus, SQL* Loader, Toad, PL/SQL Developer

Modelling Tools: Erwin Data Modeler 4.1.4, 7.1.1, Oracle data modeler.

ETL Tools: Informatica (PowerCenter 10, 9.6.1/9.1/8.6.1/8.1 ,7.1), SQL Server Integration Services (SSIS) 2005/2008/2017/2019 , SQL Server Reporting Services (SSRS) 2008/2017, SAP BI, SAP CPI DS

BI Tools: OBIEE Hyperion Interactive Reporting 11.1.2.2, 9.x, Business Objects, Power BI

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Principal Consultant

Responsibilities:

• Actively Involved in project kickoff and requirements gathering sessions along with the business leaders.
• Analyzed the business requirement specs and actively involved in the Internal Review meetings and Walkthroughs.
• Worked on the design documents for various sites.
• Worked with the regional data managers to understand the Business rules and developed mapping documents.
• Coordinated with site specific demand data specialists in streamlining the source data scheduling process.
• Wrote complex SQL queries to pull the data from Multiple sources and applied various filters rules and extensively worked SQL scripts for performing Data validations and report validations in Oracle, SQL Server.
• Worked with multiple text and .csv files to load the data into the staging tables.
• Designed and developed ETL mappings to read data coming from various ERP Sources like Oracle, SAP, Avante, BAAN etc apply the transformation logic according to the business rules using Microsoft SSIS ETL tool and write into the SQL Server target database.
• Created and customized error logging to gather all the required information and store in the log tables for error handling and easier troubleshooting.
• Worked on the unit testing and performed several group validations with testing team and regional business users to make sure the business rules are passed.
• Worked on end to end package deployment in the Production environment and automized the process by scheduling weekly workflows and setting up email notifications.
• Troubleshooting various issues in the production environment.
• Used TFS as version control on daily basis and for error tracking. Used SharePoint for source documents.

Environment: Windows Server 2019, SQL Server 2019, SSMS, SSIS 2019, Microsoft Visual Studio 2019, Oracle 11.2, SQL developer, TFS, SharePoint.

Confidential

Senior consultant

Responsibilities:

• Participated in the Project Kickoff meetings with various stakeholders.
• Created technical documents, mapping documents, end user documentation.
• Worked on Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions, and measured facts.
• Worked on Informatica Power Center tools - Designer, Workflow Manager, and Workflow Monitor.
• Used various transformations like Filter, Expression, Sequence Generator, Joiner, Stored Procedure, look up, and Union to develop mappings and mapplets in the Informatica Designer.
• Create framework for atomizing the creation of CRUD packages, TRIGGERS, and VIEWS.
• Debugging and troubleshooting Hyperion reports, Informatica mapping and workflows.
• Extensively worked on SQL and PLSQL for data migrations, data conversions, customizing interfaces across applications.
• Created various migration scripts to populate data across different systems. Written data conversion programs and worked on API interfaces for multiple clients.
• Worked on critical business enhancements, by gathering requirements, coordinating with the functional team members, and coding the business rules into Oracle Packages, Triggers, Function, Procedures.
• Created enterprise data model and worked on migrating the enterprise data models from Erwin to Oracle modeler.
• Performed various upgrades in the data warehouse applications, database upgrades, Informatica and Hyperion BI tool upgrades.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for backup of repository.
• Involved in Performance tuning at source, target, mappings, transformations, sessions, and system levels.
• Worked on end to end P2land BI reporting solutions using OBIEE Hyperion Reporting.
• Designed and Developed large number of reports in OLAP environments using OBIEE Hyperion IR studio and worked on multiple Reporting Tools for several clients.

Environment: Windows 2010 Pro, Oracle 11gR2, Toad 8.5.3, PL/SQL Developer, Erwin 4.4.1, Microsoft Visual Studio, OBIEE Oracle Hyperion reporting 11g, Informatica 9.1

Confidential, Houston, TX

Senior software engineer

Responsibilities:

• Sole responsible leading the data warehouse design enhancements, development, implementation and maintenance of development, test, and production environments.
• Organized meetings and interacted with various Business users, functional, technical teams, and system experts as part of Business analysis, requirements gathering, development, testing and final releases.
• Worked in different roles from designing the data models, configuring the data warehouse environments, administrating the data warehouse repositories, creating the ETL mappings, releasing the product to the end users, supporting various clients during the installation and post installation issues and other product related questions.
• Performed various upgrades in the data warehouse applications, database upgrades, Informatica and Hyperion BI tool upgrades.
• Created technical documents, mapping documents, end user documentation.
• Worked on Informatica Power Center tools- Designer, Workflow Manager, and Workflow Monitor.
• Worked on Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions, and measured facts.
• Used various transformations like Filter, Expression, Sequence Generator, Joiner, Stored Procedure, look up, and Union to develop mappings and mapplets in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, transformations, sessions, and system levels.
• Designed and Developed large number of reports in OLAP environments using OBIEE Hyperion IR studio and worked on multiple Reporting Tools for several clients.

Environment: Windows 2008 Pro, Oracle 11gR2, Toad 8.5.3, PL/SQL Developer, Erwin 4.4.1, Microsoft Visual Studio, OBIEE Oracle Hyperion reporting 11g, Informatica 9.1

Confidential, Houston, TX

Senior Software Engineer.

Responsibilities:

• Worked with functional and business users in requirements gathering and design phases. Converted Business requirements into Database Technical design by creating data models in Erwin, creating database objects in the database, Oracle PL/SQL packages, procedures, functions, and triggers to capture the business functionality. Involved in end to end application testing.
• Designed and developed complex solutions for creating and generating the Checks and Invoices module, Acreages, Organizations, Leases, Contracts for Tel land management systems and interfacing to the external applications.
• Created several technical documents to capture the functionality and process flow.
• Worked on SAP BI application interface process with P2land application.
• Worked and presented Proof of concept to Migrate the applications on Oracle to Postgres SQL.
• Worked on P2Land Enterprise Data warehouse. Involved in end to end data warehouse project phases including Administration, development, testing, release, and support.

Environment: Windows 2003 Pro, Informatica 8.1, Oracle 10g, Toad 8.5.3, PL/SQL Developer, Erwin 4.4.1, OBIEE Oracle Hyperion reporting 9, Microsoft Visual Studio

Confidential, Houston, TX

Software Engineer

Responsibilities:

• Convert Business requirements into Database Technical design.
• Extensively worked on Oracle PL/SQL packages, procedures, functions, and triggers.
• Create framework for atomizing the creation of CRUD packages, TRIGGERS, and VIEWS.
• Writing and maintaining various migration scripts used to populated data from old system to the new system.
• Designed tables and view depending upon the business requirements in the process flow.
• Working and maintaining the Enterprise land data models in Erwin data modeler.
• Tuning and monitoring database (database applications tuning, which included testing the application and suggesting changes in code to improve performance)

Environment: Windows 2000 Pro, Oracle 10g, Toad 8.5.3, PL/SQL Developer, Erwin 4.1, Microsoft Visual Studio. 8.0.5

Confidential, Milpitas, CA

System Analyst

Responsibilities:

• Responsible for planning and coordinating design, development and implementation of the complex software systems and applications to meet the project needs.
• Extensively worked on Informatica installation and Setting up repositories. Worked on Informatica client tools PowerCenter Designer, Workflow Manager, Repository Manager, and Workflow Monitor to design, develop, and maintain complex ETL Mappings, Mapplets, Worklets, and Workflows.
• Developed and maintaining the Oracle data models in Erwin data modeler.
• Responsible for outlining the various steps in the development process.
• Gathering various business requirements and writing oracle packages, stored procedures,functions,triggeres etc.
• Created Database objects like tables, views, indexes, Program units (procedures, functions, packages)
• Responsible for the migrations project, written scripts used to populate data from old system to the new system.
• Involved in database refreshes and other DBA activities.

Environment: Informatica Power Center 7.1/6.x, Erwin 4.0, Business Objects 6.1, Oracle 9i, PL/SQLSQL Plus, Windows 2000.

Confidential

Student Worker

Responsibilities:

• Worked solely on the complete analysis, design, development, and implementation of a GUI application on a Pocket PC 2002.
• Developed a GUI interface in CANoe by programming the CAN messages and signals from the database to simulate the different functionalities of door control units of car.
• Involved in testing various functionalities of PQ35 door control units by using ADS software on a test rig.
• Worked with CANister Configurator as a development interface that enables you to freely configure CANister. CANister is hardware used to program the control unit. It is for controlling, testing electronic control units in production and in development.
• Worked and implemented protocols such as “Keyword 2000 protocol and Transport protocol “for communication and data transfer with ECU.
• Developed an application on Pocket PC 2002, which is used for Uploading and Downloading of data files into door control units of a car. This involves in working with hardware called CANcardXL which is used as an interface between the Pocket PC and ECU. It mainly deals with developing Protocols. The data present in the protocols must be coded into the format of CAN messages and the communication is established with the ECU.

Environment: Microsoft Embedded Visual C++, Windows CEHardware Device: Pocket PC