SUMMARY

• Over eight (8) years of experience in team management and database design, development, resource planning, debugging, testing, deployment, support and maintenance of business applications, including business requirements gathering, analysis and release management
• Experience in implementing all phases of Software Development Life Cycles using different methodologies
• Experience in resolving complex problems using logical/analytical capabilities and translating them into codes
• Experience in creating PL/SQL and T - SQL scripts using Packages, Stored Procedures, Functions, Cursors, Referential Cursors, Views and materialized Views/Indexed views as per the business requirements
• Experience in advanced PL/SQL concepts like bulk collect, Multi Table insert, Temp Tables, Exception Handling, Nested tables, Varrays, types, dynamic SQL, collections and records
• Worked along with the DBAs on Performance Tuning, backups and recoveries
• Experience in working with the software development life cycle (including agile development methodology), database design, RDBMS, data warehousing and data modeling concepts
• Experience delivering projects leveraging global delivery models (onshore/offshore) and multi-vendors teams
• Demonstrated leadership skills, strong team players and proficient in creating presentations

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/ 9i, MS SQL Server 2005, IBM DB2, MySQL, MS Access

Languages: SQL, PL/SQL, T-SQL, C, C++, Java, ASP, VB.NET, C#.NET, Javascript, XMLHTML, UNIX Shell Scripting, Python, Perl

Operating Systems: Windows 98/2000/XP/ 7, UNIX

Tools: Toad, ERwin, SQL *Plus, SQL *Loader, Visual Studio, Visio, Control-MWinSCP, ZOC SSH Client, Putty, Informatica PowerCenter 8.6/9.1, SSISSharePoint, SAP Business Objects, OBIEE, Rational Rose, IBM Quality CenterMS Office

PROFESSIONAL EXPERIENCE

Sr. Business Systems Consultant

Confidential, Buffalo, NY

Responsibilities:

• Reviewed the business user requirements and then converted them to the functional and technical specifications
• Developed enhancements to the existing ORION application
• Migrated data from ORION to IBM Open Pages application
• Generated the Confidential business units operational risk reports for the business users
• Developed business logic to integrate the business requirements of the compliance department with the Operational Risk Business Application
• Developed Capital Modeling data extracts based on the business requirements
• Worked with different vendors to evaluate and select software products, to meet the business requirements of the Confidential Global Operational Risk department
• Worked with the DBA to enhance the database performance by analyzing the hardware specifications
• Led the off-shore team to co-ordinate releases and reviewed the codes written by developers on my team
• Developed UNIX and SQL scripts for the automation of jobs using Control-M
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, and UTL FILE

Environment: Oracle 11gR2/12c, Toad, PL/SQL Developer, SQL*PLUS, SQL*Loader, Putty SSH Client (Shell Scripting), Control-M, FileZilla (FTP Client), IBM Open Pages, Oracle Financial Services Operational Risk, OBIEE 11g/12c

Sr. Programmer Analyst

Confidential, Menomonee Falls, WI

Responsibilities:

• Gathered the business user requirements, translated them to formal functional and technical specifications
• Conducted the data analysis to identify issues and resolved them by normalizing the data
• Developed and implemented the ETL processes to convert and transfer data from legacy database applications
• Documented the developed data models and ETL processes in Visio
• Developed SQL scripts for referential integrity checks which validated the incoming data with master tables in database
• Developed PL/SQL and T-SQL scripts using Packages, Stored Procedures, Functions, Cursors, Referential Cursors, Tables, Views and Indexed views as per the business requirements
• De-normalized the tables using Triggers to improve Read-Load Performance
• Used Control-M tool for automation of job scheduling
• Created Unix Shell scripts and PL/SQL scripts to publish the data to relevant databases and logged the process output
• Re-wrote the existing Perl Scripts to UNIX and PL/SQL scripts
• Loaded the data into the database tables from flat files using Shell Scripting (used SQL *Loader)

Environment: SQL Server 11/12, MS SQL Server Management Studio, Oracle 11gR2, Toad, SQL*PLUS, SQL*Loader, Putty SSH Client (Shell Scripting), Control-M, FileZilla (FTP Client), WinSCP

Programmer Analyst

Confidential, Freeport, NY

Responsibilities:

• Reviewed the business user requirements and translated them to formal functional and technical specifications
• Developed the application user manuals, training materials and trained the end users
• Fine-tuned procedures for the maximum efficiency in various schemas across the databases using Oracle hints, explained planned and traced Sessions for cost based optimizations
• Wrote complex SQLs using Joins, sub-queries and correlated sub-queries
• Handled Errors using system defined Exceptions and user-defined exceptions
• Loaded the data into the database tables from flat files using Shell Scripting (used SQL *Loader)
• Developed SQL scripts using Packages, Stored Procedures, Functions, Cursors, Referential cursors, tables, Views and materialized views as per the business requirements
• Developed SQL and PL/SQL scripts to transfer Tables across the schemas and databases
• Created Indexes and worked on disk sorts for fast retrieval of data from database objects to avoid the need for large-table and full-table scans
• Assisted the DBA in migration of the Oracle database from 10g to 11g, making the necessary changes to the UNIX scripts and Job Scheduler

Environment: Oracle 11g/10g, SQL Navigator, SQL*PLUS, SQL*Loader, UNIX Shell Scripting, WinSCP, ZOC SSH Client

SharePoint/SQL Server Developer

Confidential, White Plains, NY

Responsibilities:

• Worked as an SQL Server Developer for developing higher education services for Kaplan, Blackboard, SunGard, and Ellucian
• Worked as a SharePoint developer with responsibilities of managing site collections and site configuration
• Created site definitions with a custom master page and themes to brand sites and developed a CSS file to apply it to the sites to change the look and feel of the site
• Set up, configured, troubleshooted and repaired the end-user PC desktop hardware, software and peripherals

Environment: SharePoint Manager, SQL Server Developer, Visual Studio v9/10, Fiddler

Graduate Research Assistant

Confidential, NY, NY

Responsibilities:

• Co-authored the journal ‘Determinants of an Effective Cloud Computing Strategy’ with Confidential
• Assisted Confidential in Cloud Computing research by collecting, interpreting, analyzing and compiling data
• Preparedrecords and reports, helped and provided support in publishing the work, and was responsible for managing time for my research
• Assisted Confidential in teaching classes for individuals with intellectual and developmental disabilities from AHRC NYC