Professional Summary

• Over 10 years of IT experience with data analysis, data access, data structures, data manipulation, databases, data reporting solutions, and technical and user documentation.
• Over 9 Years of experience in Business requirement gathering, Analysis and Documentation of the requirements.
• Over 7 plus years of experience in Designing BO Universe and creating reports based on the Universe in Desktop Intelligence and WEB Intelligence.
• Worked extensively on modules Supervisor, Designing Dash Boards, Web Intelligence reports Desktop Intelligence Reports and Broadcast agent in SAP Business Objects and Crystal Xcelicus
• Extensively Worked on Maximo Reports for Work management, Asset management cost from the BO Universes
• Over 7 years of experience in Designing and Development of Relational / Dimensional Database on Oracle9i/10g and MS SQL Server 7.x/2000/2005/2008.
• Hands on experience in Installing, Configuring and Trouble shooting the Installation issues of SAP BOXIR2.
• Good knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, ETL Processes(Cognos,informatica,OWB), Data mining, Data audits and Web reporting features of data warehouses.
• Extensively worked on Data Federator for Creating Virtual Tables to manage the Meta data and to create views and materialized views.
• Good knowledge on Business Intelligence Architecture of Crystal XIR2 (CMC, CMS, Page Server, Cache Server, FRS etc).
• Expertise in all modules of Crystal Reports and Business Objects Suite 4.0/3.2/XIR2/XI/6X/5X (Installation, Configuration, Dash Boards design, Up-gradation, Universe Design and Development, Report Development, Performance Tuning/ Optimization, User/Security Administration)
• Expertise in creating the dash boards representations for various departments and consolidated reports using Crystal Xcelcius.
• Hands on experience with writing and tuning complex PL/SQL.
• Good Understanding in Business Objects Framework (Architecture) and functionality.
• Theoretical Knowledge of Brio, SAP BW
• Having good understanding knowledge in Navigational paths and the functionality in Oracle Application Re12( GL,AP,AR,FA,Purchasing).
• Good working knowledge of implementing .NET solutions
• Theoretical Knowledge of the Extraction, Transformation and Loading (ETL) of the data into the Data Warehouse using Informatica Power Mart / Power Center 5.x/6.x,Cognos(BOSS),OWBand Data Integrator XI.
• Experience in Training users, Knowledge of facilitation, mentoring and Technical writing skills including documentation and editing of user manuals.
• Experience in VBA macros, Application Code Development using .NET along with Deployment Activities. Familiar with the functionality available in the BO XIR3 SDK.
• Experience with System Development and Change Management Methodologies.
• Strong background in SQL Server/Oracle RDBMS, Data Warehousing, Data Modeling, and Reporting.
• Extensive knowledge in Linux/Unix environment and also used shell scripting for better Performance.
• Good Knowledge on Performance Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server.

Technical Skills:

Business Intelligence

SAP Business Objects Suite 5i/6i/XI/XIR2/XIR3.x/4.0, BOE Premium Suite, Business Objects SDK, WebI, Desktop Intelligence, Dashboard Builder 3.x, Performance manager 3.x,Crystal Xcelcius, Crystal Enterprise 8.5/9/10/XI /2008/2011, SSRS (SQL Server Reporting Services).

Data Modeling

Erwin 4.x/3.x, MS Visio, Data Federator, BO Data services

ETL Tool

Informatica, Cognos,OWB,Data Integrator, SQL, DTS and SSIS

Languages

C/C++, PL/SQL, Java 1.4, PL/SQL,.NET, SQL*PLUS

Web Technologies

HTML, JSP, Asp, XML, CGI,Oracle Apps Re12

RDBMS

MS SQL Server 6.5/7.0/2000/2005/2008, Oracle 8i/9i/10g/11, MySQL, MS Access 97/2000, Teradata,DB2

Operating System

Windows 9X/NT/2000/XP,2003, Unix, Linux

OR Mapping Frame Work

Hibernate 3.x

IDE

RAD 6.x/7.x

Web server

Web sphere 5.x/6.x

Professional Experience:

Confidential, Chapel Hill, NC Oct’11 to Till Date
Project: CDW Retirement with BO Upgrade Sr BO Developer/Application Support

