Candidates About

 

Sagar M Ghalsasi

SUMMARY

➢     Certified Informatica and Oracle IT professional with 8+ years of technical including a  3+ managerial experience (3+ years with Fortune 500 Company) in Data Analysis, Informatica Power Center 9.x/8.x, Informatica Data Quality (IDQ), Change Data Capture (CDC), Oracle (SQL & PL/SQL), Oracle, Teradata, Data Warehousing and UNIX and used the Business Intelligence tools like Spotfire, Business Objects.

 

➢     Involved in development of Informatica mappings with required transformations like (Source Qualifier, Rank, Joiner, Lookup, Filter, Router, Sequence Generator, Union, Sorter, Update Strategy, Aggregator, and Expression)

 

➢     Good understanding of Change Data Capture (CDC) techniques along with Ralph Kimball Dimensional Modeling using Star schema methodology and Bill Inman Snow Flake schema methodology.

 

➢     Strong experience in Extraction, Transformation, Loading (ETL) data from various heterogeneous source systems like Oracle 11g/10g, Teradata, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3 ,SAP BW into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).

 

➢     Expert in creating and using Mapplets, Worklets, and Advance Transformation like SQL, Transaction control, Normalizer, HTTP.

 

➢     Expertise in Performance Tuning (Teradata and Oracle Query tuning, Informatica dynamic session partitioning for optimal performance). 

 

➢     Expertise in implementing slowly changing dimensions SCD type1/2/3 with optimal performance. 

 

➢     Extensive use of Lookup Shared Cache, Persistent cache, Static cache, Connected, Un connected lookups, Target Update override. 

 

➢     Teradata experience using Teradata SQL Assistant, Teradata Administrator and data load/unload utilities like BTEQ, FastLoad, MultiLoad, FastExport, and Tpump

 

➢     Experience in leading team and possess excellent communication and interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.

 

➢     As an onsite lead responsibility to coordinate requirements and assigning development work and guiding them during Development and Unit testing Phases to implement logic and troubleshoot the issue that they were experiencing.

 

➢     Responsible for projects estimates, Project Plan, risk mitigation plan, design documents, Best Practices Document for Informatica, Oracle and Teradata. 

 

➢     Worked on both waterfall model as well as agile methodology projects.

 

➢     Implemented various Frame as ETL Framework for Operational Metadata Logging, Change Data Capture (CDC) Framework, Align code review Frame work etc.

 

➢     Extensive experience in Healthcare domain.

 

➢     Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in Oracle 11g/10g/9i and Teradata.

➢     Skilled in Unix Shell Scripting and experience on different UNIX platforms.

➢     Experience in scheduling of ETL jobs using Autosys.

 

➢     A highly motivated self-starter and a good team-player with excellent verbal and written communication skills.

 

 

EDUCATION

 

Highest Education - Master Of Science MS (Software Engineering)             

Title of the Degree with Branch	College/University
Master Of Science in Software Engineering	Birla Institute of Technology and Science, Pilani, Rajasthan, India
Bachelor of Engineering in Computer Science Engineering	Walchand College of Engineering,                Sangli, Maharashtra, India

 

 

PROFESSIONAL EXPERIENCE

 

➢     Worked as Informatica consultant in Arrowhead consultancies (June 2008 till May 2009)

➢     Worked as an ETL Developer Lead in Cognizant (June 2009 to Oct 2014)

➢     Working as Enterprise Information Manager in Randstad Technologies ( Oct 2014 till date)

 

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x, Information Data Quality

Databases: Oracle 11g/10g/9i, DB28.x, SQL Server 2000/2005, Teradata

Languages: SQL, PL/SQL, Shell Scripting

Operating Systems: UNIX (SOLARIS, AIX), Linux, Windows 95/98/NT/2000/XP and DOS

DB Tools: SQL Plus, SQL Loader, Toad, Power Designer, Erwin

Scheduling Tools: Autosys, UNIX crontab, Informatica Scheduler

Others: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word, MS Visio).

 

MANAGEMENT SKILLS

●      Successfully managed complex projects with global implementation, and rapidly evolving requirements.

●      Effective communication skills and record for coordination between globally located teams.

●      Project delivery under stringent timelines and high pressure.

●      Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.

●      Exceptional ability to maintain and build client relationships, frequent travel meeting one on one with clients, able to comfortably converse with all facets in the clients organization.

●      Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables. Check the data quality using IDQ

●      Adept in providing Analytical Support to key business Applications /solutions

●      Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences

●      Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.

●      Acted as liaison between management and development team for Requirements and QA.

●      Managing reports, analysis and decision-making for a change request.

●      Project Management, Project Schedule, Project Tracking and Team Management

●      Rich experience in translating Business requirements to understandable IT systems requirements and implementing proper Processes & Procedures across the organization.

 

