Experience Summary

• 12 years of Professional work experience in the IT industry in analysis design, development and maintenance of various software applications mainly in SAP Business Objects, Crystal Reports, Oracle and SQL Server.
• Hand on Experience in Business Objects Crystal reports and SQL Commands.
• Expertise in Business Objects Universe designer, Webi and Crystal Reports.
• Expertise in the various components of BEx Reporting viz. Analyzer, Browser, and Web Application Designer.
• Expertise in areas of BEx. Analyzer Queries, Workbooks, Web templates and Web Reports, structures, variables, calculated key figures, restricted key figures.
• Experience in the maintenance of Information Warehouse and good acumen in troubleshooting performance tuning.
• Good working knowledge in SSRS, SSIS, DTS.
• Capable of working in team as well as independently with excellent communication, interpersonal and analytical skills, ability to work under pressure in fast-paced environments.
• Extensively wrote several PL/SQL procedures, functions and packages in Oracle
• Created several dynamic SQL queries to fetch data for reporting purposes.
• Exposure in SAP BI skills includes Info objects, Info cubes, DSO, Multiprovider, Infoset, ETL, BODS, Generic Data Extractions, Infoset Query Extraction, Business content.

Technical Skillset

• RDBMS : Oracle 10,9i/8i/7.3, SQL Server 2005/2008 and MS Access, MYSQL
• Web Servers : MS IIS, Tomcat4.1.24
• Languages : SQL/PLSQL, XML, XSL, VBScript, HTML
• Operating System : WINDOWS 95/98/XP/NT/2000/7
• Report Tool : SAP Crystal Reports, SQL Server Reporting Services
• SAP Business Objects : Universe, Webi, Deski, Crystal Reports, Xcelcius

Projects Details:

Confidential

Crystal Report Consultant

This project is to design, build and develop reports from Electronic Toll Confidential System. I mainly worked on development and maintenance of des a variety of reports for tracking revenue tag handling, customer accounts, violations and transactions. We developed various kinds of reports for Confidential projects like Casual Use Report Q8M , ETC Toll Posted by Lane Plaza Q4P , Processor Reconciliation Report F3M , Violation Image processing, Toll Violation mismatches by plaza/lanes, Tag Status Report, Payment Details Reports, Revenue Reconciliation Report, DMV Request and Reject .

Responsibilities

• Develop, build and deploy complex reports involving formulas, dynamic parameters, cross-tabs and sub reports.
• Created Daily, Weekly and monthly reports using Crystal Reports.
• Scheduled automatic generated reports in Crystal Server.
• Developed different kinds of reports such as Sub Reports, Charts, Crosstab reports, Linked Reports
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Crystal Reports.
• Played an active role during the requirement gathering, analyzing and designing of the system.
• Responsible of monthly reconciliation Q13 Revenue Reconciliation reports which need to be submitted before every month first seven business days to the agencies.
• Analyzing PDR Details and Summary report every month for the Q13 Reconciliation.
• Analyzing Account Details, Toll summary, GL Summary every month for the Q13 Reconciliation.
• Analyzing 16A Truck Volume discount report with Q13 for monthly reconciliation.
• Analyzing F3M with PDR for the monthly reconciliation.
• Analyze Q8M. Q4P and F3M report with Q13 for Monthly reconciliation.
• Analyze Q13 direct revenue with F3M for monthly reconciliation.
• Analyze 61 and 62 report with Q13 for monthly reconciliation.
• Analyze PDR Payment summary by Payment Type 57 with Summary by Transaction 58 for Q13 reconciliation.

Environment: Crystal Reports XI, CMC, Business Objects, Webi, Oracle, PL SQL Developer Confidential Crystal Report/SQL Consultant

This project is to design, build and develop reports from various health care application like ARCS Automated Reimbursement Clinical Solution , Confidential like Omnitrope weekly referral report, NPS Gattex Weekly Report, Therapeutics LPAH oral drug report, Janseen Daily Task Report, Fulfillment Reconciliation report, fulfillment request matches with the acknowledgement recd daily report.

