SUMMARY:

• An experienced Information Technology management professional with over 10 years of comprehensive experience in Data Warehousing / Business Intelligence environments.
• Experience of multiple end to end data warehouse implementations, migration, testing and support assignments.
• Hands on exposure to ETL using Informatica, Oracle and Unix Scripting with knowledge in Healthcare, Telecommunication and Retail Domains.

TECHNICAL SKILLS:

ETL/Reporting Tools: Informatica 10.1.0, Informatica 9.1.0, Informatica 8.6.1, Informatica 8.1.1, Informatica 7.0, Informatica Power Analyzer 4.1, Business Objects Designer 6.5, Cognos8, Hyperion System9

RDBMS: Oracle 11g, Oracle 9.2.0.6, Oracle 10g, Netezza 4.08.0, DB 2 4.6.0.556

Other Utilities: Oracle SQL developer 4.0.3.16, Oracle SQL developer 3.0.04, UNIX FTP client, Toad for Oracle 9.0, WinSql 6.0.71.582 , Text pad, Agility for Netezza Workbench, Netezza Performance Server, Informatica Admin console, Aqua Data Studio V9 etc.

Data Modeling: MS Visio 2007/2010

Operating Systems: MS Windows 7/2000/XP, UNIX, LINUS

Methodologies: Party Modeling, ER/Multidimensional Modeling (Star/Snowflake), Data Warehouse Lifecycle

Programming Languages: Visual Basic 6.0, C, C++, HTML, PERL Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Delivery Lead/Informatica Technical SME - Lead/Senior Developer/Business Analyst

Responsibilities:

• Play the role of technical SME lead the team with respect to new technical design/architecture or modifying current architecture/code.
• Strong troubleshooting skills, strong experience of working with complex ETL in a data warehouse environment Extensive experience in database programming in writing Cursors, Stored procedures, Triggers and Indexes.
• Involved in Development and Testing of UNIX Shell Scripts to handle files from different sources such as NMS, NASCO, UCSW, HNJH, WAM, CPL and LDAP.
• Involved in Performance tuning of Informatica mappings, sessions and DB Queries.
• Involved in Creation of tables structures using PARTY Model.
• Held responsible for end to end project delivery and played the primary role for the projects that I handled Delivery responsibilities
• Involved in profiling of Source data samples and Generate Mapping documents for the projects I played business analytic roles.
• Walkthrough of Project Design, PA/Class B/Final Estimates with the business for Client Review and Approval.
• Studied the requirements from the technical requirement document and prepared the low-level design document with business rules.
• Review of ETL Code, DB Scripts, Deployment document, Unit test cases, Results and Walkthrough of the same with the Clients.
• Deployment of ETL/Database and Unix Components to SIT/ UAT / PREPROD and support the respective testing and execution.
• Conduct and Co-ordinate Defect Triage discussions with SQA and UAT COE teams.
• Project Deployment/Warranty Support.
• Assist the team to provide clarifications in design and resolve issues during development and testing
• Development and Testing of NMS & NASCO Demographics mappings, sessions and workflows with Unit Test Cases and Results
• Extensively used all Informatica Transformations like WSDL, XML Parser, XML Generator, Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier during development of ETL mappings.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements. load the target tables.
• To perform Tickets monitoring, job monitoring and address any job failures or new incidents
• Prepare Ageing Report, Weekly Metrics report, Monthly Metrics report and Provide Audit Support
• To communicate Job notifications/ delays to Parallel and Downstream systems and Attend the Client conference calls with respect to Critical and High priority tickets to take corrective actions
• Lead the Offshore Support team and Ensure proper support shift plans and activities are in place
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle

Environment: Informatica Power Center 10.1.0, Oracle 11g, Oracle SQL developer 4.0.3.16, UNIX Shell Scripting, WINSCP 5.7.7, AIX/Windows 7

Confidential, Newark, NJ

Informatica ETL Developer/Business Analyst/Team Lead

Responsibilities:

• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• To collect and study the BRD requirements and prepare DLD that should include all the existing business rules
• Track all requirement clarifications through regular update calls with onsite and in corporate the same in the DLD
• Identifying and designing a new Physical / Logical Modeling as per business need with futuristic purposes.
• Development/Testing of I care-Care core and MOM mappings, sessions with proper Unit Test Cases and Results
• Extensively involved XML Transformation, Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier transformations.
• Created a Reusable asset to generate email reports on the erroneous records for every source system from the respective error table with different subject line.
• Technically lead the team from offshore and help the team to provide clarifications in design and resolve issues during development and testing
• Provide Deployment document and Warranty Support for Provider - Outbound

Environment: Informatica Power Center 9.1.0, Oracle 11g, Oracle SQL developer 3.0.04, UNIX Shell Scripting, WINSCP 5.7.7, AIX/Windows 7

