PROFESSIONAL SUMMARY:

• Around 13+ years of experience in Information Technology with strong ETL background including 7+ years overseas project exposure in US.
• Certified by Paxata (Analyst /Admin), Splice Machine, Microsoft & Informatica.
• Extensively working with Paxata - Data preparation tool integration to use Paxata in all business requirements with Splice machine, HDFS, Oracle, etc
• Extensive experience in analyzing the data and produce adhoc reports as per the business needs and use paxata, Splicemachine and self-servicetools using SQL to deliver.
• Experience in requirements gathering and analysis, design, development, testing and validation in Data centric projects (data bases, data warehousing and business intelligence space).
• Experience leading small and medium sized Data warehousing and Business intelligence engagements and mentoring junior or associate consultants.
• Experience in Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables using ER Studio (embarcadero).
• Strong knowledge of ETL Tools (Informatica, Talend), Netezza, Oracle Exadata, Teradata and UNIX Shell Scripting
• Experience in all aspects of Software development life cycles including Requirement gathering, Data Analysis, System Design, Development, Testing, Implementation and Production Support of Data Integration/ETL.
• Good experience with Data Extraction, Transformation, and Loading from data sources like Flat Files, Databases & XMLs for Data Integration.
• Skilled in Unit Testing, Regression Testing, System Integration Testing and User Acceptance Testing (preparing test plan, test cases, validation, etc.)
• Experience in Effort Estimations, Planning & Execution of Data Integration Projects
• Worked in different Project methodologies such as Agile, Waterfall, etc. Currently working in Agile methodology for last 5+ years
• Worked in Agile Methodology tools like Rally & JIRA, and worked as Scrum Master for more than 6 months.
• Efficient in handling teams both at work-site / remote locations, and exposure in handling Japanese projects.
• Experience in coordinating with different stake holders of a project, both from Business (Program Managers, Sponsors) as well as Technology (DA, DBA, EIA, BSA, etc)
• Self-Motivated to adapt and learn fast with excellent analytical, & problem solving skills along with good communication skills.
• Sound experience in mentoring/leading a team in Onsite- Offshore model project execution.

TECHNICAL SKILLS:

Big Data: Paxata, Thoughtspot & Splice Machine Analysis Tools: ER Studio, Toad Data Point (Profiling)

ETL Tools: Talend 4.x, Informatica PowerCenter 8.1/8.5.1.

Operating Systems: Windows 9x/XP/NT, DOS, UNIX AIX, Linux

Languages: SQL, HTML, C#, Asp.Net, ADO.Net and Php

Databases: Netezza 7, Exa data, Oracle 8, PL/SQL, Teradata 13.1

Scripting Languages: UNIX Shell Scripting, Perl

Practices: CMMI, Agile Methodologies

Scheduler: Autosys, Autobatch & Control M

WORK EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Working as Analyst, involved in all Analysis activities like identifying the business elements and mapping the logical data elements as per the needs.
• Working on POC with Paxata in all the business related requirements.
• Performed Data analysis and Data Profiling to understand the user requirement and work with ETL tech leads to load the data to tables and creating view to provide the data to business.
• Interacting with Business System Analyst and SOR SME support to get involved in the analysis to get the better data mapping for the requirements.
• Provide technical support and leadership for data discovery, analysis, and documentation.
• Performing all the Data analysis work as per the Agile methodology in the project.
• Lead the offshore team and onshore team to deliver business solutions within the agreed SLA's.

Environment: Splice Machine 2.5, Hadoop Framework, Paxata 2.19

Confidential

Sr Data Analyst / Scrum Master

Responsibilities:

• Working as Analysis team lead, involved in all Analysis activities like identifying the business elements and mapping the logical data elements with MISMO data descriptions.
• Working with Dimensional Data Modeling using Star, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling using ER Studio.
• Performed Data analysis and Data Profiling to understand the user requirement and designed ETL solutions accordingly.
• Interacting with Business System Analyst and SOR SME support to get involved in the analysis to get the better data mapping for the requirements.
• Working as a Data modeler to implement the Logical & Physical data elements and creating the high level design.
• Working as a Data Profiler to profile the data and ensure the Data model is intact.
• Participated in Joint Application Development (JAD) sessions with project sponsors, end-users, development team members, subject-matter experts and stakeholders to communicate their perspectives with each other, resolve any issues and come to consensus.
• Led the offshore team and onshore team to deliver business solutions within the agreed SLA's.

