We provide IT Staff Augmentation Services!

Business Intelligence Consultant Resume Profile

Targeting Database Developer/Data Lead/Business Intelligence Position

  • l 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.
  • l 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.
  • l 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.
  • l 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.
  • l Strong experience with SDLC and Agile Approach to project work and delivery. Utilize Waterfall-Agile approach to getting projects completed quickly with documentation.
  • l Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical data issues.
  • l Exceptional analytical problem solver with great communication skills capable to support customers in and technical teams internal and offshore India .
  • l 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.
  • Database/Business Intelligence Experience

Skills

Years of Hands-On Experience

Database Size

Last Used

ETL

16

1gb - 30 terabytes

2013

T-SQL/Triggers/Stored Procedures

16

1gb - 30 terabytes

2014

Data Modeling/Dimensional Modeling

ERWIN reverse engineering, creating relations between tables

VISIO reverse engineering, creating relations between tables

Devart Entity Developer Similar to VISIO

SQL Server Data Diagram

SSAS Dimension Modeling start schema

6

10g - 30 terabytes

2013

SQL Server 7/2000/2005/2008/2012

SSIS/SSRS

SSAS

RedGate Bundle

Backup/Mirroring/Log Shipping

Optimization and Indexing

SQL Agent

System Privileges

Team Foundation Server 2012

IIS 2012

16

9

2

2

16

9

9

9

9

6

2

1gb - 30 terabytes for all

2014

2014

2013

2014

2013

2013

2014

2014

2013

2014

2014

Oracle 8i/9i/10i/11i

PLSQL/Toad

7.5

1gb - 30 terabytes

2013

SAS Base 9.2/SAS EG 4.1

7

60gb 30 terabytes

2010

SAP CRM and R3

8

60 terabytes

2009

MySQL Workbench 6.1 CE

Optimization and Indexing

6

1

4gb

4gb

2014

2014

IBM DB2

4

60gb

2002

PostgresSQL

2

2gb

2010

SAP Crystal Reports and Crystal Reports

7

30 terabytes

2009

BRIO Reports

4

60gb

2002

Cognos

6 months

30 terabytes

2013

SSRS, Nevron

Tableau, QlikView, LogiXML

9

3

4gb 30 terabytes

4gb 10gb

2014

2014

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,

Provide Business Intelligence reporting solutions to internal and external clients.

Duties included:

  • l 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.
  • o 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.
  • o Developed Analysis and OLAP Cube Grids for use by clients to analysis their data.
  • o Developed prototypes for prospects using LogiXML Studio, HTML, DHTML, JavaScript, and .NET.
  • l Utilized SQL Server and MySQL to develop queries, stored procedures, and indexed tables for faster delivery of data in the presentation layer.
  • o Wrote MDX queries as part of creating dashboard reporting for clients with data warehouses.
  • l Utilized Microsoft IIS, Apache, and Tomcat web servers to deliver .NET and JAVA web applications.
  • l Analyzed data for reporting and dashboard creation.
  • l Meet with various customers to gather reporting and data requirements and turn those requirements into LogiXML and QlikView web applications.
  • l Defined site navigation and created interaction models for both internal and external clients.
  • l 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,

Implement server and software upgrades and continuous improvements to Manufacturing Execution Systems MES . Responsibilities include following an Agile, Software Development Lifecycle SDLC , and emulating reusable Component-Based Designs within a database. Domain includes disaster recovery and performance standards and audit procedures, new application testing, training, and creating Microsoft SQL queries, SSIS SQL Server Integration System packages, SSRS SQL Server Reporting Services reports and stored procedures. Recommending and implementing an efficient and reliable infrastructure to maximize transactional efficiency when collecting data and warehouse techniques for reporting performance. Understand and support the KRS architecture and software and support the continued evolution of the system throughout Kaisers' plants. Duties included:

  • l Developed solutions using MS-SQL Server, Transact SQL T-SQL , SSIS, SSRS Nevron Charts , and SSAS
  • l 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.
  • l Developed PEEKS application to help plant operator perform their daily task by providing work order and recipe information.
  • l Created SQL objects to support data warehouse/data mart infrastructure
  • l 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
  • l Created data models and manage tasks and projects in support of software application development
  • l Coordinated implementation of new software and accompanying processes with other departments
  • l Tracked software test results and report status to management
  • l Created and validated factory knowledge reports and underlying data quality to support the incremental spiral development model
  • l Deployed factory floor interfaces to present and record machine and operator input
  • l Synchronized lessons learned and software components between plant deployments
  • l Identified continuous improvement opportunities through site visits that will have measurable business impact within the manufacturing process
  • l Defined opportunities for application development and functional extensibility
  • l Recommended new applications and platforms, support the hardware and software infrastructure of the Kaiser Recipe System
  • l Proposed and implemented database enhancements to support process knowledge
  • l Optimized software configuration and establish proactive automated performance metrics and validation reports to identify potential N-Tier discrepancy or malfunction and opportunities for improvement
  • l Utilized skills to troubleshoot and propose creative yet simple solutions
  • l Identified best practices to address operational risk, fault tolerance, security and disaster recovery solutions
  • l Established, debug, demonstrated, and mistake-proof database administration, recovery and audit procedures for new and existing software applications
  • l Created technical specification and test plan documentation.

