Sr Informatica ETL Analyst/ DataWwarehouse Developer
Resume:
Rizvi S
***********@*****.***
SUMMARY
• Around 8+ years of IT experience with specialization in ETL, Data warehouse life cycle.
• Experience in development, and implementation of business applications for Insurance, Financial (Banking), Automotive and construction domains.
• Experience in using Informatica PowerCenter8.6.1/8.1/7.1.2/7.1/6.2/5.1. Developed mappings and Mapplets using Designer transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure.
• Strong experience in dealing with reading different sources – Oracle, SQL Server, Flat file, XML, MS Access, MS Excel, Cobol.
• Worked with Informatica Best Practices guidelines for tuning of ETL mappings, targets, sources and minimize performance issues.
• Experience in performing Unit testing, Integration testing, System testing & End-to-end testing.
• Experience in Business requirements gathering, documentation and converting into technical documents like – Research & Solution Document (RSD) or Business Requirement Document (BRD), Detail Design Document (DDD), mapping specs document and Unit test document.
• Hands on experience in creating Data maps using PowerExchange 5.2.2.
• Experience in stored procedures/triggers/functions/packages in conjunction with Informatica processes for ETL Control Totals balancing, reconciliation and Rating & Requote algorithms.
• Working knowledge of SQL tuning using concepts like Explain Plan, Hints. Hands on experience with Erwin tool.
• Experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions. Experience in developing UNIX Shell scripts to analyze, truncate tables, run jobs, placing touch files on the servers etc.
• Used Control-M scheduling tool for automation of ETL jobs.
• Strong experience in Production Support activities– jobs scheduling, monitoring, troubleshooting. Working experience with on and offshore teams. Quick learner and excellent problem solving skills. Team player, motivated and dynamic.
• Excellent analytical and logical programming skills with good understanding of concepts and possess excellent presentation, interpersonal skills with strong desire to achieve specified goals.
• Excellent communication, coordination, organizational and follow-through skills.
• Efficient in the execution of all assignments, eager to take on new challenges.
SKILLS
Software & ETL Tools:
Informatica PowerCenter8.6.1/8.1/7.1.2/6.2/6.1,Oracle10g/9i/8.1.7,DB2,SQLServer2005,Toad10.6.1/9.6.1/9
.0.1/8.6.1,SQLDeveloper1.2,PowerExchange 5.2.2, Control-M 6.1, Erwin r7.3/4.1.4/4.0,
, SecureFX4.5, SecureCRT 5.5/4.0, MS Office Visio, MS Office Suite, Citrix
Operating Systems: Windows XP/2000/98/95/NT, AIX 5.3/5.2/5.1/4.3.3, Linux, DOS
Databases: Oracle 10g/9i/8i/7.3, DB2, MS SQLServer 2005/2000, MS Access
Languages: C, SQL, PL/SQL, Unix
Data Modeling Tools: Erwin r7.3/4.1.4/4.0/3.5.2
Utilities: Toad 10.6.1/9.6.1/9.0.1/8.6.1, SQL Developer 1.2
EDUCATION: Bachelors in Computer Science Engineering
PROFESSIONAL EXPERIENCE
Sr. ETL/Database Developer Nov 2009 – Present
Client: MFX Fairfax, Morristown NJ
MFX Fairfax is a leading insurance company offering insurance products with solutions for variety of insurance firms like Ironshore/Ironstarr/CVStarr/Prosight. Worked as an ETL Developer in Reporting Datamart project.
Responsibilities:
• Designed the detailed ETL flow process and implemented Informatica mappings to load DW.
• Involved in direct client discussions for requirements gathering.
• Analyzed the functional specs provided by the data architect and created technical specs documents for the ETL process.
• Designed and developed ETL to implement the concepts of “Incremental Load” & “Current row Indicator logic”.
• Involved in Database design and ETL application design.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor. Optimized performance by tuning the Informatica ETL.
• Performed ETL tuning and resolved data extraction bottlenecks.
• Reviewed source systems and proposed data acquisition strategy.
• Involved in administration and migration activities of Informatica.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Coordinated development efforts with on and offshore teams.
• Involved in Production activities and supported systems for process recovery.
• Developed reconciliation/Control-Totals balancing for data validation.
• Worked closely with QA team during the testing phase and fixed bugs that were reported.
• Worked and managed offshore team during the course of project.
• Supported production support activities and experience as an on-call production support for the applications.
• Performed unit testing/system testing and supported user acceptance testing (UAT).
• Performed activities related to ETL code migrations & validations.
Environment: Informatica Power Center 8.6.1/8.1.1, Erwin r7.3, Oracle 10g, Toad 10.6.1/9.6.1/9.0.1, SQL Server 2005, MS Office suite, SecureFX4.5, SecureCRT 5.5, SharePoint
Sr. ETL/Database Developer Sep 2006 – Nov 2009
Client: CNA Insurance, Cranbury NJ
CNA is one of the largest U.S. commercial insurer providing insurance services for property & casualty (P&C). CNA provides insurance services and products to a wide range of lines of business like - Professional Liability, Auto, Property, General Liability and Workers Compensation. Worked as an ETL/Database Developer in projects “Billing & Collections” and “Accounting Center”.
Responsibilities:
• Involved in requirements gathering, analyzed the functional specs provided by the data architect and created technical specs documents for the ETL process.
• Wrote detail design specifications, attended user requirement sessions.
• Extracted data from multiple sources – oracle, DB2, Flat files, SQL Server 2005, Cobol files.
• Developed ‘Rating Algorithms’ used by the Actuaries.
• Created complex ETL mappings/mapplets. Implemented CDC (change data capture) concept in mappings. Built Data Maps using PowerExchange.
• Used concepts like Persistent cache, SQL overrides, LKP overrides for performance tuning of the Informatica mappings.
• Implemented Control-Totals balancing in ETL process for data validation.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor. Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
• Partially worked with Data modeler in Database design, Data Modeling.
• Hands on experience using Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions.
• Wrote stored procedures and used in stored procedure transformations of the mappings.
• Created UNIX Shell Scripts to be used as pre/post session commands to truncate, analyze, drop indexes on tables, and to run stored procedures.
• Managed Change control implementation and coordinated daily, monthly releases and reruns.
• Scheduled Jobs using Control-M scheduling tool. Coordinated development efforts with offshore team.
Environment: Informatica Power Center 8.1.1/7.1.2/7.1.1, Control-M 6.1, PowerExchange 5.2.2, Erwin 4.1.4/4.0, BO 6.1 / 5.1.6, Oracle 10g/9i / 8.1.7, DB2, Toad 9.0.1/8.6.1, SecureFX4.5, SecureCRT 5.5/4.0.
Sr. ETL/Database Developer Jan 2006 – Sep 2006
Client: TD Bank, MT Laurel NJ
TD Bank is a leading financial institute providing its customers with diversified services. TD Bank initiated. Worked as an ETL developer in Data Archive project processing data from merger banks.
Responsibilities:
• Analyzed and processed metadata related to financial/mortgage/credit-cards documents like Signature Documents, Mortgage & Loan Documents, IRA, LEGAL and Compliance Documents.
• Involved in user requirement gathering and assessing the impacts on the existing systems.
• Analyzed the source system data and designing ETL mapping frame work to extract data.
• Designed the ETL process and steps to extract new conversion data.
• Prepared Detailed Design document & technical mapping specs document.
• Developed complex ETL mappings to extract data.
• Optimized the ETL code to improve performance.
• Performed Unit testing/System testing on the archived data.
• Actively involved in business requirement meetings.
• Documented the complete application development process with ETL detail design documents, Business Requirement documents and ETL process flow.
• Developed Functions/Triggers/Procedures for application development.
Environment: Informatica Power Center 8.6.1, Oracle 10g, Toad 9.6.1, SQL Developer
ETL/Database Developer May 2005 – Jan 2006
Client: Temple-Inland, Austin, TX
Temple-Inland is an Austin based company operating a full-service bank and engaging in mortgage lending, insurance services and real estate activities. Data warehousing project was initiated to collect and analyze data of its customers for revenue collection activities. Worked as ETL/Database Developer in this project.
Responsibilities:
• Performed requirement gathering, analysis and study of existing systems.
• Extensively worked with Mapping Designer, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before normal run of the Workflow. Designed complex mappings involving target load order and constraint based loading.
• Assisted in updating the logical model for related entities, attributes and relationship with each entity based on the rules provided by the business using Erwin.
• Developed Stored Procedures and used them in Informatica mappings. Designed and Deployed UNIX Shell Scripts
• Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
• Documented the purpose of mappings so as to facilitate the personnel to understand the process and incorporate the changes when necessary.
• Developed test cases for Unit, Integration and system testing.
• Was responsible for Pre and Post migration planning for optimizing Data load performance, capacity planning and user support.
• Performed migration of mappings and workflows from Development to Test and to Production
• Developed reusable Mapplets and Transformations for reusable business calculations.
• Actively involved in end user training and support.
Environment: Informatica PowerCenter 7.1/6.2.2, Oracle 9i/8.1.7, SQL Plus, PL/SQL, DB2, Business Objects 5.1, AIX 5.3/5.2,5.1, Sun Solaris 5.9, Windows 2000, Erwin 4.0/3.5.2, Toad 8.6.1, SecureCRT 4.0
ETL/Database Developer July 2004 - April 2005
Client: CarMax Inc Richmond, VA
CarMax is one of the top used car reseller and distributor in USA. Data Warehousing Project was initiated to collect data and assess the performance of its stores. Worked as ETL/Database Developer.
Responsibilities:
• Participated in requirement meetings with Business Analysts and end users.
• Identified data sources for defining data extraction methodologies. Performed impact analysis for systems and database modifications
• Worked with DBA to set up development, test and production environments.
• Analyzed data values, relationships from legacy systems, relational databases, non-relational sources, file formats to check compliance with existing standards and business rules.
• Created packages, stored procedures, functions and triggers.
• Performed unit testing/system testing.
• Created mappings in Informatica PowerCenter to migrate data from various operational sources like Oracle Databases, SQL Server, Excel spreadsheets to Target Data Mart.
• Performed migration of mappings/workflows from Development to Test and to Prod Servers.
• Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
• Developed mappings and mapplets extensively using Informatica Designer.
• Developed complex mappings using different transformations.
• Developed pre and post session Stored procedures transformation tasks to drop, recreate the indexes and keys of source and target tables.
• Partitioned the sessions to improve the performance.
• Used Workflow Manager to design sessions, event wait/raise, and assignment and command to execute mappings.
Environment: Informatica PowerCenter 6.2.2, Oracle 9i/8.1.7, SQL Server 2000, Toad 8.6.1
Database Developer Jan 2003 - June 2004
L&T Power Systems, India
Larsen & Toubro Limited (L&T) is India's largest engineering and construction conglomerate. The company’s fast growing business led to inflow of huge data and accumulation. Issues like redundant information and associated conflicts, errors in reports, unavailable information. Therefore a project was initiated to build a centralized oracle database as a strategic solution to manage, store data efficiently. Worked as Database Developer.
Responsibilities:
• Responsible for Business Analysis and Requirements gathering.
• Designed and developed data tables to store inventory data.
• Wrote PL/SQL Stored procedures, functions, triggers and anonymous PL/SQL block.
• Involved in Unit Testing / System Testing.
• Interacted with end users to prepare system requirements.
• Identify the data and activities that need to be maintained.
• Report generation for Price list, Inward register and Vehicle stock.
• Perform application and database design services.
• Provide complete documentation and transition application to internal team.
Environment: Oracle 8i/7, MS SQL, SQL Plus.
*****References available upon request*****
Contact this candidate