SUMMARY:

Data Engineer / ETL Developer with nine years of experience applying my skills to design, test, develop, integrate, map, convert, cleanse data within RDBMS, ERP systems and data warehouses. Writes scripts in PL/SQL, SQL, Confidential, SAS and instills confidence with customers by proactively addressing issues through understanding business need and values the ability for quality data to help clients make better decisions.

COMPUTER SKILLS:

Write SQL and PL/SQL using TOAD, SQL Developer, SQL Loader, RapidSQL, Oracle 11g, Oracle 12c, SQL Server 2008, 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, BO Universe Designer 4.1, Confidential with external DLL, INI, COM files, Excel 03 - 13 with excel and com add-ins, MS Access 03 -13, XML, Python, Windows Command Line

PROFESSIONAL EXPERIENCE:

Informatica Developer / Oracle SQL Development Engineer

Confidential, Washington, DC

Responsibilities:

• 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 KC.
• Document KC data models in ERWIN and evaluate target tables for fact / dimensional structure.
• Troubleshoot data anomalies in KC 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 mapping to various environments.
• 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 by working with database admins.
• Work overnight for software releases to ensure the appropriate installation and verification of software to production.

Senior Software Application Developer

Confidential, Arlington, VA

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 NIST 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

Confidential, Washington, DC

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

Confidential, Washington, DC

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

Confidential, McLean, VA

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

Responsibilities:

• Analyzed, debugged, coded and tested an application that manages the Confidential post - procurement process.
• Brought an incomplete 200+ user 2007/2010 MS Access Database programmed with Confidential to the testing phase.
• Application assisted the Confidential in complying with federal requirements for awarding 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.

Database Analyst

Confidential, Washington, DC

Responsibilities:

• Aided data migration by enhancing an MS Access Database used to collect inventory assigned to 696 employees.
• Wrote SQL statements to validate inventory recorded in enterprise system with records in Access database.
• Used enterprise system as data source for some inventory when there were inconsistencies between SAP and MS Access.

IT Customer Solutions Advisor

Confidential, Washington, DC

Responsibilities:

• Interacted frequently with Under Secretary and staff to understand business processes and suggest ways to streamline.
• Built a SharePoint site that communicated event information to registrants of the Chief of Mission Conference.
• Modified a workflow with SharePoint Designer to confirm event registration by sending custom emails to attendees.

Senior Associate

Confidential, McLean, VA

Responsibilities:

• Developed a human resource database application with MS Access to ease record keeping and reporting.
• Performed data analysis using SQL to verify what assets belonged in a $300 MM fund.
• Project involved the reconciliation of inventory in materials management and finance SAP modules.
• Discovered the two modules had same amount of assets but were reporting the wrong assets.

Developer

Confidential, Washington, DC

Responsibilities:

• Maintained reports and application tools developed in SharePoint, Microsoft Access and Excel.
• Developed and maintained SharePoint site that tracks all activities overseen by the gift funds director.
• Developed a donor database in MS Access to validate 10 fiscal years of appropriations imported into SharePoint site.
• Linked database tables on primary and foreign keys to create donor database at CFO Office at Confidential .
• Addressed control gaps by designing and testing workflows for the CFO Office using Nintex and COTS features.
• Wrote Confidential scripts to perform front - end ETL process from Momentum Financials into SharePoint.
• Saved 10 man-hours a month by using Confidential to automate the creation of reports from SharePoint.
• Championed change by writing user guides and administrations guides for tools I created at Confidential .
• First consulting team to implement a solution that met requirements

Office Manager

Confidential, Groveland, FL

Responsibilities:

• Managed payroll, invoicing, contractual agreements, general ledger and scheduling for a physical therapy practice.

Economics Instructor

Confidential, Orlando, FL

Responsibilities:

• Taught Principles of Economics and Money and Banking to undergraduate students.

Operations Data Analyst

Confidential, Orlando, FL

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.