SUMMARY:

• Over NINE years of experience in software industry
• Experience in designing datawarehousing projects including Informatica/SSIS/SQL Server and testing.
• Experience in the latest BI Tools Tableau
• Experience in designing and implementing relational database model as per business needs
• Good knowledge of Transact - SQL (DDL, DML).
• Excellent skills in implementing ETL Mappings using Informatica.
• Experience in creating master and child packages, package configurations and logging.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools
• Experience in Performance Tuning, Query Optimization.
• Good communication skills, interpersonal skills & desire to excel, fast learner, committed and versatile team player.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data

TECHNICAL SKILLS:

Software s: Informatica 7/8/9, SSIS,Power exchange.

Version Control: Clear Case, Star team.

Automation Tool: DCS MPF Creation utility.

Reporting Tool: Tableau.

Databases: SQL Server 2005/2008, Oracle, netezza

Operation System: Windows 2K /XP / 2003/Windows 7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Lead Informatica developer

Responsibilities:

• Designed, developed, and tested the components using Informatica 9.1/9.5 on an SQL Database
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Involved in the analysis of source to target mapping provided by data analysts
• Involved in leading team at the onsite location and gathering requirements from the client
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created integrated workflow per subject area keeping the dependency with in the subject area
• Wrote Unit Test cases and executed test scripts successfully
• Involved in performance tuning of Informatica code using standard informatica tuning steps
• Involved in code Reviews as per ETL/Informatica standards and best practices

Lead Informatica developer

Responsibilities:

• Designed, developed, and tested the components using Informatica 9.1/9.5 on an SQL Database
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Involved in the analysis of source to target mapping provided by data analysts
• Involved in leading team at the onsite location and gathering requirements from the client
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created integrated workflow per subject area keeping the dependency with in the subject area
• Wrote Unit Test cases and executed test scripts successfully
• Involved in performance tuning of Informatica code using standard informatica tuning steps
• Involved in code Reviews as per ETL/Informatica standards and best practices

Environment: Operating System: Windows 7, Tools: Informatica 9.1/Informatica 9.5, Databases: SQL Server 2008, Scheduler: ESP.

Senior Informatica Developer

Responsibilities:

• Designed, developed, and tested the components using Informatica 8.6.1/9.0 on an SQL Database
• Designed and developed standards for the Informatica development team.
• Involved in analysis of the defects and ensured the defects are fixed with expected results
• Involved in creation and testing of all the mappings in the datawarehouse
• Extensively used informatica client tools-Designer, Workflow Manager and Workflow Monitor.
• Involved in preparation of unit test case and captured Unit test Results.
• As Teradata developer, responsible for maintaining all DBA functions (development, test, production) in operation 24×7.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
• Tested the Workflow and involved in writing SQL Queries for ETL Validating the data transformed, Ensured that all expected data is loaded.
• Interacted with Development team through frequent meetings.
• Prepared validation scripts and validated the data against source system
• Prepared Weekly Status Report for the project.
• Worked with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.
• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Involved in gathering information for various scenario for Change Data Capture.
• Worked with DBA to set up the DEV and QA environment and various users and roles
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Performed extraction, transformation and loading of data from different sources like Flat Files, DB2 in accordance with requirements and specifications. Performed extraction of data from mainframe/Cobol /vsam file sources and oracle table sources
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures.
• Creating tasks, sessions, events, timers etc in the workflow manager and monitoring them in the workflow monitor.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the Shell scripts.
• Involved in system testing, performance and System Integration testing stages of the project
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.

Environment: Operating System: Windows 7, Tools: Informatica 9, Databases: SQL Server 2008, Reporting Tool: Tableau.

SSIS Developer

Responsibilities:

• Involved in analyzing the existing process for product specific and design for enhancements
• Involved in managing the team in offshore and handling the day-day work tasks.
• Having involved in discussions held with clients during analysis and design phase and documented them
• Analysis of Specification document and mapping document.
• Raising clarification and following it to closure.
• Created Technical Design and UTC for the ETL SSIS package.
• Involved in Implementation, reviews and Unit Testing
• Responsible for reviewing the Stored Procedures.
• Created batch files that executes the ETL scripts which invokes SSIS packages
• Created SSIS Packages using Execute SQL Task, Execute Package Task, Execute Process task, Execute Script task, Data Flow Task, Data conversion, derived column, Lookup, multicast, OLE DB command etc.
• Created SSIS packages with Configuration, Expressions and Variables to make the package as dynamic one.
• Handling of Error and its logging.
• Created deployment utility and developed run book.
• Optimized the performance of various SQL scripts, stored procedures using suitable index and appropriate index re building.
• Tracking the CR/TR, day-to-day ad hoc task and following it to closure.
• Interaction with QA and BA team to resolve the issues.
• Weekly status reporting to various stack holders of the project.
• Had additional responsibility in ensuring quality, technical guidance, code review .
• Ensuring the developed code as per the coding standard.
• Involved in post-production support and resolving the incident during this phase.
• Invoked in utilizing the SSIS, UNIX and Oracle in combination with the testing tool HP Quality center for carrying out software quality assurance activities.
• SQL Server agent job was used to schedule the which help the whole process from Extract Loading, Output file generation, Loading output files and Log files in Datawarehouse and control process and also involved in monitoring of the jobs
• Agent Job helps in automating the process and without any manual intervention for e.g.: avoiding the steps of file transfer and manually running the packages.
• Implementation of the date replace function using the batch file which helped to automate the date change without manual intervention
• Ensuring the developed code as per the coding standard.
• Automated the code by running the code based upon the line of business.
• Automated the process of the running the Packages using automation tool and the powershell script to invoke the jobs.
• Involved in post-production support and resolving the incident during this phase.

