SUMMARY:

• Extensive work experience as a developer with RDBMS ORACLE, MS SQL Server.
• Strong knowledge of relational database and data warehousing concepts.
• Strong knowledge of SQL and data extraction, transformation and loading methods.
• Strong understanding of Software Development Lifecycle (SDLC). Many years of industry experience including software design, development, implementation, and system and unit testing to ensure and maintain data integrity and quality control of developed program units.
• Extensive experience of designing and developing PL/SQL, SQL*Plus scripts.
• Extensive experience of designing and developing reports using various reporting tools.
• Proven ability to manage and complete multiple projects under time constraints.
• Strong analytical and problem solving skills, attention to details. Excellent communication skills, including ability to work effectively with both end - users and engineers/programmers.

TECHNICAL SUMMARY:

• Windows XP/7/2008, Unix
• Oracle 10g,11g, MS SQL Server 2000/2005/2008 R2, Microsoft Access 2010, MS Excel
• SQL, PL/SQL, T-SQL, XML,Vbscript, shell, C#, PERL 4/5, Java, Javascript
• SQL*Plus, Oracle utilities, Oracle Designer/2000, Oracle Forms, Oracle Reports, SQL Developer,
• Business Objects Web Intelligence XI R1/R2, Crystal Reports,
• VS2010, SSIS, SSRS

EXPERIENCE

Software Engineer, Confidential 

Environment: Windows 2008, Oracle11g, PL/SQL, SQL*Plus, XML,SQL Server 2008R2, PostgreSQL, Windows Access 2010, Excel 2010, VS2010, T-SQL, Vbscript, SQL*Loader, Toad, Business Objects

Responsibilities:

• To upgrade Confidential Patient Portal application to a new version provide analysis of current and new databases.
• Develop an upgrade plan, map data, create and test upgrade scripts.
• Analysis and developing solution for generating testing data.
• Develop complex queries to extract and loads data, SQL queries tuning.
• Development of Vbscripts, SQL automation scripts to assist a production technical support team.
• Develop, test, implement PL/SQL, SQL*Plus scripts, creating tables and external tables, data corrections to resolve production issues.
• Provide ad-hoc, daily, weekly, and hourly statistic reports about production performance.
• Monitor production issues, correct corrupted documents, back up BFI administrator.

Data Management Analyst, Confidential 

Environment: Windows, Unix, Oracle9i, Oracle 10g, PL/SQL, shell, XML,SQL*Plus, SQL*Loader

Responsibilities and achievements:

• Perform Data Architecture Impact Analysis to recognize and report impact of any database model changes on the conversion project.
• DBA role in conversion team testing environments. Oracle baselines deployments to three testing environments to support conversion, and development teams, and business lines testing.
• Develop PL/SQL program unit and triggers, extensive SQL*Plus scripting, scripts for ad-hoc reports, shell scripting.
• Development of complex master records corrections and data backfills through the full lifecycle from inception to Change Order to production deployment.
• Perform scripting and deployments in Compensation and Pension Award Rate, and Adjustment processes, including scripts for loading data.
• Provide technical support, troubleshooting for development teams.
• Reports, research, and analysis of VETSNET processes and corporate database.

Database Developer/Report Writer, Confidential 

Environment: Windows 2003, Oracle9i, PL/SQL, Crystal Reports XI

Responsibilities and achievements:

• After enhancement database structure (normalization), analyze which reports needed changing
• Make changes in reports (fields, SQL queries, stored procedures, functions)
• Creating new reports (SQL queries, stored procedures, functions)
• Testing report results and tuning SQL queries. Creating or making changes in documents.

Database Developer/Analyst Confidential 

Environment: Windows 2003, Oracle9i, Oracle Forms, PL/SQL, SQL*Plus, SQL*Loader, Business Objects XI

Responsibilities and achievements:

• Perform Data Definition and Data Modeling for historical tables.
• Develop scripts for creating tables, views. Develop scripts for populating tables.
• Develop forms, write complex queries, stored procedures, triggers, functions.
• Develop number reports using Business Objects for marketing department needs.
• Testing report results and SQL queries tuning. Creating documents and user training.

Computer Programmer/Report Writer, Confidential 

Environment: Windows 2000/2003, Oracle8, Oracle Forms,MS SQL server, VS.NET, CrystalReports.NET, C#.NET, ADO.NET, ASP.NET, PL/SQL, SQL, JavaScript, HTML

Responsibilities and achievements:

• Responsible for presentation layers of desktop and web based applications using Crystal Reports.NET
• Data modeling, creating tables, views. Develop number reports using various data sources.
• Write complex queries, stored procedures to access data. Testing report results and SQL queries tuning.
• Creating forms for input and manipulating data.