Samir Sathe

adz7de@r.postjobfree.com

704-***-****

Summary of Experience and Qualifications

● Technical Architect with 15 years of experience in Data warehouse Design, Data modeling, Development and Testing using ETL tool IBM DataStage versions 11.x/9.x/8.x/7.x & Informatica Power Center 10.2, IICS(informatica cloud)

● Strong Experience in EDC Data Lineage for impact analysis.

● DHW Solution Design expert

● In-depth Understanding of the Banking, Finance and Life Science domains particularly in Customer Data management.

● Strong knowledge in Data warehousing concepts.

● Proficient in InfoSphere data governce catalog and info analyzer.

● Proficient in using DWH Concepts for conversion of business specific requirements into overall High Level & then Low Level ETL Design.

● Expertise in building Operational Data Store (ODS), Data Marts, metric tables and Decision Support Systems (DSS), Star and Snowflake schema design.

● 1st DataStage lead developer joined in Ford Motors Credit Company, so have understanding and hands on experience of initial hurdles in establishing project standards, design & guidelines.

● Prior experience of working on DataStage migration project from version to 7.5 to 8.5.

● Have lead team of 10 people before in onsite/offshore model.

● Excellent in making, interpreting & in understanding of SDA (Solution Design Architects Documents).

● Experience in running and scheduling Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.

● Expertise in Scheduling tools like Autosys for automating and scheduling jobs run.

● Able to resolve many production issues related to performance tuning.

● Experience in working on various data sources such as Oracle, MS SQL Server, and DB2, XML and Flat/Mainframe files.

● Experience in UNIX.

● Expertise in SQL programming.

● Experience in development and Support projects involving online and large Batch processes.

● Expertise Database tools like SQL Developer.

● Efficient team player & natural leader with strong technical, logical, analytical and problem solving abilities.

● Ability to multitask & perform under pressure.

Technical Skills:

Primary Skills IICS,Informatica Power Center,Datastage 11.5,9.1, EDC Lineage, SQL, Unix,Snowflake basics

Platform Windows, UNIX

Databases DB2, Teradata, Oracle, SQL Server

Web Apps Control M / Service Now / Request Center/ uBuild Supporting Tools Putty, SQL Assistant, Accurev, Autosys Professional Experience:

Flagstar Bank Troy MI

March 2022- till date

Tech Lead

Projects Worked on: Snowflake Community Banking,AFS Vision, EDMA merger Responsibilities:

● As tech lead Samir worked on establishing standards for IICS-Snowflake community banking project.

● Worked on daily/monthly IICS mappings

● In EDMA merger working on end to end solution for multiple workstream

● Mentoring team members and providing technical leadership by coordinating with onsite client,BA and offshore DS development team to come up with amicable solution.

● Doing ETL reviews with client.

● Working on complex supporting transaction module to help analyze and test in short time frame. Ford Motor Credit Company, Detroit, MI Sept 2014 - March 2022

ETL SME

Projects Worked on: India Retail, Global Account Manager Online, Global Collection Sales, ECL, EDW to GDW Transformation

Responsibilities:

● Being the 1st ETL lead in FMCC, worked with IBM experts for all necessary setup.

● Help team get along with DS standards, guidelines, category formation & job templates, Proof of Concepts.

● Mentoring team members who have worked on Mainframes before to get moving in DS.

● Designed ETL high level design.

● Solved some extremely complex data/design issues related to metric tables, huge volume of data.

● Involved in the high level design and prepared the related documents. Extensive contribution in ETL blueprint of FMCC.

● Helped the BAs in preparing the mapping documents.

● Designed and developed ETL processes using DataStage designer to load data from EBCDIC files with multiple categories in it, Teradata database, DB2 database, to staging database and from staging to the target Data Warehouse database.

● Efficiently used various DataStage stages likes Sequential file, lookup, peek, row generator, Transformer, Aggregator, Sort, Join, Funnel stages in accomplishing the ETL Coding.

● Coordinated with various channels interacting with the application to resolve the technical & business related issues.

● Modified configuration files and achieved performance improvement.

● Formulated process to send/receive trigger files from mainframe / to reporting tool webfocus from DS server.

● Also worked with DS Admin for setting up different project level environment. Software/Environment: IBM DataStage 9.1 (Designer, Director), Autosys, Putty, Teradata, Flat files/Sequential files, Datasets, Mainframe EBCDIC files. Cognizant Technology Solutions, Charlotte, NC/Detroit, MI May2013 – Sept 2014 ETL designer – Project Lead

Financial Crime Suite (FCS – AML) is system for monitoring the transactions happening globally to keep track of money laundering if any. The data to FCS is sourced through DWH, which is populated by ETL extracting and transforming data from multiple source applications The project is to transform the data flowing from various sources through multiple stages before being loaded into the data warehouse.

Responsibilities:

