Ashish Trivedi

Profile Summary

*.* Years of extensive experience in ETL, Business Requirements Analysis, Quality Assurance, Application Design, Development, Implementation and supporting of Data Warehousing and business systems.

5+ Years of experience in Finance domain, worked for American Express’s reward and rebates program and JPM Chase’s global data warehouse (Workforce program having HR data).

Experience in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing logic and transformations as per the requirement and creating mappings and loading the data into Data Warehouse.

Strong Data Warehousing ETL experience using Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.

Experience in creating Informatica Mappings, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.

Experience in Informatica Data Quality (IDQ) transformations like Address Doctor, Parser, Labeler, Match, Exception, Merger and Standardizer.

Extensive experience in developing Stored Procedures, Complex SQL queries using SQL Server and Oracle PL/SQL.

Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling.

Experience in creating Informatica Power Center Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Strong Technical skills in range of technologies which includes Informatica ETL,Oracle,DB2,UNIX, PL/SQL, Microsoft SQL server 2017, T-SQL.

Successfully performance tuned and maintained ETL applications and SQL databases with significant reduction in the process run time and standardization of the process in production.

Have worked with the conversion of legacy data (mainframe) into datawarehouse tables.

Created Mapplets, reusable transformations and used them in different mappings.

Experience in using Automation Scheduling tools like Control-M and Autosys.

Worked extensively with slowly changing dimensions.

Review of existing code to tune the performance of Informatica mappings processing large volume of data.

Worked on Audit Balance jobs to ensure the quality of transactions during the process using automated shell scripts to notify support team.

Experience in converting high-level design specification to simple ETL coding and mapping standards.

Extensively worked with Analytical SQL functions (RANK/SUM/AVG/COUNT/LEAD/LAG).

Technical Skill :

Technical Expertise:

Operating System:

UNIX, Linux and Windows

ETL Tools

Informatica PowerCenter 10.2/9.6, Informatica PowerExchange,IDQ

Databases

Oracle11g, SQL Server,DB2and Netezza

Scheduling tools

Informatica Scheduler,Control-M and Autosys

SDLC Methodology

Agile and Waterfall

Other Tools

MS SQL MS (2017), Toad, Tableau, Mircostrategy, JIRA, Jules and Bitbucket

Work Experience

Sep /19 – Present Columbus,OH J.P Morgan Chase Sr. Informatica Developer

Build the ETL transformations and mapping to convert the data from Peoplesoft sources to oracle tables for big data tables consumption.

Involved in Unit/ Regression testing to check whether the data loads into target are accurate.

Code review of ETL mappings used for financial and account report generation.

Created complex Informatica mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure,transformations to implement complex logics while coding a mapping.

Creation of adhoc autosys jobs to be triggered from informatica through shell scripts as per the requirement.

Creation of views from datawarehouse tables to build the universe for business users for their reports.

Involved in the development of PL/SQL stored procedures, functions and packages to process business data.

Created jobs in autosys so that Informatica sessions can run automatically on use case basis.

Root cause analysis for issues faced by business user in reports.

Environment: Informatica 10.2, Oracle, Tableau, Autosys and Unix.

Sep /17 – Sep/19 Baltimore,MD State Dept. of Maryland (DLLR) Lead ETL Developer

Developed tactical and strategic plans to implement unemployment insurance conversion

from legacy system to Data Warehouse.

Build the ETL transformations and mapping to convert the data from VSAM(Mainframe) sources.

Used Informatica Power Exchange for Change Data Capture to covert the mainframe VSAM files into tables to generate reports.

Created Data Maps / Extraction groups in Power Exchange Navigator.

Created SCD type 2 mapping to have historical data with begin and end date.

Created end to end structure for APPEALS, PAYMENTS, COLLECTIONS AND OVERPAYMENTS for unemployed claimants.

Created UNIX Shell scripts and supported implementation of automated ETL solutions which included scheduling of jobs with Informatica PMCMD Commands.

Created mapplets to use them in different mappings.

Made use of parameters and variables to reuse them across environments.

Created the Architecture high level and ETL design documents for offshore.

Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.

Involved in creating new table structures and modifying existing tables.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Involved in Unit testing to check whether the data loads into target are accurate.

Written SQL Scripts and PL/SQL Scripts to extract data from Database for Testing Purposes.

Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.

Environment: Informatica 10.2,Microsoft SQL Server MS(2017) and Informatica Power Exchange.

Mar /15 – Sep/17 Phoenix, AZ AmericanExpress ETL Developer

Designed and developed complex Informatica mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.

Built Informatica reusable transformations and mapplets wherever redundancy is needed.

