Areas of Strength:

DATA WAREHOUSING

BUSINESSOBJECTS  

Xcelsius OLAP Crystal Reports

RDBMS 
SQL SDLCDEVELOPER DESIGNER ANALYST

PROFILE:

• Result Oriented IT professional with over Eight(8) years of progressive expertise in analyzing the requirements, Application design, development, testing and a comprehensive background in Database development, Business Intelligence, OLAP and Data Warehousing.
• Four years (6+) of Business Intelligence experience using Business Objects Xir4.0/XIr3.1/Xir2/6.5/Xir4.0, CMC, BO Designer, BO Reporter, Broadcast Agent, InfoView, Web Intelligenceand Xcelsius
• Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.
• Strong Data warehousing experience with SAP Business Objects, WebIntelligence, CMS (Central Management Server), CMC (Central Management Console), Import Wizard, Publisher, Broadcast Agent.
• Experienced in design and development of Complex Universes.
• Published Reports in Crystal Enterprise via. Crystal Publishing Wizard and Crystal Management Console. Experience in Scheduling the Reports using Crystal Enterprise.
• Expertise in gathering the business requirements and creating Universes in the Designer
• Experienced in Analyzing through MS Office by creating Cross Tab,Navigation,Sorting and Filtering .
• Experience with creating hierarchies, predefined conditions, customized Lists of Values, Derived Tables and in using @ functions.
• Experienced in creating canned, ad-hoc and complex reports using SAP Business Objects.
• Experienced in the implementation and Migration of SAP Business Objects applications across different versions using Import Wizard.
• Experienced in creating Dashboards using Dashboard Manager in Xi R2.
• Experienced in creating Metrics, Analytics, Goals/ Scorecards in Xi R2.
• Extensively worked on CMS by creating users, Groups. Involved in Clustering with XiR2 servers, Deciding cluster Scalability.
• Involved in Doing Report Migration Estimation. Experienced in Creating and setting up the EPM Repository.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects XI R4.0 XI R3.1/R3/R2/R1/6.5/6.1/5.1, CMC, Designer, Info view, Web-Intelligence XI/6.0/2.7,Supervisor, Auditor, Crystal Reports, Crystal Xcelsius 4.5/3.5/3.0.

Database: Oracle 11g/10g/9i/8i, DB2, SQL Server 2005/2000, Teradata.

Operating Systems: Windows NT /2000/XP, Win 95/98/3.x,MS-DOS, UNIX, Solaris

Tools: SAP Integration Kit, Discoverer 11g/10g/9i/4i, Developer Suite 10g, Oracle SQL*Loader, SQL*Plus.

Database languages & Tools: TOAD9.0.1.8/9.0/8.6.1/7.2, Pl/SQL Developer, SQL*PLUS, SQL* LOADER,VBA,JAVA, SQL, PL/SQL, SQL*Loader, Constraints, Indexes-B-tree Index, Bitmap Index, Views, Inline Views.

EDUCATION Bachelor of Engineering in Electronics & Communication Engineering

Confidential TEXAS

