SUMMARY

Experienced software developer with over 10 years of experience working at companies that range in size from less than 10 employees to Fortune 100 companies. Expertise in the domains of database development, querying and programming. Problem solver with the ability to understand business issues and translate them into working IT solutions. Nearly all of my contributions to the projects below were done accurately and in a timely fashion.

TECHNICAL SKILLS

• Oracle PL/SQL
• DB2 SQL PL
• T - SQL
• Bash shell scripting
• Microsoft SSIS
• Microsoft SSRS
• Django
• Setting up and configuring databases
• Schedulers including Autosys and Tidal
• Reporting
• Unit Testing
• Hive
• SQL
• Informatica PowerCenter 9.6
• C#
• Informatica MDM 9.7
• SQL Server 2012
• Python
• Batch architecture
• Data modeling
• Financial data
• Data Modeling
• System Testing
• NoSQL

PROFESSIONAL EXPERIENCE

Confidential, Clifton, NJ

Senior Programmer

Responsibilities:

• The purpose of the project is to create a new web based payment application for the Department of Design and Construction (DDC) as well as migrate data and create integration jobs to import data daily
• Created a data migration mapping document that was a deliverable for the client
• Resolved many data related bugs to assist the application development team
• Created databases and installed schemas and code to be used as test environments
• Creating stored procedures to migrate master data such as vendors, users, etc
• Writing report SQL to be used in the application

Confidential

T-SQL and SSIS Developer

Responsibilities:

• The purpose of the project was to redesign the EDRI program to move away from IBM Websphere Message Broker to a scheduler based system
• Observed and resolved numerous bugs and improved processes in the SSIS, stored procedure and C# code created by the initial development team
• Created enhancements including one to assign “weights” to various system messages so that they could be handled in a timely and efficient manner by the EDRI program

Confidential

DevOps Engineer

Responsibilities:

• This project was about providing IT support to the Confidential, which is a watchdog agency on the Department of Corrections. Initially much was unknown about the Board’s IT infrastructure and the first task was to learn more about the environment
• Responsible for all day to day IT operations of the Confidential (BOC), including but not limited to installation of new hardware and server upgrades, writing SQL and T-SQL code, Active Directory management of users, data driven improvements and fixes to a custom application, data modeling, managing database backups, custom querying and report generation for the team, managing version control, providing recommendations for the future state
• Developed architecture consisting of Powershell scripts, T-SQL programs and SQL Agent to process, load and archive source extracts
• Created the first database development schema and configured security for its use
• Data modelled a normalized schema and created views to represent the data in this format

Confidential

SSIS Developer

Responsibilities:

• The project was focused on performing a data migration of the Confidential ’s DECD data into a Microsoft Dynamics CRM application.
• This data was concerned with requesting and receiving financial assistance by applicants (small businesses and large businesses) from the Confidential
• Manipulated 13 source files to accurately model the target data structures in CRM
• Managed and created 50+ data cleansing operations using SSIS, SQL scripts, T-SQL stored procedures, C# scripts and the use of regular expression functionality
• Aided with the conversion from data map based data imports to Kingsway based imports, which saved time and provided ease of use as far as resolving errors in the load process
• Managed version control of the database, SSIS solution file and various database code using Team Foundation Server

Confidential

T-SQL and SSIS Developer

Responsibilities:

• The purpose of the project was to redesign some of the functionality of the EDRI system which acquires epidemiology data from various sources within NY State and NYC and performs processing on the data prior to sending it downstream to a case management system
• Wrote T-SQL procedures to strip data from source XMLs and load them into work tables and to perform complex manipulations at the message level (message level being an atomic unit of data for the EDRI system)
• Created SSIS packages to call T-SQL procedures and scheduled these SSIS packages using SQL Agent
• Aided in overall performance testing of the EDRI application and pinpointed underperforming pieces of SQL code, for which solutions were offered
• Performed management of development and testing environment, including refreshes and backups
• Ad-hoc querying to support the team