Extensively worked on the transformations like Aggregator– to get monthly, quarterly, yearly invoicing also used SQL override to filter the data.

Analysis of our source data systems using the IDQ basic profiling features using the Informatica developer and the analyst tools before making any ETL Designs.

Created financial accounting Rewards and Rebates dimension table mappings.

Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.

Developed mapping to load the data in slowly changing dimensions (SCD).

Build the ETL source to Target specification documents by understanding the business requirements.

Automated the production jobs using UNIX Shell scripting and worked to implement automated ETL solutions which include scheduling of jobs with Informatica infacmd Commands to remove manual dependencies.

Identified areas of improvement, developed UNIX automation scripts to reduce manual effort by 40%, from 10hrs to 6hrs.

Involved in Data Quality Analysis to determine the cleansing requirements.

Created Profiles and Scorecards and also performed join analysis in IDQ.

Experience in Informatica Data Quality transformations like Address Doctor, Parser, Labeler, Match, Exception, Merger and Standardizer.

Created Oracle Stored Procedure to implement complex business logic for better performance.

Also Involved in tuning the mappings in the transformations by tracking the reader, writer, transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.

Involved in Unit testing, System testing to check whether the data loads into target are accurate.

Worked on troubleshooting issues and quickly resolving them in an efficient manner that minimizes downtime.

Worked with the flat files in both the direct and indirect methods.

Worked on Microstrategy reporting tool to generate reports for business from DWH reporting tables.

Automate the production jobs using UNIX Shell scripting and worked to implement automated ETL solutions which include scheduling of jobs with Informatica infacmd Commands to remove manual dependencies.

Environment: Informatica 10.1,IDQ, Oracle,DB2, Netezza,Control M,Microstrategy and UNIX

Mar/12 – Mar /15 (Offshore/Onsite) Pune-Phoneix, AZ AmericanExpress Informatica Developer

Created Informatica Mappings, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.

Coordinating with Business Teams / Functional Subject Matter Experts (SME) to gather Requirements and transforming them into technical specifications for the ETL Designs through which Implement ETL solutions using Informatica Power Center.

Worked on data cleansing, standardization and helped business user to tune SQL queries generated by Microstrategy tool get the desired output on their reporting window.

Worked with Informatica Power Exchange for Change Data Capture.

Worked on profiling and cleansing in IDQ .

Assisted in performance testing, data quality assessment, support & product deployments.

Created automated shell scripts to transfer files among servers using FTP, SFTP protocols.

Worked on Performance Tuning and Maintenance of ETL Applications and SQL databases with significant reduction in the process run time and standardization of the process in production which was appreciated by the users who were getting the data within 36 hours from 48 Hours.

Providing effective resolution to client reported issues on the daily and monthly basis.

Experienced in deployment of the ETL jobs into the Production environment along with primary production support, handling Change Requests and Defect Resolution.

Perform root cause analysis on all Informatica processes and resolve all production issues.

Automated alert for data availability to business.

Monitoring Scheduled jobs in CONTROL-M, troubleshooting job failures in Informatica.

Environment: Informatica 9.6,IDQ, Oracle,DB2, Netezza, Service Now, Microstrategy and UNIX.

Jul /10 – Feb /12 Pune,India Pfizer Inc ETL Informatica Developer

Created UNIX shell scripts to run the Informatica workflows for controlling the ETL flow.

Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.

Validate all data and perform routine tests on databases.

Monitoring the Jobs and sever space availability and CPU Process.

Perform root cause analysis, performance monitoring and application related issues

Provided application support 24/7.

Worked with business and functional teams to extract the requirements.

Environment: Informatica 9.1, Oracle, UNIX and HP Service Center.

Certifications

Infosys certified Business Intelligence Informatica professional in 2013.

IQ Foundation Certification at Infosys Limited in 2011.

Global Business Finishing School (GBFS) Star Certified (Java Stream) by Infosys Ltd in 2010.

CISCO certified Network Associate in 2009.

IBM certified Database Associate DB2 9.0 in 2009.

Achievements

‘Big Smile’ Appreciation from Syntel Inc. in Dec 2016.

‘Excellent Top 20%’ ranking in Syntel’s CRR rating in March 2016(FY 2015).

Syntel Inc SPOT Award in Sep 2015.

Best Relative ranking among my peers Infosys CRR Rating in 2014.

Best Performer for Q1 FY 2014 in FSI unit, Infosys Limited.

Education

B.Tech (Information Technology) – Graphic Era Institute of Technology (First Div. with Honors) in 2010.

Contact this candidate