SUMMARY

• Innovative Senior Database Developer with over 20 years of advanced expertise in software design, development, analysis and support with particular strength in PL/SQL.
• Multifaceted experience working in complex mixed - platform environments consisting of legacy and new technologies from a wide range of vendors.
• Solid expertise working with Oracle Databases, OLTP and OLAP Data warehousing environments providing solutions to enterprise organizations.
• Interacting with internal and external clients and stakeholders to finalize project architecture and processes, estimate resources, allocate tasks, etc.
• Ability to multi-task, quickly learn new technologies and adapt to changing environments.

TECHNICAL SKILLS

Programming Languages and Software: PL/SQL, SQL, SQL*Plus, Oracle Scheduler, Toad, SQL Developer, FileZilla, PuTTY, UC4, Java 1.7/J2EE, JDBC, JSP, JSON, XML, HTML, JQuery, Apache Tomcat 7.0, JBoss, Spring, Hibernate, Struts, Camel, Eclipse Juno, Spring Tool Suite 3.4, IntelliJ 13.1, UC4, Visual C++, C, PowerBuilder 4.0, Jira, Impulse, Subversion, Perforce, MS Visual SourceSafe, DataStage 7.5, Oracle Forms 4.5, Oracle Reports 2.5, Adobe Acrobat, MS Office, Install Shield, Visio, AWK 4.0, SAS 6.11, 4th Dimension

Databases: Oracle 11g/10g/9i/8i/7.x, H2, SQL Server 7.0/6.5, MS Access 2000/97/7.0/2.0

Operating systems: Windows XP/10, UNIX, Mac System 7.1, Linux RedHat

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle PL/SQL Developer/Contractor

Responsibilities:

• Participated in design of BBLITE process flow as well as physical and logical data models for BBLITE database
• Created PKG CRD GENERATION package to encapsulate all logic needed to create CRD files. Worked with Java team on requirements and testing since the code was to be used for Java services.
• Created Database Objects such as tables, sequences, synonyms, views, materialized views, indexes, stored procedures and functions
• Created and tested deployment scripts, moved them to production, and performed testing.
• Improved performance of long running queries using indexes, hints and creating materialized views.
• Wrote complex SQL queries joining multiple tables, using aggregate and analytic functions, PIVOT, UNPIVOT and WITH clauses
• Created procedures to log processing time and errors into logging tables
• Synced testing databases to production for integration testing using DB compare tool
• Worked with Business Analysts and Subject Matter Experts to create, analyze and clarify project and tasks requirements.
• Analyzed Informatica mappings and altered the tables as per the requirement
• Wrote detailed Oracle Design Documents based on the business requirement documents provided by Business Analysts.
• Troubleshot, fixed and implemented bug fixes and enhancements within tight deadlines.

Confidential, Vernon Hills, IL

Senior PL/SQL Developer / Oracle Expert

Responsibilities:

• Developed, tested, and optimized Oracle queries and PL/SQL code for the migration of large datasets.
• Created, enhanced, and debugged complex packages, stored procedures, functions, triggers using PL/SQL.
• Used Bulk Collections for better performance and easy data retrieval, by reducing context switching between SQL and PL/SQL engine.
• Create views and materialized views for data replication in distributed environments.
• Perform SQL tuning using EXPLAIN PLAN, AUTOTRACE and TKPROF to optimize complex report queries and to add indexes to tables for improved performance,
• Used SQL*Loader to load data into data from external files into staging tables
• Performance tuning of complex views and PL/SQL programs
• As a part of the Support Team provide Database related support for Confidential clients.
• Developed errors handling routines to save errors into the logging tables.

Confidential, Chicago, IL

Oracle PL/SQL Developer/Contractor

Responsibilities:

• As part of Risk IT team, developed and enhanced complex extracts from the GOLD Data Warehouse. The extracts are fed into web based applications providing financial reports to clients.
• Acted as a lead developer on various projects, most notably SHADOW migration, Super Basic Id Transformation, Third Party Equity project, etc.
• Designed, coded and tested complex database packages and procedures testing in Data Warehouse environments with in-house ETL tools.
• Worked closely with BA, Offshore and Onsite development and DBA teams on functional and technical requirements, development, QA, and releasing code to production.
• Handled numerous enhancement and maintenance requests, data updates, bug fixes.
• Provided knowledge transfer and mentoring to new and junior team members.
• Performed data analysis and validation to ensure the integrity of client financial reports.
• Created and updated workflows and processes to extract and compress data files and deliver (FTP) them to the target servers for subsequent import into the front end reporting applications.
• Optimized and tuned long running queries and views using various techniques such as Explain Plan, Analyze table, adding explicit cursors with bulk collect, creating indexes, hints, temporary tables, etc.
• Used Oracle Analytic functions to perform complex aggregations and calculations.
• Created and modified Unix shell scripts for testing, compressing files, moving files between servers etc.

Confidential, Chicago, IL

Senior PL/SQL Developer

Responsibilities:

