PROFESSIONAL SUMMARY:

• Around Eight years of strong IT experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2 with various business domains like Banking, Insurance, Health care and Retail .
• Working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Development and Implementation experience of power BI using Power bi Desktop tool.
• Expertise in Data Warehouse Modelling with SQL Server Analysis Services (SSAS ).
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008/2013
• Use DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Creating SSAS Cube from Scratch and involved in end to end development.
• Completely Involved In Entire business.
• Sound Knowledge on Power Bi Reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in Importing/Exporting Data from various heterogeneous data sources to SQL server using transformation of OLTP data to the Data Warehouse using SSIS.
• Working with SQL Server Job scheduling to execute Integration Services packages and to send reports to the client.
• Experienced in database Installation, configuration, maintenance, monitoring, SQL jobs.
• Experienced in database backups/restoration, replication, linked server, log shipping, clustering, database mirroring.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Advance knowledge of Excel 2013 using PivotTables, Power Pivot, and PowerView.
• Experience in Performance tuning and SQL Profiler of SQL Server.
• Hands on experience in execution of Parent and Child package execution.
• Ability to work in - groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

RDBMS: SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0 , Oracle, MS Access.

SQL Server Tools: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0 , MSSQL Server Reporting Services 2014/2012/2008 R 2/2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2013/2008R2/20082005(SSAS), MSSQL Server Integration Services 2012/2104/2008 R2/2008/2005 (SSIS), Data Transformation Services(DTS), Oracle SQL Developer, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).

Operating Systems:: Windows /XP/ 2000/2003/2007

Programming Language:: T-SQL, C++, HTML, DAX, MDX.

Reporting Tools:: Crystal Reports, SQL Reporting Services and Actuate E-Reporting, PowerPivot, Power BI, Cognos Reporting tool.

Development Tool:: Visual Studios, TFS.

WORK EXPERIENCE:

Confidential, WhitePlains, NY

SR BI Consultant

Tool: SSMS,SSAS, Tera Data, PowerBI.

Responsibilities:

• Creating Data bases, tables, views, indexes, Writing Stored Procedures.
• Create SSAS Cube as Per the business requirement.
• Involved Cube development like creating Named Queries, Dimensions, measures, calculations, partitions in measure group, dimension relations, Table mapping, Aggregations and Browsing the cube.
• Worked on processing the cube as per the needed.
• Created Jobs in SSIS to run the process in cube and to get data from the data source.
• Involved in Some admin works like creating user access logins to particular users and providing access to the Database.
• Involved in daily Stand-up Meeting like Scrum Call.
• Involve din entire business by knowing the up to date business requirements from the business users and Business Analyst.
• Developing and implementing power BI using Power bi Desktop tool,
• Creating JSON Using power BI Desktop tool.
• Good Interaction with client on weekly basis.
• Worked on Deployment as per the needed.
• Done unit Testing by writing MDX queries and re-checking the data is getting matched or not.
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Created 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 packages.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.
• Develop complex MDX, stored procedures, function table and views to generate various drill-through, drill-down reports, with dynamic grouping capability, parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS.
• Lead the design, development and maintenance of custom reports using BIDS/SSDT and Report Builder.
• Implemented complex business logic with case, cast, convert, CTE using T-SQL.
• Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments.
• Monitoring Jobs and Investigate Failures.
• Create and update SSIS Packages to pull data from source to destination database.
• Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.
• Worked On Bug Fixing.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.
• Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.
• Scheduling the jobs to send the reports.

Sql Developer

Confidential, Dallas TX

Tool: SSIS/SSRS/SSAS 2014, SSMS 2014, TFS, Oracle SQL Developer.

Responsibilities:

• Creating Data bases, tables, views, indexes, Writing Stored Procedures.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.
• Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
• Created 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 packages.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server.
• Develop complex MDX, stored procedures, function table and views to generate various drill-through, drill-down reports, with dynamic grouping capability, parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub reports using SSRS.
• Lead the design, development and maintenance of custom reports using BIDS/SSDT and Report Builder.
• Use Powerpivot to extract, import and join data that coming from different sources and use DAX to create new calculated measures and make this available in Clients SharePoint Site.
• Import own data through Power BI connects to the SaaS sources you use (such as Microsoft Dynamics, Google Analytics, Salesforce, and many more) and automatically creates dashboards and reports for you. You can also import Excel workbooks from OneDrive or your computer.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Interact with the implementation MS SQL Server T-SQL scripts for ETL to enhance delivery of existing and future reporting solutions.
• Implemented complex business logic with case, cast, convert, CTE using T-SQL.
• Extensively used Package Configurations while deploying the SSIS packages from DEV- Stage, Stage - Prod environments.
• Monitoring Jobs and Investigate Failures.
• Create and update SSIS Packages to pull data from source to destination database.
• Migrated DTS packages from SQL Server 2012 to SQL Server 2014 as SSIS Packages.
• Worked On Bug Fixing.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence Development Studio.
• Generating drill through reports, drill down reports, parameterized reports, linked reports, Crystal reports, sub reports, table, matrix, charts in SSRS 2012.
• Scheduling the jobs to send the reports.

Confidential, NYC, NY

BI Consultant

Environment: : MS SQL Server 2012, TFS,T-SQL,SSAS, SSIS, SSRS, Excel, Visual Studio 2010/2012,Windows Server 2008, Oracle SQL Developer, Tableau 8.2.

Responsibilities:

• Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot).
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Created Users, Groups and Set Permissions on Server.
• Connecting to Datasources.
• Worked on Quick filters.
• Logical calculations, mapping, formatting.
• Formatted the Reports as per the Client requirement
• Updating the status to the Manager on daily and weekly basis.
• Extracted data from various sources and performed data blending.
• Creating Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Experience with the design and development of Tableau visualization solutions.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Strong knowledge on software development life cycle (SDLC).
• Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
• Created Derived Columns to fulfil the User Requirements.
• Created Parameters to reports be more User friendly to End Users.
• Connecting multiple data source with Data Blending technique.
• Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.
• Providing the Security while Publishing to the Tableau Server.

Confidential, Boston, MA

Sr. ETL/MSBI Developer

Environment: : MS SQL Server 2008 R2, TFS, SharePoint 2010, T-SQL, SSAS, SSIS, SSRS, Excel, Visual Studio 2008/2010, Informatica 8.1.1 Power Center, Windows Server 2008, tableau 7.0, tableau desktop.

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. Configured performance tuning settings using indexes, SQL profiler
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Developed ETL programs using Informatica to implement the business requirements.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Analyzed the Informatica mappings for Source to Target for Data Analysis.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Performing intensive data analysis on large data volumes, testing for quality assurance, and migrating releases into stage and production environments.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Created Parameters to achieve desired functionality.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on Dual Axis concept while working with reports.
• Created Filters, Groups, Sets on Tableau Reports.
• Created and modified some of the existing reports and dashboards.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Created conditional filters and Action links to filter the data on dashboard.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Maintaining jobs for data messaging from development server to test server for generating daily reports.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Confidential

Sr.MSBI Developer

Environment: : Windows Server 2003/2008, SQL Server 2005/2008-R2/2012, DTS, SSIS, SSRS, SSAS, Proclarity/Performance Point, Microsoft Access 2013, Visual Studio 2008/2010, Team Foundation Server, .NET, Visio 2007, VB, ASP.NET, JavaScript.

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in working with SSAS in creating cubes , data source views, named queries, dimensions and deploying of analysis services projects.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
• Experience in Dimensional Data Modelling Star and Snow Flake Schemas .
• Designed and developed SQL Server Analysis Services ( SSAS ) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX , Data Mining Models, developing reports using MDX and SQL.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX .
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Create and maintain project artifacts including; data requirements, technical specifications, test plans , etc using Business intelligence tools.
• Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Created 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 packages.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created reports that have been defined by business architect and generated reports in a Crystal format of Crystal Reports.
• Created share point pages, master pages, navigation and security, charts, score cards, KPI, SSRS reports and lists and also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Sql Developer

Confidential, Tysons Corner, VA

Environment: Windows Server 2003/2008, SSMS 2005, SSIS, SSRS, Visual Studios 2005.

Responsibilities:

• Created the tables, views, indexes, Writing Stored Procedures.
• Configured performance tuning settings using indexes, SQL profiler
• Creating database consolidating data and Loading into live database using IS.
• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrating COGNOS reports to SSRS.
• Developed optimal stored procedures and queries to create data sets for reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Involved in the performance Tuning.
• Unit tested the packages.
• Scheduling the jobs to send the reports.