Professional Experience

• Over 8 years of IT experience in Analysis, Design, Development, Production, Deployment, project coordination and creating complex reports using Crystal Reports, Business Objects Designer, Web Intelligence, Desktop Intelligence, Xcelsius, Import Wizard, Central Management Console (CMC), Business Objects Data Services.
• Proficient in creating canned/adhoc reports from different data sources utilizing Crystal Reports, Business Objects and Web Intelligence.
• Hands-on experience in designing/enhancing Universes, customizing thin and full client reports, retrieving data using universes, personal data files, stored procedures and freehand SQL.
• Generated complex reports by linking data from multiple sources using functionalities such as Combined Queries, Master Detailed, Slice and Dice, Drilling methodology, Scope of Analysis, Merge, Filters, Ranking, Sections, Graphs and Breaks.
• Hands-on experience in migrating Business Objects applications from Business Objects 5.x/6.x to XIR2.
• Extracting data from multiple sources using Business Objects Data services and loading the data into multiple target databases.
• Scheduled the reports using the infoburst scheduling tool and scheduled the ETL batch jobs using Autosys.
• Extensive experience interacting with business users and business owners for requirements gathering, analysis of business processes, report enhancements etc
• Trained users in report development and running ad-hoc queries in Business Objects.
• Strong experience in writing Stored Procedures and Triggers.
• Experience working with multiple relational databases like Oracle and SQL Server.
• Expertise developing complex queries and programs utilizing SQL and PL/SQL.
• Hands-on experience in writing functional and technical specification documents.
• Excellent Analysis, Customer Interaction and communication Skills and ability to multi-task in a fast-paced technical environment.
• Excellent team player at all levels with ability to perform independently with exceptional analytical, presentation and problem solving skills.

Skills Set

BI Tools : BO XI R3 (3.1 & 3.2)/R2/6.x/5.x (Designer,Web Intelligence, Desktop Intelligence, Xcelsius, Import Wizard, Info View) Crystal Reports 2008/XI/10/9, Business Objects Data Services 12.2.2, infoburst, Autosys 
Languages : SQL, PL/SQL, C/Pro*C, HTML, XML
Databases : Teradata 12/13, Oracle 10g/9i, SQL Server 2005/2008 
Oracle Tools : SQL*Loader, SQL*Plus, TOAD, Query Analyzer
Operating Systems : MS Windows server 2003/98/2000/XP/Vista, UNIX

Professional Experience

Confidential., Phoenix, AZ 03/2011–Till Date
Sr. Business Objects / BODS Developer

Confidential is the world’s largest publicly traded copper company and mine geographically diverse, long-lived reserves of copper, gold and molybdenum. Freeport-McMoRan Copper & Gold have been in business since 1980 and The “Freeport” organization has roots in minerals industry going back to early 1900’s.

• Involved in the complete lifecycle of SDR, PDOE, MSAS and CSAS projects in FMI, involved in different phases of the project like Requirements gathering from Business users, participated in project sessions with the Project core Team, EDW Schema Design, EDW schema Test, Universe Design, ETL design, System testing of Universe and the Reports, Performance testing, Universe and Reports maintenance etc.
• Developed multiple Webi reports for SAP supply chain and Maintenance modules.
• Designed the global Drill and Blast universe to have a single data source for reports used by multiple sites. Also sourced the data required for this universe using business objects data services from multiple sources and loaded into the EDW Teradata system.
• Involved in the creation of Ops portal KPI’s which drives our processing systems in the mills.
• Developed various milling reports which includes the details of crush convey, Hydromet, Leaching, Concentrator etc.
• Modified multiple Universes for user reporting and developed multiple reports using these universes.
• Scheduled all the reports to burst according to the user requirement using info-burst.
• Maintained different version of the reports and universes using version manager tool and used it for publishing the report to different environments.
• Extracting Data from different sources, Transforming and loading them into the Enterprise Data Warehouse databases using SAP Business Objects Data Services.
• Also was leading the SAP DATA project where we used to load the data from multiple SAP tables into sql server which was required to support the custom apps team.
• Used to schedule all the batch jobs using Autosys and to schedule the jobs have to create the batch files and text files in the server. Had management console access to do so.
• Created various group boxes in Autosys to maintain the job schedules.
• Provided 24 hours production support during the GO-LIVE process.
• Analysis of data requirements and translation of these requirements into dimensional data models using Extended Star Schema data modeling techniques.
• Created and maintained Views, Operational Data Stores, Work flow, Data flow, Data sources, Transform objects, Transfer rules and Update rules for Data targets in the Enterprise Data Warehouse.
• Created multiple macros, stored procedures and views in the Teradata system as required.