• Created PL/SQL packages/procedures and scheduled jobs to transfer data to the IC ADMIN (the schema behind call center vendor software) and update ADTRACK (main StudentScout schema) with call results.
• Provided design and data modeling for StudentScoutOracle Database as well as for the processes propagating data to the front-end systems.
• Architected, designed and created processes and interfaces for client integration projects, StudentScout Management Portal and StudentScout Reporting System.
• Generated complex reporting data feeds for subsequent generation of client facing reports.
• Implemented user friendly processes to load campaigns for clients using the SQL Loader, MS Excel, extracted data from Oracle table to MS Excel.
• Extensive experience in writing and tuning complex queries, SQL, stored procedures, functions, and triggers.
• Created Oracle tables, Views, Constraints, Synonyms, Sequences.
• Conducted Oracle database and SQL tuning to improve applications performance, used inline and sub queries, Dynamic SQL, materialized views, etc.
• Involved in Logical and Physical Database Layout Design.
• Loaded flat files with the client data into OLTP Database and developed processes to propagate the data into front end systems.
• Developed Candidate Management web portal for clients to review Candidates status, set appointments, assign candidates to Admission Reps, etc.
• Designed and built Web Services applications to exchange data with many StudentScout clients. Early clients were implemented using SOAP/WSDL based model within iWay framework. Recent clients were integrated using REST methodology under Tomcat application server.
• Created Unix shell scripts for testing, data parsing and manipulation, loading files into the DB.
• Developed Unix shell scripts to automate repetitive tasks and scheduled them using Crontab.
• Solely responsible for development of Web Reporting tool for key business users to generate reports for internal and external use.
• Continuously worked with users to refine and improve processes and applications.
• Troubleshooted, fixed and implemented bug fixes and enhancements within tight deadlines.

Confidential, Schaumburg, IL

Senior Developer

Responsibilities:

• Developed and/or enhanced numerous stored procedures, triggers, batch and PL/SQL files that ran nightly to manage data between the databases used by Pepsi Americas.
• As a team member designed, developed, supported, documented, and deployed applications and enhancements relating to the vendor package called Thinque Mobile Solutions Platform (TMSP). TMSP was a mobile enterprise solution that coordinated sales, marketing, and audit processes between the Confidential home office and mobile workers.
• Solely responsible for full life cycle development of Thinque Downloads Interface (TDI) extract data from the host database into the form that can be read by the TMSP. The extracted dataset was written into a flat file that containing sales representatives, routes, customers, products, and pricing information. Optimized and enhanced performance of the application by tuning SQL and creating necessary indexes for the host database. Front end is written in Java 1.5 with extensive use of JDBC. Back end is Oracle 10g.
• As part of a team worked on design, development, testing and implementation Central Data Repository (CDR) database. Created new release of Thinque Download Interface to extract data from CDR structures. Ensured the extraction process completed 20% faster then with previous version of TDI.
• Developed, tested and maintained Order Monitor (Thinque Uploads Interface) in Java to move orders sent by sales reps from Thinque Database to Pepsi Order Management and Routing System (OMAR) for further processing. The order data was moved directly from Thinque Database to OMAR Database. Created utilities to handle exception cases and notify interested parties using Java 1.5 (specifically using JDBC and JavaMail API).
• Created and maintained various web reports to view sales rep’s activities, status of orders, number of orders sent per location, etc. Java Servlets and JSP were used to create reports.
• Conducted interviews with the users in order to establish technical specifications for new system development and enhancements. Documented technical specifications for management and user's approval. Coded, tested, and implemented changes into production. Created test plans and performed Quality Assurance for variety of phases of the project.
• Recognized the need for improvement in existing process/applications, presented solutions and implemented plan to the team
• Ensured that systems development methodology was followed and key components such as design, testing, code reviews, and technical documentation were completed for each project.
• Provided training and support to other business analysts, programmers, and users.

Confidential, Chicago, IL

Programmer Analyst

Responsibilities:

• Participated in analysis of client requirements, design and implementation of Case Management System (CMS 3.0). The system is used to keep track of respondents’ personal, sample, address information, etc. The work was done using Oracle 7.2, PL/SQL 2.2, SQL*Plus, Oracle Forms 4.5, Oracle Reports 2.5, SAS 6.11, AWK 4.0.
• Involved in prototyping, development, coding and testing of front end forms allowing users easy access to data and ability to view information restricted by various criteria, such as date range, dispositions, etc. Participated in creating miscellaneous reports, such as completion reports by region, interviewer’s caseload report, statistical analysis, etc.
• Created stored procedures and functions to perform data validation, error handling, calculate various totals, reformat data, return status of the case, etc. Developed database triggers to maintain data integrity and populate log tables.
• Set up and monitored several nightly batch jobs.
• Solely responsible for design and implementation of ECLS. The system was used to keep track of schools, principals, teachers and students involved in a study. Front end of ECLS was written in Power builder 4.0 with SQLBase running on the back end, Gupta SQL, SAS 6.11.
• Designed database tables, views, and relations. Normalized data. Developed SQL queries and updated scripts.
• Responsibilities included working on client deliverables, creating user interface, setting up and monitoring overnight batch processes, preparing preload files and importing/exporting data (for custom software), data cleaning and conversion, producing ad hoc reports when requested, writing documentation, trouble shooting, testing and maintenance.

Confidential, Lincolnwood, IL

Software Developer

Responsibilities:

• Developed, coded and maintained Cleaning Quality Assurance System (CQAS) for Confidential . Confidential provided office-cleaning services. CQAS was designed to keep track of buildings, zones, and rooms where the service was performed as well as grading the tasks completed in each area. Quality Assurance personnel used Apple Newton Handhelds to enter data to be transferred into CQAS. The CQAS and Handheld software was written in 4th Dimension using Mac System 7.1 environment. Modules used: 4D Chart, 4D Write.
• Created custom reports providing information on work assignments, lists of zones, rooms and tasks, QA Report by Task, Defective Tasks Analysis, etc. Included functionality to restrict reports by building, zone, date range, and other criteria.

Confidential, Chicago, IL

Programmer Analyst

Responsibilities:

• As a team member participated in design, coding and implementation of Forfeiture Sale Bill (FSB) processing system for the office of Cook County Clerk and Department of Treasury, City Hall. FSB was written in Pascal under CTOS operating system on Unisys machine.
• Implemented and tested modules to enter bills, modify bills, produce permanent receipt, and post a report about current state of the bill. Other responsibilities included installation and testing of system on site and providing maintenance and support.