SUMMARY

• Over 11+ years of IT experience in various domains as Developer dat includes Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server 2012/2008R2/2008, SSAS, SSIS, SSRS, TSQL and .NET.
• Diversified business noledge in various industries including Digital supply chain, Finance, CRM, ERP, Marketing and Logistics.
• Extensive experience in Database development for OLAP Systems (SSAS, SSIS, SSRS) using SQL Server 2012/2008R2/2008.
• Extensive experience in Analysis services development (both star and snow flake schemas) of multi - dimensional models and tabular models using SQL Server 2012/2008R2/2008.
• Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads.
• Extensive experience in providing Enterprise Reporting solutions using SSRS 2012/2008R2/2008, Power BI tools (like power query, power pivot, power views) and SharePoint Service.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance.
• Experienced on Master data services
• Developed Nine Business intelligence supporting automations for SSRS, SSIS and SSAS using C#.
• Trained on Azure machine learning, HDinsight and Azure data factory.
• Experienced on Azure SQL.
• Requirement gathering.
• Analysis Services (SSAS Multidimensional Model / Tabular Model):
• Good understanding and designing of Star and Snow Flake data models Schema used in ROLAP and MOLAP data modeling.
• Experience in designing and developing Tabular models. Implemented Role based and user based subject selection in Tabular models.
• Experience in SQL Server Analysis Services (SSAS) CUBE/Tabular design, development, deployment and tuning.
• Experience in MDX/DAX functions.
• Experience in SQL Server SSIS (Integration Service) including package design, constructing, deployment and migration.
• Extensive noledge of using Package Configuration wizard to configure SSIS packages.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and teh objects they contain, copying SQL Server objects, and loading data using SSIS.
• Experience in populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Experience in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008R2/2008, MS Access, Sybase, POSTGRESQL.

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

Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual, Visual Studio .NET.

Operating Systems: Windows10/ 8/7/XP, Windows Server 2008/2003/2000.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Excel 2013 for Power Pivots and Power views.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Data Modeling: Visio 2010.

Application Packages: MS Office Suite, MS Outlook.

Deployment and version control: TFS, MS Octopus and NSIS.

PROFESSIONAL EXPERIENCE

Confidential, Houghton, PA

Sr. Developer SQLServer

Responsibilities:

• Agile release life cycle as Power BI and SQL developer.
• Defect analysis and bug fix in SSIS packages.
• Power BI data model design and reports development using stored procedures.
• Deploying power BI reports in cloud and data refresh configuration.
• Generated failure log in log files using ETL.
• Experience on Fact and Dimension model.
• Created DAX expressions for Power BI reports.
• Implemented row level security for Power BI reports.

Confidential

Sr. Developer SQLServer/SSIS/SSAS

Responsibilities:

• Worked in Agile release life cycle as a SQL developer.
• Conduct thorough unit testing of code and document teh unit test cases wif teh halp of TFS MTM.
• Conduct appropriate performance testing to ensure solutions will meet performance criteria in meeting large volume data sets.
• Create Technical Design Specification documentation dat clearly articulates teh design and code being implemented.
• Experience on Data integrations using ETL.
• Worked on Azure migration for MSsales project
• Experienced on Azure Blob storage
• Generated failure log in log files using ETL.
• Used TFS for code repository and code merging between monthly releases
• Deployments has been performed using MS octopus.
• Prepared stored procedures for application.
• Configuration changes performed for MSRA reports generation.
• Conducted code reviews wif peer group before code check-in in TFS.
• Worked on more than 1TB database to support Microsoft sales report analysis using facts and dimensions.
• Worked on Azure SQL.
• Experience on Fact and Dimension model.
• Work experience on Power BI reports
• Created DAX expressions for Power BI reports.
• Implemented role based security for Power BI reports.
• Worked on telemetry power BI report using MSSales analysis database.
• Experienced on DBA activities like log shipping, environment setup for each release.
• Release management using msrelease tool.

Confidential

Lead SSAS/SSIS/SSRS Consultant

Responsibilities:

• Gatheird teh business requirements and dealing wif teh clients on teh same.
• Experienced in writing functional specifications and Technical specifications documents.
• In SQL DB design worked on Stored Procedures, Functions and T-SQL.
• Designed developed tabular models to hold data which can be easily used for generating Power pivots and Power Views.
• Implemented complex calculations in tabular model using DAX and complex calculations in multi dimensional models using MDX
• Experienced in Designing, Building teh Dimensions, cubes/Tabular wif star schema using SQL Server Analysis Services (SSAS).
• Implemented all security levels in cubes/Tabular.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Worked in Creating partitions and Designing various storage modes to increase teh performance of a cube/Tabular using SSAS.
• Also worked on Performance tuning of existing cubes/Tabular.
• Designed and implemented SQL Server DATA WAREHOUSE based on business requirements.
• TEMPHas worked on designing of SQL-DB (especially star and snowflake) and optimizing teh databases
• Developed SSIS Packages for pulling teh data from source systems along wif transformations and making them into facts and dimensions (Data Warehouse) which are required for building cubes (SSAS).
• Implemented different deployment models in SQL server 2012.
• Developed complex SSRS and power pivot and power views.
• Has come up wif some innovative ideas to implement complex things (by reducing re-work).
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed power pivots, power views, power queries and hosted teh same in share point.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard. Played a Content Manager role on report server

Environment: MS SQL Server 2012/2008R2/2005, SQL Server Data Tools, Business Intelligence Development Studio, Visio, MS SQL Analysis Services 2012/2008R2, SQL server reporting services, MS Excel 2013/2010, Visual Studio 2013,Share point 2010, Power BI tools(Power Pivot, Power Query, Power Views)

Confidential

Sr.Developer SQLServer ASP.NET/SSRS/SSIS Developer

Responsibilities:

.

• User address validation using 3rd party WCF service i.e., cybersource
• Adobe omniture library usage for tracking User interest in Club Bing site.
• Work experience on .net 3.5 version.
• Automated SQL reports and Fraud functionality.
• Arvato Windows service management for prize distribution.
• Omiture data capture wif respect to site clicks.
• Integrated Excel files data into SQL server using SSIS packages.
• Code merging and TFS deployments till pre prod.
• Web analytics using Adobe omniture.
• Reports generation using SSRS
• Data integration using SSIS
• Used AJAX for client side validations

Environment: ASP.NET, WCF, Reporting Services (SSRS), Integration Services (SSIS), C#, XML, Visual Studio 2008/2010, SQL server 2008R2/2008,MS Word, MS Excel Visio.

Confidential

Sr. Developer POSTGRE/ ASP.NET

Responsibilities:

.

• Requirement gathering and documentation
• C# coding for TFG app utilization, used DUNDAS software DLLs to generate reports.
• Created login page based on teh authentication.
• Created web.config file while deploying teh project.
• Testing and Bug fixes using bugzilla.
• Packaging wif NSIS(Nullsoft Scriptable Install System) scripts.
• Implementation, Troubleshooting and Support Automated SQL reports and Fraud functionality.
• Integrated Excel data into SQL server using SSIS packages.

Environment: ASP.NET, DUNDAS software DLLs, Integration Services (SSIS), C#, XML, Visual Studio 2008, POSTGRE, MS Word, MS Excel Visio, NSIS scripts, JavaScript.

Confidential, New York

Sr. Developer SQLServer/Sybase/ .NET

Responsibilities:

• Winforms design, C# coding on data grid for CRUD operations and documentation.
• Testing and Bug fix using TFS.
• Used webservice to update or retrieve data from SQL server
• Support requests handling.
• Sybase database data integration wif MSSQL server 2005

Environment: VisualSudio 2005, C#, Integration Services (SSIS), C#, XML, Sybase, MS Word, MS Excel Visio, TFS.

Confidential

Developer SQLServer2000/ .NET/MSOffice

Responsibilities:

.

• Asp.NET pages design and coding in C#
• Primary interop assembly’s usage to generate MS Word reports
• Deploying web application in server.
• Testing wif halp of bugzilla
• Maintenance and Support
• Office automation using PIA assemblies using .net 1.1 framework

Environment: VisualSudio 2003, C#, XML, SQLServer 2000, MS Word, MS Excel.