SUMMARY:

• 18 years of experience in Design, Analysis and Development of Software applications in client/server environment using Excel Macros, Visual Basic.NET, Crystal Report s, Oracle, XML, Unix, Access and Excel 2010 VBA, Business objects Web Intelligence
• Strong Managerial skills in planning and delivering projects and in effectively leading and monitoring people.
• Strong Background in Pharmacy, Manufacturing, and Finance Industry (Banking, Stock Brokerage etc.) with Fixed Income and Credit Derivatives
• Extensive experience in Manual, Automated and Load testing of integrated applications.
• Good Experience in Excel Add Ins (XLA) technology
• Strong Expertise in Writing Complex Access, Excel and Access Macros with Excel VBA with Different Business Environments. Analyzing complex Business Requirements and developing technical applications in both Client Server and Object Oriented Environments.
• Strong Expertise in writing Complicated PL/SQL procedures and triggers in Oracle for Financial Applications

COMPUTER SKILLS

Languages: C, SQL, Java, Unix Shell Scripting, PL/SQL, ERWIN 7

Web Design Tools: HTML, DHTML, ASP, VB Script, JavaScript, XML, XSLT

Operating Systems: UNIX (Sun Solaris), HP UX, WINDOWS 2000 / NT

RDBMS ORACLE 10g/11g: , MS SQL Server 7.0, MS - Access2010, SYBASE 11.0, DB2, TOAD

GUI Visual Basic 6.0 / .NET: , Developer 2000 (Forms 5 Reports 3), VBA with Excel and Access Macros 2013, MS-Word Macros, Excel XLA, /.NET

Reporting Tools Crystal Reports XI: , Oracle Reports 9, Crystal Info, Web Intelligence 11Transformation Tools SQL* Loader, Microsoft Data Transformation Services (DTS), Microsoft OLAP Services, ERWIN 7, Informatica Power Center

PROFESSIONAL EXPERIENCE:

Lead Data Analyst / Project Management Analyst

Confidential, VA

Responsibilities:

• Generated front end forms in Excel VBA for calculation of NPV and IRR for mutually exclusive projects.
• Assisted upper management by providing OLAP and hierarchical drill down reports using Excel VBA.
• Generated GANNT chart reports for project management using complex Excel Charting techniques.
• Generated high end MS Access database systems which updates the project SLAs and RFPs.
• Provided and MS Excel application which calculates the Return over investment and payback period for various projects.
• Generated complex dashboards using Excel VBA for forecasting of various project budgets.
• Exported multiple Excel reports to Business objects environment using Live Office and Excel VBA
• Imported complex financial data from HTML pages and XML files and provided weekly Excel charts.
• Generated drill down reports for region wise and data wise data using Excel VBA and macros
• Provided Oracle PL/SQL scripts for generating complex packages and procedures for budget calculations.
• Generated Dashboards using Xcelsius and Excel VBA for What if analysis for upper management
• Distributed various report bursting data using Complex Web Intelligence reports for various regions.
• Assisted upper management in creation of project charter and financial ratios statement.
• Coordinated with various functional and project managers for integration of various projects with PMO.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements. Ensured cGMP and compliance requirements (Title 21 CFR Part 11) were met.
• Developed use case with UML for new product functionality. Updated SOPs and WIs.
• Documented Software System Requirements (SSR) and BPR for SAP R/3 4.7 and BW teams.
• Updated System Change Request (SCR) forms for Product Data Management (PDM).
• Traced test cases and functional specifications to SSRs and BPRs using DOORS.
• Applied change requests, versions, and addendum .
• Drove impressive improvements across the business as a result of IT implementations. Equipped ABC with solutions that accelerated the bidding process on architectural projects by 45%, shortened the sales cycle by 50%, increased cash collections by 35% and saved $1.2M annually.

Environment: Visual Basic 6.0, VBA with MS-Access 2013, VBA with MS-Excel 2013, Sharepoint 2010MS Excel VBA, MS Access 2013 VBA, Business Objects XI V.4.0, Informatica 9

Senior Data Analyst / Business Analyst

Confidential, Herndon, VA

Responsibilities:

