We provide IT Staff Augmentation Services!

Business Intelligence Consultant Resume Profile

Norcross, GA

Summary

  • Professional individual with 16 years of IT experience in manufacture, insurance, mortgage/banking, sales marketing industries with both technical and business analyst experience reviewing and analyzing the effectiveness and efficiency of existing systems and developing strategies for improving or further leveraging the systems which require liaison between business client and IT departments. Demonstrate the ability to manage multiple projects with tireless energy and dedication.
  • Extensive experience in data analysis, data quality, data migration, extraction, transformation, load, data integration, data enrichment, data warehousing, data modeling, designing, coding, reporting, testing and supporting next-generation database solutions on client/server platforms.
  • Expertise in building business intelligence and corporate performance management solutions including dashboards and mobile dashboards QlikView/LogiXML/Tableau/SSRS/Nevron , score cards, ad-hoc query, interactive reporting, and analysis reports with drill through, drill down.
  • Strong experience as a Business Liaison/Business Analyst Responsible for gathering requirements, gap analysis, coordinating business requirements discussion with business and technical teams, prioritizing issues and tasks, ensuring technical team delivers applications according to business requirements within deadline and with quality. Monitor technical team performance and estimations on critical issue resolution and project delivery.
  • Strong experience with SDLC and Agile Approach to project work and delivery. Utilize Waterfall-Agile approach to getting projects completed quickly with documentation.
  • Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical data issues.
  • Exceptional analytical problem solver with great communication skills capable to support customers in and technical teams internal and offshore India .
  • Quickly learn and master new technology equally successful in both team and self-directed settings and proficient in a range of computer systems, languages, tools and testing methodologies.

Technology Summary

Business Analyst:

Write Business Case, Gather Requirements, Perform Gap Analysis, Research, Mockup Design, Write Functional and Technical Specifications, Write Test Case Plans and Scripts, Bus Matrix, Traceability, Change Control, Coordinate Peer, Business and UAT Testing

Helpdesk Management:

Perform trend analysis on issues and resolution timeframe, Delegate calls to Tier1 Tier3 support, Write Helpdesk Scripts, Meet with business to identify solutions

Systems:

SAP CRM Server, SAP OLTP R3 Server, CICS/ISPF/Mainframe, UNIX, Windows 9X/NT/2000/XP/2K3/Vista/7, VMware, Mac OS Leopard

Business Intelligence:

Databases:

LogiXML 11.3 049 Sp2, QlikView, Tableau 8.2, SSRS, Nevron Charts, Crystal Report, BRIO Query, SAP Crystal Report, Brio Query Report, SAS Reporting

MS SQL Server 7/2000/2005/2008/2012 ETL/DTS/SSIS/SSRS, RedGate, Team Foundation Server 2012, Oracle 8/9i/10i PLSQL, Toad, IBM DB2, MySQL Workbench 6.1 CE, PostgresSQL

Integration Software:

DATAFLUX dfPower Studio Server, Group1 Suite, ERWIN, Entity Modeler

Languages:

SAP CRM Mobile Workbench, SAS 9.2, SAS/STAT, SAS/Access, SAS EG 4.2, Visual Basic/VBScript/Excel VBA/VB.NET, SQL, ASP, C , C . NET, JavaScript, PHP, COBOL/JCL, QMF, PowerBuilder

Source/Test:

Software:

Test Director, SeaPine Software Surround Control, Tortoise Source Control, Team Foundation Server 2012, RedGate Bundle

MS Project, MS Visio, MS Office, Corel WordPerfect

Web Development:

WordPress, Joomla, CMS, XML, HTML 5, CSS, JavaScript, VBScript, ASP.Net, PHP, Macromedia Flash, Dreamweaver, Artisteer 3, Edit Plus, NotePad , Microsoft IIS 6/7/8/2012, Apache Web Server, TomCat

IT Experience

Confidential

Business Intelligence Consultant

Duties included:

  • Utilized Logi Analytics LogiXML tools, JavaScript, VBScript, HTML, and CSS to develop and deliver the presentation layer of the solution as outlined in the statement of work from various clients.
  • Created advanced interactive reports and charts, drill-down and drill-through reporting, real time dashboards, mobile dashboards, disclosure, and base views for advanced statistical analysis.
  • Developed Analysis and OLAP Cube Grids for use by clients to analysis their data.
  • Developed prototypes for prospects using LogiXML Studio, HTML, DHTML, JavaScript, and .NET.
  • Utilized SQL Server and MySQL to develop queries, stored procedures, and indexed tables for faster delivery of data in the presentation layer.
  • Wrote MDX queries as part of creating dashboard reporting for clients with data warehouses.
  • Utilized Microsoft IIS, Apache, and Tomcat web servers to deliver .NET and JAVA web applications.
  • Analyzed data for reporting and dashboard creation.
  • Meet with various customers to gather reporting and data requirements and turn those requirements into LogiXML and QlikView web applications.
  • Defined site navigation and created interaction models for both internal and external clients.
  • Worked independently or within a small team with a focus on helping clients formulate proper business concepts, interface design, and content presentation.

Confidential

Contractor Database Developer/Business Intelligence

