SUMMARY

• 9 Years of extensive experience in IT industry which include different ETL tools like Informatica and SAS.
• Well acquainted with software life cycle (SDLC) & Agile Methodology.
• Experience in Designing and Implementing Complex Data Warehouse applications and Legacy Conversions using ETL tool INFORMATICA POWER CENTER.
• Experience in writing SAS scripts which extract transform and load into Target table.
• Experience in working on End - To-End implementation of data warehouse and understanding of Data Warehouse Concepts, ETL and Star schema.
• Design and guide team in development of Error handling mechanism, Parameter generation and Designing Audit process for the mappings.
• Experience in loading data into the Oracle BAW warehouse from Seibel system.
• Experience in loading data into IBM IIW from DB2.
• Hands on experience on SAS data validations using Proc SQL.
• Experience in all phases of SDLC life cycle involving Requirement Analysis, Design, Coding, Testing, Deployment and Production Support.
• Hands on Experience in preparing High Level Design (HLD), Detailed Design (DLD), ETL Mapping Specification and Unit Test Documentation in the Design and development phases.
• Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading, in a corporate-wide-ETL Solution using different versions of Informatica.
• Experience in Informatica performance tuning/Partitions and identifying the bottle necks in sources, mappings, targets and sessions.
• Strong Skills in writing technical and functional documents defined by the business requirements and involved in the issue resolution and root cause analysis.
• Proficient experience to work on DAC and CISCO Tidal scheduling tools.
• Excellent Interpersonal and Communication skills, organizational skills, ability to handle multiple tasks and work well in a team environment.
• Excellent Logical and Analytical Skills to solve the complex problems.

TECHNICAL SKILLS

Tools: Informatica 9.5.1, SAS 9.2

Languages: UNIX, Linux

Databases: Oracle 8, 9i, 11, Teradata 13, DB2.

Scheduling Tools: Tidal, DAC, ESP and Informatica Scheduler.

Reporting Tools: Crystal Reports 11.0

Version Control: SVN, GIT

Others: Rally, Toad, SQL Developer, ALM, Clear Case, Clear Quest & Harvest.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer and System Analyst

Environment: Informatica 9.1.0, Oracle.

Responsibilities:

• Worked closely with the business users across different business Units to gather requirements for building and enhancing the existing process & functionality.
• Worked on gathering, analyzing & documenting business requirements.
• Worked mainly with Finance teams to determine the Margin for a customer at 5 GL segment level.
• Margin analysis for Offnet service is provided to End clients.
• Create and maintained mapping documents.
• Extensively used Informatica client tools Mapping designer, Mapplet Designer, Transformations and Informatica Repository Manager.
• Designed, developed and tested Informatica mappings using efficient transformations and used reusable transformations as well as Mapplets.
• Worked on Performance tuning of mappings.
• Worked with DBA and Architects in design of new tables.
• Created Deployment groups and promoted code into higher environment.
• Involved in Sprint planning and grooming sessions.
• Performed Unit testing and Involved in Debugging.
• Involved in pre and post production release activities.

Confidential

Onshore Module Lead

Environment: SAS 9.2, Teradata TPT utility, DB2, Oracle, Teradata, Toad, SQL, Proc SQL, Rally

Responsibilities:

• Involved in Requirement gathering, Design and Development of SAS reports.
• Analyze the requirement and extracted data from base tables (CRDM DB) to perform the metric calculations.
• Developed SAS code to perform the ETL activities.
• Programmed TPT scripts to load data into CCW.
• Developed Benchmark code based on requirements.
• Worked on debugging the issues and fixing the code.
• Perform production checkouts to validate reports and coordinate with Dev ops team for migrations.
• Schedule jobs using ESP scheduler.
• Lead and coordinate with Product owner, Business Analysts and responsible for Deliverables.
• Schedule daily scrum meetings with team members to assign and update tasks following Agile methodology.
• Provide estimations to Scrum Master for development tasks.
• Plan and Define Sprint, user stories/tasks in Rally.

Confidential

Production Support Onshore Lead

Environment: Informatica, Oracle11g, Actuate, SQL, Linux

Responsibilities:

• Lead the migrations, Release tasks and validations post release.
• Lead the offshore team and was responsible for defects resolution and coordinate with other teams.
• Took the entire responsibility of the support team after immediately handed over and be able to address the application and administration issues within the agreed SLAs.
• Taking the challenge to lead the team of 10 members.
• Initiate and involve partner teams during down time.
• Provide root cause analysis to client for issues or down time.
• Monitor server load during push notifications and involve teams during issues.
• Responsible for the daily files sent to Partners (ATT, TMO, and Verizon).
• Responsible to keep the servers up and running (Oracle WebLogic Server, Narcissus, Oracle Enterprise Manager 11g, Oracle Service Bus 11gR1).
• Scheduled Cron job to Generate hourly wallet activation report and sent to client managers.
• Plan and schedule oncall and weekend support for team members.

