We provide IT Staff Augmentation Services!

Sql Server Databases Admistrator Usa

4.00/5 (Submit Your Rating)

SUMMARY OF QUALIFICATIONS:

  • IT professional with a Masters qualification and 5 years of experience.
  • Experience in both mainframe (4 years) and windows environments (1 year). Have a high aptitude for working in multiple technologies and platforms.
  • Experience in working directly with the clients.
  • Experience in Banking (Securities, Investment Management, Credit Cards), Healthcare and Insurance domains.
  • Good knowledge of the SDLC life cycle, SDLC deliverables and processes.
  • Experience in analysis of business specifications and preparing design documents.
  • Experience in developing application software on IBM Mainframes using COBOL, Microfocus COBOL, VSAM, DB2, JCL, C, SQL and Unix Shell Scripting.
  • Experience in maintaining Windows applications using VB6, VB.Net, SQL Server and SQL.
  • Experience in Unit, Integration, System and User acceptance testing.
  • Experience in development, execution and maintenance of test plans, test cases and test scenarios.
  • Experience in working with DB2, SQL Server and Sybase databases.
  • Expertise in using utilities/tools like FILE-AID, IDCAMS, Endevor, Xpediter and SPUFI.
  • Experiencein using ZEKE job scheduler.
  • Experience in working in Maintenance, Production support and Development environments.
  • Experience in preparing QMS (Quality Management System) documents.
  • Ability to work in both independent and team-oriented environments.
  • Excellent communication skills, leadership qualities and interpersonal skills with aptitude for learning and creativity.
  • Experience in handling knowledge sharing sessions.
  • The project Aetna-PBC in which I was a part, won the best project of the year 2007 award at Cognizant Technology Solutions, Coimbatore, India.

EDUCATION:

Master of Computer Science

B.E.(Electrical and Electronics)

TECHNICAL SKILLS:

Mainframes:

COBOL, Microfocus Cobol, JCL, CICS, Z/OS, TSO/ISPF, VSAM, MQ Series, IDCAMS, File-Aid, Xpediter, ENDEVOR, SPUFI, ZEKE job scheduler, SCLM, Syncsort

Programming Languages:

VB6, VB.Net, C#, C, C++, SQL, Java, Unix Shell scripting, JavaScript, R

Markup Languages:

HTML, XML

Databases :

DB2, Sybase, Oracle 10g, SQL Server

Tools:

Visual Studio, RapidSQL, Rational Rose, Visual Source Safe, TFS, Latex, Clearcase, MS Visio, MS Expression Web, MS Office Suite

PROJECT PROFILE:

Project Title: Mini Data Warehouse quarterly load and load process improvement

Company: Confidential

Client: Confidential, USA

Duration: Jan 2012 June 2012

Project description: Confidential, property and casualty insurance company with its home office located in Springfield, Missouri. ANPAC provides for a variety of property and casualty coverage needs, including automobile, homeowners, umbrella, boat, recreational vehicles, motorcycle, other personal lines insurance and agri-business insurance. ANPAC is maintaining a SQL SERVER database, referred to as a “mini data warehouse”, that provides details to actuaries and other units for analyzing the policy data. This database has to be loaded after completion of each quarter. The majority of policy data resides on mainframe, either in DB2 tables or files. This data is extracted by executing COBOL based ETL programs and SORT jobs. The files created by the mainframe jobs are FTP’d to SQL SERVER and loaded into two SQL SERVER databases. Once the development SQL SERVER database is loaded and results verified, information is sent to production support group for loading the production data warehouse and released to users. Now there are 335 SQLs that are run in SQL SERVER manually. Most of the SQLs can run in groups by batch scripts. After analysis, it has been determined that the 220 SQLs in Auto can be grouped into 15 different scripts and 115 SQLs in RCT can be grouped into 12 different scripts. This will help the developer by running only the 27 batch scripts instead of 335 SQLs. Once the batch scripts are created, it should be possible to save 15-20 hours per quarter for the mini-datawarehouse load.

Skills used: COBOL, JCL, IDCAMS, Syncsort, File-Aid, SQL Server.

Role:

  • Involved in quarterly load of the SQL SERVER databases.
  • Fixed issues that may be reported by the production support group.
  • Involved in the analysis of the load improvement process.
  • Involved in preparing the batch scripts.
  • Performed unit and integration testing.
  • Took ownership of the new project and system.

Project Title: Maintenance and Support of Paris system of Anpac

Company: Confidential,

Client: ANPAC, USA

Duration: May 2011 June 2012

Project description: Confidential, property and casualty insurance company with its home office located in Springfield, Missouri. ANPAC provides for a variety of property and casualty coverage needs, including automobile, homeowners, umbrella, boat, recreational vehicles, motorcycle, other personal lines insurance and agri-business insurance. PARIS is a standalone application used by agents to process new business apps and policy changes. Nuforms is a 3rd party application integrated with the PARIS and used to format documents for use by agents. It allows the agents to have fillable forms. Variable data (about the client) is pulled from Paris and filled in on the form template. The original intent of the project is to move towards a “paperless office”.

