PROFESSIONAL SUMMARY:

• 7+ years of experience in Data Analysis, Design, Implementation, Administration and support of Business Intelligence using SQL Server 2012/2008R2/2008/2005, SSIS, SSAS and SSRS.
• Published reports to Azure based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Expert in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert in different components of SSIS (Control Flow, Data Flow and Connection Manager) while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks.
• Proficient in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Expert on the optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Proficient in Data Warehousing methodologies and concepts, including Star schemas, Snowflake schemas, ETL processes, Dimensional modeling and reporting tools.

PROFESSIONAL EXPERIENCE:

MS SQL SERVER/MS BI Developer

Confidential, Englewood Cliffs, NJ

• Worked as a Team Lead while performing requirements gathering, analyzing and designing of the system.
• Load data from various sources like OLEDB, Flat files to SQL Server database using SSIS packages and created data mapping to load the data from source to destination.
• Proficient in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Successfully migrated data between different heterogeneous sources such as flat files, Excel and SQL Server 2008 using SSIS.
• Involved in creating multiple parameterized stored procedures which were used to generate reports, with Cascaded Parameters, Gauges and Interactive Charts in SSRS.
• Published Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Proficient in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS).
• Designed, implemented, and monitored EDI processes to interchange invoicing and purchasing data with suppliers using industry standards.
• Building KPI reports for the cubes and optimizing the reports.

MS SQL SERVER /T-SQL/MSBI (SSIS/SSRS) ETL Developer

Confidential, New York, NY

• Proficient in Normalization of the databases and bringing them to 3NF.
• Designed SSIS Packages to migrate slowly changing dimensions.
• Developed database maintenance plans for deleting of history data using SSIS packages.
• Proficient in logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Developed queries for generating drill down reports in SSRS 2008 and prepared AD-HOC reports through report builders.
• Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
• Worked on calculating measures, mathematical formulas and user-defined functions (DAX) in Power BI reports.
• Deployed Dashboards, Reports and Data sources using the Power BI Service.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2007, MS Excel, Power BI Desktop, Power BI Services.

MS SQL SERVER/MSBI DEVELOPER

Confidential

• Worked as a Lead in the development of the back-end systems.
• Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
• Designed complex queries and stored procedures for high performance reporting and rendered them to HTML, PDF and EXCEL formats using reporting services.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different data transformations (DTS) using SSIS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Proficient in processing the cubes (SSAS), partitions as and when required.
• Designed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.

Environment: SQL Server 2008 R2, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008, MS Office 2007/2003, MS VSS, XML

Confidential

MS SQL Server/MSBI Developer

• Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).
• Weekly presentation to the business users about the reports and their changes as required.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support SSRS reports.
• Proficient in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Developed aggregations and pre-calculations in SSAS.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: SQL Server 2008 R2, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008, MS Office 2007/2003, MS VSS, XML.