SUMMARY:

• A Microsoft Certified Technology specialist with over 8 Years of experience with Data Warehousing/OLTP applications across various SDLC environments using SQL Server 2005/2008R2/2012.
• Extensively worked ondata modeling,NormalizationandDe - Normalizationtechniques for both OLTP and OLAP.
• Experienced in writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Experienced in ETL/Data warehousing systems, Data mapping, data dictionary, ODS/Staging/EDW areas for Migration/Development/Deployment/configuration of SSIS Packages in both ETL/OLTP environments.
• Experienced withDTS/SSIS (SSIS2005/2008/2008R2/2012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for Data transfers andETLPurposes across different servers.
• Knowledge with Microsoft technologies ASP.NET C# web applications
• Knowledge on Microsoft Dynamics CRM with 2011/2013/2015 (On-Line and on-Premise)
• Excellent knowledge increating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined functions, IndexesusingT-SQL
• Extensively used various features of SSIS Packages (Control Flow tasks, Data Flow tasks, Transformations, Migration tasks).
• Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Designed and developed tabular reports using Power BI features and enhanced them based on user requirements.
• Hands on experience in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL.
• Knowledge on Installation, Configuration, Development, Deployments and Troubleshoot Reporting services using SSRS 2005/2008/2012 across various environments.
• Experienced in creating various types of SSRS reports(table, chart, list, Matrix Tablix reports).
• Designed and developed Drill down, Drill through, parameterized reports with Drop down menu options using SSRS.
• Integrating CRM with SSIS packages for importing and exporting data.
• Report creation using Dynamics CRM using 2013 and migrating the reports to 2015
• Strong working experience in Developing reports on SSAS & SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services (SSAS).
• Knowledge on Tabular cubes using Power BI and implementing DAX expressions with in Power Pivot.
• Knowledge on MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Strong Ability to work independently or as part of a team to accomplish critical business objectives as well as good decision making skill under high pressure complex scenarios.

TECHNICAL SKILLS:

Databases: SQL Server (2000, 2005, 2008,2012), IBM DB2, Oracle 10G, MS - Access, MySQL

Database Tools/Languages: C#, .Net,VB.Net, T-SQL, PL/SQL, XML, SSRS, SSIS, SSAS, DTS, Business Intelligence Studio(BIDS), SQL Management Studio, Query Analyzer

Operating Systems: Windows (XP/7/8), Windows Server 2012/2008/2003, UNIX

Data Modeling tools: SSAS(SQL Server Analysis Services(SSAS), ERWIN, BPWin, MS-Visio

Reporting Tools: Reporting Services (SSRS 2012/2008/2005), Crystal Reports, Power BI

ETL Tools: Microsoft Integration Services (SSIS 2012/2008/2005), DTS

Other Tools: Microsoft Visual Studio 2008/2010/2012, Team Foundation Server, VSS

Web-Portal Technologies: HTML, Photoshop, Visual Studio, MS Front Page, ASP.NET, XML, Web Services,AJAX,CSS, DHTML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

MSBI/SQL Developer (SSRS/SSIS/SSAS) Developer

Responsibilities:

• Working in close quarters with business, application developers, and productionteams across functional units to identify business needs and discuss optimal solutions.
• Creating ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Involving in ETL architecture enhancements to increase the performance, automate the processes.
• Developing Sub Reports, Matrix Reports, Charts, and Drill down reports, usingSQL Server Reporting Services.
• Developing and deploying SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Implementing Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Using Power Pivot to create tabular cubes and deployed them in Analysis Services.
• Creating relationships in Power BI Designer, Uploading reports from the Power BI Designer.
• Rigorously testing and debugging the Stored Procedures and using Triggers to test the validity of the data after the insert, update or delete.
• Created Reports on CRM and customized based on the requirements from the clients
• Actively involved in developing several Sub Reports, Matrix Reports, Drill down, Drill through, Matrix Reports, parameterized reports using SQL Server Reporting Services 2008/2012/2014.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL
• Monitoring Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Responsible for Dimensional modeling, defining relationships between Dimensions and Measure groups.
• Written a script for different connection like share point link, shared drive and SFTP for sources within SSIS packages.
• Creating the data source views and defined granularity with in a measure group and drill through actions.
• Reviewing cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
• Creating SLAs and Knowledge base articles for the Users and Customer Service based on the level of support.
• Working with installation, configuration and deployment of SQL Server Reporting Services (SSRS), developing various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Building complex multi-sectional reports with charts and drill-down capabilities, creating report models for AD-HOC reports when the end user wants to see the reports on fly and also creating Ad-hoc reports for manager using SSRS to find all the work items open for Developers.
• Involving in developingad-hoc business requests,Power PivotandPower View reports for team.
• Creating and maintaining Roles and Database users
• Involving in code reviews, code migration and deployments across all environments.

Environment: MSSQL Server 2012/2008/2005, T-SQL, PL/SQL, Visual Studio 2012/2008, SQL Server Reporting Services (SSRS 2012/2008/2005), SQL Server Integration Services (SSIS 2012/2008/2005), SQL Server Analysis Services (SSAS 2008)

Confidential, Westborough, MA

MSBI Developer/SQL Developer

Responsibilities:

• Studied existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Written complex stored procedures, queries, triggers, functions and cursors for the OLTP batch and online processes.
• Created indexes, Constraints, and rules on database objects.
• Solely responsible for identifying and defining Data Source and Data Source views mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Migrated data from various data sources like Oracle, Flat files, upstream systems into Staging, ODS and DWH areas using DTS/SSIS.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Worked on Dimensional modeling, Defined relationships between Dimensions and Measure groups.
• Created SSAS cubes and loaded dimensions and facts, Defined attribute properties in a Parent Child Dimensions.
• Created the data source views and defined granularity with in a measure group and drill through actions.
• Reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
• Worked with installation, configuration and deployment of SQL Server Reporting Services (SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Worked with SSRS 2008 Report Builder and allow customers build their reports using Report Builder.
• Performed reporting and included interactive drill down reports, report models and dashboard reports and security implementation for the reports.
• Created and maintained Roles and Database users.
• Involved in code reviews, code migration and deployments across all environments.

Environment: MSSQL Server 2012/2008/2005, T-SQL, PL/SQL, Rapid SQL, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Integration Services (SSIS2008/2005), (BIDS), ERWin, MS-Access, Oracle 11i/10g

Confidential, Providence, RI

SQL Server MSBI Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups,and Derived Columns with Multiple Data Flow tasks.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Created Packages using Complex Store Procedures and TSQL queries.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task FailedEvent Types.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files.
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grid’s
• Configured, Installed and Administered Reporting Services 2005/2008.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• CreatedETL packages with different data sources(SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations usingSSIS/DTS packages.
• DevelopedCubes using SQL Analysis Services (SSAS)and Experience in Developing and Extending OLAPCubes, Dimensions and data source views.
• Extensively involved in theSSAS storageandpartitions, andaggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions.

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle9i, VBScript

Confidential, Pittsburgh, PA

SQL Server / MSBI Developer

Responsibilities:

• Extensively worked on SSRS, SSIS, SSAS, for designing the EDW.
• Created package with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked on creating mapping document with business requirements, source to destination schema mapping along with the ETL logic and created design documents.
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Written complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Monitored execution plans to enhance the performance of the queries.
• Ensured database integrity, indexing, segmentation and recovery and update database design over time.
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Designed, developed, implemented, and maintained reporting frameworks.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Worked on Performance Monitoring with SQL Profiler and Windows System Monitor.
• Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards.
• Built SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Created Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Erwin 7x

Confidential, Morristown, NJ

SQL developer/SSRS/SSIS

Responsibilities:

• Actively involved in the complete software development life cycle for a design of database for new Financial Accounting System.
• Converted logical database design into Physical Schema using either 2nd or 3rd Normalization to obtain highest performance.
• Successfully implemented the physical design of the new designed database into MSSQL Server 2005.
• Stored Procedures and Functions were optimized to handle major business crucial calculations.
• Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them.
• Implemented data collection and transformation between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Created necessary triggers to ensure data and referential integrity incorporating business logic.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Defined Check constraints, rules, indexes and views based on the business requirements.
• Documented the database design and developed data dictionary for databases.
• Managed the historical data in the data warehouse from various data sources.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.

Environment: SQL Server 2000, SQL Server 2005(SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SQL Server Integration Services (SSIS), MSSQL Server2005 Analysis Server), MS-Reporting Services, XML, ASP.Net, VB Script

Confidential

MS SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2005.
• Written complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• Designed, Built the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2005).
• Designed and developedSSIS Packages to import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Worked on different kinds ofTransformationsinSSISas per the client’s Requirement.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: SQL Server 2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003