SUMMARY

• Accomplished VBA Developer / Data Analyst professional with over 10 years extensive experience in business analysis, data analysis, project initiation, software design, programming, coding, development, troubleshooting, maintenance, support and data management.
• Areas of expertise include planning, conceptual design, requirements definition, system programming specifications and documentation, quality assurance / system testing and implementation.

TECHNICAL SKILLS

Database development: MS SQL Server / 2008 R, Transact - SQL, SSRS, SSIS, SSAS, Business Intelligence technologies, MS Access / 2007, Oracle 11g/10g/9i, ETL, Teradata 7.1, Oracle SQL Developer, Toad for Oracle, Oracle SQL * Plus.

Technologies: Visual Studio / 2008, SDLC, ADO, ODBC, ASP, Teradata SQL Assistant, BI IIS, MS Project, SharePoint, MS Power Point, Excel Macros, Pivot tables, SAP ERP 6.0 KPI’s, Data Warehousing, Data Transformation Services (DTS), Rumba MF Display 7.2.

Programming languages: T-SQL, VBA Access, VBA Excel, PL/SQL, VBScript, Visual Basic 6.0, XML, HTML.

Reporting: SSRS, VBA Access / Excel automated reports, Crystal reports, IBM Cognos Report Studio.

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Sr. VBA Developer / Data Analyst

Responsibilities:

• Translated business needs into analytics / reporting requirements, identified requests and opportunities for improving data management and delivery. Navigated MS Access Database as front-end with various information systems - Teradata, SQL Server, EDW, Oracle and extracted the relevant reports for their product groups.
• Created Pivot Tables in Excel reports with quantity and item sum costs for SKUs based on Cubes connected to SSAS.
• Created automated MS Access processes to extract and utilize the data from different sources, JDA / Apple.
• Design new reports, data transformation and flows. Developed and created dashboards and ad hoc reports.
• Designed and coded automation VBA processes for External data reconciliation reports in MS Excel and MS Power Point with MTD / YTD scorecards based on Inventory daily processing. Designed and developed reports in Excel VBA by utilizing SQL, VB Script and the use of cube technology within Cognos, MS SQL Server Analysis Services and SAP.
• Collected and processed Warehouse data from EWD using views, stored procedures, functions and jobs.
• Created written specifications before the development phase for the business logic and data access logic.
• Developed the test plans that tested Excel VBA applications in iterative process to ensure they work.
• Created automated MS Access / Excel applications based on VBA Macros with advanced data manipulation inPivot Tables, Charts, Tables, Ribbon interfaces, queried Ranges and formulas using code in modules and classes.
• Scripted respective tasks in Excel VBA for management reports presentations. Reconciled data gaps.
• Monitored inventory levels and ensured that all orders are completely accurate through supply chain KPIs and metrics to ensure that operations are running smoothly. Corrected acknowledged problems by updating results.

Environment: MS Access/Excel VBA, MS Power Point, T-SQL, SQL Server, ODBC, Teradata, SSIS, Cognos, Oracle, ETL.

Confidential, NJ

Sr. VBA / SQL Server Developer

Responsibilities:

• Designed, developed, implemented and supported database objects such as MS Access forms, sub forms, tables, complex queries (used as Front end) and SQL Server functions, views, stored procedures, jobs and triggers (Back end) used for Family Tree Service / Maintenance GBO projects. Performed data mapping and ETL.
• Developed and automated complex data extraction and verification processes in VBA / Macro Excel and MS Access database. Coded all procedures to prepare tables and queries for auto reporting processes.
• Created, supported and improved internally developed applications used to support business process.
• Extensive experience using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform & Load (ETL) data. Packages installation, modifying, editing and debugging.
• Supported databases with multiple concurrent users, ensuring control, integrity and accessibility of the data.
• Coded VBA macros, modules, classes and procedures (linked ODBC to source data in SQL Server, Oracle MS Access and Excel VBA) for automation solutions and troubleshoot data processing issues.
• Improved operational procedures to maximize systems efficiency and database integrity using T-SQL.
• Developed logical and physical data flow models and applications for automated data verification, consolidation, comparison, reconciliation and validation. Analyzed output data with conditional formatting.
• Created After, Instead of and DDL triggers to extend the normal processing of a SQL statements with applications for comparison, reconciliation and data verification in SQL Server 2012 and Teradata.
• Used optimization, performance tuning and debugging. Created indexes for improving execution speed.
• Used DDL to created and altered tables, views and apply declarative constraints to protect data integrity.
• Designed SSIS ETL processes to control data access, transformation, distribution and movement.

Environment: SQL, T-SQL, SQL Server, MS Excel/Access VBA, MS Visio, Crystal Reports, ADO, ODBC, SSIS, SSRS, Teradata

Confidential, NJ

Sr. VBA Developer / IT Data Analyst

Responsibilities:

• Designed front end MS Access / Excel based workflow applications using the Excel Object Model and VBA for extract, transmitting and converting Medicare COB source files to the tables in Teradata/SQL databases.
• Created multipart applications to sponsors of prescription benefit plans and payers of medical claims for selected plans and clients using VBA Access / Excel Macros and MS Excel / SQL Server interaction.
• Developed production tools for establishing and reviewing quality control and data verification rules using 3-D formulas, statistical and logic functions. Developed automated data analysis and data validation management tools to ensure the accuracy of the data between source systems and target databases.
• Designed and maintained Pharmacy Benefit Management (PBM) full development life cycle projects and Retail Pharmacy Network applications including analysis, development, testing, maintenance and implementation.
• Provided support and enhancements of projects once they are in a live production environment.
• Created and supported Pharmacy Contract and Reporting Access databases based on business rules, user input account or superchain data, quality control and interaction with all the business requirements.
• Collected all entries with active pharmacy contract details from extract files for claims research, network options and requests for proposal data. Coded all processes to identify standard networks.
• Developed Blue Cross Blue Shield of MI project based on daily maintenance files. Created automated client-specific MS Access / Excel reports for Feedback and Exception Sheets files to update universes in Preferred Provider Organization (PPO) tables on client’s and company sites. Coded all processes to identify standard networks that change of ownership providers using MS Access database and MS Excel.
• Worked with reference data (warehouse) optimized through data integrity, ETL, database normalization and an entity-relationship model. Gathered requirements, create logical models and provide quality detailed documentation.
• Created Audit database to check and compare network’s Standard/Maintenance/Specialty, Brand/Generic rates and fees to ensure quality assurance and client’s data verification. Coordinated all the project related activities, implementing action plan to meet agreed standards and deadlines using MS Access database.
• Developed and automated complex data extraction and verification processes in VBA / Macro Excel and

  MS Access database to transfer files between PC and PShare Mainframe using API functions for FTP.

• Designed and maintained front / end-user data sets for statistical displaying, business analysis and guarantee reconciliation summary using MS Excel / SQL Server 2008 R2 auto-generation model.
• Creating / deploying SSIS packages for Extracting, Transforming and Loading ( ETL processing ) data from various systems, flat files, XML / Excel / CSV files, relational databases and other data sources.

Environment: MS Access/Excel VBA, VB, ODBC, Oracle, Teradata, MS SQL Server, T-SQL, Cognos, XML, Rumba MF.

Confidential, Florham Park, NJ

VBA Developer / Data Analyst

Responsibilities:

• Created Summary Retirement Service 401(k) plans monthly reports with roll call calculations for selected dates and Manager Dashboard up-to-date summary reports with totals started / no started plans data.
• Created Tracking Log in / out program to collect User IDs, computer names, database names, versions, and paths for increasing databases security and data integrity using VBA with Windows API functions.
• Retrieved and maintained production data, created tables, views, indexes, wrote stored procedures that extract data from multiple servers, developed triggers and created user-defined functions with T-SQL.
• Developed and updated processing / reporting tables, queries and procedures for Retirement Service production reports for selected dates. Running weekly / monthly Paycheck reports using Crystal Reports.
• Collected with FTP tasks and processed the data from SQL Server databases for creating weekly, monthly and YTD analytical reports, dashboards and associate scorecards with VBA MS Access / Excel reports.
• Created SQL queries for data analysis for various platforms and sources - Oracle, SQL Server, MS Access, SharePoint, and documented. Designed Crystal Reports with SQL queries as back end.
• Summarized data with MS Excel using formulas, formatting, charts and graphs. Navigated and manipulated multiple spreadsheets in workbook, optimized worksheets using templates, graphs, formulas & functions.
• Created ETL processes to converting flat files to fixed-length and extracting these files to SQL Server tables.
• Debugged and fixed MS Access database source code. Used Error handlers for troubleshooting VBA issues, identified error messages, debugged error messages, identified code problems and work around solutions.
• Verified mappings between various workflows (ex: Mainframe EDW to ETL, EDW to staging and to Core tables). Created test cases in MS Access VBA verifying business rules, assumptions and logic.
• Used advanced Excel skills including Pivot tables, VLOOKUP / HLOOKUP functions with a logical relationship in MS Excel worksheets to perform calculations at application run time with VBA auto-generation reporting process.
• Troubleshot production applications issues including attempts to reproduce problems in test environment, identified error messages, investigated environmental-related anomalies and debugged error messages. Debugged and fixed Oracle database source code including stored procedures, stored functions and triggers.
• Created processes for transferring data from diverse sources into different databases using Data Transformation Services (DTS). Developed ETL packages for running in different servers utilizing package configurations, secure packages for implementation and provide flexible procedures for unintended implementation using SSIS.
• Designed forms in Multiple Document interface (MDI) environment and wrote programs for extract, inquiry and report creation for client company order processing and sales activities using VB 6.0 / MS Access / Crystal Reports.
• Developed and supported production applications converted from MS Access into Visual Basic / Oracle model in Win NT environment. Designed, developed and maintained Graphical Users Interface (GUI) for various applications and systems using ActiveX controls, modules, classes and form templates of VB 6.0.
• Designed and implemented the applications for generating automated running reports in a timely manner using Batch files and Windows Scheduled Tasks processes. Maintained, upgraded and troubleshot the processes.

Environment: VB6, MS Access/Excel VBA, Oracle, PL/SQL, SQL, Toad, MS SQL Server, T-SQL, ODBC, HTML, Crystal Reports.