Sql Server Project Manager

A summary of the experience and expertise I will bring to the job

• 6+ Years of experience in developing reporting solutions for Financial, Banking, Billing, Payroll and Wholesale/Retail, Healthcare industries.

• Worked extensively in leading, developing and implementing report solutions on Business Objects XI RI, XIR2, XIR3, Crystal Reports 10, XI, XIR2, 2008, Web Intelligence XI, Desktop Intelligence, Xcelsius, Universe Designer, Business View Manager, Infoview & CMC.

• Designed & demonstrated a POC & converted into a long term project.

• Proficient in interaction with Client/End-user for gathering the reporting requirement, documenting & converting into Reports.

• Experienced in design & developing Periodic & ad hoc reports suiting the end user requirement.

• Experienced in UAT & getting signoff from the end user.

• Having the knowledge of widely used reporting tools of Business Objects, can always suggest alternative ways to achieve the reporting needs of End user.

• Expertise in Crystal Report features like Drill Down Report, Running Totals & summary Report, Sub Reports, Parameterised Report & Sub Report, Run Time Grouping.

• Implemented Row level security.

• Experience in SQL Server reporting.

• Implement security requirements and user administration, rights and user groups supporting various projects.

• Expertise in designing Universe from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R2 SP3.

• Experience on SAP BW BEx Queries as data source for reporting.

• Experience on major RDBMS systems like Oracle, SQL Server 2005/2000, DB2,Access.

• Worked extensively in developing Procedures, Triggers, Views on database like Oracle 9i

• Lead the migration project from Crystal 10 to XIR2 & Access/Excel to Desktop Intelligence.

• Experience in interacting with business users and rules analysts on multiple projects.

• Expertise over preparing report specifications, database designs to support the reporting requirements.

• Experienced in documenting different stages of developing reports and setting them up on BO Server

• Active team player and as an individual with Excellent Communication, Interpersonal skills, self motivated fast learner and good listener.

Technologies I worked with

Areas Technology / Products

Languages

SQL, PL/SQL Structured

Query Language

(SQL).

Reports Crystal Reports 2008,XIR2, XI/10/9/8.5,8.5, Business Objects Designer XI, XIR2, Desktop Intelligence XIR2, Web Intelligence XIR2 Crystal Reports, Business Objects XI Release II, Business View manager, Infoview, CMC

RDBMS Oracle 9i,10g, SQL Server 7.0,2000,2005, Access Oracle, Microsoft SQL

Operating systems

Windows 2000, XP, Vista WindowsNT, Windows 95/98, 2000, XP, Vista

Version control Visual Source Safe

Work/assignment history

Client :- Entertainment Partners Duration :- Sep11 – Till Date

Projects:- TimeTrax Reporting

Team size 4

My role Sr. Report Developer

Technologies Crystal Reports XI R2, SQL Server 2008, BOXI -Central Management Console & Infoview, Clear Case (Version Control) & Clear Quest (Ticket management), Mingle, Java application.

Responsibilities:

• Gather & understand the requirement of user.

• Analysis of Business Requirement and time estimation for the reports

• Suggest alternatives.

• Develope database objects as per the requirement. Do compatibility test.

• Responsible for design, development and implementation/deployment of report and database objects.

• Duties include maintenance, development and Enhancement

• Responsible to support the issues with reports on the application ( Development, UAT, Test and Production )

Client :- BMS (Upland,CA) Duration :- May11 – Aug11

Projects:- • BMS Reporting

Team size 5

My role Consultant

Technologies Windows XP, SQL Server 2008, RevFlow, JIRA

Responsibilities:

• Understanding the system, Application & data structure

• Analysis of Business Requirement documentation and time estimation for the reports

• Responsible for design, development and implementation of SQL Server Procedure.

• Duties include maintenance development and Enhancement

• Developed stored procedures in support of RevFlow applications

• Responsible to support the issues with reports on the application ( Development, UAT, Test and Production )

Client :- Ingram Micro (Belgium) Duration :- Feb10 – Feb 11

Projects:- • IMG BO Consolidate Report

