SUMMARY

• Over 7 years of IT experience in the field of Business/Data analysis, Business Intelligence and Database Developer in Retail, Finance, Telecommunications, and Telemarketing domains with expertise in MS SQL Server 2005 and MS SQL Server 2008/2008R2/2012/2014 suite of products like SSIS, SSAS, and SSRS.
• Proficient in SSAS and dimensional cubed data modelling techniques, including DAX, MDX (Ideally Tabular and DAX scripting).
• Experience in utilizing complex joins such as right, left, full outer, self, and cross joins to create effective views that can later be used for reporting.
• Proficient in implementing business logic and procedure in backend using T - SQL, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Experience in Query Performance Tuning using tools such as SQL Profiler, Estimated Execution Plan, and Actual Execution Plan.
• Hands on experience in troubleshooting performance related database issues.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel PowerPivot table based on OLAP cubes.
• Worked in OLTP and OLAP environment including Production, and development databases in SQL Server 2012/2008.
• Developed and deployed OLAP Cubes, Fact Tables, and Dimension Tables. Expertise in increasing security and performance of OLAP Cubes by developing perspectives and partitions.
• Experience in Dimensional Modeling, Star and Snowflake Schemas, Fact and Dimensional Tables.
• Experience in developing Custom Report and different types ofChart Reports, Drill-Down reports, Cross-tab-reports, Matrix Reports, Ad hoc reportsanddistributed reportsin multiple formats using SQL Server Reporting Services(SSRS) 2012/2008.
• Experience in utilizing MS SharePoint to distribute reports and to create attractive reports, dashboards, and scorecards using KPIs and Power BI Suite.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R2/2008/2005
• MS SQL Server Integration Services (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Services (SSRS)
• JSON
• Oracle DB
• DB2
• MS Office Suite 2007/2010/2013
• MS Visio 2010/2013
• Visual Studio 2010/2012
• MS Power BI
• Power Pivot
• Power Maps
• MS SharePoint 2007/2010/2013
• Tableau
• SharePoint
• Google Drive
• Drop Box
• Skype
• Windows Vista/XP/NT/
• Windows 7/8/10
• SAP
• QuickBooks
• ERP Systems
• Adobe Acrobat.

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL BI Data Analyst

Responsibilities:

• Experience in designing, developing, supporting new SSAS Tabular Models which uses xVelocity (formerly Veritpaq) in-memory engine.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements. Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Create Power View Reports using the Tabular SSAS models in Excel 2013 and 2012.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in designing, developing complex SQL queries to support reporting requirements
• Design, develop and test processes, which include the creation of SQL views, scripts, T-SQL, stored procedures.
• Create complex Stored Procedures using dynamic SQL statements, Triggers, Tables, Views, and other SQL Joins such as left joins, right joins, inner joins, cross joins by using T-SQL.
• Create table in Power Pivot by importing data from SQL server and organize the table by filtering the fields
• Experience in creating jobs, set up and monitor jobs in SQL Server Job Monitor.
• Create, stop and run queries for extended events for Analysis Services and refresh Power Pivot table to retrieve daily data for Data warehouse
• Monitor extended events, system details within the data warehouse including stored procedure and execution time in SQL Server.
• Experience in populating table in Excel and writing code in VBA Macro

Environment: Office 365, BI Tools 2014, MS SQL Server 2012/214, SQL Management Studio 2014, Visual Studio 2013, SQL Server Analysis Services (SSAS), SharePoint, Power Pivot, SQL Server Profiler, MS Excel 2013 and VBA Macro.

Confidential, Philadelphia, PA

MS SQL BI Developer (SSRS, SSAS, SSIS)

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents and also created new design documents
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer to DW.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, flat file, Text Format Data.
• Involved in creating a Data Mart of two schemas relating to Customer Service and Products to analyze the various factors that were involved in ensuring customer satisfaction.
• Created Dimension and Fact Tables and Schemas for the Data Mart using SQL Server Management Studio.
• Utilized SQL Server Profiler and Database Design Engine Tuning to analyze traces files to improve data warehouse performance.
• Experience in development and deployment of cubes that were generated to analyze KPIs by utilizing SQL Server Analysis Services (SSAS).
• Created Snapshot, Cached, Linked, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Created calculated measures and dimension members using multidimensional expression (MDX), and user-defined functions.
• Worked ontuning the long-running SQL Stored Procedures, when needed
• CreatedDatabases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Functions, Triggers.
• Collected performance data from previous financial quarters to determine the patterns/trends in company's operations and performances.
• Implemented self-service business intelligence using Microsoft Power BI.

Environment: MS SQL Server 2012, SQL Management Studio 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SharePoint, Power Pivot, SQL Server Profiler, MS Excel.

Confidential, Omaha, NE

MS SSIS/SSAS - BI Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008/2012 using T-SQL, stored procedures and views to get data from Data warehouse to Data marts.
• Involved in the analysis of the Production data mart that utilized the SQL Server 2008 Platform using SQL Server Analysis Services (SSAS) 2008.
• Developed and deployed a cube which included Timberline Total Solution’s exclusive brand’s dimension and fact data and developed perspectives for users in sales and for users to analyze revenue.
• Worked with SSIS to extract data from different source systems and used transformations like Slowly Changing Dimensions, Data Conversions, Derived Columns, Merge, and Union to cleanse and scrub the data.
• Created Entity Relationship (ER) Diagrams to the proposed database and database objects such as tables,views, stored procedures, functions and triggers as per the requirements.
• Identified columns for Primary Keys in all the tables at the design time and create them.
• Involved in creating cubes in SQL Server Analysis Services using SQL Server 2012 version.
• Analyzed, developed and created cashed reports, snapshot reports based on financial statements.
• Developed and maintained SSIS Extracts Transforms and Load (ETL) processes across multiple data sources.
• Created several dashboard reports withdrill-down, drill-through, cross Tab Reports and sub-report using Report Definition Language(RDL)
• Worked with a reporting team on building charts, graphs and tables.
• Designed, developed and implemented data management and data analytics solutions.
• Performed Conceptual, Logical, Physical, Multidimensional, & Hierarchical data modeling.
• Identified data discrepancies and data quality issues and work to ensure data consistency and integrity.
• Monitored system details within the data warehouse including stored procedure and execution time and implemented efficiency improvements.

Environment: Microsoft SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS SharePoint.

Confidential, Omaha, NE

MS BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Experienced in creating numbers of complex formulas in sub reports using different type of variables likes shared variable and retrieved them from master report.
• Experienced in Data warehouse design and implementation
• Experienced in designing, developing complex SQL queries to support reporting requirements
• Presented data in multiple formats including reports, charts, graphs, aggregates and statistical computations.
• Involved in writing Custom Functions to be used in other Functions.
• Understood an existing system and designed modifications to the system to support new requirements.
• Successfully createdFact Tables, Dimensionsand joined them to extract meaningful data.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, T-SQL, stored procedures, functions, triggers and SSIS packages.
• Experienced in tuningSQLstatements using indexes, SQL stored Procedures and views.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimizeSQLQueries.
• Configured, patched, tested, and supported all MS SQL Server database instances.

Environment: MS SQL Server 2008-R2, SQL Server Integration Services SSIS, Crystal Reports 8.5, MS Excel, SharePoint, T-SQL.

Confidential, Omaha, NE

MS SQL SSIS - BI Developer

Responsibilities:

• Involved in Creation, Manipulation and Supporting the SQL Server Database.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler.
• Extensively involved in designing SSIS packages to make the automated synchronization of data from one system to another system.
• Created and tested SSIS packages for importing and exporting data from data warehouse.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Monitor and tuned indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2008-R2.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc. from event viewer,SQL Error log files.
• Configured Mail Profile for sending automatic mails to the respective people when a job failed or succeeded.
• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Created queries with Inner Join, Outer Join, Co-Related sub-query with String function, Mathematical function, Aggregate function.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.

Environment: MS SQL Server 2008-R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint, SQL Server Profiler, MS Excel.