PRANOTI

Phone: 248-***-****

Email: ac3b4s@r.postjobfree.com

SUMMARY

Over 7 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing, ETL Design, Databases and Master Data Management using Informatica PowerCenter 10.1/9.1/ 8.x/ 7.x.

Well-versed experience in different domains such as Healthcare, Financial and Insurance.

Excellent knowledge on Business Analysis, Data Analysis, requirement gathering and creating Business Requirement Documents and Technical Specification Documents.

Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter - Repository Manager, Designer, Workflow Manager, Workflow Monitor.

Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer.

Hands-on experience on using various transformations such as Expression, Filter, Router, Sorter, Union, Update Strategy, Aggregator, Sequence Generator, Joiner, Connected and Unconnected Lookup and so on.

Good knowledge on advanced transformations such as Data Masking, Transaction Control, Connected and Unconnected Stored Procedures.

Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Expertise in OLTP/OLAP system analysis and strong skills on relational and Dimensional Data Modeling.

Worked broadly with Slowly Changing Dimensions (SCD) and Change Data Capture (CDC).

Worked on target load order plan, pushdown optimization, constraint based loading and created mapplets and worklets when needed.

Experience in Star schema, Snowflake schema, and excellent knowledge on Kimball and Inmon methodologies.

Performed the data profiling, data analysis by using Informatica Data Quality (IDQ).

Strong experience working with different RDBMS like Oracle, SQL Server, Teradata, DB2 and with different file systems like Flat Files and XML files both as Source and as well Target.

Created Windows/UNIX scripts to run the Informatica workflows using pmcmd command and controlling the ETL flow.

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

Have good problem-solving, time management and communication skills and ability to work independently and cooperatively in a team and always open to learn new technologies and ideas from different team members/projects.

TECHNICAL SKILLS:

ETL TECHNOLOGY

Informatica Power Center 10.1/9.1/8.6/8.1, Informatica Cloud, Jitterbit

DATABASES

Oracle 10g, MS SQL Server, MS Access, DB2, MySQL, Teradata v15

REPORTING TOOLS

Tableau, Business Objects XIR2, Crystal Report

PROGRAMMING

C, C++, SQL, PL/SQL, HTML, UNIX Scripting

OPERATING SYSTEMS

Windows 10/7, MAC, Sun Solaris, UNIX, MS-DOS

APPLICATIONS

MS Office, MS Project, FrontPage, Toad 9.2/8.6, SQL Developer, SSMS

PROFESSIONAL EXPERIENCE:

Cigna HealthSpring, Franklin, TN Oct 2016 - Present

ETL Informatica Developer

Project: Data Migration (Siebel CRM to Salesforce, SQL Server to Teradata)

Responsibilities:

Worked closely with different stake holders to identify their required data / fields on the salesforce page layout and based on that defined any other data cleansing or business transformation rules to migrate the data from Siebel CRM to Salesforce.

Designed the new data migration approach with better performance and more stability.

Helped the client to follow the industry best practices such as performance optimization, naming conventions, environment cleanups and follow the migration document while migrating data.

Performance tuning – Achieved significant performance enhancement by utilizing bulk load, pushdown optimization and pushing joiner queries to database server.

Created complex mappings that involved implementation of Business Logic to load data in to staging area from SQL Server to Teradata.

Migrated huge data from various applications like GTE, QNXT, CCMS, FACETS to Teradata using parameterized files.

Designed mappings for each table in Informatica Designer and created sessions associating with each mapping in Workflow Manager.

Built workflows, applied conditional loading using link operator and executed tasks successfully.

Monitored execution of workflows in Workflow Monitor; examined session log and resolved errors as encountered.

Pulled data from organization’s data warehouse and created interactive reports which provided key insights of business using Tableau.

Developed mappings to load Patient, Professional, Treatment etc., Data from Siebel, CSV, Excel to SQL Server.

Designed and developed complex integrations involving many lookups/reference lookups to get the respective fields salesforce ID’s to load the data from SQL Server to salesforce.

Designed and developed complex Informatica cloud mappings involving many lookups/reference lookups/related lookups to get the respective fields salesforce ID’s to load the data from SQL Server to Salesforce.

Designed and developed data integration approach to replicate and synchronize salesforce standard and custom objects by using Informatica cloud.

Created full replication and incremental Informatica cloud jobs as well as scheduled the jobs to run on specific interval.

Created Custom and Standard Objects and Fields, Page layouts etc. in Salesforce as well as created views and worked on other customizations within salesforce.

Environment: Informatica Cloud, Siebel CRM, Salesforce, SQL Server 2014, Windows Server 2008, Windows 7

