Sunil Kumar Singh

Email : adqxpd@r.postjobfree.com Mobile:330-***-****

Linked: https://www.linkedin.com/in/sunil-singh-55b5aa21/

Experience Summary

An accomplished, results-oriented DW/BI onsite Tech Lead and offshore project manager with 16+ years of experience in Software Development and maintenance cum production support projects in various domain like insurance, life science, manufacturing, automobile and Banking domain.

Currently working as, a Technical Lead Consultant in Financial domain with Charles Schwab Financial Services, Dallas (TX).

Experience in gathering Business Requirements, Developing Business Intelligence Program strategies, designing & implementing Business Intelligence information & analytical solutions.

Excellent understanding of data sources like Flat File, Oracle DB, Oracle EDW, MS-SQL Server, MS Access.

Core areas of experience are in DW Development and support using ETL tools such as Informatica Power Center 9x/10x and OBIEE 12c.Good experience in developing Informatica Mappings/Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure and Lookup) for ETL of data from Multiple Sources to Data Warehouse.

Extensive experience in ETL methodology for Extraction, Transformation and Loading using Informatica and designed data conversions from wide variety of source systems like RedShift, Oracle, SQL server, Flat files, and unstructured data files.

Expertise in providing end-to-end business intelligence solution by designing dimensional modeling, configuring metadata & building Analytics Repository, building business models, generating reports, creating Inter-active Business Intelligence Dashboards using Oracle Business Intelligence (OBIEE) 10.x, 11x and 12c .

Worked Extensively on Oracle BI Administration Tool, web / Presentation Services, Answers, & Interactive Dashboards and Security Implementation.

Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).

Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Business Rules with User Identity & Roles, Profiles & Personalization.

Experience in installation and configuration of OBIEE 10g, 11g and 12c and excellent understanding of Star & Snowflake Schema methodologies & Dimensional Modeling.

Extensively worked on Operational Data like Workday, PeopleSoft, Oracle EBS and POS Systems like JDE, Kronos etc., and created a sophisticated reporting structure with Fact-less Fact table.

Very good in Debugging, Optimizing and Performance Tuning of BI Dashboards/Reports.

Excellent command over Oracle Forms/ Reports, SQL, PL/ SQL programming, which includes stored procedures, functions, packages, views, cursors, triggers, indexes, Dynamic SQL, snapshots, materialized views, table/ index partition, collection, analytical functions, Oracle UTL_FILE features, external tables, SQL Optimizer Hint, Explain Plan, TKPROF, AWR Report, SQL*Loader and SQL/ stored procedure tuning.

Has proven analytical skill and has been instrumental in developing innovative solutions for projects implemented in Barclays and in prior assignments.

Experience in leading large development, migration, technology re-write and upgrade projects from inception and planning to delivery acting as the project driver from technology with hands on approach. Capable of being an individual contributor as well.

Extensive experience in stakeholder managements and co-ordination amongst several infrastructure and Operations teams.

Technical Skills

Operating System

Windows, HP-UNIX, Linux

Skill sets

Power Center 9/10, Power Exchange, EDW, IBM-Optim, OBIEE 11g/12C, OBIA, SQL, PLSQL, AWS-Redshift, AWS-S3

Databases & Tools

Oracle 9i/11g/12c, Sybase, Impala-Hive

Other Utilities

Autosys Scheduler, TWS Scheduler, BMC Remedy, Service-Now, CA7, u-Deploy, IBM-Artifactory, DAC 12C

1#Employment Profile

Company

Leidos, Reston, VA

Client

Entergy Services Inc-Texas

Project

BI Analytics

Designation

Technical Lead

Duration

Dec-2021-Contin

Skill Set

Power Center-informatica, Oracle, SQL, Autosys

Roles and Responsibilities:

Working as an individual contributor on the DW technologies which involves technologies such as Power Center-Informatica, Oracle, SQL, Autosys, HIVE and Informatica BDM.

Work with the BA/BSA on the analysis of the new requirements and business requirement analysis documents for the technical design documents and development for the ETL mapping and workflow.

Work closely with the architect and engineers to understand the data model after addition of the new DB objects.

Work closely with offshore team on the deliverables.