● Currently Leading the Data quality Team which is intended to fix the data quality issues.

● Worked on Designing and Development of major functionalities of the application which feeds the data from various sources.

● Designed ETL Architecture.

● Involved in the high level design and prepared the related documents.

● Helped the BAs in preparing the mapping document for source to target.

● Have been acting as the Application Technical Lead for the onshore (clients location) team and Single point of Contact for the offshore team, in co-coordinating the assignments.

● Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and COBOL files to staging database and from staging to the target Data Warehouse database.

● Efficiently used various DataStage stages likes Sequential file, lookup, peek, row generator, Transformer, Aggregator, Sort, Join, Funnel stages in accomplishing the ETL Coding.

● Coordinated with various channels interacting with the application to resolve the technical issues.

● Modified configuration files and achieved performance improvement.

● Participated in discussions with external vendors (IBM)in order to define the Service Level Agreement for the products Supported by the applications.

● Also worked as DS Admin for setting up different project level environment. Software/Environment: IBM DataStage 8.7 (Designer, Director), Tidal, Putty, Oracle 11g, Flat files/Sequential files, Datasets, COBOL files

Lloyds Banking Group, Pune, India April 2012 – April2013 ETL SME

Consolidatory Regulatory Reporting: CRR was a datawarehouse built for regulatory reporting of LBG. It has multiple source applications, a staging area, conformed area and reporting area. Reporting area is divided into different datamarts and data was getting populated using DataStage 8.5 version Responsibilities:

● Worked on Designing and Coding of Batch processes which load the huge data from various sources.

● Developed ETL jobs as per business rules using ETL design document

● Involved in various phases of Requirements Gathering, Testing and Coding and Deployment of Key functionalities of the application.

● Implemented approaches to load and extract data from database using DataStage.

● Conducted Technical and Architectural design review of the application during development Phase.

● Worked closely with data warehouse architect and business intelligence analyst in developing solutions.

● Taken care of Post Implementation Production Support (PIS) of the application.

● Coordinating the team in the Defect fixes, and addition of new Enhancements during PIS. Software/Environment: IBM DataStage 8.7 (Designer, Director), Tidal, Putty, Oracle 11g, Flat files/Sequential files, Datasets.

Novartis Pharma, Pune, India Mar 2010 - April 2012 ETL Developer/Lead

Novartis Commercial Datawarehouse: CDW project was mainly CR & Enhancement project with different live applications of Novartis pharmaceuticals in a running in a commercial Datawarehouse where ETL was in Datastage. CDW was built for data mining of Customer, Sales & Marketing data to find out different sales trend and generate reports

Responsibilities:

● Worked from development phase of the application by participating in documentation of HLD and LLD as per the Requirements from the architect and Reviewed FFD Data Model.

● Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer

● Involved in the all the activities like testing, certifying and implementation of the data models in production.

● Performed ETL coding using Sequential file, Transformer, Sort, Merge, Hash file, Aggregator stages compiled, debugged and tested.

● Extensively used stages available to redesign Data Stage jobs for performing the required integration.

● Design and implementation of Job flows using Autosys for the functionalities supported.

● Participated in Data conversion from other applications and loading the initial Data to FFD using the Platinum Load utilities.

● Worked on production Fixes and defect analysis during the control phase of the project.

● Executed jobs through sequencer for better performance and easy maintenance.

● Used Data Stage Director to run and monitor the jobs for performance statistics. Software/Environment: IBM DataStage 7.5, DB2 DDB, Autosys, UNIX, Windows NT/XP Fifth-Third Bank Pune, India Dec 2007 – Feb 2010

Datastage Developer

Retail DWBI Applications Fifth-Third Bank:

Retail DWBI applications was the project of Fifth-Third bank to create the Datawarehouse with its customer data and other transactional data. There were different source applications involved in this from which we used to get data for processing. The major application data was coming from loan applications and other third party applications.

Responsibilities:

● Working on Code Fixes and Small Enhancements to the existing functionalities of the application.

● Maintaining Data Quality by Cleaning up and integrating the data.

● Tracking production issues and providing resolution for the tickets raised, conforming to the SLA with the Business.

● Effective Participation in all code release and walkthroughs and provide support for the installs.

● Involved in unit, performance and integration testing of Data Stage jobs.

● Used Data Stage Director to run and monitor the jobs for performance statistics.

● Worked as ETL developer, used various stages such as Database, Join, Look up, Transformer, Sort etc.

● Development of the jobs according to the requirement and ready LLD/mapping sheets.

● Coding and testing the components according to the requirements.

● Performing testing and trouble shooting.

● Ensuring that the Quality standards are followed while executing any task. Software/Environment: IBM DataStage 7.5, DB2 DDB, Autosys, UNIX, Windows NT/XP. Education

Pune University, India

Electronics & Telecommunications Engineering

2007

Contact this candidate