Professional Summary:

• Over 7+ years of experience in IT industry in various domains like Retail, Financial, Insurance and Health Care.
• Extensive experience in interacting with business users and executives to identify information needs, gather Requirements, and authoring Business Requirement Documents.
• Experience of SDLC, Waterfall, Agile and RUP methodology and project life cycle.
• Experience in design, analysis, testing and production support.
• Strong in Design and Development of user friendly applications in Excel and Access.
• Designed and created a Microsoft Access database for storage and retrieval of sensor data.
• Analyzing functional business applications and design specifications for functional activities.
• Proven background translating cell formulas in Excel into VBA code.
• Extensive experience implementing user interface based on client needs.
• Designed block diagrams & logic flowcharts and translate detailed designs into application.
• Use Rapid Application Development (RAD) Programming techniques to develop and execute applications and manage end-to-end tactical solutions to meet business challenges.
• Extensively worked on Visual Basic 6.0, SQL Server 2005, 2008.
• Expertise in T-SQL (DDL, DML), Complex Queries , Tables , Views , Stored Procedures , Indexes , Cursors , User Defined Functions and Triggers.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access, Oracle to MS SQL Server by using BCP utility and DTS/SSIS services.
• Developed and performed test/debug functions.
• Extensive experience in creating custom interactive reports for Executives and senior planners.
• Developed reports using Crystal reports and Excel Reports.
• Prepared program-level and user-level documentation.
• Expertise in defining scope of projects based on gathered Business Requirements including Documentation of constraints, assumptions, business impacts, Project risks & scope exclusions.
• Experience with Flow charts, Use Case Diagrams, Sequence diagrams, Activity diagrams, Mockup pages and Use Cases.
• Experience in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Possess excellent MS Access, Power Point and SQL query writing ability, Excel & VBA skills.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• Expertise in Verbal and Written Communication. Excellent analytical & problem solving skills.

Technical Skills:

Languages/IDEs: C, C++, C#, T-SQL, Visual Basic 6.0

Operating Systems: Windows Server 2008/2003/2000 , Windows NT 4.0, Windows 7/Vista/XP/98.

SQL Server Tools: MS SQL Server 2008, 2005, Management Studio, Business Intelligence Development Studio, DDL, DML, Stored Procedures, UDF, Triggers, SSIS, SSAS, SSRS.

Data Modeling: MS Visio 2007/2003.

Web Technologies: HTML, DHTML and XML.

Reporting Tools: MS Excel, MS Access, SQL Server 2008/2005 Reporting Services, Crystal Reports.

Office Suite / Tools: MS Office 2007

Professional Experience:

Confidential, NJ

BA /VBA Developer (Planning/Forecasting)

Responsibilities:

• Played a dynamic role during the requirements gathering, analyzing, planning, designing and development of Business Applications.
• Developed planning strategy for Departments and Stores which includes determining group rankings, sales forecasting method, and historical planning basis to produce accurate sales plans.
• Monitor the Departments and Stores sales performance against plan to identify trends and store plans that need to be revised and forecasted.
• Active participant in the planning process with the Head of Planning and Buyers by providing historical data and analysis to verify the plans are consistent with the store's sales potential and meet the inventory receipt requirements.
• Assist to monitor Key performance items and inventory levels by climate/region/district/store and make necessary adjustments to the plans and allocations going forward to maintain proper inventory balance.
• Independently developed applications and custom interactive reports in MS Access, Excel using VBA.
• Translated business rules & logic into VBA.
• Developed macros for tracking users.
• Developed macros to fetch data from different data sources.
• Developed VB application to import data into Access from Excel files & other data sources.
• Developed and performed test/debug functions.
• Used several types of data sources for connecting to different databases and files.
• Calculate OTB at a weekly, Monthly and Seasonal level based on Sales, Markdowns, on order and Inventory.
• Key Role in designing the Report Templates according to the requirements in efficient and user friendly approach.
• Developed and generated Daily, Weekly, Monthly, Quarterly and Yearly Planning and Forecasting Reports with the help of Excel Macros.
• Used Microsoft Excel to extract data from the complex cube structure (SSAS) in the form of Pivot Tables.
• Used Microsoft ProClarity for ad-hoc reporting.
• Used SQL Statement to query data when needed.
• Analyzed and wrote complex formulas in Microsoft Excel 2007.

