SUMMARY:

• Around 8 years of IT experience in leading projects with complex IT landscape.
• Technology expert in Informatica, Oracle BI, SQL, PL\SQL and Siebel.
• Expert in working on Application Development projects in various domains and across different regions.
• Currently leading the project as Technical Lead for a major investment bank in New York.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Involved in creating Dimensional Data Modeling and creating Fact table and Dimensional tables.
• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling.
• Expert in creating Informatica mappings and workflows.
• Expert in creating interface design documents and data mapping sheets.
• Extensively worked on Informatica Designer Components - Source Analyzer, transformations Developer, Mapplet and Mapping Designer.
• Experienced with complex mappings from varied transformation logics like lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Expert in Oracle RDBMS and in SQL and PL/SQL.
• Expert in using OBIEE and Oracle BI Publisher for building business critical reports.
• 5+ years of experience in leading small teams.
• Expert in laying out the data migration strategy from the legacy systems to new applications.
• Experience in Data Migration from Enterprise Legacy Systems to Siebel via Informatica/EIM.
• Strong oral and written communication skills.
• Expert in working in the Waterfall SDLC model.
• Good understanding of the Agile SDLC model.

PROFESSIONAL EXPERIENCE

Confidential, New York

Technical Lead

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources..
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Participate in the Joint Application Development sessions held amongst Business SMEs and Development teams and other stake-holders.
• Involved in scheduling the Informatica workflows using Autosys.
• Gathering, Understanding and documenting different Business Requirements.
• Identify risk and issues during different phases of the project and come up with suggestions to mitigate those risks.
• Coordinating with different stake-holders of the project to identify dependencies and defining the level of support needed from them.
• Co-ordinate with offshore development team to bridge gaps in their understandings of business requirements.
• Translating the high level business requirements into the high level design document.
• Create Interface design documents and interface specification documents for MRM interfaces with different systems.
• Create Data mapping sheets which will be used for mapping data elements from source to destination systems along with the different business rules used for data transformation.
• Create the Low Level Design Documents for ETL.
• Design the multi-dimensional data model which will be used for creating OBIEE Reports.
• Use Informatica for creating workflows which are used for extracting and transforming data from Siebel system and loading it to OBIEE data mart, which will slice and dice this data for different reporting requirements.
• Create PL/SQL stored procedures to meet some complex data processing requirements.
• Analyze data for the month end data business critical activities and generate adhoc reports via SQL queries.
• Review the code developed by the offshore development team and
• Maintain the peer review log to track the issues/review comments.
• Write and execute Unit test cases, both positive and negative, to cover all business scenarios under a Business Use-case.
• Provide support during System Integration Testing (SIT) and User Acceptance Testing (UAT) phase.
• Fix-bugs identified during SIT and UAT phases.

Confidential

Programmer Analyst

Responsibilities:

• Extracted data from different relational sources and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Worked on Informatica Power Center 9.1 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Developed Informatica mappings and also in tuning of mappings for better performance.
• Tested the mappings generated by analyzing the data flow, evaluating transformations and fixing the bugs so that they confirm to the business needs.
• Extensively used Informatica to extract from different source systems and load into the target Oracle Base tables.
• 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.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in developing Stored Procedures and complex SQL queries using SQL and Oracle PL/SQL.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Conduct inter-team meetings to finalize the data flowing between the systems and creating mapping sheets to maintain the mapping of fields between the systems.
• Write Unit test cases and execute those test cases to identify any defects in the Unit testing phase.
• Fix the defects identified in the Unit testing phase.
• Provide support during the System testing and System Integration testing phase. Fix the bugs identified during these phases of testing.