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 complex in-object SQL.• 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.• Developed new, and refined existing build and coding standards for field mapping and metadata capture.• Participated in all phases of the SDLC in projects utilizing Waterfall and modified Agile methods.• Produced multiple business operations reports and ad-hoc analyses utilizing SAP SQVI and Oracle Sql.• Developed calculation and data flow models as for proof-of-concept for new large commercial / industrial contract products and processes.• Acted as subject matter expert on design and implementation of new SAP ISU functionality.• Designed, programmed, and implemented various multi-user workflow tracking and reporting applications and complex billing calculation models in MS Access.

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 complex in-object SQL.• 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.• Developed new, and refined existing build and coding standards for field mapping and metadata capture.• Participated in all phases of the SDLC in projects utilizing Waterfall and modified Agile methods.• Produced multiple business operations reports and ad-hoc analyses utilizing SAP SQVI and Oracle Sql.• Developed calculation and data flow models as for proof-of-concept for new large commercial / industrial contract products and processes.• Acted as subject matter expert on design and implementation of new SAP ISU functionality.• Designed, programmed, and implemented various multi-user workflow tracking and reporting applications and complex billing calculation models in MS Access.

• 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. At the height of the program, these calculation engines accounted for over $300M annually.• 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.• Received the highest possible rating on the annual performance review.

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 company, sheet metal products fabricator, national non-profit agency, multinational food and beverage maker.Contract analytical and development engagements:• 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.• Interfaced with various data sources including MS SQL, ORACLE, Filemaker Pro, Solomon, QuickBooks, Peachtree, MS Excel, and EDI files.• Designed tools to automate data transfer from inventory and billing systems into financial accounting packages.• Prepared functional and technical specifications for program development and user training documentation.Interim Controller for $12MM manufacturing entity:• Managed accounting staff employees. • Provided alternatives, recommendations and assistance to President and CEO and was charged with the development, integration, and conversion of business information accounting systems.• Developed and designed multiple queries and reports to extract financial reporting data from existing production and job tracking databases. • Prepared financial and statistical reports.• Recommended changes in financial policies and procedures, as was necessary.• Monitored established internal controls to assure proper compliance for the parent corporation and eight partnerships.

• 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. • Consulted with numerous clients on selection of modular accounting packages.