PROFESSIONAL SUMMARY:

• Over 11 years of IT experience as Excel/Access/VBA Developer.
• Extensive experience in Gathering Requirements, analyzing them, Business Process Design, authoring Business Requirements Document (BRD), Use case Specifications, Functional/Systems Design/Software Requirements Specification (SRS), Detailed Design Specifications (DDS), Workflows using SDLC and Agile methodologies.
• Highly proficient in Access/excel/SQL data extraction, transformation and loading using ODBC, ADO, DAO, Transfer spreadsheet method and Transfer database method.
• Expert in all aspects of MS Access (tables, queries, forms, reports, modules, macros, security) including database design & development
• Efficient in building Access/Excel front ends using VB forms and manipulating them through VBA.
• High level of expertise in advance Excel features like pivot tables, charts, functions and web services
• Highly experienced in SQL queries, joins and store procedures.
• Advanced SharePoint skills - creating & designing web parts, views, reports, surveys, workflows and interfaces.
• Highly experienced in financial market & Sound knowledge of financial market instruments: Equities, Fixed Income Securities, Derivative Instruments, Options, and Futures
• Developed and implemented reports against SQL Server, Access, Store procedures and MS Excel.

SKILLS:

MS Access 1997/2003/2007/2010/2013/2016 , MS Excel 2003/2007, 2010, 2013, SQL Server 2008, SharePoint 2007/2010, SharePoint designer, ADO, DAO, Soap UI 4.6.4., Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Software Developer/Business Analyst

Hardware/Software: Excel 2010/SharePoint/SQL Sever

Responsibilities:

• Supported enhancement for 5 key Excel/Citrix based Pricing models for different line of business.
• Interact with the business to document the requirement in TFS tracking system in each release ranking meeting based on agile methodology
• Investigate requirements to update BA & Developers effort for each story in team release planning meeting
• Reviewed state regulatory and compliance policy forms and designed automated procedure using Excel VBA to display these forms for selection and print based on different criteria such as state, coverage and effective date.
• Automated the task to list the bookmarks added to all form fields in policy word documents using Excel/VBA.
• Provide acceptance criteria for QA on each story.
• Monitor the Kanban board for the story progress
• Perform unit testing of the application
• Work with business to perform UAT for each story in a release.
• Create bug in TFS for each issue reported during the UAT and debugged the issue to fix the application
• Analyzed the repository of s, policy documents and quotes using beyond compare tool.

Confidential, Baton Rouge, LA

SQL/Excel/Access/VBA Developer

Hardware/Software: SQL Server 2014/Excel 2010/Access 2016/Tableau

Responsibilities:

• Interact with business users to understand and document the current Wellness Activity and Annual Incentive Campaign process.
• Reviewed Access database tables, queries and forms used to create Data loads report and Annual Incentive Campaign reports
• Documented the business rules for each report.
• Identified redundant steps in the current report creation process in MS Access and recommend steps to automate the reports in SQL database
• Created SSIS package in SQL to automate import of data from source files, manipulate the data using queries and writing the data to excel for Cerner Upload
• Designed Wellness Activity reports in Tableau.

Confidential, NY City, NY

Excel/VBA Developer

Hardware/Software: Excel 2013/Access 2013/VBA/ SharePoint/ Jira Board

Responsibilities:

• Interact with actuaries, compliance and underwriter to gather the requirements.
• Documented the requirement in Jira software using Agile methodology
• Designed automated Asset and Private Equity Rater to build the policy to determine premium using Excel/VBA
• Used interpolation and extrapolation to calculate premium using excel formulas
• Designed automated Access database to import, compare and generate excel report listing different policies
• Automated excel upload to access table using input box to select file and sheet to upload
• Added the ability to calculate premium for both renewal and expiring policies
• Developed workbook events using class module
• Conduct daily standup with business community to report the status of the project
• Performed unit testing and UAT of the applications
• Worked with Compliance and underwriter.

Confidential, Boston, MA

Excel & SQL Developer

Hardware/Software: Excel2010/VBA

Responsibilities:

• Interact with business users to gather the requirements
• Designed utility to automate the import of cost sheets in different formats into Confidential report template
• Validate data import using VBA
• Automate data calculation using excel formulas, functions and procedures
• Designed configuration tab to map data fields between report template and various cost sheets
• Designed format macro to format cost sheets to facilitate smooth import

