SUMMARY

• Highly qualified Business Intelligence Developer having over 7 years of software development experience within several business areas.
• Results - focused with proven ability to plan, design and develop quality software solutions to support reporting and Business Intelligence initiatives. A trainer and leader with strong communication skills and the ability to solve complex problems, lead development teams, improve data management and integrate systems.
• Extensively worked as a Business Intelligence Developer on Data Warehousing projects. Worked on installing and configuring BI Tools, developing reports, universes from various databases Oracle, SQL Server and Teradata.
• Expert in creating database semantic layers (Universes) and developing Decision support Reports using Business Objects, Desktop Intelligence, Web Intelligence and Crystal Reports.
• Experience in designing and developing the Universe (business view of the database), developing canned/ad-hoc reports, scheduling the processes and administering the BO activities.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle, Teradata and SQL Server.
• Good communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills, Good Technical writing skills.
• Expert in designing Disaster Recovery and Performance optimization techniques.
• Experienced in applying patches/fixes & performing Upgrades, environment sizing, Performance tuning & troubleshooting.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle, Ingres, Teradata and SQL Server.
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions.
• Good experience in Performance and Memory utilization analysis.

TECHNICAL SKILLS

BI Tools: SAP Business Objects (XI R2/XI 3.1/4.0), Universe Designer/Semantic Layer, SAP BW, BEx Query designer, BEx Analyzer, Central Management Console, Desktop Intelligence, InfoView, Web Intelligence, Crystal Reports (2008/2011), Xcelsius 2008, Qlikview 10.x/11

Operating Systems: UNIX (HP, Solaris, AIX), Windows 9X/2KX/NT/2008, Linux (Red Hat)

Databases: Oracle10g/11i, Teradata, DB2, SQL Server and MS Access

Database Tools: TOAD, Rapid SQL, SQL Developer

Other Tools: SQL*Plus, MS Office XP, MS Visio, MS Project, PowerTerm, Visual Terminal, Putty

Programming Languages: C, C++, SQL, HTML and PL/SQL

Web Servers: Tomcat, BEA Web Logic, IBM WebSphere, Microsoft IIS

ETL Tools: SAP Business Objects Data Services XI 3.1/4.0, Data Integrator XI

PROFESSIONAL EXPERIENCE

Confidential, Winston Salem, NC

SAP Business Objects and Crystal Reports Developer

Responsibilities:

• Designed and implemented the security model for the Business Objects BI 4.1 and Crystal enterprise environments.
• Designed new Access Levels in SAP BI 4.1 environment to implement user, application and folder level security on Central Management Console (CMC).
• Upgraded 400+ existing Crystal Reports to Crystal Reports 2011 in Crystal Enterprise XI release 4.
• Re-written the Oracle/DB2 stored procedures that were used in the ETL processes for daily data load.
• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Implemented Object and row level security in Universe to in corporate security at Business level.
• Developed, Tested, Promoted and Maintained the Web Intelligence Reports, also had modified the existing reports based on user requirements.
• Re-created the reports from scratch in Crystal Reports 2011 which have performance issues.
• Worked on Performance improvements for the existing Crystal and WebI reports.
• Worked on SAP Information Steward 4.0, Data Quality Management, Metadata Management, Data Profiling and, Data Quality.
• Configured Metadata Manager to read and analyze large volume of BOE metadata.
• Developed Xcelsius/SAP Dashboards presentations, visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.
• Built multi variable what-if analysis bar charts for all information at one glance about all product lines of the company.
• Followed best principles and made some major workflow changes and successfully reduced Dashboard load times.
• Scheduled the reports to the users, gathered the feedback from them and made changes as per the requirements.
• Monitored, provided production support and application maintenance for Crystal Reports 2011 deployment.
• Performed regression testing for all the reports and documented the changes.

Environment: SAP Business Objects Enterprise XI R2/4.1, InfoView, BI launchpad, Business Objects Central Management Console, Crystal Enterprise XI/2008/2011, DB2 9.x, Oracle 10g/11, Web Intelligence, DB2 Connect, RapidSQL, Windows 7.

Confidential, Atlanta GA

SAP Business Objects Developer

Responsibilities:

• Implemented Full life cycle: Design, development, deployment and support in developing rich professional dashboards to present operational HR data using SAP Xcelsius.
• Designed and implemented the security model for the Business Objects BI 4.1, BOE XI 3.1 and Crystal enterprise environments.
• Migrated Business Objects Enterprise XI 3.1 environments to new SAP Business Objects 4.1 environments.
• Designed Universe semantic layer, data model and OLAP cubes.
• Created SAP Business Objects Web Intelligence, Crystal Reports based reports and customizations.
• Created Rich web based reports in online and offline mode with highly flexible query capabilities like Queries and sub queries, Report filters, freestyle input, Query enhancements and Alerting.
• Monitored, provided production support and application maintenance for SAP Xcelsius deployment.
• Developed rich professional dashboards to present operational HR data.
• Implemented What if scenarios and simulations for comparisons and transformed Complex business data into simple actionable visual presentation.
• Created compelling dashboards with usage of country maps, charts, graphs, knobs, animation of data sequences and rich imagery.
• Implemented Xcelsius dashboards distribution, publication, SAP BO Xcelsius security and report authorizations.
• Involved in conversion of existing Xcelsius dashboard to Qlikview dashboard.
• Identified data sources and prepared data for Qlikview dashboards.
• Designed, created and maintained Qlikview applications.
• Developed Qlikview Scripts to build model across multiple data sources.
• Designed SAP Business Objects Data Services workflow package and built static Dashboards using Crystal Xcelsius 2008 with the data in Excel files.
• Created reports for SABA LMS 7.0 cloud using the Crystal Reports, SABA Adhoc Reporting, SABA Analytics and the Data Exports.
• Used Business Objects Data Services XI 3.1 in creating various processes, data flows, and Data Marts.
• Developed SQL and PL/SQL scripts to implement business logics of database through Stored Procedures.
• Worked on enhancements to existing reports, creation of new reports in a productive SAP Business Objects instance as part of post-implementation support.
• Worked with Business Users on regression testing the Enterprise Reports.
• Effectively prepared and customized the training documents, White papers, Best Practices, Template documents.

Environment: SAP Business Objects BI 4.1, Information Steward, Lifecycle/Promotion Management, Upgrade Management Tool, Business Objects Enterprise XI R2/ XI 3.1, SAP Dashboards (Xcelsius 2008), Qlikview 10.x/11, Live Office, QAAWS, Business Objects Data Services XI 3.1, Oracle 10g/11i, SQL Server 2005, Tomcat, PL/SQL, SABA LMS 7.0, Crystal Reports 2008, Web Intelligence, SQL Developer, TOAD, Windows NT/2000.

Confidential, Albuquerque, NM

Business Objects Developer

Responsibilities:

• Installation, migration, configuration, maintenance, technical support and troubleshooting of Business Objects Enterprise platform and Crystal in a shared environment.
• Leveraged Business Objects tools to make best use of resources and ensured optimum performance of the tool.
• Defined architecture standards and best practices for BO implementation and conceived reusable frameworks for BO and get them developed.
• Designed and implemented Business Object Web clustering infrastructure design.
• Migrated Business Objects Enterprise XI environments to new Business Objects XI 3.1 environments that included conversion of reports. Identified and resolved the production issues arising from the migration.
• Performed tuning on the Business Objects Enterprise performance and implemented the load balance on the servers.
• Monitored the Business Objects Enterprise servers and created alert scripts.
• Used Crystal Reports to create reports that connect to Business Objects Universes with minimal effort.
• Created multiple Universes for ad-hoc and canned reports based on the relational data model that will replace the existing Stored Procedures as the data sources.
• Solved schema-designing problems by creating aliases, defining contexts and using features available in Designer to separate queries on measures or contexts
• Implemented the Index Awareness and Aggregate Awareness for faster query responses and thereby improving the report performance.
• Implemented Object and row level security in Universe to in corporate security at Business level.
• Demonstrated Crystal's strength by enhancing the report performance the reports mainly by universes to develop Crystal Reports.
• Created Master/Detail Reports, Cross-tabs, Charts and Applied slice-and-dice, implemented different level of hierarchies for drill techniques.
• Developed and tested the reports based upon data generated by IHS transaction and customer information systems using Crystal Reports.
• Performed QA on the reports, data to make sure they are on par with the reporting specifications.
• Involved in conversion of Crystal Reports using stored procedures and views to the reports using the new universes created.
• Worked with Business Users on regression testing the Enterprise Reports.
• Optimize and improve the performance the performance of existing data warehouse and BI applications.
• Conducted user end training to the users to make them understand the data models, building queries using Universe and use the Business Objects tool.

Environment: SAP Business Objects Enterprise XI 3.1/ XI R2, Crystal Enterprise XI/2008, DB2 8.x/9.x, Web Intelligence, BO SDK, DB2 Connect, TOAD, RazorSQL, Performance Management, QAAWS, Windows 2008.

Confidential, Tampa, FL

Business Objects Developer

Responsibilities:

• Supported the infrastructure for a Business Objects Enterprise system spanning several clustered environments and supporting ~6000 users. This includes support for Business Objects XI 3.1, and covers many SAP Business Objects products including: Crystal Reports (with Business Views), Web Intelligence, Performance Management, and Crystal.
• Involved in a huge migration effort from Crystal Enterprise 10 environments to new Business Objects XI 3.1 environments that included conversion reports. Created and maintained Enhancement, Bug tracking and Bug fix documents.
• Designed and implemented the security model for the BOE XI 3.1 and Crystal enterprise environments.
• Used Business Objects Data Services XI 3.1 in creating various processes, data flows, and Data Marts.
• Developed SQL and PL/SQL scripts to implement business logics of database through Stored Procedures.
• Involved in the design/development of ETL and batch load data processes. This included design and development of efficient Star-Schema designs to support Enterprise and Customer Specific Data Marts.
• Assisted the team with training, design and architecture of day to day and project tasks.
• Worked on performance tuning the various jobs and workflows.
• Created Business Views and Universes for canned reports based on the relational data model and exported to repository. Implemented row level and object level security within the universe.
• Developed complex high visibility Xcelsius dashboards to monitor standard KPI metrics. Developed single and multiple dashboards and scorecards.
• Built static Dashboards using Crystal Xcelsius 2008 with the data in Excel files.
• Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.
• Responsible for detailed knowledge of data coming from SAP modules: FI, SD, MM.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
• Designed the BEx Queries in the BW Environment.
• Extensively used BEx analyzer to create queries, variables, filters, calculated key figures, restricted key figures, charts and workbooks.
• Built Xcelsius Dashboards with SAP BICS Connector using SAP BW Queries to get data from SAP BW.
• Developed Crystal Reports from SAP BW (Business Warehouse) using BEx Query as the extraction tool.
• Created Dash boards for the top level Management using SAP BW (Bex queries).
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Worked on Bex Analyzer to test the above mentioned Xcelsius Dashboards, Webi Reports & Universe, to verify & test the Consistency of data all throughout the SAP BW & SAP BOBJ Platform.
• Updated the static models with live data connecting via the Web Service connectors like QAAWS.
• Created complex reports using the multiple data providers and reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Developed Live Office functionality, presentation layer and worked on navigation.
• Trained Power users/End users to use the tool and create Ad-hoc business objects reports.

Environment: Business Objects Enterprise XI 3.1, Business Objects Data Services XI 3.1, SAP BW, SAP FI/MM/SD, BEx Query designer, BEx Analyzer, Crystal Enterprise 10, DB2 8.x/9.1, SQL Server 2005, Tomcat, Weblogic, CA Datacom, PL/SQL, Crystal Reports 10/2008, Web Intelligence, BO SDK, WebiSDK, DB2 Connect, TOAD, Performance Management, Xcelsius 2008, QAAWS(Query As a Web Service), Lawson ESIS, Windows NT/2000,UNIX(HP), MS Project 2007.

Confidential, Atlanta, GA

Business Intelligence Lead

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues.
• Plan, Coordinate and execute Business Objects XI/XI R2/XI 3.1 deployment for End users.
• Created Universe for ad-hoc and canned reports based on the relational data model and exported to repository.
• Implemented Object and row level security in Universe to in corporate security at Business level.
• Managed User, Group and Object-Level Rights, Scheduling, Security Settings, Universes, Data Connections, User and Group creation using the Central Management Console.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Dashboards to monitor business performance, insightful analytics and role-based dashboards using Business Objects Xcelsius. Created Query as a Web Service on top of relational databases, created excel functions and linked dashboards
• Created various reports with multiple data sources, dynamic crosstabs and drilldowns using Crystal Reports XI, DeskI and WebI.
• Migrated all the reports, universes and security setting from Business Objects XI R2 to XI 3.1.
• Created dashboards using different analytics like Interactive Metric Trends (IMT), Speedometers, Metric Trees, Maps, Pareto Charts and Traffic Lights across the sliced metrics.
• Created Aggregated Tables at various levels in the universe to improve the performance of the reports and the dashboards and wrote the stored procedures and packages at the back end for these aggregated tables.
• Created/enhanced catalogs and set user profiles to grant user permissions for querying.
• Used Web Intelligence for web based query and reporting.
• Created complex reports such as Monthly/Weekly KPI reports, User Conversion and Retention reports, High Usage reports using DeskI and Crystal Reports XI.
• Created Hierarchies to provide drill down options for the end-user.
• Customized Business Objects Infoview using Business Objects SDK.
• Created and developed Stored Procedures and packages in Oracle and Teradata.
• Conducted user end training to the users to make them understand the data models and use the Business Objects tool.

Environment: Business Objects (XI/XI R2/XI 3.1), Oracle 10g/11i, Teradata, PL/SQL, Crystal Reports XI, Web Intelligence, Embarcadero Rapid SQL,DB Artisan, TOAD, BTEQ, Data Integrator XI, Performance Management (Dashboards), Windows NT,UNIX.