Shiv Kumar T.

Shiv Kumar T.

Senior DBA

Wadgaon , India

Experience: 11 Years

Shiv Kumar

Wadgaon , India

Senior DBA

USD / Year

  • Start Date / Notice Period end date:

11 Years

Now you can Instantly Chat with Shiv Kumar!

About Me

Seasoned career of 11.2 years in IT since May-2007. Worked as SQL Server DBA for Microsoft & Bank Of America, managed VLDBs, high volume transactions & highly sensitive data. Onsite assignment to USA during Mar2013-Sep2014. As a Senior DBA – Respon...

Show More

Portfolio Projects

Description

Show More Show Less

Description

Show More Show Less

Description

Show More Show Less

Description

Show More Show Less

Description

Show More Show Less

Description

Show More Show Less

Provision mortgage data from multiple Systems of Record into ODS.

Contribute

Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Leading Dev Team

Description

It was designed and developed to source and provision mortgage data from multiple Systems of Record also known as SORs. It conforms the inputs to a standard data model within an operational data store and provisions out to client applications.

Show More Show Less

Support Data Integration (ETL) and provisioning Services

Contribute

Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Leading BA,Dev, QA Teams

Description

This project facilitates data load to & fro between heterogeneous data sets in the enterprise for example AS400 systems, Oracle, SQL Server & File systems. This project uses SSIS as the ETL tool utilizing the C# scripting.

Show More Show Less

Windows 7 OS Compatibility status based on certain defined Business Rules.

Contribute

Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Developing TSQL code & SSIS Pacakages

Description

This project constitutes of different teams like Hardware Compatibility Research Team, Availability, Readiness, Quality and Tools teams. Hardware Compat Team researches volumes of data which is collected by Microsoft from various sources like CNET, NPD, Lyra etc. This Data is prioritized and then processed to the team for researching the date to know the compatibility status based on certain defined Business Rules. This is mainly used to verify compatibility of Devices over new Operating Systems like Windows 7. The process involves Prioritization, Research, Ensuring Quality, and publishing on the Windows Compatibility Site. The Compatibility status is determined by researching the IHV Sites and other sources of date and hence forth updating the same information over the Windows Compatibility site. This helps Microsoft attain compatibility for almost all devices available in the market and in turn helps Microsoft increase in OS Sales. Other teams like Availability and Readiness teams interact with the IHV’s on need basis and get/provide feedback on the status of their devices with respect to Compatibility. The Tools team supports the portfolio by providing automated scripts to speed up the overall process. The Project uses SQL Server 2008 as its database to research compatibility of Devices over new Operating Systems like Windows 7.

Show More Show Less

Enterprise Integrated solution to comply with the Fair Credit Reporting Act

Description

CBRM is a systematic integrated enterprise solution across the enterprise to ensure consistent reporting to the CRAs that are currently receiving the Bank of America credit reporting data.

This complex solution involves processing/ingesting the Credit Report Files from different LOBs/SORs and performing data validity checks based on pre-defined business rules. The data that has passed will then be sent to CRAs and feedback from CRAs will be again be ingested into CBRM. This feedback data is sent to SORs for their analysis and dispute rectification.

Show More Show Less

Operational data store for centralized provisioning of mortgage data.

Contribute

Database Modelling & Design. Performance optimisation; Query Tuning Automation of execution of Test scenarios using T-SQL & .Net. TSQL & SSIS development Status reporting to stakeholders Coordination

Description

Mortgage Data Exchange is an operational data store for centralized provisioning of mortgage data to downstream applications and reporting platforms.

It conforms the inputs to a standard data model within an operational data store and provisions out to client applications. MDX has the capability to not only receive and provision mortgage related data in batches, but also receive and provision in Near Real Time with very low latency.

MDX was instituted as a primary Hub/Data Repository for all the Business needs serving/hosting 100+ LOBs replacing several disparate SORs ( System-Of-Record).

Show More Show Less

Centralised automated Document Imaging Repository for Loan Servicing Portfolio

Contribute

Dev Lead for TSQL & SSIS. Acting as POC for all project stakeholders. Used Unix Scripting, IBM Datastage, Oracle GG Replication. Working with Business Analyst, QA and UAT teams for defect-free product

Description

Centralised automated Document Imaging Repository for Loan Servicing Portfolio, with multiple Upstreams and Downstreams and various data integration channels that feed data in Binary , FileStream, XML, Physical file format.

Optimised for easy storage & retrieval for reporting and banking centres.

Show More Show Less

Repository for all analytical reports to LPS and US treasury.

Contribute

• Designing Test Strategies • Creating Requirements Traceability Matrix • Executing Test Cases • Handling QA Team. • Creating the validation scripts to verify the sanity of data based on Business Requ

Description

IR2 Next Gen Reporting is a Bank of America one stop repository for all analytical reports to LPS and US treasury. IR2 Next Gen Reporting provides quality controlled user friendly services to The Sales & Relationship management, Operations and Finance departments. It gives insights into inbound and outbound services to Operations Department to not only monitor and maintain the Loan Modification process but also to control and maintain changing Treasury rules and requirements in an efficient manner.

Show More Show Less

DMO application provides visibility to Corporate Customer records

Contribute

Application Support and Database Administration. Create and schedule database jobs, tasks. Verify that all scheduled jobs and tasks have run successfully. Database & Query performance tuning

Description

The DMO Workbench provides a centralized location for operational report delivery that enables visibility, centralization, automation, and transparency for data quality initiatives. This Corporate DMO application provides visibility to records identified and prioritized for data cleansing activities.

Show More Show Less

Microsoft Refurbishing platform for licenses, Desktops

Contribute

Application Support and Database Administration. SQL Testing, Performance Tuning using SQL Tools . Production Support Activities and Client Interaction. custom support procedures for data manipulatio

Description

Through WW MAR ( Microsoft Authorised Refurbisher) program, refurbishers are licensed to install Windows 98 Special Edition and Windows 2000 Professional operating systems on refurbished computers supplied to Eligible Recipients throughout the region. This programme has been created to meet the needs of refurbishers and promote digital inclusion by helping under-served communities’ access affordable operating systems for refurbished computers.

Show More Show Less

Microsoft's Fresh Start for Donated Computers program helps primary and secondar

Contribute

Application Support and Database Administration. Design and Implementation of custom support procedures for data manipulation and automation. Maintaining the SQL Server Security.

Description

Microsoft's Fresh Start for Donated Computers program helps primary and secondary (K-12) schools ensure its donated computers are properly licensed—so students and teachers can gain additional access to technology.

Show More Show Less