SUMMARY

• 7+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2012/2008R 2/2008/2005/2000 system in OLTP and OLAP environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008R 2/ 2008/2005/2000.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2012/2008R 2/2008/ 2005.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility.
• Extensive Knowledge in SSASstorage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes withSSAS 2008 and in adding calculations using MDX.
• Expert in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data
• Proficient in Creating business critical KPIs using SQL ServerAnalysis Services SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Strong experiences to Design, deploy, and maintain various SSRS Reports in SQL Server 2012.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Create Metadata Repository database to store metadata.
• Performed XML transformations a language for transforming XML.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS)

Languages: SQL, T-SQL

Operating Systems: Windows 98/2000/2003/ XP/ VISTA, Windows Server 2000/2003/2008/2008 R2/2012

Databases: MS-SQL Server / 2008 R2 / 2012

Reporting Tool: SSRS

Application Software: Visual Studio, Visual Source Safe, MS Office, Team Foundation Server, Sub-Version

PROFESSIONAL EXPERIENCE

Confidential

MS SQL BI Developer

Responsibilities:

• Modified the existing stored procedures to get the new functionality depending on the client requirement.
• Created many tables with the clusters and non-clustered indexes on columns.
• Created various database objects such as tables, indexes and views based on requirement.
• Created daily, weekly, monthly reports for various categories and hierarchies based on business needs using SSRS
• Create reports such as parameterized, cascading, Drill through/Drill down reports, charts and specialized in producing sub reports using relational data warehouse and OLAP cubes.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping
• Created table valued functions and used in the report stored procedures on the fly Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization mechanisms for SSAS and OLAP databases.
• Developed Drill-down/thru, sub-reports, linked and Dashboard reports using SSRS
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated
• Conducted cost benefit analysis of various ETL tools and technologies.
• Created UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Played role in design of scalable, reusable, and low maintenance ETL templates.

Environment: SQL server 2012, SQL server Management studio, SQL server integration services (SSIS), SQL server reporting services (SSRS), SQL server Analysis services (SSAS), SQL server profiler, Microsoft visual studio 2010, Team Foundation server (TFS)

Confidential, Virginia Beach, VA

MS SQL Server Developer

Responsibilities:

• Maintained databases, performed software installations and monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Implemented automated backup and database maintenance / cleanup jobs.
• Generated Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs through SQL Server Agent.
• Designed SSIS packages for loading data from ODS to Data mart.
• Created SSIS packages for synchronizing the data between two different servers.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Experience in the design, development and maintenance of different cubes using SSAS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Managed Logins, Users, Roles and User permissions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services(SSAS)
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Generated Ad-hoc reports and cascading reports for historical data using SSRS.
• Involved in the implementation of Performance Point Server (PPS).
• Involved in Processing QNXT Healthcare Claims

Environment: SQL Server 2005, Query Analyzer, SSIS 2005, T-SQL, Excel, Microsoft SQL Reporting Services 2005 (SSRS), Windows 2000/XP, QNXT

Confidential, Raleigh, NC

SQL / ETL Developer/SSIS/SSRS

Responsibilities:

• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Creating, Approving and Modifying PA in both Portal and QNXT.
• Involved in Adding Contracts to the Provider in QNXT and associating Providers in Portal while creating claims

Environment: SQL Server 64 bit), SQL Server 2008, Windows Server 2008, VMWARE, .NET, Quest Diagnostic tools, SSIS, SSRS,QNXT

Confidential, Rancho Cordova, CA

SQL Developer/ DBA

Responsibilities:

• Administration, Maintenance of multiple SQL Server instances into Prod-Stage-DEV environment.
• Design, Setup, Implementation, upgrade and migration of SQL Server to SQL Server 2012 databases.
• Setup of jobs and alerts for Backup Restore (VLDB), integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs
• Query optimization using Show Execution Plan, SQL profiler and Query analyzer.
• Development of Indexes, stored procedures, views, functions and triggers using T-SQL.
• Setup, monitoring and maintenance of SQL Server data Replication
• Design/Development and Maintenance of multi-dimensional cube using SSAS.
• Installation, configuration and maintenance of security of SSRS 2005.
• Documentation of coding standards, Technical specifications, policies and procedures
• Provide troubleshooting, Training and support to users
• Developed and modified SharePoint user previliges as directed as incompliance with all standard operating procedures
• Installed all backup procedures and records for SharePoint installations.
• Configure of Microsoft office SharePoint.

Environment: SQL Server 64 bit), SQL Server 2008, Windows Server 2008, VMWARE, .NET, Quest Diagnostic tools, SSIS, SSRS, SharePoint

Confidential

Customer-centric database SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and also defined roles and privileges to implement business rules and control access to database.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse with different transformations in order to get the accurate data using SSIS 2008/2005 and deployed the SSIS packages to different environments by maintaining the configuration settings in the XML files and variables.
• Extensively involved in the design of SSAS storage, partitions and aggregations and developed different calculated members, KPIs, actions by using the MDX while designing the cube using SSAS 2008/2005.
• Wrote different MDX queries using different functions to gather the data from the cube and developed the reports using the SSRS 2008/2005.
• Modified the cube structure by adding the new facts, dimensions with user defined hierarchies, calculated members, attribute relations in order to optimize the cube and develop the user defined reports from the cube.
• Developed many scripts while designing the SSIS package using C#, VB.NET in order to perform various transformations while getting the data from different sources and also resolved the issues with ActiveX scripts and query driven tasks while migrating the DTS packages to SSIS.
• Provided statistical information through different reports in order to explain business conditions and scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Created parameterized reports and ad hoc reports using Report builder and developed dashboards with different KPIs, scorecards for the users/management and deployed them using Excel, MS Share Point (MOSS).
• Used ASP.Net controls like Dropdown list, Button, Textbox controls while developing the user interface and developed complex web forms and business components.
• Extensively worked with the SQL Profiler, Database Tuning Wizard and query execution plans to identify the slow running queries and to test different application for performance.

Environment: MS SQL Server 2005/2008, SSRS 2005/2008, SSIS 2005/2008, SSAS 2005/2008, SSMS, ASP.NET, VB.NET, C#.NET, MDX, T-SQL, PL/SQL, Oracle 10g, MS Share Point, Access and Excel.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate Consistency Data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee requirement and generating records between front End and back end.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Experience in Data Modeling using Erwin Design Tool
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Worked to establish connectivity between VB applications and MS SQL server by using ODBC

Environment: T-SQL, MS SQL Server 2000, SSMS, DTS, Erwin, Windows NT server, VB, Visual Basic.net