SUMMARY:

• Over 11 years of experience in Data analysis, design, development, testing and implementation in Data warehouse projects primarily in Data Integration tools
• Expertise in Informatica data Extraction, Transformation and Loading from source to target in a complex, high volume star and snowflake schema
• Experience working with various Heterogeneous Source Systems like Oracle, DB2 UDB, MS SQL Server and Flat files
• Experienced in data analysis, reconciliation, profiling, standardization using Trillium Data quality
• Experienced on Informatica performance tuning of Source, Target, Mapping and Session level bottlenecks
• Expert in creating complex Oracle SQLs, query tuning and debugging
• Expertise in Data Analysis, requirement gathering, high - level and low-level design documents, interface and test documents
• Knowledge on Informatica Cloud features like Data Synchronization, Quality Assessment, Loader and Replication
• Experienced in Agile SDLC model of work, with bi-weekly Sprints and deliverables
• Experience in Team and process management in onsite and offshore model
• Experience working on Insurance, Supply chain, Manufacturing & Retail, Oil and Gas domains
• Knowledge on the Confidential ’s BI report studio for report creation and data validation
• Experienced in Production Support role 24/7 to resolve the issues using a trouble ticket system
• Have defined and applied best practices in development and administration activities
• Hands-on experience in various stages of Waterfall SDLC model including business requirement analysis, data mapping, build, unit testing and user acceptance testing
• Excellent interpersonal and communication skills, with experience in working with C-level business executives and across multiple disciplines and teams

TECHNICAL SKILLS:

Domain: Insurance, Manufacturing & Retail, Supply Chain, Oil and Gas

Programming Languages: C, SQL, PL\SQL

Operating System: Windows, Unix

Data Warehousing Tools: Informatica 9.X,8.X&7.X, Cognos, Open Text O.T.I.C. 10.6 and Trillium Data Quality

WORK EXPERIENCE:

Confidential, Atlanta, GA

Onsite Technical Lead, Business Analyst and Conversion Support Analyst

Responsibilities:

• Analyzed legacy TAMS system with target structure and to gather requirements
• Lead the offshore team by guiding and reviewing their deliverables on regular basis
• Participated in daily sprint meetings for status update on JIRA tasks
• Created complex queries to reconciliation the data between source and target with 100% accuracy
• Identified multiple long existing defects and resolutions
• Performed QA testing based on Sprint allocation
• Interact with Product team, Architects, SCM - Software Configuration Management and scrum master on regular basis
• Debug and enhance the Informatica code for data discrepancies for high priority defect
• Participated in defect review meetings with analysis and impact
• Developed the work around Pl\Sql scripts for Production defects
• Provide L3 support for the application
• Provide L2 store conversion technical support overnight and published the reject and scorecard reports to various stake holders
• Other coordination and management activities that include providing estimates, process improvement, time\effort tracking, status updates, defect\JIRA request creation and knowledge transfers

Technology & Tools: Informatica 9.6, Oracle SQL and PL\SQL, Microsoft SQL Server, MS Access DB, and Unix

Confidential, Berkley Heights, NJ

ETL Lead

Responsibilities:

• Business requirement gathering from on Actuarial and underwriting team for enhancements
• Analysis of the existing legacy ETL code by reverse engineering, understanding and to create new mapping rules
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner and Lookup to develop robust mappings in the Informatica as part of enhancements
• Used SCD Type 1 and type 6 mappings to update slowly changing dimension and mini dimensions
• Streamlined the team operation by creating required support documents so entire team can be cross trained
• Optimized the DB back up strategy to save the DB processing time from 18 hours to 2 hours a day
• Involved in Performance tuning at source, target, mappings, sessions and system levels by which reduced the complex workflow run time from 18 hours to 6 hours
• Document the bug fixes made with testing results for easy reference of new team members
• Performed ETL production data loads analysis and fixed complex problems
• Wrote UNIX shell scripts using PMCMD commands for executing and scheduling workflows
• Created complex SQL query for STG to Fact table’s reconciliation of business measures
• Planning tasks allotted to the team based on the business provided priority and issues tracker
• Coordinating the Release Management cycle with required approvals and PVCS for versioning code

Technology & Tools: Informatica, Oracle 11g, Cognos and OTIC 10.6

Confidential

Business Analyst \ Technical Lead

Responsibilities:

• Business requirement gathering from Business users
• Matching policy number across various front-end systems in Central European region and standardizing the format
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts
• Data Analysis of RI Vertical legacy codes and GOALD DB to derive business logic to design and implement a new standard Informatica ETL approach for Central European region
• Congos report Cube, report validation with backend DB results using complex SQLs
• Prepare the ETL design documents and designed DB and ETL solutions for the RI Vertical and Confidential implementations
• Co-Ordinate with various team to understand the code issues, fix the bugs and test the changes for various regions of the client
• Taking care of the Release Management process

Technology & Tools: Informatica, Erwin 7.2, Genio (O.T.I.C.), Oracle 10g and Unix

Confidential

Senior Informatica Developer

Responsibilities:

• Understand and Analysis the specifications, did impact analysis created technical design documents
• Co-Ordinate with various teams to understand the deliverables and estimates
• Created complex SQL script for Primary key and foreign key dimensional loads and optimized the performance
• Design S.C.D Type 2 Informatica mappings
• Developed SQL and PL\SQL scripts as per the requirement
• Performance tuning of in ETL and SQL scripts
• Leading a team of 5 people and provide them required inputs for their development work
• Review of developed codes and performance improvements if any required
• Creating and maintaining Quality\Audit documents for the deliverables

Technology & Tools: Informatica 8.1, SQL, PL\SQL and UNIX

Confidential

Data Quality Analyst/Informatica Developer

Responsibilities:

• Developing Informatica mappings for ETL related activities
• Analyzed business rules and checked the data adherence with those.
• Co-Coordinating with onsite Business Analyst and Data modelers to design the ETL data warehouse
• Profiling master data tables TS Discovery.
• Creating reports using SSRS tool.
• Loading data from various legacy systems using Informatica.
• Preparing Low Level Design for the developers to develop the codes.
• Scheduling the jobs using ESP Scheduler
• Guiding couple of people for their deliverables.

Technology & Tools: Informatica 8.1, Trillium, Oracle, SSRS and UNIX