SUMMARY

• IT professional having more than 8 years of extensive working experience in Business Intelligence, Data Warehousing and ETL technologies in Insurance and Manufacturing domain.
• Experienced in analyzing, designing, testing, implementing and supporting complex warehouse projects
• Played Business Analyst for some time alongside ETL Lead role which involved business interaction, understanding the requirements, Data Analysis and designing Techno - functional documents
• Good understanding of Data Modeling (Star and Snow Flake Schemas), Physical and Logical models, DWH concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.
• Elaborate experience in databases like Oracle, Sybase and IBM DB2 and database tools like TOAD, AQT, Win-SQL, and SQL Developer.
• Experience in converting PL/SQL code into ETL Interfaces/mappings.
• Experienced in testing Data Warehouse/Data Mart/Business Intelligence projects with emphasis on requirements gathering, business analysis, logical and physical database design, database optimization and implementation, reports, application.
• ILM tool for discovery and finding sensitive data.
• Use TDM(Test Data Management) to define masking rules, domains, create workflow and mask data.
• Hands on experience with complex SQL, Procedures, Packages
• Use of ILM Data Archive for sunset applications or retired apps.
• Hands on experience on retirement policy to archive database.
• Use of Informatica Data Validation Object(DVO) to verify data after masking.
• Strong understanding of data structure, analysis and design techniques.
• Experience in ETL tools such as Informatica and query reporting tools such as Micro Strategy.
• Ability in selecting the appropriate testing tool for projects.
• Experienced with IDQ (Informatica Data Quality) for profiling database tables, Data cleansing.
• Good Project management skills in planning and monitoring small to large projects. Had been managing technical and non-technical teams through the DW & other application life-cycle phases(SDLC)
• Fast Learner, good communication and presentation skills, ability to quickly adapt to the technical environment coupled with very positive user interaction & team spirit.
• Experience in using Bugzilla, HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.

TECHNICAL SKILLS

BI & ETL Tools: InformaticaPowerCenter 9, Data Warehousing, ILM, TDM,IDQ

Databases: IBM DB2, Oracle 9,SQL Server, Mainframe

Operating System: Windows XP/NT/2000/98/95, Unix (AIX)

Languages: SQL, PL/SQL, C

Scripting Languages: Unix Shell Script (Korn shell),Excel VBA(Macro)

Others: Ipswitch, WinSCP and Visual SourceSafe, HP Quality Center, Calligo, Maestro Scheduler, MS Office, MS VisioEdit plus, Text pad, Excel VBA

Domains: Annuity & Life Insurance, Finance

PROFESSIONAL EXPERIENCE

Confidential, Jersecy City, NJ

Senior ETL Developer/Dev Lead

Responsibilities:

• Requirement Gathering and Analysis of each enhancement come across for provider area.
• Worked on highly critical trade normalization project for Confidential where all trades which were made by Confidential needed to be consolidated.
• Worked on International future bond/Future bond options for European market positions.
• Followed agile methodology for development which also includes deployment, defect fixing, status matrix.
• Work closely with data analyst and data modeling team on help building new structures.
• Helped developed audit balance control mechanism for all ETL/data warehouse projects to control quality of data sent to vendors.

Confidential, NJ

Senior ETL Developer/Dev Lead

Responsibilities:

• Requirement Gathering and Analysis of each enhancement come across for provider area.
• Coordinate with all downstream systems/Vendors for testing to make sure no breach in app due to new data.
• Get offshore resource adequate knowledge to get them on speed to meet project deadline.
• Helped analyzing the data synchronization
• Extensive co-ordination with multiple Maintain the defect life cycle, traceability matrix.
• Prepare Project Status, Metrics report and manage onshore/offshore quarterly effort estimation.
• Manage Customer Relationship.

Confidential, NJ

Senior ETL Programmer Analyst

Responsibilities:

• Requirement Gathering and Analysis of each individual application with application AD team on masking in/out of scope fields
• Run ILM tool for analysis to find out sensitive data based on PII, Domains and metadata profiles defined in bank
• Discuss with application team and finalize sensitive data.
• Use ILM Archive based on application need and requirement,
• Creating retirement strategy policy for apps to archive data.
• Coordinate with all downstream apps for testing to make sure no breach in app due to masking of upstream application
• Verify data with Informatica Data Validation Object(DVO) that data is correctly masked or not.
• Run Informatica IDQ to profile database tables and cleansing data based on requirement.
• Maintain the defect life cycle, traceability matrix.
• Participate in Reviews and Audits.
• Prepare Project Status, Test Status and Metrics report.
• Manage Customer Relationship.

Environment: Informatica Power center (v9.5), TDM, Data Quality, PowerExchange, Oracle, Sybase, SQL Server,Unix

Confidential, NJ

Onsite Project Lead

Responsibilities:

• Requirement Gathering and Analysis of each individual application with application AD team on masking in/out of scope fields
• Responsible for identifying sensitive fields from each application database.
• Accountable for the test delivery - act as a SPOC
• ILM tool for discovery and finding out sensitive data from database based on PII, PCI defined in metadata expressions.
• • Extensively used various active and passive transformations like Filter Transformation, Router Transformation, ExpressionTransformation,SourceQualifierTransformation, Joiner Transformation, and Look up Transformation,Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Coordinate with all downstream apps for testing to make sure no breach in app due to masking of upstream application
• Software configuration management: documenting and defect tracking.
• Maintain the defect life cycle, traceability matrix.
• Participate in Reviews and Audits.
• Prepare Project Status, Test Status and Metrics report.
• Used IDQ for data quality and cleanliness
• Mentor & guide the onshore &off-shore teams and act as a SME.
• Manage Customer Relationship.

Environment: DB2, Oracle, Sybase, SQL Server, Mainframe

Confidential

Onsite Project Lead

Responsibilities:

• Requirement Gathering and Analysis.
• Responsible for Estimation & Planning.
• Accountable for the test delivery - act as a SPOC.
• Manage ETL / DW / DM testing teams.
• Software configuration management: documenting and defect tracking.
• Maintain the defect life cycle, log and traceability matrix.
• Participate in Reviews and Audits.
• Prepare Project Status, Test Status and Metrics report.
• Mentor & guide the onshore &off-shore teams and act as a SME.
• Work closely with Business Analyst, Data Modelers, ETL Developers and the test teams throughout the project life cycle.
• Manage Customer Relationship.
• Prepare & Review Scoreboards.
• Managing small database project single handed from onsite.
• Build Business Relationship.
• Create/Modify SQL complex script based on mapping docs/ Informatica mapping.
• Review/Update SQL scripts

Environment: DB2, Oracle

Confidential

Informatica Developer

Responsibilities:

• Responsible for the planning and management of all technical and operational activities.
• Provided strategic solution to verify address data across CMR and IBDW team.
• Created mock up data and inserted them into CMR and verified that to detect Duplicate Address issue.
• Helped analyzing the data synchronization
• Extensive co-ordination with multiple Teams.
• Created technical documents to understand team how data extracting happens from various sources involving flat files in future.
• Verification of all ETL mapping for error strategy, reconciliation, error processing.
• Verified mappings which extracts data from various sources involving flat files with mock up data
• Frequent communication with the business on technical and functional queries.
• Building Generic SQL for quick verifications.

Environment: DB2, SQL,Oracle