Application Analyst Resume Format in Word Free Download

640Sample 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

Sara Brochu

Phone: 508-767-9876
Email: sara@yahoo.com
Auburn, MA 01001 USA

Objective:
Seeking for a challenging and interesting role in a company where my experience and knowledge can be utilized and enhanced.

Business Skills:

• Prepare reports for use in business planning and analysis for assigned areas.
• Using ALTIRIS software asset management and inventory tool and SQL Server 2005 to run software installation reports.
• Using Peregrine software and hardware Asset Management tool and Toad for DA to run software installation reports.
• User information is extracted using Toad for Data Analysts when needed.
• Work on a variety of issues and may exercise independent judgment and recommendations in selecting reporting and analysis techniques.
• Provide analytical and statistical support with broad range of cross-functional positions.
• Assists in managing projects through completion including project tracking, monitoring, reporting and administration.
• Develop report specifications of data requirements and provides analysis to resolve business-related problems.
• Improve reporting processes whenever possible.  
• Experience with data query functions (Excel Pivot, SQL server 2005)
• Work closely with ITAM team to assist with reports and maintenance using Account Life Cycle management tool (ALM).
• Create documentation and ensure readiness for all projects.  
• Work with other departments to ensure the integrity and completeness of the solutions delivery process if required.
• Work with the IT, Finance, Sales and Marketing organizations on development and implementation of reporting system enhancements and fixes.
• Translate business needs into system requirements.
• Evaluate and articulate proposed business requirements and identify impact, risks, and benefits of alternative solutions.
• Investigate complex problems in production environments and suggest solutions to resolve them.
• Maintain and manage Security Roles for User access to revenue reporting systems.
• Provide training and documentation for users on reporting system functionality.
• Critically review existing business processes with relation to revenue and margin reporting and data and process integrity and make recommendations for improvement.
• Reconcile data between Reporting Systems and explain variances.
• Create reports and dashboards using Oracle OBIEE and ESSBASE tools.
• Involve in defining, documenting, and clarifying business requirements on various reporting system enhancements and report/dashboard development.
• Performs other duties as required.
• Communication Skills.
   

Technical Skills:

• Exceptionally good in problem Analyzing, Solving and Troubleshooting skills
• OS: Windows, Windows 2000, 2003, Mac OSX, Windows XP Pro
• Languages: Basic C, Visual Basics, SQL, DBMS, ASP.NET, VB.NET
• Junior level Scripting Languages: HTML, DHTML, JavaScript, Vb.Net CSS, Automator
• Work Experience refreshing and retrieving data using Oracle OBIEE, ESSBASE Reporting Applications
• Database & Tools used for Reporting: ALTIRIS software Asset Management and Inventory tool, MS Access, MS Excel, MS Visual Studio, SQL server 2000/2005, SQL Enterprise Management tool, Peregrine Asset Mgmt tool, Toad for DA, Oracle 11i/1103 programming tool, T-SQL, Oracle customized Account Life Cycle Identity data management tool, Gimp, Oracle OBIEE, ESSBASE, Microsoft Access 2007
• Knowledge of Oracle Time & Labor Application.
• Junior to Mid-level knowledge of SQL server Database Programming
• Understanding of Project Management principles
• Excellent communication and Interpersonal skills
• Ability to support critical business requirements
• Ability to work in a team environment.
• Cross-Functional skill
• Ability to work independently
• Strong analytical ability
• Knowledge of job associated database/software/documentation
• Organizational skills
  
  
  

Education:

• Bachelor of Commerce: Bangalore University - Bangalore, INDIA
• Web Development Certification: Worcester Polytechnic Institute - Southborough, Massachusetts, USA
• Undergraduate Credit Courses: - Microsoft Applications
  Worcester State College - Worcester, Massachusetts, USA
• Undergraduate Credit Courses: - Information Technology
  Quinsigamond Community College - Worcester, Massachusetts, USA
   

Work History:

Application Analyst

EMC Corporation

12/2010 – Present

• Work with the IT, Finance, Sales and Marketing organizations on development and implementation of reporting system enhancements and fixes.
• Translate business needs into system requirements.
• Evaluate and articulate proposed business requirements and identify impact, risks, and benefits of alternative solutions.
• Investigate complex problems in production environments and suggest solutions to resolve them.
• Use MS Access 2007 to Import/Export data from master database tables
• Maintain and manage Security Roles for User access to revenue reporting systems.
• Provide training and documentation for users on reporting system functionality.
• Critically review existing business processes with relation to revenue and margin reporting and data and process integrity and make recommendations for improvement.
• Reconcile data between reporting systems and explain variances.
• Create reports and dashboards using Oracle OBIEE and ESSBASE tools
• Involve in defining, documenting, and clarifying business requirements on various reporting system enhancements and report/dashboard development.
• Maintain and manage security roles for user access to revenue reporting systems
• Involved in New Acquisition Integration process
• Data validation in multiple data source database tables
• Involved in Propel documentation (SAP)

Database Analyst– Contract through CompuCom
Hanover Insurance Worcester, Massachusetts
6/2010 – 12/2010

• Gathering software data from different sources
• Determining required data fields
• Cleaning and compiling data
• Using ALTIRIS Inventory management to recognize datasets for Asset management
• Using Toad for DA to query Peregrine Asset Center which uses Oracle and SQL Server 2005
• Meeting with stakeholders to discuss on ALTIRIS Asset management project
• Involved in Organizational Structure on s/w Inventory and Asset management processing
• Design database tables
• Import Export data into and from SQL server 2005 database
• Additional ad-hoc reports.
• Provide documentation and recommendations detailing best practices

