Professional Summary

** ***** ** ********** ** the IT industry and Functional domain experience involves Retirement, Purchase & Inventory, Accounting, Payroll, and Sales & Distribution

** ***** ** *rofessional experience working in the capacity of Architect, Performance Tuning Specialist, Sr. Database Developer Analyst and SQL Engineer

10 years of experience in team management

Highly adaptable and experienced SQL Database Developer with a proven track record of high client satisfaction

Excellent experience in Data/Database Migration projects

Superior ability to support and develop analysis solutions and data transformations

Expertise in Query performance, Superior technical problem-solving and code debugging skills

Excellent ability to develop and implement data and reporting solutions

Profound understanding of SDLC (software development life cycle)

High achievement record in process quality improvement and efficient data solutions management

Superb maintenance of all working relationships

Comprehensive knowledge of computer languages

Extensive experience in Oracle and SQL Server Database design developing T-SQL queries, stored procedures, and triggers using SQL Server 2000, 2005,2008,2012,2014

Effective in working independently and collaboratively in teams and proactive and results-oriented leader skilled in mentoring and motivating the dynamic team to exemplary performance.

Technical Skills:

RDBMS and related tools -- SQL Server 2005- 2014, Oracle 7.x, 8.x, Oracle 8i, Oracle 9i, DBA Studio, SQL*Loader, Toad, SQLLiteSpeed, ERWIN, SQL Profiler, SQL Query Analyzer

NoSql DB : Mongo DB

Programming Languages -- HTML, JavaScript, T-SQL, SQL, PL/SQL,

Development Tools--Developer Forms 6i, 5.0, 4.5, Reports 6i, 3.0, 2.5

Reporting Tools -- SQL Server Integration Services (SSIS), Crystal Reports, SQL Server Reporting Services (SSRS), Crystal Reports,

Version Control Software -- Visual SourceSafe, Perforce and TFS

Work Experience

March 2007 to Present, HP Enterprise Services / DXC Technology, Project Lead / Database Architect

Database Tool development (database backup and restoration application)

Database Optimization and Performance Tuning

Database Design / Modeling / Complex data migrations and upgrades using SSIS packages

Identified and optimized SQL statements in stored procedures/reports, which were pain points. There was a 30% improvement in the stored procedures and 50% improvements in the reports.

Extract, transform, and load data from legacy IBM servers into SQL Server

Track and report weekly on per cent complete, slippage, project effort and duration to complete and other key project metrics.

Lead the team to prioritize signed off project work based on analysis of strategic importance, tasks outstanding, obstacles or barriers, resources and deadlines.

Developed a Data Archival Tool, which archives data (1 year old data) to an archival database and deletes from the real time database over the weekend as a part of the weekly database maintenance schedule

Manage offshore database team

Provide functional and technical expertise to team

Projects:

Maryland State Retirement Agency (MSRA), Salary Adjustment and AFC Calculation, Project Lead

This is a new web-based application developed to automate the Average Final Compensation (AFC) calculation tool. This provides the business users with an agile and interactive application that would significantly reduce the time and effort to calculate the AFC by eliminating any manual procedures currently followed by the Agency. This includes Salary Cleansing and Flagging, Salary Adjustments and AFC calculation. This will pave the path for automating the creation of the retirement final and estimate transactions, eliminating the manual data entry keying of the transactions. Eventually, this application will also be incorporated into level that will enable the members to calculate retirement benefit estimates through secure online web applications.

Maryland State Retirement Agency (MSRA), MPAS-2 Improving Data Integrity, Project Lead / Team Lead

The system streamlines the calculation/review of over 385,000 active state employee’s disability, death and retirement benefits enrolled under different plans. Initially system designed using legacy mainframe environment, later converted to relational database, due to conversion historic data for various members need to be cleansed.

At the time of member’s retirement, staff needs to review each account manually and correct the wrongly reported contribution, hours and salary etc. based on employment type (part time/full time), system and plan. We developed automated system that link the prior year member’s details and cleansed the various information such salaries, hours, contribution & various important dates, which helps to recalculate the service for benefit calculations at the time of retirement.

MPAS Operation & Maintenance and Pension Reform, Role: Project Lead / Team Lead