WORK EXPERIENCE

 

 

Bank Of America

Duration: 27-Oct-2014 till date

Role: Enterprise Information Manager

Project Name: BOA counterparty Risk Management

Location: Agoura Hills, California

 

Description: The BOA counterparty Risk Management project primarily services the needs of the Bank Of America alignments with various counterparties like Chase, Wells Fargo, and so many others for the various counterparty risk mitigations. The contractual risks, and technology level tie ups with the current technical Information structure at Bank of America with various other counterparties needs to be taken care of, creating and converting wherever necessary, the Information structure formatting to match up the standards at the Bank. Minimization of the risks involved when dealing with the data from counterparty servicers from their servers, data format conversions, creation of standard set of formats, libraries, etc. Credit allotment as per the agreements with each counterparties, risk mitigations, risk flagging when credit limits are being reached, etc. to be taken care in the Datawarehousing environment of Bank Of America.

 

 

Role and Responsibilities

➢     Creation of the counterparty credit agreements, understanding and standardizing a common Information handling format.

➢     Analysed source systems, business requirements and identified business rules for building the data warehouse.

➢     Developed Technical Specifications of the ETL process flow

➢     Designed and developed Informatica mappings in Informatica 9.5.1 and 9.6 environments, workflows to load data into Oracle ODS.

➢     Extensively used the CDC

➢     Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server. Check the data quality using IDQ

➢     Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.

➢     Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.

➢     Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.

➢     Set up Metadata driven utility design for the ETL processes using Informatica.

➢     Used debugger to test the mapping and fixed the bugs.

➢     Involved in tuning the performance of sessions and mappings.

➢     Used the Workflow manager to create workflows and tasks, and also created Worklets.

➢     Involved in Production Support in resolving issues and bugs.

➢     Worked onSQL stored procedures, functions and packages in Oracle.

➢     Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.

➢     Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined. Check the data quality using IDQ

 

 

 

 

 

 

 

Amgen Inc.

Duration:15-April-2014 till 24-OCT-2014

Role:  Sr. Informatica Lead Developer

Project Name:Customer Master and Alignment

Location: Thousand oaks, California

 

Description:The CMA application primarily services the needs of the Amgen Sales & Marketing workforce by providing a unified Customer Master and Alignment application that enables the user community to seamlessly manage customer records, sales force structures, and the organizing “alignments” that exist between them. CMA is a single source for all the Customer Data including Targeting and Alignment.

The CMA application acts as the master data provider to many systems and thus plays a pivotal role in supporting the business critical processes at Amgen.

Currently approximately 500 users across all major Amgen locations (T.O., Washington, Colorado, Rhode Island, Louisville, Washington D.C.) access CMA for their customer information needs.

The CMA Remediation project will be carried out based on the recommendations suggested in the CMA Assessment Report. Check the data quality using IDQ

 

Role and Responsibilities

➢     Analysed source systems, business requirements and identified business rules for building the data warehouse.

➢     Developed Technical Specifications of the ETL process flow

➢     Extensively used Change Data Capture for production issues analysis, troubleshooting of the problem tickets, and to keep production data efficient, and to improve the performance of the ETL mappings. Check the data quality using IDQ

➢     Designed and developed Informatica mappings in Informatica 9.5.1 environment, workflows to load data into Oracle ODS.

➢     Installed and Configured Informatica Power Center client tools and connected with each database in Data Ware house using repository server.

➢     Extensively used Informatica to load data from Oracle, XMLand Flat Files to Oracle.

➢     Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.

➢     Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.

➢     Set up Metadata driven utility design for the ETL processes using Informatica.

➢     Used debugger to test the mapping and fixed the bugs.

➢     Involved in tuning the performance of sessions and mappings.

➢     Used the Workflow manager to create workflows and tasks, and also created Worklets.

➢     Involved in Production Support in resolving issues and bugs.

➢     Worked onSQL stored procedures, functions and packages in Oracle.

➢     Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.

➢     Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined. Check the data quality using IDQ

 

 

 

 

 

Merck Pharmaceuticals

Duration: 09-Dec-2012 – 14-April-2014

Role: Informatica ETL CoE(Center Of Excellence) Lead

Project Name – Multiple assignments

Location: Bridgewater, New Jersey

 

Description: AMS Informatica Support, providing Managed Shared Services support leveraging Onsite/ Offshore with ISD (L1.5) Support Model for over 200 ETL applications built in Informatica, with different source systems like SAP, Flat Files, CSV files, business provided Excel templates, and relational sources including Oracle and Teradata. These applications are hosted on UNIX operating system.

 

➢     ETL technologies – Informatica 9.x, Informatica Cloud, Composite, PL/SQL, Teradata

 

➢     ITIL based ticket Management for Incidents, Problem, Change & Release management

 

