SUMMARY:

• 13+ years of experience in Information technologies with emphasis on Finance domain.
• Experienced in Requirement Analysis, Design, Development and Testing.
• Expertise in Programming, Database querying, Reporting and Automation.
• Ability to handle multiple assignments, and a quick learner.

COMPUTER SKILLS:

Programming Languages: Python, R Prog, VB 6.0, MS Office, Word VBA, Excel VBA, Outlook VBA, Access VBA, Lotus 123, VC++ 6.0, Java, HTML, CSS, SQL/PL - SQL, XML

Reporting & Scripting: Tableau 10.4, JavaScript, VBScript, Crystal Reports XI, UNIX Shell ScriptingRDBMS ORACLE, SQL Server 2008, MS Access

Financial Applications: ORACLE Financials 11i, Lawson Financials

Tools: KNIME, Developer 2000, Toad, Visual SourceSafe 6.0, Oracle ADI, ServiceNow

Technologies: ASP, ADO, DOM, BOM, LAN, .NET, ODBC

Software Engineering: Requirement analysis, Design, Coding, Testing, Data analysis and Reporting, ETL, Automation, QA

WORK EXPERIENCE:

Business Systems Analyst

Confidential, California

Responsibilities:

• Worked with global team, supporting a team of approx. ‘10’ PMs/Director with business analysis, data analysis and metrics collection, metrics reporting, metric analysis, and report automation using Tableau and Excel VBA, connecting to various data sources and databases, including global/local filtering, parameter passing, and charting features.
• Proficient with SQL coding.
• Created dashboards for team updates, status tracking, quarterly status reporting, and decision making.
• Interacted with internal teams to collect data and project status.
• Reporting included Data Analysis and Excel based automation, Pivot tables, VLookups, Charts, Graphs, formulas, VBA coding, connectivity with external data sources, conditional formatting, and data consolidation.
• Created interactive Tableau dashboards and Spreadsheets.
• Created dynamic PowerPoint dashboards connecting to excel templates.
• Monitored, analyzed and reviewed data/reports for data quality, accuracy; resolved and fixed data issues.
• Periodically updated metrics on internal reporting systems.
• Extracting and reporting on headcount and budget data from Essbase.
• Extract purchase orders from Teradata for account reconciliation purposes, automate reporting in Tableau.
• Gathered metrics, provided trend analysis for DCPS/CIO reviews.
• Automated reporting for remedy case trend analysis in MS Excel, saving significant amount of time and manpower. Provided assistance to storage team on remedy case reduction analysis.
• Automated VM Utilization reporting (CiRBA) in MS-Excel for GIS/IT Service interlock meetings (client engagement meetings) on a quarterly basis. Saved time and manpower.
• Migrated Excel based reports to Tableau dashboards.
• Worked both in structured and unstructured environments.

Environment: Tableau, Oracle, SQL Server, MySQL, Teradata, MS Excel 2010 Formulas/Templates, PowerPoint 2010, Hyperion Essbase, MS Access and SAP Business Objects, Smartsheets, CSV files, ServiceNow

Business Systems Analyst

Confidential, California

Responsibilities:

• Quarterly incentive compensation processing, validation, analysis. Distribution of incentive compensation reports and quarterly bonus payments.
• Consolidated huge amounts of data into templates for data input. Check for data integrity, data cleansing, data issues, missing data.
• Investigated and resolved Sales Bonus related service tickets.
• Identified and communicated process issues to resolution.
• Participated in UAT for new Sales Processing System. Created Test Scenarios & Test Cases. Identified, logged and maintained bugs in Bug Tracking System.
• Data comparison - Reports generated using manual process Vs. Canned reports from Sales Processing tool.
• Answered enquiries on current and historic bonus targets and actual bonus.
• Created ad-hoc reports in excel. Created PowerPoint presentations linking to data in Excel.

