Sql Server Manager

KAVITA SALIEN

Ph: 281-***-**** / 281-***-****

E-Mail: ******.******@*****.***

OBJECTIVE:

Seeking a challenging and rewarding career in design , development , administration of database applications leveraging skills in Business Objects Enterprise 10/11, Business Objects Enterprise XI 3.0, 3.1, Business Objects Designer, Crystal Reports XI/10/9/8.5, Crystal Reports 2008 , Microsoft SQL Reporting Services 2005, Desktop Intelligence, Web Intelligence, CMC, Infoview, Business View Manager, APOS Bursting Manager, SQL Server 2000, Oracle 10i, SYBASE, VB.NET, ASP.NET, XML, Web services, Object-Oriented Programming (OOP) principles, ADO.NET, Windows, Microsoft SQL Reporting Services 2005, Microsoft Visual Studio 2005, Unix, Sybase, WINSCP3, Showcase.

SUMMARY OF EXPERIENCE:

Over 9 Years of experience in developing, Implementing, supporting reports for Bank, Medical, Energy, Real Estate Industries.

Over 9 years of IT experience in analysis, design, development, reporting, implementation, documentation, testing and maintenance of applications using Business Objects Designer, Business Objects Enterprise XI 3.0/3.1, Crystal Reports 8.5/ 9/10, Crystal Reports 2008, Crystal Enterprise XI, Microsoft SQL Reporting Services 2005, MS Visual Studio 2005, MS Access, Oracle, SQL Server, SYBASE ,VB.NET, ASP.NET, COM, XML, ADO, UNIX, Showcase, WINSCP3, Putty, IMPACT Vendor Database, Subversion, Tyger.

Strong written and verbal communication skills, ability to facilitate communications between technical, non-technical personnel, vendors, management and other partners.

COMPUTER SKILLS:

Reporting Tools: , Business Objects Enterprise XI 3.0,/ 3.1, Crystal Enterprise XI/10, Crystal Enterprise 8.0,8.5,9,10, Microsoft SQL Reporting Services 2005, Info View, Crystal Reports 2008, Business Objects Desktop Intelligence Rich Client, Universe Designer, Web Intelligence, Infoview , CMC, Dashboards, Business View Manager,APOS Bursting Manager.

Languages: VB.NET, ASP.net, JSP, OOP in .NET, XML, Web Services, Visual Basic 6,HTML, ADO.net, CSS, XSLT, Microsoft FrontPage, HTML, MS Visual Studio 2005.

Web Expertise: ASP, HTML, JSP

Web/Application Servers: IIS 6.0, 5.0, Apache server

RDBMS: SQL Server 6.5, SQL Server 2000, MS Access, SYBASE, Oracle 10i

Operating System: Windows XP/2000/NT/9x, MS DOS 6.22, UNIX, PUTTY

Version Control: Visual SourceSafe, Subversion

Development Tools: Visual Studio, Visio, SQL Workbench

Other Tools: Microsoft Office 2000, Coreldraw9, Adobe PageMaker, Windows Share Point Services, FTP and SFTP tools, Tyger, ShowCase, WINSCP3, JIRA, ECM, Microsoft Project 2007, Lotus Notes

PROFESSIONAL EXPERIENCE:

MD ANDERSON CANCER CENTER, HOUSTON

BI APPLICATION SYSTEMS ANALYST/DEVELOPER

JULY 2010 – PRESENT

• Developed and Implemented new Universes, reports based upon organizational strategy, designs, specifications, and ongoing needs analysis.

• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs. Assisted users on how to use Universes, and extract data for performing queries and writing reports.

• Generated Web Intelligence reports/ Desktop Intelligence Reports using the Universe as the main Data provider, free hand SQL development and also using the personal data files provided by the users.

• Providing primary support for multiple reporting applications. Reviewed reports, queries and monitor system performance making changes as needed to optimize performance

• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements in Crystal XI/ Business Objects XI 3.0

• Responsible for the maintenance and support of Business Intelligence Solutions.

• Using the Central Management Console (CMC) to manage:

o User, groups and folder security

o Business Objects Servers

o Printers

• Publishing and Maintaining Reports in Business Objects XI 3.1

• Troubleshooting Report, Database failures of scheduled Reports

• Designing and Publishing Reports in Crystal reports 2008.

