SUMMARY

Professional individual with 14 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), score cards, ad-hoc query, and analysis reports with drill up, 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.

Database/Business Intelligence Experience

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 Vista/7/8, VMware Player/Station, Mac OS Lion

Databases:

MS SQL Server 7/2000/2005/2008 R2– ETL/DTS/SSIS/SSRS, RedGate, Oracle 8/9i/10i – PLSQL, Toad, IBM DB2, MySQL, PostgresSQL, SAP CRM

Business Intelligence:

SSRS, Crystal Reports, SAP Crystal Reports, BRIO, Cognos, Qlik6view, LogiXML

Data Warehouse:

SQL Server 2008 R2 SSAS, WhereScape Red

Data Modeling:

ERWIN, Devart Entity Developer, Microsoft Visio, SQL Server SSAS Dimension Modeling, SQL Server Data Diagram

Integration Software:

DATAFLUX dfPower Studio & Server, Group1 Suite

Programming 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, PHP, COBOL/JCL, QMF, PowerBuilder

Testing and Change Control:

Test Director, SeaPine Software Surround Control

Software:

Microsoft Office 2010 Professional Plus, Microsoft Office 2011 Mac, WordPerfect, Microsoft Communicator

Web Development:

WordPress, Joomla, CMS, XML, HTML 5, CSS, PHP, Macromedia Flash, Dreamweaver, Artisteer 3, Edit Plus, NotePad++, Apache Web Server

IT Experience

Confidential,Raleigh, NC

• Contractor – Data Warehouse Developer II, (June 2012 to Present)

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:

• 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,Fort Lee, VA

• Database Engineering III, (September 2011 to June 2012)
• Support efforts to create a new data warehouse and new flexible reporting capabilities for the Department of Defense Army Food Management Information System (AFMIS).

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

Confidential,Richmond, VA
Database Analyst 4 – Associate Vice President, (July 2010 to September 2011)

• 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.

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.
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.
Validated calculations against SAS dataset pulled from Oracle.
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.
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.

• Documented the Database tables, views, stored procedures, and DTS/SSIS packages processes.

Confidential,Richmond, VA

• Senior Database Analyst/Direct Marketing Analyst, (January 2010 to July 2010)
• 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.
• Provided geographic and demographic metrics to business clients for deciles of direct mail audience and further analysis.
• Performed data mining, data warehousing, and data processing for clients Liberty Mutual Insurance & Citrix.
• 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.
• 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.
• 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.
• 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.
• Fulfilled customer segmentation and analysis requests in a deadline driven environment.
• Standardized file transfer format for submission to outside company for NCOA processing.
• Utilized DATAFLUX application to performing standardization, CASS certification, parsing, match coding data, and merge purge of data ETL to and from SQL Server.
• Responsible for ensuring all Marketing data is process through DATAFLUX Data Quality processes.
• Responsible for updating DATAFLUX Management Studio and DATAFLUX Server with mandatory patches and upgrades on development and production machines.
• Maintained integrity controls and integrity of client’s consumer information.
• 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,Richmond, VA

• Business Technical Analyst, (June 2002 to February 2009)
• 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.
• 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.
• Responsible for various projects in life cycle phases, from gathering business requirements, writing specifications, and coding through deployment, testing, debugging, documentation, and maintenance.
• Worked with business stakeholders, technical teams, and cross-functional units to identify business needs and discuss solutions.
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Responsible for the designing and development of Mobile Sales applications, which receives data by synchronization from a SAP CRM Middleware (client/server) system.
• Utilized Visual Studio 6 and Visual Studio 2005 to create Mobile Sales applications.
• 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 (terabytedatabase).
• 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.
• Managed and supported 2200+1 GB Microsoft SQL Server database issues on sales personnel laptops.
• Managed a 2 terabyte SAP CRM Middleware CDB (consolidated database) on an UNIX Oracle platform. Created stored procedures and query using PL-SQL.
• Wrote T-SQL batch scripts to index and tune SQL Server databases.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• 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.
• Troubleshot and resolved bugs in .NET applicationsintegrated to the same SQL Server database utilized by Mobile Sales applications to ensure optimal development and reporting environment.
• 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.
• Developed, troubleshot, and maintained the SQL Server databases, SAP CRM Middleware systems.
• Responsible for the demonstrations, training end users, presentations and reports of the projects.
• Utilized SMS, Microsoft MSI packages to deploy all new applications and upgrades to existing applications.

Confidential,Richmond, VA

• Associate Technical Analyst, (June 1998 to June 2002)
• 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.
• Utilized Mainframe OS/390, UNIX AIX, IBM DB2 database, and COBOL/JCL.
• Responsible for performing as a DBA for IBM DB2 UNIX database in support of Direct Marketing and Mass Mobilization direct marketing and campaign analysis.
• Created direct marketing mailings for various campaign audiences utilizing Mainframe and JCL.
• 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.
• 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.
• 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.
• Database and mail file processing using DMA Pander, CASS Certification, NCOA, SERP, Tele Match, Merge Purge (de-duplication system).
• 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.
• Developed many legal compliance and government id reports for Corporate Affairs and Legal.
• 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.
• Data modeling and created database using ERWIN.
• 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.
• DBA; grant the Senior Marketing Team access to specific database views for report marketing statistical data on consumer purchases.
• 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.
• Created complex joined SQL statements and store procedures used to provide pivotal ad hoc reports
• (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.
• 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.
• Performed indexing and weekly backups of the database.
• Facilitate super user training on BRIO Query Reporting tools.
• 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.

Education

B.S. in Computer Information Systems/Business major.

Keywords
SQL Server 2005/2008, SQL Server 2008, ETL, DTS, SSIS, SSRS, SSAS, SAS Programming, SAS, SAS/Access, DataFlux, dfPower Studio, DataFlux dfPower, Business Analyst, Business Liaison, Oracle 8/9i, PLSQL, Toad, SAP CRM, SAP R3, SAP CRM Mobile Sales, SAP SD, Helpdesk Management, Offshore Management, IBM DB2, UNIX, VB.NET, VB6, VBA, Excel Macros, C#.NET, Business Intelligence, WordPress, Joomla, HTML5, CSS, PHP, MySQL, Crystal Report, SAP Crystal Report, Brio Query, Visio, ERWIN, Mainframe, ISPF, COBOL/JCL, Business Intelligence Analyst, Business Intelligence Developer, Data Warehouse, WhereScape Red, Devart Entity Developer, LogiXML, QlikView, Dimensional Modeling