SUMMARY:

• Veteran B.I. architect with expertise in coding, application design, defined data Architecture, Data Governance, Enterprise Data Warehouse, Metadata management, Report Development, Information Strategy, Master Data Management and successful
• Project leadership. I am Self - Motivated with the technical expertise and business acumen necessary to translate business requirements and objectives into scalable, highly resilient and successful system solutions. Leader of teams delivering Business Intelligence, Predictive Analytics and Data Science. I’ve driven multi-million dollars of improvements in cost reduction and earnings and highly focused on delivering the best customer experience and enhancing the brand of IT.

PROFESSIONAL EXPERIENCE:

B.I. Solution Architect

Confidential, Atlanta, GA

Skills used: Requirements Gathering, System Documentation, Performance Tuning, PLSQL, Stored Procs, SQL performance tuning, CI/CD

Responsibilities:

• Responsible for Architecting Business Intelligence solutions utilizing Oracle Exadata, ODI, Times Ten, OBIEE, Teradata, Golden Gate, Tibco, Hadoop
• Responsible for support and enhancements of Oracle and Teradata Data warehouse environment and BI Architecture
• Gathered and analyzed business requirements and translating needs into long-term and short-term (if applicable) Business Intelligence solutions.
• Collaborate with business users and SMEs to ensure the creation of production BI designs and implementations satisfied the analytics and reporting needs.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments, (Oracle Exdata, ODI, Times Ten, OBIEE, Teradata, Golden Gate, Tibco )
• Troubleshot BI Environment problems and tune for performance. Diagnosed and resolved application bottlenecks and performance issues.
• Defined and enforce coding standards, design styles and best practices.
• Provided Business and technical oversight of Newly Implemented Message based Order Management Implementation using Tibco technologies
• Responsible for architecting database CI/CD solution Using Jenkins, Antifactory, Udeploy
• Architected solutions to capture and report on real time tibco messaging data using azure data datalake, dw and ssas with Power BI dashboarding for the presentation layer

B.I. Architect

Confidential, Durham, NC

Skills used: Requirements Gathering, System Documentation, User documentation, Performance Tuning,, SSIS,T-SQL, SSAS, MDS, DQS, Stored Procs, Partitions, SQL performance tuning, PowerPivot, Power BI, SQL Team Foundation Server, FTP, SQL Server 2014, Enterprise Gateway, AS Connector, MDX, DAX

Responsibilities:

• Responsible for Architecting Confidential Business Intelligence solutions utilizing MS SQL Server 2014, SSIS, SSAS, SSRS, Power BI, MS Azure
• Supported creation of Azure Data warehouse environment and BI Architecture
• Gathered and analyzed business requirements and translating needs into long-term and short-term (if applicable) Business Intelligence solutions.
• Collaborate with business users and SMEs to ensure the creation of production BI designs and implementations satisfied the analytics and reporting needs.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments, (Power BI,SSRS, SSIS, SSAS )
• Troubleshot BI Environment problems and tune for performance. Diagnosed and resolved application bottlenecks and performance issues.
• Defined and enforce coding standards, design styles and best practices.
• Developed QA monitoring models using DAX/Power BI for Identifying Data Quality Issues.

B.I. Architect

Confidential, Atlanta, Ga

Skills used: Requirements Gathering, System Documentation, User documentation, Performance Tuning,, SSIS,T-SQL, SSAS, MDS, DQS, Stored Procs, Partitions, SQL performance tuning, PowerPivot, Power BI, SQL Team Foundation Server, FTP, SQL Server 2014, Enterprise Gateway, AS Connector, MDX, DAX

Responsibilities:

• Responsible for Architecting Confidential Business Intelligence solutions utilizing MS SQL Server 2014, SSIS, SSAS, Power BI, MDS, DQS, CRM Dynamics, MS Azure
• Supported creation of Azure Data warehouse environment and BI Architecture
• Gathered and analyzed business requirements and translating needs into long-term and short-term (if applicable) Business Intelligence solutions.
• Conducted business requirements workshops attended by business users from multiple states/cities/countries
• Collaborate with business users and SMEs to ensure the creation of production BI designs and implementations satisfied the analytics and reporting needs.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments, (Power BI, MDS, DQS, SSIS, SSAS )
• Troubleshot BI Environment problems and tune for performance. Diagnosed and resolved application bottlenecks and performance issues.
• Defined and enforce coding standards, design styles and best practices.
• Provided Business and technical oversight of MS Power BI Implementation/sales support as well as Internal BI Reporting efforts
• Designed logical Data Warehouse Model via ERwin and Provided technical architecture oversight of physical implementation required to ensure data access requirements were meet
• Assisted in the evaluation and selection process of all front-end analysis tools, including the selection of components of the selected software required for the front end bi solution
• Developed liner regression Revenue forecasting models using SSAS (Both MDX and DAX) for Predicting if year-end revenue goals would be reached

