SUMMARY

• Extensive experience of 6+ Years in Data Warehousing, Decision support Systems and has wide experience in implementing Data Warehousing solutions for large corporate clients using Informatica Power Center.
• Strong Consulting experience in Implementing Full Life cycle Data Warehousing Projects..
• Developed Strategies for Data conversions, Extraction, Transformation and Loading (ETL) processes.
• Experience in developing complexMapplets, Workletsand re - usable Tasks, re-usable mappings.
• Experience in Performance tuning of sources, mappings, transformations, targets and sessions.
• Proficient in SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g, Microsoft SQL Server 2000/2005, DB2 and MS Access

ETL Tools: Informatica Power Mart/Power Center 9.x/8.x/7.x

Reporting Tools: Business Objects, OBIEE

Operating Systems: Sun Solaris 8, Windows NT/98/95, WIN 2000

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts, HTML

Other Tools/Utilities: TOAD, RapidSQL 7.1, Microssoft Office

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

ETL Developer

Responsibilities:

• Involved in the architectural redesign of the ETL for Wealth compensation application reporting to include the Legacy Wachovia’s Wealth trust and Brokerage transactions to compensate the financial advisors.
• Strong business and analytical skills including direct interaction with business end users for requirements analysis.
• Extensively used Informatica PowerCenter 8.6 to load extract data from Flat Files, Oracle, server, db2 and Teradata databases and load to Oracle, DB2 and Flat Files.
• Developed and maintained metadata content for data warehouse data sources
• Designed/developed, tested and implemented the ETL’s for the short term/long term solution to help support the Legacy Wachovia’s business reporting.
• Extensively used Informatica PowerCenter 8.6 to load extract data from Flat Files, Oracle, server, db2 and Teradata databases and load to Oracle, DB2 and Flat Files.
• Designed and developed shell scripts for loading the data from file transfer and handling.
• Responsible for Designing, Developing and testing all modules involved in the data acquisition process.
• Used Informatica Repository Manager to create new Folders, Users/Privileges and repositories.
• Documenting and deploying new ETL processes into a production environment.
• Worked with various Transformations like Aggregator, Expression, Filter, Source Qualifier, Joiner, Look Up and Stored Procedure, normalizer etc to in corporate the business rules into the mappings.
• The Scheduled and Ran Extraction and Load process and monitored sessions using Informatica Sever Manager.
• Fine-tuned existing Informatica Maps for performance optimization by partitioning the mappings.
• Validated the data in the reports against the databases.
• Developed PL/SQL procedures, packages for GL.

Environment: Informatica PowerCenter 8.6, Toad 9.1, Business Objects 5, Oracle 10g, DB2, SQL*Plus, PL/SQL

Confidential, Albany, NY

ETL Specialist III ETL Developer

Responsibilities:

• Involved in the Design and Development of EDW warehouse environment.
• Involved in full SDLC life cycle right from Planning/Analysis, Design, and Development, Testing, UAT, Implementation and Post Implementation Support activities.
• Used Technical transformation document to Design the Logical and Physical data models using Erwin/ER studio and design the architecture for ETL modules.
• Performed Data Profiling on the source systems to get a sense of the source application data for creating the business rules for the ETL.
• Design multidimensional data warehouse structures such as star schemas etc
• Develop mappings as per the design to meet the business requirements with expertise in SQL, stored procedures, indexes, partitioning, database design and tuning.
• Created Functions, Packages to automate the pull from TP, push to Data Mart, manage indexes, manage keys, Truncate tables, partitions.
• Designed/integrated the Shared Conformed facts and dimensions across all the application/source systems and staging to datamarts.
• Experience developing ETL processes using ETL control tables, error logging, auditing, data quality.
• Guided and helped the DBA, Testing and Software Configuration Management teams during Testing cycle.
• Involved in User Acceptance Testing (UAT) to support the UAT process and answer/clarify any questions raised by business users, test team and functional architects.
• Extensively used Informatica PowerCenter 8.6 to load extract data from Flat Files, Oracle db2 and Sybase databases and load to Oracle, DB2 and Flat Files.
• Used Mapping/sessions parameters and variables to perform the initial and incremental loading of data.
• Performance Tuned mappings and sessions to achieve best possible performance.
• Created Tasks, Worklets and Workflows and scheduled Workflows to run the jobs at required frequency using Workflow Manager.
• Used Informatica Repository Manager to create new Folders, Users, Privileges and repositories.
• Administered PowerCenter Server and resolved any issues when they arise.
• Developed PL/SQL procedures, Stored Procedures, Triggers, Views and UNIX Shell Scripts.
• Designed and deployed various UNIX Shell Scripts.
• Created new reports for new report development for different DataMarts.

