Data Developer

Name: Praveen Reddy

Email:***************@*****.***

Phone No :902-***-****

Professional Summary:

* ***** ** ** ********** in Design, Develop, Test, Analyze and Maintain various software applications

Extensive working experience in different sectors like Banking, Insurance, Health care, Retail and Financial domains

Involved in different phases of Software Development Life Cycle(SDLC)

Experience in Agile Scrum methodology of Software Development

Extensive experience in using different components of Informatica Power center

Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, SSIS/RS, Qlikview and Cognos

Experience on various relational databases like Oracle 11g/10g, MS-SQL Server 2005/2008, Sybase and Teradata

Understanding and working knowledge of Informatica CDC (Change Data Capture) Implementation

Good understanding of Star and Snowflake Schema, Dimensional Modeling, E-R modeling, Slowly Changing Dimensions(SCD) and data ware housing concepts

Expertise in Job Scheduling environments Autosys, CONTROL-M

Working experience in tuning the mapping to enhance performance

Expertise in SQL/PLSQL programming, developing and executing Packages, Stored Procedures, Triggers, Table Partitioning, and Materialized Views

Experience in UNIX Shell Scripting

Experience with Type 1, Type 2 slowly changing Dimensions

Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, designing various mappings, developing mappings, unit testing, integration testing, regression testing and UAT in development

Created the data models for OLTP and analytical systems

Established standard process for data model reviews

Reviewed and guided other data modelers

Good exposure on Apache Hadoop, Map Reduce Programming, Sqoop, Hive and HDFS

Ability to perform individually and in a group with good interpersonal and strong communication skills

Knowledge on Kerberos Authentication and Informatica process impersonation

Knowledge Andrew file system

Technical Skills:

ETL Tools

Informatica Power Center 9.5/9.1/8.6/8.1, SSIS

OLAP/BI

Cognos, Business Objects, OBIEE 10.1, Qlikview

Data Modeling

Star-Schema Modeling, FACT and Dimension Tables, Erwin Data Modeler, Visio Data Modeler

DBMS

Oracle 11g/10g/9i/8I, SQL Server 2005/2008, MS Excel, Flat Files, Teradata, Metadata, Sybase etc.

Languages

SQL, PL/SQL, T-SQL, HTML, XML, UNIX, Shell Scripting.

Operating Systems

Windows, HP-Unix, Linux

Others

MS Office Suite, Toad 9.1, Rsql, Visio, SQL Developer

Professional Experience

CGI, Halifax Aug’15-Present

ETL/Informatica Developer

Tufts Health Plan, a leader in healthcare information systems integration and healthcare solutions provides analytics, decision support, process automation and related information technology solutions that help governmental and commercial healthcare payers to improve patient outcomes, enhance market position and reduce costs. This provides direction and technical guidance for the administration of the Federal effort to plan, develop, manage and evaluate health care financing programs and policies to perform validation of payment requests from Medicare Part D Plans to the Retiree Drug Subsidy (RDS) program in releasing payments for validated requests, complete drafts of zero-dollar emails.

Responsibilities

Responsible for activities related to the development, support, implementation of ETL processes for large scale data warehouse using Informatica Power Center

Provide the Logical model & work with the DBAs in finalizing the Physical model.

Support, Setup and configure Power Center domain, grid and services(Informatica Admin.)

Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks

Oversight, analysis and implementation of advanced workflow job process design and management

Analyzed performance issues within applications/databases and make recommendations for improvement.

Worked with a team in the integration of various data sources definitions like SQL Server, Oracle, Flat Files

Created Complex packages by understanding Informatica Mappings, workflows and sessions

Analyzed the systems, met with end users and business units in order to define the requirements

Understand the prebuilt mappings and design the new mapping based on the existing standards if required

Implemented Type 2 Slowly changing dimensions to keep track of current and complete historical data.

Created sessions and batches and scheduled them on Success tasks like Email to the ETL team and Business Analysts.

Worked extensively on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions

Created and scheduled jobs using Control-M

Executed data modeling using Erwin data modeling tool

Developed automated tool for updating and running quality checks on Erwin data models

Responsible for unit testing the developed mappings and involved in UAT sessions.

Worked with Teradata utilities such as M-load, F-load, export etc. to load or extract tables.

Involved in migrating the plans from Development to Production and automating the process

Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.

Environment: Informatica Power Center 9.1/9.5,Informatica Admin.,Teradata, SQL server 2008, oracle 11g, Tidal, TOAD, Erwin Data modeler, Windows 7, Linux, CSV files, MS Excel.

Hudson Bay, Toronto Jan‘14 –July’15

ETL/Informatica Developer

Hudson's Bay Company is one of the fastest-growing department store retailers in the world. Company is a Canadian retail business group. It’s a chain of 90 department stores that operate exclusively in Canada. The purpose of this project is the creation of Sales Data Mart to study the trends of merchandise sales and also develop various reports for company's Product sale decision. I was involved in following Aspects of the project.

