SUMMARY:

Database Analyst - Programmer with 10+ years of experience in database programming, interpreting and analyzing data for business solutions.

CORE COMPETENCIES:

• Strong prioritization skills and analytical ability to multi-task several high priority initiatives
• Expert knowledge of SQL, PL/SQL and relational database management systems
• Expertise in PL/SQL subprograms, user defined aggregate functions, PL/SQL collections, Indexes( B-Tree, Bitmap, Function based Indexes) and performance tuning
• Proficiency in Microsoft Office
• Excellent knowledge in manipulating, cleansing &processing data using Excel and SQL
• Expertise in business process engineering and SDLC
• Experience with Waterfall and Agile methodologies
• Familiarity and Training with ETL processes and Methodology

EXPERIENCE:

Confidential

Data Analyst/Programmer, Lebanon, NJ

Responsibilities:

• Data analysis of a large Oracle Data warehouse involving Data Quality and Data Rules testing
• Creation of extensive test cases and Oracle sub programs to verify data
• Building Oracle Framework to automate analysis and testing processes
• Creation of Reports to project data in a user readable format
• Extensive performance tuning using parallelism, indexes, PLAN TABLE, query tuning and so on

Environment: MS Word, Oracle 11g/12C, PL/SQL, PL/SQL developer, TOAD, SQL Loader, MS excel data analysis, Tableau

Confidential

Business/Data Analyst/Programmer, Somerset, NJ

Responsibilities:

• Worked on introducing a new program for an existing Pharmaceutical client
• Engaged client to gather requirements/business rules and ensure alignment between teams
• Analyzed client’s business requirements and processes through document and workflow analysis
• Provided input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Created PL/SQL scripts and/or updates to existing code to match technical specifications
• Performance tuning using indexes, analysis and rewriting SQL statements, analyzing tables, restructuring query joins etc.

Environment: MS Project, Word, Visio, Oraclse 9i/11g, PL/SQL, TOAD, SQL Loader, MS excel data analysis

Confidential

Data Analyst /Programmer, Somerset, NJ

Responsibilities:

• Led a phased effort to migrate large data sets into an internal proprietary system (inSupport)
• Created of extensive PL/SQL scripts to load data sets alongside performance tunin
• Translated stakeholder requirements into tangible deliverables such as functional specifications, user cases, process diagrams, data flow/data model diagrams.
• Evaluated risks related to implementation, testing processes, project communications, and training
• Identified and reconciled errors in client data to ensure accurate business requirements.
• Drafted and maintained business requirements and align them with functional and technical requirements.
• Facilitated weekly meetings with clients to document requirements and explore potential solutions.
• Introduced to Salesforce as part of design discussions to migrate existing web based systems
• Provided quick resolution of any unanticipated issues and communicating and documenting the same

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

Confidential

Database Analyst /Programmer, Somerset, NJ

Responsibilities:

• Led migration of big sets of data for several pharmaceutical clients into an internal proprietary system (inSupport)
• Performed extensive end to end analysis, data mapping and developed functional and technical specifications
• Developed reports within the custom Proprietary Reporting system (BRU)
• Provided day to day production support on both Oracle and SQL server systems
• Actively participated in the design and development of new web based solutions

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

Confidential

Programmer/Analyst, Manhattan, NY

Responsibilities:

• Worked on proprietary CRM system/Data Mart (SPOT) handling large day to day transactions
• Developed PL/SQL scripts to retrieve and analyze large volumes of data on a daily basis
• Performed periodic analysis of database objects for performance bottlenecks
• Defined and documented requirements to map functionalities for a system migration
• Automated 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

Confidential

Programmer/Analyst

Responsibilities:

• Involved in business discussions with users to identify requirements
• Created Pro *C and PL/SQL scripts on Unix Platforms
• 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