John Darr Email & Phone Number

Boston, MA, US

Boston, MA, US

Irving, TX, US

Irving, TX, US

• Developed multiple ETL jobs using SAP Data Services encompassing ABAP, Flat Files, RFC data sources, Oracle and MS SQL Server target tables, mapping and history preserving data flows, variables, pass-through SQL and.
• Created reusable data flows and workflows for job logging and performance measurement capture.
• Created complex SQL queries including Oracle Analytical functions.
• Fine tuned jobs, scripts, and queries to optimize performance.
• Converted jobs from BODS 3.2 to BODS 4.1.
• Developed and refined Unix Bash Shell scripts.

Irving, TX, US

• Developed multiple ETL jobs using SAP Data Services encompassing ABAP, Flat Files, RFC data sources, Oracle and MS SQL Server target tables, mapping and history preserving data flows, variables, pass-through SQL and.
• Created reusable data flows and workflows for job logging and performance measurement capture.
• Created complex SQL queries including Oracle Analytical functions.
• Fine tuned jobs, scripts, and queries to optimize performance.
• Converted jobs from BODS 3.2 to BODS 4.1.
• Developed and refined Unix Bash Shell scripts.

• Created data mining and calculation databases, which allowed for the billing of specialized contracts and for the expansion of the program from $6M to over $30M in annual revenue- without adding additional headcount..
• Created SQL Server 2005 calculation database to consolidate reporting and replace individual MS Access calculation databases.
• Created data validation procedures and MS Access calculation database for billing previously unbillable “Swing” charges that created additional $10M in annual revenue.
• Trained peers in advanced data gathering and VBA programming techniques.
• Streamlined and automated the generation of daily, monthly, and annual reports for the billing group.
• Designed, programmed, and implemented various multi-user workflow tracking and reporting applications in MS Access.

• Industries: Electric utility, cast stone manufacturer, large public utility, national insurance company, educational creator and publisher, cellular telephone service retailer, public investment firm, document storage.
• Consulted with management at all levels.
• Applied the knowledge of data processing systems to multiple business application environments ranging from small start-up to a global corporation.
• Developed and revised computer programs in languages such as Visual Basic and VBA.
• Designed, programmed, and implemented multi-user applications in MS Access.
• Developed financial, manpower performance, and other data analysis reports for a variety of industries utilizing MS Access, MS Excel, MS Power Point, FRx, and COGNOS Impromptu.

• Led and participated in system requirement and design sessions with customers.
• Analyzed client procedures and prepared detailed design specifications and functional specification documents.
• Developed and implemented procedures for testing clients’ internal data flow and control procedures.
• Developed procedures for testing new software and validating data against legacy results.
• Prepared Visio diagrams and developed coding logic flowcharts.
• Consulted with multiple clients on Peachtree and QuickBooks Accounting Software upgrades and designed and recommended 3rd party enhancements.