Shiv K.

Shiv K.

SQL Server DBA with experience in taming VLDBs, Banking transactions.

Wadgaon , India

Experience: 11 Years

Shiv

Wadgaon , India

SQL Server DBA with experience in taming VLDBs, Banking transactions.

USD / Year

  • Start Date / Notice Period end date:

11 Years

Now you can Instantly Chat with Shiv!

About Me

  • <!--[if !supportLists]-->Seasoned career of 11.2 years in IT with experience in Techno-Functional Roles as Business Analyst, Data Analyst, SQL Server Developer & DBA Lead.
  • <!--[if !supportLists]--><...
  • <!--[if !supportLists]--><!--[endif]-->Worked with Microsoft & Bank Of America, managed VLDBs, high volume transactions & highly sensitive data.
  • <!--[if !supportLists]-->Helped customers translate their business requirements into technical solutions efficiently & easily leveraging my technical acumen.
  • Earned valuable insights working in Banking Domain.
  • Seasoned hands-on with Database design and T-SQL development in MS SQL Server 2000, 2005, 2008, 2012, 2014 & 2016.
  • My working as a Senior DBA –
    • Responsible for design of databases, on-boarding of new tables, providing integration endpoints for different System-Of-Records (SORs), review of current security policies & creation of new ones, disaster recovery implementations. Planning, guiding & oversight of periodic mock Disaster Recovery (DR) exercises involving Database restorations, Load Balancing, Auto/Manual failover configurations in coordination with relevant Application teams.
    •  Coordination with Business, Development & Test teams for new requirement analysis and incorporating into existing design with least downtime/design change.
    • Acting as SPOC for Application DB design update, maintenance & all-time availability adhering to agreed SLAs/Recovery Objectives (ROs).
    • Socializing the DB enhancements/upgrades to various upstream & downstream application teams and addressing/incorporating their inputs/concerns.
    • Triage with SQL Server Product Support Team for Security & Service Pack Patching. Researching on possible impacts & documenting mitigation measures. Planning the patching/upgrade and creating checklist for consistency check post-upgrade.
  • <!--[if !supportLists]-->·         <!--[endif]-->Exposure to PL\SQL Development in Oracle 11g.
  • <!--[if !supportLists]-->·         <!--[endif]-->Hands on with migration of DB2 & Oracle databases to SQL Server.
  • <!--[if !supportLists]-->·         <!--[endif]-->Worked with Export/Import of data from varied data sources – SFDC, DB2, AS400, Text & XML Files.
  • <!--[if !supportLists]-->·         <!--[endif]-->SME in Consumer Banking – Mortgage Servicing & FinTech domains.
  • <!--[if !supportLists]-->·         <!--[endif]-->Stronghold in SQL Server Administrative tasks relating to Installation, Troubleshooting, Maintenance, ensuring Availability through Clustering/Replication, Load Balancing.
  • <!--[if !supportLists]-->·         <!--[endif]-->Expertise in Performance Tuning, mitigating bottle-necks, creating optimal Database backup strategy, Troubleshooting DTS/SSIS Packages.
  • <!--[if !supportLists]-->·         <!--[endif]-->Expertise in development, deployment & troubleshooting Microsoft SQL Server Integration Services.
  • <!--[if !supportLists]-->·         <!--[endif]-->Experience in the usage of IBM DataStage ETL & Cognos Reporting tools.
  • Well versed with Waterfall & Agile Scrum methodologies.

Show More

Portfolio Projects

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

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