Confidential

Contractor BI Report Developer,

Provide development, system analysis, technical support, reporting, and peer troubleshooting assistance to help improve Mid-Atlantic's decision making, optimize performance, and achieve reporting requirements. Work with team of CIO, Operations Manager, Analysts to build highly performing database system and business intelligence reporting:

l Developed reports, forms, and dashboard using LogiXML, HTML, CSS, JavaScript, and SQL Server 2008 database.

l Provide support of daily SQL Server jobs and troubleshoot issues with data.

l Analyze complex source system data. Prove calculations/algorithms.

l Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.

l Create technical specification and test plan documentation.

Confidential

Contractor BI Data Warehouse/Report Developer,

  • Support Virginia Department of Health, Office of Information Management OIM Data Warehouse team to provide development, system analysis, technical support, reporting, and peer troubleshooting assistance to help improve VDH decision-making, optimize performance, and achieve reporting requirements. Work with team of analysts, developers, managers, and business resources to build highly performing system and business intelligence reporting:
  • l Developed reports and dashboard using LogiXML and Oracle 11i database.
  • l Analyze complex source system data. Prove calculations/algorithms.
  • l Developed complex ETL processes in Oracle 11i TOAD and WhereScape Red as well as dimensional modeling architecture conducive to reporting.
  • l Developed ETL to pull data from multiple sources into the data warehouse.
  • l Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.
  • l Create technical specification and test plan documentation.

Confidential

Contractor Data Warehouse Developer II

  • Reporting to the Director of Information Management, design, develop, and implement business driven information system solutions in a timely and efficient manner using data warehouse dimensional modeling techniques, corporate intranet technologies, SQL coding and end-user reporting tools. My responsibilities include but are not limited to the following:
  • l Contributed to the design, development, customer support and other data management team projects using Microsoft's Business Intelligence toolset SSIS, SSRS, SSAS .
  • l Take business requirements for new and enhanced data marts and implement the code changes into the ETL process using SSIS.
  • l Support and enhance the existing Dimensional Model ensuring integrity of the data in the model and the data marts.
  • l Troubleshoot and correct issues with existing applications in the data warehouse environment.
  • l Support scheduled ETL processes and ensure efficiency and accuracy of outcome.
  • l Identify new technologies or technological improvements to include in the application to improve usability, stability and maintainability.
  • l Assist and lead design changes and enhancements of the data warehouse and end-user reporting environment.
  • l Developed SQL queries and/or procedures and functions for complex data requests.
  • l Worked with Web developer on programming data solutions into the corporate intranet.
  • l 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:
  • l Documented SSIS Packages, tables, stored procedures, functions, and business rules.
  • l Create Visio Data Models show relationship between fact tables and tables used to hold WCPrism data.
  • l Automated the SSIS Packages for the medical claims file creation.
  • l Added Claim Adjuster information to the outbound claims files generated in SSIS.
  • l 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,

  • Support efforts to create a new data warehouse and new flexible reporting capabilities for the Department of Defense Army Food Management Information System AFMIS .
  • l 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.
  • l 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.
  • l 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.
  • l 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.
  • l 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.
  • l Utilizing Kimball and waterfall-agile process to complete all tasks with documentation of all data models, star schema relations, and ETL processes.
  • l 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.
  • l 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.
  • l 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

Confidential