Confidential, Falls Church, VA

Technical Consultant

Responsibilities:

• Full stack debugging and updates of complex SSRS reports for corporate daycare provider, resulting in numerous fixes to existing client issues and an overall improvement of the quality of the delivered reports
• Testing and quality assurance of SSRS reports, which resulted in the discovery and fix of many bugs
• Delved into web app and MVC issues, creating a schematic of the overall application to bring knowledge to other team members

Confidential

SSIS Developer

Responsibilities:

• Coded and tested large SSIS packages for data transformation in context of financial institution compliance with U. S. regulations for foreign bank transactional reporting
• Data modeled for Oracle and SQL Server databases using Oracle PL/SQL and Microsoft T/SQL
• Created complex SQL queries and functions and Oracle packages
• Created parts of the overall code architecture which were employed by other developers, including a 1500+ line piece of C# code to test the overall quality of incoming data feeds and the piece of code that ultimately moved over all the data generated by all the developers into the production environment

Confidential, Florham Park, NJ

Analyst Programmer

Responsibilities:

• Created ~8 Party Master related MDM mappings to load and master data
• Wrote unit test and system test scripts to test these mappings and mappings created by other developers
• Execution of these scripts resulted in the discovery and elimination of numerous bugs
• Performed testing using Informatica Data Director, found many bugs which were subsequently fixed
• Actively worked across teams, assisting the ETL and system test teams in their duties, resolving their questions and giving them insight into the programs that the development team wrote

Confidential

PL/SQL Developer

Responsibilities:

• Wrote sql and pl/sql code using custom ETL tools to load Iowa’s DHS data into a custom built benefits management system created by Accenture
• Solved numerous difficult data related bugs by using a top down approach of tracing the bugs from the gui front end all the way down to the database

Confidential

Informatica Developer

• Created Informatica mappings to load Confidential advertising assets into a SAS application
• Project was approximately 2 months behind schedule until the Accenture development team stepped in and was ultimately completed successfully and on time
• Resolved complex issues about implementation of the Informatica code independently as knowledge did not exist on the team about how to work with XML sources and targets
• Helped a junior developer with implementation details and resolving bugs

Confidential

Senior Developer

Responsibilities:

• Worked on a team that was responsible for redesigning the payments and transfers website of Chase Bank
• Worked closely with JPMC data modelers to understand the data models and explained relationships in the data model to other members of the team
• Created migration mappings and code using the DB2 import/export utility to move high volumes of transactional data from Oracle to DB2
• Numerous methods had been tried previously but this one was deemed to be the best way
• Managed an offshore resource working in Mumbai and oversaw his work
• Moved over to the batch processing team and worked on fixing existing defects in how JPMC processes payments
• The code was released successfully and on time which could not be said about the original release
• Created innovative test suite to provide ability to test code in dev prior to being released in other environments
• The development of this test suite resulted in the saving of numerous hours of testing by the system test teams

Confidential

Repository Developer/Junior DBA

Responsibilities:

• Participated in brainstorming with the client experts (business and IT) to define the migration rules for both the SQL Repository and Reporting needs
• Participated in the writing of the detailed design documents for the SQL repository project
• Created jobs for backing up and copying SQL Server databases between two physical servers
• Created scheduler jobs with email notification on SQL Server 2000 and SQL Server 2008
• Set up basic security on SQL Server databases and basic security at the server level as well
• Project was delivered on time and to a client that was very satisfied with the results

Confidential

Informatica Developer

Responsibilities:

• Designed several ETL jobs using Informatica Powercenter to compare, join, transform and persist information coming in from different systems into fact tables
• Worked collaboratively to solve complex implementation problems with the Informatica code
• Scheduled ftp and load jobs using Tidal
• Created Korn shell scripts to encapsulate the Informatica workflows
• Unit and system tested the data and in production support