SUMMARY:

• Have 13+ Years Experience, Performance focused professional with broad background in analyzing, solutioning, facilitating and automating the business requirements.
• Dynamic and result driven in implementing end to end projects across industries and technology.Armed with comprehensive qualifications and experience in understanding applications/business requirements to Architect Data Warehouses for Reporting requirements.
• Well versed in ETL and Reporting concepts to optimize decisions for the business growth/expansion.
• A hardworking leader and team player with communication, problem - solving, multitasking, and technical skills.
• Very capable and enthusiastic to accept new challenges.

TECHNICAL SKILLS:

• Informatica power Center
• Informatica Cloud
• Pentaho
• Data lake
• Hadoop
• HIVE
• Impala and Big Data Oracle 9i/11g
• SQL server 2012
• SQL Developer
• Toad
• Erwin Modelling
• Sybase Power Designer
• Informatica Scheduler
• CVS
• Putty
• control M
• Unix
• HP Quality Centre
• Data Marts
• Star/Snow flake/Hybrid Warehouse
• Technical Design Document
• OBIEE
• Tableau

PROFESSIONAL EXPERIENCE:

Confidential

Systems Analyst & Associate Manager

Responsibilities:

• As Data Analyst, interacted with the client to understand the reporting requirements and model the Warehouse and Decision Support Layer for the Report development.
• Erwin data Modeler to design the conceptual, logical, and physical models for the data marts integrating into the Corporate Data Warehouse.
• Analyzed existing PL/SQL packages and converted them into tables in data warehouse, as per the business requirements.
• Used Informatica cloud to replicate Salesforce data into CDW layer.
• Worked on enhancing the performance of the jobs to reduce execution time.
• Involved with the business users during UAT process.
• Understanding the front-end applications and the OLTP functional data to design warehouse.
• Enterprise Report Design for the business using Tableau and OBIEE
• Designed the ETL processes using Informatica Power Center.
• Handled a team of 10 offshore and 5 Onshore team members effectively and make sure deliverables are completed on time.
• Worked with the Quality Assurance Team reviewing the CDW Test Cases, Regression and Data Validations for the Operational Data Store and Decision Support layer.
• Keep track of features, User stories, Tasks using Rally application.
• Build data marts for Finance, Purchase order, Purchase requisitions, Project accounting, inventory.
• Designed more than 150 tables over different subject areas for Corporate data warehouse reporting.
• Created reusable component for calculating USD computations for global financial reporting.
• Implemented and tuned SAP HANA queries to pull data from SAP for Financial reporting.

Confidential

Data Analyst & ETL Developer

Responsibilities:

• Worked with end users to understand the business requirements and business rules.
• Analyzing the functional requirements and developing design documents like HLD, LLD, S2T mappings.
• Ability to define and implement approaches to load and extract data from multiple data sources.
• Involved in creating Logical & Physical models and used Power Designer for data modeling.
• Involved in Data model reviews and validated the tables, columns and data types to meet the requirements.
• Analyzing existing database schemas and designing star schema models to support the reporting needs and requirements.
• Extensively used ETL to load data from Flat files with direct and indirect method.
• Extensively worked on tuning and improving the load time as well query processing time.
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, modifying session properties and partitioning the mapping.
• Prepare project estimates, delegation of tasks and duties to team members.
• Preparing elevated level support manual for the Ops support and transitioning the project knowledge to Support team.
• Identified opportunities for further enhancements and refinements to the ETL processes.
• Successfully lead a team of 5-7 people for multiple projects.
• Prioritized and Effectively Assigned team-level tasks.
• Responsible for coordination with QA/DBAs/ETL Admin teams.
• Perform unit testing on the module developed/changed.
• Prepare Unit Testing Results (UTRs) and Coordinate with client in getting sign-off for each module.

Confidential

Senior Software Engineer

Responsibilities:

• Understand the business requirements involved.
• Requirement analysis and coordinate between client team in case of any discrepancies or further details on requirements specifications.
• Interact directly with Client to address all the development requests
• Create detailed design document for the requirement following the quality standards
• Extracted, transformed, and loaded the data from source RRDW data warehouse to staging and staging to XML according to the business requirements.
• Developed Unix Shell scripts for running the workflows and generated parameter file using shell script.
• Develop UNIX shell scripts for the Load, Analysis, Quality check, release and delete operations involved in the project for data that does not go through the ETL process. using Perl and Korn shell scripts on DB2 database, with partitions and sub-partitions
• Assign development tasks modules wise to the team members.
• Used XML transformations to load data into XML Files for reporting purpose

Confidential

Senior Systems Executive

Responsibilities:

• Responsible for extracting, transforming and loading data from operational database (Oracle or Flat files) to Oracle warehouse database.
• Involved in development and testing of mappings (Unit testing).
• Install, configure, and backup data warehouse database and informatica repository including maintenance and tuning responsibilities
• Responsible for user support, post implementation review and maintenance.
• To troubleshoot production issues and provide prompt resolutions.
• To assist in batch monitoring and ensure smooth transaction.
• To solve and implement quick fixes to new enhancement implemented to production.
• Involved in User Data Validations using SQL queries