• IM MPC in EDW/BO

Team size 7

My role Sr. Report Developer , Team Leads

Technologies Windows XP, BO XI R2, R3 Desktop Intelligence, Crystal Reports 2008, MS Access, Excel, SQL Server 2005, MS project Manager, Universe Designer

Responsibilities:

• Involved in understanding of legacy IM Consolidation system.

• Responsible for Understanding Business logic implemented Via MOR Tool developed using MS Access & VB Script for MPC System.

• Accountable for implementing MPC logic in BO Univers( development from scratch) for MPC.

• Accountable for ETL definition & Documentation.

• Accountable for Writing Report Design Specification

• Involved in all phases of migration from MS Access to Deski & CR XI R2.

• Involved in Understanding Universe and migrating existing excel & Access based reports to Crystal Reports & Deski

• Involved in creating the Business Requirement Specification (BRS) & Report Requirment Specification which included enhancements to existing & new Reports.

• Involved in Leading team on multiple projects like IM MPC in EDW/BO, IMG BO Consolidate Report.

• Resposible for the timely deliverables.

• Involved with team members to make sure they understand the requirement & if required then contact Client Finance team for clarification.

• Responsible for handling escalation.

• Responsible to support the issues with reports on the BO enterprise environments ( Development, UAT, Test and Production )

• Responsible for report testing & for Sign-Off after the release.

• Resposible to Billing generation

Client :- Lehman Brothers India Duration :- Dec 07 – Jan 10

Projects • Multi Client Portfolio Reporting System

• Offline Client Reporting

Team size 17

My role Crystal Report Developer

Technologies Windows 2003,XP, Business Objects XI R2, Crystal Reports XIR2, Oracle, SQL Server 2005, Siebel 7.0, FMC Pages, Visual Source Safe 6.0

Responsibilities:

• Responsible for design, development and implementation of SQL Queries.

• Analysis of Business Requirement documentation and time estimation for the reports

• Duties include maintenance development and Enhancement

• Developed stored procedures and views in support of various business applications

• Maintenance of objects and user in CMC.

Client :- Business Objects Duration :- May 06 –Nov07

Project Business Objects Tech Support

Team size 14

My role Design Engineer

Technologies Windows, Crystal Enterprise ,Crystal Reports 9,10,XI, XIR2, Business View Manager, SQL Server, Oracle 9i, MS Access

Responsibilities:

• Responsible to work with Business Objects products including Crystal Reports, Info view, Universe, Designer.

• Handle issues related to migrations from previous versions.

• Help Business Objects Clients in reports issues

o Connectivity issues related to Web and Application Servers

o Business Objects connectivity, migration and security with Domain, Local NT account

o Database Connectivity, Migration, Maintenance and Security

o Setting up VMWare Images including Win 2K Advanced Server, Win 2K3 along with Service Packs.

o Testing Business Objects Hot Fix, Service Packs on Business Objects Products

o Testing Bugs and enhancements on the Product

o To investigate and troubleshoot possible globalization defects on a test environment by replicating the issues and to provide resolution at early stages and to coordinate with users using People soft CRM system.

• To provide training to the new hires on the process

• Technical and Process Documentation for future

Client:- Girikand Travels Duration:- April 05- April 06

Projects • Car Rental System

• Feedback System for Car Rental

• Passport Booking

Team size 5

My role Oracle Softwre Developer

Technologies Windows NT, Oracle 9i, VB.Net , Asp.Net

Responsibilities:

• Role as PL/SQL Developer Designer.

• Member of Team responsible for developing new PL/SQL Programs

• Include maintaining development and PL/SQL programming.

• Developed stored procedures, triggers and packages in support of various business applications

• Created users and roles. Created Packages, procedures, functions, cursors, sequences, triggers using SQL, PL/SQL.

Education and professional training

Graduation Bachelor of Engineering in Information & Technology

Certifications • Oracle Certified Associate – SQL & PL/SQL

I declare that all the information furnished above is true to the best of my knowledge.

Place : Burbank Best Regards,

Date : Neha Jaiswal

Contact this candidate