SUMMARY:

• Set up validation methods for ETL, create full database in SQL. From design to creating complex queries, data manipulation, stored procedures, etc
• Set up views for reconciliation of revenue, accounting processes, HR payroll processes.
• Processing data queries, run routine reports within client’s set timeframe. Complex querying, and downloading from multiple servers and .csv files.
• Support Beta Engineers and Customer Service Team with set up of forms, views with list boxes, dashboards, and email capability.
• Loading 6 million records within client’s timeframe - validate, extract, transform and load. Troubleshoot. Analyze and test data, thorough research, and fact finding.
• Cleansing and validating. Figured out a way to transfer data overnight, which significantly speeded up the process to half the time.
• Work experience comes from several industries - IT, healthcare, legal, finance, oil and gas, human resources and payroll, accounting, administration, inventory, document management.

TECHNICAL SKILLS:

• Data Analysis
• SSIS (ETL packages complex queries data mapping stored procedures triggers
• ETL)
• SSAS (cubes dimensions)
• SSRS (reporting and dashboards)
• SAP BI
• SAP BODS
• MS BI
• MS Access
• VBA
• Excel
• SharePoint
• JavaScript
• HTML
• Document Management.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

MS Access/SQL Developer (Consultant)

Responsibilities:

• Work with HPE Beta Engineers and Customer Service team. Work closely with subject matter experts to enhance current SQL database. Create new tables, queries, views, user reports with BI dashboards. Design technical requirement for custom applications, integrations, and processes for downloading data from website, validate data for further upload into SQL. Automate email processing with word and .pdf attachments. Create custom MS Access application with specific views.

Confidential, Houston, TX

Snr. Technical Analyst

Responsibilities:

• Support IT Technical Document Management team in decommissioning around 6 million legacy records data from ARIS (SQL 2008 R2) into TRIM (Tower Records Information Management Systems) data warehouse. ETL work was to - cleanse and validate data, troubleshoot issues, develop and enhance new features, upload to website. Generate SAP BODs queries and reports. Analyze data via SAP queries. Download SAP data to excel. Enhance current features for Shell healthcare document requirements. Was key person for unit testing on SAP upgrades for new user interface, queries, downloads from data warehouse. Create application to notify client where archived boxes were checked out above 1000 days old timeframe. Support the team on troubleshooting applications. Finally work with team to set up SharePoint websites for records management.

Confidential, Houston, TX

Excel Developer

Responsibilities:

• Work with Account Controllers team to reconcile Revenue from various countries (Australia, France, Sweden, etc.). Create Excel forms with drop down list boxes for users from different countries to input data and return to head office. Create code for Controllers team to reconcile revenue in multiple currencies, group by inter company code, create pivot tables for group account reports. Create indirect and vlookup functions for currency conversion tables.

Confidential, Bentonville, Arkansas

Excel Developer

Responsibilities:

• Work with team to set up budget report for fiscal year 2015.

Confidential, Sugarland, TX

Excel Developer

Responsibilities:

• Develop Add-in macro. Current files linked with old add-in path of Uniformance and LIMs. The add-in macro is to reset and validate new path. This macro was used multiple users excel files customized to run in the same manner. Unit testing, support and general troubleshooting on migration from Excel 2003 to 2010.

Confidential, Houston, TX

Application Developer

Responsibilities:

• Data analysis - Work closely with client to re-design current reports, make new reports, correct issues in calculations, lab test end results, and make downtime reports available on server in .pdf format. Calculate lab test results and make it easy for end user to get “Certificate of Analysis” report on the click of a button.

Confidential, Pearland, TX

Application Developer

Responsibilities:

• Develop inventory application for migration of data from Excel to MS Access 2010. Create a Preventive Maintenance application which will generate work-order tickets for plant engineer’s inspection duty. The application creates a new ticket number, captures details of work order, work in progress, and any particular findings on work needed for heavy equipment. Report to generate graph tracking breakdown of heavy equipment.

Confidential, Houston, TX

Application Support Staff

Responsibilities:

• Short term contract with the Harris County Hospital District Center for Mental Health & Mental Research Association. Support current database. Take care of all outstanding tickets and issues with current database developed on MS Access with SQL Server backend. Work closely with client to modify forms and reports for case workers. Support EMCOT Application used by remote (blue cop) emergency medical coordinators and technician staff.

Confidential, Irving, TX

Application Developer

Responsibilities:

• Build a Well Development Plan. Download data from TIBCO and Arc SD servers. Create an ETL user interface on MS Access with SQL as backend. Allow users to upload data and compare with TIBCO and Arc SD data, modify data update their changes to SQL Server. Search data with date. The application has graphical interface with 13 tab sheets and sub-forms imitating excel spreadsheets.