SUMMARY

• Database Analyst with 18+ years of experience in leading and mentoring team managing projects with full SDLC life cycle from analyzing, design, development, testing through implementation of code using Agile and Waterfall methodologies and providing maintenance with timely delivery.
• Proactive in establishing backup and recovery processes setting up protocols to protect and retain company valuable data, running servers and processes on optimum performances. Also provide solid infrastructure foundation and policies for short and long term that helps implementation of software solutions to support meet business needs quickly and efficiently
• Motivated and goal oriented with keen analytical and problem solving, task management abilities. Enthusiastic data engineer eager to contribute to team success through hard work, attention to detail and excellent organization skills.
• Quick learner, grow with team success having excellent interpersonal and communication skills with a proficiency in problem abstraction, business modeling and providing solutions
• Nineteen years including fifteen years of database architecture analysis and design experience on various domains including Healthcare, Finance and Travel. Proficient at establishing processes for highly scalable transactional and provide bulk data to downstream systems and setting up Real - Time Data Integrations
• Analyzing business requirements, planning, documenting, and evaluating strategic solutions
• Solve and correct issues in real time, providing problem resolution end-to-end to save business time & money and advise on DB design, tuning options, and best practices
• Performs data validation, error checking, troubleshooting, and performance tuning of existing application database environments
• Support production and non-production database environments for distributed applications
• Support and work with DBA teams for running daily activities and Roles Assignments, installations and Code deployment, server upgrades and maintenance tasks and space management
• Analyzing data and work with teams setting up plan for migrating data for downstream applications and data warehouse for analyzing and reporting purpose
• Experience in design and Implement complex ETL solutions using SSIS and designed batch utilities to process data daily and on demand
• Research new ways to improve existing functionality and create queries on large data sets
• Configure SQL server monitoring utilities to raise required alerts
• Designing database objects and functions like Tables, Synonyms, Views, Stored Procedures, Functions, Triggers and Indexes and SQL jobs
• Strong in report designing and create Adhoc and high-end dashboard reports on-demand for business needs using tools like SSRS, Crystal Reports with integrated Stored procedures and Tsql queries
• Experience in application design using C# and ASP.Net, VB.Net, HTML
• Experience in production support activities like incident management and SLA’s, Bugs and Enhancements using tools like Jira and TFS

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server (2019, 2016, 2014, 2012, 2008, 2005 and 2000), Oracle 8i, 9i

Database Tools: SQL Profiler, Query Analyzer, Export & Import (DTS), SSIS, BCP

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 8.0 & 11.0, Report Builder 2.0, MS Excel and Tableau

ETL Tool: SSIS (SQL Server Integration Services), DTS

Development Tools: Visual Studio / 2008/2005, ASP.Net, C#.Net & VB.Net, VB 6.0, Java Script and VB Script, Ajax, HTML, XML, IBM Rational Rose for Visual Studio

Documentation: MS Word, Visio

OS: Windows 2000, 2003 & 2008 R2, Windows XP

Other Tools: Scheduler, JCL's and Application structure (Mainframe), Connect Direct (NDM), Web Logic, Queues, Channels, Perl Scripts, SAS, R, Python

PROFESSIONAL EXPERIENCE

Sr. Programmer Analyst

Confidential - New Jersey

Responsibilities:

