SUMMARY:

• Data Engineer seeking full time permanent placement as an ETL Developer where I can continue to improve the flow and quality of data between systems.
• Have 10 years of experience using Informatica, PL/SQL, SQL, SAS or Visual Basic to tune, extract, transform, cleanse and load data within RDBMS, ERP systems and data warehouses for various clients.

COMPUTER SKILLS

• Write SQL and PL/SQL using TOAD
• SQL Developer
• SQL Loader
• RapidSQL
• Oracle 11g
• Oracle 12c
• SQL Server
• SQL Server Management Studio 2016
• Sybase ASE and DB2. ETL
• Informatica 10.1 Powercenter Client Tools
• Informatica Administration Console
• SAS BASE on PC and EG 9.4
• SAP ECC 6.0 and BW using MM
• SD
• FICO modules
• Visual Basic
• MS Access and MS Excel 03 - 16
• XML
• Python
• Windows Command Line
• Visual Studio 2017

PROFESSIONAL EXPERIENCE:

Informatica Developer / Oracle SQL Development Engineer

Washington, DC - Confidential

Responsibilities:

• Ingest data through PL/SQL scripts and Informatica mappings from various applications into data warehouse where timely business intelligence reports can be viewed by customers across the enterprise.
• Develop mappings and perform Extraction, Transformation and Load of source data into data warehouse by using various PowerCenter transformations such as lookups, unions, aggregations, filter, router and source qualifier to meet the requirements for data warehouse.
• Document data warehouse data models in ERWIN and evaluate target tables for fact / dimensional structure.
• Troubleshoot data anomalies in data warehouse by finding source of data elements in an environment where mappings, sessions, stored procedure transformations, SQL overrides and changes in source or access to objects present a challenge for finding data lineage.
• Use DDL to create or modify database objects and issue grants to roles and schema owners; give direction to database admins on how to resolve access to objects.
• Write documents to install, back out, validate and verify the migration of Informatica objects to various environments.
• Repair application defects caused from source data, business logic or code on multiple platforms including PeopleSoft and systems developed in house with SQR, PeopleSoft code, Informatica mappings or PLS/SQL.
• Improve run time of jobs by tuning the performance of Informatica and database objects and SQL statements.
• Write and use PL/SQL blocks, procedures and functions to transform and load data into data warehouse.
• Monitor performance of scheduled nightly workflows and remedy issues using the Informatica Administration Console to administer and configure Informatica by viewing logs, reviewing access and status settings for services.

Senior Software Application Developer

Arlington, VA, Confidential

Responsibilities:

• Revived features of enterprise application without access to source code by writing Oracle 11g Standard Query Language (SQL) scripts to test requirements written in documentation.
• Enhanced and maintained Confidential applications that applied Confidential Security Controls within the Risk Management Framework.
• Maintained database dictionaries, validated controls and reverse engineered data models.
• Tested and resolved SQL Server and Oracle database issues by understanding the design of applications and architecture of systems.
• Wrote ctrl files for loading of active directory into Oracle using SQL Loader.
• Worked with team members to verify time zone setting, allocation of namespace and tablespace memory in database.
• Developed statistical reports to evaluate the effectiveness of the Tips of the Day program.
• Developed new features and modified desktop applications by writing and debugging Confidential and XML code.
• Provided Ad - hoc reports and analysis evaluating the performance of the Tips of the Day (TOD) program.
• Wrote standard operating procedures (SOP) and work instructions to document existing and new services.

Market Data Developer

Washington, DC - Confidential

Responsibilities:

• Found code error causing many Excel out of memory messages responsible for the crash and freezing of applications.
• Supported the trading desk for multi - family, single-family and adjustable-rate and jumbo loan portfolios.
• Wrote Confidential code for new MS Excel and MS Access applications to meet changes in business process or architecture.
• Transformed data through automated processes to ensure data quality and usability of products.
• Automated daily posting of inventory by writing batch files to transfer files to UNIX server.
• Wrote and ran Confidential test scripts with time stamp logs to assess performance degradation and repro crashes of Excel 2013.
• Identified control issues from changes in upstream systems and found resolutions by conducting requirements analysis.
• Wrote Confidential code to store and report trades made and offered in the derivatives and secondary mortgage markets.
• Wrote Confidential code to automate XML requests to report the maintenance margin required to hold positions with clearing houses.
• Worked with Microsoft, Bloomberg and Reuters to reproduce production issues by creating harness versions of code.
• Edited T-SQL and resolved defects encountered during various testing by understanding application design.

Manager of Business Analysis

Washington, DC, Confidential

Responsibilities:

• Persuaded client to use Oracle and Statistical Analysis System (SAS) to replace MS Access databases used to reconcile and cleanse terabytes of transactions within SAP.
• Used SAP BW and BEx to extract and analyze transactions within the MM, SD, FI modules of SAP ECC 6.0.
• Identified and resolved gaps in SOPs while validating the funds balance with treasury reconciliation.
• Wrote SQL and SAS scripts to automate the tracing of sales, purchases and inventory from transaction register to financials.
• Data and statistical analysis supported several system change requests to prevent invalid or incomplete values into SAP.
• Reconciled differences between DLA general ledger to DOD financial statements for high priority accounts.
• Wrote SAS and SQL scripts to automate the transformation and validation of transactions.

Developer

McLean, VA - Confidential

Responsibilities:

• Wrote SQL to discover collection agencies waiting for borrower information to collect unpaid loans of $2 billion.
• New system allowed client to comply with increased standards for transparency and recovery of loan balance.
• Programmed workflows with Confidential to track the referral and collection of 175,000 delinquent loans.
• Mapped data from DB2, Sybase, Oracle and Midas to create reports for servicers by writing SQL statements.
• Code, debugged and tested systems to reduce vendor errors from 20,000+ a month to fewer than 20 a month.
• Worked with vendors to edit excel spreadsheets integrated with Confidential system of record.

Database Developer Confidential

Washington, DC, Confidential

Responsibilities:

• Analyzed, debugged, coded and tested an application that manages the NAVY post - procurement process.
• Brought an incomplete 200+ user 2007/2010 MS Access Database programmed with Confidential to the testing phase.
• Application assisted the Navy in complying with federal requirements for ing contracts.
• Used Shell Controls, Scripting runtime, DAO, ADO, Microsoft Office, and Outlook APIs.
• Application handled document management activities such as archiving files residing outside of database.
• Programmed a workflow to manage the approval of contracts by auto generating emails to notify users of next steps.
• Controlled user access by setting record level permissions by user group and performed unit / integration testing.

Operations Data Analyst II

Orlando, FL - Confidential

Responsibilities:

• Member of an analytics team that addressed resource allocation issues for inventory management.
• Automated the extraction and transformation of financial data into inventory data using SAP BW and MS Access.
• Perform sensitivity and variance analysis for difference between budget and actual.
• Worked on cross - functional team to develop dashboard by sourcing information system data and creating metrics.
• Conducted benefit analysis to negotiate vendor contracts and maintained the liability model to value resorts in Excel.
• Saved 20 man-hours every month by using Confidential, crystal and monarch to automate reports that were created manually.
• Modeled in Excel a new way to budget and track performance of StarPoints and supported it with a business case.
• Evaluated how new business initiatives would impact the demand for inventory through cost-benefit analysis.
• Prepared quarterly business reviews and revised a quarterly executive report that was underestimating worsening condition of business.