Description: Confidential is a leading provider of Health Insurance in State of North Carolina with over 2 million members.

Role &Responsibilities:

• Participated in Conversion of Corporate Data warehouse (CDW) to Enterprise Data warehouse (EDW) Reports Using Agile Methodology.
• Experienced in leading, developing and delivering Training materials to users.
• Conducted and Facilitated the Conversion of DeskI Reports to WebI and Crystal reports in BI 4.0 Environment.
• Created and maintained custom universe and analyzed over 300+ universes inventoried
• Specific to project needs.
• Extensively used BO Life Cycle Management to migratereports across different environment (ie Dev, test and prod).
• Obtained and analyzed User’s Information and Security levels in BO 6.5 and implemented new Security in SAP BO 4.0.
• Created/Administered users/user groups/Security in Supervisor/CMC.
• Created Profiles in CMC to support to report bursting feature.
• Designed Universes and developed Web Intelligence and Crystal reports in BI 4.0 Launch Pad.
• Performed the User Training Sessions with Lab sessions on the Data marts, Universes and Reports in respective to the users Business Area.
• Designed Crystal Report 2011 templates with conditional Formatting as per the end user requirements.
• Published Universes and Report documents to the Repository as part of the production deployment and made them available to the users.
• Expert in creating web intelligence documents using level input controls, merged dimensions, data tracking, open doc and complex filters ( query and report level).
• Developed complex universes by using advanced features like aggregate aware, Derived SQL, LOVs and hierarchies.
• Developed and implemented Universesby defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
• Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.
• Created complex WEBI reports with time Period, trending and comparative reports to make the Live Dash boards in Crystal Xcelcisus.
• Executed tasks and duties with sensitive deadlines in timely manner.

Environment: Business Objects 4.0/3.x, Crystal Reports 2008/2011, TOAD, Teradata 13.x, Abinitio, Oracle and SQL. 
Confidential, Indianapolis, IN May’11 to Sep’11
Project :Implementation of SAP Rapid Marts Sr BO Developer/Application Support

Description: Confidential is the 10th largest pharmaceutical company in the world.This project mainly converting the SAP Rapid marts data into the business objects reporting for various modules of SAP.

Roles and Responsibilities:

• Responsible for Implementing the Ad-hoc changes and supporting the Finance reports for Business requirements.
• Worked on Full End To End Life Cycle for the reports in different Environments with in the Project plan.
• Responsible for creating the users and applying the restrictions both the folder levels and the data level restrictions based on their Regional settings.
• Responsible for creating the manage restrictions and the user security in CMC based on the Ad-hoc users with respect to their Zones.
• Extensively worked in Creating and modifying the Web Intelligence and Crystal reports for all the Ad-hoc requirements by the business users to meet the requirements.
• Extensively worked in supporting the BOBJ 4.0 Reporting and the universes changes.
• Responsible for creating the Business objects XI R3 Reports WEBI and Crystal Reports (on demand, AdHoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging reports).
• Experience in Creating the user level input controls, report filters and Drill Filters to make the ad-hoc users to manipulate their own Filter criteria in the report.
• Responsible for creating Complex Variables ,Summarized objects, Rolling Totals, Date Time Functions, YTD/QTD calculations at different levels for different Regions and Zones.
• Worked on Multiple Cross Tab reports generating from Different Data Sources and Integrating
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Involved in creating Dash Boards for the Monthly/Quarterly/Yearly Analysis for the Financial Trending Reports using Crystal Xcelcisus.
• Created Materialized views, stored procedures, Functions , triggers, Synonyms, Views for Reports using complex SQL, PL/SQL
• Extensively worked on Business objects info view for Importing , Exporting, setting up the credentials to the Viewers/Ad-hoc users/Developer and scheduling the reports to trigger and sending emails at respective timestamps required to the end users.
• Worked with ETL Development Team for extracting data from SAP RapidMarts, perform Transformations as per the requirement and Load the data into existing Oracle DB Using BO DS.
• Involved In creating and Maintaining Crystal reports 2008 with different Drill Down Detailed Reports using Sub reports and CrossTab reports for Trending charts.

