Data Sql Server

Kishore

************@*****.*** 682-***-****

Professional Summary:

Over 5+ years of in depth experience in database Design, Modeling, development, administration and

●

maintenance of SQL Server 2012/2008R2/ 2005 / 2000 large scale databases.

Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and

●

troubleshooting SQL Server 2008/2005/2000.

Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data

●

Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and

appropriate Triggers to facilitate efficient data manipulation and data consistency.

Expert in writing T SQL queries, creating clustered and non clustered Index, working on DTS, Data

●

Cleansing and Data Migration.

Extensive experience in Microsoft stacks of BI solutions SSRS, SSAS, and SSIS with MS SQL

●

2008/2005.

Proficiency in creating different types of Reports such as Cross Tab, Drill down, Summary, Parameterized,

●

Sub reports and formatting them using SSRS.

Assisted in development of ETL architectural standards and provided guidance and conducted trainings to

●

Architects.

Crystal Reports development focusing on website/email tracking, database queries and accounting.

●

Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production

●

Server.

Experience in transforming unstructured data from various data sources using SSIS Transformations like

●

Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.

Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the

●

errors.

Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services

●

(SSAS).

Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000 to

●

SQL Server 2005.

Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.

●

Highly experienced in database server performance tuning and optimization of Complex SQL queries.

●

Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes,

●

Access) and power pivot.

Launching the report builder for adhoc reports.

●

Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows

●

Performance Monitor for monitoring and tuning MS SQL Server Performance.

Performed DBA tasks using Enterprise Manager and Query Analyzer.

●

Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.

●

Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore

●

procedures.

Implemented different Replication Models like Snapshot, Merge, Transactional and Database Mirroring.

●

Good Knowledge in designing Database Models using UML, MS Visio and Erwin.

●

Ability and willingness to learn new technology and deliver results in a timely manner.

●

A well organized, goal oriented, highly motivated effective team member.

●

Education:

Bachelor’s

Business/Technical Skill:

MS SQL Server 2000/2005/2008R2/2012, SQL Server Integration Services (SSIS), SQL Server DTS, Data

Stage, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Rational Rose,

Oracle 9i, VB6, Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Power Point, T SQL, PL

SQL, HTML, XML, C++, JavaScript, C#,ASP.net, Share point, ODBC, MS Visio 2008.,Erwin.

Project Summary

PSCU, TAMPA FL

SSIS/ETL DEVELOPER DEC2014 TILL NOW

PSCU is a leading provider of traditional and online financial services to credit unions. One of the nation’s

leading Credit Union Services Organization (CUSO). Which represent more than 800 credit unions and

more than 18 million cardholders and innovative bill payment solutions to over a million online bill payment

subscribers. The Project was to convert SAP DI packages into SSIS

Responsibilities:

• Convert the SAP DI packages into SSIS and created new SSIS packages to Extract, transform

and load the data from old data warehouse to new data warehouse and OLTP to OLAP

• Worked as a database developer on databases like Oracle Server using Pl SQL, stored procedures

and views to get data from Data warehouse.

• Created and maintained technical documents for ETL Process

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse

databases

• Used Package configurations, Variables and Expressions while creating the SSIS packages.

Use ETL to implement the slowly changing Transformation, to maintain Historical Data

•

• Responsible to create test cases and performed system testing for the SSIS packages using SSIS

2012.

• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets

• Wide knowledge of ETL architecture, data schemas and SSIS packages

• Identified the data sources and created source to target mapping documents to be used by the

packages in SQL Server Integration Services (SSIS).

• Extensively worked on SCD transformation in SSIS package.

• Design ETL Framework for SSIS Packages.

• Successfully deployed SSIS packages with defined security.

.

Tools & Technologies:

SSIS, MS SQL Server 2012, Oracle 9g, 11g Visual studio 2010, 2012, MS Excel, SAP DI

New Century Healthcare, CA Aug14 – Dec14

MS SQL Server Data Analyst /SSRS/SSIS Developer

New Century Healthcare is a national Cancer and Cardiology Care management Company that Provides

