Data Crystal Reports
Resume:
Kumar Madupu
************@*****.***
SUMMARY:
More than 8 years of experience in Information Technology industry with solid 7 years of expertise in developing Business Intelligence and Data Warehousing applications.
Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as Development, Testing, Migration, Administration, Security Management and Production Support on various platforms like Windows NT/2000/XP/98, UNIX.
Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
Experience in installation, configuration and management of all the components of Business Objects suite.
Experience in BO administration like scheduling jobs, creating calendars, publications, reports migration, configuring services and servers.
Technical hands-on expertise using SAP Business Objects XI 4.1/4.0/3.1/R2/R1/6.5 (Reporter, Universe Design Too/Designer, Information Design Tool, Web Intelligence (WebI), Infoview, Desktop Intelligence (DeskI), Central Management Console, CCM, and Supervisor).
Expertise in working and implementation of Crystal Reports 2008, XI R2/XI/10/9.0/8.5, Crystal Xcelsius 4.5/2008.
Proficient knowledge on Business Objects XI architecture and new features.
Expertise in universe designing, developing and generating complex, adhoc, dashboard reports, Business Views, List of Values along with User Acceptance Test and data accuracy test.
Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, Stored Procedures, and functionalities like Combined Queries.
Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, and Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
Worked with Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
Strong experience in writing Complex Queries, Stored Procedures, Functions, Triggers, Cursors and Packages using PL/SQL and T-SQL programming in Oracle, MS SQL Server.
Expert in tuning the performance of SQL queries.
Used Publications for report bursting.
An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
Experience with all the phases of SDLC (Software Development Life Cycle) and Quality procedures and standards while executing projects.
Experience in building screens and dashboards using Crystal Xcelsius.
Experience in designing SSRS report models in Microsoft Business Intelligence Development Studio (BIDS).
Experience in publishing reports using Crystal Publishing Wizard and Crystal Management Console.
In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
Extensive Tableau experience in Enterprise environment, in Tableau 8.0 and 8.1 as a developer and analyst.
Over 3 years of work experience in creating visualizations and interactive dashboards using Crystal Xcelsius.
Adept in creating Dashboards using Crystal Xcelsius 4.5, 2008 and published them to various sources like Microsoft PowerPoint, Word and Business Objects Enterprise.
Excellent experience in creating drill down aggregated SSRS reports.
Utilized the capability of Aggregate Awareness and Index Awareness to improve query performance.
Good knowledge in ETL/Data Warehousing, Data Integration using BO Data Services XI 3.1 and Data Integrator XI.
Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
Good project coordination skills, onsite coordination and offshore team management.
Created Analytics and Dashboards using Performance Manager and Xcelsius to enable executives track progress and compare current and historical performance against established targets.
TECHNICAL SKILLS:
BI Tools: SAP Business Objects (6.1/6.5/XI R2/XI 3.1/4/0/4.1), Crystal Reports (8.5/9.0/10.0/XI/2008/2011), Crystal Enterprise 9/10, Crystal Xcelsius (4.5/2008), Information Design Tool, Universe Design Tool/Designer, Central/Crystal Management Console, Supervisor, Desktop Intelligence, Web Intelligence, Info View, ZABO, Broadcast Agent, Report Conversion Tool, Import Wizard,
Tableau Desktop 8.3, Tableau Server, SQL Server Reporting Services (SSRS)
Databases: Oracle 7x/8x/9x/10g/11i, MS SQL Server 2000/2005/2008, DB2, Teradata, Sybase, Netezza, MS Access
Database Tools: Toad, SQL Server Management Studio, Embarcadero Rapid SQL, DB2 Connect, Razor SQL
ETL Tools: SAP Business Objects Data Services 3.2, Informatica PowerCenter, SSIS, Data Integrator XI, DTS
Languages: SQL, PL/SQL, T-SQL, C, C++, Java, HTML
Operating Systems: Windows 95/98/2000/2003/2008 R2/NT/XP, UNIX, MS-DOS
PROFESSIONAL EXPERIENCE:
Nationwide, OH Feb 2012 – Till Date
BI Specialist
Participated in functional discussions and designed the ETL according to the requirements.
Converted functional requirements into logical Data Integrator/Data Services batch jobs, work flows and data flows.
Scheduled and monitored the ETL batch jobs thru Data Services Management Console.
Created Data Connections, Data Foundations, Business Elements, Business Views and List of Values using Business View Manager tool. The List of Values are used in a lot of Crystal Reports for dynamic parameters.
Involved in working with different database environments and moving up all the universes and reports between PROD, UAT and DEV environments.
Applied security features of Business Objects like row level and object level security in universes so as to make the sensitive data secure.
Designed metadata universes by setting up universe connections to the backend database, joining tables and creating classes, objects and filters.
Created Hierarchies to support drill down reports.
Defined report level ranking, database ranking and alerts in reports based on the specifications.
Used various @Functions like @Prompt (for user defined queries), @Where(for creating conditional filters) and @Select.
Created report level variables, objects and formulas to create new columns based on desired result sets.
Developed complex crystal reports by using Crystal Reports 9/XI/2008, which include the following features parameter fields, formulas, conditional formatting, subreports, multiple grouping and running totals.
Created a few Xcelsius dashboards using LiveOffice and QaaWS connections using Xcelsius 2008 tool.
Responsible for creation of publications which burst reports to various sub areas.
Several Stored Procedures, Views and Functions were created in Netezza and SQL Server database. They were extensively used in the reports for better performance.
Developed Tableau visualizations and dashboards using Tableau Desktop 8.3.
Created Tableau dashboards, visualizations and stories are distributed to end users by publishing them on Tableau Server.
Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau Desktop to highlight the value of anyatics in executive decisions
Defined best practices for creating Tableau dashboards by matching user requirements to the charts to be chosen, color patterns as per user’s needs, standardizing dashboards size, look and feel.
Created a few objectives, perspectives and scorecards in HP Executive Scorecard tool 9.3.1.
Environment: SAP Business Objects Enterprise XI 3.1/4.0, Designer, Web Intelligence, Desktop Intelligence, Crystal Reports 2008, CMC, CCM, Business View Manager, Publishing Wizard XI 3.1, Business Objects Data Services 3.2, Netezza (WinSQL), Xcelsius 2008, SQL Server 2008 R2, Oracle 11i, Windows 2008 R2, HP Executive Scorecard 9.3/9.3.1, Tableau Desktop 8.3
NetJets, OH Aug 2011 – Jan 2012
Business Objects/Crystal Reports Developer
Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.
Transformed designs and specifications into universe design and Business Objects (XI 3.1/R2) production reports.
Several complex Hyperion SQR reports have been converted to Web Intelligence and Crystal Reports using universes as main data source.
Involved in working with different database environments and moving up all the universes and reports between PROD, QA and DEV environments.
Applied security features of Business Objects like row level and object level security in universes so as to make the sensitive data secure.
Generated various report templates for standardizing the reports throughout the organization.
Designed metadata universes by setting up universe connections to the backend database, joining tables and creating classes, objects and filters.
Created Hierarchies to support drill down reports.
Defined report level ranking, database ranking and alerts in reports based on the specifications.
Used various @Functions like @Prompt (for user defined queries), @Where(for creating conditional filters) and @Select.
Created report level variables, objects and formulas to create new columns based on desired result sets.
Resolved issues like Chasm Traps and Fan Traps in universes by creating contexts and aliases. Also, resolved loops by creating aliases and contexts.
Developed complex crystal reports by using Crystal Reports 9/XI/2008, which include the following features parameter fields, formulas, conditional formatting, subreports, multiple grouping and running totals.
Several Stored Procedures, Views and Functions were created in Oracle database. They were extensively used in the reports for better performance.
Troubleshoot various reporting system errors and tuned existing reports and queries.
Involved in training end users in basic and advanced Ad Hoc reporting as well as create queries, format results, and share them with others within the enterprise and beyond using Web Intelligence.
Environment: Business Objects Enterprise XI 3.1, Designer, Web Intelligence, Desktop Intelligence, Crystal Reports 2008, CMC, CCM, Publishing Wizard XI 3.1, Oracle 10g, Hyperion SQR, SQL Developer, Windows NT/2000.
Price Waterhouse Coopers, FL Mar 2007 – Jul 2011
BO Administrator/Report Developer
Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.
Responsible for creating on-demand and schedule reports based on the business requirements.
Involved in migrating everything (users, groups, reports, rights, etc.) from Crystal Enterprise 10 to Business Objects Enterprise XI R2. Later on, independently upgraded DEV, TEST and PROD environments to the latest version of Business Objects i.e. Business Objects Enterprise XI 3.1.
Transformed designs and specifications into universe design and Business Objects (XI 3.1/R2) production reports.
Involved in working with different database environments and moving up all the universes and reports between PROD, DEV and Test environments.
Administered User Management, Server Management and Content Management.
With the help of Publishing Wizard XI 3.1, published and distributed the reports to the recipients with the help of Report bursting methods.
Created a couple of Web Intelligence and Crystal Reports job servers to balance the load on the Business Objects Enterprise server.
Troubleshoot day to day admin activities, maintenance and support.
Applied security features of Business Objects like row level and object level security in universes so as to make the sensitive data secure.
Generated various report templates for standardizing the reports throughout the organization.
Designed metadata universes by setting up universe connections to the backend database, joining tables and creating classes, objects and filters.
Created Hierarchies to support drill down reports.
Defined report level ranking, database ranking and alerts in reports based on the specifications.
Used various @Functions like @Prompt (for user defined queries), @Where(for creating conditional filters) and @Select.
Created report level variables, objects and formulas to create new columns based on desired result sets.
Resolved issues like Chasm Traps and Fan Traps in universes by creating contexts and aliases. Also, resolved loops by creating aliases and contexts.
Developed complex crystal reports by using Crystal Reports 9/XI/2008, which include the following features parameter fields, formulas, conditional formatting, subreports, multiple grouping and running totals.
Several Stored Procedures, Views and Functions were created in Oracle and SQL Server databases. They were extensively used in the reports for better performance.
Apart from report development, created other database objects like Tables and Triggers in SQL Server 2005 and 2008.
Excellent knowledge in Import/Export using DTS and BCP utilities.
Troubleshoot various reporting system errors and tuned existing reports and queries.
Converted few crystal reports to SSRS reports.
Thorough knowledge of Extraction, Transformation and Loading (ETL) tools like Informatica, Data Transformation Services (DTS), Import/Export Data, SQL Server Integration Services (SSIS).
Involved in training end users in basic and advanced Ad Hoc reporting as well as create queries, format results, and share them with others within the enterprise and beyond using Web Intelligence.
Environment: Business Objects Enterprise XI 3.1/XI R2, Crystal Enterprise 10/9, Crystal Reports 8.5/9/10/XI/2008, Crystal Xcelsius 2008, Designer, Web Intelligence, Desktop Intelligence, CMC, CCM, Publishing Wizard XI 3.1, Oracle9i and 10g, SQL Server 2005/2008, Toad for Data Analysis, Windows NT/2000.
Keystone Mercy Health Plan, PA May 2006 – Feb 2007
BO & Crystal Reports Developer
Interacted with functional/end users to gather requirements of core reporting system to understand exceptional feature users expecting with reporting system and to implement business logic.
Involved in installation and configuration of Business Objects on windows 2003 server. Created universes and various formats of reports. Created total new reporting structure.
Total system migrated to Business Objects version XI R2 from Business Objects version 6.5.
Created new users, user groups and managed their access privileges to the reports by using the Central Management Console.
Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
Transformed designs and specifications into universe design and Business Objects (XI R2/6.5) production reports.
Administering the ad hoc data environment, developing processes and standards for this environment.
Involved in designing and developing complex Web Intelligent, Client, and Ad Hoc reports for corporate data which was mainly stored in the Sybase database.
Responsible for the Extraction, Transformation and Loading (ETL) of data in Oracle which involved writing complex SQL queries.
Responsible for tuning the existing universes for time management purposes by creating alternate views and indexes.
Scheduled reports using Central Management Console.
Created Master Detail reports using Slice and Dice panel.
Responsible for trouble shooting (tuning) all existing queries and reports. Resolved loops using Aliases and Contexts.
Developed universe and reports for HR Talent review.
Environment: Business Objects (XIR2/6.5), BCA, Crystal Enterprise 10/9, Crystal Reports XI/9/8.5, Desktop Intelligence, Web Intelligence, Sybase, Oracle 9i, Windows NT, UNIX, SQL Server, Crystal Query.
EDUCATION:
Bachelor's degree in Computer Science from JNT University (JNTU), Andhra Pradesh, INDIA.
Contact this candidate