Business Analyst Curriculum Vitae Model in Word Format Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Arafat Aiven

215 Chishdm Dr.

Bakersfield, LA 41702

(817)-715-0599

arafat_aiven47@gmail.com

Summary

·         10  years of IT Business Analysis and Development: Investment Banking/Financial, Pharmaceutical, Human Resources, Insurance industries.

·         10 years of Access VBA and Excel VBA , classic ASP and VB.

·         7  years  of VB.Net , Window Forms,  ADO.Net,  ASP.Net, Web Services,  XML,  XSLT

·         7   years  of Filenet/Panagon Imaging  and Visual Workflow, Content Management, Workflow,    

        Scanning and imaging and  Business Process Management

·         10 plus years of Crystal Reports and Crystal Reports Enterprise.

·         10  years of Oracle, PL/SQL and MS SQL Server, Data Transformation Services (DTS)

·         8 years of Workflow Analysis and Process Improvement, Content/Catalog Management, eCommerce

Education                       New York University,  Stern School of Business, New York, NY

                                               B. S. Computer Science/B.S. Accounting

·         Skills            

         Access/Excel  VBA , Visual Basic and VB.Net, ASP.Net, SQL Server, Data Transformation Services,

         Crystal Reports, DAO/RDO/ADO,  ODBC, Oracle, MS SQL Server, Imaging: Filenet/Panagon / 

         Visual Workflow, PL/SQL Developer, TOAD, RazorSQL,  Systems Development Life Cycle,

         SharePoint, Microsoft Visio, MS Project, eCommerce, Business Process Management

Experience

06/11 – Present                Valiance Partners ((Software consulting for Pharmaceutical clients),  Bernardsville, NJ

                                           Business Analyst / Developer (Consultant)

·         Provided technical expertise and coordinated activities of multiple database management systems (DBMS) resources on a large account or multiple smaller accounts.

·         Created Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).

·         Developed test scripts, and ensure validation documentation for the client is completed.

·         Used data migration and maping in-house for identifying differences between data and content residing in multiple repositories for such clients as Covidien (a leading global provider of healthcare products), Watson Pharmaceuticals  and Celgene Corporation (a Multinational Biopharmaceutical Company).

·         Gather equipments, analyzed, modified and enhanced with new functionality data migration software in VB.NET providing handling unlimited records for batches created for data  comparison.

·         Created SQL queries for data analysis for various platforms and sources - Oracle, SQL Server, MS Access, SharePoint, Documentum.

·         Created XML configurations and  designed customized sql queries to insure the accuracy of the data and batch file automation for overnight process run.

·         Tools:  Access/Excel VBA, VB. NET, SQL Server , Oracle, Documentum, Share Point, SQL Server, XML, Business Process Management

12/10 – 05/2011              Citigroup, Warren, NJ  (Global Investment Banking)

                                             Business Analyst/Developer (Consultant)

·         Prepared data privacy/cross border compliance reports for departmental and  upper management reporting using Crystal Reports/ Access/Excel VBA, VB6, VB.Net and ASP.Net  for  production maintenance and new enhancements for the Data Privacy Compliance group.

·         Created Business Requirement Documents (BRD), Functional Requirement Documents (FRD), and comprehensive Use Cases.

·         Reviewed reports to determine basic characteristics and flows, format, distribution and purpose of function of report; recommended establishment of new or modified report methods and procedures to improve report content and completeness of information. Answer database architectural related questions specific to reports. Trained business users.

·         Supported databases with multiple concurrent users, ensuring control, integrity and accessibility of the data. Coded VBA macros (SQL Server,  Oracle, MS Access and Excel) for automation solutions and troubleshoot data processing issues.

·         Recommended and designed Crystal Reports from conception through deployment; identifyed problems and   suggestions for improvements. Developed  sql queries and reports, and delivered finished reports based on customer requirements.

