TECHNICAL SKILLS:

Tools: T - SQL, Business Intelligence, Business Analyst, Requirements Gathering, Team leadership, Business Interviews, Data Modeling, Report Design, ETL, Report Prototyping, Load Forecasting. Limited programing experience in R, C++, C#, Java, and HTML

Visualization: Microstrategy, Cognos, SQL Server Reporting Services (SSRS), R, PowerBI

Integration: SSIS, DataStage, SAP Business objects Data Services

Database: Microsoft SQL Server, MySql, Oracle 10g, DB2, Netezza

Other: Microsoft Office, Linux, Windows, ERWin, Visual Studio, OpenLink Endur (commodity trading)

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Sr. DataBase Developer/ Sr. Forecasting Analyst

• Work cross functionally with 6 separate IT and business teams to update mission critical energy trading data.
• Manage the development of an Operational Data Store consolidating data from of 4 distinct billing systems
• Monitor and Maintain daily running of all ETL and Stored Procedures
• Develop and maintain all new ETL jobs to pull data from each billing system
• Manage system performance and security profiles for all users. Test and solution all fixes and updates.
• Build BI reporting for Sales, Commercial, Pricing, and Forecasting teams
• Develop SSRS, Excel, and Power BI reporting solutions to fit a customer's need.
• Manage 3rd party energy forecasting imports into Endur trading system
• Analyze and maintain multi step process for energy load forecasting into our internal trading system.
• Verify accuracy of forecasted system loads before releasing data to business
• Built automated jobs to streamline the reporting and analysis of Short Term and Long Term load forecasting.

Confidential, Houston TX

Data Architect

• Managing all aspects of the company database and reporting environments from design and development to maintenance. This includes multiple sql server 2008 and 20012 installations. SSRS and PHP for reporting. SSIS for Data Warehouse environment as well as all of our data integration with 3rd party vendors.
• Support the development of in house web based software by writing T-Sql queries, stored procedures, and database backups for Sql Server 2008 and 2012.
• Respond to all ad-hoc data requests from Company Owners.
• Optimize T-SQL all queries for the fastest possible execution in a web based environment.
• Lead all analysis, trending, and development of useful reporting to discover areas of opportunities for business to enhance operation, customer service, and gaps in service.
• Automated monitoring of all ETL and Report jobs using SQL Server 2012, SSRS, and SSIS. Fixing all jobs prone to failure within three months of employment. Job failures are almost non-existent.
• Worked with each department to review reports and correct data issues or calculation deviations. Rebuilt business users trust in report generated data.
• Develop complex trend analysis and predictive modeling to assist with strategic planning using PHP, SSRS and SQL Server 2008.
• Manage accounts with multiple data vendors including RxKey, Cardinal Health, BPL, and Amgen.

Confidential, Columbus, OH

Senior Business Intelligence Business Analyst

• Responsible for taking a statement of work and developing a project plan to in corporate all necessary business stakeholders, analysts, developers, and testers.
• Tasked with traveling to a business site to lead requirements gathering and development of multiple successful projects.
• Collaborated closely with cross functional teams spanning the HR, Finance, Manufacturing, Marketing, and Procurement lines of business.
• Wrote complex SQL queries using Sql Server, Oracle, and Netezza to move data, produce test data, analyze outliers, find data quality issues, and assisted in quality assurance testing.
• Worked as the Lead Business Analyst for the reporting and data warehouse portion of a large scale Oracle ERP intuitive. Successfully designed, acquired business approval, and led the team of 7 developers to deliver over 60 custom reports built in Microstrategy.
• Developed requirements and successfully led an implementation team through multiple phases for a new point of sale system the client was incorporating. Phases included HR, Accounts Payable, Site Location Management, Location Inventory Management, and Vendor Management.
• Tasked with managing multiple smaller side projects, while working on a much larger scoped project.

Confidential

Lead Business Intelligence Business Analyst

• Tasked with taking a general idea for a restaurant labor Reporting Dashboard and turning it into a reality.
• Performed in depth process and data analysis to understand system environments, key metric requirements, business strengths and weaknesses, and operational hierarchies.
• Led the Requirements Gathering, Design, Architecture and User Acceptance Testing pieces for a labor dashboard suite using Microstrategy that is now used in all 500+ of their stores.
• Implemented a report request program that is used to document and streamline reporting requests and allow the Business Intelligence (BI) team to prioritize and track requests.

Confidential

Business Intelligence Business Analyst/ETL Developer

• Lead requirements gathering sessions with stakeholders to develop a sales scorecard report.
• Use IBM’s Netezza ( PureData) and T-SQL to analyze data and developed complex queries to pull necessary source data.
• Prototype reports using Microstrategy.
• Use the Data Modeling software ErWin to design and add new tables to existing Data Warehouse environment.
• Use IBM DataStage to create ETL jobs to populate new data tables.

ETL Developer

Confidential

• Asked to assist with data analysis and ETL development for a project that was on the verge of failure.
• Tasked with learning DataStage to assist in troubleshooting coding issues
• Within one week of being assigned to the project, I was put in charge of the ETL sequencing, change control, and performance optimization for DataStage. Within 3 weeks, the project was turned around and ultimately delivered to the client on schedule.
• Tasked with performing an extensive gap analysis between two merged company segments