PROFESSIONAL SUMMARY:

IT Professional, SDLC methodologies of Agile, Scrum, Iterative, Waterfall, etc., New system implementations, conversions, and updates; Corporate data warehouse DBA; Create/Modify SQL, Views, Tables, Indexes, and Stored Procedures; Business Objects v5.1.3 through Business Objects Enterprise XI and SAP BO v12; SQL Server 2000, 2005, 2008 - r2, 2010, and 2012; SQL Enterprise Manager; SQL Query Analyzer.

PROFESSIONAL EXPERIENCE:

Confidential - Monroe, MI

ERP Consultant

Responsibilities:

• Maintain and enhance financial, production, sales, forecasting, and plant operations (Avalon frontend and backend) reporting systems
• Work closely with Accounting, Purchasing, Planning, and Sales departments to provide solutions.
• Create extracts from production Avalon ERP system for new Oracle ERP BI Story Grooming, Data Mapping, Discovery, ERP (Enterprise Resource Planning).
• Develop SQL scripts to create extracts from Avalon to Oracle ERP.

Confidential - Irving, TX

SQL Developer

Responsibilities:

• Story Grooming, Data Mapping, Discovery, ERP (Enterprise Resource Planning).
• Perform complex analysis, research and develop database solutions based on thorough and comprehensive research, data validation, data cleansing, data modeling and technical expertise.
• Managed redesign of 3rd party project management system to SQL Server database.
• Data analysis, mapping, and documentation during TFS and Daptiv project management systems into a SQL reporting data warehouse utilizing SSIS.
• Facilitate discussions with various teams to maintain focus on goals and objectives of projects.
• Present findings to management and makes recommendations to make modifications in the area of personnel, equipment and procedures to improve customer service.
• Data modelling and analysis using SQL, MS Access and MS Excel.
• Create plan for implementing new system technology for existing system.
• Create SSIS packages to upload data to SQL server.
• Implement new 3rd party application JIRA Project Management.

Confidential - Frisco, TX

SQL Developer

Responsibilities:

• Data analysis, data mapping, and development of complex SQL coding to populate data warehouse.
• Documentation of data analysis for warehouse conversion during upgrade from Baan FP5 to LN8.
• Perform complex analysis, research and develop solutions based on thorough and comprehensive research, data validation, data cleansing, data modeling and technical expertise.
• Develop user documentation as well as scripts for functional usability testing and system training.
• Create, modify, and maintain complex SQL queries, stored procedures, and views.
• Perform data mapping between Baan and Data warehouse by creating complex SQL code using joins and conditions.

Confidential - Lewisville, TX

SQL Consultant

Responsibilities:

• Business Analyst functions of gathering information requirements by interviewing management.
• Experience developing and enhancing SQL queries based on defined requirements.
• Create SSRS reports to drive KPI metrics.
• Design, develop, test, deploy, document, and train all phases of assigned projects.

Confidential - Fort Worth, TX

SQL Developer

Responsibilities:

• Define/document/create conversion from WDS source system to new SQL server 2012 platform.
• Create complex MS Excel extracts from data warehouse for financial analysis.
• Create SQL Queries, Views, and Stored Procedures.
• Define and create Tables, Indexes, and Stored Procedures.
• Create SSIS packages to upload data to SQL server.
• Create SSRS reports to provide financial reporting and KPI metrics.
• Document data transfer flow and reporting specifications.
• Document system and user account maintenance to ensure compliance.
• Enhance accounting financials under direction of Lead Financial Officer used for ERP (Enterprise Resource Planning).
• Monitor SQL server performance.
• Perform complex analyses, research and develop solutions based on thorough and comprehensive research, data validation, data cleansing, data modeling and technical expertise for financial reporting.
• Work closely with leadership to develop and maintain processes and procedures perform special research for internal and external customers.

Confidential - Irving, TX

Database Developer

Responsibilities:

• Create & enhance Business Objects reports for the corporate metric dashboard from executive summary levels through granular detailed analysis.
• Create & enhance Business Objects semantic layer universes for the corporate metric dashboard reports.
• Develop Oracle SQL code to analyze data in preparation for report development.

Confidential - Fort Worth, TX

SQL Developer

Responsibilities:

• Production Support of Commercial Off The Shelf (COTS) applications: Time Labor System and CostPoint.
• Write complex SQL code for data analysis and updates.
• Create SQL Views, Tables, Indexes, and Stored Procedures.
• Create SSIS packages to upload data to SQL server.
• Create SSRS reports to provide KPI metrics.
• Create SQL for data reporting (user - role audit), extraction (based on products, areas, and time), and data validation to document system version upgrades using SQL Server Mgt. Studio 2008-r2.
• Document data transfer flow and reporting specifications.
• Developed T-SQL queries to update data.
• Document system and user account maintenance to ensure compliance.
• Monitor application performance.
• Utilize Team Foundation Server (version control, documentation repository, and testing scripts).
• Utilize BI tools for reporting, analytics, and KPI indicators.

