OBJECTIVE

• Seeking a career in Report Development and/or Databases, preferably using Microsoft technologies Excel, Access, C#, VBA and/or SQL, with a growth - oriented organization.

TECHNICAL SKILLS

Languages: Some Visual Basic (VBA), C++, C#

Databases: SQL 2008, Oracle OraClient 11g, MS Access, SQL Management Studio

Applications: Crystal Reports, Excel, Macros, Cognos, Impromptu, Business Objects, TeradataSSRS, Yellowfin

Operating Systems: Windows 2003 - Windows 7

Other: Visual Studio, MS Server, PowerPoint, Visio, Technical Writing, SDLCPAN systems, Merge Graph, Stars/NAIS (UNIX based)

PROFESSIONAL EXPERIENCE

Confidential

Virtual Report Analyst II

Responsibilities:

• Running Daily, Weekly and Monthly Reports
• Ensuring Data quality and Integrity
• Create and maintain reports in crystal reports, oracle and MS SQL
• Work closely with management to prioritize business and information needs
• Understanding business objectives and completing business request
• Create a daily task list with timeline to organize schedules
• Acquiring data from primary and secondary data sources & databases/data systems
• Creating Excel knowledge, using import and export and SQL ad-hoc reports
• Creating reports using excel (Import/Export, Pivot Tables, Vlookups, functions, etc.)
• Write basic and complex queries in SQL and Access to create client specific ad-hoc reports
• Gather data for and create client specific Quarterly Business Reviews on a monthly and quarterly basis
• Assist with the conversion of client data from oracle client to yellowfin and/or SSRS
• Create, update and supervision of client specific foundational document for cube creation
• Excellent ability to learn new technologies and ability to deepen understanding of existing code
• Ability to work on multiple priorities and deadlines simultaneously
• Ability to schedule report distribution on SSRS, Yellowfin and BO
• Knowledge of T-SQL, views and stored procedures
• Knowledge of SSRS, currently learning yellowfin
• Knowledge of Crystal reports
• Knowledge of BO
• Knowledge of Taleo and Brassring
• Updating technical documentation and reporting steps
• Assisting manager with special time sensitive projects

Confidential

Data Report Analyst

Responsibilities:

• Knowledge of SQL code and SQL statements
• Running SQL queries using Teradata
• Running Daily, Weekly and Monthly Reports by specified time
• Working within a fast paced environment
• Creating reports using excel (Import/Export, Pivot Tables, Vlookups, functions, etc.)
• Creating Ad-hoc reports with little or no notice
• Working closely with business to create and complete report builds based on business need
• Prioritizing business and information needs
• Ensuring Data quality and integrity
• Using some VBA and Macros in Excel to calculate data for placement in graphs and reports
• Excellent ability to learn new technologies and ability to deepen understanding of existing code
• Ability to work on multiple priorities and deadlines simultaneously

Confidential

Data Research Analyst / Report Analyst

Responsibilities:

• Assist with monthly maintenance of ECS data files, research and translations within a custom system.
• Recommend, test and implement process improvements to gain efficiencies, eliminate redundancies, reduce expenses and meet business demands.
• Process and maintain data that is stored on STARS and NAIS, as well as maintain documentation of all requests/ updates.
• Create Ad-Hoc reports using cognos (Version 7 & 8) and impromptu
• Created reporting spreadsheets in excel to analyze data received from vendors
• Updated macros to run and format reports
• Creating excel pivot tables and graphs to showcase data
• Using text function, logical functions and statistical functions in excel on a daily basis
• Analyzing and updating VBA and macros for report efficiency
• Import and Export data from access to excel
• Studying about and writing apps for iPhones
• Creating Stored Procedures, Triggers and functions in SQL
• Proficiency with SQL reporting tool (SSRS)
• Update monthly sales/financial reports for regional managers and VP’s.
• Ability to work on multiple priorities and deadlines simultaneously.
• Identify and streamline more efficient processes/procedures for meeting business goals of the Company.
• Create, design, and execute custom databases as needed.
• Updating & creating technical procedures and reporting steps
• Assist others within a focused team environment.
• Assist manager with special projects as needed.
• Learning and using SAP and BEx.

Confidential

Reporting Analyst

Responsibilities:

• Analyzing oil and gas well data for outcome of production.
• Creating Excel and ad-hoc reports for major gas companies.
• Using some VBA and Macros in Excel to calculate data for placement in graphs and reports.
• Building, maintaining and tuning SQL databases for in-house apps and field reps.
• Converting Access database to SQL using SQL Server.
• Updating and maintaining Access database.
• Analyzing and updating VBA and macros for report efficiency
• Using text function, logical functions and statistical functions in excel on a daily basis
• Import and Export data from access to excel
• Studying about and writing apps for iPhones
• Creating Stored Procedures, Triggers and functions in SQL
• Proficiency with SQL reporting tool (SSRS)
• Excellent ability to learn new technologies and ability to deepen understanding of existing code.
• Server Support, Laptop Support and Desktop Support
• Taking initiative over new projects.
• Updating & creating technical procedures and reporting steps.

Confidential

SAP Business Intelligence Intern

Responsibilities:

• Using SAP GUI.
• Assisting with packaging new functional/technical specs.
• Assisted with dashboard conversion to Webi and Xcelius.
• Testing packages for results and fixing issues with applications during testing.
• Assisted with update of BW document in solutions manager.
• Running jobs in Redwood, assisting conversion from Redwood to Control M.
• Gathering, Maintaining KPI’s for BW team for reporting and updating purposes
• Participating in weekly and monthly meeting to report progress