SUMMARY

• Having 7years of IT experience in Analysis, Design, Development and Implementation of Data Warehousing, Client/Server Applications and Web based Applications.
• Developed, Deployed & Scheduled Crystal Reports in Crystal Enterprise. Developed Reports in SQL Server using SSRS
• Extensively worked on Business Objects Ad - hoc Reporting by accessing data using Universes, Personal data files and stored procedures.
• Strong experience in Business Objects Enterprise Suite products Designer, Desktop Intelligence, Central Management Console, Supervisor, Web Intelligence, Info View, Live Office and Business Query.
• Migrated Deski Reports to Crystal Reports 2008.
• Experienced in the development of Reports for Financial needs of the business using Crystal Reports.
• Developed several crystal repositories using Crystal Enterprise Business View Manager and created reports from repositories.
• Good experience in creating functions like In Repeated Group Header, While Printing Records, While Reading Records etc.
• Expert in creating Complex Crystal Reports (AdHoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports).
• Worked on various reports using multiple RDBMS including Oracle, MS SQL Server, MS Access, Informatica and associated SQL Dialects such as Transact SQL (T-SQL), PL/SQL etc in Windows NT\2000.
• Generated Sub Reports, On Demand Reports, Linked Reports, Mailing Labels, Cross Tab Reports and Graph Reports. Expert in using shared and global variables across the crystal reports.
• Expert in writing complex formulas at the summary level and group level to implement the business logic.
• Developed stored procedures, views, functions etc using SQL, PL/SQL, T-SQL.Very good in documenting the testing process and test evaluation summary.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Crystal Reports.
• Experienced in writing complex formulas in crystal reports, SQL queries using Crystal Designer, migration of Crystal reports in different versions.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle. Excellent communication skills, both written and verbal.

TECHNICAL SKILLS

Core Analytical Skills: project plan, Functional specification document, process flows, data flows, business requirement documentation, Uml, Test plan end user documentation, GAP Analysis.

Methodologies: Water fall, Rup, Agile

Microsoft Products: Office 97 through Office 2007 Word, Excel, Project, Power point, Access, Outlook, Visio 2007

Operating Systems: Windows (all versions), Linux, Mac OSX

Data Bases: MS SQL Server, Oracle, DB2

Applications and Scripts: Crystal reports, Business objects, BO Data Services, Java Scripts, VB Scripts

Other Tools: Toad, Sql Plus

Mark up Languages: XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Crystal Reports Developer

Responsibilities:

• Involved in various projects like DESKI Migration project, CRDW to eBI Conversion project and Report Testing Project.
• Migrated 70 plus reports from DESKI to Crystal using universes, Business Views and stored procedures as data sources also migrated existing tabbed reports in DESKI to Crystal 2008.
• Created complex Crystal Reports from scratch containing various formulae, set parameters and conditions depending upon the selection criteria.
• Created complicated Crystal Reports containing data from more than 3 data providers and worked with SQL optimization to improve run time performance of reports.
• Worked extensively with the Crosstab reports and dealt with various Crosstab functionalities.
• Designed and developed cross tab reports, reports with sub-reports (linked and unlinked) and chart reports. Reports were based on a command object and wrote several SQL queries to accomplish the task.
• Fine-tuned sql queries for faster performance.
• Created manual Crosstab to accomplish individual cell highlighting in Crosstab and also Worked with calculated members to meet the requirements of end users.
• Created and maintained Cubes on BW Database as a data source for reports and Created WebI, Crystal reports using Universe as data source.
• Experience with Report testing and to validate the results against the database. Fine tune SQL Queries and created stored procedures for performance improvement 90% of jobs will run less than a min
• Assisted in trouble shooting issues when reports were migrated from CRDW to eBI and Worked with the Quality Assurance Team to resolve bugs with a very less turnaround time.
• Wrote various test cases to assist in the migration of reports from CRDW to eBI.
• Created custom functions for currency conversion, date conversion, created business views and implemented data-level security to the users and worked with dynamic cascading prompts.
• Given holistic solutions for product limitations like internal drilldowns, large number format, field truncation, Simplified Chinese fonts and RTF alignment.
• Provided minor updates to the scheduler automation system which is programmed using Visual Basic 6 language.
• Scheduled jobs in Qlikview Publisher for reloading of data and distribution of applications.