• Analyzing business requirements, planning, documenting, and evaluating strategic solutions
• Solve and correct issues in real time, providing problem resolution end-to-end to save business time & money and advise on DB design, tuning options, and best practices
• Actively participate in client meetings and discuss and recommends new changes required
• Monitoring progress and running daily calls with teams for resolving technical and business challenges
• Designing database objects and functions like Tables, Synonyms, Views, Stored Procedures, Functions, Triggers and Indexes and SQL jobs
• Design and implement complex ETL solutions using SSIS and bulk copy (batch utilities) to process data daily and on demand (processing multiple sourced text data, JSON, csv files, binary/ ascii mainframe files)
• Support and work with DBA teams for running daily activities and Roles Assignments, installations and Code deployment, server upgrades and maintenance tasks and space management
• Research new ways to improve existing functionality, improve performance and create efficient and robust queries on large data sets
• Managing code versions and user stories, change requests using version control tools in TFS and Jira
• Work with multiple teams to plan and execute QA and production releases
• Provide support for production and non-production database environments for multiple clients
• Designed Web Application on C# and ASP.net for monitoring and managing daily ETL processes, Realtime data load requests and responses, system services as well as manage SQL jobs and configure system alerts

Sr. Programmer Analyst

Confidential - New Jersey

Responsibilities:

• Leading development teams and work extensively on analyzing & documenting business requirements create Technical Specification, Impact analyses and deployment documents
• Performs data validation, error checking, troubleshooting, and performance tuning of existing application database environments
• Designed database architecture for high responsive (OLTP) environment for web applications and mobile applications also publishing and exporting data to external systems
• Running Project lifecycle using Agile methodology and do bi-weekly meetings for monitoring project progress, running daily calls with teams for resolving their technical and business-related concerns
• Designed automated custom database Integration module to exchange data with multiple applications and external systems (API’s) (this process data in ad out near to real time basis)
• Support and work with DBA teams for running daily activities and Roles Assignments, installations and code deployment, server upgrades and maintenance tasks and space management
• Design technical specification, impact analyses, migration and deployment and release documents
• Defining project lifecycle scopes and timelines for new applications and upgrading existing SQL code logics
• Worked extensively on optimize query performances, tuning stored procedures taking long time in production environments and performance monitoring usingSQL Profiler
• Created Incremental data from various sources in database for reporting and data analysis tools

Sr. Programmer Analyst

Confidential, PA

Responsibilities:

• Leading development teams and work extensively on analyzing & documenting business requirements create Technical Specification, Impact analyses and deployment documents
• Coordinate and supporting end to end project design with Front and backend developers under Agile methodology, running daily calls with teams for resolving their technical issues
• Worked on data migration, map source to destination tables, create scripts for running bulk data loads, transformation logics for migrating existing data based on new requirements
• Designed database and database objects like tables, indexes, views, functions and stored procedures also managing user roles and access rights also setting up reporting services
• Worked on performance tuning and process optimizations for existing procedures
• Designed custom ETL environment for sharing data to downstream applications like NorthStar and JD Edwards and EDW (data warehouse) and in-house product selling web applications
• Designed tabular, Crosstab, Adhoc and summary reports using SSRS and Report Builder
• Used TFS for managing source code, SSRS reports and user stories and change requests
• Designed dynamic document database structure (on JSON structure) to store and retrieve document data and generate dynamic reports on the JSON data

Technical Analyst

Confidential, PA

Responsibilities:

• Worked on developing Confidential (BIS) which provides clients with flexible and efficient access to their TRUST 3000 data
• BIS accomplishes this by transforming TRUST 3000 data from mainframe data model to relational model data repository, containing near real-time data and point-in-time data gets replicated from the ADABAS analyzing requirements, design custom ETL application to load data from MF to Windows
• Leaded team with 10-20 members at offshore for daily troubleshooting and issue fixes and provide client support, also part of level 2 support for troubleshooting issues if not able handled by offshore teams.
• Part of onsite team for building and establishing Offshore Onsite 24X7 support model
• Managing and documenting, defining and testing Release flow processes for all clients
• Worked on taking client requirements and work with offshore for closing requirements for multiple clients
• Setup new database environments on VM Ware and Install, upgrade SQL servers & NDM nodes on clusters
• Creating and managing schema objects such as Proc, function, tables, views, indexes, users roles
• Created Perl scripts to run SQL commands to exec batch files for managing & updating SQL Replication objects and executing backup and Restore processes and running bulk data load for initial client setups
• Created maintenance jobs for monitors database backups and space availability on servers.
• Running daily DBA activities like backups, DBCC commands to check physical & logical consistencies of DB and other automation activities scheduled on down time maintenance window
• Designed SQL replication (Transactional/Snapshot) and database mirroring to available data via secured network or NDM’s to downstream banks for DW analysis
• Worked with DBA teams for planning and testing of disaster recovery policies every year
• Design documents like Technical Specification, Impact analyses and deployment documents

