Candidates About

                                                                                                                                               

Badri Narayan Singh

 

EXPERIENCE: SUMMARY:

·         Over 15 years of Data Warehousing experience in the areas of ETL design and Development. Involved in complete Software Development life-cycle (SDLC) of various projects, including Requirements gathering, System Designing, Data modeling, and ETL design, development, Production Enhancements, Support and Maintenance.

·         Designed technical processes as a Team Lead by using internal modeling and working with analytical teams to gather requirements and create specifications.

·         Hands on experience in Importing and exporting data from different sources like mainframe, DB2 into Hadoop using data ingestion tool like Talend and Datastage.

·         Data Lineage and business Lineage reports produce through  IBM Information Governance Catalog.

·         Current area of working is in Hadoop, Talend Bigdata, Datastage,  DB2 z/OS and DB2.

·         Coded programs used in testing, implementing and building client databases and process flows using IBM Infosphere (DataStage), Informatica,  Business Objects 5.1.2/XI R2,OBIEE, Oracle, DB2. 

·         14 years of experience in Information Technology with a broad range of computer expertise, analytical skills, backend database applications and ETL Architecture and Business Intelligence (DW) applications.

·         Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.

·         Proficient in both Waterfall and Agile development methodologies.

·         Proficient in analysis, design, development of Database Management Systems using ORACLE 11g/10g/8.x/7.x. 
Experienced in PL/SQL and TOAD.

·         Hands on knowledge in UNIX/Linux shell scripting, job scheduling in CRON, Autosys, Control-M and TWS.

·         Hands on experience in implementing business logic in Oracle using Stored Procedures, Functions, Packages, Views, materialized views, function based indexes and Triggers, Dynamic SQL, ad-hoc reporting using SQL.

·         Experienced in Oracle Database Design and ETL with IBM Infosphere (DataStage), Talend and Informatica.

·         Mentored, coached, cross-trained junior developers by providing domain knowledge, design advice.
Proven ability in defining goals, coordinating teams and achieving results. 

 

ACADEMIC PROFILE:

 

·         Master of Computer Application 2003 from Utkal University, Bhubaneswar

 

SKILLS:

 

ETL Tools                              :  IBM Information server 11.5/9.1, IBM Information server /8.x, DataStage 7.5 and Informatica Power Center 8.X, Talend Studio 6.4

OLAP/DSS tools                   :  Business Objects 5.1.2/XI R2 and OBIEE.

RDBMS                                 :  Oracle 11g/8.x, DB2 UDB, DB2 Mainframe, MS SQL Server 7.0, DB2, MS Access.

Modeling Tools                      :  ERwin7.1, Visio

Scheduling Tools                   :  Autosys, Control-M and TWS.

Version Control Tools          :  IBM Rational Clearcase, Serena, DataStage, Niku.

O/S                                          :  IBM (AIX) and UNIX, Windows NT, Windows 95/98/2000

Software Package                  :  Microsoft office 2013, Ultraedit, Advance Query Tool, Toad, Beyond Compare 3, IBM Rational       Quest, JIRA, Service now and HP- Sitescope.

Management                          :  Team Lead, Project Management, Agile, Waterfall, SDLC process   

 

Consulting Expertise Summary

Industries: Banking and Financials 14years.

Solution Areas: DataStage design, Data Architecture, Solution Design, Data Modeling

Data Models: Enterprise Data warehouse (EDW) and Reporting Data mart.

 

EXPERIENCE: SUMMARY:                                                                             Nov 2017  -  Till Date

 

Client          :           Cincinnati, OH

Role            :           Senior Architect

 

Description: Fifth Third provides a broad array of products and services through four primary businesses: Retail Banking, Commercial Banking, Investment Advisors and Fifth Third Bank Processing Solutions. The project is to automate processes that load the data from different sources (ACE, ECIF,TSYS, FNA, ICOMP…etc) to the Marketing Data Mart (MDM). It also send daily extracts to different clients to satisfy their downstream requirements.

 

Responsibilities:

·         Designing and development of IIS DataStage 9.1/11.5 code and scheduling packages to transfer the batch data to BO and Tableau environment.

