PROFESSIONAL EXPERIENCE:

Confidential

Senior Developer

Responsibilities:

• Prioritize and Plan I.T. processes to implement solutions across multiple platforms.
• Designing, building and supporting data warehouse solutions on teh SQL Server, Oracle, and Teradata platforms.
• BI Development and Dashboard design for End Users utilizing Tableua and Microstrategy
• Creation of SQL queries, stored procedures, and T - SQL scripts from scratch to drive dashboards.
• Process Automation utilizing SQL Stored Procedures, SSIS, and ETL processes.
• Analysis of data and recommending revision or enchancements to Performance Metric definitions, sytems, tools, or reports to support teh Business needs.
• Analyzing performance data for defect root causes and/or improvement opportunities.

Confidential

Senior Lead IT Developer

Responsibilities:

• SSIS, SSAS and SSRS Development and Support wifin teh Microsoft BI Stack
• Prioritize and Plan I.T. processes to implement solutions across multiple platforms.
• Designing, building and supporting data warehouse solutions on teh SQL Server, Oracle, and Teradata platforms.
• BI Development for Supply Chain End Users utilizing Tableua, OLAP Cubes, and Dashboards.
• Advanced design in SQL queries, stored procedures, and T-SQL scripts
• Ensure team comprehends and applies established processes, policies, standards and procedures
• Report Automation utilizing SQL Stored Procedures, SSIS, and ETL processes.
• Data model management and metadata design utilizing Erwin.
• Analysis of data to make apprioriate decisions for teh business.

Confidential .

Developer for Delta Airlines

Responsibilities:

• Database design in a SQL Server environment to create a data repository for Virgin/Delta Airlines
• Report Automation using various reporting tools wif a strong emphasis using SSIS packages, Stored Procedures, and VBA.
• Mining and manipulation of data from SQL Server and Oracle Databases
• Designed Relational databases wifin a MS Access environment.

Confidential

SQL BI Datawarehouse Manager

Responsibilities:

• Design, development, testing, and troubleshooting SSIS packages dat implement ETL Processes to automate various database operations.
• Design and implement complex T-SQL scripts, stored procedures, views, SQL queries, and functions to generate reports necessary to satisfy teh reporting requirements for teh business.
• Work wif both internal and external customers to gather reporting and business requirements.
• Ensure quality and accuracy of teh data mapped from staging environments to teh target environment.
• Data modeling and database design at teh conceptual, logical, and physical in a Microsoft SQL enviroment.
• Translate business requirements into technical designs to map and load data from source systems to data warehouse.
• Maintain SSRS Server environment, including end user permissions, data sources, and report subcriptions.
• Document reporting architecture, server specifications, system design, and data flows.
• Creation of OLAP Analytical Cubes through teh data wharehouse using SSAS.
• Conduct data model reviews wif project team members utilizing Erwin.
• Database Admnistration

Confidential

Senior BI Developer/Data Analyst

Responsibilities:

• KPI Dashboard Development for Departments through teh use of SQL and Oracle databases.
• Database Design and Administration in a SQL Server environment.
• Report Automation using various reporting tools wif a strong emphasis using Stored Procedures, SSIS, and PL/SQL.
• Provide a source of business noledge and problem-solving capabilities to assure sound analyses and recommendations.
• Documented teh business processes (process modeling) for current- “as-is” and future- “to-be” state wif pro / con analysis.
• Data Acquisition and Analysis for department using SQL, PL/SQL, MS Access, Excel, Tableau, and VBA.
• Enforce standards and best practices around data modeling efforts utilizing Erwin.
• Acted as a liaison between business, technology and support teams.
• Prepared and deliver data-driven conclusions and recommendations.
• Served as a subject matter expert for future state service models.
• Supported teh business through ad-hoc queries and reporting from a variety of resources.
• Mining and manipulation of data from SQL Server and Oracle Databases

Confidential

Senior Engineer

Responsibilities:

• Provided weekly & monthly analytical reports to teh executive leadership team.
• Data Acquisition and Analysis for department using SQL, MS Access, Excel, SAS, VBA, SAP, XML and QMF.
• Supported teh business through ad-hoc queries and reporting from a variety of resources.
• Created and analyze reports to support business execution.
• Compiled and prepare reports, graphs and charts of data developed.
• Implementation and deployment of reporting to end users.
• Made final project recommendations which impact teh business.
• Prepared and deliver data-driven conclusions and recommendations.
• Established metrics to evaluate success of business changes.
• Mentored other analysts in developing analytical skills.
• Mining and manipulation of data from IBM Base Tables and various data sources.
• Created and maintained complex Databases and queries.

Confidential

Senior Systems Analyst

Responsibilities:

• Designed Relational databases.
• Mining and manipulation of databases.
• Extraction of data from AS/400 mainframe using AS/400 Query.
• Implemented teh import and export specifications for migration.
• Researched teh integrity of data relationships between Linkage customer information and Bottler Outlet Master Files.
• Draw conclusions and develop action plans based upon findings.
• Independently designed queries to search a complex, integrated database for data discrepancies.
• Analyzed customer information to ensure compliance to business rules.
• Applied improvements to source system as needed to enhance data integrity.
• Provided research and ongoing analytical support for teh Market Place Solutions Group.

Confidential

Manager/System Analyst Specialist

Responsibilities:

• Database Management using (SQL, AS/400, Access, Visual Basic, Crystal Reports, MS Project, TSO, Brio, Excel, and Paradox.
• Developed in-depth consolidated billing system for various customers using Data warehousing.
• Intense technical writing and documentation for all development.
• Reconciled and customized reports for company billing accounts (both internal and external).
• Generated monthly AR/AP billing system for customers using Excel, Access, Crystal Reports, TSO, AS/400 Query, Brio, and Paradox.
• Responsible for downloading computer generated information from customers received from email, FTP sites, floppy disks, and teh Internet.

TECHNICAL SKILLS

• Advanced use of SQL PL/SQL, Access and Excel for data mining and manipulation
• Programming noledge of SQL, PL/SQL, VB, Java, HTML, C++, etc.
• Strong decision making skills
• Analytical, detailed oriented and good problem solving skills working under stress