SUMMARY

• More than 10 years of Access/VBA/Excel/Teradata development and Data Analyst experience in the areas of mortgage, health care, telecom, retail market and financial services.
• Extensive development experience in VB.Net and VB Script
• Extensive massaging & analyzing data using MS Excel, Pivot Tables & Charts and VBA.
• Diverse experience in Consulting, Research, Consumer Analytics, and Predictive & Operational Analytics.
• Excellent working experience with Databases like Access, MS SQL Server, SQL, Stored Procedures, Import and
• Exports, Microsoft Office Suite.
• Well versed with Oracle, C / C++ / C#.Net / ASP.Net programming
• Thoroughly abreast with full SDLC process including requirement gathering, test case development etc.
• Good understanding of retail market and demand forecasting.
• Very strong communication and interpersonal skills, working experience with APAC, C&LA and EMEA regions.
• Strong organizational, presentation and negotiation skills; highly motivated, team player, quick learner.

TECHNICAL SKILLS

• VB.Net
• VB Script
• Excel
• Access
• VBA
• SQL Server
• Macros
• Forms
• File Operations
• ActiveX
• Menus
• R
• SQL
• C
• C#.Net
• ASP
• & JavaScript
• Visual Studio 2013
• Access Reports
• Excel Reports
• Teradata
• SQL
• Macros

PROFESSIONAL EXPERIENCE

Confidential - Ewing, NJ

Sr. Application Developer / Data Analyst

Responsibilities:

• Solely responsible for interacting with business users to gather requirements for process automation of letter creation.
• Providing suggestions for complete process flow of the protocol followed from template generation, word bookmark creation, data file format, letter creation using bookmark value substitution, log generation, and updating database.
• Creating BRD for protocol documentation using flowcharts and component description documents and diagrams.
• Extensively coding whole process using VB.Net, and C# for creation of various modules.
• Taking user generated template in MS Word and creating Bookmarks for values that need to be substituted from data file for creation of final letter that is sent out to print vendor.
• Using the Bookmarked Word document and data file from the system manager to create the final letter PDF.
• Extensive provision for exception handling for robustness and easy status check on the fly for non-technical users.
• Creating various log files (Exception Log, 14E Log & DB Log) to update various systems for tracking outgoing letters.
• Creating a letter profile to dynamically intimate the process of any changes that needs to be incorporated for each run of the program. The eventual goal is the make the application environment domain agnostic so that it can be deployed Confidential will to various intimation protocols with minor configuration changes.
• Creating functionality to archive the application run, and all the components/files generated in the process.
• Planned future activities include generation of client-server module which would enable for application to be deployed on multiple machines and would keep track of the current status of each instance running on these machines.
• Creating GUI in a C# environment to encapsulate the underlying process and abstracting it from business users.
• Training all the stakeholders of the application and will be involved in maintenance and enhancement of the product.
• Liaising with client representative to make changes to various daily and monthly extracts based on clients’ requests.
• Creating / modifying multitude of SQL server queries for end clients.
• Creating ad-hoc excel templates using formulas and VBA code to be used as a configuration file for monthly uploads.
• Extensively created and used various listener programs and desktop schedulers for various process automation.

Environment: VB.Net, VB Script, C#, MS SQL Server, Outlook, Visual Studio 2013

Confidential - Franklin Lakes, NJ

Data Analyst / Sr. SQL Excel Access Developer

Responsibilities:

• Solely responsible for development of Formulary Advisor Application for end client on excel platform using VBA.
• Gathered requirements in team meetings over phone for various stakeholders.
• Developed excel input template to load data in Formulary Advisor Application.
• Designed and developed the application capable of handling multi state/ multi formulary data.
• Conducted testing and facilitated UAT for gathering business user feedback for formal release.
• Generated release document for formal release.
• Gathering requirements from management for creation of peripheral tool for CPS.
• Developing dynamic VBA applications using Excel, PowerPoint and a C# & XML based to support data modeling based on frequently queried client requests.
• Used presentation object and slide specifications to develop PowerPoint presentation using VBA for end user use.
• Extensively used ActiveX controls to generate customized output for clients.
• Redesigned new CPS tool to reduce the run time from 45 minutes to 10 minutes by reducing the number of queries.
• Coordinating UAT for the developed tool and gather inputs on the modifications based on user requirements.
• Generating customized report template using share-point for marketing team to input most updated client information.
• Execution of Client request for ad-hoc reports based on generic drugs, BPLs and DIV Level.
• Guide the management team with any semantic error that they encounter for any reports developed by client.
• Creating and refreshing monthly Well Point report for management.
• Refreshing weekly DIV level client details on Teradata enterprise database.

Environment: Teradata, Excel, PowerPoint, and VBA, Visual Studio 2013

Confidential - Chicago, IL

Excel Access VBA Developer/Remediation Contractor

Responsibilities:

• Generated macro for complex reports downloading data from SAP and using it as input to Excel macro.
• Created dynamic Excel reports to generate revolving month’s data for actual and forecasted sales data.
• Generated Access applications to upload and download archival data seamlessly to and from Excel reports for trend forecasting and data analysis.
• Customized Access application to pull data based on multiple parameters to generate highly efficient reports.
• Involved with Office 2010 upgrade team as a Remediation Analyst for a smooth transition to new office platform involving Excel, Access, PowerPoint and Attachmate Reflection upgrade.
• Created Excel and Access based inventory-management application creating a communication tool for stakeholders.
• Ticket queue management and coordination with individual employees or issue resolution.
• Extensively involved in VBA code modification and module testing for incompatible code in new VBA object model.
• Coordinate with partners for UAT of applications involved in code up-grade.