Own deliverables related to development, implementation, and testing.

2#Employment Profile

Company

Wipro, Plano-USA

Client

Charles Schwab, Westlake, TX

Project

Financial Reporting Layer-FRL/Digital Accelerator(Zelle, Heart Campaign)

Designation

Technical Lead

Duration

August-2020 -Dec-2021

Skill Set

Power Center-Informaica, Teradata, SQL, Control-M, CD/CI, Bamboo

Roles and Responsibilities:

Working as an individual contributor on the DW technologies which involves technologies such as Power Center-Informatica, Power exchange, Teradata, SQL, Control-M, CI/CD, Bamboo, HIVE and also using talent framework on the BDH platform for the financial reporting layer project and Zelle.

Work with the BA/BSA on the analysis of the new requirements and business requirement analysis documents for the technical design documents and development for the ETL mapping and workflow.

Work closely with the architect and engineers to understand the data model after addition of the new DB objects.

Work closely with offshore team on the deliverables.

Own deliverables related to development, implementation, and testing.

2#Employment Profile

Company

Wipro, Plano-USA

Client

PHEAA Financial Services, Harrisburg-USA

Project

DARBI-Data Migration From Mainframe To AWS-Redshift

Designation

Technical Lead

Duration

Apr-2019 to August-2020.

Skill Set

Power Center 10, AWS-S3, AWS-Redshift, UNIX, Tableau, JIRA, GLITZ

Roles and Responsibilities:

Worked as a Technical Lead Consultant in financial domain (student loan services) which involves technologies such as Power Center 10, Power exchange, Oracle 12C, Unix, Data-Lake, AWS-S3, AWS-Redshift SQL, PLSQL.Also I have beginner working knowledge and experience on the MondoDB(NoSQL).

Particularly involved in the development activities like workflow, session and mapping for the data migration from mainframe to AWS environment. Data source is AWS-S3 where data arrives from DB2 through python scripts. Doing hands on activities to develop the mapping and writing DB view script and stored procedure as an individual contributor as well as leading a team to provide the technical supports.

Interacted with data analyst team to understand the business requirement and the functionality of the various applications for the ETL process.

Was responsible to create TDD, STM (Source to Target Mapping) spreadsheeted, ETL workflow diagram, enterprise architectural diagram changes, code review and mapping/workflow/SQL/Stored procedure, DB view and code migration from UAT to QA.

Data source is AWS S3 Bucket and target is AWS Redshift.

Particularly involved in project’s space and responsible for the conducting POC on DW technologies, feasibility studies, end-to-end design and delivery along with daily production and support activities.

2#Employment Profile

Company

TCS, NJ-USA

Client

PNC Bank, Pittsburgh, PA-USA

Project

1.Technology Enterprise Reporting (TEP)

2.Human Resource Reporting and Analytics (HRR)

Designation

Technical Lead

Duration

Sep-2018 – April 2019

Skill Set

Power Center 10, Oracle 12C, Unix, DAC, CA7, uDeploy, IBM Arti Factory, SQL, PLSQL, EFX, Power Exchange

Roles and Responsibilities:

Worked as a Technical Lead Consultant to provide the production support and enhancement activities for the “Technologies Enterprise Platform” and “Human Resource Reporting” projects Involved technologies are Power Center 10, Power exchange, Oracle 12C, Unix, DAC, CA7, uDeploy, IBM Arti Factory, SQL, PLSQL along with BDH platform.

Particularly involved in the project’s enhancement and responsible for the conducting POC on DW technologies and interacted with BA to understand the business requirement and the functionality of the various applications for the ETL process.

Was responsible to create TDD, STM (Source to Target Mapping) spreadsheeted, ETL workflow diagram, enterprise architectural diagram changes, code review and mapping/workflow/SQL/Stored procedure, DB view and code migration from UAT to QA.

PeopleSoft, Workday, Oracle, flat file, HTTP, Archer/Service Now Application, Corner Stone, IBM Kanexa and main frame are source outbound and Oracle DW is inbound.

3#Employment Profile

Company

Fujitsu America Inc. Richardson, TX-USA

Designation

Technical Lead

Duration

Sep-2017 – Dec-2017

