SUMMARY:

• Decreased teh size of our Key Performance Indicator table by over 63%, which caused a boost in report performance across teh system.
• Re - designed code to be written outside of a cursor, which increased our web based chart reporting over 100 times faster. From 5 minutes to 10 seconds for most indicators across multiple programs.
• Helped reduce a procedure that was running for over 30 minutes to less TEMPthan 8 minutes by using indexes and creating table variables to hold data in memory instead of writing to disk for optimal speed.
• Working with a variety of database system data, including: Zangle, PowerSchools, Swiss, FacsPro, our proprietary systems, and Qualifacts/Carelogic for health care systems.
• Create new key performance indicators for Custom Decision Support System for organizations based on individual business requirements upon client request.
• Modify/Create stored procedures implementing teh use of cursors, temp table calculations, indexes, common table expressions, Dynamic SQL, and triggers to automatically track changes in key performance indicators on a daily basis in reporting engine.
• Perform teh full life cycle of development. This includes: analyzing business requirements, designing database/ business intelligence solutions, development, sandbox testing, deployment, and maintaining solutions through production support.
• Perform Use case testing and validation on various indicators and procedures based on business rules. Implemented database restores, user login credentials, and procedures on a testing environment to validate against production and prepare for new business intelligence production releases.
• Import a variety of spreadsheets and flat files including csv, excel, pipe, txt, and tab delimited into SQL Server 2008 R2 for synchronization, formula creation, and in corporation into stored procedures and business intelligence web reporting engine.
• Wrote a C# application to pull historical data from third party system Web Service API and integrate this data with our system going forward on a daily basis.
• Created a Windows Batch file to integrate teh historical third party data into our system automatically. Changed teh design and code of 5 procedures from similar programs to be managed in one simultaneously. Separated out bloated database tables for procedures to run against on a new dedicated database.
• Improved teh efficiency of importing new client data automation by using inner joins and filtering in teh inner join instead of creating a temp table through subqueries.
• Traced back, fixed and recovered missing data from source files by tracking errors through temp tables in procedures, back to source from organizations.
• Wrote a set of standard data definitions to be presented to clients. These data definitions were used as a standard set of business requirements to visually report and graph key performance indicators and provide teh proper data for custom indicators by request.
• Re-wrote development processes to improve teh speed and accuracy of system wide product releases. Utilized Pentaho Report Designer to design reports for business intelligence web reporting engine. Customized reports using grouping, roll-ups, common table expressions and a variety of joins and look-ups using local database data and through remote report designer on client system.
• Reviewed potential ETL Mapping tools for efficient mapping of dirty data and dispersed data across multiple tables and flat files.
• Worked with Clover and Altova ETL to produce mapped data from a variety of sources including CSV, excel, and text files.
• Utilized Caspio for backing up customer data and running nightly tasks.
• Kept track of errors and debugging through ticketing system via Google docs.
• Act as a liaison between lead developer and other members of business intelligence team. Reporting to C.E.O. of company.
• Assisted in Conference calls and meetings with customers and other core members of their data teams to discuss business requirements and data retrieval complications and solutions.
• Interviewed potential new developers for web and business intelligence development.
• Reviewed new technologies to be integrated into our system on a team of developers who had teh final say on new product integration.
• Separated data of two organizations based on logical keys and relationships among keys and tables. Directly corresponded with vendors for issues and bugs.
• Designed look-up tables for data matching and record insertion based on primary keys.

TECHNICAL SKILLS:

Software Technologies: Proficient in WordPress, Microsoft Word, Excel, Access, Outlook, Visual C# 2010

Programming Language/Tools: Express, Visual Studio, Eclipse, NetBeans, C9.io, Oracle SQL Developer, Spring Framework, Maven, GIT, Tortoise SVN, Raspberry PI Programming: Java, Javascript, Jquery, Jquery-UI, Angular Js, NodeJS, Express, MongoDB, Bootstrap, HTML, JSON, AJAX, XML, CSS, Hapi JS, PHP, C#, Visual Basic, ASP.net, My SQL, Microsoft SQL( 2005 and 2008), PL/SQL, T-SQL, Oracle SQL (10g and 11g), Data Warehousing, shell scripting and batch file scripting. Various operating system experience including multiple Linux Distributions, Mac, Windows 95- Windows 8, and Linux/DOS terminal commands. Experience with Ebay and Paypal. Windows Software/Hardware repair and installations. Ability to Type 60 words per minute.

WORK EXPERIENCE:

Software Developer

Confidential - Royal Oak, MI

Responsibilities:

• Contributing to teh design of a universal platform for data portability and teh security behind teh platform.
• Integrated IBM Watson for OCR document conversion and automatically generating keyword tags based on teh relevancy of teh text being uploaded into teh system.
• Building custom Apex, Visual Force, and Lightning components code for Salesforce integrations. Persisting data across both Heroku, Amazon S3, Postgres and MongoDB databases.
• Connected data to our system from IOT devices and phone apps such as Fitbit, Fat secret, Adidas app, and
• Higi.
• Web development through Angular JS, Node Js, LESS, CSS, and HTML
• Using node js to build micro services to integrate data between disparate systems.
• Designing loosely coupled and event based workflows that communicate through message queues such as
• RabbitMQ.
• Acting as an admin on teh Salesforce Platform.
• Researching new product integrations and participating in final decisions on cost vs benefit. Then implementing those products into our platform.
• Created cron jobs through Amazon Lambda for initiating our daily batch data pulls and executing our continuous integration tests done under CircleCI.
• Created methods for validating data as it passed through our APIs. Unit testing using Hapi Lab framework.
• Sped up message queue data ingestion into Postgres by 24 times from 8 hours to 20 minutes. This was done by converting our files to shorter JSON data formats. This also halped to reduce teh data file sizes being stored on Amazon S3.
• Reduced teh number of API requests needed to call Salesforce by writing Apex code to "callout" to our webapp instead of our webapp doing a request to Salesforce.
• Presented our product to potential customers at Dreamforce and analysts at Forrester. Skills used:

Developer II

Confidential, - Southfield, MI

Responsibilities:

• Combined data from multiple databases and schemas' to produce key performance indicators for direct marketing, data modeling and research.
• Designed and developed product timeline website. Met with customers to gather business requirements. Helped with design decisions for product delivery.
• Used Talend to automate process for products that will be delivered cyclically as a service. Wrote shell scripts to clean up and automate data formatting and work flow processes.
• Utilized Oracle hints to improve query optimization across tables of generally 1 billion records and greater.
• Reduced a procedure from running for over 8 hours and consuming over 370 GBs of memory; down to a 15 minute run and 3 GBs of Memory.
• Set teh framework for a company wide product timeline website that will scale to suit any type or amount of product time lines with sub second response times.
• Developed a method for quickly pivoting a table against a large set of tables containing well over 9 billion records, without teh need to store multiple tables of 20 million+ records.
• Devised a plan to automate a daily process that was previously thought to be solely capable of a manual run. This was done through folder name and file extension monitoring across an external data processing source.
• Developed test sites using Nodejs, Express, HapiJS and MongoDB.
• Used Event Emitters and middleware for data manipulation and workflow within NodeJS and Express.
• Utilized NPM and Yeoman as a build tool for quickly scaffolding NodeJS websites within C9.io IDE.