SUMMARY

• 7+ years of extensive experience mainly in Design, Development and Implementation of complex Business Applications.
• Thorough knowledge in concepts of data warehousing, data marts, ETL processes, data mining, multi - dimensional modeling, warehouse design and architecture.
• Experienced in Informatica power center.
• Experienced with Informatica IDQ - Created various expression rules, profiles, score cards for data validation and implemented the same in Power center mappings.
• Experience with Analytical tool - SSAS and MDX querying.
• Trained on OLAP tools and concepts - OLAP schemas, drill down, slicing and dicing, implementation techniques like ROLAP, MOLAP, and HOLAP.
• Trained on reporting tool - Hyperion Brio.
• Trained on Oracle Warehouse Designer (OWB).
• Experienced in Oracle and SQL/PLSQL
• Experienced in IBM DB2 - Developed complex stored procedures, data base transactions, triggers, different type of joins, sequences and DB2 functions.
• Experienced with columnar data bases like Vertica and SAP HANA.
• Experienced with Databases like Teradata and Green Plum.
• Trained on Netezza and Postgres.
• Thorough knowledge on DBMS concepts-database models, RDBMS, abstraction, database architectures, constraints, relational algebra and operations, normalization and normal forms.

TECHNICAL SKILLS

Operating systems: Windows XP/NT/2000, DOS, UNIX, Linux.

Scripting: Shell scripting, HTML, JavaScript and VBScript.

Data Bases: ORACLE, IBM DB2, Vertica, SAP HANA, Netezza,Teradata, GreenPlum, Microsoft Access,SQL server.

ETL Tools: Informatica PowerCenter, Informatica IDQ,Oracle Warehouse Designer (OWB), Hyperion Brio.

Analytical Tools: SSAS

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Informatica Developer

Responsibilities:

• Working as business analyst and primary contact point for development POCs in ETL.
• Involved in development of ETL jobs using informatica.
• Involved in ETL code migration from Oracle to Vertica database and took part in performance tuning of ETL so as to utilize performance features of columnar data base - Vertica.
• Involved in developing the test cases for the data warehousing environment.

Environment: Informatica 9.5, Oracle, Vertica, SSAS.

Confidential, Menomonee Falls, WI

Informatica Lead

Responsibilities:

• Presently leading the team and has involved generating various reports for clients and vertical managers.
• Involved in monitoring ETL jobs and supporting EDW to ensure the SLAs are met for them.
• Involved in Resolving L2 issues (Bugs).
• Involved in developing the test cases for the data warehousing environment.

Environment: Informatica 8.x, IBM DB2, Teradata

Confidential, New Brunswick, NJ

Informatica Lead

Responsibilities:

• Involved in Requirement analysis and high level and low level Design and Development. This involves the designing of the workflow as well as the column level transformations.
• Involved in database development in DB2 environment (stored procedure, functions, and triggers).
• Involved in Development of complex ETL (Informatica) jobs and PLSQL procedures.
• Created various expression rules, profiles, score cards for data validation using informatica IDQ to implement same in Power center mappings.
• Involved in developing the test cases for the data warehousing environment (system test cases and unit test cases).

Environment: Informatica 8.x, Oracle.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Involved in Development and enhancement of complex ETL (Informatica) jobs and GreenPlum stored procedures.
• Involved in job scheduling using Opswise automation center.
• Involved in configuration management (using VSS).
• Involved in Resolving L2 issues (Bugs).
• Involved in developing the test cases for the data warehousing environment

Environment: Informatica 8.x, Oracle, GreenPlum

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Involved in end - to-end life-cycle of DATA MART development (ETL).
• Involved in Requirement analysis and high level and low level Design and Development. This involves the designing of the workflow as well as the column level transformations.
• Involved in database development in DB2 environment (stored procedure, functions, and triggers).
• Involved in developing the test cases for the data warehousing environment (system test cases and unit test cases).
• Involved in configuration management (using Share point).

Environment: Informatica 8.x,IBM DB2

Confidential, Boston, MA

Responsibilities:

• Analyzing production related issue and gathering requirements from the customer.
• Involved in developing data reports for various client requests using sql queries.
• Involved in testing and developed test cases for various enhancements in database using Oracle apps and PL /SQL.

Environment: Oracle SQL/PLSQL, OracleApps HRS, Xtrac Manager

Confidential

Informatica Design/Development/Support

Responsibilities:

• Involved in end - to-end life-cycle of DATA MART development (ETL).
• Involved in Requirement analysis and high level and low level Design and Development. This involves the designing of the workflow as well as the column level transformations.
• Involved in database development in DB2 environment (stored procedure, functions, and triggers).
• Involved in the POC (proof of concepts) development for the different solution validation.
• Involved in developing the test cases for the data warehousing environment (system test cases and unit test cases).
• Involved in configuration management (using VSS)

Environment: IBM DB2, SQL, Informatica

Confidential

Design/Development/Support(Academic)

Responsibilities:

• Involved in end - to-end life-cycle of product development.
• Involved in Requirement analysis and high level and low level Design and Development.
• Involved in implementation of gateway systems for GSM modules and automated SMS services.
• Developed python scripts to parse GSM service provider info which include GSM location (tower) information and signal strength.

Environment: Java, Python, SQL Server