Environment: Business Objects 4.0 , Crystal Reports 2008/XI, Remedy ARS ,Web Intellegence Rich Client,
PL/SQL , Oracle 11g ,BO Data Services , Crystal Xcelcisus

Confidential, Rockleigh , NJ Sep’10 to Apr’11
Project :Korus Application ReportsSr. BO Designer/Reports Developer

Description: A wholly-owned subsidiary of Fresenius Medical Care, the world\'s largest vertically integrated dialysis service provider, Spectra Laboratories the leading provider of renal-specific testing services.

Role &Responsibilities:

• Responsible for Implementing the New Reports and also maintaining the Existing Reports.
• Involved in writing Technical specification documents based on report client specifications.
• Responsible to Designing Universe with the Business requirement and the Aggregations, classes, Variables, Parameters conditions, Derived Tables ,contexts etc.
• Responsible for implementing the security credentials at different Levels of Functional and technical requirements in user level and the object level restrictions in the Universe Designer XI 3.1.
• Published Reports in BO Enterprise (InfoView) via. Business Publishing Wizard and Central Management Console(CMC).
• Highly involved in creating API with the front end Application and responsible to restrict the data based on the user credentials with respect to the Business objects XI R 3.1 info view categories and folders restrictions.
• Responsible for Designing Universe in Business Object XIR3.1 to get the Data from different Regions in order to make the transactions to be Global
• Involved in creating complex formulas for generating the Cross- tab reports with different Trending reports with Charts.
• Extensively used crystal reports 2008 in generating new reports with multiple sub reports which uses shared variables from the main reports.
• Responsible to create LOVs using Business View Manager(BVM) for Dynamic Cascading prompts.
• Expertise in importing, exporting , changing Properties ,modifying Reports Using Business Enterprise Portal (Info view).
• Extensively used While Printing records/While Reading reports etc to speed up the Report execution time
• Created Materialized views, stored procedures, Functions , triggers, Synonyms, Views for Reports using complex SQL, PL/SQL, T-SQL
• Created Reports based on Views, Stored Procedures and Commands. Modified existing Report based on the User requirement and created running totals, sub-totals and used Crystal syntaxto create complex formulas for the Reports
• Involved in creating Dash Boards for the Monthly/Quarterly/Yearly Analysis for the criminal records based on the shift bases using Crystal Xcelcisus.
• Created new reports and also modified many reports and successfully completed the project within the time given.

Environment: Business Objects XIR3.1, Crystal Reports 2008/XI, Oracle 11 g, MSRS 2005, MS VISIO,VSS, PL/SQL,SQL, Win NT & UNIX.

Confidential,Albany,NY Sep’09 to Aug’10
Project: Site Manager Reporting Technical Lead BO Designer/Report Developer

Description: Confidential is one of the best State Departments in Transportation all over the United sates. It is mainly to construct or maintain the Roads, Brides and Controls traffic .

Roles &Responsibilities:

• Designing and Migrating the Existing reports from the MS Access and Mainframe Reports into crystal reports or WebI Reports.
• Responsible for Getting the Requirements from the Clients for Enhancements to the Existing reports.
• Extensively Participated in conducting Team Meeting and Vendors Meeting for the UAT by Training on the Site manager System.
• Involved in Performance Testing including the Load test in different Regional offices and remote areas.
• Responsible for creating the Business objects XI R3 Reports WEBI and DeskI (on demand, AdHoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging reports).
• Extensively created Cascading prompts both report level and Query level based on the Report requirement.
• Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects) that support critical businessoperations.
• Participated in maintaining the Business object CMS and CMC for checking the which Job servers are down and check the conditions and load on the remote servers.
• Responsible for creating the Views and Materialized views for quick retrieval of Data using
• Data Federator
• Responsible for Designing Universe in Business Object XIR3 to get the Data from different Regions in order to make the transactions to be Global
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Extensively responsible for Creating the Dash board reports Using Crystal Xcelcius for the graphical representation of the overall analysis of the DOT for the State Analysis Board.
• Created views and stored procedures, Functions , triggers, for Reports using complex SQL, PL/SQL, T-SQL
• Generated reports with both static and dynamic prompts(cascading) in order to filter the data according to the requirement.
• Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
• Modified existing reports according to the Report RequirementDocs and exported reports to PDF format.
• Prepared detailed Documentation of the Reports to the users for future reference guide.
• Created new reports and also modified many reports and successfully completed the project within the time given.

