TECHNICAL SKILLS:

ETL: Ab Initio Products, UNIX, SQL

Miscellaneous: Linux, MS Office, HTML, Visio, SQL Developer

Training: Phython

WORK EXPERIENCE:

Confidential, Rolling Meadows, Illinois

Responsibilities:

• Worked on a cloud migration and enhancement project.
• Ab Initio design and development.
• Technical research and documentation.
• Coordinated work with offshore developers.
• Provided technical support to business users and other teams.

Confidential, Arlington, Virginia

Responsibilities:

• Worked on an online HR system that will provide integrated personnel, pay and talent management capabilities in a single system to all Army Components.
• Worked on various inbound and outbound interfaces to support the Global Payroll team. These interfaces were created using Ab Initio. Generic graphs were used where possible.
• Developed multiple validation jobs to track and validate data loaded to Oracle tables through PeopleSoft.
• Helped the test team with testing and debugging their Ab Initio test processes.
• Created multiple adhoc Ab Initio graphs used for loading, and validating data.

Confidential, Deerfield, Illinois

Responsibilities:

• Worked on multiple phases of the Valeant - Finance and Accounting project. Work involved everything from minor changes, to the addition of new features, along with performance improvements.
• Was responsible for the design, development, testing, and deployment of the project phases.
• Development was done using Ab Initio, UNIX, shell scripting, and SQL.
• Created detailed technical documentation.
• Worked with onshore and offshore teams, along with vendors.
• Also worked on various ad hoc Ab Initio processes as needed.

Confidential

Responsibilities:

• Worked on the design, coding, testing, and deployment of the Cost and Price Interface part of the Stage 1 data feed.
• Worked on various modifications and enhancements to the various data feeds.
• Development was done using Ab Initio, SQL, and UNIX.
• Also worked on the technical design for Stage 2 of the project that would receive daily extracts from the DemandTec application. These extracts would contain planned promotion information that would need to be validated and transformed before loading into the existing Ad Planning system.
• Worked with and directed offshore developers.

Confidential

Responsibilities:

• Worked on a DEA Suspicious Order monitoring and reporting system.
• This was a multi-phase project from design through implementation, and production support.
• Also worked on a 3-Way Match project that included work on Vendor Cost Updates, Invoice Approvals, and Fill Rate processes.
• Development work was done using Ab Initio, EME, Perl, SQL, and UNIX.
• Helped with Ab Initio development and enhancements on various other projects.
• Project technical documentation.

Confidential

Responsibilities:

• Design, development, testing, and deployment of an IKB project related to Space and Floor planning that supplied sales metrics data to JDA applications. These sales metrics are used to analyze and plan store layouts.
• Development for this project was done using Ab Initio, Perl, SQL, UNIX, and CVS.
• Created documentation such as functional design, technical design, test cases, etc., for the various projects and processes I created or worked on.
• Participated in an Ab Initio upgrade project to upgrade all Ab Initio processes to Ver. 3.0.
• Worked closely with business users, technical teams, and offshore resources.
• Provided production support.

Confidential

Responsibilities:

• Responsible for several adhoc data extracts requested frequently by different areas within the Decision Support and Confidential groups.
• The data extract processes were created using Ab Initio, UNIX, and SQL.
• Focused on efficiency and resource utilization due to the volume of data regularly requested and other production processes running while extracting the data.
• Was able to provide access to historical data previously not possible due to the volume of data and tools used.

Confidential, Oakbrook Terrace, Illinois

Senior Software Engineer

Responsibilities:

• Design, coded, and implemented an Ab Initio process that added over 90 new attributes to Discover’s Web Targeting process. This data is used by the E-Business area for targeted marketing of Cardmembers who are signed up online to use Account Center, the account management tool.
• Worked on this project as a developer and project manager.
• Initial research for this project entailed the data profiling of all the attributes that the E-Business team wanted fed to their Web Targeting Engine.
• Analyzed many Ab Initio graphs to determine where and how data is being sourced and processed. Also met with various business areas in the company to determine what data they have that could possibly be used.
• Created a custom data profiling process in Ab Initio that pulled sample data from the different source areas and provided reports to the business area for them to verify the data. This process also provided a distribution percent for each value that occurred for a given attribute.
• Provided technical support and guidance to the E-Business team on different ways data can be sourced or derived if needed, while utilizing the knowledge and input of the different source areas the data was pulled from.

Confidential, Oakbrook Terrace, Illinois

Responsibilities:

• Completed a case study that performed a customer profile analysis for a credit card company.
• Designed and developed an Informatica process to gather information about customer’s monthly credit card usage figures and their profile types.
• Completed a case study that produced a monthly customer and manager aggregation based on customer’s transactions and the average sales for the manager associated with each customer. Designed and developed this process using Informatica.

Confidential, Oakbrook Terrace, Illinois

Responsibilities:

• Completed a case study utilizing DataStage to implement a solution that integrated reference and transaction data from different departments within a telecommunications company into a single unified data mart.
• The data was aggregated by month and quarter to allow management to perform cross-sell analysis between the different services the company provided.

Confidential, Herndon, Virginia

Responsibilities:

• Was a member of a securities reference development team that was working on a major Get Current project.
• Assisted in the design and development of Ab Initio processes that processed data from Confidential ’s Confidential (Real Estate Mortgage Investment Conduit), FIN 46 (Financial Accounting Standards Board Interpretation Number), and other related systems to load and update data warehouse tables for the current production period.
• Worked closely with the testing team during integration testing to answer any questions or resolve any defects that might have been encountered.
• Documented all steps of the development process.
• Enhanced and maintained various Ab Initio processes and developed other miscellaneous processes in Ab Initio as requested.
• Inspected many Ab Initio graphs to verify standards were followed.

Confidential, Riverwoods, Illinois

Responsibilities:

• Data warehouse development and enhancements using Ab Initio, UNIX, Oracle, and SQL.
• Made enhancements to various Ab Initio applications in the Marketing Services reporting system to allow better tracking of the channel hierarchy of customer service calls.
• Designed and developed a Usage Influence Reporting system that gave Marketing Services the ability to track customer card usage resulting from customer service contacts. This system replaced an old process that had to manipulate data that was gathered from multiple tables spread out over different area’s data warehouses. This new system gave Marketing Services a more centralized location for relevant data that will help increase efficiency and accuracy of their reporting. It also better aligned the usage reporting with other company standard analytics.

Confidential, Chicago, Illinois

Responsibilities:

• ETL development using Ab Initio, EME, SQL, Oracle, and Teradata.
• Developed Ab Initio graphs that extracted data from Oracle tables, reformatted, and loaded it into Teradata tables.