Manager Data

PROFESSIONAL SUMMARY:

Over *+ years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in various domains such as Banking, Insurance, Medical,Health Care, Telecom andWireless.

Over 9+years of experience in dealing with SQL and PL/SQL.

Over 9+ years of Data Warehousing experience using Informatica Power center 9.x/8.x, Informatica Power Mart 7.x/6.x, Power Connect, Power Exchange, Power Analyzer.

Expertise in Database development skills using Oracle 11g/10g/9i/8i, SQL, PL/SQLstored procedures, Functions, Packages, Triggers, Cursors, Programming and TOAD.

Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client/Server.

Experienced in complete life cycle Implementation of data warehouse.

Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.

Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).0

Extensively worked on various Data warehouse projects using Informatica Client Tools- Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer and DAC(Dynamic Access Control).

Expert knowledge in Trouble shooting and performance tuning at various levels such as source, mappings, target and sessions.

Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.

Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.

Expertise in designing and Developing complex Mappings using Informatica Power Center Transformations –Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.

Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets, Developing complex Mapplets, Worklets, Re-usable Tasks, Re-usable Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings & Workflows, Backup & Recovery,Power Exchange.

Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.

Data loading using UNIX Shell scripts, SQL*Loader.

Experience in dealing with various databases like Oracle 11x/10g/9i/8x/7x, SQL Server 2005/2003/2000,Teradata, DB2 Excel sheets, Flat Files and XML files.

Well Experienced in doing Error Handling and Troubleshooting using various log files.

Good exposure to development, testing, debugging, implementation, documentation and production support.

Expertise in developing reporting applications using Cognos8.x/6.x Components like Framework Manager, Report Studio, Query Studio, Analysis Studio, and Data Manager.

Expertise in developing web service applications using .NET and related technologies.

Experience in handling initial and incremental loads in target database using mapping variables.

Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectation.

Excellent written, communication skills and possessed analytic problem skills in evaluating business and technical processes and issues, develops and implements system enhancements to facilitate overall operations.

Education:

Bachelor of Technology, Andhra Pradesh, India

Technical Skills:

Data Warehousing

Informatica Power Center 9.6/9.5/9.1/8.6/, Informatica Power Mart 9.x/8.x/7.x/,Informatica Power Exchange 9.x/8.x/7.x, Repository Admin console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.

Data Modeling

Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, Snowflake schema, Dimensional data modeling, Snowflake modeling,

Fact Tables, Dimension Tables.

Databases/Files

Oracle 11g/10g/9i/8i, SQL Server 2008/2005,Nettezza, Teradata,DB2,Sales Force.com, Web services, XML and Flat files.

Oracle Utilities

TOAD 9.x/8.x/7.x,Oracle SQL Developer, SQL * Plus.

Operating Systems

Windows 7/vista/NT/2000/XP, MS-Dos, UNIX/ Linux.

Reporting Tools

Informatica Power Analyzer, Cognos8.x/6.x,Micro Strategy

Modeling Tools

Erwin 4.1/4.0, SQL Loader 11g/10g, ER-Studio.

Scheduling Tools

CA7, Autosys, Control-M, UC4 and Maestro.

Office Tools

MS PowerPoint, MS Word, MS Excel.

Programming

SQL, PL/SQL, T-SQL, C, C# (.NET),JAVA, HTML, ASP.NET.

Scripting

UNIX Shell Scripting, Java-Scripting, Korn Shell Scripting, Perl Scripting.

Work Experience:

PNC Bank, Pittsburgh PA Aug’15 – Till Date

Role:Sr.Informatica Developer

PNC Investment advisors have multiple systems and tools they use to understand their clients and process business. Each tool has various metrics and views but not one presents a comprehensive view of the client which can be used to ensure the client is effectively being serviced.To achieve the financial goals of the business, PNC Investments needs to ensure we are penetrating more households, we are increasing share of wallet and retaining our clients. Book of business will provide the functionality to advisors and managers to ensure they have tools and resources to service and grow their household baseThe data for Customers, Accounts and Transactional related information were extracted from multiple sources, transformed and loaded into the target database using ETL tool.

Responsibilities:

Extensively worked with the data modelers to implement logical and physical data modeling to create an enterprise level data warehousing.

Extensively used Informatica Power Center 9.6 to extract data from various sources and load in to staging database.

Designed and Developed Data mappings, Oracle PL/SQL Procedures and UNIX Shell Scripts for Data manipulations and Data Conversions.

Created and Modified T-SQL stored procedures for data retrieval from MS SQL SERVER Staging.

Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

Extensively worked with Informatica Tools – Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Power Exchange, Repository server and Informatica server to load data from flat files, legacy data.

Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.

Designed the mappings between sources (external files and databases) to operational staging targets.

Extensively worked with business analyst for ensuring the business requirements.

Developed Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design and implemented the ETL standards and procedures.

Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.

Implemented Slowly Changing Dimension methodology for Historical data.

Designing mapping templates to specify high level approach.

Extensive hands on XML import/export, deployment groups, query generation, migration using informatica repository manager.

Used Power Exchange to source copybook definition and then to rowtest the data from data files.

Change Data Capture can do using the Power Exchange.

Extensively worked on unit testing and implemented on transformations, mappings.

Created Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Coordinated between Development, QA and production migration teams.

Involved in ETL deployments and releases.

Environment: Informatica Power Center 9.6,Informatica Power Exchange 9,Oracle 11g, PL/SQL, MSSQL SERVER 2008,UNIX Shell scripting, Business Objects XI R3,DAC,Control-M Schedule, TOAD, SQL Developer,Power Exchange, Win XP, Win SCP,OBIEE

