SUMMARY

• Over 12 years of experience in Software Development Life Cycle, Reports Development and windows server administration
• Extensive experience in Business Analysis and Business Intelligence/Enterprise Reporting solutions delivery using tools like Crystal Reports, Crystal Enterprise and Business Objects
• Strong experience in Data Analysis, developed Ad - hoc reports and complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail, etc
• Experience in working with Web Intelligence 4.0
• Experience in Logical and Physical Data Modeling including Star Schema and Snowflake Schema, designing of DATA MART, FACT and Dimension Tables using Erwin
• Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server, Teradata and Flat files
• Expertise in writing and implementation of the Package, Triggers, Stored Procedures, Functions, Views, Materialized Views, Indexes at Database level and form level using PL/SQL and Oracle
• Strong technical and working experience with Business Objects Enterprise Administrator Launch pad, Central Management Console, Central Configuration Manager, Business Objects Repository, Business View Manager, Migration Wizard, Publishing and Import Wizard
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role

TECHNICAL SKILLS

• Business Objects XI R4 (Web Intelligence, OLAP Intelligence, Desktop Intelligence, Designer, Info view, Central Management Console, Central Configuration Manager), Crystal Reports 2008, 2013, ETL (DI), IBM Rational
• DB2, SQL, PL/SQL, VBScript, JavaScript, SQLPLUS, Transact-SQL
• Oracle 10g, MS SQL Server 2000, 2005, MS Access 2000
• Top DB2
• Windows 2003, Windows XP, Windows NT 4.0, UNIX
• ASP 3.0, ASP.NET 2.0, VB 2005.Net, ADO.NET, OLAP, ActiveX, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential

Sr. Reports Developer

Responsibilities:

• Create Web Intelligence (WebI) ad-hoc and canned reports
• Ensure report accuracy and perform data validation and analysis using SQL.
• Worked on complex (Crystal Reports 2016) reports that require running totals, sub-totals, sub-reports, and cross-tab and conditional display of groups, fields
• Creating Documents with queries, restricting data return by queries, Designing Web Intelligence documents, formatting documents, calculating data with formulas and variables and analyzing data in drill mode
• Advanced SAP BO 4.x (Universe Designer, Information Designer Tool, Web Intelligence Rich Client)
• Proven experience in BO Universe Design/Universe Development using IDT
• Convert Docgen Reports to crystal reports
• Convert Jreports to Crystal reports
• Wrote various sql queries using joins and sub queries in DB2 database to develop Stored procedure for reports
• Worked on Central Management Console for managing, deploying and configuring the entire infrastructure
• Worked on Business Object Universes
• Involved in the designing and Building of Classes and objects
• Changed List of Values (LOV) in the universe prompts
• Exported the universes to the Repository to make resources available to the users
• Involved in configure the database connections, parameters and scheduling the reports in different BOXI environments
• Developed Web Intelligence documents to get the detailed Data
• Convert Docgen Reports(WordPerfect) to Crystal Reports 2008

Confidential

Sr. Reports Developer

Responsibilities:

• Worked with the end users and higher management to gather requirements for reports and data analysis
• Designed and developed different kind of new crystal reports for various modules like Credit, service Billing, Finance, Journal Entry etc.,
• Created Database Objects including Database Views, and Stored Procedures in incorporating business functionality
• Developed reports from sequential files
• Created ODBC and defined sequential file formats to get the data from sequential files into reports
• Published Reports into Business Objects Enterprise using Crystal Reports

Confidential

Sr. Reports Developer

Responsibilities:

• Worked on complex (Crystal Reports XI) reports that require running totals, sub-totals, sub-reports, and cross-tab and conditional display of groups, fields and alerts
• Wrote various sql queries using joins and sub queries in Oracle database to develop Views for reports
• Worked on Central Management Console for managing, deploying and configuring the entire infrastructure
• Worked on Business Object Universes GL Data Mart and Security Data Mart
• Involved in the designing and Building of Classes and objects
• Detected cardinalities, loops, and checked the Integrity of Universes
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context
• Changed List of Values (LOV) in the universe prompts
• Exported the universes to the Repository to make resources available to the users
• Involved in migrating the reports to BOXI Development, Testing and User Acceptance Environments
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, and Query Prompt
• Involved in configure the database connections, parameters and scheduling the reports in different BOXI environments
• Developed Web Intelligence documents to get the detailed data for different Income Statement and Balance Sheet reports and migrated to BOXI environment
• Developed Drill Down Reports and used Open Document Syntax in Crystal to get the drill down functionality for the report
• Worked with FAPT Reporting Infrastructure Team to resolve some performance issues while running reports from BOXI Enterprise
• Involved in developing Report Design documents with most recent requirements for all the reports
• Extensively worked on defect tracking tool Rational Clear Quest
• Involved in internal QA (Unit Testing) and Shake outs (Smoke testing) of the reports
• Developed ‘Data Validation Report’ and ‘Three-way Restatement Reporting Automation Data Validation Reports’ by using VIEW from ORACLE native server in Crystal Reports. These reports show a comparison and validation of summary data between the People Soft GL and Essbase and GL Data mart

Environment: Business Objects Enterprise, Designer, Crystal Reports XI, Oracle 10g, Toad 8.5 Rational Clear Quest, Windows XP Pro

Confidential

Sr. Reports Developer

Responsibilities:

• Developed Risk Assessment Reports in Crystal Reports 10.0
• Created Custom Functions, Manual Running Totals, Stored Procedures, Complex Formulas and complex data and sub Reports in Crystal Reports 10.0 for the Client.
• Created the Web Reports in Crystal Enterprise 10.0
• Created universe with star schema and maintain the universe
• Created Reports On-Demand, Scheduled, and Ad Hoc Reporting
• Developed Security Snapshot Reports
• Developed Internal Risk Assessment Reports
• Developed Cross-Tab Reports
• Wrote a number of VB programs involving ODBC to access SQL databases
• Wrote VB and DHTML programs using Web Classes for ASP pages to interface between Users and databases
• Programmed data entry terminals in VB to scan barcodes of order forms / enter data into SQL database