SUMMARY

• Self - Motivated Analyst with over 15 years of experience in, Audit, Communications, Banking and other industries.
• Strong problem solving/decision making skills and well developed analytical skills.
• Recognized for ability to identify continuous change to reduce cost, enhance quality, and increase margins.
• Profound knowledge of MS Access development with VBA& SQL
• Outstanding ability to develop database tables through standard queries
• Exceptional ability to manage high volume of projects and tasks
• Able to write Data Definition, Data Manipulation & Transaction Control Languages.
• Excellent understanding of Business Automation.
• In-depth knowledge of ETL, data modeling, mapping and design.
• Strong logical, assessment, interpretation, planning and administrative abilities.
• Adept at reducing development costs and providing traceability of projects.
• Adequate public speaking, presentational skills & report writing capabilities.
• Good analytical capabilities with well-grounded data analysis & inferential skills.
• Enjoy driving new improvements, detail oriented, innovative and excellent analytical decision making skills

TECHNICAL SKILLS

Databases: MS Access, Visual Basic, Alpha-5, SQL

ETL Tool: Docu Analyzer, Auto Import (V 1.27)

GUI/Tools: Tableau, MS Office (Access, Excel, Word, Power Point, Outlook), Salesforce, LogMeIn, Join.me, GoToMyPC, TeamViewer, PODIO.

Industry Standards: SOX, ISO, Six Sigma, CMM, OPEX

Platforms: Windows NT/2000/XP/7/8, MSDOS

PROFESSIONAL EXPERIENCE

VBA Developer

Confidential, Chicago, IL

Responsibilities:

• Enhanced existing modules to enable automatic updates and data collection for excel workbooks.
• Performed testing, maintenance, debugging, and documentation for every process
• Designed and wrote the automation code for requested enhancements
• Designed Confidential self-training and trouble-shooting manual for On Shore and Off Shore users
• Provided on-site and off-site troubleshoot assistance.
• Evaluated numerous complex system problems and user requirements.
• Developed the ability to develop structured and modular solutions. Built program specifications, requirements analysis and internal design to meet rigorous standards.

Data Analyst

Confidential, Chicago, IL

Responsibilities:

• Produced, Maintained and further improve new and current Microsoft Access databases using VBA - and SQL (Structured Query Language) Code
• Helped Administrating the web based Client Voice Survey data gathering.
• Write VBA programs to automatically clean data, encompassing class and program modules to be used in Access.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and transform datasets through filtering, grouping, aggregation, and statistical calculation.
• Worked with all levels of development from analysis through implementation and support.
• Introduced the improvements in the way we process and refresh the data on an ongoing basis.
• Wrote queries and VBA Codes to extract data for various reporting needs
• Created Excel Macro to cleanse data for reporting needs
• Update firm’s Intranet and ensure all data is in-line and current.
• Manages web based Dashboard for External and Internal client Reporting.

Data/Financial Analyst

Confidential, Naperville, IL

Responsibilities:

• Added automated functions to existing Access databases. Redesigned queries to improve performance.
• Produced Daily, weekly, Month End and Year End reports.
• New and updated information entered by one user is immediately available to other users to generate real-time reports.
• Used M.S. Excel Macros & formulas (array formula, pivot tables, charts,VBA) for process automation.
• Developed custom screens and reports that display information orderly with graphs/charts to analyze business data and track work progress.

Business Analyst

Confidential, Florida

Responsibilities:

• Provided support assistance to business users on non-break-fix issues by facilitating analysis and data gathering.
• Liaise IT with the business across lines of business and areas in Confidential shared services structure providing understanding of financial operations and supporting technology, with understanding of finance impacts to and from other business units including supply chain and the multi org and multi-currency strategic functionality.
• Documented requirements for custom reports.
• Reviewed and gathered requirements, and documented solutions for business requests.
• Liaised between users and system developers by interpreting and documented requirements for development.
• Created and documented training, troubleshooting and user manuals for issues resolution.
• Liaised IT departments, management and users in decision making in meetings as related to the SAP, Vantive, CADS and AML solutions in the Supply Chain area.
• Maintained and updated PODIO workspace with current issues by exporting currently used Excel worksheets.

Technical Analyst

Confidential, Florida

Responsibilities:

• Review external client’s technical needs and technical parameters.
• Work with external clients to understand their technical needs, resolve or recommend integrated technical solutions, implement and support integrated technical solutions.
• Demonstrate good judgment in selecting methods and techniques for obtaining solutions.
• Manage multiple clients’ requests simultaneously, Network and maintain good relationships with clients.
• Continuously challenge the ways of working to ensure continuous improvement within the team.
• Working closely with sales and service development teams that use cutting edge technology to put the client first, customer service and sales.
• Follow established procedures to document, resolve and/or escalate incidents.

Data/Financial Analyst

Confidential, Florida

Responsibilities:

• Added automated functions to existing Access databases. Redesigned queries to improve performance.
• Produced Daily, weekly, Month End and Year End reports.
• Performed data compiling, mining and psychoanalysis required to assess the given data using V-Lookups, H-Lookup, Pivot table and other tools and formulas
• Reviewed job tracking sheet, revise, and make improvements.
• Developed charts and graphs for analysis and presentation.
• Created macros to process daily downloaded data for database upload.
• Used macros to import data from current databases for reporting.
• Managed Monthly budget preparation and development of Management Information System Dashboard.
• Created user manual and trained users accordingly.

Business/Financial Analyst

Confidential, Florida

Responsibilities:

• Developed Microsoft Access and SQL database applications that can be shared on the local network.
• New and updated information entered by one user is immediately available to other users to generate real-time reports.
• Used M.S. Excel Macros & formulas (array formula, pivot tables, charts,VBA) for process automation.
• Developed custom screens and reports that display information orderly with graphs/charts to analyze business data and track work progress.
• Performed business process automation by enhancing currently used databases and creating several new databases which saved over million dollars every year.
• Downloaded and processed everyday user transactions from Master Database
• Developed financial models and analyses to support strategic initiatives
• Supported Senior Management Team and Departments heads with in-depth analysis.
• Prepared presentations to Board of Directors and Senior Management Team.

System Analyst

Confidential, Florida

Responsibilities:

• Reviewed business process, User Requirement Specification (URS), and functional requirements.
• Worked with SQL queries for data manipulations.
• Performed GAP analysis of business rules, and system process flows, user administration, and requirements.
• To create Constraints, Views, Indexes, Sequences and Synonyms to produce the required output.
• Utilizing Expressions and various SQL Functions (i.e. Character, Number, Date, Conversion functions & Group Functions) to exhibit the desired information.
• Applying Order By, Group By and Having clauses to pull the needed data.
• Restricting and Sorting Data using Where clause, Boolean Logic, References, Expressions etc.

System Analyst

Confidential, Florida

Responsibilities:

• Aided management in standardizing Web applications by preparing GUI standards and recommending alternatives for in corporation in phased, iterative manner.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.

Financial Analyst

Confidential, Florida

Responsibilities:

• Helped manage analysis and mitigation plans, status reports, and client presentations; defined milestone deliverables, and established critical success factors.
• Created documentation for training, Involved in detailing project mission, data process flow diagrams, and timelines.
• Generate customized Financial Reports pertaining to the user requirements.

Inventory Control Manager

Confidential, Florida

Responsibilities:

• Ensure adequate inventory of materials and products in accordance with inventory cycles and organizational philosophy.
• Conducted daily inventory analysis to solve inventory problems.
• Developed and implements inventory control procedures.
• Coordinated and managed daily physical cycle counts.
• Trained and manage an inventory team.

Confidential, New York

Responsibilities:

• Orders merchandise, supplies, and equipment.
• Records delivery of merchandise, compares record with merchandise ordered, and reports discrepancies to control costs and maintain correct inventory levels.
• Inspects merchandise to ensure it is correctly priced and displayed.
• Recommends additions to or deletions of merchandise to be sold in department.
• Prepares sales and inventory reports.
• Interview job applicants and evaluates worker performance to recommend personnel actions such as hiring, retention, promotion, transfer or dismissal of workers.

Accounting Manager

Confidential

Responsibilities:

• Lead Confidential team of accounting professionals.
• Responsible for new growth revenue by adding to the existing book of business.
• Responsible for servicing the needs of the clients, attainment of sales objectives and client satisfaction and retention for new and existing accounts.