Project: Data Archival and Decommission/Client: Comerica Bank, Detroit-MI/Duration:092***-******

Roles and Responsibilities:

Interacted with BA and application owner to understand the legacy system for the decommissioning the application and achieved the business-related data into IBM Optim Server for reporting purpose to BI team which involved technologies such as IBM Optim, Unix, Oracle (SQL, PLSQL, OBIEE), Crystal Report, IBM-MainFrmae.

Particularly involved in project’s scope definition as per contract and was responsible for conducting POC on the data archival by using the IBM Optim.

Responsible to create TDD, STM (Source to Target Mapping) spreadsheeted workflow diagram, enterprise architectural diagram changes, code review and mapping/workflow development.

DB2, Oracle, flat file, HTTP, Archer, and main frame are source outbound and IBM Optim Sphere is inbound.

Involved technologies were IBM Optim, Unix, Oracle (SQL, PLSQL, OBIEE), Crystal Report, IBM-MainFrmae

Project: Value Chain Planning (VCP)/Client: JM Smucker, Orrville-OH/Duration:092***-******

Roles and Responsibilities:

Interacted with SME, BA and application owner to understand active dashboard and ad-hoc report of the value chain planning application that was needed to rebuild and migrate from OBIEE10g to 12C by using EDW.It was technologies change/platform change project from PLSQL, OBIEE 10 g into DW technologies EDW and OBIEE 11g.

First phase for this project was to build ETL mapping and schedule the ETL jobs to extract the data from the Demantra and EBS by using DAC after understanding the existing business rule and logic that was written SQL/PLSQL and second phase was RPD creation with star schema, aggregation, level-based as well as parent child hierarchy and OBIEE Analysis, Dashboard and ad-hoc report.

Created 40 ETL mappings that includes SCD1 and SCD 2 for the dimension and fact tables.

Created 65 reports in BI Analyses to show a different capability of OBIEE to the users.

Created the Physical, BM and Presentation layers/Subject Area by using OBIEE RPD based on dimension and fact tables (daily, weekly and monthly aggregate tables).

Involved Technologies were Oracle/OBIEE 12C, SQL, PLSQL, DAC 12c, Unix, SVN, Power Center 10, EDW

5#Employment Profile

Company

HSBC, Pune-India

Project

SPARC

Designation

Associate Project Manager

Duration

May-2016 – sep-2017

Skill Set

Oracle/OBIEE 12C, SQL, PLSQL, Control-M, Unix, ETL (Power Center 9x)

Roles and Responsibilities:

Frequent interactions with business user from different region to understand the business requirements and ongoing issue to automate the production issue.

Frequent interactions with Unix and Oracle Admin at the time of the Code and SPRINT release.

Did gap analysis to fix the performance issue and tuned the existing stored procedure, mappings (SCD2/SCD1) and reports. Did tuning in the repository side too by implementing the aggregate and fragmentation methodologies.

Provided support to the testing team at the time of the UAT while writing the SQL and did production support during warranty period.

Particularly involved in project’s scope and definition with stakeholder and was responsible for conducting POC on the data new requirement and implementation, feasibility studies, end-to-end design and delivery along with daily production and support activities.

6#Employment Profile

Company

CTS, Pune-India

Designation

Project Manager-Technical

Duration

Dec-2007 – June-2015

Skill Set

Oracle/OBIEE 12C, SQL, PLSQL, Control-AutoSys Unix, Power Center 9x, D2K(Forms/Reports), VB.Net, SQL/Stored Procedure Tuning and Performance

Duration : Apr-2014 – June-2015 – Project Manager-Technical (Pune-India)

Client : Hartford Financial Service Group, Inc. Hartford, Connecticut-USA

Project : Billing and Audit Integrated Services

Roles and Responsibilities:

Was responsible in building and mentoring the team after cognizant took over the new project from an existing vendor of The Hartford in Billing and Audit area.

Was involved in hiring of team members, mentoring, co –ordination of KT sessions, Reverse KT sessions, End to end Service and Artefact handover, end to end planning and team organization.

Went on to lead the production support team for the Direct Billing applications in the project. These are the company’s commercial and personal Insurance billing applications that report directly to the general ledger and hence are survival critical.