Responsibilities

Involved in interacting with Business Analyst in analyzing the requirements

Involved in documenting the Technical and Functional Documents like High Level Design, Low Level Design and System Specification Document.

Worked with Business analysts and the Data Base Administrator for requirements gathering, business analysis and designing of the data warehouse

Involved in building the ETL architecture and Source to Target mappings to load data into Data warehouse.

Developed ETL mappings, Transformations and Loading using Informatica Power Center

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse and then into the Data mart.

Extensively worked on Informatica Designer components, Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.

Developed various mappings to load data from various sources using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store data in target tables.

Developed mappings to load into Sales fact table.

Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse

Implemented Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Used all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing etc.

Modified existing mappings for enhancements of new business requirements

Tested Complex Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables

Used Debugger to test the mappings and fixed the bugs

Involved in performance tuning at various levels including Target, Source, Mapping, and Session for large data files.

Implement performance tuning on a variety of Informatica mappings to improve their throughput.

Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.

Involved in Unit Testing

Captured the Unit Test Results and documented the test results

Executed data modeling using Visio Data Modeler tool

Migrated Objects, mappings, workflows from DEV environment to QA environment

Created sessions, batches for incremental load into staging tables and scheduled them

Created event-wait tasks for maintaining dependencies between workflows

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

ENVIRONMENT: Informatica Powercenter 9.5.1, Oracle11g, Sybase, SQL PLUS, MS Visio, UNIX, Quality center, Visio Data Modeler, Control -M.

Laurentian Bank, Montreal Jan‘13 –Jan’14

ETL/Informatica Developer

Laurentian Bank is one of the largest financial organizations focusing on consumers and commercial clients. This DataMart is projected to Assist Sales and Marketing Department to analyze their sales and also categorize their customers based on significant portfolio of service Including checking accounts, savings accounts, personal loans and Geographical area. Using different ad-hoc analysis, Warehouse is supposed to assist in defining strategy for each customer category

Responsibilities

Designed, Developed and Supported ETL Processes using Informatica Power Center

Worked on developing complex mappings based on the business requirements

Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance

Performance tuned Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval

Created various documents including high-level design documents, mapping documents

Configuring sessions for different situations including incremental aggregation, pipe-line partitioning etc.

Performed POC’s to test the AS400 and SFDC connectors for low, medium, and high loads of data.

Designed and implemented Exception Remediation process for handling error records coming from the source.

Performance tuned Informatica code to eliminate bottle necks

Used Debugger to troubleshoot cause of failures, invalid results, if any, after running a process.

Wrote complex SQL queries in order to perform unit testing for validating output data.

Developed mappings for other Informatica ETL based projects.

Experience in using Teradata load utilities (FASTLOAD, MULTILOAD and TPUMP) to load huge volumes of data to Teradata RDBMS. Used BTEQ scripts for automating process

Environment: Informatica Power Center 9.1, oracle 11g, TOAD, Linux, Autosys, SFDC connector, Apex Data loader, AS400, Teradata, Oracle 11g, SQL server 2005/2008.

HDFC Bank, India June’11 - Dec 2012

Data Analyst/ETL Developer

HDFC Bank is India's second-largest private sector lender by assets. HDFC Bank provides a number of products and services which includes wholesale banking, Retail banking, Treasury, Auto (car) Loans, Two-Wheeler Loans, Personal loans, Loan against Property and Credit Cards. Project involved Requirement analysis, Data Profiling, Refinement of STM (Source to Target Mappings) with ETL Architect, Refinement of database structure with Data Architect, ETL Development as per HDFC standards, Unit & Regression Testing, participation in UAT (User Acceptance Testing), Bug fixing, Technical Documentation and Production deployment

Responsibilities

Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.

Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Router, Sequence generator, Expression, Filter and Rank transformations

Involved in designing of star schema to design dimension and fact tables.

Created mappings with heterogeneous sources like flat files, MS Access, Oracle databases and created targets in Oracle data warehouse using Informatica Power Center 8.6.2.

Created Source to Target mapping from design and requirement documents.

Built reusable transformations for recurring business logics and used them in multiple mappings.

Designed and developed test cases for unit and system testing.

Modified Unix Shell Scripts for executing the Informatica workflows.

Experienced in developing mappings for SCD1 and SCD2.

Created a global schema with common source and target table to be used across different data marts and implemented shortcuts to the objects within each mart folder so that it is easy to maintain and control the changes to the source and targets.

Created event raise, event-wait tasks for maintaining dependencies between workflows.

Efficiently interacted with UAT team and supported system testing and fixed bugs in mappings during QA

Phase.

Optimized or tuned mapping/ sessions during load testing in QA environment.

Designed, developed, and tested various enhancements.

Environment: Informatica Powercenter 8.6.2, DB2, Oracle 10g, UNIX,

Education and Certifications

Education:

Bachelor of Computer Science

Jawaharlal technological University

India

Contact this candidate