SUMMARY

• OverEight (8+) years of extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R2/2012.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Performance Tuning in SQL Server - Using SQL Profiler, DTA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP),Indexed Views & Schema Binding, STATS, Clustered/Non Clustered Indexes.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several detail Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Experience as Report Writer for understanding each client business reporting requirement, designing creating and maintain of simplex to complex reports.
• Experience in generating reports for OLTP and OLAP databases.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), Power view.
• Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Worked in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version ( 2005/2008/2012 ) and troubleshoot migration issues.
• Experience in designed Data Conversions from wide variety of source system using SSIS.
• Experience working with different SSIS Configuration options and Deployment Methods for different environments use.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience working with Data Cleansing technique in ETL process.
• Hands on experience working with different types Dirty Data from different sources.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views following Star schema)using SQLServer 2005/2008/2012 Analysis Services (SSAS).
• Excellent hands on experience in creating groups and measures, KPIs.
• Other Languages - Good Knowledge in front end applications like C# .NET, ASP.NET

TECHNICAL SKILLS

Database Tools: SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX, COBOL

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual Source Safe, MS Office Suite, Quality Control (QC)

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC

Version Control: TFS, Tortoise Subversion

Data Modeling: Erwin

Other Languages: C# .NET, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential - Detroit, MI

SQL Server BI Developer /SSIS/SSRS/SSAS Developer

Responsibilities:

• Analyzed the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.
• Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor
• Developed and worked with design, development, implementation and support of ETL processusing SSIS Packages in SQL Server 2008.
• Created Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations
• Worked with a combination of multiple Control Flow Tasks, Data Flow Tasks and Dataflow Transformations to build packages in SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Implemented major Event Handlers like “OnError”, “OnProgress” and “OnTaskFailed” for SSIS Packages.
• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Developed the OLAP processes for changing and maintaining the Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Worked with Calculations, Key Performance Indicators and Aggregations on SSAS Cubes
• Analyze, design, and develop, unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes as well as migrating reports to SQL Reporting Services from Crystal Reports and Microsoft Access.
• Extensively used Report Manager to configure Web URLs, E-mail and Databases to prepare reports and make reports visually appealing by adding different report formatting options and also provided
• Back end support for functional testing and performance testing

Environment: SQL Server 2008R2 Enterprise, Windows Server 2010 Enterprise, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), Erwin, Performance Point Server, MS Share Point Server, OLTP, OLAP, XML

Confidential - Broomfield, CO

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Designed and developed various types of reports using SSRS.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Agile methodology was used throughout the project, Performed pivotal role in planning and
• Developing as well as aligning with the assigned sprints.
• Developed incremental loading using MERGE statement in SQLserver 2008R2.
• Deploying and scheduling Reports using SSRSto 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.
• Improved Performance by creating Clustered and NoN clustered Indexes and by Optimizing the T-SQLstatements using SQLprofiler.
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.

Environment: Microsoft SQL Server 2005/2008, Windows Server 2008, Microsoft Visio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)

Confidential -Bloomfield, CT

SQL Server BI Developer /SSIS/SSRS/SSAS Developer

Responsibilities:

• Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and clustered environments and applied service pack.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Hands on experience with developing reports using SSRS.
• Interacted with Developers in troubleshooting application and Report Developing.
• Involved in installing SQL Server 2005 on Development, Production and WTC (Testing) machines.
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
• Interacted with concern application team in fixing the problems when ever needed.
• Created logins and users with specific roles and permissions as per security rules.
• Created daily database backup and recovery procedures for Development, WTC (TESTING) and Production environments.
• Used HIPAA Rule for personal health information held by covered entities and gives Confidential ts an array of rights with respect to that information.
• Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
• Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Involved in setting up database mirroring for production server
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Optimized Stored Procedures and long running queries using query-optimization techniques.
• Provided 24 x 7 Production support for the database using VM Ware and application issues.

Environment: Windows 2007 Server, MS SQL Server 2008/2005, MS SQL Server 2005, BIDS, SSIS, DTS

Confidential -Omaha, NE

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/20 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Create ad-hoc SQL queries for customer reports, executive management reports.
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server.

Environment: SQL Server 2005/2008, SSIS (2005/2008), SSRS (2010/2008), Maestro Jobs, Visual Studio2010, MS Excel 2007, Power Designer

Confidential - Minneapolis, MN

SQL Developer

Responsibilities:

• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping)
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for data integration and migration services.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Environment: SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005,Reporting Services 2008, Visual SourceSafe, T-SQL, MS Access, Windows 2003/2007 Server