Environment: Operating System: Windows 7, Tools: Microsoft SSIS, Databases: SQL Server 2008, Automation Tool: DCS MPF Creation utility.

Informatica Developer

Responsibilities:

• Analysis of Specification document and mapping document.
• Raising clarification and following it to closure.
• Created Technical Design and UTC for the ETL Informatica mapping validation
• Involved in Implementation, reviews and Unit Testing
• Responsible for reviewing the Stored Procedures.
• Created mapping with transformations and implemented SCD Type 1 & 2 mappings
• Handling of Error and its logging.
• Created deployment utility and developed run book.
• Optimized the performance of various SQL scripts, stored procedures using suitable index and appropriate index re building.
• Tracking the CR/TR, day-to-day ad hoc task and following it to closure.
• Interaction with QA and BA team to resolve the issues.
• Weekly status reporting to various stack holders of the project.
• Had additional responsibility in ensuring quality, technical guidance, code review.
• Ensuring the developed code as per the coding standard.
• Involved in post-production support and resolving the incident during this phase.

Environment: Operating System: Windows XP, Tools: Informatica, Databases: SQL Server 2008.

Informatica Developer

Responsibilities:

• Performed analysis and reverse engineering Informatica mappings and relevant SQL Stored procedure to determine the requirements for various interfaces.
• Involved in the preparation of technical specification document and its review.
• Explaining the functionality of the existing informatica to the developers.
• Coordinated with client SMEs, onsite technical leads on the analysis and project delivery.
• Communicating project status, issues and risks to onsite.
• Ensuring quality and timeliness of the deliverables.

Environment: Operating System: Windows XP, Tools: Informatica, Databases: Sybase 15, SQL Server 2005, Product: Claims.

Informatica Developer

Responsibilities:

• Designed, developed, and tested the components using Informatica 8.6.1/9.0 on an SQL Database
• Designed and developed standards for the Informatica development team.
• Involved in analysis of the defects and ensured the defects are fixed with expected results
• Involved in creation and testing of all the mappings in the datawarehouse
• Extensively used informatica client tools-Designer, Workflow Manager and Workflow Monitor.
• Involved in preparation of unit test case and captured Unit test Results.
• Tested the Workflow and involved in writing SQL Queries for ETL Validating the data transformed, Ensured that all expected data is loaded.
• Interacted with Development team through frequent meetings.
• Prepared validation scripts and validated the data against source system

Environment: Operating System: Windows XP, Tools: Informatica 8.1/9, Databases: SQL Server 2008, DB2, Operating system: UNIX.

Informatica Developer

Responsibilities:

• Involved in creation of mapping from source to staging and to datawarehouse
• Extensively used informatica client tools-Designer, Workflow Manager and Workflow Monitor.
• Extracted data from flat file and Oracle,Netezza. The data is transformed and loaded into netezza database in schedules to derive a single data Warehouse repository.
• Involved in preparation of unit test case and capturing Unit test Results.
• Tested the Workflow and involved in writing SQL Queries for ETL Validating the data transformed, Ensures that all expected data is loaded.
• Responsible for Bug tracking and Reporting using Test Management Tool Quality Center.
• Interacted with Development team through frequent meetings.
• Prepared Weekly Status Report for the project.

Environment: Operating System: Windows XP, UNIX, Tools: Informatica 8.1, Databases: Netezza.

ETL Tester

Responsibilities:

• Development of Test cases.
• Test Case Execution & Defect Posting in ‘Dev Track’ Tool.
• Preparation of Defect Report.
• Participated in weekly project status meetings and updated the progress.
• Involved in Deployment of the builds across the Preconfidence, Testing, Quality, UAT, Preproduction and Production environments for various projects & involved in smoke testing.
• Involved in smoke test and development of test cases

Environment: Operating System: Windows XP, Tools: C#, ADO.NET, C++/VC++, Databases: Oracle 9i, Defect Tracking Tool: JIRA.

Software Engineer

Responsibilities:

• Involved in creation of mapping with the source and warehouse components
• ETL process is used to populate the data warehouse.
• Extensively used informatica client tools-Designer, Workflow Manager and Workflow Monitor.
• Developed various Mappings and Transformations for migration of data using informatica Designer.
• Extract data from flat file and Oracle. The data is transformed and loaded into Oracle database in schedules to derive a single data Warehouse repository.

Environment: Operating System: Windows 98/XP, UNIX, Tools: Informatica 7.1, Databases: SQL Server 2000.