Database Analyst 4 Associate Vice President,

  • Primarily provided database development and data reporting for Mortgage Marketing functions of House-Hold Lending marketing efforts. Manage Cross Sell data for the creation of monthly reporting, analytics, and client incentive payouts.
  • Involved in supporting SunTrust Mortgage short and long range system planning and report development. Worked with Cross Sell Analytical Team and Project Management to ensure effective and timely database support of all critical and ad-hoc marketing efforts.
  • Gathered business requirements and performed gap analysis on the processes used for reporting.
  • Utilizing Mortgage data, provided metrics on the primary relationships established between clients and SunTrust. Responsible for creating algorithms to calculate the incentive payouts for clients who meet specific criteria and have more than one booked product with SunTrust. Responsible for providing monthly booked business reports to up-level management to enable SunTrust to measure the success of the bank's marketing efforts.
  • l Utilized SQL SERVER 2000/2005/2008 DTS/ETL/SSIS/SSRS to manage and create Mortgage Marketing data warehouses, extracts, and provide ad-hoc reporting. Migrated SQL SERVER 2000 DTS packages to SQL Server 2008 SSIS packages. Created and scheduled DTS and SSIS packages to streamline reoccurring ETL and reporting. Utilized script task to format and control data written to Excel files.
  • l Utilized script task VB.NET component of SQL Server 2008 and activeX VBScript component of SQL Server 2000 to control the format and pivot of data on Excel spreadsheets.
  • l Validated calculations against SAS dataset pulled from Oracle.
  • l Utilized SAS 9.2 and SAS EG 4 to analysis Mortgage client data suitable to receive marketing information on SunTrust target products. Developed SAS code to build extracts using data from Mortgage Marketing Database SQL Server 2000/2008 and UNIX Oracle Server robust databases with statements such as RSUBMIT, ENDRSUBMIT, PROC Download/Upload, and PROC SQL.
  • l Performed database maintenance and monitoring of scheduled jobs. Re-wrote SQL code, which simplified and increased performance of DTS/SSIS/Stored Procedures used to extract and report Mortgage data. Developed and implemented Mortgage Marketing databases, tables, views, stored procedures for future bank products.
  • l Documented the Database tables, views, stored procedures, and DTS/SSIS packages processes.

Confidential

Senior Database Analyst/Direct Marketing Analyst,

  • l Provided production database development support for the company's direct marketing campaign initiatives. Primary responsibilities included creating direct marketing extracts and reporting campaigns across multiple business lines and distribution channels.
  • l Provided geographic and demographic metrics to business clients for deciles of direct mail audience and further analysis.
  • l Performed data mining, data warehousing, and data processing for clients Liberty Mutual Insurance Citrix.
  • l Developed and designed SQL SERVER 2005/2008 marketing database and wrote SAS analysis programs to acquire and warehouse customer information used to establish customer profiles, identify potential markets, target customers and support new sales.
  • l Utilized SAS and SQL Server 2008 T-SQL, DTS, ETL, and SSIS code to aggregate and manipulate large data sets to create mail lists and/or campaign reports.
  • l Analyzed post merge reporting to determine optimal mailing strategy including recommendations concerning postal optimization and regulations, list segmentation and data hygiene. Assigned matrix data for simple as well as complex direct marketing campaigns.
  • l Converted existing DBF data into SQL Server using Data Transformation Services DTS , VBScript. Converted existing FoxPro jobs into VB.NET applications and SQL Server DTS, SSIS packages.
  • l Fulfilled customer segmentation and analysis requests in a deadline driven environment.
  • l Standardized file transfer format for submission to outside company for NCOA processing.
  • l Utilized DATAFLUX application to performing standardization, CASS certification, parsing, match coding data, and merge purge of data ETL to and from SQL Server.
  • l Responsible for ensuring all Marketing data is process through DATAFLUX Data Quality processes.
  • l Responsible for updating DATAFLUX Management Studio and DATAFLUX Server with mandatory patches and upgrades on development and production machines.
  • l Maintained integrity controls and integrity of client's consumer information.
  • l Led data migration tasks for migrating Liberty Mutual Marketing database from a local to a global platform. Created database crosswalk mapping to document data transformation for the source database to the target database.

Confidential