HP Enterprise Services is one of the leading providers for the Government Solutions, such as Elections, Public Retirement Systems, Enterprise Health, Human Services, Unemployment Insurance, Motor Vehicles, Tax and Revenue, Justice, and Information Technology Outsourcing. Maryland State Retirement System is the retirement system managed by the State Retirement Agency of Maryland. In April 2011 Maryland State passed Pension Reform legislation to increase the contribution amount to pension system. Pension Reform include the changes in member contribution rate, benefit multiplier, early age retirement, benefit calculation on highest 5 years of salary rather than highest 3 year salary, eligibility criteria, COLA calculation and some more. MPAS (O&M) includes Routine Job Processing, Customer Service Request Task Execution, Ad hoc Technical Support, Team/Project Management, Project Work Planning and continuous functional and technical improvement in MPAS.

Maryland State Retirement Agency, Maryland Pension Administration System (MPAS), Database Architect

MPAS is a conversion project from Legacy Mainframe system to .NET applications. It provides the screens which will be used by the client for accessing the MPAS solutions. Each of the JCL jobs is converted into the .NET console-based applications and the SQL Server 2005 acts as the backend database. The .NET console applications are scheduled through GECS (Global ECS), a job scheduling engine. As the mainframe maintains the large data in VSAM files, similarly the data is maintained in relational database SQL Server 2005 in MPAS. Most of the programs in Mainframe are converted as stored procedures in SQL Server and the JCL steps are converted as Dot net applications. The MPAS applications follow the 3-tier architecture in which the Web services act as an interface for the database through the data access layer. The input files are passed to the application through BizTalk over SOAP adapter or through SSIS package for large files. To provide the business rules for enabling the client to change the hard-coded values at runtime, the business rules are maintained using the ILOG Business Rules. The output files of one job may be used by the other jobs as input, for which GECS has the capability to run the jobs as stream. The common functionality of all the jobs is maintained in Common Web service, which is capable of handling multiple files and clubbing them to create a new file and placing the file in the BizTalk watcher folder. SQL Server Reporting services are used to generate the reports in the different formats like PDF, XLS and CSV, and so forth. The reports are subscribed for each run of the job through GECS and the report gets generated based on the parameters set through the reporting service subscriptions.

Platform: Visual Studio.NET 2005, .NET 2.0, and VB.NET, ADO.NET, XML, XSLT, SQL Server 2005, BizTalk 2006, Microsoft Enterprise Practices Library, ILOG Rules Studio, SSIS, GECS, SQL Reporting Services, IIS 6.0, Windows Server 2003

Oct 2002 to Mar 2007 Seasia Consulting, Sr. Software Consultant

Involved in performing feasibility analysis and studying the existing system

Managed the software team and reported to the managers

Worked with DBA\'s to create users and groups on IQ and granting appropriate permissions

Created database libraries to be reused in various applications.

Provided end-to-end data analysis, documentation to map data, work flow, and processes from disparate sources

Query Optimization for handling large amounts of data and making data retrieval faster

Analyzed data for business users and answer specific questions.

Provided oversight and design support to Production Support resources

Saber Corporate Resource (SCORE), Team Lead

Platform: HTML, JavaScript, Reports 6i, and Oracle 8i

This corporate resource management application facilitates the resource management process of an organization. This Web-enabled application allows the effective resource (manpower and projects) management and resolving of other related issues to the resource allocation and billing of the resources.

Public Employees Benefit Board, Benefit Management System (BMS) Public Employees Benefit Board, Senior Programmer

Platform HTML, JavaScript, Reports 6i and Oracle 9i

Public Employees Benefit Board (PEBB) manages health care benefits for Oregon State employees. Previously, they did not have a computerized system to manage their daily work. Benefit Management System (BMS) system is developed to manage PEBB’s daily work, including members benefit management, communication with health care providers, and payroll centres. Since BMS has sensitive data, electronic communication is performed using health industry standards-HIPAA. BMS generates HIPAA files based on the periodic transaction. BMS also has ongoing communication with payroll centres. BMS also allows individual members to log into the Web-based system to check their benefits and post their queries to PEBB staff.

San Diego Workforce Partnership, Customer Information Services Reporting System (CISRS), Team Lead

Platform: HTML, JavaScript, Reports 6i, and Oracle 9i

The system was a complete case management tool for managing, tracking, and reporting on the activities of the workforce clients. CISRS is the Workforce Partnership’s custom-developed case management system. It is the cornerstone Web-based application for participant data collection and reporting. The case manager used CISRS to record and track all services provided to the client. These were complex statistical reports for performance measure calculations for the San Diego Workforce that mainly deals in studying and controlling the grants provided by the government for the upliftment of various communities and sectors of the society.

Cannon Inc. USA, Direct Pickup Process (DPP), Sr. Developer

