Database, SQL, Analyst

Objective

To pursue a challenging career, while utilizing my skills to achieve professional growth

Summary of Skills

Excellent analytical and problem solving abilities; Excellent communication and inter-personal skills; Team player and hard worker with adaptability and willingness to learn and acquire new skills; Exceptional ability to understand and apply new principles and concepts

Certifications

Oracle 9i PL/SQL Developer Certified Associate; MCP in Developing and Implementing Windows Based applications using Visual Basic. Net and Visual Studio. NET; Brain bench certified in RDBMS concepts and SQL (ANSI) Fundamentals

Experience

Conduent/inVentiv Health – Database Analyst (Project Based) 8/16 –

Responsibilities include

Creation of PL/SQL scripts (packages, procedures, functions, views) to facilitate the functioning of a web based system with Oracle databases

Performance tuning using indexes, analysis and rewriting SQL statements in a manner that avoids full table scans, analyzing tables, restructuring query joins and so on

Leading production support efforts for issues reported internally or by client, system exception errors, reconciliation of monthly reports, creation of queries to extract data for business use, ad-hoc reports and so on

Working with the Business Analysis team on SOPs and Business Rules documents to create mapping and gap analysis documents

Unit Testing and collaborating with testers during internal and User Acceptance testing to identify and solve any data or system related data issues

Report generation using PL/SQL scripts and interfacing with Microstrategy

Automation of processes including reports and extraction of data to be made available at specific points of time (Monthly, Weekly and Daily Reports)

Documenting standards for database scripts and verification of the same for production updates

Environment: Oracle 9i/11g, PL/SQL, SQL Plus, TOAD, SQL Loader, Oracle Export/Import

inVentiv Health – Database Analyst 02/13 – 10/14

Responsibilities included

Extensive end to end analysis, mapping of data, preparation of requirement documents and SOPs in conjunction with Business Rule documents and SLAs

Direct interaction with vendors and clients in identification of gaps and solutions

Creation of PL/SQL scripts to export data from a new vendor

Driving production support efforts for the resolution of production trouble tickets for any issues reported internally or by client, system exception errors, reconciliation of monthly reports, creation of queries to extract data for business use, ad-hoc reports and so on

Unit Testing and collaborating with testers during internal and User Acceptance testing to identify and solve any data or system related data issues

Creation of PL/SQL scripts to generate and maintain monthly reports involving microstrategy

Environment: Oracle 9i/11g, PL/SQL, SQL Plus, TOAD, SQL Loader, Some Unix, MS SQL Server, Oracle Export/Import Utility

inVentiv Health – Database Analyst 12/10 – 02/11

Worked on documenting the mapping of data for transfer from an existing windows based system onto a web based system

Environment: Oracle 9i/11g, PL/SQL, TOAD, SQL developer, SQL Loader, Export/Import

inVentiv Health – Database Programmer-Analyst 4/05 – 04/10

Worked with the development and maintenance of the healthcare system Business Acceleration Technology (BAT) and Institutional Patient Assistance Program (IPAP) that serve various big Pharmaceutical clients across the US.

Responsibilities included

Analysis and mapping of data and preparation of technical specifications

Creation and maintenance of databases and configurable parameters capable of being ported across programs

Day to day production support of existing systems including systems errors, ad-hoc queries to retrieve data for business needs

Part of a team to lead the Design and development of a new web based solution

Identifying and developing data models and design flows for an optimal system

Environment: Oracle 9i/11g, PL/SQL, SQL Plus, TOAD, SQL Navigator, SQL Loader, Oracle Export/Import Utility, SQL 2000, SQL 2005, Oracle enterprise Manager, Crystal Reports, VB.NET

McKinsey & Company – Programmer/Analyst 02/04 – 04-05

PL/SQL scripts to retrieve and analyze large volumes of data on a daily basis

Periodic analysis of database objects for performance bottlenecks

Develop PL/SQL and UNIX Shell scripts to implement requirements as needed

Defining requirements to map all existing and necessary functionalities from the current system to a newly proposed system

Automating current processes to eliminate the need for manual monitoring

Environment: Oracle 8i/9i, PL/SQL, SQL Plus, Oracle forms, Developer 2000, SQL Navigator, TOAD, Unix Shell Scripts

Citibank - Programmer/Analyst 10/98 – 07/01

Worked for the credit card division of Citibank

Key Projects:

Common ATM Pin Generation, Renewal and Reissue of credit cards, E-Card, E-Wallet, Contact Point Verification Upload, Automatic response generation of credit card applications, Behavioral Scoring, Y2K Testing.

Involved in business discussions with users to identify requirements

PL/SQL scripts including stored procedures, functions and packages to implement business logic

Generated data files in appropriate formats to be downloaded at various international locations

Provided on call support for all projects post-implementation

Environment: Oracle 8i/9i, PL/SQL, UNIX Shell Scripts, C, Pro *C

Education

1998-2001: Master of Computer Applications, Bharathidasan University, India

1996-1998: Diploma in Systems Management, NIIT, India

1995-1998: Bachelor of Commerce, Madras University, India

Contact this candidate