• Used InfoView, Central Management Console (CMC) to perform almost every day-to-day administrative task, including user management, content management, Server management, Scheduling Reports etc

.

SITUS COMPANIES, HOUSTON

BUSINESS OBJECTS XI 3.0/3.1 CRYSTAL REPORTS XI /2008 DEVELOPER/ADMINISTRATOR

MARCH 2010 – JULY 2010

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe. Created Cascading LOV’s, prompts.

• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.

• Generated Web Intelligence reports/ Desktop Intelligence Reports using the Universe as the main Data provider, free hand SQL development and also using the personal data files provided by the users.

• Created complex reports, charts using the multiple data providers and synchronized the data providers by linking the common objects to create common report.

• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements in Crystal XI/ Business Objects XI 3.0

• Provided the security access management by creating users/groups and folders.

• Developed universe user documentation guide for the end users reference.

• Provided training for end users for generating their own report including complicated report.

• Used , InfoView, Central Management Console (CMC) to perform almost every day-to-day administrative task, including user management, content management, Server management, Scheduling Reports etc

• Created interactive dashboards to help users gain quick insight into their business performances using Dashboard Builder XI 3.0 from Business Objects.

JPMORGANCHASE, HOUSTON.

.NET/UNIX/ REPORTS/SHOWCASE DEVELOPER

JANUARY 2007 – JANUARY 2010

• Designed, developed, implemented and maintained reports for the Investment Banking business using Crystal Report, Sybase, UNIX, ASP, JSP, Showcase, WINSCP3, Subversion, Impact Vendor Database, Fixed Income securities, JIRA. Experienced with front end, middle tier, and backend development environments

• Worked extensively in developing Procedures, Triggers, Views, tables and proxy tables on database like SQL server 2000, 2005, Sybase, DB2 database.

• Expert in preparing report specifications, database designs, identifying issues, deficiencies and proposing solutions to support the new/existing reporting requirements.

• Coordinated with DBA’s, Business units and Operate for reports testing, integration and successful deployment.

• Gathered requirements during inception phase. Interfaced with business users to prepare and update business requirements. Created Project roadmaps during various phases of development using Microsoft Project 2007. Mapped out timelines, milestones, communication processes, question and answer session.

• Used Subversion to maintain current and historical versions of the source code

• Created test plan and test cases for User Acceptance Testing (UAT). Created documentation for User training and Help Desk teams.

• Maintained the repositories for different environments like DEV, QA and PROD.

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

• Reviewed and tested new upgrades to Impact database and provide support during implementation.

• Wrote shell scripts to extract and convert vendor data and load it into Sybase datamart, ftp reports via email or to their shared drives, created chron jobs to execute scripts, , transfer data from production to any of the development servers, modified scripts etc

• Knowledge of Fixed Income Securitized Products, Impact Vendor Database, Trade Router

• Coordinated with DBA’s, Business units and Operate for reports testing, integration and successful deployment. Scheduled several change records, code promotion etc.

• Worked in a fast-paced, team-oriented, dynamic environment, under aggressive deadlines.

• Was involved in converting Crystal Reports to Business Object Report.

TEXAS CHILDRENS HOSPITAL, HOUSTON.

.NET/CRYSTAL REPORTS DEVELOPER

AUGUST 2006 - NOVEMBER 2006

• Designed and implemented several reports for the Texas Children’s Hospital Health plan Department using Crystal Reports, SQL server 2000, Visual Source Safe. With the design process I have had excellent experience in developing various databases, tables, stored procedures, views, temporary tables, formulas, running totals, parameters, sub reports etc.

• Coordinated with DBA’s and business units for reports integration and deployment.

• Responsible to support the issues with reports on the crystal enterprise environments (Development, UAT, Test and Production). Supported and executed all QA activities (test cases, test scripts, timelines, defect tracking, deployment, issue and risk assessments)

• Created test plan and test cases for User Acceptance Testing (UAT). Created documentation for training and Help Desk teams.

• Maintained the repositories for different environments like DEV, QA and PROD

• Performed day-to-day production support for applications, database issues , diagnosed problems, resolved production issues

CAPROCK COMMUNICATIONS, HOUSTON.

CRYSTAL REPORTS/SQL SERVER REPORT DEVELOPER