B.I. Architect (T.I.G Consultant)

Confidential, Atlanta, Ga

Skills used: Requirements Gathering, System Documentation, User documentation, Performance Tuning,, SSIS,T-SQL, SSAS, MDS, DQS, Stored Procs, Partitions, SQL performance tuning, PowerPivot, DTS, SharePoint, SQL Team Foundation Server, FTP, Oracle Exadata, Oracle Olap Option, SQL Server 2012

Responsibilities:

• Responsible for Architecting Confidential Business Intelligence solutions utilizing MS SQL Server 2012 SSIS, SSAS, SSRS, PowerView, PerformancePoint, integration with Excel and SharePoint.
• Supported creation of Business Intelligence Center of Excellence and data governance model.
• Analyzes user requirements and, based on findings, designed functional documentation for both the back-end data warehouse as well as for BI front-end applications.
• Gathered and analyzed business requirements and translating needs into long-term and short-term (if applicable) Business Intelligence solutions.
• Conducted business requirements workshops attended by business users from multiple states/cities/countries
• Collaborate with business users and SMEs to ensure the creation of production BI designs and implementations satisfied the analytics and reporting needs.
• Responsible for Administration and Configuration and optimization of BI components of our BI environments, (SharePoint Excel services, Power Pivot SSAS server, MDS, SSIS, SSAS )
• Defined Business Intelligence framework model, semantic layers and BI Metadata repositories to support reporting and administration.
• Troubleshot BI Environment problems and tune for performance. Diagnosed and resolved application bottlenecks and performance issues.
• Worked with Data Modeler to define and enforce coding standards, design styles and best practices.
• Responsible for technical design and architecture of MDS and SSAS solution
• Provided Business and technical oversight of ETL Developers
• Designed logical Data Warehouse Model via ERwin and Provided technical architecture oversight of physical implementation required to ensure data access requirements were meet
• Assisted in the evaluation and selection process of all front-end analysis tools, including the selection of components of the selected software required for the front end bi solution

Sr. B.I. Developer

Confidential, Atlanta, Ga

Skills used: Requirements Gathering, System Documentation, User documentation, Performance Tuning, XML Data Types, SSIS,T-SQL, Stored Procs, Partitions, SQL performance tuning, SSRS, DTS, SharePoint, SQL Team Foundation Server, FTP

Responsibilities:

• Responsible for creating custom SQL solutions for customers which included (DTS, SSIS, SSRS)
• Modified Existing SSRS packages and the underlying Stored Procs per customers request
• Worked for an Tech Writer, Team Lead, and SME(Business Customer) to complete each task
• Used SharePoint for project updates and user request
• Used SQL Team Foundation Server for SSRS version control
• Interacted with customers directly to gather additional requirements
• Created and developed application specs by communicating with various users at various levels of management.
• Supported the design and development of SQL server data models
• Provided source to target mapping to support the data transformation in BI Data Mart.
• Worked with end users and project business owners on developing detailed business requirements and ad hoc and control reports
• Ensured that the architecture conformed to data consistency and performance standards
• Assist in the execution of feasibility studies for efficiency and technical viability of solutions to business problems

Sr. B.I. Developer/Manager IT

Confidential, Atlanta, Ga

Skills used: Requirements Gathering, System Documentation, User documentation, Performance Tuning, SSIS,T-SQL, Stored Procs, Partitions, SQL performance tuning, SSRS, Cognos, Aspose, Surround SCMExcel VBA

Responsibilities:

• Created and developed application specs by communicating with various users at various levels of management.
• Supported the design and development of SQL server data models
• Provided source to target mapping to support the data transformation in BI Data Mart.
• Assisted with data validation and application testing as well as and user acceptance.
• Worked with end users and project business owners on developing detailed business requirements and ad hoc and control reports
• Developed, maintained, and designed technical specifications, as well as high-level database design and requirements along with end user documentation for assigned projects and analysis
• Ensured that the architecture conformed to data consistency and performance standards
• Assist in the execution of feasibility studies for efficiency and technical viability of solutions to business problems

B.I. Developer/Lead Business Analyst

Confidential, Atlanta, Ga

Skills used: Requirements Gathering, System Documentation, User documentation, Performance Tuning, SSIS,T-SQL, Stored Procs, Partitions, SQL performance tuning, ETL, SSAS, SSRS, Hyperion, ProClarity, MDX, Java ScriptAccess VBA

Responsibilities:

• Created and developed application specs by communicating with various users at various levels of management.
• Completed several Business Intelligence project life-cycles (Host Tool, Inventory Visibility, Car Safety Stock Analysis, Leadership SKU's, Etc)
• Responsible for design and development of SQL server data models as well as OLAP Cube development
• Provided source to target mapping to support the data transformation in BI Data Mart.
• Assisted with data validation and application testing as well as and user acceptance.
• Worked with and end users and project business owners on developing detailed business requirements as well as ad hoc and control reports
• Developed, maintained, and designed technical specifications, as well as high-level database design and requirements along with end user documentation for assigned projects and analysis
• Ensured that the architecture conformed to data consistency and performance standards
• Created UML Models for Relational and Dimensional designs
• Assist in the execution of feasibility studies for efficiency and technical viability of solutions to business problems
• Completed Data Quality concepts such as Master Data Management to insures Data Mart was inline with BI Data Mart
• Responsible for applications through full development life cycle

VBA Programmer / Sr. Business Analyst

Confidential, Atlanta, Ga

Skills used: Excel VBA, Requirements Gathering, System Documentation, User documentation, Application Presentation, Performance Tuning, API Calls, Java Script

Responsibilities:

• Created and developed application specs by communicating with various users at various levels of management.
• Developed Excel application that gathered information from several other excel spreadsheets, Performed various calculations such as wcm(Weight Customer Minutes) and ttr(Time To Repair), etc and displayed this information on a excel based dashboard.
• Created MYSQL tables and architecture to support the move from excel to mysql. Help come up with a long term goal of a web-based dashboard with an web front-end that would pull information directly out of the database and move away from spreadsheets
• Responsible for application through full development life cycle

VBA Programmer / Sr. Business Analyst

Confidential, Atlanta, Ga

Skills used: Excel VBA, Requirements Gathering, System Documentation, User documentation, Application Presentation, Performance Tuning, API Calls

Responsibilities:

• Created and developed application specs by communicating with various users at various levels of management.
• Developed Excel application that accepted user entered Property investment specs such as Interest rates, Initial investments, Acquisition, and Disposition Dates as well as the order and method in which call flows would be distributed to Investors.
• Programmed Various Calculations/Formulas such as preferred returns, Compounded and uncompounded interest calculates, and IRR summary returns.
• Responsible for application through full development life cycle

VBA Programmer/ Business Analyst

Confidential, Atlanta, Ga

Skills used: Excel VBA, Access VBA, Requirements Gathering, System Documentation, User documentation, Application Presentation, Performance Tuning, API Calls, Database Architecture, Data Architecture

Responsibilities:

• Created and developed application specs by communicating with various users at various levels of management.
• Developed Excel application that sorted and Analyzed Insurance rating specs
• Developed Access Application that Replaced current Excel rating application that sorted and calculated customer rating information more efficiently then previous system

Database Programmer/ Business Analyst

Confidential, Atlanta, Ga

Skills used: SQL coding,VB6, Access VBA, Excel VBA, Requirements Gathering, System Documentation, User documentation, Application Presentation, Performance Tuning, API Calls, Data Architecture

Responsibilities:

• Developed system architecture to extract, store and manipulate historical import/total sales, advertising, budget, and forecast information for several product class levels. The system also coordinated forecast for weekly and monthly levels as well as aggregating product class forecast. This system contained well over a million records and consisted of 35 different data sources that included: IBM, Access, SQL server tables
• Developed sales forecasting application that gathered historical sales and advertising data from 35 different data sources. This system produced a historical sales, monthly sales forecasting and inventory.
• Presented application to VP’s and GPM’s to discuss enhancements and solidify scope of project.
• Responsible for application full development life cycle.
• Created an installation program and process to automatically install and update the application in a network environment.
• Developed financial reports in crystal reports as well in access that consisted of weekly sales trends so GPM’s could better forecast total and import sales. These reports also contained variances so differences from planned, actual, and forecasted sales could be tracked.
• Manipulated data so information contained on financial reports could contain numerous looks/views.
• Made performance enhancements to an existing VB6 Supply Chain and Visibility application. This application was designed to collect information for one department. Structural and coding changes were made so application could be run for all The Confidential departments.
• Created supply chain application distribution and application update methods
• Created supply chain application testing procedures
• Added several API calls to supply chain application to determined several system variables
• Added and worked with VB COM objects to automate sending and receiving of files
• Also created a user friendly GUI and customized reports so users could have easy access to all exception information and reports created by the application. Example: exception, cycle-time, and exception summary.
• Created an installation program that dynamically created installation files to match individual system set-up.
• Created security procedures for secure access to both applications.
• Created stored procedures in SQL Server to convert and extract sales information
• Created SQL server tables used to migrate sales information from Access tables for historical storage
• Created Unix Shell scripts and Batch files to automate system process

VBA Programmer/Business Analyst

Confidential, Atlanta, Ga

Skills used: SQL coding,VB6, Access VBA, Excel VBA, AS400,SQL/400, AS400/CL,Crystal Reports, System Documentation, User documentation, RPG, API Calls

Responsibilities:

• Developed front end in Confidential Access to enhance data entry productivity.
• This application is now being used in lue of some of the AS400 green screens.
• Responsible for generating SQL/400 DML scripts for all large transactions.
• Created macros in AS400 to perform medium size data transactions.
• Worked with Senior Analyst and RPG programmer to make enhancements to current AS400 production billing system.
• Developed and maintained Access databases. Put together documentation for current system processes.
• I was responsible for all Oracle database transactions. Responsible for updating rate plans, creating reports and data validation in an AS/400 database.
• Served as the primary interface between user representatives, IT department and development teams for finding and implementing emerging technologies that may speed or improve their analytical process.
• Created various mini application tools in VB6 to automate the moving and storing of data from mutable different data sources such as SQL Server, Sybase, Oracle, AS400, Btrive, and MS Access.
• Created testing stages and ensured that VB6 applications worked in conjunction work AS400 CL and RPG programming.
• Ensured Integrity of data AS400 data
• Created oracles application to allow the conversion of system naming conventions to customer friendly conventions.

Data Programmer/Analyst

Confidential, Decatur, GA

Skills used: SQL coding,VB6, Access VBA, Excel VBA, AS400,Crystal Reports, System Documentation, User documentation, Oracle DBA, Report Writing, Project management, Data Modeling, Data Mapping, ASP, HTML

Responsibilities:

• Project lead for migration from several Departments (BMT, Referral, BMT Lab) legacy systems (FoxPro 7.0, Oracle 8) into one centralized SQL Server Database.
• Responsible for Initial SQL server DBA responsibilities such as creating users and assigning user rights
• Gathered necessary information to document and resolve problems requiring research. Was responsible for maintaining knowledge of departmental procedures and transplant protocols.
• Created wireless application prototypes utilizing VB6 and palm OS programming to capture and retrieve patient information at point of care.
• Designed, developed, and deployed application support as well as customized reports using Access, Visual Basic, Fox Pro, Crystal Reports, Microstrategy, SQL Plus, SPSS, and Palm Pilot SDK (Software Development Kit) programs.
• Created reports that contained medical statistical analysis using programs such as SPSS, Crystal Reports and Confidential Excel.
• Developed databases from various applications: Ms Access via ODBC connections, SQL Server 2000 and other relational databases which included table structures, data mapping and database maintenance and queries.
• Developed databases, queries and tables using Ms Access and imported/exported results to/from Excel (spreadsheets, templates, pivot tables and formulas) Word (documents, macros and graphics), and Access files form various data sources for report analysis and distributed to customers via e-mail.
• Provided help desk and technical support for all end users who created their own reports using various programming tools, applications and other software packages.
• Maintained Oracle PL/SQL codes and edited existing functions and programs when needed.