Environment: Informatica PowerCenter 8.1, Oralce 10g, DB2, Toad 9.1, SQL*Plus, PL/SQL

Confidential, Portage, MI

ETL Architect/Modeler/Lead Data Warehouse Developer

Responsibilities:

• Participated in the review and approval of the technical transformation requirements document. Used technical transformation document to design and build the extraction, transformation, and loading ETL modules.
• Performed source data assessment and identified the quality and consistency of the source data.
• Extensively utilized Informatica PowerCenter 7.1 to load data from Flat files and Oracle database into Oracle database.
• Developed complex Informatica mappings and also tuned for better performance.
• Worked with various transformations like Aggregator, Expression, Filter, Source Qualifier, Joiner, Look Up and Stored Procedure etc to in corporate the business rules into the mappings.
• Created Mapping variables to perform the incremental loading of data.
• Scheduled and ran the extraction and load process using Server Manager.
• Created the Sessions and Batches and monitored them using Informatica Sever Manager.
• Developed PL/SQL procedures, Packages to extract data from multiple sources into ODS.
• Worked with business analysts to validate that the data extracts produce correct results.
• Fine-tuned existing Informatica Maps and Sessions for performance optimization.
• Resolved production issues by analyzing the issues thereby identifying the root cause of the problem and possible a work around to resolve the same.
• Used Erwin to update the existing Data Model.
• Imported all the necessary Fact and Dimension tables into the PowerAnalyzer from Informatica repository and defined business relationships among them so that they can be used for creation of a report.

Environment: Informatica PowerCenter 8.1.1SP2, Toad 9.1, Oracle 10g, DB2, SQL Server, SQL*Plus

Confidential, Kansas City, KS

ETL Developer

Responsibilities:

• Involved in requirements gathering in support of data warehousing to develop ETL.
• Involved in creating logical and physical data models using Erwin based on business requirements.
• Used Informatica 5.0 to load data from different source databases, flat files into the Confidential Oracle database.
• Worked with various transformations like Router, Expression, Aggregator, Filter, Sequence generator, connected and unconnected lookups to implement simple and complex business logic.
• Created Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Created, configured Workflows, Worklets and Sessions to transport the data to Confidential using Informatica Workflow Manager.
• Performance tuning of Sources, Targets, Mappings and Sessions. Improved performance by identifying performance bottlenecks and tuned various jobs at session level.
• Used PMCMD command in UNIX to schedule jobs and sessions using Autosys scheduler.
• Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
• Trouble shoot problems by checking the session log files. Also used debugger for complex troubleshooting.
• Created test data and unit test cases to ensure successful data loading process.
• Developed test plans and test scripts by decomposing the business requirements to support quality deliverability.

Environment: Informatica Power Center 7.1.1, Erwin 4.0, Oracle 9i, DB2, MS SQL Server 2000, PL/SQL, SQL Plus, Toad

Confidential, Minneapolis, MN

Data Warehouse Developer

Responsibilities:

• Involved in design of database using Entity Relationship Diagrams.
• Involved in creating logical and physical data models using Erwin based on business requirements.
• Extensively used Informatica (ETL) to load data from Oracle and flat files into the Confidential Oracle 8i database.
• Monitored the jobs on a daily basis and looked at the session logs to see if jobs completed successfully.
• Documented the number of source / Confidential rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures and Router were used to solve simple and complex business logic.
• Wrote PL/SQL stored procedures to fulfill the iterative process and to solve complex business logic.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Created and scheduled workflows using Workflow Manager to load the data into the Confidential Database.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data and to load incremental data.
• Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
• Created UNIX shell scripting and automation of scheduling processes.
• Extensively used Calculations, Variables, Break points, and Sorted inputs.

Environment: Informatica Power Center 7.1.1, Business Objects5.x, Web Intelligence. Erwin 4.0, Oracle 9i, DB2, MS SQL Server 2000, PL/SQL, SQL Plus, Toad