Business Technical Analyst,

  • l Provided Tier I VI technical support for 2200 Field Sales Force end users and 40 super users of any existing and new Mobile Sales applications how-to questions and critical issues.
  • l Facilitated and trained Help Desk and Super Users on the Mobile Sales application business rules and functionality. Created installation documentation, Help Desk scripts, and training material for each upgrade/enhancement. Create a CHM help file for the Mobile Sales application functional.
  • l Responsible for various projects in life cycle phases, from gathering business requirements, writing specifications, and coding through deployment, testing, debugging, documentation, and maintenance.
  • l Worked with business stakeholders, technical teams, and cross-functional units to identify business needs and discuss solutions.
  • l Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • l Responsible for the designing and development of Mobile Sales applications, which receives data by synchronization from a SAP CRM Middleware client/server system.
  • l Utilized Visual Studio 6 and Visual Studio 2005 to create Mobile Sales applications.
  • l Utilized SQL Server to develop store procedures, triggers, views for reading and writing data to data that will be synchronized to SAP CRM Middleware system consolidated database terabyte database .
  • l Trained developers on how to write better SQL Statement, how to use more powerful features like table variables parameters , and how to avoid cursors. Trained developers on how to write better queries to optimize their applications and become junior database administrators.
  • l Managed and supported 2200 1 GB Microsoft SQL Server database issues on sales personnel laptops.
  • l Managed a 2 terabyte SAP CRM Middleware CDB consolidated database .
  • l Wrote T-SQL batch scripts to index and tune SQL Server databases.
  • l Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
  • l Responsible for restoring data on sales representative's laptop by syncing a full copy of the sales personnel data from SAP CRM Middleware consolidated database on to the laptop.
  • l Troubleshot and resolved bugs in .NET applications integrated to the same SQL Server database utilized by Mobile Sales applications to ensure optimal development and reporting environment.
  • l Responsible for the development of complex Excel/VBA spreadsheets and Crystal Reports to report volume data and prices. Integrated the reports within the Mobile Sales applications.
  • l Developed, troubleshot, and maintained the SQL Server databases, SAP CRM Middleware systems.
  • l Responsible for the demonstrations, training end users, presentations and reports of the projects.
  • l Utilized SMS, Microsoft MSI packages to deploy all new applications and upgrades to existing applications.

Confidential

Associate Technical Analyst,

  • l Developed, analyzed, and supported Direct Marketing System and Mass Mobilization System applications to generate consumer information which is given to graphic vendors to create and send out direct mailing coupons and sweepstakes entry forms to loyal customers.
  • l Utilized Mainframe OS/390, UNIX AIX, IBM DB2 database, and COBOL/JCL.
  • l Responsible for performing as a DBA for IBM DB2 UNIX database in support of Direct Marketing and Mass Mobilization direct marketing and campaign analysis.
  • l Created direct marketing mailings for various campaign audiences utilizing Mainframe and JCL.
  • l Developed, analyzed, and supported Direct Marketing System and Mass Mobilization System applications to generate consumer information which is given to graphic vendors to create and send out direct mailing coupons and sweepstakes entry forms to loyal customers.
  • l Responsible for Merge-Purge instructions to our print service bureau including setup of Technical Specifications, NCOA and other list hygiene, Segment Merge Priorities, tests, post-merge splits, nths, and re-uses.
  • l Handle of large datasets, table joins and suppressions in the millions in SQL SERVER SSIS and SAS. Utilize Mainframe OS/390 IBM DB2 Database, UNIX, and SAS for ETL flat file import, data manipulation, formatting, assigning, extracting.
  • l Database and mail file processing using DMA Pander, CASS Certification, NCOA, SERP, Tele Match, Merge Purge de-duplication system .
  • l Wrote applications to validate consumer addresses using GROUP1 Software Code1, List Code, and Geo. Code, and Merge Purge and to load legal cigarette tax information into the mainframe systems.
  • l Developed many legal compliance and government id reports for Corporate Affairs and Legal.
  • l Created multiple statistical reports utilizing SAS programming for adult smoker's mass publication of loyalty coupons by demographic information and geographical locations. Created multiple statistical reports to report taxes for all states each quarter or each time law are approved to raise taxes in various states.
  • l Data modeling and created database using ERWIN.
  • l Wrote SQL queries, cursors, triggers, stored procedures using QMF and T-SQL. Created views and tables for specific cigarette state tax and government id information for various locations, customer demographics, and for specific adult customers.
  • l DBA grant the Senior Marketing Team access to specific database views for report marketing statistical data on consumer purchases.
  • l Utilized UNIX IBM DB2 and Mainframe IBM DB2 QMF tools to index databases to enable faster data retrieval of data into BRIO pivot reports. Create various UNIX scripts for database updates, indexing, and batch jobs.
  • l Created complex joined SQL statements and store procedures used to provide pivotal ad hoc reports
  • l Utilized BRIO Query Reporting tools connectivity to the UNIX IBM DB2 database for some customer demographics, government id, age verification to Corporate Affairs and Legal Teams.
  • l Maintained system applications of the Direct Marketing and Mass Mobilization systems. Functioned as a DBA and SQL programmer of UNIX IBM DB2 Marketing databases. Downloaded/FTP data weekly from the Mainframe to be inserted into the UNIX IBM DB2 database.
  • l Performed indexing and weekly backups of the database.
  • l Facilitate super user training on BRIO Query Reporting tools.
  • l Utilized SAS Base for OS/390 to perform campaign, coupon, and loyalty analysis. Develop histograms, PROC Freq, PROC PLOT, PROC STDEV, PROC Means reports to the business clients.

Hire Now