Environment: MS Excel 2010 Formulas/Templates, GUTS, Buganizer, Trix, PowerPoint 2010, GSP, Chrome

Business Systems Analyst

Confidential, California

Responsibilities:

• Projects included Forecasting, Reforecasting, Predictive Forecasting and Reporting.
• Analyzed end-user functional and technical requirements; documented and developed solutions using computer technology. Enhanced functionality of existing tools/systems.
• Designed the database; developed manual and machine procedures and detailed specifications.
• Provided reports and metrics for finance teams including Revenue Analysis, Sales Ops, Credit & Collections, FP&A, GL Accounting and Legal groups.
• Provided enhancements / maintenance support for all existing reports and programs used by finance groups.
• Used Access 2007 to pull data from SQL Server and other databases for reporting purposes.
• Built Integrated MS Office applications/tools for different groups in the finance department.
• Built tools to run at scheduled times so the data in financial reports is automatically updated.
• Created batch files and used Windows Scheduler to run scheduled tasks.
• Created tables, designed modules to reorganize data in specified format.
• Automated pulling/updating/appending data to/from different databases.
• Created advanced Access queries to process data. Created Pivot tables.
• Created tables, SQL queries, data extraction routines to import/export data from the repositories.
• Collected, correlated and processed large amounts of data from various sources.
• Developed templates and reports for analysis and presentation purposes.

Environment: MS Excel/Access 2007, Excel/Access VBA/Macros/Templates, Visual Basic 6.0, MS Outlook, Windows XP, SQL Server 2008, SQL, DOS Programming

Sr. App. Developer/Data Analyst

Confidential

Responsibilities:

• Analyzed and interpreted existing Lotus 1-2-3 reporting templates and converted them to Excel 2003 with enhanced functionality. Performed quality checks on the report data.
• Created new dynamic templates with Excel VBA/macros.
• Template coding involved linking numerous spreadsheets, VLookups, data analysis/import/manipulation, formulas, calculations and financial information.
• Automated importing of data from numerous CSV and Excel files.
• Created Excel AddIns to import data from SQL Server for reporting purposes.
• Created technical specifications and user documents for new reporting templates.
• Created test plan templates for Q/A team.
• Fixed issues, made enhancements and Integrated Excel into Access based Ticketing System application.
• Used SharePoint for document management. Handled projects from conception till production.

Environment: MS Excel 2003, Lotus 1-2-3 Release 5, Excel/Lotus 123 VBA/Macros/Templates, VSTS 2010 MS Access 2003, Visual Basic 6.0, MS Outlook, MS Share Point 2003, Windows XP, SQL Server, Excel Add-Ins

Sr. EForms Developer/Analyst

Confidential

Responsibilities:

• Worked as part of EForms Management team. Involved in MS Office migration (Ver ).
• Worked on Office 2003 Compatibility testing and Remediation.
• Excel/Word/Outlook VB/VBA based EForms Development for new and existing English and French templates as per business requirements.
• Performed Code/Database analysis, development, clean-up, standardization, optimization, modularization, protection-check as part of the migration project (BDP 2.0).
• Analyzed existing code and created requirements documents and tested EForms.
• Fixed bugs and made changes/enhancements to the existing templates.
• Converted existing Outlook VBA based forms/templates to Excel VBA forms/templates.
• Investigated and develop a strategy for protected EForms/Smart forms development.
• Coding included developing data entry screens/forms, securing macros/worksheets/workbooks/documents, creating standard procedures/functions, vLookups, calculations etc.
• Create Queries in Access database to pull data for analysis and reporting purposes.
• Developed Coding Standards/Best Practices document for the department.
• Used SharePoint for document management. Mentored junior members of the team.

Environment: MS Access 97, MS Office 2000/2003, Excel/Word/Outlook VBA/Macros, Visual Basic 6.0MS Share Point 2003, Windows 2000 Prof, HP Quality Center 9.2 (Formerly Test Director), SQL, Templates, Forms