Was responsible for Incident management, day to day work allocation to the team, status tracking, project reporting and stake holder management.

Had the ownership to monitor and keep the business survival critical batch and real time processes running 24x7 and had to ensure that his team adheres to the strict SLAs mutually agreed between Cognizant and The Hartford.

Had to utilize his expertise in technologies like Oracle Forms, PLSQL, SQL, LINUX, Shell Scripting, Oracle application server, Autosys batch scheduling, Mainframe, Web services etc. to address and resolve the various batch failures and the issues faced by the business users. He often had to perform complex analysis and coordinate and drive the critical/Major Incident calls with interfacing teams.

Was also responsible for delivery of enhancement requests to the system.

Duration : Dec 2012 – Feb 2014 - Project Manager-Technical (Pune-India)

Client : Credit Swiss, Zurich, Switzerland

Project : Swiss Finance Platform

Roles and Responsibilities:

Created the physical layout of the database, DB View, Stored Procedure using Sybase Power Designer Tool, Oracle (SQL, PLSQL)

Responsible for developing RPD and Reports/ Dashboards as per client’s requirement by using OBIEE 10g.

Involved in developing the SQL to transfer data from inbound section to outbound section using view, materialized view and data load.

Developed SQL Loader and Mapping to load the flat file into Oracle Database and spool file by using SQL loader and Power Center 9.0.

Created SQL scripts to load data into the temporary staging tables.

Created and altered database objects such as tables, views, sequences, and synonyms.

Developed highly tuned SQL to use inside the Java Application.

Implement Dynamic SQL methodologies whenever necessary in the Packages/ Procedures/ Views.

Providing the accurate solutions to complicated issues to meet the customer’s expectation.

Apart from all above points I was HCM supervisor for OSP resources.

Duration : Dec 2010 – Oct 2012 – Technical Lead Consultant (Pune-India)

Client : MeadWestvaco, Richmond, VA

Project : Planning and Performance Management

Roles and Responsibilities:

Worked as a Database Solution Consultant for DW Technologies.

Involved in project management activities like (Weekly Status Call/ Project Metrics/ Resource allocation/ Work assignment).

Assisting in preparing the Business Requirement Document (BRD) as to provide a better understanding of business processes and identify improvements.

Created mappings and workflows to extract the source data and staged the data in staging tables (ODS database) and then extracted the data from RPS database and loaded the data into target warehouse (SAP BW) using various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Normalizer, Expression, Stored procedure and many more while designing and developing complex mappings by using Power Center 8.6.1.

Enhancement of existing PL/ SQL packages, procedures and repository customization and developing Reports/dashboard as per client’s requirements and TD document.

Performed SQL tuning using indexes and created bitmap indexes on low cardinality columns as they resulted in reduced response time for queries and substantial reduction of storage space

Developed complex queries on data warehousing and developed PL/ SQL procedures to provide nice strategic plans to higher level of management

Created SQL scripts to load data into the temporary staging tables and Used Dynamic SQL (D-SQL) programming techniques to build and process SQL statements "on the fly" at runtime.

Tuned complex stored procedures for faster execution and developed.

Duration : Jan 2009 – Dec 2010 – Technical Lead Consultant (Pune-India)

Client : Volkswagen-Audi, Herndon, USA

Project : Checkpoint Reporting System and Inventory Application

Roles and Responsibilities:

Involved in project management activities like (Weekly Status Call/Project Metrics/Resource allocation/Work assignment).

Enhancement of existing PL/SQL packages and procedures according to the requirement.

Developed complex queries on data warehousing and developed PL/SQL procedures to provide nice strategic plans to higher level of management

Tuned complex stored procedures for faster execution and developed database structures as per the requirements in Oracle data warehousing

Frequent Interaction with business users to understand the business requirements.

Developed complex PL/SQL packages and procedures as per the business requirements for data transformation from one system to another.

Prepared technical design documents.

Environment: Oracle 10g, SQL Server 2008, SQL, PL/SQL, Report Builder and UNIX

Duration : Jan 2008– Dec 2008 – Technical Lead Consultant (Pune-India)

Client : Schering-Plough, USA

Project : Adverse Event Reporting System 4.5

Roles and Responsibilities:

Analyzed the business requirements for new report as well as existing report if any modification is required.

Involved in development of various Interfaces.

Prepared the code end review before delivering the code to the client.

Handled queries from the working teams as well as from the client.

Modified and creating package for performance improvement.

Translated functional requirement into detailed technical requirement.

Customized the AERS application using Oracle Report9i to meet client's requirements.

Prepared test plans, test cases, and test scripts to validate conversion.

Responsible for testing and validating the client requested modifications.

Environment: Oracle 9i (Reports, PL/ SQL, SQL), SQL Server 2000, TOAD, Windows

6#Employment Profile

Company

Tech Mahindra, Pune-India

Designation

Sr. Associate-Project

Client

British Telecom, UK

Duration

May-2007 – Dec-2007

Skill Set

Oracle (SQL, PLSQL), UNIX, Control-M

Role and Responsibilities:

Involved in writing and modifying packages, procedures, functions and views

Worked on scheduling, monitoring, and supporting the batch jobs using crons.

Prepared LLDs and Release scripts and Release Notes

Responsible for support/ maintenance, which included on call support as well as EOD batch support

Performed monitoring of database and space usage

Involved in unit/ performance testing

Environment: Oracle 8i (SQL, PL-SQL), UNIX

7#Employment Profile

Company

IT-People, Dubai-UAE

Client

Mercator, Dubai-UAE

Designation

Sr. Oracle Developer

Client

British Telecom, UK

Duration

Jan-2007 – Apr-2007

Skill Set

Oracle (SQL, PLSQL), D2K (Forms, Reports)

Role and Responsibilities:

Worked on the production and maintenance issues as an individual team member.

Developed tables, sequences, stored procedures, functions, packages, triggers, views, front end screen/ report using D2K (Forms/ Reports) and indexes for the developing business logic using TOAD.

Responsible for testing and validating the client requested modifications.

8#Employment Profile

Company

United System, Muscat-Oman

Client

Ministry of Defense, Muscat-Oman

Designation

Sr. Oracle Developer

Duration

Feb-2006 – Dec-2006

Skill Set

Oracle (SQL, PLSQL), D2K (Forms, Reports)

Role and Responsibilities:

Worked on the maintenance issues as an individual team member.

Developed tables, sequences, stored procedures, functions, packages, triggers, views, front end screen/ report using D2K (Forms/ Reports) and indexes for the developing business logic using TOAD.

Responsible for testing and validating the client requested modifications.

9#Employment Profile

Company

Satna Cement Works, IT Section, Satna, India

Designation

System Analyst

Duration

Jul-2000 – Jan-2006

Skill Set

Oracle (SQL, PLSQL), D2K (Forms, Reports)

Role and Responsibilities:

Was involved Development, Maintenance, Enhancement and L3 support of the different application modules like finance and costing, sales and inventory management.

Worked in front end development using D2K Forms/Reports and backend development in SQL, PL-SQL and Unix Shell scripting.

EMPLOYMENT HISTORY

Organization

Designation

Duration

Wipro Limited, New Jersy-USA

Technical Lead

April-2019-Dec-2021

TCS,New Jersy,UA

Technical Lead

Sep-2018-April-2019

Infosys, Plano, Texas-USA

Lead Consultant

Aug 2018–Aug 2018

Fujitsu America Inc., Richardson, TX-USA

Sr. Technical Consultant

Sep 2016–Dec 2017

HSBC, Pune-India

Associate Project Manager

May 2016–Sep 2016

CTS, Pune-India

Project Manager

Dec 2007–June 2015

TechM, Pune-India

Sr. Technical Associate

May 2007–Dec 2007

IT-People, Dubai-UAE

Sr. Software-Engineer

Jan 2007– Apr 2007

United System, Muscat-Oman

Sr. Oracle Developer

Feb 2006 – Oct 2006

SCW (IT Section), Satna-India

System Analyst

Jul 2000 – Jan 2006

EDUCATION

M Tech (Computer Engineering) - OSPU, Odessa, Ukraine.

B.Sc. Egg. (Computer Engineering) - OSPU, Odessa, Ukraine.

AWARDS & RECOGNITION

Received Rainmaker Award twice from Cognizant

Contact this candidate