PROFESSIONAL SUMMARY:

• 16 years of extensive experience in Design, Development, and Implementation in software Industry
• Completed Training and a project at Simililearn on Big Data Hadoop and Spark Developer
• Knowledge of setting Apache Hadoop cluster and Cloudera Cluster using High Availability - failover and commissioning and De-commissioning of Nodes.
• Completed Big Data Hadoop Administrator training at Simplilearn.
• Good experience in ETL architecture, design and providing solutions for business needs.
• Extensive experience in ETL using data from various sources into Data Warehouses using Informatica PowerCenter (Repository Manager, Designer, Workflow manager, Workflow Monitor).
• Experience in building the Audit balancing and exception handling frameworks.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Hands on experience in data warehousing techniques such as data cleansing, Surrogate key assignment, Slowly Changing Dimensions SCD TYPE 1, SCD TYPE 2 and Change Data Capture (CDC)
• Knowledge, understanding, and experience in Entity Relationship, Multidimensional - Star and Snowflake schema model.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Expertise in creating Transformations, Mapplets, and Mappings using Informatica Designer and Workflows, Worklets, and Tasks using Workflow Manager to move data from multiple sources into targets.
• Follow the HIPAA compliance which designing, accessing and storing the data.
• Used Job Scheduler tools like Maestro.
• Exposure in on Microsoft Business Intelligence - SSIS
• Exposure in Informatica IDQ.
• Experience in UNIX shell scripting to support the ETL process.
• Good knowledge of Validation testing procedures and processes, Software Development Life Cycle (SDLC) and QA Life Cycles.
• Efficiently interacted with developers and product analysts regarding testing status and Defect Tracking.
• Coordinated successfully with business users in analyzing and identifying the scope of the product releases. Participated in Requirement Analysis, reviews, working sessions to understand the requirements and system design.
• Excellent communication skills with keen analytical ability. A highly-motivated professional with proven success in leading Data warehousing projects.

TECHNICAL SKILLS:

Programming Languages: C, C++, PASCAL, JAVA, J2EE, UNIX Shell Scripting, PL/SQL

Tools: Informatica 8.5, Informatica 9.5.1, Power Builder 6.5/7.0/9.0,10.0, Visual Basic 6.0, TOAD, MS VISUAL STUDIO, MS VISIO

Databases: Oracle 8i/9i., Sybase 12.5, SQL Server 2005, DB2, Teradata 13.1, Oracle 10g/11g.

Web Technologies: ASP, VB Script, JavaScript

Big Data Hadoop ecosystem: Apache Spark & Scala., Python, HDFS, YARN, Sqoop, Hive, Pig, KAFKA, and HBase.

Hadoop Administrator: Apache Hadoop Cluster and Cloudera Cluster

Operating System: Windows 2000/NT/95/98/XP,VISTA,Windows 7, Windows 10.

EXPERIENCE:

Confidential, Monroeville, PA

ETL Solution Specialist

Responsibilities:

• Analyzed the requirements.
• Provided Architecture solution to support the business needs.
• Design and developed ETL solution to migrate all the patient.
• Interacting with 13 different upstream and downstream teams and explaining architecture and design changes.
• Worked closely with Confidential business team and Voyager team to prioritize the epics and features as per project goals and requirements and provide feedback on correctness, completeness with respect to Development and testability.
• Responsible to support QA team to perform testing.
• Worked with lead Business analyst to identify the Voyager source systems.

Confidential, Monroeville, PA

Tech Lead

Responsibilities:

• Analyzing and Understanding the existing functionality and review of new requirement present in BRD, FRD and NFR
• Provide ETL Designed and solution to load the claims data.
• Combining the business requirements and existing functionality and providing solution into the new system.
• Worked with the client to perform extensive validation on the target system.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/9.5.1 to load the data from staging tables to Target Tables.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Architecture, design and developed the ETL process as per the business needs.
• Worked closely with Confidential project management team to prioritize the epics and features as per project goals and requirements and provide feedback on correctness, completeness with respect to Development and testability.
• Responsible for requirement analysis in support of development efforts.
• Worked with lead Business analyst to identify the source systems.
• Worked with client team while creating designing document.

Confidential, Monroeville, PA

Tech Lead

Responsibilities:

• Understanding, Analyzing and review of new requirement present in BRD, FRD and NFR
• Responsible for understanding the business needs and providing solution architecture and design as per the business requirement.
• Worked closely with Confidential project management team to prioritize the epics and features as per project goals and requirements and provide feedback on correctness, completeness with respect to Development and testability.
• Responsible for requirement analysis in support of Data Warehousing efforts.
• Worked with lead Business analyst to identify the source systems.
• Worked with client team while creating designing document.
• Performed Data cleansing and data scrubbing on the source systems.
• Extensively used ETL Tool Informatica to extract data from source system into Flat Files and from Flat files to Staging area and then applying transformation logics to load into target system.
• Worked with the client to perform extensive validation on the target system.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/9.5.1 to load the data from staging tables to Target system.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Creating reusable sessions for Audit balancing and validating the counts of the loads.
• Used Maestro scheduler to process jobs and implemented them successfully.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy.
• Created events and tasks in the work flows using workflow manager.
• Created sessions and arranged them in various workflows in the workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Confidential, North Brook, IL

Tech Lead

Operating Systems: Microsoft Windows XP

Software & Tools: Informatica (Power Center 9.5.1), Oracle 11g Subversions, Toad for Oracle, UNIX, Maestro job scheduler

Responsibilities:

• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of load processes and Data transformation processes.
• Designing the process for extract, staging and transforming the data to store in the Data warehouse.
• Understanding all three different source systems and extracting data for all three different source systems into Flat files and from flat files into staging area and then staging to Data warehouse.
• Created Technical Specification documents and maintaining the specification documents throughout development lifecycle.
• Extensively used ETL processes to load data from source systems in different databases into target systems, by applying business logic on transformation mapping for inserting and updating records when loaded.
• Wrote shell scripts to perform Repository backup, logs cleanup, on regular basis and automated the daily load process across the systems.
• Worked with mappings that moved data by the Slowly Changing Dimensions (SCD-2). Hence worked on movement of the new and updated data.
• Used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Developed SQL scripts as per the business requirements.
• Changed and validated session properties and connections such that they now point the data to all different source system.
• Performed Unit testing for all processes and maintained the unit test logs.
• Used Maestro scheduler to insert the process jobs and implemented them successfully after checking for all errors.
• Created artifacts list to migrated changes to SIT (System Integration Testing) and then to production. Artifacts list consists of changes to database objects, informatica objects, flat files, sandbox scripts, frame work, job scheduler and Meta data migration scripts.
• Worked with SIT team to create test data for SIT purpose and supported them in migration to production.
• Provided primary on-call production support for all enterprise Informatica environments.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Confidential, Minneapolis, MN

Tech Lead

Operating Systems: Microsoft Windows XP

Software & Tools: Informatica (Power Center 9.5.1), Teradata Subversions, SQL navigator for Teradata, UNIX

Responsibilities:

• Interacted with various business team members to gather the requirements and documented the requirements.
• Developed and maintained the technical design documents of ETL process.
• Performed data analysis and worked with System owners to resolve source data issues.
• Designed and built ETL processes to extract and load high volume of data from different source systems such as Mainframe, RDBMS, and Flat Files.
• Having a thorough understanding of these current and potential requirements and helped the Data Architect and Project Manager to design a flexible and scalable solution that meets the needs of the business.
• Developed reusable transformations, mapplets and shortcut to prevent redundancy.
• Created Deployment Group and performed objects migration.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Effectively balance and prioritize multiple projects concurrently.
• Created and executed unit tests on all solutions, worked with Data analysts and QA team to ensure solutions are well tested, production ready and well documented.
• Provided primary on-call production support for all enterprise Informatica environments.
• Trained internal employees on Informatica and got them to the pace of development.

Confidential, Minneapolis, MN

Team member

Operating Systems: Microsoft Windows XP

Software & Tools: Informatica (Power Center 8.6), DB2, Unix, SQL navigator.

Responsibilities:

• Interacted with various business team members to gather the requirements and documented the requirements.
• Developed and maintained the technical design documents of ETL process.
• Performed data analysis and worked with System owners to resolve source data issues.
• Designed and built ETL processes to extract and load high volume of data from different source systems such as Mainframe, RDBMS, and Flat Files.
• Having a thorough understanding of these current and potential requirements and helped the Data Architect and Project Manager to design a flexible and scalable solution that meets the needs of the business.
• Developed reusable transformations, mapplets and shortcut to prevent redundancy.
• Created Deployment Group and performed objects migration.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Effectively balance and prioritize multiple projects concurrently.
• Created and executed unit tests on all solutions, worked with Data analysts and QA team to ensure solutions are well tested, production ready and well documented.
• Provided primary on-call production support for all enterprise Informatica environments.
• Trained internal employees on Informatica and got them to the pace of development.
• Extensively used PL/SQL, TOAD for creating views, stored procedure, and indexes on the tables.

Confidential, Minneapolis, MN

Tech Lead

Operating Systems: Microsoft Windows XP

Software & Tools: Power Builder 11, Oracle 9i, C++, JAVA

Responsibilities:

• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of individual modules.
• Created Technical Specification documents using and maintained Technical specification documents throughout development lifecycle.
• Production Support, which involves tickets solving and SLA meeting.
• Application development, which involves estimation, coding and testing individual module.
• Distributing work among the Team members.
• Tracking all the work done by offshore team members.
• Reviewing the Design and Code done by offshore team members.
• Analyzing and fixing the bugs.
• Providing timelines for the reported bugs.

Confidential

Release Engineer

Operating Systems: Microsoft Windows XP

Software & Tools: Power Builder 9, Oracle 9i

Responsibilities:

• Primary responsibility is Release Engineering.
• Preparing builds for various applications used in Confidential .
• Analyzing and solving defects related to builds using Install shields.
• Testing the Build correctness and readiness.

Confidential

Team Lead

Operating Systems: Microsoft Windows XP

Software & Tools: Power Builder 9, Oracle 9i

Responsibilities:

• Production Support, which involves tickets solving and SLA meeting.
• Application development, which involves estimation, coding and testing individual module.
• Distributing work among the Team members.
• Tracking all the work done by team members.
• Reviewing the Design and Code done by the team members.
• Analyzing and fixing the bugs.
• Providing timelines for the reported bugs.

Confidential, Minneapolis

Team Lead

Operating Systems: Microsoft Windows XP

Software & Tools:Power Builder 9, Oracle 9i

Responsibilities:

• Application development which involves estimation, coding and testing individual module.
• Preparing the Design and Test case documents.
• Analyzing and fixing the bugs.
• Providing timelines for the reported bugs.

Confidential

Team Lead

Operating Systems: Microsoft Windows XP

Software & Tools: Power Builder 9, Oracle 9i

Responsibilities:

• Involved in analyzing the code and preparing business logic.
• Reviewing documents prepared by another team member and providing a consolidated document to the client.