·         Tools: Access/Excel VBA, VB.Net, Asp.Net,  VBA, SQL Server, Oracle, Crystal Reports , Business Process Management

1/10 –  11/10           State of New Jersey Division of Pensions and Benefits,   Trenton, NJ

   Business Analyst/Developer (Consultant)

·         Gathered requirements, created logical models and provided quality documentation of detailed user requirements. Create Use Cases, Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Scenario Based Analysis , Static Models, Class Diagrams Interviewing, Surveys. Create project plan, project scope and project objectives.

·         Closely interacted with business users to guarantee expected results through project planning, training sessions and implementation using Agile Methodology.

·         Created descriptive documentation of required approach, procedures, test execution and evaluation for this new development. Wrote user acceptance test plan and testing scripts.

·         Analyzed User Requirements and Time Estimate for Retirements Tracking System .

·         Identified and coded changes in VB.Net and ASP.Net and enhancements required for report general templates (Excel/AccessVBA/Oracle) and interaction with existing system for Accidental Disability Letter Modifications according with new rules and regulations.

·         Created SQL queries ( Oracle, SQL Server, MS Access) for code implementation.

·         Used FileNet Panagon Capture OCX‘s controls and adobe library dlls for text search functionality. Supported Kofax Imaging software and configuration for the scanners in VB6 legacy systems.

·         Created Crystal Reports integration with Microsoft Office 2003 and 2007 applications.

·         Supported web based HR self-service, time tracker and recruiting.

·         Tools: Access/Excel VBA, VB, VB.Net, ASP.Net, Filenet, Oracle, Crystal Reports, XML, BPM

06/09 –  1/10                     IEEE (Institute of Electrical and Electronics Engineers- Publishing) , Piscataway, NJ 

                                           Business Analyst/Developer   (Consultant)

·         Developed  in Access/ExcelVBA and VB.Net/SQL Server IEEE CRM crucial business project.

·         Performed data migration, data validation, and testing of new interfaces from legacy MS Access system to newly designed  VB.Net/SQL Server system.

·         Provided detailed business analysis of the existing system and recommended transitions and

        solution for the new system.  Documented all findings and recommendations.

·         Developed Import projects from legacy systems to new structured SQL Server DB

·         Customized Salesforce.com configuration, fields, and page layouts for Accounts, Leads, Contacts, Opportunities, Activities and trained business users.

·         Analyzed application requirements, created test plans, and wrote documentation.

·         Tools: Access/Excel VBA, VB, VB.Net, Filenet, Oracle, Crystal Reports, Salesforce.com

5/08 –  5/09            Deutsche Bank,   NY, NY  (Global Investment Banking)

Business Analyst / Developer

·         Gathered requirements, create logical models and provide quality detailed documentation.

·         Documented client's Use Cases, reporting requirements and specifications and maintained project plan and issues tracking.

·         Developed and maintained automation functions and reports for global credit trading product control group (Accounting/Finance) using MS Access / Excel VBA with Oracle backend. Designed month end accounting and P&L reporting processes.  Modified existing applications based on rapidly changing trading products and business lines. Generated adhoc requests.

·         Customized accounts, contacts, opportunities, campaigns and contracts objects in salesforce.com application per internal stakeholders requirements.

·         Gathered business requirements from HR and Financial users to create Workflow Content Management web sites with integration of other applications such as PeopleSoft and SAP.

·         Enhanced and modify applications that generate financial data for centralized General ledger system SAP for month end P&L statements and validates data between US and UK accounting books.

·         Ensured that  accounting Sub-ledger generated reports reflect daily updates per center for various financial products –derivatives, stocks, bonds, SWAPS, options, equities, futures.

·         ETL procedures, triggers, alerts, error trapping and documentation

·         Tools: Access/Excel VBA, VB, VB.Net, ASP.Net, Oracle, SQL Server, UML, Visio

10/07- 5/08             Merck,   Rahway, NJ  (Pharmaceutical)