Confidential, NY City, NY

Financial Report Developer

Hardware/Software: Excel2010/Access 2010/ VBA

Responsibilities:

• Designed automated (FCC) Financial and coverage comparison reporting tool, excel based application used to create various coverages like worker compensation, auto, general liability and umbrella liability
• Creating coverage specific tabs on fly with data specific to the coverage copied from hidden sheets using VBA
• Automated the process of creating code event on fly for buttons in coverage specific tabs
• Automate process of dynamically populating limits of liability, deductibles and carrier using active x controls like labels, buttons and textboxes
• Automated the creation of client ready document by copying coverage specific tabs to new workbook using VBA
• Automate process of exporting client ready document to Access database.
• Modifying formulas and data validation drop down list using VBA
• Inserted hyperlink using shell command and VBA
• Designed high level FCC testing document
• Created properties and methods in Excel Class Modules

Confidential, NY City, NY

Excel VBA/Analyst/Developer

Hardware/Software: Excel2010/Access 2007/VBA, Soap UI 4.6.4, Toad for Oracle 9.7.2

Responsibilities:

• Analyzed financial data to identify input and output data points for min-scoring tool.
• Automated weekly rating report using MS Word/VBA
• Designed peer comparison application using VBA Dictionary to compare ratings of multiple entity using Excel/VBA
• Designed macro to create name range using styles in excel
• Create Excel login page to generate report using VBA
• Created Yield curve, excel web services application to get rate and yield curve on particular date for multiple currencies using Excel/VBA/Web services/Soap UI
• Designed Arrow Global reporting tool, Excel based application used to create automated reports using Excel/VBA/Toad
• Designed protection configuration macro to protect range of cells in workbook using VBA
• Designed menu item with multiple macro buttons in excel ribbon using Excel/VBA
• Created summary document by comparing 2 scoring tools using Inquire tool
• Designed Excel model for Multi-Family scoring tool to calculate final rating using excel VBA

Confidential, Hope, NJ

Application/Developer (VBA)

Hardware/Software: SharePoint 2010, Excel 2010/VBA

Responsibilities:

• Interact with users to gather requirement
• Build excel processor excel based application to filter data based on multiple criteria
• Create complex Excel user form to process excel file
• Create button to filter data based on text filters such as contains, do not contain, equal, not equal
• Automate the process of importing excel file
• Prepare tutorial for business users to give overview of the application
• Document the process for non technical users describing the functionality of the application

Confidential, NY City, NY

Office 2010 Developer/Project Coordinator

Hardware/Software: SharePoint, MS Access /Excel /VBA

Responsibilities:

• Interact with users to gather list of application inventory that needs to be tested and to collect information for software application packaging
• Work with point of contact on scheduling and tracking business application testing.
• Provide Windows 7/ Office 2010 Virtual Desktop Instance (VDI) via Citrix to users to test applications.
• Debug the VBA errors in MS Access/Excel user form caused due to migration from 2003 version to 2010.
• Designed SharePoint survey to get the feedback on Windows 7 migration
• Created Access user form used to generate automated daily and weekly migration schedule spreadsheet using VBA
• Designed Windows 7 dashboard on SharePoint with charts, tables and pivot tables to display migration status and progress.
• Designed Win7 FAQ site on SharePoint using SharePoint designer
• Maintain test lab environment of computers and VDIs.
• Manage inventory of applications, files and tools to be tested
• Provide weekly status on progress and challenges

Confidential, NY City, NY

MS Access/VBA/SQL/SharePoint Developer

Hardware/Software: SharePoint 2007/2010, SQL Server, MS Access 2007/Excel/VBA, MS Power Point, SharePoint Designer

Responsibilities:

• Interact with users to analyze requirements, provide IT work estimates, and work towards tight deadlines in an AGILE model
• Designed automated Sync process using Access/VBA to import project list from 80 SharePoint project sites into access table and updated GBT Project dashboard on SharePoint site with access data
• Conducted SharePoint for various business groups on functionality such as importing and exporting SharePoint list into and from access database, designing dashboard for consolidated data and creating different views of list.
• Created automated reporting tool such as GBT Projects Reporting tool for Fixed income products & Private banking group (PBG) Book of work using MS Access/Excel/VBA and provided a link on SharePoint site for user interface
• Expensively used SQL Stored procedures, joins, queries and functions to automate weekly project status reports.
• Customized SharePoint site by creating list views, filters, project documents, links and web parts
• Queried the data in business objects to schedule weekly excel extract.
• Extensively worked on MS Access SQL joins, queries, multi-value field and lookup field
• Prepared power point presentation for sync process describing individual functionality of application.
• Documented technical processes, design, requirements and user test plans.

VBA Developer

Hardware/Software: MS Excel 2007/VBA

Responsibilities:

• Interact with business users to gather requirements
• Automated the process of importing data from Access into Excel using VBA for creating management reports for various equity and derivatives portfolio
• Created reporting tool in Access by creating dynamic user form using Access/VBA
• Extensively used advance excel functions such as V look up, match using VBA
• Compact the current report processes which use to open 30 excel files to run queries to just one excel file using Excel/VBA
• Create Excel based custom detail reports for various portfolio on Confidential format based on high level reports.
• Provide in report for the data source by using advance excel formulas
• Create chart and graphs in reports

Confidential, Bensalem, PA

VBA/Access/Excel developer

Hardware/Software: MS Excel 2007/VBA, MS Access 2007, PLM software

Responsibilities:

• Created open file dialog box to import multiple Excel file and 1 excel file at a time into access from shared folder
• Created excel user form to pull data from access based on several filter criteria such as Department, super department & class id
• Extensively used functions such as look up, choose, & index in Access and Excel using VBA
• Maintained access database using SQL queries & joins, tables, forms and reports
• Extensively used dynamic name ranges in excel and created multiple drop down for various apparel attributes such as color, fabric, print, pattern, etc.
• Provided weekly status report to project manager to ensure weekly milestones are met
• Prepared test scenarios and test cases to ensure application delivers required functionality
• Performed unit testing and UAT of Assortment form application
• Documented the whole application and access database describing each functionality of the application

Confidential, Princeton, NJ

Excel/Access VBA Developer

Hardware/Software: MS Excel 2003/VBA, MS Access 2003, SQL server 2005, Oracle Siebel 8.0

Responsibilities:

• Interacted with business users to gather requirements
• Designed Dashboard, a front end Excel/user form based application which connects to back end Access database using Excel/VBA
• Created custom tool bar in Dashboard to automatically import data such as Budget & time allocation, field trainer list, categories, reason codes, etc into Excel from Access database.
• Created user-interface for capturing manually entered data
• Filtered/sorted data based on column entries using Excel/VBA
• Created dynamic charts such as Needle chart, Pie chart & Bar chart displaying vital data such as Time allocation and Budget spending through VBA
• Automated the printing process of excel reports such as performance matrix report and Budget spending report on monthly and YTD(Year to Day) basis and sending them as an email attachments using Excel/VBA macro.
• Performed the unit testing of Dashboard application and debugged the errors encountered
• Prepared the test cases of Dashboard application for the User Acceptance Testing
• Performed UAT testing of Dashboard application with business users
• Prepared User manual of dashboard creation for non-technical users and provided user guide explaining different functionality of the dashboard.
• Built user guide for technical users providing vital information to create new users for the Dashboard application, to load data necessary to update Dashboard and logical diagram of flow of data from flat files to Dashboard.

Confidential

MS-ACCESS/MS-EXCEL Developer

Hardware/Software: MS-ACCESS 1997, MS-EXCEL 2000

Responsibilities:

• Obtained initial requirements from business analyst and corresponded with them throughout conversion.
• Created MS Access database using tables and forms.
• Designed a front-end access to reports, queries and forms
• Created Front End Screens with data validations Using Access VBA
• Imported data into Excel from Access for creating pivot tables and Charts.
• Conducted financial ratios analysis and reporting using Excel/VBA
• Defined the various naming standards.
• Developed prototypes and managed changes based on feedback.
• Worked with Add Ins features into Excel Sheets with XLA technology.
• Generated weekly sales report in excel spreadsheets using Excel/VBA.