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 MoreSkills
Portfolio Projects
Contribute
Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Leading Dev Team
Contribute
Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Leading BA,Dev, QA Teams
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 LessDescription
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 LessContribute
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 LessContribute
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 LessContribute
• 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 LessContribute
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 LessContribute
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 LessContribute
Application Support and Database Administration. Design and Implementation of custom support procedures for data manipulation and automation. Maintaining the SQL Server Security.