SUMMARY

• ETL Developer with 9 years of experience Informatica, Cassandra, Unix Shell Scripting, PL/SQL, Teradata, BO Reports.
• Strong in Data warehousing concepts Fact table, dimension table, star and snowflake schema methodologies.
• Experience in Banking & Financial Services, Health Care and Communications Domain.
• Experience as Agile as Scrum Master for 3 years and meeting up with daily stand up call.
• Continuing to learn and develop technical and functional advancements with Informatica and Cassandra Tools
• Ability to work with minimal supervision where self - reliance and lateral thinking are required
• Ability to work independently or as a team member with an analytical bent to problem solving and delivering under high stress environment Info
• Effective communication skills for coordination between globally located teams.
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
• Experience with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts.
• Experience in Unit, Functional, Integrated System Testing.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
• Experience in creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
• Experience in HP Quality Center for Bug Tracking and Defect Reporting.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Extensive experience in testing and developing of dimensional modeling (Star and Snow flake) of data warehouse using Erwin.
• Automated Testing using shell scripts and PL/SQL packages for complex scenarios in the application.
• Ability to lead end to end ETL project and team.
• Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary systems.

TECHNICAL SKILLS

Applications: DLAQM (DATA AUDIT), Uverse Data Maintenance, Confidential Data, Health Care

RDBMS: Oracle 9i/10g,MYSQl,MS Access, Teradata, SQL Server

Operating System: Windows vista, Windows 9x, Windows NT/ 2000/XP, HP-UNIX

Languages: Visual Basic6 and Unix Shell Scripting

Tools: BO Reporting, 8,Informatica 7.1.3/8.1/8.6/9.5.1/9.6 , HP ALM, Remedy User - Incident Tracking Tool, Ultra Edit, TOAD, SQL Developer, Eclipse MARS, DataStax

Version control tools: SVN

PROFESSIONAL EXPERIENCE

Confidential

Technical Architect & Development Tech Lead

Responsibilities:

• Involved in requirement gathering of various audits which is performed between data grid and data layer applications
• Developed data audit with different sources like Cassandra Cache, Oracle, Teradata, Data router files, SQL Servers, Flat files.
• Acted as Deployment Manager for moving the code from IST to UAT.
• Hands on experience BO, for the validation on audits developed using Informatica.
• Worked on Eclipse and Datastax which is an in build GUI tool to interface with Cassandra database.
• Developed mappings using Java transformation for Cassandra Interface data audit
• Worked in DataStax plugin interface in Informatica for Cassandra Interface
• Involved in estimation of various data audit modules.
• Involved in IST & UAT Testing for certifying the modules.
• Developed the design and architect for the DLAQM project of all of the audit modules.
• Implemented parallelism in work flow jobs.
• Implemented normalizer, aggregator, filter, expression and Joiner Transformations in the project.
• Played the role of scrum master following Agile Methodology.
• Coordination of system / Integration / UAT testing with other teams involved in project and review of Master test strategy.
• Involved in performance tuning of the workflows and mapping. Portioning mapping for optimal performance.
• Followed TDD (Test Driven Development) approach which includes collaborating with the testers in identifying and testing possible scenarios.
• Used Informatica Scheduler to schedule jobs.
• Responsible for sharing the delivery metrics, Status reports and defect metrics to the clients on a monthly call with details on the delivery milestone adherence, defect SLA, defect root cause, Defect root cause analysis etc.

Environment: I was a 15 member where I was involved in Analysis, Design, Development and enhancement of the DLAQM Application using Informatica 9.6, Oracle 10g, Toad, Unix Shell Scripting, SQL Developer, Eclipse MARS, DataStax, Teradata, Data Router Files

Confidential

Informatica Technical Lead/ Business Analyst

Responsibilities:

• Review of ETL Detailed design documents for Mapping and DDL specifications document for creation of tables, defining key constraints on tables and data types.
• Extracting data from various source systems like Flat Files, XML Data and then to target
• Designing mappings as per the business requirements. Using transformations such as Source Qualifier, Expression, Aggregator, Lookup, Filter, Sequence generator, Router, Union, Joiner, Update strategy etc.
• Coordination of system / Integration / UAT testing with other teams involved in project and review of Master test strategy.
• Involved in performance tuning of the workflows and mapping. Portioning mapping for optimal performance.
• Extensively used parameter file for standardizing the ETL and making it generic.
• Hands on experience with PL/SQL programming, triggers, stored procedure, functions, packages. Strong understanding implementation of slowly changing dimension.
• Used UNIX korn shell scripts to deliver the daily, weekly and monthly usage reports to various interfacing teams.
• Performed data audit between various source and target applications to find discrepancies for various projects as an added implementation for the project.
• Performed detailed documentation of design, development, testing and deployment activities necessary to ensure team knowledge sharing.
• Provided 24/7 Production support for the application and single Triage contact for a 150 member team
• Weekly interaction with the business clients in prioritizing the issues and updating the Product backlog.
• Involved in developing the Package Details information over the web for a customer tied to a Yahoo member Id.
• Involved in developing VoD data and metadata to the downstream system for customer facing Catalog maintenance
• Developed Data auditing capabilities across systems to meet the needs of the sister application called VSDA using complex Informatica Transformation.
• Developed workflows to Serve the Customer Credit limit reset computation and data movement to IPTV
• Performed root cause analysis and impact assessment for defects identified in testing and post-production and fixing the same
• Preparing the production readiness documents like deployment checklist and component list, involving in Post production change requests.
• Analyzed, Designed, Developed & Tested as per business requirement
• Lead a team of 6 developers, 4 Testers and performed development code reviews
• Designed test plans and approach to validate complex transformation logics developed in Informatica
• Provided 24/7 Production support
• Scheduled new jobs using Informatica scheduler
• Performed Unit testing and System testing on the customizations and enhancements
• Perform End to End testing of the application with integrations with various upstream and downstream interfaces.

Environment: 10-member team was involved in maintaining, customizing and enhancing the uDAS application with Informatica 9.6.1, Unix Shell scripting, Toad Data Modeler, SQL Developer, Putty, VSS

Confidential, Colorado

Techno-Functional Consultant

Responsibilities:

• Provided Support and Maintenance to the existing system
• Responsible for designing and developing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Involving in writing complex SQL queries to verify data from Source to Target.
• Experience in working with business users, App DBA’s, ETL Admins, Prod Support.
• Hosting daily scrum meetings and attending weekly keys meeting.
• Implemented SCD type-1 and SCD type-2 load strategy for the Data Warehouse
• Lead the onsite team on the high level design and responsible for data model and
• Performed detailed design and development stored proc and unix scripts of the various source system involved.
• Developed POCs (Proof of Concepts) to determine whether a particular requirement can be achieved through stored proc, scripts and sql loader to be built, arriving Confidential the design to be used for each Proc, preparing Visio diagrams and skeleton for each source, actual development of the code and performance tuning the queries, and scripts.
• Successfully completed various POCs (Proof of Concept) in oracle and Teradata to use it in the current release of IDW
• Responsible for designing and implementing process control and auditing mechanisms in the IDW release
• Responsible for assigning the daily tasks to the team members for Voice/Circuit and sending the daily status to the onsite team.
• Analyzed, solution and Test the production issues 24/7

Environment: 4-member team was involved in maintaining, customizing and enhancing the Project with Unix Shell Scripting, Informatica, Oracle 10g, Teradata.

Confidential

Informatica Technical Lead/ Business Analyst

Responsibilities:

• Involved in Release R15 to R18 from the high level design phase of the project and assisting the onsite team with the high level design and data modeling
• API testing for creating grants and validation of grants on account level.
• Provided POCs (Proof of Concepts) to determine whether a particular requirement can be achieved through Informatica, identifying the mappings, sessions and workflows to be built, arriving Confidential the transformations to be used for each mapping, preparing Visio diagrams and mapping matrix for each mapping, actual development of the ETL code and performance tuning the mappings, sessions and workflows
• Developed Informatica Power connect Web service transformations and partitioning concepts available in Informatica version 8.6.1 to use it in the current release R18
• Responsible for designing and implementing process control and auditing mechanisms in the R13 release through Informatica Power center 8.6.
• Responsible for assigning the daily tasks to the team members for billing flow module and sending the daily status to the onsite team
• Responsible for the code delivery from the offshore for billing flow module.
• Analyzing, Designing, Developing, Testing as per business requirement
• Create Functional and Technical Specifications
• Performed Unit, Integration and System testing.
• Providing Support and Maintenance to the R15 to R18
• Providing 24/7 Production support to R15 to R18 modules, involved in migration of Objects to Production as per the monthly migration schedule

Environment: 20-member team was involved in maintaining, customizing and enhancing the Informatica 8.6.1,Unix Shell Scripting, Oracle 9i PUTTY, Toad

Confidential

Developer

Responsibilities:

• Involved in the Release R11 for the data modeling and detailed design phase of the project
• Application Developer and Offshore Coordinator for Credit Limit Reset module in Release R11
• Performed research’s on the various concepts available in Informatica and efficiently implemented it.
• Performed detailed design for Credit Limit Reset module documenting the functionality of each transformation, mapping, session and workflow that had to be created as part of the development.
• Preparing Visio diagrams and mapping matrix for the mappings, developed the actual ETL code and performance tuned
• Involved in design for Credit Limit Reset module and developing the mappings helped in achieving the optimum performance of the workflows without using much of the CPU resource
• As an Offshore coordinator, providing technical assistance in Informatica to the offshore team, submitting the technical questions or any clarifications required by the offshore team to the onsite and getting the necessary solution
• Acted as delivery lead for the Credit Limit Reset module for the offshore.
• Involved in reviewing and ensuring the quality of the code using Confidential ’s internal tool AQUA.
• Tracking the team to see they adheres to both Confidential &T and Confidential ’s quality process.
• Involved in preparing best practices document for Informatica and Oracle and ensured that the developed Informatica ETL code and the Oracle database objects followed the same.

Environment: I was solely involved in Analysis, Design, Development and enhancement of the Credit Limit reset process Informatica 8.6, Oracle 9i, Toad, Unix Shell Scripting, SQL Developer

Confidential

Programmer Analyst

Responsibilities:

• development of Informatica mapping design and proposed break through approach
• Preparation of Requirement Specification document, High Level Analysis and Approach document,
• High Level Design Document, Detailed Design Document, System test plan and test procedure document and implementation plans ensuring top quality deliverables from Confidential to client and collection of project metrics
• Created File Layouts to upload the data from flat file into the database.
• Created one-time load Application Engine to load the Members YTD, QTD, MTD details to the Membership table
• Client appreciation for precise requirement gathering

Environment: 4 member team was involved in development and customization of Reports using Informatica 8.1, Unix Shell Scripting and Teradata

Confidential

Programmer Analyst

Responsibilities:

• Involved in Requirement gathering and analyzing
• Involved in Setting up the development environment for EDC and database (MYSQL) for EDC
• Preparation of prototype of the application and Designing, Coding, Testing and Deployment of the application.
• Sole person to develop an entire portal and create surveys and graphs using components
• Involvement in development, enhancements, and maintenance of EDC and performed support of the Tool.
• Performed Unit Testing, Integration Testing, System Acceptance Testing,
• Scheduled jobs in batch tool Autosys

Environment: 2 member team was involved in develop an entire portal and create surveys and graphs using SQL, Oracle 9i,MYSQL,MS Access, Visual basic6, ASP.NET 2, TOAD