Duties included:

  • Developed solutions using MS-SQL Server, Transact SQL T-SQL , SSIS, SSRS Nevron Charts , and SSAS
  • Utilized RedGate, Team Foundation Server and Seapine Test Track to test and track defects and database changes and queries. Setup Team Foundation Server and Redgate Source Control to track changes to the database, tables, stored procedure, functions, and views.
  • Developed PEEKS application to help plant operator perform their daily task by providing work order and recipe information.
  • Created SQL objects to support data warehouse/data mart infrastructure
  • Practiced agile software development in a collaborative team environment to include documentation of proposed business story, design approach and plan for testing for peer review at strategic development phases
  • Created data models and manage tasks and projects in support of software application development
  • Coordinated implementation of new software and accompanying processes with other departments
  • Tracked software test results and report status to management
  • Created and validated factory knowledge reports and underlying data quality to support the incremental spiral development model
  • Deployed factory floor interfaces to present and record machine and operator input
  • Synchronized lessons learned and software components between plant deployments
  • Identified continuous improvement opportunities through site visits that will have measurable business impact within the manufacturing process
  • Defined opportunities for application development and functional extensibility
  • Recommended new applications and platforms, support the hardware and software infrastructure of the Kaiser Recipe System
  • Proposed and implemented database enhancements to support process knowledge
  • Optimized software configuration and establish proactive automated performance metrics and validation reports to identify potential N-Tier discrepancy or malfunction and opportunities for improvement
  • Utilized skills to troubleshoot and propose creative yet simple solutions
  • Identified best practices to address operational risk, fault tolerance, security and disaster recovery solutions
  • Established, debug, demonstrated, and mistake-proof database administration, recovery and audit procedures for new and existing software applications
  • Created technical specification and test plan documentation.

Confidential

Contractor BI Report Developer

  • Developed reports, forms, and dashboard using LogiXML, HTML, CSS, JavaScript, and SQL Server 2008 database.
  • Provide support of daily SQL Server jobs and troubleshoot issues with data.
  • Analyze complex source system data. Prove calculations/algorithms.
  • Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.
  • Create technical specification and test plan documentation.

Confidential

Contractor BI Data Warehouse/Report Developer

  • Developed reports and dashboard using LogiXML and Oracle 11i database.
  • Analyze complex source system data. Prove calculations/algorithms.
  • Developed complex ETL processes in Oracle 11i TOAD and WhereScape Red as well as dimensional modeling architecture conducive to reporting.
  • Developed ETL to pull data from multiple sources into the data warehouse.
  • Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.
  • Create technical specification and test plan documentation.

Confidential

Contractor Data Warehouse Developer II

  • Contributed to the design, development, customer support and other data management team projects using Microsoft's Business Intelligence toolset SSIS, SSRS, SSAS .
  • Take business requirements for new and enhanced data marts and implement the code changes into the ETL process using SSIS.
  • Support and enhance the existing Dimensional Model ensuring integrity of the data in the model and the data marts.
  • Troubleshoot and correct issues with existing applications in the data warehouse environment.
  • Support scheduled ETL processes and ensure efficiency and accuracy of outcome.
  • Identify new technologies or technological improvements to include in the application to improve usability, stability and maintainability.
  • Assist and lead design changes and enhancements of the data warehouse and end-user reporting environment.
  • Developed SQL queries and/or procedures and functions for complex data requests.
  • Worked with Web developer on programming data solutions into the corporate intranet.
  • Lead/Mentor DW Developer I and Reporting Analysts and acting as technical lead assigning tasks to Data Management staff as required and providing input for staff reviews.
  • Support WCPrism Workmen's Compensation Project:
  • Documented SSIS Packages, tables, stored procedures, functions, and business rules.
  • Create Visio Data Models show relationship between fact tables and tables used to hold WCPrism data.
  • Automated the SSIS Packages for the medical claims file creation.
  • Added Claim Adjuster information to the outbound claims files generated in SSIS.
  • Communicated with ISO Company and cross-functional teams within Builders to understand business rules and resolve prior issue with WCPrism processes.

Confidential

Database Engineering III

  • Senior ETL SSIS/SSRS Developer/DBA/Analyst for the new Data Warehouse Project. Responsible for reverse-engineering the existing business system requirements for AFMIS Dashboard Reporting in order to create new OLAP Data Warehouse and flexible Dashboard Reporting.
  • Develop ETL SSIS packages to migrate data into staging area initial and created SSIS packages for incremental loads utilizing SQL Server 2008 Change Data Capture tools to perform loads to dimension and fact tables instead of using Slowly Changing Dimension because CDC performance is faster and clearly identifies the inserts, updates, deletes that took place on the data in transaction logs without having to use the lookup transformation with SQL Server 2008 to identify new and changed records.
  • Created data diagrams and models to map the relationships between tables utilizing SQL Server 2008 and Visio. Designed the star schema relation models for the new data warehouse.
  • Created auditing tables, stored procedures and SSIS processes to track package information, table name, insert, update, and delete record counts, capture errors critical and data for the SSIS process used to load data staging and into fact and dimension tables. Developed exception/error handlers to prevent issues with data being written to the new data warehouse within SQL SERVER SSIS.
  • Created complex queries and functions to de-normalized data flatten tables to populate granular fact and dimensional tables for SSAS data warehouse and cube creation which allows for easier reporting in using star schema. Created SSRS reports to provide drill-down, up, and through capabilities.
  • Utilizing Kimball and waterfall-agile process to complete all tasks with documentation of all data models, star schema relations, and ETL processes.
  • Participating in planning, analysis, and implementation of solutions in support of business objectives. Facilitated meetings to define business requirements, key strategic goals, and flexible reporting needs from the government functional project leads.
  • Document requirements, assist in clarifying discrepancies in requirements, and assist in obtaining appropriate approvals. Utilized SharePoint and One Note to organize meeting minutes and requirements and status of project.
  • Assisting in testing activities for maintenance, project assignments by identifying testing scope and scenarios, preparing test plans and scripts, capture metrics for all data extraction, transformation, load runs, results monitoring, feedback and sign-offs and issues tracking and resolution

Hire Now