PROFESSIONAL SUMMARY:

• Over 7 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, Agile and RUP methodologies.
• Advanced SharePoint skills - creating & designing web parts, views, reports, surveys, workflows and interfaces with multiple MS Access databases over network infrastructure.
• Highly proficient in Access/excel/SQL data extraction, transformation and loading using ODBC, ADO, DAO, Transfer spreadsheet method and Transfer database method.
• Highly experienced in financial market & Sound knowledge of financial market instruments: Equities, Fixed Income Securities, Derivative Instruments, Options, Futures, Commodities products such as crude & Gold
• 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.
• Highly experienced in SQL queries, joins and store procedures.
• High level of expertise in advance Excel features like pivot tables, charts, functions, scenarios.
• Experienced in evaluating and modifying tables, queries, and reports.
• Adept with Financial Modeling including Black-Scholes, Black-Scholes-Merton (BSM), Commodity, Portfolio Optimization, VaR, Binomial Tree models.
• Developed and implemented reports against SQL Server, Access, Store procedures and MS Excel.
• Strong front-office development exposure that fosters ability to bridge between trading desk and technology groups in order to ensure technology solutions meet business objectives.
• Highly motivated and conceptually strong with outstanding oral and written communication skills and ability to work independently as well as in a team.

TECHNICAL SKILLS

Skillset: MS Access 1997/2003/2007, MS Excel 2003/2007, SQL Server 2000/2005/2008, SharePoint 2007/2010, SharePoint designer, Business Objects, C# VSTO, .NET Framework, VBScript, Oracle 9i/10g, ADO, DAO, MS Visio 2003/2007, XML 1.1, HTML, Bloomberg API

PROFESSIONAL EXPERIENCE

Confidential, NY City, NY

Developer/Project Coordinator

Hardware/Software: SharePoint 2003, MS Access 2003-2010/Excel 2003-2010/VBA

Responsibilities:

• Interact with users to gather list of application inventory that needs to be tested.
• Work with point of contact on scheduling and tracking business application testing.
• Provide Windows 7/ Office 2010 Virtual Desktop Instance (VDI) 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, SharePoint Designer, C# .NET

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
• 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.
• Developed master list on SharePoint site using C#.NET SPSiteDataQuery Class method which will query across multiple list in multiple SharePoint sites.
• Performed complex data analysis, including data mappings, data feeds and data modeling for various data source to build automated reporting tools
• Customized SharePoint site by creating list views, filters, project documents, links and web parts
• Extensively used SharePoint designer to add multiple list across multiple sub SharePoint sites and designed dynamic workflow based on multiple conditions and actions.
• Highly proficient as SharePoint 2010/2007 admin skills such as Managing permissions, creating sites and documents library, moving or copying documents across multiple SharePoint site.
• 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
• Documented technical processes, design, requirements and user test plans.

Confidential, NY City, NY

VBA Developer

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

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 reference 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 Excel/Access VBA Developer

Hardware/Software: MS Excel 2007/VB-6.0, MS Access 2007, SQL Server 2008, Oracle 10g, Bloomberg

Responsibilities:

• Interacted with risk manager and the traders in front office for developing the required application.
• Designed user form to calculate various financial calculations such as NPV, variance and standard deviation for various equity and derivatives portfolio using .NET and VSTO.
• Designed and developed several Excel/VBA automation solutions such as loan amortization, investment growth & retirement planning
• Designed the model based on Variance-Covariance for calculating VaR of the portfolios. The model consists of Excel spreadsheets, which generate daily VaR reports for all trades and open positions.
• Designed and developed models for the calculation of VaR (Value at Risk) based on the 95% and 99% confidence interval level using Excel VBA.
• Created an add-in to implement custom functionality in Excel using VBA, the add-in file performed a Monte Carlo simulation of possible investment outcomes.
• Conducted profitability analysis/reporting through complex calculations in Excel & VBA
• Worked with stored procedure in MS SQL server.
• Imported data into Excel from MS Acces and SQL Server using SQL queries and stored procedure in VBA.
• Extensively used pivot tables and charts in reports.
• Performed stress testing of the portfolio and back testing of VaR.
• Performed the unit testing of application to check the quality assurance of the output and its functionality.
• Created various test case scenario to test application
• Performed User Acceptance Testing (UAT) with business users
• Generated reports on Excel spreadsheets for various portfolios types such as Equity &derivatives portfolio, commodities portfolio & created Excel VBA macro to automate the procedure.
• Documented the Excel VBA Models with applications and also provided user guide which described functionality of the applications.

Confidential, MN

MS-Access/MS-EXCEL VBA Developer

Hardware/Software: MS Excel 2003, MS Access 2003, Bloomberg API, SQL Server 2000

Responsibilities

• Developed and calculated asset allocation strategies to meet risk and return objectives for client’s Fixed Income portfolios
• Developed pricing module for fixed income products using Excel and VBA.
• Developed Excel/VBA based financial programs utilizing Bloomberg API to monitor market volatility, key rate duration and to calculate VAR of the portfolios
• Created spread sheets for reconciliation of fixed income and derivative products.
• Created user defined functions, add-ins, menu bars, forms and user friendly interfaces that support various P&L reports and daily tasks.
• Produced daily risk report encompassing VAR assessment, scenario analysis and stress testing using Excel and VBA.
• Generated Daily/Monthly/Quarterly reporting and asset valuations.
• Converted Excel file data from multiple sources to Access tables.
• Converted MS Access database to SQL server and worked with SQL statements and tables.

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.