Sr. MS Office Developer/Analyst

Confidential

Responsibilities:

• Designed, developed and maintained MS Access database, forms, queries and reports.
• Designed and developed data entry screens in Access and Excel for accessing and modifying data.
• Developed and generated ad-hoc reports for review by management. Reporting involved data extractions from various databases including MS Access, Excel and CMIS systems.
• Query database to filter information and generate reports to provide a quick snapshot to management.
• Maintained data integrity and performed updates. Performed ETL as part of reporting.
• Designed and developed user friendly English and French Excel/Word templates and forms for data entry and collection by business. Designed data input sheets using data from various databases for entry into CMIS system.
• Coded VBA to integrate data from multiple Excel spreadsheets and transfer it to MS Access database.
• Gathered data and performed Q/A to identify data issues and resolve them. Performed data fixes, cleanup, consolidation and quality management. Maintain data consistency and data integrity.
• Documented the design and functionality, changes and upgrades to the database for maintenance purposes.
• Programmed Word Mail merging to produce confidential letters/documents using Excel database.
• Confidential documents included Agreement, Letter of Offer, Budget allocation sheets, Statement of Work and related Annexes. Automate creation of PDF documents. WordPerfect Programming.
• Formulating statements of business and system requirements.
• Responsible for Advanced Word and Excel VBA Programming, use of Pivot Tables, VLookup function & formulas, database linking & advanced mail merging.
• Performed detailed analyses of business requirements, prepared systems and programming specifications to design and develop applications to meet these requirements.
• Integrated Word, Excel, Access, Outlook, PDF applications to automate mail-merged document generation, Outlook emails. Synchronized data between multiple files.
• Mentored ‘2’ data entry persons to use the templates, internal systems & processes.

Environment: MS Access 2003, Access VBA, MS Excel 2003, Excel VBA/macros/templates, Word VBA/macros/templates, MS Outlook 2003, Outlook VBA, SQL, Corel WordPerfect 10 macros/scripting, Windows XP, CMIS (Application tracking system), GCRS (Oracle based Reporting system), Lotus Notes 6.5, SQL, ADO, ODBCMS Query, Document and Spreadsheet Programming

Sr. Word VBA Developer/Analyst

Confidential

Responsibilities:

• Worked on Insurance Policy Management System application to generate word documents (Submission/Quote/Proposal documents) as the end product.
• Developed and maintained Word VBA macros to format the word documents.
• Created and modified word templates and integrated them with internal Oracle based application to generate dynamic documents. Developed reports using Crystal Reports.
• Automating tasks using Word & Excel VBA.
• Developed Visual Basic Add-ins and modularized the existing code. Developed DLLs for reusability of code.
• Responsible for updating and maintaining Oracle database to maintain metadata used for producing insurance related documents. Written advanced queries in SQL.
• Used TOAD, SQL*Plus to access Oracle database. Created and executed SQL release Scripts for code deployment in Oracle.
• Reviewed service tickets. Investigated and fixed bugs, defects, data issues. Identified an appropriate solution and made modifications in production systems.
• Involved in developing, testing, maintaining, and documenting internal applications according to standards.
• Standardized MS-Word documents and templates through out the organization.
• Created and maintained code library. Created and maintained files on Visual SourceSafe.
• Performed comprehensive UNIT testing as part of Quality Assurance process.
• Reverse-Engineered to discover the functionality of complex metadata.
• Designed a sub-system that forms a part of a larger, more complex system.
• Synchronized data between different environments/ multiple files.
• Worked in different environments - Development, Development test, Production. Investigated to identify inconsistencies and synchronized data between different work environments.

Environment: Visual Basic 6.0, Word VBA, Excel VBA, Oracle 10g, SQL*Plus 10, Toad for Oracle 9.5Visual SourceSafe 8.0, Quality Assurance, MS Office 2003, Lotus Notes, Crystal Reports XI, Win XP Prof