** ***** ** ********** ** 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.
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
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
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
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
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
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
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
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)