SUMMARY

• Over 9+ years of IT experience with 8 years of rich experience Data Analysis, Design, Development of various business applications in different platforms in DW/BI, Integration and Data Migration with a sound knowledge of Retail Industry, Education and Communication domains.
• Have worked Sr.Developer on multiple skills such as Informatica (8.x and 9.x), SSIS, Talend Open Studio, Pentaho Data Integrator, Cognos BI Tool (10.2), Tableau & Power BI Business Intelligence and Analytics Tools, Autosys, UNIX, PL/SQL, Oracle 10g/11g, MySQL, MSSQL Server.
• Experience in report generation and data analysis with different sources using Microsoft excel, Pivots, Tableau.
• Analyzed the dashboard and reporting options on Power BI & Tableau in comparison with ANVIZENT tool to assist with a decision on a selection of appropriate dashboard tool for the client.
• Extensive professional Information Technology experience with expertise in the field of Enterprise Data Warehousing, Data Integration, and Data/Code Migration.
• Extensive exposure to Business Intelligence projects with experience in building Enterprise Data Warehouse, Data Marts, and Operational Data Stores.
• Expertise in design and development of mappings to handle all types of slowly changing dimensions SCD type 1, type2 and type3.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• Involved in designing the bottlenecks at the mapping level and, session level.
• Involved in development of Power Exchange source for CDC process.
• Involved in developing the system test cases for system testing.
• Extensive Expertise with error handling and Batch processing.
• Database experience of Oracle 11g/10g/9i, SQL Server.
• Extensive experience in Performance tuning of sources, targets, mappings, sessions and SQL queries.
• Good Experience in using Informatica Power Center ETL tool v 8.6.1/9.1.1 , Informatica Power Exchange 8 with industry best practices & knowledge in Reporting tools like Tableau & Power BI
• Solid understanding of Ralph Kimball & Bill Inmon’s Methodologies.
• Experience in dimensional modeling (Star Schema & Snow Flake Schema).
• Good Knowledge of UNIX (Solaris) systems and Scheduling tools like AUTOSYS
• Good knowledge of Oracle RDBMS v10g/9i/8i with proficiency in writing SQL queries and PL/SQL procedures.
• Extensive experience in Shell scripting.
• Familiar with Informatica IDQ Concepts, knowledge on Teradata, Big Data, and Hadoop.
• Expertise in performing Unit Testing, Integration Testing and Regression Testing.
• Knowledge with TOAD, SQL Developer and SQL Navigator, Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Tpump), SQL Server Management to test, modify and analyze data, create indexes, and compare data from different schemas.
• Excellent communication and interpersonal skills, very good team player and self - starter with the ability to work independently and as part of a team, strong effort, time management, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

• Data warehousing Technology
• Informatica Power Center (8.6 and 9.5)
• SSIS
• Talend Open Studio
• Informatica Big Data Edition 9.6.1(IDQ)
• Pentaho Data Integrator
• Informatica IDQ
• Cognos BI Tool (10.2)
• Oracle 9i and 10g
• SQL Server
• MySQL
• Autosys Scheduling Tool
• TOAD
• PL/SQL Developer
• Unix and Shell Scripting
• Microsoft Excel Macros
• Tableau & PowerBI Business Intelligence and Analytics Tool
• Knowledge on Predictive Analytics like (What-If-Analysis
• Goal Seek
• Data Table)
• Windows XP/ 2008/2007/2003/ NT/98/95
• C Language
• BigData and Hadoop 2.2.

PROFESSIONAL EXPERIENCE

ETL Developer & Data Analyst

Confidential, Waltham, MA

Responsibilities:

• Worked with client and Developed Load Strategy for loading HUB (staging area) and then DWH tables from the source repository.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment Performed low-level data analysis, cleansing activities
• Performed data profiling activities
• Interacted with Business Analysts, some end users to understand the specific use cases
• Interacted with BA team and Involved in detailed designed documents preparation.
• Worked as business analyst to analyze and compared features analysis between BI tools like Tableau, Qlickview, Sisense and Microsoft Power BI.
• Involved in feature wise testing and compatibility of different BI tools for heterogeneous Tools.
• Analysed and interprets the existing Stored Procedures, Materialized Views, Functions, and views.
• Perform data analysis and build data transformation & data mapping documents.
• Lead discussions / facilitate JAD sessions with technical developers, data modelers, and business SMEs to provide solution.
• Building Informatica Workflows using Informatica client Tools. Developed Mapping using transformation like Aggregator, Update Strategy, Lookups, Source Qualifier, Joiner, Union, Expression Source/Target Definitions and complex SQL Queries
• Performance tuning of the mappings as well as the tuning of SQL queries for better performance.
• Created Workflows, re-usable Worklets and Sessions using the Workflow MonitMatch, Merge, Comparison, Case converter etc.
• Implemented data quality rules on Hadoop HDFS and HIVE source tables using Informatica Big Data Edition Adapters in IDQ.
• Worked on preparing test cases for component testing, Supporting Testing Team.Prepared the transformation matrix for future reference. Preparing Unit Test cases for Unit Testing and assisted with QA team and UAT team for providing development support.
• During the UAT, interacted directly with business stakeholders, provided clarifications for their questions on the data and use cases
• Assisted UAT team and QA team in coming up with validation scripts to perform the validations as expected to cover all scenarios
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed Informatica Mappings.
• Technologies Involved: Informatica Power Centre 9.6, Informatica IDQ 9.6.1,Oracle 11g, PL/SQL Developer, Unix, Informatica Big Data Edition 9.6.1(IDQ)..