Environment: ER Studio, MDR(Meta Data Repository), Oracle Exadata

Confidential

Technology Lead / Data Analyst

Responsibilities:

• Worked as a BAU team lead, involved in all BAU activities like providing fixes for any Batch issues, Maintenance activity, small enhancements, etc.
• Involved in Netezza and Talend Code developments.
• Involved in Release management activities like engaging with prod support team and CAB to ensure the smooth transaction with everyone without impacting the users.
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team
• Worked efficiently even in tight deadlines.
• Good experience in UNIX writing shell scripts, performance tuning on database and Job Scheduling.
• Interacting with Business to provide SME support on these applications
• Working with Production support team for issue management and resolution

Environment: Linux, Talend 8 and Netezza

Confidential

Technology Lead

Responsibilities:

• Involved in creating ETL objects(mappings, mapplets, sessions, workflows) & Performance Tuning in Informatica.
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team.
• First Data Integration project executed out of shanghai, china with India offshore support.
• Involved in engagement activities such as estimation, schedule, scope define etc.,
• Tracking project budget, resource structure, project status, reporting status report to business, issue tracking & resolution, optimal decision on roadblocks in the project life cycle
• Effective co-ordination between the large numbers of interfacing groups (10+ source systems and other internal/external stakeholders)
• Proposed implementation process with streamlined plan and staggered approach
• Worked efficiently even in tight deadlines.
• Involved in Analysis, Design, Build, Testing, Fixing Technical Issues in Informatica
• Coordinated with QA team during QA and Preproduction testing process for the project.
• Extensively worked on Performance Tuning to enhance the quality of project for all current code development
• Interacting with Business to provide SME support on these applications
• Implementation, Rollout, Working with Production support team for issue management and resolution
• Experience in preparing Project documents, Installation documents and migrations documents.

Environment: Unix AIX 5.2, Informatica Power Center 8.5/9.1, Power Exchange, IBM TWS, DB2, Oracle, Unix Scripts, MFT connect direct

Confidential

Onsite - Technology Lead

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team
• Involved in creating ETL objects (Mapping, Mapplets, sessions & workflows) in Informatica.
• Participated in creating a conceptual data model & logical data model for the data mart based on the interactions with the team
• Involved in Analysis, Design, Build, Testing, Fixing Technical Issues in Informatica
• Involved in engagement activities such as estimation, schedule, scope define etc.,
• Proposed implementation process with streamlined plan and staggered approach
• Worked efficiently even in tight deadlines.
• Optimization of Informatica mappings using various components like Parameter files, Variables and Dynamic Cache, for real time sync
• Unix scripts and Informatica reusable components build
• Troubleshooting Technical Issues, Fixing Application level Bugs
• Testing support, Implementation.
• Extensively worked on Performance Tuning to enhance the quality of project for all current code development

Environment: Unix AIX 5.2, Informatica Power Center 8.5/9.1, Power Exchange, IBM Control M, DB2, Oracle, Unix Scripts, Mainframe, MFT connect direct

Confidential

Technology Lead

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team
• Participated in creating a conceptual data model & logical data model for the data mart based on the interactions with the team
• Involved in Analysis, Design, Build, Testing, Fixing Technical Issues in Informatica
• Involved in engagement activities such as estimation, schedule, scope define etc.,
• Handling environmental issues and resolving them by coordinating with Informatica Support
• Optimization of Informatica mappings using various components like Parameter files, Variables and Dynamic Cache, for real time sync
• Unix scripts and Informatica reusable components build
• Testing support and Implementation
• Extensively worked on Performance Tuning to enhance the quality of project for all current code development
• Involved in creating ETL objects (Mapping, Mapplets, sessions & workflows) in Informatica.

