SUMMARY

• Ten plus (10+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial, Insurance, Supply Chain Management (SCM) and Real Estate Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2005/2000.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Strong Data Warehousing ETL experience of using Informatica 9.x/8.x PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using ERwin.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger) Power Connect as ETL tool on Oracle and SQL Server Databases.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for data warehouse to develop the code, Unit Testing and Documenting.
• Hands-on experience in working with UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Extensive use of Subversion, PVCS for managing the assets of the software project and release management.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows 2008/2007/2005/ NT/XP

ETL Tools: Informatica Power Center 9.x/8.x (Designer, Workflow Manager, Workflow Monitor Repository manager and Informatica Server)

Databases and Tools: Oracle 11g/10g, MS SQL Server 2005/2000, Toad, Putty.

Data modelling tools: Erwin, MS Visio

OLAP Tools: Business Objects XI, Crystal reports XI

Languages: SQL, PL/SQL, UNIX.

Scheduling Tools: Autosys

Testing Tools: Quality Center

Version Control: Sub Version (SVN), PVCS

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Technical Lead

Responsibilities:

• Management of BI projects for various departments in the company - including finance and technology.
• Analysis, systems design and responsibility over development.
• Business requirements analysis and determining of project scope.
• Interaction with senior management and other workers in IT and user departments.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Environment: Informatica Power Center 9.x/8.x, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 11g/10g, Erwin, Autosys, UNIX, Toad, Putty.

Confidential

ETL Lead/ Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modelling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.x/8.x, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 11g/10g, Erwin, Autosys, UNIX, Toad, Putty.

Confidential

Database Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Technical & Process Level Coordination with Team.
• Development & implementation of Ramco-ERP Inventory & Purchase Business processes.
• Business customizations, techno-functional activities such as Requirement analysis, Impact analysis.
• Created N number of Packages, Triggers, Tables and Views by using Oracle PL/SQL.
• Worked on Collections and Bulk processing, External Tables, Merge Statements, Global Temporary Table(GTT), Ref Cursor, Partitioned Tables and Dynamic SQL, Materialized Views, Table Indexing.
• Involved in many consistency / complex queries to build to find out the financial data mismatch.
• Responsible for leading and mentoring the core team in designing, developing, and implementing the project deliverables.
• Involved in gathering the business requirements/rules, translating the business rules into technical specifications, coordinating with the business during testing.
• Project Estimations, Creating Process flows, Design Walkthroughs, Data Modeling, Source target mapping and Issue Log maintenance, Code Reviews.
• Involved in UAT, Pre Live and Post Live support.
• Tracking of team velocity and provide status reports to Program Management team.

Environment: Oracle 10g, RVW virtual works, SVN and Quality Control.

Confidential

Database Developer

Responsibilities:

• Technical & Process Level Coordination with Team.
• Responsible for leading and mentoring the core team in designing, developing, and implementing deliverables.
• Suggest Business Process Improvements (BPI) and conduct Process Audit.
• Involved in many consistency / complex queries to build to find out the financial data mismatch.
• Created N number of Packages, Triggers, Tables and Views by using Oracle PL/SQL.
• Code review walkthroughs / Detail Design Review walkthroughs with architect.
• Project Plan Preparation and weekly status Report creation.
• Participated in review of project plan with the Project manager to come up with clear cut Tasks and Timelines. Maintenance of Requirements Traceability Matrix, Issue Log.

Environment: Oracle 10g, RVW virtual works, SVN and Quality Control.

Confidential

Analyst Programmer

Responsibilities:

• Technical & Process Level Coordination with Team.
• Ensured deliverable quality.
• Established detailed action plan and achieved major milestones in the project.
• Established clear priorities and tracked activities effectively to meet commitments and schedules consistently.
• Developed N number stored procedures, Tables, views and Triggers for Enhancements.
• Provided technical support/guidance to the team during the design and coding phase.
• Coordinate Unit testing, Quality Assurance and Production deployment of applications.
• Involved in constructing utility packages for common repeatable functionalities.
• Prepared Process Flow Diagrams / Detail Design documents for the Cutover Process.
• Code review walkthroughs / Detail Design Review walkthroughs with architect.

Environment: SQL SERVER 2000/2005, RVW virtual works, SVN and Quality Control.

Confidential

Programmer

Responsibilities:

• Technical & Process Level Coordination with Team.
• MS SQL Server database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Developed Oracle PL/SQL packages for Enhancements.
• Ensured deliverable quality.
• Established detailed action plan and achieved major milestones in the project.
• Established clear priorities and tracked activities effectively to meet commitments and schedules consistently.
• Provided technical support to the team during the design and coding phase.

Environment: Oracle 10g, RVW virtual works, SVN and Quality Control.

Confidential

Programmer

Responsibilities:

• Technical & Process Level Coordination with Team.
• MS SQL Server database Backup and Maintenance Activities, create and modify tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in SDLC process and fine-tuned the queries.
• Ensured deliverable quality.
• Established detailed action plan and achieved major milestones in the project.
• Established clear priorities and tracked activities effectively to meet commitments and schedules consistently.
• Provided technical support to the team during the design and coding phase.

Environment: SQL SERVER 2000, RVW virtual works, SVN and Quality Control.