• Generated Dashboards for Human Resource reporting using Excel VBA for monthly reports.
• Synchronized Excel reports with SharePoint 2010 using Excel VBA for wider corporate access.
• Involved in various Systems requirement gathering and JAD sessions with the end users.
• Generated pilot application of the Confidential Intake application in MS Access and updated project charter.
• Generated initial user acceptance testing (UAT ) scripts and involved in Integration testing.
• Generated front end GUI in MS Access for the intake of the Corporate Human resource data.
• Generated initial pilot plan Human resource budget reports in Business Objects XI.
• Converted Excel file data from multiple sources to XML data using XSLT and Excel macros.
• Created MS Access and Excel Front end to load local data into XML using MS Excel macros
• Generated Switchboard forms using MS Excel VBA for fetch remote Oracle data.
• Created Database triggers in Oracle for preventing any loss of financial data.
• Created Functions and Packages in Oracle to import large Financial data from Excel and Access
• Generated Macros in Access, Excel build Complex Web Intelligence reports.
• Participated in the Business Analysis and Business Process Reengineering of the entire System and recommended various enhancements with Business Objects and ETL Tools.
• Responsible for building and demonstrating a proof-of-concept and Project Charter for the Business stakeholders.
• Involved in the Costing, budgeting and Time management techniques of the Operations by coordination with the key stake holders and the Project managers.
• Involved in Business Analysis of the entire business systems and produced Visio Process flows.
• Generated Used cases and Process flows for the entire business process and created sample test cases.
• Produced Business Analysis Documentation for Risk Analysis of Sales and marketing data integration.
• Involved with the interviews and business analysis with the customers, key stake holders and the project sponsors of the applications for determining the project scope.
• Involved in the process flow diagrams, data flow diagrams and the generated hierarchical and drill down data analysis.
• Performed systems analysis for Activity costing and Activity scheduling and routing using MS Project 2007.

Environment: Visual Basic 6.0, VBA with MS-Access 2010, VBA with MS-Excel 2010, Sharepoint 2010MS Excel VBA, MS Access 2010 VBA, Business Objects XI V.4.0

Lead Data Analyst/ Excel VBA Developer

Confidential, McLean, VA

Responsibilities:

• Generated Servicer and Daily and Ad Hoc reports in Excel 2010 Reports.
• Enhanced the SPARTA tool by bulding various Review Screens and Remedy Screens in Access 2010.
• Provided daily backup of the SPARTA production data and automated the process with VBA
• Provided Application Support for the SPARTA tool and participated in Trouble Shooting sessions.
• Generated Management, Foreclosure and Remedy Reports in Excel 2010 with VBA Coding.
• Involved in the Business Analysis and Used cases generation for the various Confidential Business processes.
• Involved in Documentation of the entire process and provided Technical and Business process documentation.
• Generated front end GUI for entering Branding Form Lender details using Visual Basic and Access XP GUI
• Created COM components and ActiveX controls in Visual Basic for Complex mortgage calculations and Branding Form Fixed Income Derivatives.
• Created ActiveX DLLS in MS Access / Excel Macros for loading data for Branding forms.
• Created weekly Admin Web Intelligence reports and Pivot tables using Excel Macros and VBA
• Generated Macros in Excel, Access VBA to automatically email large PAOTW data to lenders.
• Generated Excel and Access Macros merge excel data with MS Excel and validate lender errors.
• Loaded excel reports on to web and Web Intelligence using Excel XLA and Excel Add Ins with VB.NET
• Generated ActiveX components in Excel to migrate data into Oracle using Excel VBA.
• Converted Home Loan Excel reports into Excel Pivot tables and Excel Spark line reports. .
• Created Database Procedures in Oracle to calculate date wise Home Loan interest calculations.
• Generated Process Flow Diagrams for Confidential workflow at various levels using Visio 2010
• Generated Complex Use cases in MS Visio as a part of Business Analysis and Process Modeling
• As a Business Analyst, supported ad hoc data requests and ongoing requests for data from workstreams and business partners
• Involved in data analysis of tax applications and coordinated with the Project Integration team for implementation.
• Customized Bloomberg systems to suit the company’s business needs and requirements.
• Created Financial Accounting Documentation for Confidential DFO using MS Visio and MS project
• Developed Scheduling and Routing requests of the project milestones in Gantt Charts in MS Project
• Created the Project Charter of the entire application to depict the scope and functionality of the project.
• Lead the delivery of business and functional requirements on complex initiatives and projects
• Used Win runner and Load runner to perform Integration testing and Functional testing of the application
• Involved in business analysis of various test cases in Black box testing with the Test managers with ILog
• Allocated the resources to the project at various stages by calculating the routing, staffing and critical path

Environment: Visual Basic 6.0, VBA with MS-Access 2010, VBA with MS-Excel 2010, SQL Server 2008MS Excel VBA, MS Access VBA, Visio 2010, Oracle 11g

Senior Data Analyst

Confidential, Rockville, MD

Responsibilities:

• Generated complex procedures in Oracle PL/SQL to transfer sales data remote schemas to central schema.
• Generated triggers in Oracle PL/SQL to maintain database security and fire automatic transactions after daily record insertions.
• Extracted sales data into Oracle from flat files through Informatica mappings.
• Scheduled complex jobs on daily/ weekly basis to load patient data into Oracle database using Informatica workflows.
• Created complex front end design in VB.Net to process and clean patient addresses in databases.
• Generated GUI in VB.Net to get the input transactions of various sales applications like Salesforce.com, QAS etc and populated summarized data into database.
• Generated complex drill down hierarchical reports and cross tab sales reports in Business objects WebI and Crystal reports.
• Administered complex Business objects reports and Crystal reports in Infoview with Administer access and granted various privileges to the users.
• Generated complex Excel macros to link multiple Excel sheets to Oracle and generate HTML reports.
• Processed Business Objects WebI and Xcelsius Chart reports to display pie chart percentage distribution.
• FTPed Unix data into Windows servers with Excel VBA and extracted flat file data into Oracle with Excel macros.
• Generated Complex Pivot reports for displaying drill down data with Business Objects WebI and Microsoft Excel.
• Linked Excel report to Xcelsius and generated complex graphical and pie chart reports.
• Generated Graphical Reports and Sub reports in Crystal reports and linked with XML data
• Generated API calls using Excel 2010 VBA and Excel macros for linking remote pharmaceutical data across various servers
• Generated OLAP reports and pivot table Excel 2010 reports to represent region wise sales reports in hierarchical manner.
• Generated Graphical reports / Scatter diagrams bubble charts in Excel 2010 to display EIS reports
• Developed use cases, workflow, screen mock-ups, and conversion requirements.
• Conducted risk engineering to derive and execute action plans on time.
• Interfaced with SMEs to prepare BPR documents for ongoing projects.
• Prioritized business and systems problems; analyzed legislation and conducted impact analysis.
• Prepared business process models; used Visio to create use case diagrams.
• Liaised with Business Analysts in Tennessee, Florida, and Houston to create data maps.
• Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
• Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
• Gathered requirements during inception phase, documented and delivered functional specification documents,

Environment: Visual Basic 6.0/.NET, Crystal Reports 11, Oracle 11g, Informatica 9.x, Business Objects XI, Xcelsius 2008, VBA with MS-Excel 2010/2007, Unix, Business Objects Infoview.

Senior Data Analyst/ VBA Lead

Confidential, Washington, DC

Responsibilities:

• Written Excel and Access Macros and generated Excel reports for Tax related MIS queries.
• Used Active-x controls for automation of Excel reports to report Bloomberg Market data.
• Managed Pivot tables in Excel and developed Web Intelligence reports in summarizing Market Test data.
• Transferred huge complex data from XML to Oracle, SQL Server through Oracle PL/SQL procedures.
• Created Functions and PL/SQL Packages in Oracle to import large Financial data from Excel and XML
• Extensively used Excel and Access Macros and VBA with Excel Forms and Excel Charts.
• Written Triggers for Excel charts for automation of Excel Summarized reports.
• Generated Switch board forms and built front end in Access 2003.
• Included Add Ins features into Excel Screens and Excel sheets with XLA technology.
• Included security and password features into excel reports using XLA features.
• Generated procedures and packages in Oracle to load complex Financial data into excel files.
• Converted Dynamic continuous Bloomberg Market feed data into Excel and Access data with XLA technology and Add ins technology.
• Generated Complex Excel reports which were integrated with Business objects and Web.
• Created linked tables in MS Access and also modules for front end Application.
• Generated monthly reports through Excel VBA and used Access VBA in initial report data modeling.
• Transferred Excel data into Crystal reports using Excel Macros.
• Generated Web Intelligence reports from the daily Excel and XML 1065 Tax data.
• Involved in automatic and Regression testing of Excel reports with Win Runner.
• Built complex Web intelligence reports for depicting dynamic Tax related data on a daily basis.
• Generated Test scripts using Mercury tools and Excel Macros which can be used for System integration tests of Excel COM Components.
• Involved in complex Business Analysis and process modeling of Mission critical applications using MS Visio .
• Involved in Business Analysis Documentation and and knowledge transfer to business users through proto type designs
• During Business Analysis, created Complex process flows of Accounting and Financial transactions of FAS -52 in Microsoft Visio.
• Performed Statistical analysis and also performed NPV, IRR, and FV calculations for project budgeting analysis.
• Initiated mentoring and technical coaching of the project staff as a part of improving human resources.
• Conducted gap analyses of the entire business system and provided the necessary documentation with potential risks, issues and errors.
• Performed PERT/ CPM techniques for planning costs, scheduling manpower and activity times and submitted the necessary calculations.
• Performed Six Sigma Techniques for providing the quality control of the Project Activities and standard deviation calculations of Process times.
• Created OLAP based tools and Pivot tables in MS Excel for the financial business analysis and dimension cubes and generated process charts in MS Project
• Involved in the User and documentation of Business models using MS Project and MS Word
• Generated Used cases of the various stages of the SDLC and generated the process flow in MS Visio

