Sql Server Sales

*

* ********* *******

Possesses over * years of experience in IT, with working experience in

Microstrategy,Business Objects XIR3.1/XIR2/6.x/5.x,Crystal Reports XI

R2/9.0/8.5/8.0 and, backend databases such as SQL Server 2005/2000/7.0,

Oracle 9i/8i/7.3, SQL Server and M S Access.

> MicroStrategy Suite 7.x/8/9.3,Business Objects Enterprise XI

R1/R2/5i.,Crystal Enterprise XI/ 9.0/8.5, Crystal Info, and Crystal

Reports XI/9.0/8.5/8.0/7.0/6.0/5.0.

> Experience in building reports using SSIS, SSRS,SSAS

> Experience in building Universes, retrieving data using Universes and

Personal Data file, Stored Procedures and Free Hand SQL methods

> Experience with SQL, T-SQL, SQL*Plus, PL/SQL, Query Analyzer in writing

queries and developing Stored Procedures.

> Experience in building reports using SSIS, SSRS,SSAS

> Expertise in creating Customized Objects, @prompts and Cascading List of

Values.

> Experience in creating Dashboards, Metrics, Rules, Alerts and Goals using

Xcelsius for user analysis based on user requirement

> Good Experience in Oracle, SQL Server and MS-Access.

> Exposure to Data Modeling, Normalization, and Business process Analysis,

Reengineering and Logical & Physical database designs.

> Strong interpersonal skills, with demonstrable verbal and written

communications to maintain effective work relationships with all levels

of personnel.

> Experience in educating and supporting end-user reporting needs using

Microstrategy, Business Objects.

Skill Set

Reporting MicroStrategy Suite 7.x/8/9.3,Business Objects XI R2/R1/5i,

Tools: Business Objects Enterprise Products as Designer, Universe

Designer, Web Intelligence, Supervisor, Broadcast Agent,

Publishing Wizard etc, Crystal Reports XI R2/9.0/8.5,SSRS

Databases: Oracle 9.0/8.0/7.3, SQL Server 2000/7.0/6.5 and MS Access.

Languages: SQL, T-SQL, SQL*Plus, PL/SQL, HTML, DHTML, CFML, Visual

Basic, Java Script, VB Script.

Operating Unix, MS DOS, Windows 2000/98/95/, Windows NT, Windows XP.

System:

Front End: Business Objects XI R2/R1/5i, Crystal Reports XI/9.0/8.0/7.5,

Developer 2000 and SQL Server

Packages: MS Office 2000.

Other Tools: MS - Access, TOAD, Designer 2000, ERwin

1 Educational Profile

> Business Objects Certification.

> Scrum Master Certification