·         Ingest data into Hadoop/HDFS from different data sources using Datastage 11.5 and Talend ETL.

·         Design Talend generic ETL mapping to load data into Hive tables/partition tables.

·         Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into warehouse.

·         Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.

·         Worked with deployment team to deploy the code in different environments(QA,UAT,PRE-PROD,PROD)

·         Extensively used TWS for scheduling the DataStage Jobs.

·         Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills

·         Participated PoCs on Data integration use cases using Talend with Big Data.

 

 

Hands on: IIS DataStage 9.1, DataStage 11.5, Talend 6.4, DB2UDB, DB2 Mainframe, Unix, HP remedy and SiteScope.

 

EXPERIENCE: SUMMARY:                                                                             Aug 2016  -  Nov 2017

Syntel Inc.

Client          :           State Street Corporation, Boston, MA

Role            :           Technical Architect

 

Description:             State Street Bank and Trust, which provides  investment banking and investment servicing for mutual funds, collective investment funds and other investment pools, corporate and public retirement plans, insurance companies, foundations, endowments and investment managers. This Project is for load the FX, IRC and Security finance risk data for TEM(CCR/CCST) as the source for New Data warehouse.

 

Responsibilities:

·         Designing Data model and exception frame work model in Erwin for NDW.

·         Designing and development of IIS DataStage 8.5 code and scheduling packages to transfer the batch data to Cognos and sport fire environment. As well as providing detailed documentation and knowledge support to the Support team.

·         Creating stories in RTC.

·         Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into warehouse.

·         Worked Closely with Product owner and Business Analyst to understand business rules and developed DataStage jobs.

·         Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.

·         Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

·         Worked with deployment team to deploy the code in different environments(QA,UAT,PRE-PROD,PROD)

·         Extensively used Autosys for scheduling the DataStage Jobs.

·         Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills.

Hands on: Agile development methodologies, IIS Data stage 8.5/ 11.5, Erwin Data Modeling, Oracle 10g, Shell scripting, Stored procedure (PL/SQL), Big Data (Design), Team management, Ultra edit, Advance Query Tool, Toad, Beyond Compare 3, and HP Quality Center

EXPERIENCE: SUMMARY:                                                                             Oct 2012  -  Aug 2016

Birlasoft Inc.

Client          :           Depository Trust & Clearing Corporation, Tampa, FL

Role            :           Solutions Architect/ETL DataStage Developer

 

Description:             DTCC's cross asset Global Trade Repository (GTR) will provide the industry with a central point of communication and storage for reporting Security Based Swaps (SBS) for all Credit, Equity, Rates, Commodities and FX Derivatives. The Trade Repository will accept all trades globally from all swap trading entities (or their agents) even if not reportable as per Dodd-Frank rules. The Global Trade Repository will act as the central Repository and receive Trade information, from Trade inception up to the maturity of the Trade. The Trade Repository will receive and store Primary Economic Term data, Confirmation, Lifecycle Events data, Trade Snapshots, Valuation, Trade Events and Contract Intrinsic event data. The Trade Repository will also receive and store Real time pricing information for price dissemination of OTC derivative transactions.

 

Responsibilities:

·         Provide architecture solution to address the new initiatives around the DTCC GTR equity data requirements.

·         Designing and overseeing development of highly complex IIS DataStage 8.5/9.1 code and Scheduling packages to transfer the batch data to Big Data environment. As well as providing detailed documentation and knowledge support to the RTB.

·         Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into the GTR Equity Repository.

·         Worked closely with Business Analyst to understand business rules and developed DataStage jobs.

·         Designed and developed Shell scripts, scheduling mechanism to support daily batch loads.

·         Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

·         Worked with deployment team to deploy the code in different environments(QA,UAT,PRE-PROD,PROD)

·         Extensively used Autosys and CRON for scheduling the DataStage Jobs.

·         Mentor and challenge junior and other team members, while growing the technical, functional and leadership skills.