Environment: Unix AIX 5.2, Informatica Power Center 8.5/9.1, Power Exchange, IBM Control M, DB2, Teradata, Unix Scripts, Mainframe

Confidential

Technology Lead

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts and End users
• Involved in System study and delivered the System Appreciation Documents as the first part of delivery.
• Defining system requirements using business user requirements
• Involved in Analysis and Design of the cashering automation.

Environment: Windows C#.net, VS 2005, Sql Server 2005.

Confidential

Technology Lead

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team
• Participated in creating a conceptual data model & logical data model for the data mart based on the interactions with the team
• Involved in Impact Analysis, Build, Testing, Fixing Technical Issues in Informatica
• Involved in engagement activities such as estimation, schedule, scope define etc.,
• Handling environmental issues and resolving them by coordinating with Informatica Support
• Performed “performance testing” in Pre-Prod environment for Informatica mappings
• 24 x 7 test support and coordination
• Optimization of Informatica mappings using various components like Parameter files, Variables and Dynamic Cache, for real time sync
• Unix scripts and Informatica reusable components build
• Testing support and Implementation
• Extensively worked on Performance Tuning to enhance the quality of project for all current code development

Environment: Unix AIX 5.2, Informatica Power Center 8.5/9.1, Power Exchange, IBM Control M, DB2, Oracle, Unix Scripts, Mainframe

Confidential

Technology Lead

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team
• Involved in Analysis, Build, Testing, Fixing Technical Issues in Informatica
• Involved in engagement activities such as estimation, schedule, scope define etc.,
• Handling environmental issues and resolving them by coordinating with Informatica Support
• Performed “performance testing” in Pre-Prod environment for Informatica mappings
• Optimization of Informatica mappings using various components like Parameter files, Variables and Dynamic Cache, for real time sync
• Unix scripts and Informatica reusable components build
• Testing support and Implementation

Environment: Unix AIX 5.2, Informatica Power Center 8.5/9.1, Power Exchange, IBM Control M, DB2, Oracle, Unix Scripts, Mainframe

Confidential

Technology Lead

Responsibilities:

• Involved in collecting and understanding the requirements of the business users and corporate managers throughout the project
• Coordinated with different Stake-Holders like the Enterprise Portfolio Architect, Data Architects, Database Administrators, Business System Analysts, Development & Testing Team
• Involved in Analysis, Build, Testing, Fixing Technical Issues in Informatica
• Involved in engagement activities such as estimation, schedule, scope define etc.,
• Handling environmental issues and resolving them by coordinating with Informatica Support
• Performed “performance testing” in Pre-Prod environment for Informatica mappings
• Optimization of Informatica mappings using various components like Parameter files, Variables and Dynamic Cache, for real time sync
• Unix scripts and Informatica reusable components build
• Testing support and Implementation

Environment: Unix AIX 5.2, Informatica Power Center 8.5/9.1, Power Exchange, IBM Control M, DB2, Oracle, Unix Scripts, Mainframe

Confidential

Software Developer

Responsibilities:

• Requirement Analysis, Design, coding, and implementation
• Involved in System study.
• Developing C#.net programs as per the requirements.
• Process adherence, interaction & co-ordination with team members

Environment: Windows, C#.net

Confidential

Software Developer

Responsibilities:

• Requirement Analysis, Design, coding, and implementation
• Involved in System study.
• Developing C#.net programs as per the requirements.
• Process adherence, interaction & co-ordination with team members

Environment: Windows, C#. Net, Asp.Net, MSSQL Server

Confidential

Software Developer

Responsibilities:

• Requirement Analysis, Design, coding, and implementation
• Involved in System study.
• Developing C#.net programs as per the requirements.
• Process adherence, interaction & co-ordination with team members

Environment: Windows, C#. Net, Asp.Net, MSSQL Server

Confidential

Software Developer

Responsibilities:

• Requirement Analysis, Design, coding and unit testing
• Developing Perl programs as per the requirements.
• Requirement Analysis, Design, coding, and implementation
• Involved in System study.
• Developing C#.net programs as per the requirements.
• Process adherence, interaction & co-ordination with team members

Environment: Windows, Perl, PHP, MySql