Responsibilities

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document.
• Develop, build and deploy complex reports involving formulas, dynamic parameters, cross-tabs and subreports.
• Analyze the requirement and prepared the specification document.
• Developed various operational Drill-through and Drill down reports using Crystal Reports.
• Worked on conversion project from access database reports and oracle reports to Crystal Reports
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Crystal Reports.
• Played an active role during the requirement gathering, analyzing and designing of the system.
• Created sql queries to fetch data for reporting.
• Followed HL7 standards and Message Validation.
• Migrated existing application from MS-Access to Oracle and Crystal Reports.
• Created DTS packages for Data migration and transformation from oracle/access/Excel to SQLServer.
• Created stored procedures, packages, function and cursor management and exception handling.

Environment: Windows Scripts/log, Crystal Reports XI, 2008,Webi, Universe, SQLServer 2008, Oracle 10g

Confidential

Tech Analyst

The project is to design and implement International trade management and applications that aid importers and exporters to manage their international trade processes. Custom imports interface application called Trade-Sense. The application simplifies duty calculation and clearance for the imported goods. The program has four main components each designed to help with a specific aspect of trade such as Import, Export, Reconciliation and Confidential Used Agile Methodology in developing Trade-sense customs application.

Responsibilities

• Designed and developed reports cross tab reports, reports with sub reports. Wrote several sql queries to accomplish this task.
• Developed drill down reports using Crystal report and developed various chart reports.
• Created Crystal Reportsusing Formulae, Grouping, Parameters, selection Criteria.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Crystal Reports.
• Prepared detailed workflow charts and diagrams using Visio to illustrate sequence of steps the program must follow and describes, input, output and logical operations involved.
• Reviewed developed code with respect to coding standards and designed and created.
• Several reports were generated using Reports and user can customize at run time and spool to printer by not waiting for the printer to complete printing.
• Extensively wrote several PL/SQL procedures, functions and packages in Oracle during the course of development.
• Created several dynamic SQL queries to fetch data for reporting purposes.
• Took the responsibility to write test Scripts and testing them.
• Involved in writing SQL Scripts for adhoc queries and providing the reports to the management.
• Support to development team to optimize SQL Performance. Creating hints for optimal query performance and analyzing execution plans.
• Worked with QA team to resolve bugs with a very less turnaround time.
• Set filters, suppression formulae and used highlighting expert to show the data the user would like to see in a more concise and presentable format.
• Provided user/system documentation, user training and testing of reports for final deployment.
• Worked along with the business users and provided report analysis and design.

Confidential

Design Analyst

Importers software services has this Custom imports interface application called Trade-Sense. This application simplifies duty calculation and clearance for the imported goods. It has four main components each designed to help with a specific aspect of trade such as Import, Export, Customs Brokerage and Trade-Sense application was written in Visual Basic 6 and supports Oracle MS SQL databases, and reports generated using Crystal Reports. Responsibility included study the existing system to migrate to VB .NET.

Responsibilities:

• needed from the report.
• over to the application integration.
• Discussed with Custom representatives, the custom related procedures documents for different countries, cargo release, custom forms etc.
• To understand better of the existing application, participated in the meetings discussions with the developers.
• Discussed with Custom representatives, the custom related procedures documents for different countries, cargo release, custom forms etc.
• Wrote the functional specification documents and Cascading Style Sheets CSS for User Interface that used by the application.
• Help restructure the database to improve response time and query efficiency, performance of the application and developed scheduled jobs using VB Script.
• Involved in writing several test scripts and then testing them, made necessary fixes when required before turning
• Gather requirements for reporting from stakeholders.
• Work with internal and external customers to develop changes that would help customers get information
• Use Crystal report to develop, build and deploy complex reports involving formulas, dynamic parameters, and crosstab and sub reports.

Environment: Oracle 9i, SQL Server, VB.net, Crystal Reports