Hands on: IIS Data stage 8.5/ 9.1, Data Modeling, Oracle 10g, Shell scripting, Stored procedure (PL/SQL),  Team management, Ultra edit, Advance Query Tool, Toad, Beyond Compare 3, JIRA and HP Quality Center

EXPERIENCE: SUMMARY:                                                                             Dec 2007 –  Oct 2012

Wipro LTD 

Client      :               FIFTH THIRD BANK, Cincinnati, OH

Role        :               Tech Lead/ETL DataStage/Informatica developer

Description:             Fifth Third provides a broad array of products and services through four primary businesses: Retail Banking, Commercial Banking, Investment Advisors and Fifth Third Bank Processing Solutions. The project is to automate processes that load the data from different sources (SOR) to the Enterprise Data warehouse (EDW) and Active Data warehouse (ADW).It also send daily extracts to different clients to satisfy their downstream requirements.

Responsibilities:

·         Provide architecture solution to address the new initiatives around the CRM Data Warehouse data requirements.

·         Participated in ETL Architecture meetings and define ETL best practices, guidelines on performance tuning for the ETL jobs.

·         Supporting the 5/3rd team by setting up the Infrastructure, ramping up development and production support.

·         Designing and overseeing development of highly complex IIS DataStage/Informatica code and Scheduling packages as well as providing detailed documentation and knowledge support to the bank.

·         Lead the team in the design and delivery of data validation rules with IIS DataStage for loading data into the EDW.

·         Worked closely with Business Analyst to understand business rules and developed DataStage and Informatica jobs.

·         Designed and developed Shell scripts, TWS scheduling mechanism to support daily batch loads.

·         Developed balance reconciliations processes, point to point controls, capturing operational info for management dashboards.

Hands on: Team management, IIS Data stage 8.1/8.7, Informatica, DB2, Oracle, SQL Server & Shell scripting, BO 5.1.2/XI R2, OBIEE.

 

EXPERIENCE: SUMMARY:                                                                             Nov 2004 –  Dec 2007

HSBC BANK, UK

Senior Software engineer

Description:  HSBC group is diversified financial services company providing banking, investment products, insurance and consumer finance through different distribution channels. The Data warehouse EDW/BI team helped in extracting the data from warehouse to query the Marts to generate the reports for different LOBs. Job Specification and Unit Test case reports were generated and Data Stage was used as an ETL tool to extract, transform and load data to HTSE Warehouse.

Responsibilities:

·         Involved in creating entity relational and dimensional relation data models using Data modeling tool.

·         Designing the target Schema definition and Extraction, Transformation and Loading (ETL) using DataStage.

·         Mapping Data Items from Source System to the Target System.

·         Preparing the mapping document source to target.

·         Worked on programs for scheduling Data loading and transformation using DataStage from legacy system to Oracle using SQL* Loader and PL/SQL.

·         Used DataStage director to monitor the job run statistics.

·         Writing documentation form detail transaction data for operational dtatasource.

·         Transformation including aggregation and summation construct from operational data source to Data warehouse.

·         Involved in performance tuning of parallel Jobs using performance statistics.

·         As per the Data Architect’s direction, created and executed the SCD Type 2 implementation on Dimensional data.

·         Extensively worked with DataStage Shared Containers for reusing the Business functionality.

·         Involved in Unit testing, System testing, Integration and performance Testing of the jobs

·         Participated in the meeting with Business Users and support Analyst for getting the more information and understanding of the Application.

Hands on:   DataStage 7.5/8.1,Data Integration Framework, Model enhancements with Visio and TDD and.

 

EXPERIENCE: SUMMARY:                                                                            Jan 2004 – Nov 2004

SB Software Solutions, Pune, India

Software Engineer 

Description: SB Software Solution is a leading IT development unit providing cost – effective ERP Solutions and professional web-based services, website design and web enabled products for schools, colleges, non-profits and small businesses.

·   Working on ERP Package for Web based Institute Management System called e-School.

·   Duties Include System Study, Installation, Users Interface Design, Website Design, Maintaining Website.

·   Successfully implementation of product at the Bishop’s School, St. Vincent’s School, St. Anne’s High School, Pune.