SUMMARY:

• CAPM (PMI) certified IT manager with experience in leading and working with IT team with team leadership and project management.
• 15+ years IT industry experience with 6+ years’ experience in Business Intelligence implementation, migration, documentation and support.
• 12+ years of experience with RDBMS, database design, data integration, SQL.
• Sound knowledge of Object Oriented Programming (OOP), Software Development Life Cycle (SDLC).
• Adherence to business process analysis and requirement gathering and designing functional specifications.
• Excellent communication, management, problem - solving, analytical and customer support skills.
• 2+ years of experience working with QlikView.

TECHNICAL SKILLS:

Languages: VB.Net, C#, ASP.Net, SQL, HTML, RPG/400, VBA, and Java.

Operating System (OS): Windows 95 - XP, NT, Windows 7, Server 2003 & 2008, DOS, OS/400.

Databases: SQL Server 2005, 2008, 2008 R2 (Database engine, SSRS, SSAS, SSIS), T-SQL, DB2 on iSeries (AS/400), MS Access, DBMS (DBase, FoxPro).

Software/Tools: Visual Studio 2005 & 2008, Visio, MS-Office, MS Project, SharePoint, WinSQL, Web Sphere on iSeries, BI software QlikView and Proclarity, Lawson ERP M3 (formerly Movex), Red Gate Tools (SQL Compare, SQL Search and Source Control), Crystal Report 2008, BPW. SAS DataFlux.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh Durham, North Carolina

Senior Software Developer Engineer

Responsibilities:

• Management and Administration of QlikView Servers and Publishers for deployment, scheduling and monitoring of QlikView documents. Integrating job scheduling for reload of documents using publisher functionality.
• Designed and developed QlikView dashboard applications using SQL Server and Oracle as data source for HR system. The QlikView application contains charts and straight tables for financial analysis, legal analysis and dash boards for Executive users. Developed VB macros to export straight tables in excel workbooks that included multiple worksheets, formatting of data.
• Developed ETL processes in QlikView to extract data in full and incremental data load from DB2 and Oracle databases to create QVD files. Designed Life Claim data model for the using the QVD files to associate data from different sources including Excel files. Developed QlikView dashboard applications to replace the manual process done in Excel.
• Developed SQL Scripts for extracting data from different sources and design data models for QlikView reporting.
• Extract the data from MS SQL Server for the marketing database. Build an ETL process as staging tables using SSIS and then load them in QlikView reporting tools. The process included to load incremental data and design and develop data model for marketing analysis.
• Developed SQL Scripts for extracting data from different sources and design data models for QlikView reporting.

Confidential, Raleigh, North Carolina

Business Intelligence Report Developer

Responsibilities:

• Designing, development and Management of QlikView documents with consultants for Finance, Commercial Operation data domain, Sales Based dashboard developments. Designed Qlilkview Publisher based scheduling to generate PDF reports for Salesman and Territory/Region distribution. The Data source was from SQL Server 2008 R2.
• Designed and developed Data warehouse using MDM database exports. Designed slowly changing Dimension (SCD) table in HCP, HCO domain using Kimball methodology. Developed SSIS ETL processes to load Dimensions and fact tables in SQL Server 2008 R2 database.
• Designed a data mart using Microsoft SSAS to build cubes on the fact and dimension tables.
• Testing and Data Quality Assessment of the implementation of Master Data Management (MDM) with SAS DataFlux Management in the Health Care Professionals and Organizations(HCP/HCO) domains. Developed Test scripts and SQL scripts for testing the six different input data source and MDM golden records of locations, HCP, HCO and their associated attributes.
• Worked with SAS consultant in documentation of the process/batch jobs in Data Management Studio, Quality Knowledge bases, data profiling.
• Administration and Monitoring of DataFlux Management Servers (Dev/QC), executing jobs, maintain repositories, manage and merge source control using TFS. Created release process and documents for Production deployment.
• Administrations and Monitoring of data updates in DataFlux. Designed and developed error reprocessing batch jobs on rejected data from data sources.
• Designed and developed ETL processes using SSIS to load data from large text based data source into SQL Server database (2008 R2), including downloading from FTP sites.
• Design and develop new ETL processes to load Vendor Sales based data into SQL Server database.
• Working on the Company Intranet website to add new functionalities in VS 2010, ASP.NET and VB.NET. Enhanced Sales Department sites to all allow adding SQL database access for Sale information.
• Management and Administration of QlikView Servers and Publishers (Test and Production) for deployment, scheduling and monitoring of QlikView documents. Integrating job scheduling for reload of documents using EDX functionality.

Confidential, Raleigh, North Carolina

Data Warehouse Analyst

Responsibilities:

• Implementation of QlikView software (Version 9 and 10) for developing dashboard reports using SQL Server 2005 Data Warehouse database, including script writing and design front end charts, graphs.
• Designed QlikView presentation documents for monthly Agency analysis using the Policy financial information. Designed and develop a validation process for claim department, write scripts to load data from SQL Server transaction system, AS/400 system. Designed and developed various Policy based KPI documents in QlikView for power user and executive.
• Manage and deploy QlikView documents on QlikView Server. Scheduled documents for automatic daily and weekly reload on the server. Support and resolve any issues with QlikView Server access point for user. Perform QlikView server upgrade from 9 to 10 and 2 release upgrade with Administrator.
• Responsible building Data Warehouse using Microsoft Business Intelligence Toolset (MS SQL Server 2008 R2 Database engine, Integration Service, Analysis Service, Reporting Service). Additional responsibility to manage backup and restore process, performance tuning of database queries.
• Implemented Red-gate Source control software with Sub-version for SQL Server 2008 R2.
• Upgraded MS SQL Server from 2005 version to 2008 R2 Database engine, convert and upgrade SSIS packages.
• Automate data driven process to create monthly Agent Commission reports using SSRS subscription and FTP the files to external server using SSIS.
• Automate monthly data driven process to create Agent and Producer based performance 1200+ PDF reports using SSRS subscription and FTP the file to external using SSIS.
• Automated daily data driven process to create Policy and Claim based audit reports using SSRS subscription to generate and feed the workflow of the Document and Content Management software Image Right.
• Implementing Share Point 2007 and SQL Server Reporting Service (SSRS 2008) in integration mode and designing new reports using the Report Builder 2.0 and KPI reports in OLAP Cubes and Share Point 2007 Business Data Catalog.
• Created a daily data extract (ETL) process for 100+ tables from the OLTP source (AS400) system into the MS SQL staging database using SSIS packages.
• Created a daily incremental ETL process in SSIS packages to update the Dimension tables with Slow Changing Dimension (SCD) based on the Star Schema model (Based on Ralph Kimball methodology Dimensional modeling).
• Created the daily incremental ETL process to fact tables using SSIS and SQL stored procedures.
• Designed and implement daily night jobs using SQL Server job agents to run the ETL packages for staging table update, Dimension and Facts process.
• Designed and implemented SSRS validation reports for the dimension and facts update to email using SSRS subscription.
• Convert existing Crystal Report to SSRS reports.

Confidential, Morrisville, North Carolina

Senior ERP Analyst

Responsibilities:

• Design and developed complex reports using the SQL Server BI Studio, Reporting Service and database in the Finance module (AR/AP aging), Sales and Distribution.
• Perform the DBA role to manage and maintain 4 MS SQL 2005 database servers, write stored procedures and create indexes for the report requirements. Maintain and tuning of the Lawson ETL software BPW.
• Project Lead on the manufacturing plant sold by Corporate to setup, transfers and migrate the ERP System M3 to the target company's system on iSeries (AS/400) and Windows 2003.
• Part of the project team on business intelligence project using SQL Server 2005 and Proclarity. Designed, documented and developed OLAP cubes using the M3 sales orders and invoices data. Created technical report specification documents for outsourcing the developments.
• Active member of support group during Go-live Phase of M3 ERP implementation in the modules of customer order management, supply chain executions, inventory management, finance, purchasing, bill of material, resource planning, manufacturing.
• Managed the integration and migration of the existing Inventory, open AR and financial data from the old legacy systems to ERP M3 system using Movex/M3 API with developing application in C#.
• Designed, developed and deployed a reporting intranet framework for documents, reports and barcode label solution from M3 database using VB.NET, ASP.NET, Windows 2003, IIS and MS SQL Server 2005 and SSRS.
• Supervised the design and development of interface and integration requirements with M3 supply chain execution module to provide data to the third part logistic (3PL) software using VB.NET and MS SQL Server 2005.
• Worked with Lawson consultants on technical design and installation of ERP M3 system on iSeries (AS/400). Created, Configured and administered Production, Test and Education environments during the implementation.
• Developed the project plans in MS Project, design and training documents and trained the existing IT staff and users. Reported directly to the Corporate IT Manager with weekly status reports.

Confidential, GroveTown, Georgia

Application Manager

Responsibilities:

• 5 years of progressive increases in both system developments and project leadership to implement IT system solutions to support organizational business processes and requirements.
• Implemented the Business Intelligence software QlikView 7 with AS/400 database as backend. Developed Key Performance Indicator (KPI) reports, Sales based reports for executive and management.
• Worked with Finance department to create scripts and QlikView documents to using financial data from ERP system. Worked with Planning department to create scripts and QlikView documents using a What-If analysis planning scenario.
• Oversee development of applications and support systems and led 6-person team and encompassing weekly management reporting to IT Director.
• Successfully led the migration team of 5 IT professionals during the ERP software Movex version upgrade project. Project managed the upgrade process with the process owners and users and IT team to research the gap between the versions, new features introduced, existing customizations, full scale testing and successful migration to next version. Responsible to create and manage project plan in Microsoft Project
• Supervised the implementation of the Movex ERP modules of ATP, warehouse management, and account receivable to ensure the full-use of functionalities to improve business process, reduction of operation errors and support. This included communication, issues management and patch application with ERP vendor support.
• Part of the project team to design and develop interface and integration between Movex and Conveyor System for Distribution Center. Designed and developed new bar-coding solution for warehouse management.
• Project responsible in developing and testing the interface and integration custom application between Movex and multi-carrier shipping software Pfastship.
• Developed enhancement to overcome the gap and limitations of the base Movex ERP software with new customization to support the organizational business requirements and functionalities
• Supported in 2nd Tier for the world class ERP software Movex in the modules of customer order management, supply chain executions, inventory management, finance, purchasing, bill of material, resource planning, manufacturing.
• Developed customized new reports using Movex standard in RPG/400, CL/400.Formulated, wrote, and documented technical requirement specifications, user manuals, and data and process flow diagrams.

Confidential

System Analyst

Responsibilities:

• 2 years as ERP technical consultant on Movex ERP software projects in India, Belgium, Poland, Holland and USA as a role of system analyst, DBA and programmer.
• Took initiative to learn Movex Standard development Case tools, Movex RPG/400 programming standards, database schemes, technical requirement specification documentations.
• Took initiative to learn and developed programming skills in RPG/400, CL/400, and SQL and AS/400 administration.

Confidential

EDP executive

Responsibilities:

• 3 years as EDP Executive with the implementation and support of computerization of two division of the company on Netware LAN 4. 10 with 50 PC and 75 users. Using FoxPro, C, C++, and SQL developed in-house programs and utilities for services, billing, warranties and accounting system for auto-service workshop.