APRIL 2006 – AUGUST 2006

• Designed and implemented several metric reports for Engineering, Sales, Accounting departments etc using Crystal Reports Enterprise XI, SQL server 2000.

• Published these reports using InfoView.

REPORTS DASHBOARD

• Created a Reporting Dashboard for Sales, Engineering and Accounting departments using Crystal Enterprise XI, Windows SharePoint Services 2003, Microsoft SQL Server Reporting Services 2005 and SQL Server 2000. Created various reports using Microsoft SQL Server Reporting Services 2005 writing custom codes. Created various Web Parts for Dashboard Implementation. Used Report Manager to Schedule and deploy the Reports on the Server.

• Converted Crystal reports XI to SQL Server Reports 2005 using Crystal Converter tool.

• Created various Ad-Hoc reports using Report Builder. Created a Report model and exposed it to the end users who ran ad- hoc reports on it.

CINERGY, HOUSTON

CRYSTAL REPORTS / MS ACCESS DEVELOPER

SEPTEMBER 2005 – APRIL 2006

MARKETING AND TRADING

• Designed and implemented several marketing and trading reports using crystal reports v10, SQL server 2000. With the design process I have had excellent experience in developing various databases, tables, stored procedures, views, temporary tables, formulas, running totals, parameters, sub reports etc.

• Coordinated with DBA’s and business units for reports integration and deployment.

• Published various reports using InfoView. Scheduled several reports for customers and exported as Excel and PDF formats.

• Deployment verification and maintenance.

GAS MANAGEMENT SYSTEM

• Interacted with business units and customers to understand and determine functional and technical requirements to perform reports conversion from existing MS access reports.

• Worked extensively on converting several MS Access reports to Crystal Reports XI. With the conversion project, I have created databases, tables, stored procedures, views, temporary tables, formulas, running totals, parameters and sub reports. Created dynamic and cascading prompts using Business View.

• Managed report related formulas, SQL commands, text objects and images in Report object repository.

• Performed crystal enterprise administration tasks using management console such as reports publishing, scheduling, user security and authentication.

SVS TECHNOLOGIES INC, HOUSTON

DEVELOPER

MARCH 2003 – AUGUST 2005

CIMS (CUSTOMER & INVENTORY MANAGEMENT SYSTEM): Designed, Developed and Maintained Medical Equipment Rental/Service System. The capabilities of the system included creating service orders, rent orders, sale orders, maintenance of customer inventory and company inventory, billing, vendor invoice, reports etc. Used SQL Server 2000, VB.Net, ASP.Net and Crystal Reports 9 for user interface. The Web Service system provides a centralized storage of all client information to be accessed over the Internet.

MEDICAL BILLING SOFTWARE: designed and developed Medical Billing software for the Client Clearlake Integrated HealthCare to schedule daily appointments, insurances details, provider details, reports, billing, invoicing etc using VB.Net, ASP.Net, Crystal reports 9 and SQL 2000 database.

PROJECT ISSUE TRACKING SYSTEM: designed and developed Issue Tracking System with the company SVS technologies,

ONLINE BOOK SHOPPING: Developed user-friendly online Book Shopping application, for Compu21 Center.

APTECH EDUCATION CENTER, GOA, INDIA

DEVELOPER

JAN 2000 - JAN 2002

AIRLINE TICKETING: Developed Air-ticket booking system for Airsonic Airline Ticketing Agency in Goa.

LIBRARY MANAGEMENT SYSTEM: Designed and developed a Library Management System for the Central library, Goa. This system is for the automation of daily activities of a library, like keeping track of Books, registering new members, Check out, Check in books to members, Query by subject, title, and author and generate past due reports and fine amounts

STRENGTHS:

Strong written and verbal communication skills, ambitious. Proven analytical, problem-solving skills, active team player and ability to work under pressure. Excellent interpersonal, leadership, presentation and organizational skills. Self motivated fast learner and good listener. Good knowledge of various database concepts.

EDUCATION:

Bachelor of Science, University Of Goa, India, 1996

Diploma in Information and Systems Management, Aptech Goa, India, 1998

Advanced Visual Studio.Net, Compu21 Center, New York, 2003

Business Objects XI R2 Designer/Administrator, Houston, 2008

Project Management for IT Professionals, Houston, 2008

Contact this candidate