SUMMARY OF QUALIFICATIONS

• 8 years of IT experience as DBA/Developer for MS SQL Server and Oracle Application Development in Production, Test and Development.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Agile / Scrum environment.

• Experience in writing and debugging Stored Procedures ,Triggers, Cursors, CLR etc
• Experience in SQL performance tuning using Cost-Based Optimization CBO .
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in using SQL Server Integration Services SSIS to build Data Integration and Workflow Solutions, Extract, Transform and Load ETL solutions for Data warehousing applications.
• Good Team Player, Strong Interpersonal and Communication Skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

• Languages: Java, C , C, C , T-SQL, PL/SQL, Visual Basic 6.0, VB.NET
• RDBMS: SQL Server 2000/2005/2008R2, Oracle 9i/10g/11gR2
• Operating Systems: Windows XP, XP Pro, Unix, Windows 2000/2003/2008R2 Server, Mac OS X, RHEL
• Development Tools: VisualStudio.NET 2005/2008, Visual Studio 6.0, Visual SourceSafe, Git
• Software: Microsoft Office Suite, Project, Visio, Outlook, Lotus Sametime, Oracle
• 11i E-Business Suite, Communicator, SQL Sentry, PowerShell, SQL Compare, MaxCass, NameSearch

PROFESSIONAL EXPERIENCE

Confidential

Developer - Consultant

• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Performed code review for peers and application developers.
• Created records, tables, collections nested tables and arrays for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Backup and restore databases.

Confidential

/ Developer

• Compose complex stored procedures for effectively and efficiently retrieving data from databases.
• Extract, Transform and Load ETL utilizing SSIS.
• Experienced extracting data from MySQL and Oracle RDBMS.
• Database administration tasks backup recovery, fragmentation, security, updates within a clustered multi-terabyte environment.
• Create database data layers called through workflows and accessed via web service.
• Performance tuning and remediation through optimization of T-SQL and indexing.
• Multi-tasking of various projects in conjunction with business partners.

Development DBA

• Utilize SQL Server Management Studio 2005/2008 to develop SQL Server database tables, stored procedures, jobs and data import/export functions.
• Review and approval of various database objects.
• Performance tuning and remediation handled through change management process.
• Communicate with Business clients and provide insight to database architecture

Confidential

Consultant

• Utilize SQL Server Management Studio 2005/2008 to develop SQL Server database tables, stored procedures, jobs and data import/export functions.
• Create detailed technical design documents to support development of system enhancements or defect resolution
• Work in a matrix management and cross-functional structure.
• Communicate with Line of Business clients and multi-task while adapting to change.

Confidential

Applications Developer

• Development using SQL Server 2005 SSIS, SSRS, SSAS, SQL tuning, indexing, review of execution plan for optimizing, and creation of SQL Agent Jobs.
• VB/C .Net Development with 2.0 Framework and creation of classes.
• Written stored procedures, ad-hoc reporting, and triggers using T-SQL in SQL Server 2000/2005.
• Creation of databases in support of quality assurance and data quality auditing.
• ETL development using SSIS / Oracle SQL Loader and monitoring of data loads. SSRS report model designed, implemented and documented.
• On call rotation for 24 x 7 x 365 day production environment.

Sr. Financial Systems Analyst/Consultant

• Developed and maintained of SQL Server 2000 entailing stored procedures, DTS packages, tables, views, backup and recovery.
• Maintained VB6 applications for internal reporting purposes and developed ad-hoc Crystal Reports as needed.
• Administered FRx Reporting and MAS500 which entailed user security, account maintenance, financial report development internal and external .

Business Planning Analyst/Sr. Cost Accountant

• Proof of concept development, user acceptance testing, system analysis design
• Daily usage of Microsoft Office, Monarch application, Tm1 Database, GEAC, and A/S 400 to perform planning and cost analysis duties.
• Communicate internationally and nationally to maintain reporting and analysis.
• Multi-currency system configuration and deployment.

Confidential

Plant Accountant/Operations Analyst/Staff Accountant

• Daily use of Microsoft Office, Cimpro general ledger, and Fixed Asset Software for Windows to perform inventory reconciliation and enhance accounting processes.