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.
Skills
Software Testing
Data & Analytics
Others
Software Engineering
Database
Programming Language
Web Development
Positions
Portfolio Projects
Company
Mortgage Servicing Platform
Role
Backend Developer
Contribute
Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Leading Dev Team
Company
Infosphere Shared Grid ETL Platform
Role
Project Manager (Team Lead)
Contribute
Understanding Business Requirements Liaison between Business & Tech Teams Designing Dev & Test Strategies Creating Requirements Traceability Matrix, HLD & LLD Leading BA,Dev, QA Teams
Company
Windows 7 Compat Center
Role
Full-Stack Developer
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 LessCompany
Centralised Business Rules Management Engine
Role
Project Manager (Team Lead)
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 LessCompany
Mortgage DX- Operational Data Store(ODS)
Role
Backend Developer
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 LessCompany
Document Management Store
Role
Backend Developer
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 LessCompany
IR2 NextGen Reporting
Role
Full-Stack Developer
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 LessSkills
Test Automation Business Intelligence Data Ingestion Data Modeling Database Programming Database Testing Database Management System - (DBMS) Excel VBA Functional Testing Quick Test Professional - QTP Microsoft SQL Server Programming Visual Studio Code PL/SQL Oracle Programming Performance TuningCompany
DMO Workbench
Role
Full-Stack Developer
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 LessCompany
Microsoft WWMAR Application
Role
Full-Stack Developer
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 LessCompany
Freshstart For Donated Computers
Role
Full-Stack Developer
Contribute
Application Support and Database Administration. Design and Implementation of custom support procedures for data manipulation and automation. Maintaining the SQL Server Security.