that innovative solutions to ensure quality and affordability. The Project was to calculate fee structure for

southern California.

Responsibilities:

• Manipulating, Cleansing & Processing Data using Excel, Access and SQL.

• Responsible for loading & Processing Data Using Excel, Access and SQL.

• Analyzing raw data, Drawing Conclusion & developing Recommendations.

• Writing T SQL Scripts to manipulate data for data loads and extracts.

• Developing data analytical database from complex Financial Source data.

• Preforming Daily system Checks.

• Data entry, data auditing, creating data reports & monitoring all data for accuracy.

• Designing, developing and implementing new Functionality.

• Monitoring the automated loading Processes.

Advising on the suitability of Methodologies and suggesting improvements.

•

Carrying out specified data Processing and statistical techniques.

•

Supplying qualitative and quantitative data to colleagues & clients.

•

Using SSIS to extract transform & Load source data from transaction.

•

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute

•

SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml

task.

Created SSIS Packages to export and import data from CSV files, Text files and Excel

•

Spreadsheets.

Tools & Technologies:

SSIS, SSRS, MS SQL Server 2012, Visual studio 2010, MS Excel

Herbalife, Los Angeles, CA Nov13 – July14

MS SQL Server /SSRS/SSIS/SSAS Developer

Herbalife International is a multi level marketing company that sells nutrition, weight management and

skin care products. The Project was to create a new PayPal payment method for the company.

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and

division using SQL Server Reporting Services (SSRS)

Developed various operational Drill through and Drill down reports using SSRS

•

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

•

• Used cascaded parameters to generate a report from two different Data Sets.

Involved with Query Optimization to increase the performance of the Report.

•

Developed Reports for business end users using Report Builder with updating Statistics.

•

• Create charts and pivot tables in Excel.

• Updated functional specification and technical design documents.

• Develop reports using complex formulas and to query the database to generate different types of ad

hoc reports using SSRS.

• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins

and statements for applications.

• Designed an OLAP system with the help of ERWIN to visualize data structure.

• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration

Services (SSIS) 2005.

• Generated daily, weekly and monthly reports using SSRS 2008.

Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service

•

Management System.

• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute

SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml

task.

• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.

• Designed and developed matrix and tabular reports with drill down, drill through and drop down

menu option using SSRS.

• Created Ad Hoc Reports, Summary Reports, Sub Reports, and Drill down Reports using SSRS

• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer

representatives for various categories and regions based on business needs using SQL Server

Reporting services (SSRS).

• Problem identification, troubleshooting, resolution, and index tuning databases.

• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.

• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Tools & Technologies:

SSIS, SSRS, MS SQL Server 2012, 2008, R2/2005, C#, SharePoint, Visual studio 2008, MS Access, MS

Excel, MS Office Access 2007

Wells Fargo, San Francisco, CA Dec’12 Oct’13

MS SQL Server /SSRS/SSIS/SSAS Developer

Wells Fargo is financial services company with operations around the world. Project PACT involves with

certification of access of every users who are entitled to access any application across the wholesale LOB.

Responsibilities:

Worked as a database developer on databases like MS SQL Server 2008R2 using T SQL, stored procedures

●

and views to get data from Data warehouse.

Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute

●

SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to

export cleaned data from Excel, Text file, XML file to different data Marts.

Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

●

Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA

●

Server and Production server

Made Master Child package using variables and Execute package task in SSIS.

●

Wrote VB.NET code for Script task to perform functions that are not available in the built in tasks and

●

transformations that SSIS provides.

Deployed, Tested and Scheduled SSIS packages.

●

Worked on designing reports using SSRS 2012 mainly Parameterized reports and Sub reports.

●

Printed contracts and reports from Quick Reports and Crystal Reports.

●

Used Crystal Reports for sales tracking, advertising renewals and billing purposes.

●

Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and

●

Parameterized and Linked reports.

Created AD Hoc reports using Report Builder and maintained Report Manager for SSRS.

●

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports

●

including current status.

Maintained report models for ad hoc reports and deployed on report server.