Sr. SAP Business Objects / BI Developer(Jan\'11– Current) 
EDW-CUSTOMER BILLING SALES & SERVICE [EDW-CSS]
Entergy Corporation is an integrated energy company engaged primarily in electric power production and retail distribution operations. Entergy owns and operates power plants with approximately 30,000 megawatts of electric generating capacity, and it is the second-largest nuclear generator in the United States. Enterprise Data Warehouse project was build to integrate key customer, consumption, billing, sales, service, and product data into its data warehouse for analysis. Entergy also integrated 3rd party demographic and market research data from to augment its analytic capabilities. Now, through its data warehouse, Entergy Resources has an integrated and standard view of all customer activity, empowering business users to improve decision-making capabilities.
Roles & Responsibilities:

• Requirements Gathering and Business Analysis.
• Responsible for Data Analysis and Requirements Collection.
• Research Sources and identify necessary Business Components for Analysis.
• Understand the business needs and implement the same into a functional database design.
• Used Use cases for documenting the functional specifications.
• Evaluated existing legacy system shortcomings in order to identify opportunities for improvement in new system.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Extensively worked on Xcelsius 2008/4.5 for developing Dashboards for end users.
• Worked with end users to get Xcelsius dashboard requirements.
• Helped end customers to create Xcelsius Dashboards.
• Designed and implemented a data warehouse system Insight to capture the Sales and Marketing information like Calls, Samples, and Details. This system was used to Measure Sales force effectiveness and to plan sales and marketing strategies.
• Involved in creating Dimensions, Cubes and Fact tables.
• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and data specifications for Business Objects universes and reports.
• Study the existing report application, to finalize the data elements required for reporting.
• Install and configure various components of BO XI R2 on Windows 2003 Server.
• Create users/groups and define privileges and access rights using Central Management Console.
• Design and develop universe in the designer, connection to the database, classes and objects, joins and predefined conditions
• Created Aliases and Contexts for resolving Loops in the Universes to improve performance.
• Work with various types of joins such as inner-joins, outer-joins, equi-joins, theta-joins, defined cardinalities and resolved issues like loops and traps by creating aliases and contexts
• Set object level and row level restrictions, to restrict sensitive client information to concerned departments only.
• Extensively used filters, conditions, list of values (LOV), calculations, etc.
• Use @functions like @prompt (for user defined queries), @where (for creating conditional filters), @select to create duplicate objects in the process of building the universes.
• Perform Analysis with MS Office in latest SAP BO XI 4.0 through Voyager in creating Conditional Formating,Navigation etc.
• Create custom hierarchies while designing universe and making it available to end users through Web Intelligence.
• Leverage the Business Objects Universe (Semantic Layer) to make measures aggregate awareness. These changes substantially improved query performance.
• Create corporate dashboards to monitor the key metrics using Performance Management tools.
• Responsible for scheduling metrics, sets, analytics using Scheduler Interface.
• Responsible for creating real time alerts based on KPIs.
• Created various analytics such as Interactive Metric Trends, Gauges, metric list to display in dashboards.
• Used Analytics linking extensively between Analytics, webi reports by using prompts extensively.
• Worked and created analytics using Dimensioned metrics and secured them for Enterprise users.
• Created Goals/Scorecards/Strategy Maps based on KPIs to monitor business performance using Performance Manager.
• Improved Dashboard loading time by displaying analytics as refresh manual in dashboards.
• Use the drill down/up, slice and dice features to analyze data, set variables, alerts and group values in the reports.
• Generate various SAP Business Objects reports such as measure reports, change reports, highlight reports using drill down, slice and dice, cross tab, master detail etc.

Environment: SAP Business Objects XIR2/Xir3.1/Xi4.0, Web Intelligence, InfoView, DeskI, BO Designer, Crystal Xcelsius, Crystal reports, CMC, CCM, Oracle 11g/10g/9i, Windows 2003 server, UNIX.

ConfidentialScottsdale, AZ  Sr. SAP Business Objects Developer (June\'09– Nov’10)

SA Sales/SA-Sales Analyzer Data Mart.

The Dial Corporation is $1.7 billion Company and is one of America\'s leading manufacturers of consumer products, including Dial soaps, Purex laundry detergents, Renuzit air fresheners and Armour Star canned meats. The company\'s Sales Analyzer data mart is used to integrate data from daily shipments and open orders, giving Dial the capability to track and analyze daily sales performance from an actual and budgeted perspective. This data mart also provides Dial\'s field sales team with daily reports on different sales-related metrics so they can continually refine their sales efforts.

Responsibilities:

Involved in writing the Business and System Vision documents, Business and System Use Cases, Supplementary Specifications. Interacted with Fixed Income securities and Equity group specialists to identify business system needs, obtain sign-off on the Business Requirement documents. Used MS Office extensively (Word, Excel, Access, Visio, Power Point, Outlook, Project) for calculations, graphs, analysis, presentation and documentation throughout the project. Created PowerPoint presentations incorporating MS Office Suite, Excel, Word and Access. Performed the user acceptance test (UAT) and suggested recommendations for the applications. Performed Manual Testing of the application to determine ease of usability of the application. Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering meetings and documentation. Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems. Responsible for solving complex data design and data retrieval/integration issues. Analyzing the data model and Identification of heterogeneous data sources. Analyzing and documenting business requirements and business rules, functional and technical designs, test cases, user guides and data specifications for SAP BusinessObjects Universes and Reports. Worked on distribute, maintain, and optimize universes for Business Objects and Web Intelligence deployments. Responsible for managing the SAP BusinessObjects reporting environment including Administration, repository management, report specification, creation and development (report, template, Universes creation), production maintenance, distribution strategy. Conducting periodic user training for business users on slicing and dicing of power cubes, drill down techniques for extensive usage of the reports. Extensively, worked on universe performance issues, rectifying loops and in correct joins. Introduced the @Aggregate Awareness functionality in the universe. Created the Universe to be more User Interactive by defining @prompt functions and conditions with certain objects. Created various classes and objects in the universe. Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes. Defined several custom hierarchies so that the user can use various analysis functionalities during reporting easily and efficiently. Exported the universes to the Repository for making resources available to the users. Created the reports using SAP Business Objects functionalities like Queries, Slice and Dice, Drill Down, Drill By, Drill Through. Created ad-hoc and scheduled complex Reports using Crystal Enterprise10/8.5. Submitted and presented reports in user-defined formats like Tabular, Master Detail, and Cross Tab. Scheduled such reports through Broadcast Agent. Linked the Universes using Kernel approach. Interviewed business partners to determine requirements.

• Installing Desktop Products, Installing Enterprise Server Products, Enhancement and changes to Existing Universes depending on User requirements and setup coordination.
• Created ad-hoc and scheduled complex Reports using Crystal Enterprise10/8.5.

Environment: MS Office Suite, Oracle9i, SAP BusinessObjects 6.5/5.1/XI, WebI 6.5/2.6/XI, Crystal Reports 8.5/10/XI, Oracle9i/8i, PL/SQL, SQL, SQL*Plus, SQL* Loader, T-SQL, SQL Server, TOAD, ODBC, Windows XP, Windows 2000/ NT 4.0.

ConfidentialPortland, OR. 
Sr. BO/Crystal Reports Developer(Jan\'08– May’09)
U.S. Bancorp is a 250 billion dollar region bank holding company, established in 1929 in Minnesota. The company, through other subsidiaries, provides trust, private banking, financial advisory, investment management, retail brokerage services, insurance, and custody and mutual fund services. Its payment services include consumer and business credit cards, stored-value cards, debit cards, corporate and purchasing card services, ATM processing, and merchant processing. In addition, the bank is also in business of managing treasury and corporate support services consist of investment portfolios, funding, capital management, asset securitization, interest rate risk management, and transfer pricing. U.S. Bancorp primarily serves individuals, estates, foundations, business corporations, and charitable organizations. My project primarily involved in analyzing commercial loan portfolio backed by the assets as collateral. I was responsible for preparing complex collateral analysis and review reports using Crystal, MS Access and MS Excel.
Roles & Responsibilities:

• Implement the Use cases for new reports.
• Assist in planning, designing, and implementing of Reports.
• Implemented Crystal reports for standard reporting, Ad-hoc query and business users.
• Enhance the existing reports as per client requirements and business team.
• Advanced reports of varying complexity including slice and dice, drill down, cross tab, multiple table/section, and master detail type reports.
• Provide support to QA testing team to clarify changes and resolve testing issues or bugs.
• Follow-up with Client on various proposed initiatives.
• Implement the Database components (Stored procedures).
• Alter the existing stored procedures as per Design team.
• Involved in the module testing, functional testing and integration testing.
• Meeting with programmers, test engineers and product management team to gain an understanding of the business requirements.
• Designed the reports like all accounts details, cross sell, auto, home, life, commercial, umbrella and miscellaneous reports.
• Tested the reports thoroughly created by other developers, as per the report specifications.
• Written documentation for the newly created reports.
• Developed pie charts, bar graphs more understandable for top-level management using Analyzer in the reports.
• Estimate the timeframe to design the reports.
• Exported reports to document agent server to schedule and monitor reports. Created complex reports using multiple universes.
• Using XcelsiusCreated interactive dashboards Exported to SAP Business Objects Platform

Environment: SAP Business Objects Xir2/6.x, Crystal Reports 8.5/10, Crystal Enterprise 10, Oracle 10g/9i, PL/SQL, SQL Loader, SQL*PLUS and Toad

ConfidentialNY 
System Analyst/Report Developer(Sep\'06– Dec’07)
GE Power Systems is uniquely capable of supplying the world with abundant, reliable, efficient energy. From assisting with the mining of natural resources to the distribution of energy to the consumer, they are providing an expanding portfolio of innovative product and service solutions across the power generation, oil and gas, transmission and distribution, distributed power, and energy rental industries. The GE Power System’s Customer Master File (called as CMF) is a single location for enterprise wide customer information. Our team called ‘CMF swat team’ is responsible to design universe and generate report on available customer information and measures.
Roles & Responsibilities:

• Involved in the Design and Implementation of datamart.
• Worked mainly with the reporter and the designer modules of the project.
• Implemented row level restrictions according to different business group requirements.
• Maintained the development, testing and production repositories and provided round the clock support during the production stage.
• Worked on the Master Kernel and Component approach during the linking universes.
• Made use of the aggregate awareness feature to enhance the performance of SQL transactions.
• Worked towards optimal design or universes and removed loops through the use of aliases and contexts.
• Created standard full client and Webi reports.

Environment: SAP Business Objects Suite Products (BO Reporter, Supervisor, Designer, Web Intelligence, And Broadcast Agent) , SQL server 7, ORACLE 8.0, UNIX, Win NT.

Confidential
Software Engineer – Full Time (Apr’04 – Aug’06)
Project 1:EMMA a B2B portal developed as virtual market for Manufacturer and Retailer. Retail buyers would have the benefit of browsing online product catalogs from different vendors, searching for products meeting very specific requirements, getting the latest product information, creating purchase requests and routing the requests for approvals. A supplier would be able to publish product information and have it displayed to all buyers within EMMA or only to preferred buyers. 
Roles & Responsibilities:

• Involved in Design and Coding of programs.
• Involved in preparation of unit test cases for the programs.
• Involved in designing the screens and testing.
• Customer interaction during development, implementation and support.
• Involved in unit testing of the different modules.
• Involved in quality documents preparation.

Environment: HTML, Javascript, JSP, MS SQL server, IIS, Windows NT and UNIX.

Project 2: Sun America Retirement Investing System (SARIS) is the new development of existing SA’s Customer Accounting System and Customer Information System. The primary goal of SARIS is to provide the corporation with an easy to use, technologically advanced system to support its ongoing business and regulatory requirements. It also should be flexible for giving superior customer service. Understanding the new Business Logic and Business process flow. 
Roles and Responsibilities:

• Involved in development of data entry screens and report generation.
• The re-order level, safety-level, and cost for each item are stored. The stock verification function helps to keep a check on all materials in the store.
• Wrote PL/SQL stored procedures & database triggers for enforcing business rules
• Reports are generated by branch and by product-wise.
• Designed and Developed Product Installation and Leasing System with Oracle Developer 2000.

Environment: Oracle7.3, SQL, PL/SQL, Forms 3.0/4.5, and Reports 2.5, Windows95 and UNIX.