Environment: MS SQL Server 2008/2005, SSAS, MS Excel 2007, VB Script, MS ProClarity (SPIN Database).

Confidential, Nashville, TN

BI Analyst/ Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Developed VB application to export data from SQL Server to Access.
• Developed front end forms for data automation in Access.
• Extensively used Excel functions in development
• Designed and created a Microsoft Access database for storage and retrieval of sensor data.
• Migrated Ms Access database to SQL Server database.
• Uploaded excel data sheets to MS Access and SQL Server.
• Designed and coded a Visual Basic ActiveX DLL which served as a interface.
• Involved in Model View Control (MVC) design pattern.
• Designed block diagrams & logic flowcharts and translate detailed designs into application.
• Developed VB application to download data from MS SQL to Excel.
• Enhanced an existing applications consisting of several VB programs and Access.
• Connected databases through ODBC for Micro strategy reports.
• Developed several VB programs to get pricing data from an external vendor.
• Designed and implemented a system to provide automation for pricing.
• Developed multiple input/output worksheets throughout the model.
• Analyzed, re-design user interface and program logic.
• Prepared documentation demonstrating the correct implementation of various financial and mathematical formulas in the new application.
• Developed and performed test/debug functions

Environment: MS SQL Server 2008, Windows, Access, Excel, VB Script

Confidential, Washington, DC

MS Access/Excel VBA Developer

Responsibilities:

• Designed Dashboard in excel for managing macro’s.
• Designed Master form in Access.
• Analyzing functional business applications and design specifications for functional activities.
• Created relationship between tables.
• Developed data base queries to fetch data from Access.
• Developed VB application to import data into Access from Excel files.
• Developed front end forms for data automation in Access.
• Developed Excel formulas in VB script (including “Sum if”) for Accounting purpose and conditional calculations.
• Developed Excel formulas in VB script (including “VLOOKUP”) for extracting data from external Excel files.
• Developed and performed test/debug functions.
• Developed VB application to manage and maintain file size.
• Designed block diagrams & logic flowcharts and translate detailed designs into application.
• Implemented conditional formatting in Excel.
• Developed VB application to export data from SQL Server to Access.
• Created tables, Views, Forms and Reports in Access.
• Created templates in Excel and Access for frequently created tables and tabs.
• Used several types of data sources for connecting to different databases and files.
• Developed Access reports.
• Prepared program-level and user-level documentation.

Environment: Windows, Access, Excel, VB Script, MS SQL Server

Confidential, Richmond, Virginia

BA/VBA Developer

Responsibilities:

• Involved in Business Analysis & Requirement collection.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Prioritized the requirements gathered from financial specialists, business users, domain experts through interviews, JAD sessions.
• Developed VB application program to export data from MYSQL to Access and excel.
• Developed VB application program to import data from excel to MYSQL.
• Designed and implemented VB application to extract data from multiple data source.
• Designed and developed user interfaces according to client requirements.
• Designed and created Excel spreadsheets to provide an attractive and functional user interface for the sales data.
• Developed Access forms for atomizing administration process.
• Created multiple access reports for administration purpose.
• Worked closely with administration department to determine the requirements and specifications.
• Enhanced an existing applications consisting of several VB programs and Access.
• Connected databases through ODBC for Micro strategy reports.
• Developed several VB programs to get pricing data from an external vendor and integrate this data into the existing databases.
• Documenting the development work.

Environment: Windows, Access, Excel, VBA, MY SQL.

Confidential

VBA Developer

Responsibilities:

• Developed com components for VB application.
• Analyzing functional business applications and design specifications for functional activities.
• Developed and performed test/debug functions
• Developed Crystal reports and Data reports for various applications.
• Designed and implemented comprehensive Backup plan for Databases.
• Performed testing, distribution, documentation, and training on final application.
• Visual Basic in code was used for massive updating of records
• Developed User Interface using VB Script.
• Developed COM components in VB to implement business rules and data access objects.
• Developed database schema scripts, stored procedures and triggers.
• Involved in Model View Control (MVC) design pattern.
• Designed forms and reports in Oracle developer 2000.

Environment: Windows, SQL Server, Access and VB, Crystal Reports, Data Reports.