Developer/Business Analyst (Consultant)

·         Designed and developed complex MS Access front end (ADP projects/VBA) / SQL Server /Crystal Reports applications for scientists and chemists. Application allows scientists to add various formulations, view graphical representations of the schema as well as images, add required components for the drugs as well as track available resources.

·         Worked with Documentum for all types of content including business documents, medical images, and fixed content, XML-tagged documents.

·         Created new database, tables, views, and functions in SQL server for this new development.

·         Oversee all enhancements and changes per user’s requests. Full life cycle development.

·         Worked with business users to develop specifications for complex Crystal Reports.

·         Tools: Access/Excel VBA, ADP projects ,VB.Net, ASP.Net, SQL Server, Oracle

9/06- 9/07               Bank of New York Mellon, New York, NY (Investment Banking)

Developer/Business Analyst (Consultant)

·         Interacted with all levels of management of Corporate Trust Division to gather business requirements for various fixed assets products and create standard procedures and documentation for day to day operations.

·         Applied Agile requirements change management process working closely with stakeholders throughout the iteration to ensure that built software meets their actual needs.

·         Automated various financial data to ensure smooth transition of BNY assets SWAP with JPM Morgan Chase in Access VBA and Excel VBA.

·         Customized accounts, contacts, opportunities, campaigns and contracts objects in salesforce.com application. Prepared and executed test plans and lead training of end users.

·         Gathered  functional and technical requirements and automated crucial management reporting.

·         Supported Content/Catalog Management and ecommerce sites for HR Content servers and interaction with PeopleSoft HR modules. Ensured necessary processes and controls for compliance with data privacy and HR laws.

·         Tools, VB.Net, VB, Access and Excel VBA, Oracle, SQL Server, People Soft, CRM, salesforce.com.

8/03- 8/06               ANC group, Sparta,NJ (Brokerage/Trading)

SENIOR PROGRAMMER ANALYST

·         Developed prototype in VB.Net and Salesforce API’s tools.

·         Supported and customized PeopleSoft modules: eRecruit, Time and Labor, Base HR/Payroll, and Self-Service.

·         Developed applications in VB6 using Active X, FileNet Panagon Capture controls with Oracle DB.

·         Tools: Salesforce.com, VB, VB.Net, ASP.Net, Access/Excel VBA, Crystal Reports, Oracle

10/01-8/03              Chubb & Son, Whitehouse Station, NJ  (Insurance)

SENIOR PROGRAMMER ANALYST

·         Designed and developed flexible Reinsurance Tracking system using Visual Basic/ Crystal reports/Oracle. 

·         Supported PeopleSoft financial system: Accounts Payable, Accounts Receivable and GL components.

·         Developed Scan application to scan, display and commit documents using VB6/Oracle.

·         Used FileNet Panagon Capture OCX‘s controls.

·         Administered the FileNET Imaging system by setting up new users, debugging production outages and scheduling maintenance reboots.

·         Tools: VB, VB.Net, ASP.Net, ASP, Crystal Reports, Oracle, SQL Server, FileNet

9/96- 5/01               Pershing ( division of The Bank of New York Mellon) , Florham Park, NJ

                                              (Brokerage /Investment Banking)

SENIOR PROGRAMMER / DEVELOPER

·         Developed applications in VB using Active X, FileNet Panagon Capture and Desktop controls .

·         Reduced document capture costs and improved accuracy with the development of customized scanning and indexing FileNet Imaging and VB applications: Mutual Fund, Broker View, Custody, and Procash.

·         Supported and Enhanced  various financial models (including Fixed Income Portfolio Management, Trading System, Securities & Derivatives, Option Pricing, Prepayment, Credit, Portfolio Optimization, Risk Management, etc.) in Visual Basic, Access, Excel, and Crystal Reports

·         Tools: VB, ASP,  Oracle, SQL Server, FileNet with VB controls

Download Resume Format