Confidential

Conversion Developer (ETL)

Environment: Informatica 9.5.1 Oracle11g, SQL, PL/SQL, SqlDeveloper, Linux

Responsibilities:

• Involve in Requirements gathering, Analysis, Design and Development of Data Conversion procedures.
• Design and Implement the Architecture.
• Modelling of Landing and Staging Data Schemas for Conversion.
• Worked with Subject Matter Experts to understand Medicaid program and flow.
• Accountable for all the critical/key deliverables to the client.
• Creation of technical Design Specifications & Mapping document.
• Involved in designing and developing mappings on Informatica for data conversion.
• Developing Informatica ETLs for transforming data from legacy to target tables/fields.
• Developing data validation and data reconciliation SQL queries to confirm appropriate transformation of data and identify issues in source data for cleanup.
• Co-ordinate with Business Analysts to understand the requirements.
• Participating in code reviews and peer reviews.
• Escalating issues to management as identified.
• Improved performance of ETL jobs through various means like modifying the jobs, increasing data/index cache size, tuning SQL queries, table and Informatica partitioning, etc.
• Fixing conversion defects identified during testing.
• Assist Functional Lead with design, build and test activities for a Project Phase or Program.
• Migrate ETL objects across environments.

Confidential

Informatica Developer

Environment: Informatica 9.1, Teradata, Toad, SQL, PL/SQL, Unix, HarvestClear Quest, ALM.

Responsibilities:

• Worked as an Informatica Admin for Offshore.
• Co-ordinate with Business Analysts and onsite team members to understand the requirements.
• Estimate hours for the development work.
• Worked on various projects like RX ODS, CAPS, EDPS, CSPT & Health Partner.
• Understand the requirements of the existing business process and develop mappings.
• Extract data from OSCAR, TUAL, MEDCO, RX sub systems and load into flat files which are later FTP’d to Mainframe systems.
• Worked on Inbound & Outbound Processes in EDW.
• Create design documents and UTP for the code developed.
• Created Unix script to generate Balance reports and email notifications.
• Resolve the defects after the code migrated to QA and PROD.
• Perform peer reviews and assist

Confidential

Informatica Developer

Responsibilities:

• Requirements gathering and gap analysis.
• Coordinating with the functional team.
• Worked as an ETL Developer for MDM and BAW modules.
• Good understanding and knowledge on integration from various source systems.
• Extracted data from Seibel source system and loaded into BAW warehouse.
• Customized BAW warehouse as per requirements.
• Worked on DAC and have done required configuration for Siebel Sources.
• Created different Execution Plans in DAC.
• Worked on ALM Tool.

Confidential

Informatica Developer

Responsibilities:

• Understand the design and develop the application.
• Worked on different Building Blocks (BBL’s), using PATTERNS.
• Created new Mappings & Workflows using Informatica to implement business logic.
• Prepared ETL Build Peer Review Checklist for different BBL’s and workpackages.
• Complete the Unit testing on the developed components.
• Verify the design integrations and data flow.
• Managing the team during the development and testing phase by providing technical inputs whenever required.
• Prepare technical documentation for the custom components.

Confidential

Informatica Developer

Responsibilities:

• Worked on the Enhancement projects and prepared HLE, LLD and UTP documents based on BRD.
• Effectively complete the month end ETL processes and worked on problem tickets.
• Involved in up gradation of Informatica 7.1 to 8.1.
• Efficiently completed the daily and weekly DW load within the SLA time limit and also attended the service requests.
• Preparing test cases for the ETL Projects.
• Executed test cases using Test Director.
• Developed Mappings & Workflows.
• Working on Ad-hoc requests.
• Delivering all deliverables related to data warehouse load within the SLA limit.
• Updating client with monthly, weekly, daily Load status and SRM (Server Resource Management) reports.
• Worked as a Primary oncall support member.

Confidential

Crystal Report Developer

Responsibilities:

• Interacting with client and analyzing the requirements.
• Modified the existing reports to suite the requirements.
• Extensively used calculations in the reports.
• Identifying the links between the source tables.
• Preparing the snapshots for the reports.
• Involved in manual testing and database testing.
• Created complex Metrics.
• Designed and Developed the Reports as per the client requirements.