SUMMARY:

• 10 plus years of IT industry experience encompassing a wide range of skill set, roles and industry verticals. Experience working with telecom domain. (Expert in Telecom Billing)
• Good proficiency in Informatic Data Quality 9.5.1/9.6.1 and Informatica power center 9.1 & 9.6 .
• Very strong in implementation of data profiling, creating score cards, Creating reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication.
• 8+ years of strong ETL data integration experience in Telecom domain using Informatica PowerCenter9.1 & 9.6 Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Transformation Developer, Mapping Designer, Task Developer and Workflow Designer.
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Match, Exception, Association, Standardizer and other significant transformations.
• Experience in various active transformations in Informatica Power Center like FilterTransformation, Aggregator, Transformation, Joinertransformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Experience in various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Experience in working agile projects
• Experience in supporting Informatica applications, data extraction, Transformation and Loading from heterogeneous sources using informatica Power Center
• Implemented Performance Tuning Techniques for ETL process such as finding bottlenecks in sources, targets, mappings, and sessions and have done Troubleshooting and Error Handling using various log files
• Worked on Star Schema, Snowflake Schema, FACT tables, and Dimension tables.
• Onsite experience in supporting the BSS applications and handling the production issues and Implementation of various Interfaces across Telecom Service providers.
• Completed 2 Major Data Migration projects with full life cycle implementation.
• Implementing Process improvements for Order Processing in AT&T’s billing and Middleware systems.
• Developed the internal automation tool that helped in reducing the manual efforts and give good quality of results in short span of time.
• Good grasp of SQL, UNIX and PL/SQL.
• Developed the tool as part of the new program that will helps to get an overview of data loaded for current date. Client is very happy with the implementation and got an additional business to IBM.
• Developed and Tested applications developed using JAVA, EJB,VB and ORACLE based applications
• Experience in end to end testing(Billing, Service assurance and Service Delivery) of telecom products like Managed Internet service, Virtual Private network, Voice over IP etc
• Experience in preparing end to end test Plan, test cases, test reports and documentation of manual and automated tests.
• Experience in conducting daily status call with team and client to provide latest on going things and blocking issues.
• Experience in resolving blocking issue in all phase of testing (System testing, user testing) including production.
• Experience in creating clear and actionable bug reports using tools.
• Experience in Reporting and prioritizing software bugs.
• Solid exposure to Defect Tracking Tools - Rational Clear quest and Defect Report Tracking Tool, Mercury Quality Center 11.0, Rally dev.
• Performed the Data Driven test that deals with different sets of data.

TECHNICAL SKILLS:

RDBMS: Oracle 9i & Oracle 11g, Teradata 15.0

Data warehousing tool: Informatica 9.1 & Informatica 9.6 & IDQ 9.6

Languages: Oracle SQL, Java, EJB, PL/SQL

Development Tool: Net Beans 8.0

Automation Tool: Quick Test Professional (QTP9.1)

Test Management Tool: IBM Test Management Tool, Rational Clear, Quest, DRTT (Defect Report and Tracking tool), Mercury Quality Center (QC), TMRS (Test Management and reporting system)

O/S: Windows NT/2000, Windows XP, Windows7 & UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Middletown, NJ

Lead ETL Developer

Responsibilities:

• Provide design leadership in large or complex development projects involving application development, migrations, and additions to existing applications. Participate in project meetings with other technical staff and business owners and subject matter experts.
• Review the requirement US with client, create mapping document, Design Document and track the outstanding issues or open item.
• Assess and develop high level design requirements for project and communicate in writing or in meetings with development team
• Review application in progress of development to ensure compliance with overall design parameters and corporate development standards. Guide programmers/developers on technical issues.
• Develop or review development of test protocols for testing application before user acceptance. Review test results and direct further development.
• May serve as technical lead, architect, and project lead or principle developer in course of large or complex project.
• May provide, or guide provision of technical support to applications currently in production
• May mentor or guide work of less experienced programming and development staff.
• Responsible for Business meeting, conversion of business rules into technical specifications
• As a Business Analyst & ETL Lead developer in team Coordinating between the onsite team and off shore team with the customer requirement. Taking the responsibility of the whole release projects conducting the status call with clients, Project Management and users providing the daily process of the project.
• Conducting the knowledge session for the new joiners for AT&T project about the process and functionality flow.
• Conducting the session with in the team for new joiners to train the tool that we are using in the project to meet the requirement.
• Reviewing the HLD with SE’s (System Engineers) and provide necessary feedback to avoid the requirement gap in further life cycle.
• In addition to the above responsibilities working on development of critical requirement for current release.
• Look over the critical production issue that needs a fix and clear the production blocker.
• Following up on blocking issues with respective applications and make sure that it is been resolved.
• Collecting the status of each projects updating the management with the updated status and participating in the audit.
• Preparing the schedule reviewing the same with IBM Management, client (AT&T) and make sure that has been base lined after coordinating with across the project.
• Preparing the project risk document and getting signed off from management.
• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Worked with Source Analyzer, Transformation Developer and Mapping Designer
• Worked with Task Developer, Worklet Designer and Workflow Designer in the Workflow Manager

