SUMMARY

• Over 8 + year’s of working experience in Database Design, Development & Support ofMS SQL Server 2012/2008R 2/2008/2005/2000 using SSIS/SSRS/SSAS in Financial, Retail, Healthcare, Insurance, and Banking industries.
• Experienced with all phases of Data Warehousedevelopment life cycle, from gathering requirements, testing, Functional Specifications, Technical Specs, Design documents, Implementation and support
• Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
• Good knowledge of Relational Database Management System (RDBMS), Data Warehouse Concepts,OLTPandOLAPand experience withworking onSSIS,SSAS,SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Involving Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2000 and MS SQL Server 2005 respectively
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Designed and developed ETL packages (SSIS) with variables, parameters, and expressionsand scheduling SSISpackages in SQL agent to load data to data warehouse or OLTP database using error handling, logging and deploying methodologies.
• Well - versed in usage ofSSISControl Flow items(For Loop, Execute SQL task, Script Task, Send Mail Task) andSSISData Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Worked on complete Reporting Life Cycle on Authoring, Management & Delivery. Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server 2005 Reporting Services (SSRS).
• Extensive experience inInstallation, ConfigurationandDeploymentof SSRS usingScale-Out, Scale-UpandLocal topologies.
• Excellent in Transforming Logical Database designs into Physical Databases.
• Hands-on working experience in Data warehousing like identifying the Facts and Dimensions, creating Star and Snowflake schemas.
• Good Knowledge on creatingscorecardsanddashboardsusing MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.
• Experienced in implementing Key Performance Indicator (KPI) Objects in SSAS 2005
• Experience creating Scorecards & Dashboard Reports using ProClarity.
• Good Understanding of Kimball and Bill Inmon modeling and Replication, Log Shipping and Database Mirroring
• Excellent interpersonal communication, problem solving, documentation and business analytical skills to implement best practices.

TECHNICAL SKILLS

Databases: SQL Server 2012/2010/ 2008 R2/2005/2000, Teradata, Oracle 9i/8i, DB2, MS Access.

Database Tools: MS SQL Server 2000/2005, MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development skills: T-SQL, PL/SQL,SSIS/SSRS/SSAS, Pro-clarity

Languages: VB.net, VB Script, T-SQL, SSAS, OLAP, HTML, XML, ASP, Java Script, C, C++ and MDX.

ETL Tools: DTS, SSIS (SQL Server Integration Services), SSRS, SSAS

Reporting Packages: SQL Server Reporting Services, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools: /Methodologies: MS Visio, Erwin, MS Project, Rational Rose, SQL Profiler, SQL*Loader, Front page.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

SQL SERVER\SSIS\SSRS DEVELOPER

Responsibilities:

• Worked with SSIS packages to load the data into the database.
• Developed Configured and maintained SSIS Packages using ETL Concepts.
• Implemented Stored Procedures for Automatic Scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects
• Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Fixed the bugs present in already existing reports.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Created the structure of the model and cube in MS Analysis Services (2008).
• Analyzed and designed software and database solutions.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Defined relationships between Measure groups and Dimensions.
• Generated automatically grouping attribute members.
• Implemented the calculations to aggregate physical measures.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Created reports to generate them through Email for the administrative using MDX Queries.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Modified existing reports according to requirements of the end users.

Environment: MS SQL Server 2008 R2/2012, Excel 2010, Microsoft Reporting Services (SSRS), Visual Studio 2010, Windows 7

Confidential, Phoenix, AZ

SQL SERVER\SSIS\SSRS DEVELOPER

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 databases servers.
• Worked with business/functional analysts to determine reports and analytical requirements.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Documented Report Models and Report Templates for other Team Members.
• Created Prototypes of some complex reports and validated from the production.
• Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
• Categorized reports into batch reports and on demand reports and scheduled it according to that.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
• Worked on Database space management, performance monitoring and alert management.
• Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
• Created user variables, property expressions, script task, look up transformations and data flow tasks using T- SQL.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Business Objects: Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications.
• Modify report content and export reports in multiple formats based on user input in Crystal
• Hands on experience with Business Objects life cycle implementations.

Environment: SQL Server 2012/2008R2 Enterprise Edition, Windows Enterprise Server 2008R2, SSRS, SSIS, Excel 2007/2010, VBA Macros, DB2

Confidential, CT

SQL SERVER\SSIS\SSRS DEVELOPER

Responsibilities:

• Interacted with the Business Users/Analysts to gather the requirements and converting them into Technical Specifications
• Responsible for stylish design layout like Pie charts, graphs and linked reports
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Involved in development of stored procedures, functions, triggers and views for implementation of complex business logic in the backend.
• Involved in creating the Data Quality Framework, which is a generic framework for conducting various audits for the data quality in the data warehouse.
• Involved in creating the Database Refresh Framework for synchronizing the data from the Production Server to the Reporting Server.
• Understanding the existing codebase and modifying the code for implementation of the new functionality for population of the Participant and Evaluation Data.
• Involved in production support and fixing existing code
• Documentation of the existing functionality using ER-WIN/Visio.
• Performed some small DBA tasks like backup, creating logins, Database tuning using tuning advisor.

Environment: MS SQL Server 2008 R2, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.2

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS and SSAS
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed Stored Procedures for combining Relational & Multi-Dimensional data into one query result set and created SSRS Reports on top of it.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Created and maintained databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL.
• Created SSIS packages with which data sources such as Flat files,Teradata,DB2, Excell files, and PDF files Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service
• Used Analysis Services for creating Dimensions using Attributes, defining Hierarchies, Levels & Measures, and Measure Groups.
• Built MDX queries for Analysis Services & Reporting Services.
• Defined Attribute, Dimension, Cube level properties using Analysis Services.
• Created KPIs, calculated members, Named Sets by using SSAS.
• Used MDX queries to Defined sets, member sets & creating calculated members, Named sets in Analysis Services.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Formatted reports using Global Variables & Expressions.
• Created Drill down & Drill Through reports using SSRS.
• Designed Highly Parameter driven reports using SSRS.
• Migrated SSRS Reports & SSIS Packages from SQL2005 to SQL2008R2
• Used SQL Server Profiler to trace out stored procedure calls of slow running SSRS reports and do Performance tuning.
• Actively involved in daily scrum meeting for status updates.

Environment: SQL Server 2005, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task .
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• 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.
• Used 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.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks..
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.