Confidential, Pittsburgh, PA

Informatica ETL Developer/Team Lead

Responsibilities:

• To collect and study the requirements from BRD.
• Technically lead the team from offshore and help the team to provide clarifications in design and resolve issues during development and testing
• Actively involved in performance tuning and rebuilding some indexes.
• Performed robust testing, unit testing, negative testing and then handed over the data to QA team.
• Analyzed the existing mapping with the shrinkage mapping and Involve in the mapping merge process.
• Involved in Identifying the performance/data discrepancy bottlenecks of 2 largely complex mappings as per the business requirement and help fixing a business-critical issue.
• Perform Unit/Integration testing and capture the Unit Test Results.
• Prepare the Traceability Matrix details of this project.

Environment: Informatica Power Center 8.6.1, Tool for DB 2 4.6.0.556

Confidential, Matawan, NJ

Informatica ETL Developer/Team Lead

Responsibilities:

• Technically Lead the team from Analysis phase to Deployment/Warranty support
• To study the DLD and identify design flaws and share with the design team for correction.
• Prepare UTC, new Parameter files, develop 21 new mappings, modified 5 mappings, audit alert script sessions and Workflows with in a span of 6 months supporting multiple projects in Agile mode.
• Using oracle hints for better performance on SQL override queries
• Created Informatica PowerCenter mappings to create various Type 1 and Type 2 mappings using transformations like Joiner, Lookup, Router, Filter, Union, Sequence Generator, Aggregator and Expression
• Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, session partitioning, pushdown optimization, memory tuning and cache management.
• Present the code for internal and external reviews and incorporated the review comments.
• Perform UNIT/INTEGRATION testing and UAT data setup for the client validation.
• Prepare/Present the Operation Manual, deployment document to the client and downstream team
• Prepared pre and post session commands to send email notifications using Informatica Workflow Manager and renaming files in UNIX
• Documenting various ETL standards to be followed which include both Informatica and Oracle Design standards
• Perform Pre-Release tasks and provide the warranty support

Environment: Informatica Power Center 8.6.1, Business Objects XI 3.1, Netezza Twin fin V6.0.3 P5 SQL Server 2008

Confidential, Chicago, IL

Application SRM / Production support Executive

Responsibilities:

• SRM for GSM and Confidential support application.
• Monitoring GSM Jobs, Confidential Jobs, Power Analyzer server, BMC tickets and Handle Failures
• Provide new user access for power analyzer and power center.
• Implement GSM Enhancements - Penang Project, GSM Network separation project, Confidential SOX Compliance project and do presentation about the projects to the NSN /Client team.
• Perform Active Directory testing and Disaster Recovery process for GSM and Confidential application

Environment: Informatica 7.0, Power Analyzer 4.1, Oracle 9.2.0.6

Confidential

Production Support Executive

Responsibilities:

• Performing Pre Checks and Monitor Jobs and ensure if the daily loads are loaded properly and within the SLA.
• Kill database/Informatica locks
• Raise remedies to the source team when there is an issue with respect to the source system.
• Ensure Reporting data available for business to run the reports.
• Perform System Improvement Performance tasks to increase the performance of the daily ETL loads.
• Fix the bugs encountered through deep analysis and ensure the data is correct.

Environment: Informatica 8.1, Oracle 10g, Netezza 4.0.8.0

Confidential

Informatica ETL Developer

Responsibilities:

• To Study the BRD and understand the new workflow and mappings, Prepare Detailed Design document of all new workflows
• Worked on dimensional modeling to Design and develop STAR Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making
• Create and Implement the new DB Scripts to create new fact, dimension tables in ORACLE, NETEZZA databases
• Create new parameter files, XML source mappings , sessions, workflows and perform UNIT and Integration Testing
• Restructure and Design new workflows from baselined guidelines and perform UNIT/INTEGRATION testing, QA data setup to run the old/new workflow in QA environment
• Design 2 new business reports , for sales and products using business objects designer 6.5
• Perform Pre-Release tasks and provide the warranty support to ensure smooth functioning of the workflows and stability of the Database in the live environment by interim prechecks and post monitoring.

Environment: Informatica 8.1.1, Business Objects Designer 6.5, Microsoft Office Visio 2003, Oracle 10 g, Netezza 4.0.8.0

Confidential

Informatica ETL Developer

Responsibilities:

• Created mappings in Informatica that monitors the long running sessions using Informatica OPB Metadata repository tables
• Created Unix Scripts to generate and sending an alert email to the support team about the long running session.
• To Work on the Documentation part of the Tool that includes HLD, DLD and the Tool Template for submitting to the Organization Tools group

Environment: Informatica 8.1.1, Oracle 10g, Toad for Oracle