Environment: Informatica Power Center 9.6, SQL, Flat Files, Oracle, Toad & UNIX, LINUX

ETL Lead Developer

Responsibilities:

• Worked with Source Analyzer, Transformation Developer and Mapping Designer
• Worked with Task Developer, Worklet Designer and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle DB and Flat files
• Responsible for the Data Cleansing of Source Data using LTRIM,LAST DAY and RTRIM operations of the Expression Transformation
• Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters
• Handled various loads like Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique
• Worked with Update strategy transformation using functions like DD INSERT, DD UPDATE, DD REJECT, and DD DELETE.

Environment: Informatica Power Center 9.1, SQL, Flat Files, Oracle, Toad & UNIX.

ETL Informatica Developer

Responsibilities:

• Worked with various active transformations in Informatica Power Center like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Worked with Source Analyzer, Transformation Developer and Mapping Designer
• Worked with Task Developer, Worklet Designer and Workflow Designer in the Workflow Manager
• Responsible for extracting data from Oracle DB and Flat files
• Responsible for the Data Cleansing of Source Data using LTRIM,LAST DAY and RTRIM operations of the Expression Transformation
• Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters

Environment: Informatica Power Center 9.1, SQL, Flat Files, Oracle, Toad & UNIX.

ETL end to end Tester

Responsibilities:

• Prepared the migration activities steps in order to track the project.
• Extensively performed the Reviews with the Client and all the impacted application
• Prepared the Defect Sheet and retrospective document.
• Execution of the Test Cases and reporting the defects.
• Interacted with all the AT&T impacted application and get it the work done in the specified time frame.
• Logging and tracking all the test defects in Defect Report and Tracking too
• Supported User Acceptance testing(UAT) execution
• Preparing system Integration Test plan in IBM Test Management Tool in very short time.
• Preparing system Integration Test Cases in IBM Test Management Tool in very short time.
• Prepared Data Requirement Defect Sheet, retrospective document.
• Execution of the Test Cases and reporting the defects.
• Interacting with the on-Site Co-Coordinator and users, Understanding the issues and resolving it in a specified time frame.
• Logging and tracking all the test defects in Defect Report and Tracking tool that is Rational Clear Quest. Quality Center (QC).
• Preparing Test management Reporting system and Test Conditioning audits.
• Extensively performed the Reviews with the Client and all the impacted application
• Supporting User Acceptance testing(UAT) execution
• Extensively performed team lead activities by reporting status of weekly and daily of all the projects that are running in the current release.
• Worked on the blocking projects to get the issue resolved and deliver the project successfully on time.
• Guiding the other team members during the execution of the project and make sure that it will goes as per the schedule.
• Scheduling the training for newly joined team members and make sure that it will goes as per the schedule and completes successfully.
• Participating in the Crit/Sit to help my management to make sure that, the exact issues of all the projects that are running in the current release will be reaching the high management with out any gap.
• The training has been given to End to End project management and SQA team to under stand about Integrated System testing activities (IST).The document has been prepared for the same and circulated.
• Participated in Project management audit and document has been prepared as per the policy and standards.
• Development of Internal Automation tool’s, helps the team in reducing the manual work & helps in billing process.

Environment: MVS, Docviewer, UNIX, JSP, Java and oracle11g