PayPal, San Jose CA Dec’13 – July’ 15

Role:Sr.Informatica Developer

Description: PayPal gives people better ways to connect to their money and to each other, helping them send money without sharing financial information and with the flexibility to pay using their PayPal account balances, bank accounts, PayPal Credit and credit cards. The project was executed in phases building up from extraction, computation logic, dimension models and populating data using Informatica.

Responsibilities:

Involved in Data modeling design, Designing specifications and Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica Power Center 9.1.

Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.

Upgraded informatica power center 8.6.1 to informatica power center 9.1.

Extensively used Informatica Power Center 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.

Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.

Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.

Finding the Informatica mappings bottlenecks and optimizing the mappings to get the best performance and tuning the SQL queries as well.

Implemented partitioning and bulk loads for loading large volume of data.

Involved in loading the data from Sources to RST (Raw Staging Tables) using Transformation and Cleansing Logic using Informatica.

Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.

Based on the requirements, used various transformations like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.

Developed mapplets and worklets for reusability.

Implemented daily error tracking and correction process using Informatica and Tidal.

Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.

Developed Informatica SCD type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.

Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.

Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.

Worked on Migration of Data warehouse in between different versions.

Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process.

Extensively used cognos 8.4 frame work studio to create reports relative to corporate business planning.

Extensive hands on Schema design, XML import/export, Scheduling, System management using Informatica.

Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power center 9.5, oracle 11g,Sales Force.com, Power Exchange, Web Services, TOAD 10.6 for oracle, PL/SQL, ER-studio, Autosys, DB2,, XML, Flat Files, Windows 7, Linux, Cognos 8.4.

HMS Holdings INC.,IRVING,TX Apr'12 - Dec’13

Role: Sr.Informatica Developer

Description:HMS is the nation's leader in cost containment, program integrity, and coordination of benefits solutions for government-funded, commercial, and private entities. Focused exclusively on the healthcare industry since our founding, HMS helps our clients ensure that healthcare claims are paid correctly and by the responsible party, and that those enrolled to receive program benefits meet qualifying criteria. The Project was in particular to integrate data from various source systems for verification and reporting purposes.

Responsibilities:

Extensively worked with the data modelers to implement logical and physical data modeling to create an enterprise level data warehousing.

Extensively used Informatica Power Center 8.6 to extract data from various sources and load in to staging database.

Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data manipulations and Data Conversions.

Created and Modified T-SQL stored procedures for data retrieval from MS SQL SERVER Staging.

Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

Extensively worked with Informatica Tools – Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.

Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.

Designed the mappings between sources (external files and databases) to operational staging targets.

Involved in data cleansing, mapping transformations and loading activities.

Developed Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.

Implemented Slowly Changing Dimension methodology for Historical data.

Designing mapping templates to specify high level approach.

Extensive hands on XML import/export, deployment groups, query generation, migration using informatica repository manager.

Provided production support for Business Users and documented problems and solutions for running the jobs.

Extensively worked on unit testing and implemented on transformations, mappings.

Created Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Coordinated between Development, QA and production migration teams.

Reports were generated using Business Objects for analysis.

Environment: Informatica Power Center 8.6, Oracle 11g, PL/SQL, MSSQL SERVER 2008,T-SQL, UNIX Shell scripting, IBM DB2, Business Objects XI R3,ESP Schedule, TOAD, SQL Developer, Humming Bird, Power Exchange 8.6, Win XP, Win SCP.

SAMSUNG, Noida, India Jan’08– Mar’ 12

Role:ETL Developer

Description:Samsung’s emphasis on Product Innovation and R&D has given the Company a competitive edge in the marketplace. The Samsung India Software operations works on major projects for Samsung Electronics in the area of telecom, wireless terminals and infrastructure, Networking and application software.The projects cover up across various elements of the financial services. The task was in particular to integrate data from various source systems for maintaining a data warehouse and for reporting purposes.

Responsibilities:

Involved in the requirement gathering and Business Analysis of the specifications provided bythe business analysts.

Designed the mappings between sources (external files and databases) to operational staging targets.

Experience with high volume datasets from sources like DB2, Oracle and Flat Files.

Loaded data from various sources using different transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, andUpdate Strategy & Sequence Generator.

Experience in writing PL/SQL scripts, Stored Procedures and functions and debugging them.

Responsible for Migration of Stored Procedures into Informatica Mappings for improvingPerformance issue.

Involved in Performance Tuning of application by identifying bottlenecks in SQL, thusproviding inputs to the application programmer, thereby correcting and implementing the rightcomponents.

Created Session Task, Email and Workflow to execute the mappings. Used Workflow Monitorto monitor the jobs, reviewed error logs that were generated for each session, and rectified anycause of failure.

Experience in ETL testing, Created Unit test plans and Integration test plans to check whetherthe data has been loaded into the target is accurate, which was extracted from different sourcesystems according to the user requirements.

Setting up of the local Informatica environment on the client machines which included the connectivity and access to the data sources, taking the necessary steps to set up the Relational Connectivity variables in the Workflow manager etc.

Used SQL override to perform certain tasks essential for the business.

Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.

Defined Target Load Order Plan for loading data into Target Tables.

Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.

Environment:Informatica Power Center 8.6, Oracle 9i, TOAD, Windows 2000, PL/SQL, MS Excel, IBM UDB DB2,Erwin, UNIX, Business Objects, Autosys.

Contact this candidate