
Oklahoma City, Oklahoma Area

Oklahoma City, Oklahoma Area
(Public Company; HP; Information Technology and Services industry)
October 2008 — Present (10 months)
* Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
* Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
* Created reports containing all the information regarding the publishers, distributors and retailers using crystal reports xiR2.
* Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
* Developed critical reports like drill down, Slice and Dice, master/detail for analysis.
* Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
* Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
(Government Relations industry)
2009 — 2009 (less than a year)
(Oil & Energy industry)
March 2008 — October 2008 (8 months)
* Worked with the higher management in various departments to gather requirements for their reporting needs.
* Created Report templates Summary Reports Master/Detail Reports Parametrized Reports and Cross-tab reports.
* Developed Views /Stored Procedures in Oracle database to be deployed in the reports for better performance.
* Created User Defined Functions and used them in the Stored Procedures.
* Created reports which included formatting options such as Charting Mapping Grouping Sorting Alerting Field highlighting Drill-down and Parameter prompts.
* Created Dashboards to display reports and web intelligence documents using InfoView.
* Used advanced features like shared repositories in Crystal reports XI.
* Worked with subreports and tuned them for optimum performance.
* Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
(Public Company; XRAY; Medical Devices industry)
September 2006 — March 2008 (1 year 7 months)
* Executed in-depth analysis and reporting on data collected from main sources, day to day management and trend analysis using SQL Server and MS Excel.
* Supported management in leading the following reporting functions: data consolidation, management reporting and data analysis.
* Created timely, accurate and complete generation of recurring and ad-hoc reports.
* Analyzed and recommended improvements for current reporting and data capture as well as uses.
* Prioritized planning, reporting and analysis assignments and efforts to ensure all projects and any recurring and ad-hoc reports are completed in sufficient time to support decision makers.
(Privately Held; Leisure, Travel & Tourism industry)
March 2005 — September 2006 (1 year 7 months)
* Supported end users with ADHOC reporting and analysis using Business Objects reporter and SQL.
* Developed and provided analysis of key performance indicators for trend evaluation.
* Prepared reports, including graphs and charts and present recommendation for action plans.
* Compiled weekly, monthly, and quarterly reports measuring Market Share, booking trends and production results for Alamo & National Brands.
* Assisted Marketing departments with direct mail program analysis.
* Continuously validated the Data Warehouse and add further value based on end user requirements
* Automated/standardized and scheduled reporting using scheduler functions in Business Objects and COGNOS Impromptu.
* Identified efficiencies, synergies and consistencies in reporting within the company.
(Government Agency; Military industry)
April 1995 — April 1998 (3 years 1 month)
* Supervised performance of administrative functions at headquarter level.
* Reviewed and edited correspondence prior to release, submission for signature, or other disposition.
* Conducted periodic review of files to ensure proper filing of correspondence.
* Controlled use of reproduction facilities and reviews item to be reproduced.
* Planed and organized office operations to include publications and forms administration and office administrative procedures.
* Wrote office SOP, job descriptions, and directives.
* Determined requirements for office equipment, supplies, and space.
* Coordinated administrative activities with other organizational elements and staff sections.
* Established mail delivery routes and schemes and arranges for pickup of distribution by messengers.
* Served as custodian of classified documents.
* Signed receipts for, logs, inventories, files, and secures classified documents.
* Prepared documents for destruction or other disposition.
* Ensured proper accountability of documents based upon degree of classification.
BS , Management Information Systems (MIS) , 2000 — 2004