OBJECTIVES:

With sound professional knowledge and creativeness, I aspire to serve an organization with sincerity and determination to succeed. I aim to occupy a responsible and challenging position in an organization by keeping abreast with the latest developments in the area of Software Technology.

SUMMARY:

• Having 9+ Years of experience in Software Development, Enhancements, Migrations and support, DB Testing, Big data, Report testing and Working as Data Analyst Lead.
• Holding valid H1B Visa
• Having extensive experience in analysis, design, development and implementation of Data Warehouse/Data Marts and also having extensive knowledge on Data Modeling concepts
• Having experience in Informatica,Teradata Oracle, UNIX and Project Management
• Having experience in Hadoop - Hive data validations
• Having experience in Informatica IDQ & IDE
• Cross-functional experience in handling large scale delivery assignments in various domains like health care, Media and Entertainment, Retail and Telecom and Pharmacy.
• Managed Project Estimation, Initiation, Preparation, Execution and Closure
• Addressing Risk, Issues/Concerns of the Client and Team and Resource forecasting
• Planning, tasking, delegation, monitoring, feedback, skill upgrade, competence management, career planning, motivation & mentoring of the team.
• Preparing and participating in Management Review
• Requirements Gathering & Understanding
• Arranging and conducting trainings (Technical and Non Technical)
• Experience in creating High Level Design Documents, Low Level Design Documents and End to end traceability matrix.
• Maintained the version control with different tools
• Informatica- ETL Testing using Toad and TIDAL
• Validation of Reports against data in the tables.
• Validation of Stage, Prep and Warehouse tables in data warehouse
• Validating the ETL processing (Dimension tables and Fact table) In SQL querying
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator
• UAT support
• Update and track sprint activities in Version One tool for scrum management.
• Providing projects status on daily basis, Weekly basis status to stake Managers
• Status reporting to the stake holders on daily and weekly basis
• Prepare the lesson learned documents based on the previous defects.
• Worked on RFPs and Pre-Sales activities
• Managed large size teams for various domains

TECHNICAL SKILLS:

Operating System: Windows, MS-DOS.

Languages: C, C++

Databases: Oracle, SQL server 2005, Teradata

ETL tools: ETL Concepts, Informatica, and Hadoop

Scripting Languages: HTML.

Testing Tools: Quality Center.

SOFT SKILLS:

• Analytical and logical problem solving abilities
• Good at planning, organizing events
• Willing to learn and apply my knowledge to practical situations.
• Team facilitator with good communication and interpersonal skills
• Ability to adapt any kind of Environment

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

Environment: Informatica, Teradata, Hadoop

Responsibilities:

• Requirements Gathering & Understanding
• Experience in creating High Level Design Document, Low Level Design document.
• Validation of Reports against data in the tables.
• Validation of Prep Dispatch and Warehouse tables
• Defect Tracking & Code Drop.
• Conducted functional testing and regression testing
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator
• UAT support
• Working as an Onsite coordinator to coordinate with onsite and offshore team members to assign and to finish the task as per the schedule dates.
• Updating and tracking sprint activities in Version One tool for scrum management.
• Providing projects status on daily basis, Weekly on status calls to Delivery Managers
• Prepare the lesson learned documents based on the previous defects

Confidential

ETL Lead

Environment: Informatica, Teradata and Oracle

Responsibilities:

• Requirements Gathering & Understanding
• Delivering CSR RR intake items, Work logs for various Development and Enhancement releases.
• Development and Enhancement of Informatica mapping and B-teq scripts.
• Analysis, Planning, work distribution for the team.
• Maintaining and updating Application Knowledge Document, Knowledge Transition Plan during Initial phase of project.
• Building team, maintaining resources for the CSR project at Offshore.
• Responsible for Production failure resolution, Process and application level analysis, back tracking of data issues.
• Assisted team members by providing process, application and technical guidelines.
• Responsible for fixing Audit balancing control data issues which caused the data issues. Interaction with Client, Developers, Onsite Coordinator
• UAT support

