TECHNICAL SKILLS:

Application Software:

• Microsoft Access
• Microsoft Excel
• Microsoft Power Point
• Microsoft Project
• Microsoft Visio
• Microsoft Word

• ADP
• HotSOS
• Infogenesis
• Kronos
• LMS
• Micros
• Ticket Master

Microsoft:

• SSAS
• OLAP
• Tabular
• SSIS
• SSMS
• SSRS
• Power BI
• Office 365
• MDS

• Administration
• Dashboards
• Framework Manager
• Metric Studio
• Report Studio

• Universe
• Web Intelligence
• Crystal Reports
• Business View Manager

• Microsoft SQL Server 2005 - 201 4
• Oracle9i

• Senior BI Developer
• BI Lead Engineer
• Business Analyst
• ETL Developer
• Implementation
• QA Analyst
• Project Management
• Systems Analyst and Support

• JCL
• SQL
• TSQL

• AS400
• IBM 3270
• MVS/TSO
• Focus

• Windows 2000
• Windows XP
• Windows NT
• Unix

• Oracle 9iAS
• Citrix Nfuse
• MS E-commerce Server

PROFESSIONAL EXPERIENCE:

Sr. BI Developer

Confidential

Responsibilities:

• Leading the definition, analysis, planning, development, testing, implementation, maintenance and documentation of innovative and cost-effective business intelligence solutions for company utilization.
• Responsible for building, implementing and supporting Microsoft BI Solutions utilizing the Microsoft BI Stack 2016 (SSIS, SSRS, and SSAS).
• Design data warehouses and data marts utilizing the Kimball Methodology to generate a logical and physical model for Star and Snowflake Schema.
• Design and develop Power BI Solutions published to Office 365 via live links to SSAS Cubes through Power BI Gateway.
• Support SAP Business Object environment.

Sr. BI Developer

Confidential

Responsibilities:

• Responsible for building, implementing and supporting Microsoft BI Solutions utilizing the Microsoft BI Stack (SSIS, SSRS, and SSAS).
• Develop BI solutions of GPS data in SQL Server utilizing the Kimball Methodology to generate logical and physical model.
• Collaborating with end users to identify needs and opportunities for improved data management and delivery.
• Design and develop dashboards for various departments within the company based on requirements from CIO.

Sr. BI Developer

Confidential

Responsibilities:

• Dimensional Modeling of Oracle data in SQL Server utilizing the Kimball Methodology to generate a logical and physical model.
• Create SSIS Solution and test extraction, transformation, and load (ETL) processes that capture metadata and rules associated with ETL Staging and Data mart build with auditing for reporting.
• Maintaining multiple database environments for development, user acceptance testing, and production.
• Develop operational schedules, operational manuals and provide monitoring of the Business Intelligence Solutions.

BI Lead Engineer

Confidential

Responsibilities:

• Work closely with BI Director in leading the definition, analysis, planning, development, testing, implementation, maintenance and documentation of innovative and cost-effective business intelligence solutions for multiple applications and systems, utilizing information technology, business and industry trends.
• Create and test extraction, transformation, and load (ETL) processes that capture metadata and rules associated with ETL processes.
• Develop operational schedules, operational manuals and provide monitoring of the ETL jobs Leads or participates in writing test plans to validate implementations against the requirements.
• Work on large complex projects, which cross over multiple functions and meets with appropriate technical staff, end users, and senior management.
• Design and develop BI Framework, Dashboards, Metric’s and Reports on the Cognos Platform and SSIS, SSAS utilizing Microsoft Solutions.

ETL Specialist

Confidential

Responsibilities:

• Created ETL Packages and implement new data extracts, transformations, and load routines to populate the Data Warehouse utilizing the Kimball Methodology to populate dimension and fact tables.
• Documented SQL Server components, which consisted of, Databases, Analysis Services, Integration Services and Reporting Services, while maintaining metadata catalog for dimensional and fact tables.
• Developed business requirements documentation, based on initial business request that included use cases, user interface specifications, and user functional requirements as defined by the business rules.
• Designed logical structure of database to include tables and views based on user specifications, in order to support development of ETL Packages. In addition to, utilizing hands on TSQL to create complex queries and stored procedures and functions.

Consultant

Confidential

Responsibilities:

• Technical Consultant for Touchworks Modules; responsible for assisting customers in resolving system stability and performance issues, while utilizing issue tracking tools and effective communications for issue management and resolution.
• Implemented the Allscripts TouchWorks build and configuration for the setup of User and User/Providers, while documenting system workflow to develop best practices for set-up of users and providers accounts. In addition to design of note module for setup of structured and unstructured text templates.
• Implements and supports assigned applications for the product line in addition to working closely with other IT department groups as well as their vendor counterpart to assist with some of the technical aspects of product implementation/rollout and support.
• Designed Microsoft Access custom SQL queries via linked tables in SQL Server to update and develop text templates and create custom reports for management.

Consultant Analyst

Confidential

Responsibilities:

• Conducted JAD session (with subject matter experts) to gather user requirements, and identify their business procedures, collaborating with the Project Managers and business users to gather, analyze, and document the functional requirements for the various projects.
• Performed data mining activities utilizing SQL in order to locate and stage data appropriate to fulfill test script data requirements, and identify modifications to test scripts in order to create data required to meet test script conditions. Validate test script correctness and functionality against the Peoplesoft CIS System.
• Tested functionality of PeopleSoft Customer Information System (CIS), which provided the ability to manage all processes in the customer lifecycle, which included initiating service to meter management to credit and collections.
• Developed relational model normalization of tables and setup enforced referential integrity with cascading constraints on foreign keys, while providing support of the Microsoft Access Databases.

Consultant

Confidential

Responsibilities:

• System Administrator for SQL Server 2000 with responsibility for backups and security management as well as coordinating with technology services department regarding server maintenance.
• Upsized the Microsoft Access to SQL Server 2000 backend and continued to develop Microsoft Access form driven applications with queries, reports, macros, and modules.
• Developed link between CRM and Accounting System to automate the transfer of data from SQL to DBF tables that omitted the manual reprocessing of invoices for accounting department.

Information Analyst

Confidential

Responsibilities:

• Analyzed existing systems, programs, policies, and organizational processes to make recommendations to technical staff for design and development of new integrated system user requirements.
• Performed liaison role between user areas and IT to assist in the identification of process improvements, system design, testing and implementation of technical projects, often requiring coordination of multiple functional areas; identify, evaluate and implement operational changes to improve information and processing systems, as well as gap analysis.
• Managed the upgrade and implementation, of the Electronic Pull System from a UNIX to NT Client/Server Environment, which included interfacing material related issues and systems aspects between EDS personnel and General Motor customer and various contractors. Also trained and supported users in new radio technology protocol.