HARSHITHA

Email:acg9vf@r.postjobfree.com

Phone: 971-***-***** 102

Professional Experience:

. A Microsoft certified Professional with 8+ yrs of experience in Data

Modeling, Database Design, Programming, Development and Implementation

of Client-Server Applications & Database systems using SQL Server

2000/2005/2008R2/2012.

. Extensive experience in using Microsoft BI studio products like SSIS,

SSAS, SSRS for implementation of ETL methodology in data extraction,

transformation and loading .

. Expert in Data Warehouse development starting from inception to

implementation and ongoing support, Strong understanding of BI

application design and development principles.

. Extensive experience & Real time working experience in Logical &

Physical Data modeling, data architecture designs.

. Understanding existing data models, data flows and data dictionaries.

. Creating new data models, data flows and data dictionaries.

. Using Normalization and De-Normalization techniques.

. Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys,

Defaults, Check, Unique etc).

. Wrote Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub

queries, Dynamic SQL queries etc.

. Programming in SQL Server - Stored Procedures, Triggers, User-defined

Functions and Views, Cursors Performance tuning of Stored Procedures and

T-SQL Queries.

. Implementing SQL Server Indexing and Query optimization using Indexes.

. Good exposure or knowledge working on C#, VB.NET framework.

. Involved in Backing up databases and refreshing Data across environments

and also in the data movement by Perl.

. Huge Data Transfers from & to SQL Server Databases using utilities /

tools like DTS, SSIS, BCP, BULK INSERT also knowledge on other tools

like Datastage.

. Creating data load and Upgrade scripts for data migrations, data

formatting and data validations.

. Creating and Managing users, roles and assigning necessary permissions.

. Experience in implementing all high availability techniques like

clustering, log shipping, replication.

. Highly experienced in whole cycle of DTS/SQL server integration services

(SSIS 2005/2008) Packages (Developing, Deploying, Scheduling,

Troubleshooting and monitoring) for performing Data transfers and ETL

Purposes across different servers.

. Experience in providing Logging, Error handling by using Event Handler,

and Custom Logging for SSIS Packages.

. Experience in Performance Tuning in SSIS packages by using Row

Transformations, Block and Unblock Transformations.

. Scheduling and Monitoring ETL Processes using DTS Exec utilities and

batch files.

. Expertise in generating reports using SQL Server Reporting Services,

Crystal Reports, and MS Excel spreadsheets.

. Good Knowledge on Microstrategy reports, Development of Metrics,

Attributes, Filters and various other Microstrategy components.

. Expert in designing Enterprise reports using SQL Server Reporting

Services (SSRS 2000/2005/2008) generated drill down reports,

parameterized reports, linked reports, sub reports, matrix dynamics and

filters, charts in SSRS 2005/2008.

. Experience in creating Ad-hoc reports, data driven subscription reports

by using Report Builder in SSRS.

. Good knowledge of Data Marts, Operational Data Store (ODS), OLAP,

Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for

FACT and Dimensions Tables using Analysis Services.

. Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and

defined data sources, datasource views, Dimensions, Measures,

Hierarchies, Attributes, Calculations using multi dimensional expression

(MDX), Perspectives and Roles.

. Performed Data Mining activities like Predictive Analysis, Forecasting

on central repository for various application and dashboard

functionalities.

. Wrote MDX Scripts to create datasets to perform reporting and included

interactive drill down reports, report models and dashboard reports.

. Created Dashboard pages in SharePoint Server that use different types of

web parts and excel services for reports.

. Created Scoreboard/Dashboard pages in Performance point server (PPS).

. Used Proclarity tool to analyze the data in the cube by using different

features like Chart view, Decomposition Tree, Performance Maps.

. Generated reports from Analysis Services cube by using proclarity tool.

. Good team player, strong interpersonal and communication skills combined

with self-motivation, initiative and the ability to think outside the

box.

Education: Bachelor of Technology in Computer Science from JNTUH, India.

TECHNICAL SKILLS

Databases MS SQL Server 2008R2/2008/2005/2000, Access, Share

Point, Oracle10g.

Programming T-SQL, PL/SQL, VB.NET, C#.NET, ASP.NET, C, C++.

Languages

Data Modeling ERWIN 7.3/7.2, Power Designer 12.5, ER Studio 8.0.1, MS

Tools Visio 14.0/12.0/11.0.

Database Tools BIDS 2008/2005, Management Studio, Analysis Services

(SSAS), Visual Studio, Query Analyzer, SQL Profiler.

ETL Tools SQL Server Integration Services (SSIS), Data

Transformation Services (DTS),

Import/Export Wizard, Bulk Insert, BCP, DataStage.

Reporting Tools SQL Server Reporting Services (SSRS), Microstrategy,

ProClarity, Report Builder, Crystal Reports, Excel.

Scripts PHP, JavaScript, CSS, VBScript, HTML and XML.

Applications Microsoft Office 2010/2007/2003, Tortoise SVN, Team

Foundation Services (TFS), JIRA.

Operating WINDOWS 2008/2003/2000/NT servers.

systems

On Time BI, Houston, TX