Sr. Software Developer

Confidential

Responsibilities:

• Worked on Application development, UI designing using ASP.NET and VB.Net & C#.NET
• Worked on migration steps, map source to destination tables, create scripts for running bulk data load process from Oracle to SQL environment
• Understanding PL-SQL/Oracle code logic and converted business logic in SQL procedure language
• Design database objects like tables, indexes, views, user defined functions, cursors, triggers, stored procedure, constraints and defining users and roles in SQL server
• Created SQL maintenance jobs, monitors DB backup status and manage space availability, check physical and logical consistency of the databases and rebuild indexes, troubleshoot and provide prod support
• Developed Perl scripts for managing jobs and SQL replication objects and executing backup and restore processes also configuring user permissions
• Enhanced the business logic to process information for services like Billing, Customer, generating vouchers, Critical Business/Finance data for Reports (PL, BL etc.)
• Designed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using Crystal Reports for Accounts, Tariff, Operations Management System and Finance modules

Team Lead

Confidential

Responsibilities:

• Responsible for Analyzing client requirements and scoping the requirements into release and deliverables
• Modules covered under the scope are Masters, Tariff, Operations, Charters, Accounts, MIS, Admin and Room Inventory and design database objects to handle Billing, purchases, generating vouchers, critical business and finance data for reports also maintaining inventories
• Design used case diagrams in Rational Rose and create software solution by creating Model/ framework
• Leaded team of 8 members responsible for application front end and backend design
• Designed module for online documents processing that taking digital signatures & provide approvals
• Designing and developed application UI interfaces using HTML, ASP.NET and VB.NET tools
• Design database objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and defining users and Roles in SQL Server
• Designed database jobs for data synchronizing on multiple subscribed servers automatically and manually
• Designed reports using Crystal reports and Microsoft tools like (word, excel and power point) with the use of reports which gives them strength to calculate faster results and give for better decision making
• Responsible for providing time bound solutions for product enhancements and resolve issues
• Supported team by troubleshooting performance issues & guiding for fixing issues
• Conducted user acceptance testing (UAT) and provide prod releases support

Software Developer

Confidential

Responsibilities:

• Worked on Front end and database design in Visual Basic .NET and SQL 2000
• Design modules assigning budgets yearly and keeps track of expenditures based on projects and projects rollovers and statuses from initiation till delivery/shipment / receiving of goods or services
• Created Database objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles in SQL Server 2000
• Helping team in designing the key process & in resolving technical issues
• Do general technical trouble shooting and give consultation to development teams
• Helping team in designing the key process & in resolving technical issues
• Worked with teams to implement, document and plan QA and production releases
• Implementation of Packages at different Units and provided training to the application users
• Conducted user acceptance testing (UAT) and provide prod releases support

Software Developer

Confidential

Responsibilities:

• Worked on Front end and database design in Visual Basic (6.0) and SQL 2000
• Worked with team on project implementation based on Waterfall model
• Application works for their Monthly Maintenance Figures (MMF), manage requirements for Tenders raised
• Takes care of requirements of all the units, depots & hospitals for their demands & supplies
• Trouble shooting of application modules and resolve database issues
• Creating and managing schema objects such as tables, views, indexes and referential integrities, Store procedures and functions
• Design and develop user specific reports using Crystal Report tool
• Worked with teams to implement, document and plan QA and production releases
• Implementation and deployment of application software at different Units
• Provided training to the application users