Technical Environment: Business Objects XI R/3(3.1 & 3.2), Business objects Data Services 12.2.2, Teradata 12/13, SQL Server 2008, Oracle 10g, SAP, Toad, Version Manager 12.1, Autosys, Info burst, Windows XP.

Confidential, Omaha, NE 07/2010-03/2011
Sr. Business Objects / Crystal Reports Developer

Confidential is one of the leading companies in the printing industry. It owns 8 plants in U.S and one in Canada. This project which I worked on was to create new reports and correct the issues with existing ones for their newly migrated Radius ERP system.

Responsibilities:

• Worked on various reports for the Radius Vision-2 application with team EPIC.
• Worked with the business users and EPIC team on requirements gathering.
• Worked on work instructions report for the plant to run a job, sales order report for the customer service, Invoice report for the billing department, etc.
• Worked on the Progress OpenEdge and SQL server database to create the reports.
• Preparation of critical, Master Detail, Sub Reports, Cross Tab and Summary reports using BOXI R/3 and Crystal Reports.
• Worked with the financial team to create a Daily Production Report for each plant.
• Scheduled jobs with crystal reports and SQL server.
• Published and Participated in UAT testing and then to production after getting approval from Users.
• Performed data analysis to resolve data issues in data warehouse.
• Had to mentor few developers with advanced reporting techniques.
• Involved in design, development, and maintenance for supporting ad hoc queries and canned reports.
• Provided 24 hours production support during the GO-LIVE process.
• Developed various PL/SQL programs like Anonymous Blocks, Stored Procedures and Packages to automate processes.
• Created Materialized views for better performance of the reports.
• Coordinated with the remote team members, provide work guide lines and participate in resource management.

Technical Environment: Business Objects XI R/3, Crystal Reports 2008, SQL Server 2008, Progress Open Edge 2009, Toad, Windows XP.

Confidential, (Chicago IL) 08/2008-07/2010
Sr. Business Objects /Crystal reports Developer

Confidential owns and operates three leading businesses in the online classified advertising space: Apartments.com, Cars.com, and HomeGain.com. It also works with its affiliate partner, HomeFinder.com.

Responsibilities:

• Worked on Various reports for Cars Intelligence Agency (CIA). Coordinated with the Corporate BI team and worked with the business users and CIA members on requirements gathering.
• Utilized BO and Crystal Reports to develop CPO OEM dealer reports which give product information whether dealer has different products like NLP, video showcase, used and new car specials, power position, multiple photos, used vehicles and CPO vehicles count etc
• Worked on Dealer special reports for product management team which provides the sold vehicles information and Dealer special metrics and Leads and contacts for each dealer and affiliate.
• Automated Video Show Case Exception reports in info view where DM used to run manually every month.
• Utilized Visio for creating dataflow diagrams and subject area documentation for inventory, lead, impressions etc.
• Modified legacy conversion lead reports to use the new universes and data marts.
• Worked on Cars Legacy Database/Corporate Data Warehouse.
• Worked on Cars Legacy database to create reports for the Dealer Product team.
• Maintained user’s licenses, assisted power users in BOXI when creating new reports; attended prioritization meetings for project intakes.
• Developed Reports and published them to Crystal Enterprise XI R2 for viewing on the Web.
• Performed SQL Tuning using EXPLAIN_PLAN, SQL Hints, SQL trace and TKPROF.
• Utilized SQL*Loader and Data Pump to move large datasets across databases.
• Coordinated with the team manager with constant updates about the intakes and projects.
• Provided Production Support for BO application. This involved fixing bugs, data issues, report failure issues, scheduling issues etc. All the incidents are tracked in team track to provide LOE for users.

Technical Environment: BusinessObjects XI R2, Crystal Reports XI R2, Oracle 10g, Flat files, SQL Navigator, Erwin, Cygwin, Putty, Microsoft Visio, Windows NT/2000 and UNIX.

Confidential, NEWARK, NJ 10/2006 - 07/2008 
Business Objects /Crystal reports Developer

Confidential. provides insurance, investment management and other financial products and services to both retail and institutional customers throughout the United States and in over 30 other countries. Principal products and services provided include life insurance, annuities, mutual funds, pension- and retirement-related investments and administration and asset management.

The main functionality of the project was to view/edit/submit for Returns Calculation of each customer. Data was extracted from various Data sources (13 different Sources). Available data was submitted for Calculation. The users (Under Writers) may view the Calculation Results, make changes, resubmit for Calculation and Authorize the Returns Calculation.

Responsibilities:

• Analyzed the reporting requirements with business users and come up with technical specs.
• As a part of Universe designer team, created Semantic Layer, went through two different levels of Database.
• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks.
• Created Classes and Objects taking the information from the database. Also created measured objects. Checked the Cardinalities, Contexts, Joins and Aliases for resolving Loops and Data Integrity of the Universes.
• Created and maintained Web Based reports using Web Intelligence and Scheduled through BCA Scheduler.
• Exported the universes to the Repository to make the resources available to the users.
• Exported business object reports to Web Intelligence to be viewed by all users on the Internet.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created reports utilizing various Business Objects features like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail, Formulae etc.
• Interacted with Business Users and End Users in understanding the existing reports, making enhancements to them, requirements for new reports, UAT testing etc.
• Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• Utilized Web Intelligence to generate reports on the internet/intranet.
• Created reports using Crystal Reports with Grouping, Sorting, Formula fields and Parameter fields.
• Demonstrated strong analytical and presentation skills, onsite/offshore coordination.
• Exported reports to the Broadcast Agent and Used the Broadcast Agent to Schedule, Monitor and Refresh Reports.
• Provided Production Support and also provided training to the users.
• Developed Stored Procedures, Packages and Triggers to automate processes.
• Utilized EXPLAIN_PLAN, SQL Hints and SQL trace to identify bottlenecks in SQL Performance and tune poorly performing queries.
• Utilized SQL*Loader for loading data into tables.

Technical Environment: Oracle 9i, MS Access, Business Objects 6.5x, Crystal Reports, SQL Server, Toad, Windows XP, Web Intelligence 6.0.

Confidential, Auburn Hills, MI 08/2005 - 09/2006
Business Objects Developer

This application captures the project & resource expenses at Chryslers marketing Division. Reports & graphs were built for a Management view for capturing various business scenarios.

Responsibilities:

• Created & maintained the reports using Business Objects and custom reports using Oracle SQL.
• Created report templates to maintain a uniform standard across all the reports.
• Defined the loading strategy for including Aggregate tables.
• Created variables, formulae and detail objects at report level.
• Involved in design, development, and maintenance and testing universes for supporting ad hoc queries and canned reports.
• Involved in scope definition, design/development and deployment of Enterprise wide BI solutions.
• Set up hierarchies in the Universe for providing drill down options in the reporting environment.
• Utilized Aggregate Awareness concept in the creation of objects.
• Created filters, prompts, conditions.
• Created reports on OLTP system.
• Created reports in both full client and Webi facilitating drilling down.
• Tuned the universe for optimum query performance.
• Took charge of the complete design and development of universe, reports and dashboards.
• Administered users and security.
• Trained developers on Universe & report creation.

Technical Environment: Oracle 9i, DB2 UDB, Business Objects 6.1a, Designer, Supervisor, Web intelligence, Windows XP/2000, Visual Basic 6.0.

Confidential, NJ 08/2004 - 07/2005 
Business Objects Consultant

An information system that delivers critical, high-level business information to executives who were monitoring the status of the organization. This decision support system is more inclusive and applies to a system that aids in decision making, often focusing on delivering ad-hoc data analysis. This is an efficient component for the organizations, used for reaching their customers and for distributing information among customers, suppliers, and vendors.

Responsibilities:

• The Finance Analysis and reporting solution: Financial reporting delivering comprehensive Financial reporting including income statements, balance sheets, cash flow analysis and a host of other capabilities to empower companies to take control of their business operations.
• The Sales Analysis and Billing reporting solution: Customers want full access to all the information and functionality they need to serve themselves. This system is a complete application for business intelligence that gives users the tools they need to analyze sales, marketing and other corporate data.
• Performed in depth analysis and data & prepared weekly, biweekly, monthly reports by using Business Objects.
• Designed & developed various departmental reports by using Business Objects.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Managing the report deliverables and the project timeline.
• Gathering the functional specifications for the financial reports needed for the business.
• Scheduled Documents on daily, weekly, and monthly bases.
• Developed Business Objects reports with multiple currency conversions to enable global deployment of the reports.
• Involved in developing PL/SQL scripts in case bad data is loaded into the Oracle Tables.
• Understood basic business analysis concepts for logical data modeling data flow processing and database design. Utilized skills for problem solving.
• Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
• Performed Data Modeling by using Visio, Erwin.

Technical Environment: Business Objects 5.1, Oracle, Erwin, Visio, HTML, Windows NT

Confidential 01/2004 - 06/2004 
Oracle Developer

Confidential Techno Labs specializes in the business of providing Software Outsourcing& Offshore Software Developmentservices to its clients globally. Worked with local/offshore development project and overseas client handling.

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Used Oracle 9i features such as merge for various transformations.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Performed uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Creating Test scripts for the generated final Reports.
• Involved in data migration from SQL Server to Oracle 9i.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Attended meetings and review to discuss current issues and processes to tackle issues.

Technical Environment: Oracle 9i, PL/SQL, SQL*Loader, Windows 2003, UNIX, SQL SERVER-2000, TCP/IP, T-SQL.

Education

Bachelor of Engineering, Confidential University