ETL Developer

Confidential, Atlanta, GA

Responsibilities:

• Understanding Functional view from the Onshore Technical Architects.
• Performed low-level data analysis, cleansing activities
• Performed data profiling activities
• Interacted with Business Analysts, some end users to understand the specific use cases
• Preparing the Technical Documents which includes (Technical and detail).
• Working Closely with Technical Architects on the functional requirement gathering.
• Assign task to team members with in module and coordinate with them complete assign task.
• Monitor team member’s performance and helps them when they needed.
• Works on Unix scripts which would trigger the jobs based on dependencies.
• Responsible for Coding/Development.
• Working on Informatica Workflow and mapping development and also database development.
• Working on the scheduling of the jobs, this would execute jobs based on dependencies, which saved many hours for Technical Architects.
• Monitoring all the sessions that are scheduled, running completed and failed. Debugging the workflows that failed.
• Provide Warranty period support for the projects which went live i.e. monitor and maintain the jobs scheduled.
• Extensively used the DQ transformations like Address validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Preparing Unit Test cases for Unit Testing and assisted with QA team and UAT team for providing development support.
• During the UAT, interacted directly with business stakeholders, provided clarifications for their questions on the data and use cases
• Assisted UAT team and QA team in coming up with validation scripts to perform the validations as expected to cover all scenarios
• Responsible for Unit Test Execution (Component and Assemble testing).
• Working on SQL server and Oracle which is validating the code built on Informatica.
• Came with different approach for the implementation of toughest logic.
• Working on Onsite offshore model
• During the warranty period, provided post production support to clarify stakeholders questions within the stipulated SLAs

ETL Developer

Confidential

Responsibilities:

• Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets, and report generation.
• Worked on Informatica Power Center 8.6.1 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema
• Optimized Query Performance, Session Performance, and Reliability did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Extensively used Normalizer, Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions. Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches. Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team
• Monitoring and running the jobs with help of Autosys Tool
• Analysing business impact before the production outage activity and notifying it to the business.
• Investigating and resolving the Service Now Tickets
• Monitoring and improving performance of various ETL jobs to transfer data from transaction to ODS and ODS to DWH system
• Providing technical knowledge transfer to the team.
• Analyzing business activity, developing, and deploying business solutions
• Interact with clients, understand their requirements and propose them the valuable and feasible solution
• Created asset software which can reduce repetitive tasksand Do daily Checklist for deliverables.Working in SLA / SLE timeline and met 98% expectation
• Involved in the data analysis for source and target systems and a good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Used debugger to test the mappings and unit tested mappings.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Technologies Involved: Informatica Power Center 8.6/9.1.0, Oracle 11g (SQL and PL SQL), UNIX, and Autosys.

Business Systems Analyst

Confidential

Responsibilities:

• Interact with clients, understand their requirements and propose them the valuable and feasible Confidential solutions.
• Evaluation difficulty in Confidential solutions and providing feedback to a development team.
• Managing clients and maintaining a relationship with Top level contacts and frequently attending meetings.
• Activity report generation from Confidential iCan and giving detailed analyzed pivoted report to the management for activity tracking and lead generations.
• Strategy making for new business acquisitions and involved in client presentations for new and upgraded Confidential solutions.
• RAK survey Analysis and presenting the detailed report to clients.
• To provide information about the new technology up gradations.
• Preparation of Technical Design Documents and solution presentations
• Analysis of Market comparing with competitors and assisting with the business cases.
• Planning and monitoring of product deployment
• Translating and simplifying requirements.
• Requirement analysis, management, and Communication.
• Handled client queries and provided appropriate validation reports for analysis purpose.
• Technologies Involved: Oracle(SQL), Microsoft Excel, Confidential iCan, uniFLOW