Business Objects platform.

2 Years

2012

2 - Proficient

Crystal Reports XI.

3 Years

2012

3-Expert

Oracle 10g Database.

2 Years

2012

2 - Proficient

PL/SQL.

3 Years

2012

3-Expert

ASP.NET.

2 Years

2012

1 - Basic

C#.

2 Years

2012

1 - Basic

Microsoft .NET 3.0.

2 Years

2012

1 - Basic

VB.NET.

2 Years

2012

1 - Basic

Visual Studio Team Foundation Developer's Suite.

2 Years

2012

1 - Basic

Education & Certifications:

• B-Tech in Jawaharlal Nehru Technological University, India - 2004

Employment History:
Confidential,
Crystal Reports Developer

Responsibilities:

• Involved in requirement gathering and data analysis for reporting from various business users.
• Created different types of reports like Master/Detail, Cross Tab and Charts (for analysis).
• Created Stored Procedures, Views, and Functions using PL/SQL to be used in the reports.
• Created Business Views to implement the feature of List of Values (LOVS) and dynamic cascading prompts.
• Designed Batch Processing system for crystal reports using Autosys.
• Dependency management on crystal reports using Autosys.
• Expert on Crystal Reports SP3, SP2.
• Designed Complex reports using sub reports, cross tabs and report formulas in Crystal syntax with extensive usage of Local, Global, and Shared variables.
• Created Formulae in Crystal Syntax to be used in the report and converted the formulae to custom functions if they were used in other reports.
• Created Parameterized, Cross-Tab, Drill down and Summary reports with options such as grouping, sorting, drill down and prompts.
• Created the Manual Crosstab reports with customized Grouping and Used Selection Expert to create a various filters for reports.
• Extensively involved in using of formulas fields, parameter fields, Running Total Fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Created Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.
• Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, scheduled reports for different file based / schedule based events, distributed in email, PDF and HTML format.
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Created Dashboards in Xcelsius with features such as drill down charts, Interactive Calendar components and alert methods.
• Created complex Cross Tab, Master Detail reports with Slice and Dice, Drill Down functionalities using WebI.
• Extensively used Calculations contexts, Variables, Breaks, Sorts and Alerters for creating WebI reports.
• Generated WebI reports involving complex queries, subqueries, Unions and Intersection.
• Created users, groups and folders using Central Management Console (CMC) and assigned privileges to different groups and users.
• Exported the reports developed using the Crystal Reports to the Repository.
• Worked on publishing crystal reports from InfoView.
• Scheduled the reports, maintained the events, set permissions using Central Management Console.
• Debugged existing reports when users complained of inconsistent Data.
• Optimized the Queries to improve the performance which decreased the run time of crystal reports.
• Document any changes to the existing or new reports.

Environment: Crystal Report Xi r2/2008, Business Objects XI 3.1, Web Intelligence, Xcelsius 2008, Oracle 10g/9.2, Windows 2003 Server, IIS, JD Edwards, Microsoft .NET 3.0, C++, VB.NET, Visual Studio Suite.

Confidential,
VA January 2009 – December 2010 Crystal Repots Developer

Responsibilities:

• Involved in requirement gathering and data analysis for reporting from different business users for Forecasting Reports Phase 2.
• Involved in writing the High-level and Detail-level documentation of the project.
• Created Stored Procedures, Views, and Functions using PL/SQL to be used in the reports.
• Responsible for Creating Complex and Multi Dimensional reports
• Created Master/Detail, Cross Tab, and Sub Queries Reports
• Created BU, SBU, Tier Level Reports for Brokerage Management System
• Developed Sub Reports For Drilldown reports
• Worked on Autosys 11 for designing scripts and notification processes
• Implemented Dynamic and Cascading Prompts for parameters.
• Worked on Grouping and Specified order.
• Implemented suppression formulas for drilldown reports.
• Worked with Crystal reports complete set of layout and design controls to create pixel perfect reports.
• Involved in deployment the reports to production and debugging of reports
• Extensively usen Calculations contexts, Variables, Breaks, Sorts and Alerters for creating reports.
• Monitor / tune Business Objects environment based on performance and usage levels
• Troubleshooting complex client business intelligence issues in development, test and production environments
• Participate in developing “best practices” data warehouse standards for production support environment

Environment: Crystal Enterprise 2008, BOXIR2, Crystal Report Xi r2/2008 Business Objects 3.1, Web Intelligence, BODI R2, DB2, Oracle 10g, SQL, PL/SQL, TOAD, Windows 2003, Microsoft .NET 3.0, ASP.NET , C++.