Front Desk Support – Part Time
Fairfield Inn Marriott

2/2010 - Present

• Greet guests
• Responsible for both reservation and reception related calls
• Take walk-Ins
• Responsible for Check-In and Check-Outs
• Responsible for new reservations
• Responsible for handling Cash
• Work with housekeeping to ensure rooms are ready and update on system
• Responsible for group Check-Ins and Check-Outs
• Necessary arrangements when reserved functional hall
• Presently I am on an on call basis when needed

Security Analyst – Identity Data Access Management Group - Contract
EMC Corporation Westborough, Massachusetts
5/2007 – 2/2009

• Analyze services and resources to determine required user Identity Data Access
• Determine user roles and responsibilities
• Analyze and document (both existing and potential) solutions for the following:
  User account provisioning with ALM (Account Lifecycle Management), Password Management, Role-Based access control etc.
• Provide documentation and recommendations detailing best practices for user and access control
• Used SQL Server Enterprise Manager tool for Creation, Import/Export from master database tables
• Exceptionally good and experienced in handling the problem and troubleshooting
• Submit Peregrine request to clean data in master database tables
• Run SQL scripts, Views to analyze user statuses for ex: User Termination/New Hire/Rehire/Conversion. Temp-Perm or Perm-Temp
• Submit Peregrine tickets for Account Administrators with admin rights to fix user accounts
• Assist with special projects
• Effectively use communication skills to support necessary departments needed to ensure job quality and turn around
• Overall responsible for daily task management, interactions and on-time delivery of services
• Knowledge of Oracle Time and Labor management application to Input, Edit, Update EMC employees time and labor
• Write SQL scripts for reporting and to clean data using Oracle 11i, Oracle 1103 and SQL server 2003 / 2005 databases
• Work with team supervisor and other departments to ensure the integrity and completeness of the solutions delivery process if necessary
• Create documentation and ensure readiness for all projects
• Performs other duties as required.  

.Net Developer – Full Time
Wilson Language Corporation Oxford, Massachusetts
1/2006 – 12/2006

• Gathered project requirements Information and system Specifications.
• Prepared physical paper prototype.
• During verification process with stakeholders, gathered further project requirements and changes.
• Built software prototype, present to stakeholders for final agreement on projects.
• Responsible for analyzing and designing of all Web Pages of the project.
• Created both static and dynamic data driven Web Pages.
• Test projects on local machine. Coding and Testing was regular practice.
• Host the newly built web project on production server and train the user.
• Support help desk team with Microsoft Customer Services Product (CRM)
• On a daily basis, resolved tickets posted related to database or web problems by CRM users.
• Built personal vb.net data driven project during spare time.
• Technologies and Languages used during this time was:
  MS Visual Studio.Net, Windows XP Pro, SQL server 2000/2005, 
• L, JavaScript, VbScript, CSS, ASP.NET, VB.NET, MS Excel.
• Marketing Data Analyst – Full Time
  IBC Corporation Westborough, Massachusetts
  5/2002 - 12/2005
• International Business Conferences - Marketing Campaign Services rendered mainly to the Marketing Department.
• Email Campaigns jobs are dumped into one common mailbox by all five marketers.
• Email & Fax Campaign processing were part of my responsibility.
• Querying Databases to Extract Lists for Email Campaign / Fax Campaign / Swap List / Main Mail / Research List.
• Maintain and Improve Existing Reports
• Establish Campaign Execution timelines and guidelines.
• Develop quality assurance processes to ensure Program Accuracy
• The above tasks are done on a daily basis using MSDOS, MS- Explorer, FoxPro, Interest Tracker Database, and Third party Software.
  
  

Web Developer – Paid Intern
Instron Corporation Canton, Massachusetts
12/2001 - 6/2002

• Gathered project requirements Information and system Specifications.
• Prepared physical paper prototype.
• During verification process with stakeholders, gathered further project requirements and changes.
• Built software prototype, present to stakeholders for final agreement on projects.
• Responsible for analyzing and designing of all Web Pages of the project.
• Created both static and dynamic data driven Web Pages.
• Test projects on local machine. Coding and Testing was regular practice.
• Host the newly built web project on production server and train the user.
• Built Intranet Software data driven project..
• Technologies and Languages used during this time was:
  MS Visual Studio, Windows XP Pro, SQL server 2000, HTML, JavaScript,
  VbScript, CSS, ASP, MS Excel. 

CSD Specialist  - Contract
Fidelity Investments Marlborough, Massachusetts
9/2000 - 4/2001

• Resolve the participant 401K Inquiries placed by the PSG rep on daily basis.
• Responsible for client spreadsheets and other responsibilities.
• Phone communications with participants, writing letters per participants request like list of loan repayments, qualified letters etc.
• The above tasks are done on a daily basis using MS Explorer, MS Word MS Excel and Third Party Application.
• Host the system on production server and train the user about the system.
• Assist with special projects.  

Technical & Administrative Support - Contract
UMass Medical Hospital, Massachusetts
9/1999 - 9/2000

• Research of Medical Journals and Articles on the Internet.
• Troubleshoot PC's, Printers, Copier, and Fax.
• Assist in basic Network Administration
• Supervise and Mentor new employees.
• Editing Manuscripts and Dictaphone
• Assist with special projects.
• Provide first contact support for Technical Assistance.
• Maintained and customized application software and tools of co systems.
• Generated, Sorted and Filed Medical Claims according to coding.
• Maintained professional manner in a fast paced Environment.

Reference:

Available upon request

Download Resume Format