Salix Pharmaceuticals/Valeant Pharmaceuticals, Raleigh, NC Jan 2015 – Sep 2016

Informatica Developer

Project: EDW (Enterprise Data Warehouse), VeevaCRM to SQL Server Migration, Sample Guardian (CEGEDIM), Salix to Valeant Data Migrations.

Responsibilities:

Production & Development Lead for all Informatica Powercenter and Informatica Cloud environments.

Developed Informatica Powercenter jobs (mappings/worklets/workflows) to refresh the data from Salesforce to Oracle and vice-versa (Incremental and full load jobs).

Worked closely with Sr developers to understand and follow the best practices and performance tuning as well as worked closely with offshore team and provided training to interns.

Extensively worked on Salesforce Integration through Informatica PowerCenter and Informatica Cloud and developed jobs for Insert/Update, Delete, Upsert, Incremental Load/Full Load…etc.

Developed the problem solution approach such as creating/designing control tables to control the I/U/D as well as to keep track of and log of the wk's execution statistics.

Prepared Code Migration documents and closely worked with DBA team on several occasions such as performance tuning /deployment.

Worked closely with Business analysts to document the business requirements and to implement the technical design document/Business Requirement Document.

Designed and Developed Informatica Cloud Data Replication as well as Data Synchronization jobs for various source and target systems.

Worked on transformations like expression, Connected/Unconnected lookup, filter, router, aggregator, update strategy, sequence generator, stored procedure and so on.

Extensively developed workflows, worklets and sessions and used Assignment, File Watcher (Event Wait), eMail, Control, Decision, Assignment and Command TASKS.

Extensively used mapplets and created Target Load Order Plan at mapping level as well as used mapping parameters and variables, session and workflow parameters and variables.

Used informatica inbuilt scheduler to schedule informatica workflows/jobs.

Used Pre and Post processing commands in informatica to kickoff subsequent workflows i.e. created Wrapper Workflows.

Created Windows Batch scripts to automate the file download process from FTP Server (With features to wait till file is arrived, file watcher, informatica workflow kickoff by PMCMD upon successful file copy from FTP to Local informatica server)

Environment: Informatica PowerCenter 9.6, Informatica Cloud, Apex Data Loader, SQL Server Integration Services (SSIS), VeevaCRM, Windows Server, Windows 7

State Farm, Bloomington, IL Aug 2013 – Dec 2014

Informatica ETL Developer

Project: The high-level scope of this project is to extract data from collection computers from the various systems and need to perform business rules and load the data in to Enterprise Service Data warehouse. EDW supports two fact tables (AHQB & SFPP) are processing daily. Whenever the data is available in tables, generates the BI reports against EDW for Business Users.

Responsibilities:

Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.

Worked with transformations like Source Qualifier, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.

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

Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.

Responsible for Best Practices like naming conventions, and Performance Tuning.

Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading

Worked with workflow System variables like SYSDATE and WORKFLOWSTARTTIME.

Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Worked with Shortcuts across shared and non-shared folders.

Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.

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

Involved in the Extraction, Transformation and loading of the data from various sources into the dimensions and the fact tables in the Data Warehouse.

Worked on MDM for measuring the growth in the sales.

Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.

Wrote SQL/Oracle queries to validate applications

Used SharePoint for document management.

Executed SQL Queries to test Data migration and Data integration

Resolving defects by using HP Quality Center.

Designed process flow diagrams by using MS VISIO 2010.

Implemented various loads like Daily Loads, Weekly Loads and Monthly Loads using Incremental Loading Strategy.

Elite Technologies, Hyderabad, India Sept 2010 to Jul 2013

Informatica Developer

Responsibilities:

Gather and analyze business requirements and translate them into specifications and Worked as a team member for design and development of Sales Data Mart.

Involved extracting data and transforming the data before loading the data into target (warehouse) Oracle tables.

The transformations included generating unique sequence numbers and aggregations for the star schema target tables. The data sources were Oracle database tables and flat files and the target tables were in an Oracle database.

Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance

Experience in identifying Bottlenecks in ETL Processes.

Schedule Sessions, Run sessions, Extraction, Load process and monitor sessions by using Informatica Server Manager.

Created mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data.

Extensively used ETL to load data from Oracle database, SQL Server database, and Flat files to Oracle.

Created necessary test plans and design documents for the mappings.

Analyzing the data model and identification of heterogeneous data sources.

Designing and testing the different mappings according to the requirements.

Used Source Analyzer and Warehouse Designer to import the source and target database schemas.

Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.

EDUCATION:

Bachelor of Engineering in Computer Engineering from University of Pune, India.

Contact this candidate