Environment: Business Objects XIR3, Crystal Reports 2010/XI, HTML,XML, Crystal Xcelcius, Oracle 10g,MSRS 2005,SQL Server 2005,Data Federator,MS VISIO,VSS, PL/SQL,SQL,Win NT & UNIX.

Confidential, Albany, NY Sep’ 08 – Aug’ 09
Project : Sand Box Reporting Technical BO Designer/Report Developer

Description: Division of Criminal Justice (DCJS) is one of the State Agencies in New York,which keeps track of all the data related to Criminal and Non Criminal Finger prints. The new system will replace COBOL generated reports with BO and the old Mainframe Data will be loaded in to ORACLE tables.
Responsibilities:

• Preparing Business Rule Requirement documents based on the existing Legacy Systems.
• Involved in weekly Team Meetings for gathering business requirements for New Finger Print Transaction Reports
• Actively participated in Testing the reports and getting the acceptance from the users and adjusting the reports according to the production Move with UAT.
• Involved in Updating or modifying the Crystal Reports 10 to Crystal reports 2008/XI R2
• Responsible for Documenting the Business Requirement and taking confirmation from Business users.
• Involved in weekly Team Meetings with Application Development Team members on Analyzing ER Diagrams.
• Participated in oracle applications development in comparison with the GL reports with the WebI reports.
• Actively participated in creating Business Objects Dash boards for getting the over view of all Statics of the DCJS operations Quarterly and Yearly.
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Developed complex reports, charts and other data analysis solutions on cutting-edge business intelligence technical platforms (business objects Full Client Desktop Intelligence and WEBI).
• Involved in writing complex connections with Business Objects SDK in order to communicate with other front end Applications using multiple API
• Created Reports based on XML Data Source received from State Police.
• Worked on JAVA SDK Using APIs to connect the crystal reports XI .
• Involved in creating customized user Alerts and prompts for the reports using info View
• Created Reports based on Views, Stored Procedures and Commands. Modified existing Report based on the User requirement and created running totals, sub-totals and used Crystal syntax to create complex formulas for the Reports.
• Involved in re-designing or customizing the existing Materialized Views and Stored Procedures to suit the Reporting needs using Data Federator.
• Involved in writing complex SQL Queries to pull the records from multiple tables using JOIN’s.
• Developed Parameterized Reports, Cross tab Reports and Sub Reports involving complex formulas.
• Involved in redesigning of Existing Universe designs.
• Responsible for showing all of your business intelligence (BI) content in one consolidated view using Dashboard builder.
• Involved in tuning Complex SQL and PL/SQL using Explain Plan and Hints
• Generated sub Reports, linked and unlinked Reports, Reports on demand.
• Created Procedures and Functions to accomplish complicated Business Login for calculating the duration of the FAX TIME between the arrest date and first reprint date.

Environment:Business Objects XIR2/XIR3 (Full Client Desktop I and Web I), BO XIR3 SDK, Crystal Reports 2008,XI/11, Performance manager 3.x, Informatica 7.x, Erwin Data modeling, Oracle 10g,oracle discoverer, DB2, XML, Web Sphere 6.x.

Confidential, Columbus, OH Aug’ 07 – Aug’ 08
Project : Credit Reporting System Lead BO Designer / Report Developer

Description: CRS is used by Confidential users to maintain all credit related files for retail customers. The CRS also keeps track of each customer’s Credit Card usage and payments. The system is also used to build reports of each customer which is to be sent to the credit reporting agencies
. 
Responsibilities:

• Responsible for Business Requirement gathering and preparing documentation based on the requirement.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the Reporting needs.
• Written Stored Procedures and Views, to extract data based on the Business requirement with Oracle 9i/10g as the backend.
• Responsible for Designing Universe in Business Object XIR2 to get the Data from different sites in order to make the transactions to be Global
• Extensively worked on performance issues on the Universe and the Data Models
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects) that support critical businessoperations
• Worked on creating dashboard for multiple reports into a consolidated report for the complete analyzing the customers overall performances in a graphical representations using Desktop Intelligence Reports
• Developed complex reports, charts for Montly, Quatery and Yearly reports in Crystal reports XI for Customer transaction YTD statements and to validate their Transactions
• Responsible for creating the graphical representations of Bar graphs, Pie charts, Speedometer representations, donut charts Using Crystal Xcelicus.
• Involved in performance tuning of reports by eliminating filters at report.
• Involved in testing the code and analyzing the report based on the clients specifications and moved the entire code into UAT and then into Production in no errors
• Involved in tuning Complex SQL and Pl/SQL using Explain Plan and Hints
• Responsible for showing all of your business intelligence (BI) content in one consolidated report using Dashboard builder to monitor the customers YTD Transactions in buckets
• Build Desktop Intelligence and Web I reports both manually and wizards reports and exported them into different formats
• Worked with ETL Development Team for extracting data from Legacy system, perform Transformations as per the requirement and Load the data into existing Oracle DB.
• Generated sub Reports, linked and unlinked Reports, Reports on demand.
• Actively participated in working on API for using Business objects SDKs for connecting the legacy data into the reports and to retrieve the data.
• Responsible for creating a Dashboard with graphical pie chats and speedometer representations with Crystal Xcelcius.
• Linked multiple reports by using OPENDOC () function in Dashboard

Environment:Business Objects XIR2 (Full Client Desktop I and WebI),BO XIR2 SDK Dashboard Builder, Performance manager , Crystal Xcelcius Informatica 7.x, Erwin Data modeling, Oracle 10g, Oracle Discoverer,MS Visio, Unix Shell scripting.

Confidential, NM May’ 06- Jul’ 07
Project :Supply Chain Management Lead Report Developer

Responsibilities:

• Mentoring the client on administration tools Central Management Server (CMS) and Central Management Console (CMC).
• Responsible for Business Requirement gathering and preparing documentation based on the requirement.
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Developed few reports for comparing Maximo Purchasing data with Oracle Purchasing system. Purchasing data includes Item Master, Purchase Requistions, PO and Receipts
• Developed reports in Maximo for Material and Labor Bill data sent to General Ledger from Maximo
• Creation of Dashboard using Crystal Xcelsius.
• Used Crystal Xcelsius to visualize and bridge the gap between data analysis to enhance the Data presentation.
• Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects) that support critical businessoperations
• Developed Desktop intelligence reports with different Alerts and prompts in the reports based on the Business requirements
• Developed complex reports, charts and other data analysis solutions on cutting-edge business intelligence technical platforms (business objects Full Client and WEBI).
• Involved in performance tuning of Business Objects Full Client and WEBI reports
• Used prompts to make Reports confined to a particular case as per business requirement.
• Created reporting front-end objects including sub Reports, drill down, parameters, LOVs, Charts etc.
• Exported Desktop Intelligence reports into WebI reports in order to have the reports in a global sites
• Worked on different SDKs for better data modulations technique in order to have legacy data into the new applications added to the business needs.
• Involved in writing Complex Queries to fetch records from multiple tables using Joins.
• Involved in performance tuning of reports by eliminating filters at report level and filtering the records at database level.
• Involved in creating indexes on tables to fetch records faster.
• Linking multiple reports by using OPENDOC () function.
• Responsible for showing all of your business intelligence (BI) content in one consolidated view using Dashboard builder
• Used Xecelcius reports for representing the overall sales of the company transactions and the purchasing reports into a graphical representation.
• Created views & materialized views in Oracle database & connected thru Crystal report.
• Created Reports with alerts when certain conditions are met as requested by the user.
• Responsible for creating scorecards using performance manager
• Validated and provided issue resolution of the Crystal reports and universes.
• Responsible to writing technical document as per the requirement
• Applied server connectivity using different Business Objects SDK .
• Trained client IT staff on Crystal Reports, Crystal Xcelsius, Web Intelligence and Designer.
• Designed and Developed Security model for Crystal Decisions Environment.

Environment: BO XIR2 (Full Client and WebI),BO SDK, Dashboard Builder Performance manager , Crystal Reports Server 10/XIR2, Oracle9i/10g, Unix.

