Sql Server Management
Resume:
Professional Summary
Sr. Programmer Analyst having 12 Years+ of strong professional experience with proven leadership qualities. Highly adept to adapting work pace to evolving clients deadlines and experience in designing and implementing multitier high-performance application designs in Healthcare, Finance, Sales and Travel industries
Technical Expertise
Strong in studying user requirements, analyzing, designing, coding, implementation, debugging, testing, deployment and implementation of strategic solutions across diverse industries
Strong knowledge of automating systems under SDLC using Agile & Waterfall methodologies
Strong knowledge of documentations like Use-case and Process flow diagrams, Technical and Functional specification documents and Impact analysis documents using Visio and other applications
Problem identification, proposing solutions & make process improvements saves business time & money
Strong clients support skills and experience with client handling with onsite and off shore model
Build and maintains applications versioning control using TFS and VSS tools
Strong in Creating and Maintaining large SQL databases using normalization best practices in SQL Server
Designing database objects like Tables, Synonyms, Views, Stored Procedures, UDF, Triggers and Indexes
Knowledge & experience in SQL Replication, CDC, Log Shipping and database mirroring processes
Knowledge of Server General Administration including Roles Assignments and security strategies
Excellent knowledge in Performance Tuning and Process Optimizations using SQL profiler, index tuning wizard and SP debugging by following best practices and troubleshooting of data issues
Creates jobs, setup SQL e-mail, design alerts and schedules database maintenance activities
Automated backend processes through Jobs, Optimized batch processes and Perl and Scripting
Maintain, Troubleshoot and Setup Backup & Restore processes and do space monitoring activities
Troubleshooting daily issues, creating release plans and schedule releases for multiple servers.
Experience in Data Migration process using BCP and other custom tools and processes
Custom ETL design process and running BCP / ETL utilities on demand and SSIS packages
Excellent ability to develop and implement data and Report solutions using tools like (SSRS, Crystal Reports, Report Builder and Microsoft Excel and word etc)
Generate AdHoc queries and high end Dashboard Reports on-demand for management using BI tools (SSRS and Crystal Reports)
Added New features to existing data analysis reports and daily maintenance activity jobs
Work with clients and design solutions to integrate third party data sharing with existing database
Independently worked on designing the Integration modules responsible for exchanging data between Applications like Northstar Complaint management and JDE (JD Edwards) Shipping systems
Knowledge in designing applications and coding using Object Oriented Programming concepts in (ASP.Net, VB.Net, HTML, C#.Net)
Quality Assurance (QA) experience with developing Test Plans and Test Scripts
Experience in doing Unit testing, System and Functionality testing.
Assisting teams to Perform Black Box testing, Performance testing, Front-End and Back-End Testing
Facilitated UAT with the stakeholders and business users along with UAT and SIT planning
Personal Qualities
Experience working on multiple projects simultaneously at same time
Ability to work in Team and individual and take ownership for support and improvisations
Proven record of high client’s satisfaction and providing quality results with little supervision
Excellent communication skills in written and verbal
Skill Sets
Technologies
Yrs Exp
Microsoft SQL Server (2014, 2012, 2008, 2005 and 2000)
T-SQL, PL-SQL, Oracle 8i, 9i
12
SQL Profiler, Query Analyzer, Export & Import (DTS), SSIS, BCP
8
Visual Studio 2012/ 2008/2005,
ASP.Net, C#.Net & VB.Net, VB 6.0, Java Script and VB Script, Ajax, HTML, XML
4
SQL Server Reporting Services(SSRS), Crystal Reports 8.0 & 11.0, Report Builder 2.0, Visio
6
Scheduler, JCL's and Application structure (Mainframe)
5
Connect Direct (NDM), Web Logic, Queues, Channels, Perl Scripts
4
Windows 2000, 2003 & 2008 R2, Windows XP
4
Educational Qualifications
Bachelor of Information Technology
Certification in ASP.Net and VB.Net from NIIT Technologies
Professional Training and Internal Certifications
Finance Domain Training
HIPPA Compliance
Client Management & Customer Orientation Training
Quality Process Management
Software Support and Maintenance
Leadership Essentials for Project Leaders
Professional Experience
Design - Sr. Programmer Analyst
Location- Chester Springs, PA
Client - Animas Corp (Johnson and Johnson) - Feb 2013 - Jul 2016
Project - Orbit Health Care Management System
Responsibilities
Responsible for Requirement and database code Analysis for new Interface design
Defined Scope and transformed existing process logics based on new application architecture
Worked with Data Migration team for planning and mapping of data columns and transformation jobs and testing data migration activities
Designed new database and objects like Tables, Indexes, Views, UDF, Stored Procedures, synonyms and defined Constraints and Roles
Designed data transfer modules (using CDC and custom jobs and codes) that uses single dynamic script for transferring data (performing Extract, Transform and Load) for creating feeds for downstream applications
Dynamic scripts that needs less /no maintenance and smart handle data exchange and sends email in case of failures or process breaks
Created AdHoc Dashboard summary and SSRS Reports which includes tabular and Crosstab formats also contains custom filters, Interactive sorting features and parameterize inputs for presenting data
Configured SQL e-mail system that sends automatic emails incase of any error happens in SQL server level or Application (real time transactions) level
Involved in Code Debugging & Performance Tuning of the procedures using the SQL recommendations
Managing Code and Reports under Version Control system by using TFS
Part of Solution Review team to analyze, review and optimize the solutions provided by other team members of Application design
Created Technical Specification, Impact analyses and deployment documents
Handle enhancements and Production-support activities
Provided solutions on process optimizations, Stored Procedure design & other database related concerns
Designed the database Integration modules responsible for exchanging data between Applications like Northstar Complaint management and JDE (JD Edwards) Shipping systems
Tools
Microsoft SQL Server 2012 & 2000, CDC, SQL Profiler, Query Analyzer
Visual Studio 2012, SSRS (BI Tool)
Project Description
OHMS is designed and developed with diligent efforts to provide a perfect platform with easy-to-use interfaces, high security and more flexibility for enhancing care provider services, slashing down the error rate and assisting the providers in attaining utmost productivity and profitability.
Orbit Healthcare provides a web-based, hassle-free EMR solution (Orbit Healthcare Management System) to care providers in order to address the critical needs of healthcare environment and complexities involved in them. OHMS is a perfect model for practices of all sizes by allowing physicians and other healthcare providers to provide better care for patients. Orbit contains Models/ Interfaces like (Patient / Doctors/ Business Partners/ Insurance and payers Information. Create Orders and Generated Automatic Invoices. Generate Documents and send notices and Filing and Claims processes.
Desig - Technical Analyst
Location- (Off Shore) India - Nov 2008 - Oct 2010
(On Site) Oaks, PA - Oct 2010 - Feb 2013
Client - SEI Investments
Project - BIS (Business Integration Services)
Responsibilities
Setup new clients from base on VM Ware environment
Designed new database and objects like Tables, Indexes, Views, UDF, Stored Procedures, synonyms and defined Constraints and Roles
Design database maintenance tasks for executing DBCC commands to check physical and logical consistency of the databases
Create scripts to Rebuild indexes automatically on scheduled maintenance down times
Designed SQL Server Replication architecture (Implemented Transactional Replication, Snapshot replications) that can handles multiple banks simultaneously for pushing data over secured network using NDM’s and secured networks
Created database Mirroring for clients
Worked with DBA team for planning of Disaster recovery policies
Created Scripts using Perl and SQL scripts to automate Releases over Client Implementations and for runtime Replication object Installations changes
Created Maintenance Jobs for running and monitors database backups and space availability on servers. Send email alerts for issues reported for Replication Status, performance issues
Configured SQL Mail Agent for sending automatic email incase of issues
Created deployment documents to deploy in all test and production environments for various clients.
Worked on Requirement Analysis and provided time bound solutions for process enhancements.
Worked in Conducted workshops with SMEs and understood Client IT needs then work with Client and Offshore Teams for coordinating Project Scope, and closing the requirements for every releases
Handle enhancements requests and Production-support activities and prioritizing them. Provide solutions by Debug the problems reported and provide time bound solutions to clients requests
Tools
Microsoft SQL Server 2005 and 2008
Windows 2000, 2003, 2008 R2 and Windows XP
Mainframe (JCL and Schedulers),
Connect Direct / NDM (install, configure on test and prod environments), Perl Scripting, Natural, C, Adabas, Web Logic, Queues and Channels
Project Description:
Business Integration Services (BIS) is a real time information movement and management facility which provides client with flexible and efficient access to their TRUST 3000 information at any time, in a format that meets their information needs. BIS accomplishes this by transforming TRUST 3000 data from a mainframe data model into a relational model data repository (SQL SERVER 2005 & 2008), containing near real-time data and point-in-time data gets replicated from the ADABAS.
Desig - Sr. Software Developer
Location- Gurgaon, India - Nov 2007 - Oct 2008
Client - Kuoni Travels
Project - Xplor
Responsibilities
Worked on Code Analyses, column mapping and Data Transformation processes for migrating master data
Worked with Data migration team for migrating data from Oracle to SQL 2005 and SQL Server 2008 R2 and defining migration steps, providing source and destination table mappings and creating scripts for Bulk Data load
Worked on Application development, designing UI using ASP.NET and C#.NET
Understanding PL SQL code in Oracle (using Toad for Oracle) and convert logic as SP’s at SQL end
Designed new database and objects like Tables, Indexes, Views, UDF, Stored Procedures, synonyms and defined Constraints and Roles
Created Maintenance Jobs for Maintaining SQL Servers availability and monitors Backup Statuses and manage space availability on servers
Designed complex T-SQL code for Customer Imports and other interfaces Configured SQL Mail Agent for sending automatic emails
Enhanced the business logic using SP’s and UDF’s to retrieve information on the 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
Handle enhancements and Production-support for project by Debug the problem and provide time bound solutions to client
Analyzed and evaluated the performance of the application from various dimensions
Check physical and logical consistency of the databases and Rebuild indexes
Conducted User Acceptance Test (UAT) for successful implementation by meeting all requirements
Responsible for trouble shooting and provide support to development teams on issues and worked on database tuning and performance monitoring activities
Worked on updating Integration packages for additional requirements in SSIS
Managing Code and Reports under Software Configuration Management and Version Control by using VSS
Tools
Windows Server 2003
ASP.Net 2.0, C#.Net, VB.Net, VB Script, Ajax, Java Script, HTML and CSS
SQL Server (2005 and 2008 R2), Oracle 8i, SSIS
Crystal Report 11.0
Project Description:
Project Xplor has a view to migrate the Travel Management System of the client's architecture i.e. D2K/Oracle to Web application using Dot Net and SQL Server. Xplor is a renamed version of ATOMS (Accounts, Tariff and Operations Management System). Project Xplor ensured the seamless migration of the ATOMS application which is at the core of the KDM's travel business .The modules covered under the scope are Masters, Tariff, Operations, Charters, Accounts, MIS, Admin and Room Inventory.
This project has delivered an integrated based application, enabling operational ease to the users while ensuring greater data integrity and consistency. It is an all inclusive, value-added strategic business solution composed of powerful and need specific functional modules that together form a robust, out of- the-box business tool, and with the use of reports which gives them strength to calculate faster results and give for better decision making for management.
Desig. - Team Lead - Sep 2005 - Oct 2007
Location- Mhow, India
Client - MCTE
Project - Application S/W for Office Automation
Responsibilities
Worked on Application development and designing UI interface using ASP.NET and VB.NET.
Created database objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and defining users and Roles in SQL Server
Created Stored Procedures to retrieve information on the services like Billing, Purchases, generating vouchers, Critical Business and Finance data for Reports and maintaining inventories
Designed Reports using Crystal Reports and Microsoft tools like (Word, Excel and Power point)
Designed custom interface jobs that updates and synchronizes data on all multiple subscribed servers automatically based on options selected what needs to be synched
Designed job that acts as Real time Replication service to synch data under all departments and acknowledgements sends to Head of dept as soon as any projects or grants initiated
Involved in Business flow Management activities such as Process design, Process Execution, Process Monitoring
Designed MIS system for delivering the documents online and sending the approval via Mail system to the concern departments. It has been developed with built-in Intelligence to operate in a user-friendly environment.
Responsible for Requirement Analysis and scoping the requirements and provide time bound solutions for enhancements and issues and release processes.
Supporting Team on troubleshooting issues and guiding development teams by providing required information and support they needed
Analyzed performance issues in application and helped team by guiding and provide necessary support for fixing the issues
Conducted User Acceptance Test (UAT) for successful project implementation and making sure to close all requirements
Tools
ASP.Net 2.0, C#.Net, VB.Net, JavaScript, VB Script, Ajax, VBA coding
SQL Server 2005
Crystal Reports 11.0, Microsoft Office (Excel, Word and PowerPoint)
Project Description
Project includes multiple modules that perform specific jobs and work together to accomplish goals and process information asynchronously and synchronously as needed
Grants Management, and Project management modules takes care of 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.
Course Management Module defines and created courses for their units / Teams. It takes care of printing and scheduling the course classes based on availability of Teaches length or book chapters and duration of course
IT Equipment Management Module handles all it Assets allocated to every person
WEB Module is main hub that synchronizes the database and updates all the servers as they get available on internet and merges/ updates data over the Intranet based on defined time or customer special request. It also acts as admin and creates reports of all activities going on in every department /unit and provides facility to digitally sigh documents on all projects and grants.
HR Management Module takes care of all leaves and salary structure and allocation of special needed goods against all persons.
Desig. - Software Developer - Feb 2005 - Sep 2005
Location- Delhi, India
Client - DGAFMS
Project - DGAFMS
Responsibilities
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
Database design and programming, creation of Store procedures and functions based on requirement
Implementation of Packages at different Units and provided training to the application users
Conducted User Acceptance Test (UAT) for successful project implementation and making sure to close all requirements
Tools
VB.NET
MS SQL Server 2000 and Crystal Reports 8.0
Project Description
This is Inventory Control Management system software that manages the purchases and project initiations done on multiple departments Units and Hospitals in India. Manages all Purchases information at central location including Local Purchase for departments and allots the Budget to the Different departments and units under defined heads for fulfill their regular small & urgent Purchasing needs.
Application keeps the MMF details of all the Units as they send their Monthly Maintenance Figures (MMF), (the approximate quantity they require in a particular month) then based on these figures and according to further requirements Tenders are raised and advertisements are made for Items to purchased those Items, and are send to the desired Unit or Depots directly through Suppliers. Dept then takes care of requirements of all the units, Depots & Hospitals for their Demands & supplies made and various other details regarding them.
Desig - Software Developer - Mar 2004 - Feb 2005
Location- Delhi, India
Client - Medical Store Management System
Project - MSMS
Responsibilities:
Front End Design in Visual Basic (6.0)
Do general technical trouble shooting of the Designed Modules
Database design and SQL programming, creation of Store procedures and functions based on requirement
Implementation and deployment of application software at different Units
Provided training to the application users
Tools
Visual Basic 6.0
SQL Server 2000 & Crystal Reports 8.0
Project Description
MSMS is for the Inventory Control of Medical Stores. Application deployed for more than 30 locations all over India. DGAFMS have divided all the Medical Units as Dependent and Independent Units. Dependent Units are dependent on their respective Independent Units for all the medical needs.
DGAFMS makes all the purchase for different Depots through Centralized Purchases and allots Budget for their Local Purchases. All the units send their Monthly Maintenance Figures (the approximate quantity they require in the particular month) then based on these figures Central and Local Purchases are made and items are sent to different units. MSMS takes care of requirements of all the units, quantity sent to them, their indents
Contact this candidate