ETL Developer Mar 2014-Till

Date

Responsibilities:

. Installation and configuration of SQL Server 2012.

. Exported the existing data from a legacy database to a newer database and

improvised the existing the Enterprise DataWarehouse

. Optimized the existing stored procedures and automated them for various

tasks.

. Created new Database objects like Tables, Views, indexes and functions.

. Developed a new set of complex stored procedures for newer business

requirements.

. Imported data from various sources like Excel, Access.

. Used SQL profiler to optimize queries and improve the performance.

. Transformed the data using SSIS.

. Optimized the existing SSIS packages to fix various issues and improve

performance.

. Designed new SSIS packages to extract data from newer OLAP and OLTP

sources and transferred the data to SQL Server using BIDS.

. Experience in Error and Event Handling: Precedence Constraints, Break

Points, Check Points, Logging.

. Worked on troubleshooting various issues with the existing ETL process.

. Provided documentation for SSIS packages.

. Performed the deployment of the developed Packages into various

Environments and schedule them as Jobs through the SQL Server Agent.

. Worked on Microstrategy for producing various reports.

. Built new attributes, metrics and filters.

. Altered the existing attributes and metrics according to the changes at

the data warehouse level.

. Assisted on building various complex reports at Microstrategy level.

Environment: MS SQL Server 2012, BIDS [SSIS], Visual Studio 2010,

Microstrategy, MS Excel, MS Access and Window 7.

Nestle, Sandiego,CA Mar 2013-

March 2014

SQL Server BI Developer

Responsibilities:

. Installation and configuration of SQL Server 2008(R2).

. Analyzed the business requirements and building logical and physical

data models.

. Developed new stored procedures and optimize existing ones.

. Developed template scripts for users so they can generate their own

daily/weekly/monthly reports.

. Developed and implemented stored procedures and triggers for automation

tasks.

. Developed SSIS packages to extract data from OLTP to OLAP systems and

schedule the same as jobs using SQL Server Agent.

. Modify the existing SSIS packages to reflect the new business

requirements.

. Developed packages to create Error Fallout Reports, send Business and IT

mails.

. Apply various transformations like Slowly Changing Dimension (SCD),

Multicasting, Union, Derived Column and Data Conversion.

. Used various advanced SSIS functionalities like complex joins,

conditional splitting for better performance during package execution.

. Developed Unit test plans for SSIS packages.

. Performed ETL operations to support incremental, historical data loads

and transformations using SSIS.

. Set up traces and use profiler to troubleshoot performance issues.

. Created drill-down, drill-through and sub reports using SQL Server

Reporting Services 2008R2 and ability to design and deploy rich Graphic

visualizations with Drill Down and Drop down menu option and

Parameterized using Tableau.

. knowledge with building various reporting objects like Facts,

Attributes, Hierarchies, Transformations, filters, prompts, Calculated

fields, Sets, Groups, Parameters etc., in Tableau.

. Developed different chart reports for customers, based on the

requirements.

. Deploy the reports to the report manager and maintain the same providing

necessary access to the users.

. Created roles for the reports and assign them accordingly.

. Developed UI mockups and ER diagrams using Visio and assisted teams

working on Citrix and VMware.

. Used JIRA for bug/issue tracking and project management, which supports

SVN.

Environment: MS SQL Server 2008(R2), BIDS [SSIS, SSRS],Tableau 8.1,

JIRA, MS Visio 2010/2007, Source Safe, Visual Studio 2010, C#.Net 2008

and Window 7.

San Antonio Water System, SanAntonio,TX Jan 2012 -

Feb 2013

SQL Server BI Developer

Responsibilities:

. Gather business requirements from the users and develop one pager.

. Developed business and functional documents.

. Developed database objects like tables, functions, views and stored

procedures.

. Load data from flat files to SQL Server using BCP.

. Created SSIS packages to import the data into SQL Server 2012.

. Worked on SSIS Script component using Visual Basic Applications and C#,

by creating generic C# components that can be used in the external

packages in SSIS.

. Worked with the team responsible for data modeling and the development

of the applications with ASP.NET and SQL Server Database and also

extensively involved in developing business and data layers components

that are shared across the project platform and also assisted them in

extracting data from a Teradata database.

. Created reports and dashboards to retrieve data using stored procedures

that accepts parameters.

. Developed Excel reports (Regular, PowerPivot and Power View).

. Designed, developed and deployed reports in MS SQL server environment

using SSRS 2008.

. Implemented report subscription which sends out reports daily to the

different users.

. Tracking report usage by logging the information such as the number of

times the reports has been viewed and user related information.

. Store user specific parameters for the reports there by helping

customers to reduce the number of selections that need to be made every

time.

. Automate SSRS data audit reports and source - destination reports.

. Developed reports from Cubes and automate them.

. Involved in the creation of cubes in the MS SQL Analysis Services.

. Provide documentation for all kinds of reports and SSIS packages.

. Assisted in XML coding in order to create front end screen insert

activites.

. Involved in suggesting automated processes to save resources and reduce

human errors.