Confidential, Dallas, TX

Crystal Reports Consultant

Responsibilities:

• Develop Call Center reporting analytics (KPI) based on Business Unit Managers requirements to include additional fields, conditions, formulas, and formats.
• Create and modified Crystal Reports providing metrics to management.
• Enhance and developed Crystal Reports based on Business Unit Managers Call Center metrics.
• Schedule Crystal reports based upon daily, weekly, and monthly criteria.
• Develop using SQL Server 2008 Enterprise Manager and Query Analyzer; enhanced and developed Call Center.

Confidential - Irving, TX

Data Warehouse Specialist (SQL D.B.A.) / Data Analyst III

Responsibilities:

• Collect, document, and translate user requirements into project plans.
• SQL Server & SQL Database development & support.
• Business Objects Developer, Designer, Administrator, & Supervisor.
• SQL Server & SQL Database support skills (SQL2005 and 2008R2).
• Create, schedule, deploy, monitor, and troubleshoot SSIS/DTS packages through review of log files.
• Create SSIS packages to upload data to SQL server.
• Create training documents and provide training on advanced Business Objects reporting.
• Provide day - to-day support of reporting environment, including administration and maintenance of user groups, users, folders, events, schedules, security, and compliance.

Confidential - Detroit, MI

Systems Development Specialist

Responsibilities:

• Analyze, define, configure, and document population of Lawson system including GL, AP, PO, AR.
• Systems Development Specialist during conversion, configuration, and implementation of Lawson.
• Create and maintain Business Objects universe joining appropriate Lawson silo s together.
• Create reporting solutions for corporate use by Accounts Payable, Purchasing, Inventory, and Logistics.
• Identify and coordinate linking of Lawson requisition and purchase order tables in Business Objects universe to develop comprehensive reporting.
• Manage, design, test, implement, and train inventory depot strategy in use on Lawson implementation.
• Provide production support for depots; including par location implementation, monitoring, and maintenance.
• Systems Development Specialist during conversion, configuration, and implementation of Lawson.
• Create and maintain Business Objects universe joining appropriate Lawson silo s together.
• Create Business Objects reports published for corporate use by Accounts Payable, Purchasing, Inventory, and Logistics.
• Design, test, implement, and train departments on Lawson inventory depot strategy.
• Develop check print layout, interface mapping from Lawson through Payformance check system.
• Develop, test, and train users on Symbol handheld terminal system to count and replenish hospital units.

Confidential - Detroit, MI

Project Manager - Financial Systems / Oracle DBA

Responsibilities:

• Populate and validate Oracle Corporate Executive Financial Information database system from G/L and PPS source system feeds.
• Production support for monthly, quarterly, and annual Executive Information System Financials reporting and analytics.
• Audit and monitor system to ensure data integrity.
• Business and System Analyst of source system interfaces during the conversion to SAP.
• Coordinate source data loads from general ledger and product profitability system.
• Develop business Requirements Documentation during conversion to SAP after sold to Confidential .
• Document database read routines, sorting routines, variables, dimensions, formulas on a multi - dimensional Oracle platform.

Confidential - Lansing, MI

System Analyst/Programmer - DBA

Responsibilities:

• Create FoxPro PC database system to transition processing and reporting from mainframe.
• Produce Medicare and Medicaid hospital claim metric analysis.
• Create FoxPro database system to replicate all processes on mainframe.
• Analyze PL/1 programs residing on an IBM 3090 computer system used to validate and store hospital inpatient data.
• Consolidate and aggregate hospital data on IBM mainframe for reporting and analysis.
• Create patient outcome measure analytical reports.
• Design a database on the fixed record layout, programmed data parsing routines to populate the database, and programmed queries to report validation statistics.
• Design and programmed a database for Market Penetration reporting.
• Develop a financial information database for analyzing aggregated Medicare metrics.
• Document program functionality, data transfer, and storage media requirements
• Perform system backups and data transfers from an IBM AS400.
• Present a business proposal that eliminated time shared computing costs.
• Produce Medicare and Medicaid hospital claim metric analysis.
• Receive a recognition award for outstanding performance and financial savings.
• Successful implementation of business proposal through procurement of additional equipment and development of pc - based systems.
• Provide solutions to ensure all execution steps within process are in compliance with Client-sanctioned audit procedures, Federal and corporate information security regulations.
• Develop database marketing delivery channels, execution tools and infrastructure for monthly communications with marketing, risk, decision management partners and outside vendors during program execution.