Skills used: Applications integrated with the PARIS system like Paris, Nuforms Designer, SQLXport, Create_PDF, VB6, MS Access.

Role:

  • Building and testing the forms.
  • Performed technical support by analyzing issues related to Paris.
  • Involved in the analysis of the application and their code.
  • Involved in end user interaction.

Project Title: Duck Creek Non-Rating for HomeROP

Company: Confidential,

Client:Confidential, USA

Duration: October 2011 Jan 2012

Project description: Confidential, property and casualty insurance company with its home office located in Springfield, Missouri. ANPAC provides for a variety of property and casualty coverage needs, including automobile, homeowners, umbrella, boat, recreational vehicles, motorcycle, other personal lines insurance and agri-business insurance. The focus the project is to pull the data from Duck Creek for HOME_MISC_RATE_SET table and its child tables. In the next phase, modify batch and online modules that are currently looking up maintenance data from the HOME_MISC_RATE_SET table to call the new Duck Creek tasks.

Skills used: COBOL, CICS, JCL, DB2, Expediter, XML, VSS.

Role:

  • Involved in the analysis of the project requirements.
  • Prepared the batch module analysis documents and approach documents.
  • Involved in coding of the batch and online modules.
  • Prepared test cases and test plans.
  • Performed unit and integration testing.
  • Involved in code and copy code reviews
  • Involved in Quality Control activities.

Project Title: Maintenance and Support

Company: Confidential,

Client: Confidential,

Duration: January 2011 Dec 2011

Project description: Confidential, property and casualty insurance company with its home office located in Springfield, Missouri. ANPAC provides for a variety of property and casualty coverage needs, including automobile, homeowners, umbrella, boat, recreational vehicles, motorcycle, other personal lines insurance and agri-business insurance. The goal of this project is to provide support to the following windows applications - Quasar, Issues32, ITS, Devwiz and SRW. Any issues in these applications need to be addressed, either through code fix or through the application functionalities.

Skills used: VB6, VB.Net, SQL Server, SQL, Visual Studio, VSS, TFS

Role:

  • Learnt the new Windows technologies and applications within a short span of time and was able to take over independently.
  • Took ownership of the applications.
  • Performed day to day application technical support by analyzing issues.
  • Involved in the analysis of the applications and their code.
  • Implemented new releases of the applications by coordinating with the clients.
  • Involved in end user interaction.
  • Performed unit testing, integration testing and end user testing.
  • Worked with stored procedures.
  • Handled knowledge transfer sessions.

Project Title: Policy Data Services

Company: Confidential,

Client: Confidential, USA

Duration: Jan 2011 March 2011

Project description: Confidential, property and casualty insurance company with its home office located in Springfield, Missouri. ANPAC provides for a variety of property and casualty coverage needs, including automobile, homeowners, umbrella, boat, recreational vehicles, motorcycle, other personal lines insurance and agri-business insurance. Anpac’s systems rely on data from several different sources. These data sources are not always in sync and do not always contain the most up to date data. The vision for Phase 1 of this project is to get the Policy and Account information for Auto policies from VSAM files and DB2 based on a request from the open side and pass the data back to the requestor, whether that is Client Services, an iPhone, SAM, or something else.

Skills used: COBOL, JCL

Role:

  • Involved in the analysis and design.
  • Involved in code and copy code reviews
  • Involved in Quality Control activities.

Project Title: Company Expansion

Company: Confidential,

Client: Confidential, USA

Duration: June 2010 Dec 2010

n

Project description: Confidential, property and casualty insurance company with its home office located in Springfield, Missouri. ANPAC provides for a variety of property and casualty coverage needs, including automobile, homeowners, umbrella, boat, recreational vehicles, motorcycle, other personal lines insurance and agri-business insurance. The goal of the Company Expansion project is to remove PACJWCM8 and PACJPCM8 copycodes. There are several options that can be used to remove these copycodes such as making a call to PAUJ020, adding embedded SQL to query DB2, using the 88 levels in PCUJ020, etc. The approach taken will vary depending on the logic and needs of each program.

Skills used: COBOL, JCL, DB2, CICS, SPUFI, Endevor, Visual Source Safe, Expeditor.

Role:

  • Involved in the analysis of the COBOL and CICS programs.
  • Made changes in the programs.
  • Made changes in copybooks and JCLs
  • Prepared test plans.
  • Performed unit and parallel testing.
  • Involved in Quality Control activities.

Project Title: PBC-SRQ

Company: Confidential,

Client: Confidential, USA

Duration: May 2007 - August 2008 (16 months)

Project description:Aetna is a health care insurance company providing medical, dental, pharmacy and long-term care insurance and employee benefits. Aetna provides benefits through employers in all 50 states of the US. The project involves development and providing maintenance for the Guide application in the Sales-Rating-Quoting (SRQ) domain of Aetna. Guide enables creation of new HMO Quotes and the renewal of existing Quotes. It is used by Aetna sales personnel to provide information needed by customers and potential customers to make informed purchasing decisions.