Platform: HTML, JavaScript, Reports 6i, and Oracle 9i

With North American Trucking Company and Canon's dealers, this project streamlined and automated the Return Pickup process. NAVL and ROSS are the two existing systems. ROSS is Canon's internal system and NAVL is external (Transporter's) system. On completion of lease of any machine at the customer’s location, Canon sends Information for machines to dealer; dealer picks the machines from the customer and keeps it with them. Canon sends price quote for that machine to dealer. If dealer is not interested in buying it, then Canon will send data to NAVL by fax; NAVL then sends data to Canon (by phone or fax). Earlier this information was entered manually into the ROSS system at Canon.

Aug 2001 –Sep 2002, Chandigarh Infotech Centre Ltd Team Lead, Chandigarh India

Corresponded with the clients and explored the prospective customers

Preparation of presentation using Microsoft PowerPoint, documentation of software developed for users, programmers, and management

Managed the team members, trained new employees, as well as established employees

Responsible for requirement gathering, analysis, and design

Developed ad-hoc database queries and reports for users

Bharat Electronics Limited Bills Payable System, Panchkula India

Platform: Forms 6i, Reports 6i, Oracle 8x

Bills Payable System that includes receipt of Invoices, Advance Payment, Creating liability, Value Adjustable Note, Bank Payment Advice, Bank Authorization Letter, Debit Advice Note, LC Payment, and SRC (Store Receipt Control) Pricing. They had Payment Purchase Order, Subcontract Order, Work Order, Service Order, Letter Order, and Freight and Forwarding Agents. Payment is made on receipt of invoice or Performa Invoice. Their major reports are Advance Register, Invoice Register, LC Register, LC (Generation, Amendment, and Payment), BPS, DAS, and more.

Jan 1999 – Jul 2001 Innovative Hitech Solutions Pvt. Ltd., Team Lead/Programmer

Coded, tested, and integrated different modules

Validated and reorganized data collected from various concerned sources

Designed database following normalization rules

Maintenance and upgradations of previously developed applications

Developed stored packages, procedures, and functions

Jupiter Aqua Lines Pvt. Limited, Purchase, Inventory and Sales Management

Platform: Forms 6i, Reports 6i, and Oracle 8x

This project included a) Purchase, b) Inventory, and c) Sales Modules. It includes sales order, acknowledgement of orders, requisition for dispatch, packing list, invoicing, request for purchase, purchase order, material receipt note is the major document on which study has been done. There are different sales, rejections, purchase, and payment status, statutory reports (sales tax, Form ‘C’, Form ST-XXII, and more).

Rockman Cycle Industries, Ltd., Payroll System

Platform: Forms 6i, Reports 6i, and Oracle 8x

This system has been incorporated in all aspects of payroll system viz. Maintenance of Leave Records, Update Attendance Register, Processing and Posting Salary, Loans, Advances, and so forth. The Major reports of this system were Salary Slip, P.F., and ESI. Statements, Department wise Salary, Daily/Monthly Attendance, Leave Register, Attendance Register, Bank Statement, Absenteeism Report, Deduction Statement, and so forth.

Cosmo Ferrites Limited, Accounting, Invoice, Stores, Purchase and Sales System

Platform: Forms 5.0, Reports 3.0, Oracle 8.x, HP-UX 900

This Project is divided into two parts: 1) Accounting, and 2) Invoicing. The Accounting part includes all types of vouchers, ledgers, P&L Account, Balance Sheet, and such. All the invoices purchase, and other transactions done in other modules automatically entered in the Accounts. Invoicing includes all information regarding Customers, Sales, and Orders. This company had domestic, as well as international customers. For each type of customer, they do business in a different manner. The Major forms of this system were Customer Master, Sales Advice, Sales Invoice, and so forth. The Major reports of this system were Sales Invoice for Domestic/Export Customers on Pre-Printed Stationery, Region-wise Sales, Dispatch Summary, Excise Summary, Product-wise Sales, Sales Book, Sales Advice Backlog, On-date Dispatch Statement, and so forth.

Education and Training

Master of Science, Computer Science, Maharishi Dayanand University, India (January 2002 – January 2004)

Post Graduate Diploma, Computer Applications, Kurukshetra University, India (June 2000 – May 2001)

Bachelor of Commerce, Punjab University, India (May 1991 – June 1994)

OCP: I-SQL & PL/SQL (November 2000) and Oracle Architecture and Administration (Oracle 8i) (December 2001)

Advance Post Graduate, Computers and System Management (January 1993 – January 1996)

Contact this candidate