Environment: Crystal Reports, UML, Visio2003, Visual Basic, MS Office Suite, QTP, Windows.NET and UNIX.

Confidential, Cleveland, OH

Systems Analyst

Responsibilities:

• Worked with clients on the requirements and passing the details to offshore team.
• Expertise on documenting the design documents and full functional documents of the system to make understand to both users and offshore developers.
• Gathered the required mapping to the appropriate technology.
• Developed the Sales and Inventory Cube for SSRS and Tableau reporting, with the required hierarchy.
• Involved in Cube Designing for all the logistics which made the users to browse it for reporting purpose.
• Worked in Production Support project where used to deal with tickets in the issues or new report requests.
• Developed HR Analytics Dashboard and detail reports to HR Department in Tableau.
• Engaged in Requirement Gathering with Business Analyst and prepared the Business Required Documents.
• Consolidated the list of reports requested by the clients and made sure to have single window for reducing the users times to open multi reports for analyzing.
• Supported the Material Utilization reporting for the planners in HBI with creating high level dashboard and reports in Tableau.
• Supported the Marketing merchandising team by providing the POS reports based on the business, division till to show the SKU level with drill down feature.
• Expertise on excel reports by using the cube formulas from sql server cubes.
• Gave the daily update to the project manager on the project and weekly to the project sponsor.
• Coordinated team in offshore who are resided in multiple locations across globe by having daily meetings.

Environment: Tableau, SQL Server Reporting Services (SSRS), SSIS, SSAS, Oracle 10g, SQL Server, MDX, PL/SQL.

Confidential, Pittsburgh, PA

Business System Analyst

Responsibilities:

• Identified Functional, Non-Functional and Business requirements. Involved in life cycle system development, from requirements gathering, business case development, rollout and maintenance.
• Participated in discovery sessions to gather requirements for ecommerce development projects.
• Conducted Survey on discount logic to capture the business rules around various Eureka Forbes discounts and promotions.
• Used detailed knowledge of application features, functions and impact of business needs throughout the analysis and completion of all enhancement specifications.
• Proposed new solution for the order of promotion application logic to offer better discounts to the customers and increase the revenue for Eureka Forbes.
• Participated in testing the promotions in RPOS and POS registers to validate the promotions application.
• Worked with SAS IT team to develop the requirements around SKU and Store Grading process.
• Prepared functional requirements document, Test plan and test schedule.
• Recognized for time management and delivering the project artifacts as per the schedule.

Environment: Windows, UNIX, Outlook, Excel, Word, PowerPoint, Visio, SQL Server 2008, SAS, TFS, POS (point of sale system).

Confidential

Business Analyst

Responsibilities:

• Developed metrics used to determine inefficiencies and areas for improvement.
• Tracked, analyzed and interpreted trends in time-entry data.
• Documented process flows and developed requirements for functional improvements and enhancements.
• Conducted activity-based analysis of business processes and made recommendations based on the findings.
• Execute SQL queries and conduct data analysis for functional improvements
• Manipulated data using pivot tables, pivot charts, and macros.
• Elicited stakeholder feedback and input through interviews and surveys.
• Identified process boundaries and determine opportunities to automate processes and functions.
• Attended organizational change management strategy meetings.
• Identified "bottlenecks" and suggested new and improved processes and policies.
• Create necessary artifacts (process and data flow diagrams, status reports, data mapping document)

Environment: Analysis, Problem solving, SQL queries, charts, presentations,