SUMMARY

• Over 7 years of IT Experience in Database Design, BI - Development of Microsoft SQL Server 2008/2005 on various development, test and production environments with various business domains like Financial, Insurance and Manufacturing.
• Experience in writing T-SQL (DDL and DML) scripts in all MS SQL server environments.
• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2008/2005/2000 .
• Hands-on experience and exposure to different phases of Software Development Life Cycle (SDLC).
• Database Maintenance Plan design to keep track of the performance of MS SQL Server, which covers updating database statistics and Re-indexing of clustered and non-clustered indexes in production environment.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Used SSIS Import/Export Wizard for performing the ETL operations.
• Demonstrated expertise in MS SQL Server 2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Expertise in building and migration of various DTS packages.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience using different Version Control Tools like Microsoft Source Safe and CVS.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures using SQL Server 2005/2008 Analysis Services.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
• Developed reports using global variables, expressions and functions.
• Created various Complex Formula Reports to query the database for business Intelligence.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, Java

Databases: SQL Server 2008/2005/2000 /7.0, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Web technologies: .Net, ASP.Net, Ado.Net, Silver light, J-query, Ajax, JavaScript, CSS

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista/ 2008/2008.1

Database Tools: SQL Query Analyzer, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, NC

SSIS/ SSRS Developer

Responsibilities:

• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Worked closely with IT project managers, programmers, and testers.
• Created SQL Server Reports using SSRS 2008R2 for the manager and the users involved.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Developed and deployed SSIS packages in Production Server.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Involved in performance tuning of T-SQL queries and Stored Procedure.
• Created parameterized reports for the users.
• Formatted the report layout for the requirement of the end users.
• Created complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, TFS 2010

Confidential, Atlanta, GA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Installed, Configured, Managed and Monitored SQL Server 2005/2008.
• Creating tables, indexes and designing constraints.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Developed and deployed SSIS packages in Production Server.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.

Environment: SQL Server 2008/2005/2000, SSRS 2008, SSIS 2008, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, Herndon, VA

SSRS Developer

Responsibilities:

• Interacted with Business team to collect data for the conceptual design of the system.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Migrated crystal reports to SQL Server Reporting Services (SSRS).
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Deployed and configured the reports in the Report Server.
• Worked closely with IT project managers, programmers, and testers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimized Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
• Trained end users with step-by-step instructions to access the pre-build or published reports.
• Designed and developed various complex reports and different types of charts.
• Generated reports that can handle dynamic grouping and dynamic sorting.
• Created drill down, drill through, sub reports and many more complex reports.
• Created interactive data exploration, visualization and presentation using power view.
• Used power pivot to import data from sources such as SQL Server, XML, Microsoft Access and even web based data.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Oracle 9i/10g, Microsoft Office Share Point Server, XML, TFS 2010

Confidential, Skokie, IL

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created SQL Server Reports using SSRS 2008 for the manager and the brokers involved.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Involved in performance tuning of T-SQL queries and Stored Procedure.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Deployed the developed reports and upgraded the system.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows XP

Confidential, Baltimore, MD

SQL developer/ SSRS

Responsibilities:

• Involved in new databases design and creation using Rational Rose.
• Created Database Diagram using third party tool Erwin in beginning of the project, identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Created database and database objects like tables, stored procedures, views, triggers, rules, defaults user defined data types and functions with T-SQL to facilitate data consistency.
• Created multiple hierarchical aggregates for faster performance.
• Created perspective of the cube to simplify the process of browsing for the end users.
• Supported all production operation activities with focus on integration and development of new and existing products and services.
• Liaised with project management and development teams to identify and implement reporting, control, and automation opportunity to improve overall access to information.
• Created report snapshots to improve the performance of SSRS.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, failure reports with error description.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Administrated the created reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005, T­SQL, Window 200 Advanced Server, ETL, SQL Server

Confidential, Los Angeles, CA

SQL/SSIS/SSRS Developer

Responsibilities:

• Created complex Stored Procedures and Functions to support the front-end application.
• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Created database triggers to implement business requirements.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Monitored growth of database objects for capacity planning.
• Involved in tuning the database and T-SQL queries using Explain Plan.
• Optimize SQL queries for improved performance and availability.
• Configured and monitored database application.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Involved in performance tuning of the database and T-SQL queries.
• Preparation of project documentation.
• Preparation of test plans for assembly testing & System Integration testing.
• Developed DTS Packages to get the reports, routinely, in the excel sheets, required by the managers for analysis.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.