SUMMARY

• Over 7 years of professional experience as a MS SQL Server/ETL/Business Intelligence developer in designing and developing T - SQL queries, ETL packages, and business reports using SQL Server Management Studio (SSMS) and Microsoft BI Suite (SSIS/SSRS)
• Extensive experience with multiple development environments including SQL Server 2005/2008/2008 R2/2012/2014, Visual Studio 2005/2008/2010, Windows Server 2003 R2/2008/2008 R2/2012, Team Foundation Server (TFS) 2008/2010, and SharePoint 2010
• Involved in system analysis, design, development, testing and implementation of projects using methodologies including Waterfall and Agile
• Experienced in developing and debugging Stored Procedures, User-defined Functions (UDFs), Triggers, Indexes, Constraints, Transactions, and Queries using Transact-SQL (T-SQL)
• Expert in query optimization and performance tuning using performance monitoring tools such as SQL Server Profiler and Database Engine Tuning Advisor, as well as analyzing Execution Plans, creating Clustered and Non-Clustered Indexes, and performing Horizontal Table Partitioning
• High proficiency in creating, documenting, and deploying ETL packages under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services (SSIS) to load data from homogenous and heterogeneous data sources into data warehouses and data marts
• Extensive working experience in staging data, cleansing data, and transforming data using transformations including Sort, Lookup, Fuzzy Logic, Execute SQL Task, and Data Quality Services (DQS) to remove duplicates, ensure data quality, and apply business rules
• Skilled in implementing initial data load using Bulk Insert Task and Fast Load, as well as incremental data load using techniques such as Slowly Changing Dimensions (SCDs), Change Tracking, Change Data Capture (CDC), and Transactional Replication
• Expertise in designing and developing Dimensions, Hierarchies, KPIs, and Cubes in SQL Server Data Tools (SSDT) and deploying to SQL Server Analysis Services (SSAS) Server
• Profound understanding of Enterprise Data Warehouse (EDW)/Operational Data Store (ODS) modeling concepts including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake schemas
• Proficient in designing and developing complex reports such as Sub-Reports, Parameterized Reports, Drill-Down Reports, Drill-Through Reports, and Snapshot Reports in SQL Server Reporting Services (SSRS) and deploying to end users through Data-Driven subscriptions and SharePoint Server
• Outstanding analytical and problem solving skills communicating effectively to accomplish all project deliverables in a fast-paced environment

TECHNICAL SKILLS

RDBMS/OLTP: SQL Server 2005/2008/2008 R2/2012

Performance Tuning: SQL Server Profiler, Database Engine Tuning Advisor, Execution Plan Analysis, Index Design, Table Partitioning

ETL: SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Data Quality Services (DQS), Data Profile Viewer

Data Warehousing/OLAP: SQL Server Analysis Services (SSAS)

Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder 1.0/2.0/3.0, Tableau 7/8

Platforms: Visual Studio 2005/2008/2010, Team Foundation Server (TFS) 2008/2010, SharePoint 2010

Programming Languages: C#, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Edison, NJ

MS SQL Developer BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Optimized existing schemas through normalization and de-normalization techniques
• Experienced in creating multiple reports in Drill mode using tables, financial tables, cross tabs and charts using SQL Server Reporting Services (SSRS) and Microsoft SQL Server Report Builder
• Created packages using SQL Server Integration Services (SSIS) from various databases into different file systems
• Involved in the installation and of the Reporting Services and its components
• Configured and maintained Report Manager and Report Server for SQL Server Reporting Services
• Created Tabular and Matrix Reports using Report Wizard and Report Designer and identifying datasets, data regions and Report Items accordingly
• Developed complex expressions to calculate, group, filter, and format the contents of reports
• Created Parameterized Reports using Stored Procedures and Query report parameters and cascading parameters
• Created complex reports and enabled drill-down functionality and applied the required formatting
• Developed Sub-reports and Master-reports accessible by bookmarks
• Managed and scheduled reports subscriptions as well as added new users assigning appropriate roles
• Created various report models based on the business requirements
• Created Ad-hoc reports based on the requirements
• Tested, debugged, and troubleshot reports
• Deployed and published reports to the Tableau Server
• Created and develop complex SQL queries using various Joins, Sub-queries, and Stored Procedures

Environment: Windows 7.0, SQL Server 2012, Reporting Services Configuration Manager, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Visual Studio 2010, Team Foundation Server (TFS) 2008, SQL Server Data Tools(SSDT), MS Office Suite (Excel, PowerPoint, Word) 2010, Tableau 7.0

Confidential, Baltimore, MD

MS SQL Developer (SSMS/SSIS/SSRS/Tableau)

Responsibilities:

• Designed ETL (Extract, Transform, Load) strategy to transfer data from source to stage and stage to target tables in the data warehouse tables and OLAP database from heterogeneous databases using SSIS and DTS (Data Transformation Service)
• Used ETL which transfers data from remote datacenter to local datacenter using SSIS. Cleaning, messaging of the data is done on local database. From local database created cubes in SSAS.
• Used reporting services created several reports based on cube and local database
• Developed SSIS packages to export data from Excel (Spreadsheets) to SQL Server, automated all the SSIS packages and monitored errors using SQL Job on a daily basis.
• Prepared reports using SSRS (SQL Server Reporting Service) to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard.
• Involved in generating and deploying various reports using global variables, expressions and functions using SSRS.
• Involved in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in designing and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL server
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Monitored scheduled jobs and alerts created for SSIS packages and SSRS reports in SQL Server
• Implemented complex business requirement in backend using efficient stored proceduresand flexible functions, and facilitated easy implementation to the front end application.
• Closely interacted with subject matter experts in understanding the business process methodology.

Environment: Windows 7/8, SQL Server 2008 R2/2012, Reporting Services Configuration Manager, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), SQL Server Analysis Services (SSAS), Report Builder 3.0, Windows Server 2008 R2, Team Foundation Server (TFS) 2008, SharePoint 2010, Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word) 2010, Tableau 7/8

Confidential, St. Paul, MN

MS SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Worked as developer in creating complex Stored Procedures, triggers, User Defined Function (UDFs), tables, views and other SQL joins and statements for applications.
• Monitored database servers, error logs and events, scheduled backups and customized jobs.
• Created SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Designed high level ETL architecture for overall data transferring 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.
• Developed custom reports, ad-hoc reports tabular, drill down, parameterized, cascaded and sub-reports using SQL Server Reporting Services
• Gathered and analyzed requirements directly from the business users.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.

Environment: Windows 7, MS SQL Server 2008/2008 R2, SQL Server 2008, MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio (BIDS), SQL Server Profiler, Visual Studio 2008, SharePoint 2010, MS Office Suite 2010 (Excel, PowerPoint, Word), MS Team Foundation Server (TFS) 2008

Confidential, Minneapolis, MN

MS SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Worked closely with management and end-users to create and evaluate business requirements to support delivery of effective business intelligence and reporting solutions
• Determined operational objectives by studying business functions, gathering information, evaluating output, and specifying requirements and formats
• Used Transact-SQL (T-SQL) in SQL Server 2008 to develop complex Stored Procedures, Triggers, Clustered & Non-Clustered Indexes, Views, and User-Defined Functions (UDFs)
• Performed performance tuning on existing stored procedures/queries by analyzing execution plans, logs/statistics, and traces in SQL Server Profiler/Database Engine Tuning Advisor
• Developed SQL Server Integration Services (SSIS) ETL Packages and other back-end processes to support system integration and ETL processes to facilitate the creation and population of the Enterprise Data Warehouse (EDW)
• Assisted in design and data modeling efforts of Data Marts and Enterprise Data Warehouse.
• Used SQL Server Reporting Services (SSRS) to design and develop solutions to support business intelligence reports and dashboards including Sub-Reports, Snapshot Reports, Parameterized Reports, Drill-down Reports, and Drill-through Reports
• Created technical and functional documentation for SQL Server development and SSIS package development/deployment
• Reviewed documentation with developers, clarified any questions or issues, and presented to the stakeholders for approval and implementation

Environment: Windows 7, MS SQL Server 2008R2, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Visual Studio 2010, SQL Server Data Tools (SSDT), MS Office Suite (Excel, PowerPoint, Word) 2007

Confidential

MS SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Developed Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to maintain database operations, meet operational requirements, and facilitate ETL processes
• Created Clustered/Non-Clustered Index on multiple tables to improve performance of complex queries and stored procedures
• Set up SQL Server Profiler traces for long-running queries/stored procedures and analyzed the traces using Database Engine Tuning Advisor for performance/index recommendations
• Created and maintained all types of database backup and recovery strategies and set up jobs to automate maintenance jobs to run on a daily basis
• Configured SQL Server Integration Services (SSIS) ETL packages to load data from heterogeneous sources such as XML/Excel/Flat/CSV files
• Created ETL packages to perform incremental loading to Enterprise Data Warehouse (EDW) using Sequence Container, Execute SQL Task, Bulk Insert Task, Lookup, and OLE DB Command
• Developed detailed and summarized financial reports in SQL Server Reporting Services (SSRS) and deployed these reports onto Enterprise Reporting Server
• Generated weekly, monthly, quarterly, and yearly parametric, drill-down/drill-through and chart reports using SQL Server Reporting Services (SSRS)
• Built ad-hoc reports using SQL Server Reporting Services (SSRS) and Excel and created dashboards that include these reports

Environment: Windows XP, SQL Server 2005, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio (BIDS), Windows Server 2003 R2, Visual Studio 2005, MS Office Suite 2003 (Excel, PowerPoint, Word)