Skills used: COBOL, JCL, Microfocus COBOL, UNIX shell scripting, C, Sybase, RapidSQL, Endevor, Xpediter, MS Visio, MQ Series

Role:

  • Module lead and took ownership of the Guide application and was responsible for its health and maintenance.
  • Worked on change requests and scheduling of various monthly and quarterly maintenance jobs through ZEKE job scheduler.
  • Performed day to day application technical support by analyzing production issues. Managed support tickets including distribution to other staff members as needed
  • Developed/modified source code using COBOL, Microfocus COBOL, C and SQL.
  • Used Unix Shell Scripting extensively.
  • Used MQ to monitor data flow across the application.
  • Performed production implementation upon successful user acceptance testing.
  • Worked with DB2 and Sybase stored procedures.
  • Frame and execute SQL queries to extract various reports as and when requested by the clients.
  • Updated QMS (Quality Management System) documents like Project action plan, Detailed Requirements Specifications, Impact Analysis, Application Design Specification, Application Development plan, Unit Test Plan, System Test plan and Implementation plan.
  • Provided support to various internal and external teams within Cognizant and outside.
  • Involved in operating system and database system upgrades.
  • Used VSS and Endevor for source code management and version control.
  • Handled Knowledge transfer sessions to the new members of the team.

Project Title: Problem Management Requests

Company: CConfidential,

Client: Confidential, UK

Duration: March 2006 - February 2007 (12 months)

Project description:First Data International is a payment processing company with a portfolio of services including merchant transaction processing services; credit, debit, and other prepaid card offerings; electronic check acceptance services through TeleCheck; as well as mobile payment solutions. My project was to analyze production issues relating to services like billing, collection etc. I worked on SSUPDATE, the second largest COBOL program in the world that maintains the cardholder accounts for 280 million cardholders and processes more than 20 million transactions that are input daily. Any issues arising in SSUPDATE need to be analyzed and the production code needs to be fixed to correct the issue.

Skills used: COBOL, JCL, DB2, SPUFI, Endevor, Expeditor

Role:

  • Analyzed the production problems arising in the processing system.
  • Performed code changes or data patching using COBOL, JCL and Xpediter if necessary
  • Updated all the QMS (Quality Management System) documents accordingly.
  • Performed manual testing and implementation.
  • Participated in meetings with clients.
  • Handled Knowledge transfer sessions to the new members of the team.
  • Participated in Quality Assurance and Quality Control activities.
  • Used Generation Data Groups (GDG’s) in production and test for storing and retrieving data.
  • Maintained the issue log and the issue checklist.
  • Attended an Assembler introduction session.

Project Title: Anti-money Laundering

Company: Confidential,

Client: Confidential, USA

Duration: November 2005 February 2006 (4 months)

Project description: Northern Trust is one of the leaders in providing investment management, asset and fund administration for corporations, institutions and individuals worldwide. Anti-money laundering guidelines came into prominence globally after the September 11, 2001 attacks. The project is to create an anti-money laundering software application for the Northern Trust which monitors bank customer transactions like cash deposits and withdrawals, wire transfers, on a daily basis and, using customer historical information and account profile, provides a "whole picture" to the bank management.

Skills used: COBOL, JCL, DB2, SPUFI, Endevor, Visual Source Safe, Expeditor.

Role:

  • Involved in the analysis of the business specifications.
  • Developed source code using COBOL, DB2 and JCL.
  • Made changes in copybooks and JCLs
  • Prepared test cases and test plans.
  • Performed manual unit and integration testing.
  • Actively participated in project review meetings.
  • Handled coding and code review according to quality check list.
  • Attended a CICS training session.

TRAINING PROGRAMS UNDERTAKEN THROUGH COGNIZANT ACADEMY:

  • Health Care, Duration: 1 month
  • Credit cards, Duration: 1 month
  • Securities and Investment Management, Duration: 1 month
  • Financial Services Foundation, Duration: 1 month
  • Entry Level Training (Mainframe), Duration: 2 months

AWARDS:

The project Aetna-PBC in which PBC-SRQ was a part, won the best project of the year 2007 award at Cognizant Technology Solutions, Coimbatore, India.

GRADUATE COURSE WORK:

Algorithms, Databases, Data Mining, Service-Oriented Computing, Electronic Commerce Technologies, Human Computer Interaction, Computer Networks, Connection-Oriented networks, Software Engineering, Management Decision and Control Systems.

GRADUATE COURSE PROJECTS:

  • Implemented a database in Java for an emerging courier company providing a whole range of parcel delivery and logistics services. Used SQL as the query language and Oracle10g for the back end.
  • Prepared a comprehensive report on an agile methodology called Extreme Programming.
  • Implemented an online shopping cart system using IBM Websphere sMash, JavaScript and Groovy.
  • Published a chapter about parallel graph mining, for a book titled "Practical Graph Mining with R: Students Series".
  • Designed and developed a website for the NCSU computer science department to prepare for a visit from an external assessment team using Microsoft Expression Web, HTML and JavaScript.

We'd love your feedback!