Confidential

ETL Lead

Environment: Informatica, Teradata and Oracle

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Determine Data Warehouse based on requirements & use cases for the application
• Work with the integration solution architects & designers to design the integration solution
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards
• Development of new Informatica mappings and workflows
• Enhancements to the existing Informatica mappings
• Development of shell scripts
• Development of PL/SQL procedures
• Analysis and troubleshooting L3 issues
• Optimization of the code to speed up execution and completion of the loads
• Assisting fellow team members in their technical deliverables

Confidential

ETL Lead

Environment: Oracle, Informatica

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Analysis of source files (XMLs) and developing the different hierarchies.
• Analysis of different source systems like DSET, Lasso and Phone home and prepared the mappings to load in to their respective targets.
• Determine Data Warehouse based on requirements & use cases for the Application
• Comparing XML data against XSD schema and validating them by using stored procedure
• Work with the integration solution architects & designers to design the integration solution
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards

Confidential

ETL Lead

Environment: Oracle, Informatica

Responsibilities:

• Understanding the requirements associated with the application.
• Involved in migrating the data from landing to target.
• Involved in writing the stored procedures and packages for data migration.
• Analyzing the data and table structure, Creating a scripts for data migration from landing to staging.
• Involved in verifying the migrated data in Metasolv
• Involved in migrating different entities(Locations, Equipment, Circuits, De-sign Lines etc..) from landing to target
• Review the database deliverables throughout migration to ensure quality & tractability to requirements and adherence to all quality management plans & standards

Confidential

ETL Lead

Environment: Informatica, Oracle

Responsibilities:

• Understanding the requirements associated with the application & Data Warehouse and analyzing the same for providing complexity and estimation.
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center 9.0.1
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse De-signer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• Deployed the mapping to create the parameter files for each run.
• Created the shell scripts to update the files. Using that file loaded the data by chunks.
• As a lead, I managed successfully a team of two developers

Confidential

ETL Technical Lead

Environment: Informatica, Oracle

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Understand changes to the Warehouse & the impact to the existing Data warehouse
• Determine Data Warehouse changes based on requirements & use cases for the Application
• Identify and address application data issues that affect application integrity
• Work with the customer, users, technical architect, and application designers to define the data requirements & structure for the application
• Work with the integration solution architects & designers to design the integration solution
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards.

Confidential

ETL Developer

Environment: Informatica, Teradata

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Understand changes to the Warehouse & the impact to the existing Data warehouse
• Determine Data Warehouse changes based on requirements & use cases for the Application
• Ensure alignment between the Data Warehouse & the Enterprise Information as well as the Enterprise Information Architecture
• Identify and address application data issues that affect application integrity
• Work with the customer, users, technical architect, and application designers to define the data requirements & structure for the application
• Work with the integration solution architects & designers to design the inte-gration solution
• Ensure that the database designs fulfill the requirements, including data vol-ume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards.

Confidential

Technical Lead

Environment: Informatica, Oracle

Responsibilities:

• Understanding the requirements associated with the application & Data Warehouse and analyzing the same for providing complexity and estimation.
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center 9.0.1
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse De-signer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• Deployed the mapping to create the parameter files for each run.
• Created the shell scripts to update the files. Using that file loaded the data by chunks.
• As a lead, I managed successfully a team of two developers

Confidential

Software Developer

Environment: Informatica, Oracle

Responsibilities:

• Understand requirements associated with the application & Data Warehouse
• Understand changes to the Warehouse & the impact to the existing Data warehouse
• Determine Data Warehouse changes based on requirements & use cases for the Application
• Identify and address application data issues that affect application integrity
• Work with the customer, users, technical architect, and application designers to define the data requirements & structure for the application
• Work with the integration solution architects & designers to design the integration solution
• Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and long-term data growth
• Review the database deliverables throughout development to ensure quality & tractability to requirements and adherence to all quality management plans & standards.