Environment: Access, Word, Excel, Visio, VBA, Office Converter

Confidential - Georgetown, KY

Excel Access VBA Developer / Remediation Contractor

Responsibilities:

• Designing project plan for deployment of Office 2010 for Accounting and Finance Department.
• Remediating all issues arising due to MS Office 2010 upgrade by ticket resolution methodology for all departments as part of MS Office2010 remediation team.
• Modifying existing applications for many non-supported functionalities in Office 2010 from Office2003, including support for MSCAL, Snapshot viewer, side by side installation etc.
• Replacing menu based add-ins with customized XML toolbars programmatically.
• Developing test cases for systematic cross-department inventory management and scanning.
• Scanning and Inventory management of all MS Office document for compatibility issues.
• Management and remediation of all compatibility issues based of native tools scan results and Converter Technology's proprietary auto-remediation suite.
• Monitoring Service Configuration and Client Management for deployment of Office 2010 primarily for Acct. & Fin. Dept. and other concerned department, including but not limited to Quality Control, Production Control, Paint and Body-weld dept.
• Engaging customer in training for familiarizing them with the new ribbon menu for Office2010, use of the new and existing financial features in the Data-Analysis toolpak and XML based database management system.

Environment: Access, Word, Excel, ASP, JavaScript, Visio, VBA, Office Converter, OMPM, OCCI, and SQLServer

Confidential - Morristown, NJ

Financial Analyst / MS-Access, VBA Developer & Contracts Administrator

Responsibilities:

• Collected data in monthly report format from teams to massage and consolidate in GW Tracker upload report format.
• Provided monthly report to department, for sales of International Global Wholesale as a metric with respect to global competitors’ market share on volume-revenue share basis.
• Provided projection and trending metrics to the pricing team using various parameters including UCNS, ASR, & ALOC.
• Involved in day-to-day traffic tracking to maintain UCNS and carrier trunk blockage based on their creditworthiness.
• Developed complex reports to compare crude usage data from various carriers to provide cost analysis. Developed excel macros and access stored procedures to connect usage data to access queries for route determination.
• Forecasting rate trends by analyzing market rates and shift of minute volumes on regional and country level.
• Requirement analysis from the user group for understanding workflow of the existing manual CMP automation.
• Developed HLD (Stakeholder identification, Diagrams, Flow Charts mockups) and LLD to the development team and acquainting the team with the design specifications and process flow.
• Wrote various Excel VBA scripts and access queries to massage raw data from carriers across the globe to standardize the data input format and used pivot tables/charts extensively for presenting various trend analysis to dept.
• Extensively involved in UAT of iStars system for contract entry, creating test cases, maintaining logs & reporting bugs.
• Exclusively involved in training RAMs/ADMs for contract entry template generation and process for bilateral contracts.
• Working with Billing & Settlements team to develop various cross department protocols and new data forms.
• Solely responsible for administering global telecom contracts from all regions for SOX compliance.

Environment: Access, VBA, Excel (techniques/models), Outlook, Visio

Confidential - Columbus, OH

Access / Excel / VBA Developer / Analyst

Responsibilities:

• Semi Annual Sales Distressed Product Offer Tracking & Segmentation Reporting
• Requirement analysis from user group and discussion over the metrics needed for analysis throughout development of project.
• Developed queries/tables for sales/inventory/in-transit commodities center data to understand accuracy of offer on product.
• Developed stored procedures for sales forecasting based on current sales, sale-index, and end-of-sale inventory.
• Developed excel templates for exporting report data with formatting for daily leadership meeting.
• Generating code for automation of report/exporting data to excel and deployment.
• Performed extensive Regression testing and made design changes to accommodate data load on server by breaking data in parts.
• Customized report for generating data for particular SubBrand used by SubBrand owners.
• Conducted training sessions for user-group for report.
• Requirement analysis from the user group for discussing report structure and understanding metrics calculation.
• Designed Tables and Relationship for application in MS Access. Generated link specification for linking sales/inventory data downloaded from microstrategy (MSI).
• Developing queries for various sales and inventory metrics and coordinating with the testing team for reconciling the test results.
• Generating code/form data automation import/selection of appropriate store/enabling outlier store exclusion/report generation.
• Extending project to pick up products from form/fragrance level for more accurate analysis.
• Stress Testing and Design modification for efficiency and reduction of report execution time.
• Created User Manual, Technical Documentation, and provided training to Users.

Environment: VBA, Excel (Templates), SQLServer, SQL, Stored Procedures, ASP, JavaScript and MSI

Confidential

VBA Developer / Software Engineer

Responsibilities:

• Worked on Excel based interface built using VBA that uploads daily Reuter’s rates for a multitude of securities to database tables.
• Worked in Trade blotter that displays position with Mark-to-market values, using Excel, VBA, ADO.
• Developed Excel templates (VBA, Macros) that retrieved rates and other information of various options and futures instruments from Bloomberg using Bloomberg APIs.
• Developed various Access based software tools that parsed XML requests using the MSXML toolkit and uploaded data into spreadsheets and databases. Apps were developed using other Access components like Reports, Forms, Queries, & Macros.
• Developed programs to update static (securities) data; load historical market data (SQL Server).
• Developed Access/VBA programs to convert various feeds/reports into HTML pages to view through browser.
• Developed minor Python scripts for ad hoc programming, processing batch jobs.

Environment: VBA, Excel, Macros, Access, SQLServer, HTML, XML, XMLSpy, MS Front Page, MS Visio, MS Project, MS Word