> Microsoft Certified Solutions Developer (VB, Advanced VB, SQL, SQL

Architecture.

> Bachelors Degree in Commerce

CAMICO MUTUAL INSURANCE COMPANY, CA

Business Analyst/Sr. Report Analyst

June'07 - Present

CAMICO is the nation's largest CPA-directed program of professional and

employment practices liability insurance for accounting profession. For 25

years, CAMICO has been dedicated to the security and success of CPA's.

Responsibilities:

> Involved in designing, developing and deploying reports in MS SQL Server

environment using SSRS-2008 and SSIS in Business Intelligence Development

Studio (BIDS).

> Used SSRS to develop different kinds of reports like canned, ad-hoc

reports for the State and Local Agency users.

> Involved in creating multiple parameterized stored procedures which were

used by the reports to get the data.

> Worked on formatting SSRS reports using the Global variables and

expressions.

> Deployed and uploaded the SSRS reports to SharePoint Server for the end

users and involved in enhancements and modifications.

> Created parameterized reports, Drill down and Drill through reports using

SSRS.

> Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming

and loading data into data warehouse.

> Designed SSIS Packages to transfer data from flat files to SQL Server

using Business Intelligence Development Studio.

> Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to

optimize queries and enhance the performance of databases.

> Involved in Analyzing and Documenting End User requirements, Business

requirements and Data Specifications for Microstrategy reports for the

claims, sales, marketing and underwriting department.

> Developed the data warehouse using SSIS for the Micorstrategy project for

the claims department, sales, marketing and underwriting deptartment .

> Integrated Microstrategy with R which is the common tool used by

actuaries in the insurance field to make analysis.

> Integrated Microstrategy with salesforce for the sales dept.

> Developed MicroStrategy application objects such as Metrics, Filters, and

prompts to compare monthly, quarterly and annual sales.

> Used analytical and governing settings in VLDB properties to tune the SQL

and for calculating the metrics in dealing with the nulls and Zeroes in

data

> Generated reports by using custom groups and included consolidations in

order to group attributes and customize the reports.

> Involved in creating Triangles dashboard for the claims dept. which

automated the whole process.

> Involved in creating the dashboards for claim analysis on monthly,

quarterly and annual basis.

> Created required schema objects and public objects for the enhancements.

> Create Freeform SQL reports, Intelligent Cubes.

> Upgraded and installed the Microstrategy software.

> Created Microstrategy projects in various environments to facilitate

development and testing

> Maintained project level security and object level security based on the

requirements

.

> Involved in Analyzing and Documenting End User requirements, Business

requirements and Data Specifications for Business Objects reports.

> Involved in the creation of Universes, Classes, Objects, and Hierarchies

for Multidimensional Analysis.

> Created new Facts, Attributes and Attribute Form Expressions and

Hierarchies as needed in the project..

> Involved in generating adhoc report generation for the client's immediate

needs.

> Worked extensively on Report services document which contains data from

several reports which are useful for the management. Also worked on

creating scorecards and dashboards, managed metric documents and

operational documents.

> Implemented advanced data drilling features, drill maps that allow users

view the reported information in greater detail.

> Performed knowledge transfer to the business users, documented the

general design of the reports.

> Crystal Reports used to produce the data to serve more than 600 users.

> Different types of complex Reports developed include Cross Tab Reports,

Linked and Unlinked Sub-Reports, Manual Running Totals, Detail and

Summary Reports.

> Migrated successfully all the reports from Seagate Info Crystal Reports

7.5 into Crystal Reports 9.0 and Crystal Enterprise 9.0 and Crystal

Reports Xi.

> Made these reports available to all the users in USA through Crystal

Enterprise and scheduled with Parameterized options.

> Reports were designed in such a way that it takes common Parameters for

all the Sub Reports used in the Main Report.

> Created adhoc reports in Crystal Reports XI for some of the Key Metrics

required for the management and exports it to Excel for use in Power

point presentation.

> Having experience in building combination of Business Objects Universes

and Crystal Reports.

> Scheduling of Inventory Reports Weekly, Monthly and distributing them via

email and FTP to a network location for archiving.

> Created PL/SQL stored procedure for accessing and manipulating data from

database.

> Developed Stored Procedures, Functions to input data into Crystal

Reports.

> Used Crystal Management Console administrative like adding users,

creating groups, folders and publishing reports.

> Used Crystal/Business Objects Enterprise to distribute the reports.

> Created Sub-reports and linked to main report.

> Installed Crystal Reports software on some of the Clients machines and

created ODBC to retrieve data from SQL server 2005/2000/7.0.

> Periodical Scheduling for Reports to run automatically. Implementation

and periodic maintenance, activity Optimization of Queries used in

Business Object.

> Experienced with project methodology process and application or system

development lifecycle (SDLC) for various projects in the organization

> Developed number of Custom Reports with different types and modified

standard reports as per customer/end user requirements. Developed Drill

Down Reports.

> Deployed the reports on Production servers Info Desktop and schedule

reports for the use of end users and customers.

> Interacted with end users to gather specifications for the development of

these reports.

> Environment: Microstrategy 8/9 Crystal Enterprise, Crystal Reports

Xir2/10/8.5, Business Objects 5i/6i, Universe Designer, Web Intelligence,

Supervisor, Broadcast Agent, Info Viewer, Oracle 9i/8i, SQL Server

2005/2000/7.0, TOAD, PVCS, MS Excel, Windows XP, Windows NT 4.0, and

Windows 2000

> Requirements gathering and Business Analysis using the Use-cases,

functional specifications, and business rules.

> Proficient in Relational Database Management Systems, SQL, PL/SQL

Experience in complete life cycle of systems design and development.

> Wrote SQL, PL/SQL codes, stored procedures, packages and triggers.

> Performance and fine Tuning of SQL & PL/SQL stored procedures and on

development/production databases. Worked on data loads using Oracle

PL/SQL and SQL*Loader. Used TOAD to develop oracle PL/SQL, DDL's, and

Stored Procedures.

> Creating Pre-Session and Post-Session Stored Procedures.

> Optimize SQL queries for better performance.

> Developed front-end web pages using ASP pages with HTML and VBScripts.

Contact this candidate