Environment: Visual Basic .NET, MS Excel 2007 VBA, HTML, SQL Server 2000, Oracle 9i, MS-Excel macros, MS- Access 2003, XLA, Business Objects Web Intelligence 11, HTML, ASP 3.0

Lead Visual Basic/ Excel VBA Programmer

Confidential, Washington, DC

Responsibilities:

• Created Front end screens with user validations in Visual Basic, Excel.
• Generated Loan related weekly Excel sheets reports to front end using Visual Basic.
• Generated Excel and Access Macros for the automation of Donor related Reports.
• Worked on Pivot tables for the summarized reports of Excel and Access data.
• Normalized the pharmaceutical data into different normalized forms using ERWIN and generated tables, views, synonyms and sequences in Oracle, Access.
• Generated Automatic graphical financial reports using Excel Graphics and VBA.
• Linked graphical objects and templates to excel and Access reports using XLA technology.
• Automatically connected excel sheets to multiple data sources with XLA technology.
• Created Oracle PL/SQL Procedures and triggers for automation of backend transactions.
• Created ActiveX Controls for the linking of excel and Access reports to Visual Basic.
• Created COM components in Excel VBA front end for linked tables and faster retrieval of data.
• Created MS Access and Excel Front end to load local data into XML using MS Excel macros.
• Generated Unix shell scripts to load data from flat files to Oracle and Access database.
• Helped in Transportation of large amount of data from Excel flat files into Oracle database tables using SQL*Loader and Unix Shell Scripts.

Environment: Visual Basic 6.0/.NET, Oracle 9i, VBA with MS-Excel 2003 and XP, XLA, VBA with MS- Access 2000, ERWIN, Unix HP-UX, Crystal Reports 10

Sr. Excel VBA/Macros Developer

Confidential, CA

Responsibilities:

• Automated Weekly Costing reports using Excel, Access Macros and API calls.
• Converted a lot of corporate reports into Excel graphical charts and reports with Excel and Access VBA
• Used Active-x controls in VB.NET, Excel XP for automation of excel reports.
• Created COM components and User Controls in VB.NET, to link remote Excel data to Oracle database and Unix flat files
• Linked Oracle Data to Excel sheets and shown as linked reports using Access and Excel VBA for Fixed income calculations.
• Worked on Pivot tables for the summarized reports of Excel data with Excel Macros.
• Linked the Excel and Access Reports to the web for the global access of the data.
• Generated bar graphs and Pie diagrams in Excel sheets for providing weekly shipping status to management. This was done though excel and Access macros.
• Generated Automatic graphical shipping reports using Excel and Access Graphics and Access VBA,
• Linked Excel reports to web using Excel VBA and Excel Add Ins and Unix Shell scripts.
• Generated Master detail reports using Crystal reports from Access Excel for transport data.
• Automated various statistical, graphical and mathematical functions through MS-excel.
• Used ActiveX Controls for the linking of Excel and Access reports to Visual Basic.
• Generated Unix shell scripts to FTP data to UNIX from Excel.
• Generated Graphical Bar charts in Excel and Access reports with Excel VBA and Add Ins.
• Created Database triggers in Oracle to enhance security requirements.

Environment: Visual Basic 6.0/.NET, VBA with MS-Excel 2002 and XP, VBA with MS-Access 2000, Crystal reports 9, Unix Shell Scripting, Oracle 9i

Lead Developer

Confidential, Cincinnati OH

Responsibilities:

• Created Front end screens with user validations in Visual Basic
• Used ActiveX Controls for the linking of excel reports to Visual Basic, Excel Macros
• Generated Excel Macros for the automation of Excel Reports
• Worked on Pivot tables for the summarized reports of Excel data
• Loaded data into excel using Oracle database with Excel VBA and Unix
• Generated MS Access Reports for Actonel drug based on prescriptions, Physicians and patients and linked to Excel with Excel VBA.
• Created Normalized tables in Ms-Access and Oracle and FTP ed data with Excel VBA
• Linked the Excel Reports to the web for the global access of the data.
• Generated sub reports, mail matrix reports and master detail reports in Crystal reports
• Linked reports to web using Crystal enterprise and Crystal reports
• Created a repository of Excel reports paths with XLA technology and Unix
• Included Add In features into the excel sheets with XLA technology
• Used certain FTP tools for transport of excel through different Unix sources
• Generated Graphical bar charts and other reports in Excel and Access
• Loaded data into Excel sheets from multiple remote sources and provided cumulative data
• Created Access Macros for automatic updations of linked tables

Environment: Visual Basic 6.0, Oracle 8.0, VBA with MS-Excel 2000, VBA with MS- Access 2000, MS-Access Reports, Unix HP-UX, Crystal Reports, XLA