Environment: MS SQL Server 2008/2005, BIDS(SSRS,SSAS,SSIS), T-SQL, MS

Visio 2007/2003, TFS, Windows 2003/2000 Advanced Server, Unix, Visual

Studio 2010, ERwin 7.3, C#.Net 2005.

Mercury, LA,CA Jan 2010 -

Dec 2011

Senior BI/SQL Developer (SQL/SSIS/SSAS/SSRS)

Responsibilities:

. Dynamically supported business users for given requirements and

developed the reports accordingly.

. Developed various T-SQL stored procedures, triggers, views, and

adding/changing tables for data extraction,data load and

transformations.

. Created various database objects such as tables, indexes and views

based on the requirement.

. Created ETL packages with different data sources (SQL Server, Flat

Files, Excel source files, XML files etc). and then loaded the data

into destination tables by performing different kinds of

transformations using SSIS/DTS packages.

. Developed the packages with monitoring features and logging so that

audit information of the packages and their execution results are

loaded in to the audit table.

. Created database maintenance planner for the performance of SQL Server,

which covers Database integrity checks and re-indexing.

. Developed Cubes using SQL Analysis Services (SSAS) and Experience in

Developing and Extending OLAP Cubes, Dimensions and data source views.

. Created Dimensions with the cube wizard and also individually and

Generated Named calculations and named queries.

. Refreshing the cube to get the latest information updated and

deployment of Cubes to the production server.

. Generated various reports with drilldowns, calculated members, dropdowns

from the cubes by connecting to Analysis server from SSRS.

. Worked on large data warehouse Analysis services servers and developed

the different reports for the analysis from that servers.

. Extensively involved in the SSAS storage and partitions, and

aggregations, calculation of queries with MDX, Data Mining Models,

developing reports using MDX and SQL.

. Created data sources, connection strings and defined the datasets for

generating the report.

. Designed and written the queries in the query builder for retrieving

the data.

. Created and worked with drill down reports and identified the report

parameters.

. Used various report items like tables, sub report and charts to develop

the reports in SSRS.

. Deployed and generated reports on to the server using the Reporting

Services Report Manager.

. Worked with various Delivery mechanisms of Reports including Email

/PDF/Schedules etc.

. Created subscriptions to provide a daily basis reports.

. Managed and troubleshoot report server related issues.

. Migrated some Crystal reports to SSRS reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration

Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis

Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel,

Visual Source Safe (VSS), Windows XP, Crystal Reports, ProClarity, Team

Foundation Server (TFS) Oracle 10g/9i, VBScript.

Marathon Petroleum, Findlay OH Oct 2008 -

Dec 2009

SQL BI Developer

Responsibilities:

. Generated database monitoring and data validation reports in SQL Server

Reporting Service (SSRS).

. Created partition table for very large database for good performance.

. Designed dynamic SSIS Packages to transfer data crossing different

platforms, validate data during transferring, and archived data files

for different DBMS.

. Wrote SQL queries, stored procedures, views, triggers, T-SQL

and DTS/SSIS.

. Deployed SSIS packages and Reports to Production Servers.

. Involved in creation of Data warehouse Cubes in SQL Server Analysis

Service (SSAS).

. Migrated data using ETL Tool in SSIS.

. Maintained system monitoring jobs and provide high availability support.

. Worked on Migration of packages from DTS using SQL Server Integration

Service (SSIS).

. Participated Databases Architecture and data modeling design.

. Performing DBA functions, installing, configuring and supporting

database systems.

. Reported all events and requirements through established reporting

mechanisms in SSRS.

. Reviewed and developed data models and database designs with development

teams.

. Wrote store procedures for some job automations.

. Generated test data and tested database to meet the functionalities

deliverables in the project documentation and specifications.

. Designed and developed OLAP using MS SQL Server Analysis Services.

. Designed and developed MS SQL Server Reporting Services(SSRS) under SQL

Server 2005.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET,

VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Sonata Software Pvt Ltd, India June 2006 - Sep 2008

SQL Programmer

Responsibilities:

. Performed the Creation, manipulation and supporting the SQL Server

databases.

. Involved in Creation of tables, indexes, sequences, constraints,

triggers and procedures.

. Created stored procedures and triggers which were used to implement

business rules.

. Helped in integration of the front end with the SQL Server backend.

. Wrote triggers, stored procedures and manipulated the data using DDL

and DML functions.

. Migrated the data (Import & Export of data) from one server to other

servers using tools like Data Transformation Services (DTS).

. Written complex T-SQL statements (Queries) for retrieval of data and

involved in performance tuning of TSQL queries.

. According to the business requirements made the documentation of the

performed tasks.

. Extensively Used SQL Profiler for troubleshooting, monitoring, and

optimization of SQL Server and non production database code as well as

T-SQL code from developers and QA.

. Worked on various scripting languages like JavaScript and CSS.

. Backing up, restoring system & other databases as per requirements, and

also scheduled those backups.

. Managing the security of the servers, creating the new logins and

users, changing the roles of the users.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer,

Enterprise Manager, Import and Export, SQL Profiler.

[pic]

[pic]

Contact this candidate