Confidential,
Crystal/BO Developer

Responsibilities:

• Involved in requirement gathering, functional and technical specifications; prepared BRD (Business Requirement Documentation), FRD, TRD and End User Training Guide.
• Frequent interaction with SME’s, Developers and coordinated with offshore and onsite development team to meet deadlines of the project execution.
• Set up client meetings, keep track project statuses and metrices.
• Involved in complete SDLC and PDLC. Handled projects with multiple volumes of data size and transactional (million records) system in different instances.
• Involved in requirement gathering and data analysis for reporting from different business users
• Created different types of reports like Master/Detail, Cross Tab and Charts (for analysis).
• Created Stored Procedures, Views, and Functions using PL/SQL to be used in the reports.
• Created Business Views to implement the feature of List of Values (LOVS) and dynamic cascading prompts.
• Designed Complex reports using sub reports, cross tabs and report formulas in Crystal syntax with extensive usage of Local, Global, and Shared variables.
• Created Parameterized, Cross-Tab, Drill down and Summary reports with options such as grouping, sorting, drill down and prompts.
• Extensively involved in using of formulas fields, parameter fields, Running Total Fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Created Period reports: shift or daily report, weekly, monthly and annual reports.
• Created Dashboards in Xcelsius with features such as drill down charts, Interactive Calendar components and alert methods.
• Debugged existing reports when users complained of inconsistent Data.
• Optimized the Queries to improve the performance which decreased the run time of crystal reports.
• Document any changes to the existing or new reports.
• Developed Perl Scripts for automation processing and monitoring Systems.

Environment: Crystal Report 2008, Crystal Report Xi r2/2008 Business Objects XI 3.1, PL/SQL, Web Intelligence, Informatica 8.1, Xcelsius 2008, Oracle 10g/9.2, Windows 2003, C++, VB.NET, Visual Studio Suite.

Confidential,
MA July 2007 – August 2008 Business objects Analyst / Developer

Responsibilities:

• Extensive use of Import Wizard for achieving migration.
• Remediation and UAT of the reports which have been migrated to new version.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created new Views and Aggregate tables for report performance.
• Received extensive testing.
• Migrated the report or object from development to Production system.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Designed Test cases for UAT of Reports for end users.
• Tuning of SQL queries for better performance.
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Designed and implemented user-interface screens using .Net technologies: ASP.Net, C# and VB.Net
• Designed Universes for the data Marts.

Environment: Business Objects 6.5/XI/XI R2, Desktop Intelligence ,Web Intelligence, CMC, Designer, Info View, Import Wizard, PL/SQL, Oracle 10g,Sql Server 2000 , Windows Server 2003, Microsoft .NET 3.0, C++.

Confidential,
India November 2005 – April 2007
Associate Software Technician

Responsibilities:

• Responsible as a techno-functional consultant for data migration, data conversion and development of operational reports. The role involves development and support work on modules like Projects, Oracle Time & Labor, HRMS, Accounts Payable and I-expense.
• Data Migration using APIs.
• Discoverer Reports on PA, HRMS and OTL modules.
• Involvement in the Design, Coding and Testing as per the Company’s requirements.
• Primarily responsible for conducting all activities relating to timesheet closure. These activities include use of Oracle timekeeper, addition of timekeeper groups, resolution of workflow related issues and entry and correction of time in projects
• Working Knowledge on Fast Formulas and Interface development.

Environment: Oracle 8i, Discoverer, PL/SQL, TOAD, SQL Navigator, PL/SQL, Windows 2003 Server, Apache Tomcat, Windows NT 4.0/2000, ASP.NET ,C#, Visual Studio Suite.

Confidential,
Data warehouse consultant

Responsibilities:

• Involved in the part of production team and worked on the issues in ETL to make some changes while loading the database.
• Involved in creating Technical Specification Document (TSD) for the project.
• Written Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage. Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Assist Customer development group with extracting and analyzing large complex data.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Participated in the group meetings discussing about the projects life cycle and implementation of the project.
• Working on various tools in congas tools like impromptu, power play and upfront to generate reports and publish them on the web.
• Involved in all aspects of impromptu, from connecting to the corporate database to setting up effective catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place.

Environment: SQL, Oracle 8i, Windows 2003 Server, Apache Tomcat, PL/SQL ERWIN 4.0, Microsoft PowerPoint, Word, Excel, Outlook, Shell Scripting, Windows NT 4.0/2000, Visual Studio Suite.