●

Generated test data and tested database to meet the functionalities deliverables in the project documentation

●

and specifications

Developed incremental loading using MERGE statement in SQL server 2008R2.

●

Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T SQL

●

statements using SQL profiler

Used Execution Plana and Database Engine Tuning Advisor to optimize queries and enhance the

●

performance of databases

Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data,

●

joins from the database tables and normalizing them.

Environment: Windows Server 2003, SQL Server 2012/2008R2, SharePoint, SQL Profiler, Microsoft

Visual Studio 2008, SSIS, SSRS,VB.Net.

Citigroup Inc. NYC Jan’10 Nov’12

MS SQL Server SSIS / SSRS Developer

Citi Cards is part of the global operations of Citigroup Inc., the leading global financial services company

with some 200 million customer accounts in more than 100 countries. Citigroup Global Consumer Group

includes our consumer product offerings in North America and around the world, including banking

services, credit cards, loans and insurance.

Responsibilities:

Requirements gathering, Analysis and Design of all the client requirements.

●

Performed Data Modelling and Developed logical and physical model using Erwin and implementing them

●

to sql server.

Wrote custom T SQL stored procedures and triggers to improve performance, preserve referential integrity,

●

and provide additional application functionality.

Created SSIS packages using various data transformations like fuzzy lookup, derived column

●

transformation etc to migrate the old Bills information, Customer Information, Contracts Information and

other important data.

Used Crystal Reports to tracked logins, mouse overs, click through, session durations and demographical

●

comparisons with SQL database of customer information.

Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables,

●

which were used for doing all the calculation. Then the data was moved to the core tables and the staging

tables were deleted.

Designed, coded and implemented ad hoc reports using existing report models in SSRS.

●

Identified the Data Source and defined them to build the Data Source Views.

●

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports

●

using Variables, Expressions and Functions for the reports.

Managed Alerts for successful or unsuccessful completion of scheduled Jobs.

●

Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click through and

●

demographical comparisons with SQL database of customer information.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non

●

Clustered Indexes for significant performance boost.

Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

●

Involved in testing, bug fixing and documentation for the project.

●

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), SQL Profiler, MS Office, Erwin, Windows

Server 2003.

Blue Care Network, Southfield, MI Feb’09–Dec’09

MS SQL Server/BI Developer (SSIS, SSRS, SSAS)

Blue Care Network is one of the nation’s best Health care organizations. Blue Care Network features award

winning disease management programs and the largest HMO network of physicians and hospitals in the

state. Blue Care Network has a Health Care Online Web portal, which helps Physicians and Hospitals to

interact with each other. The main project goal was to extract data from various data marts and loaded into

SQL Server Integration Services and also created, designed and modified reports as per requirements.

Responsibilities:

Gathered requirements about the project which was used to create the SSIS 2008 packages.

●

Wide knowledge of ETL architecture, data schemas and SSIS packages

●

Identified the data sources and created source to target mapping documents to be used by the packages in

●

SQL Server Integration Services (SSIS).

Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.

●

Used Package configurations, Variables and Expressions while creating the SSIS packages.

●

Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the

●

data flow from one stage to other.

Used various transformations in the ETL packages while transferring the data from OLTP source to

●

destination using SSIS 2008.

Used SQL server agent to automate the SSIS package execution.

●

Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.

●

Made various report parameters and query parameters to create parameterized reports using SSRS 2008.

●

Created reports having actions like URL and bookmarks which helped to easily navigate through the report

●

using SSRS 2008.

Implemented caching of reports and managed the report history in the Report Manager.

●

• Performed complex Expressions to create calculated fields and used Global Variables in SSRS

2008.

• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data

warehouse.

Created stylish reports and implemented conditional formatting using SSRS 2008.

●

Deployed and managed the reports in the Report Manager using SSRS 2008.

●

Wrote complex stored procedure, views using T SQL in Management Studio

●

Optimized the queries for efficient data retrieval by implementing indexes on the tables.

●

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T SQL, Windows NT.

Contact this candidate