➢     The ticketing tool used is BMC Remedy.

 

➢     Asset management to track service impacts among various Configuration Items

 

➢     Knowledge Management to build a strong known error repository, documenting major and recurring incidents

 

➢     24/7 ticket processing for critical applications

 

➢     Extensively used Change Data Capture for production issues analysis, troubleshooting of the problem tickets, and to keep production data efficient, to improve the performance of the ETL mappings.

 

➢     Ongoing Monitoring of Servers and ensuring their availability 24/7

 

➢     Monitor and support all the platforms & applications

 

➢     Communication to the application project teams regarding system maintenance activities or downtime

 

➢     Flexible minor enhancement capacity model including the requirement analysis, impact analysis, design, coding, testing and deployment

 

➢     Enhanced application support processes with internal Xxx staff, external partner systems and vendors

 

➢     Designed and developed shell scripts to monitor the integrity of the system towards minimizing the downtime in transaction processing. The auto correcting scripts resulted in 25% reduction of the problem tickets on system

 

➢     Implemented software releases and patches on the user acceptance and production environments

 

➢     Performed defect analysis of the real time issues in the production environment.  

 

Merck Pharmaceuticals

Duration: 18-March-2011 – 27-Nov-2011

ETL Lead

Location: Pune, India

 

Description:The goal is provide one ultimate data warehousing solution to align all Managed Markets data in Merck to one detailed data warehouse according to business requirements. This data warehouse will be used for reporting purposes as well as source/target for Model N requirements. The SAP integration with Informatica was required to be implemented using the SAP chains, invoking these SAP chains Informatica workflows were triggered fetching data from SAP sources.

Responsibilities

➢     Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.

➢     Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.

➢     Extensively used ETL to load data from Flat files, DB2 and Oracle into Oracle.

 

➢     The SAP integration with Informatica was required to be implemented using the SAP chains, invoking these SAP chains Informatica workflows were triggered fetching data from SAP sources.

 

➢     Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks. Check the data quality using IDQ

➢     Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy.

➢     Worked with mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable.

➢     Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

➢     Used Informatica partitioning to improve data loading performance.

➢     Developed shell scripts for job automation, which will generate the log file for every job.

 

➢     Created Informatica Frame work for Audit and Error Balancing.

➢     Validated Data to Maintain Referential Integrity.Developed UNIX shell scripts to move source files to archive directory.

 

➢     Involved in Unit, Integration, system, and performance testing levels.

 

➢     Worked on back end programming such as PL/SQL procedures, functions and packages.

 

➢     Prepared a production monitoring and support handbook for ETL Process.

 

➢     Coordinated offshore and onsite team with a total of 7 ETL developers.

Environment:Informatica Power Center 9.x, Oracle 11g, Teradata, UNIX, UNIX Shell Programming, PL/SQL, TOAD Quest Software.

Merck Pharmaceuticals

Duration: 10-Sept-2010 – 18-March-2011

Role:ETL Lead

Project Name: Ab Initio to Informatica Migration

Location: Pune, India

Merck & Co., Inc. (Merck) and Schering Plough's (SP) merger has led to the need for integrating different business processes, IT technologies and people involved in these processes across both organizations. Merck currently supports multiple software platforms specific to the integration discipline due to the merger with Schering Plough. Legacy Merck uses Informatica and TIBCO while Legacy Schering uses Ab Initio and BEA Web Methods.

Thus a large number of ETL Informatica applications were required to be migrated to Informatica platform.

Responsibilities

➢     Code review, assigning development work to offshore team and guiding them during Development and Unit testing Phases to implement logic and troubleshoot the issue that they were experiencing. 

 

➢     Requirement gathering and FRS clarification.

 

➢     Preparing High Level and Low Level design documents.

 

➢     Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

➢     Used Informatica data services to profile and document the structure and quality of all data.

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

➢     Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Teradata Instance.

Followed the required client security policies and required approvals to move the code   from one environment to other.

➢     Developed ETL mappings, transformations using Informatica Power center 9x.

➢     Created Informatica complex mappings with complex SQL queries (complex joins and unions, hierarchy queries, Analytical functions, MODEL clause) to build business rules to load data.

➢     Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.

➢     Created automated scripts to perform data cleansing and data loading.

➢     Preparing, executing and documenting Unit Test Cases.Providing full support during SIT and UAT phase. Check the data quality using IDQ

➢     Performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed jobs into the production environment.

➢     Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment:Informatica PowerCenter 9x, Oracle11g, Teradata, PL/SQL, TOAD8.0, Windows NT, Unix ShellScripting.

 

Merck Pharmaceuticals

Duration: 18-Jan-2010 – 09-Sept-2010

ETL Lead Developer

Location: Pune, India

 

Description:

Me