Confidential Jan’ 05 – Apr’ 06
Project: BI Reporting Services BI Specialist

Responsibilities:

• Reviewed and enhanced the current infrastructure for Business Objects Implementation.
• Performed analysis and provided thought leadership relating to the existing technical infrastructure with a focus on Implementation Strategy and end user efficiency enhancements.
• Participated in DW related projects, from business needs analysis through production delivery, acting at the technical architecture/design level and as the liaison for the rest of department.
• Member of the decision committee to analyze the functionalities of Business Objects Pre-packaged applications vs. Oracle Business Intelligence pre-packaged applications for Oracle AR and GL financial solutions.
• Developed and implemented a plan to support the rollout of Business Objects 6i.
• Installed and Configured Business Objects Dev/QA and Production Environment.
• Customization of Infoview in .NET Environment to meet the requirements.
• Designed and Developed Security model for BO Environment.
• Bug Fixing in BO Environment
• Maintenance, Support and Administration of the Business Objects Environment.
• Involved in development, validation and administering the ad hoc report requests, developed processes and standards for this environment, testing queries developed by others for data accuracy and supporting users.
• Involved in creating SQL Procedures and triggers as per the business requirement.
• Created views in database based of the requirement.
• Involved in creating indexes on tables to fetch records faster.
• Developed reports for Sales, Marketing, Lab Operations and Finance Departments.
• Involved in performance tuning of reports by eliminating filters at report level and filtering the records at database level.
• Installed and Configured Performance Manager in Business Objects Environment.
• Managed the settings on Business Objects Administration Suite.
• Ensured appropriate documentation, documented all designs and development efforts accordance to the Enterprise Life Cycle Standards.

Environment: Business Objects 6i, MS SQL Server 2000, Oracle 8i/9i, Windows 2003 Server/Unix/Windows XP, TOAD and .NET Technologies and Web Logic.

Confidential. Sep’03 – Dec ‘04 
Project:Commercial Warehouse IT Programmer 
Description: Worked on warehouse’s Enterprise reporting team, which is responsible for maintaining the centralized database, reports generation, schedule and distribution. 
Role & Responsibilities:

• Assessed business needs to create and produced requirements and project scope document.
• Involved in user meetings to gather and analyze the report requirements.
• Generating all the reports required for other groups and clients and posting the reports on Seagate desktop, which enables the users to access, those reports.
• Scheduling the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Generated reports using various databases (Order Tracking, Sales and Product catalog) using Adhoc queries.
• Involved in migration of the reports with the application /database upgrades.
• Involved in testing the reports with test database, and giving the possible test cases to the testing team.
• Involved in creating the summary/detailed reports with drill down, sub reports, cross tabs, grouping etc as and when needed to higher management.
• Updated data flow diagrams, data model, population procedures, and scripts. Designed and developed new inventory population module.
• Created testing plans, executed plans, documented system changes, and implemented improvement.

Environment: Windows 2000, Visual Basic, JSP, VB script, Java Script, Oracle 8i, SQL, PL/SQL, Crystal Reports 7.0, Seagate Info 7.0, MS Access, MS Office, Erwin 3.x, etc.

Confidential. Sep ‘02– Aug ‘03 
Project:Order Entry & Invoice Management System IT programmer 
Description: The project involves development of web application of work orders and Invoice management system
Roles & Responsibilities:

• Exported Desktop Intelligence reports into WebI reports in order to have the reports in a global sites
• Good understanding of data access, data manipulation using back end SQL and complex stored procedures
• Involved in client side validations using java script
• Involved in creating the summary/detailed reports with drill down, sub reports, cross tabs, grouping etc as and when needed to higher management.
• Developed complex reports, charts and other data analysis solutions on cutting-edge business intelligence technical platforms (business objects Full Client and WEBI).
• Involved in performance tuning of Business Objects Full Client and WEBI reports
• Writing test cases and test plans.
• Basic documentation for user help and developer documentation.

Environment: Windows NT, Visual Basic 6.0, JSP, Java Script, Oracle 8i, Crystal Reports 7.0, SQL, PL/SQL, etc.