PROFESSIONAL SUMMARY:

• Over 9+ years of extensive experience in business intelligence applications design, development and maintenance of SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI Reporting Server, and SQL Server Analytical Services (Multidimensional and Tabular Models).
• Experienced in developing Power BI reports and dashboards from various Data Sources like Cube, Databases, Excel files.
• Good Experience in database design, data modeling, development, implementation, ETL and reporting in SQL Server 2016/2014/2008 R2.
• Reporting Services (SSRS), Analysis Services (SSAS) & Power BI (Power View, Power Pivot)
• Practical understanding of data modeling (dimensional & amp; relational) concepts like star - schema modeling, snowflake schema modeling, and fact and dimension tables.
• Used Power BI to prepare dashboards to create attractive visualizations.
• Created reports in Power BI preview portal utilizing the SSAS Tabular using Power BI Gateway
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power View & Power BI.
• Experience monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal performance.
• Expertise configuring and creating SSIS solutions for ETL and business intelligence process for data integration and migration services.
• Skilled in merging data from various heterogeneous data sources, populating dimension and fact tables in data warehouses and data marts, cleaning and standardizing data loaded into OLTP and OLAP databases using SSIS.
• Extensive experience creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Created Dynamic time-based calculations like MTD, QTD, YTD, Prior, %YoY etc
• Expertise creating various parameterized, cascaded, linked, drill-through and drill-down reports.
• Expertise configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in Reporting Services, Power BI (Dash Board Reports), Power BI using MS SQL Server and in supporting services MDX technology of the analysis services.
• Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS)
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.
• Having experience in creating Data level security which is Role based security. Created Dynamic security in Tabular Model for two types of users based on requirement
• Good Experience in deploying SSRS reports to Report Server and Power BI Reports to Power BI Report Server
• Having Experience on moving/deploying Tabular, Multidimensional, SSIS packages from Dev to Stg and Stg to Prod Servers
• Automated Entire ETL process, Cube/Model Processing and Report Execution based on Time and Event based Scheduling

TECHNICAL SKILLS:

Integration Services: SQL Server Integration Services (SSIS)

Reporting Tools: SSRS, Crystal Reports, BO-Universe, WebIntelligence, Power BI, Excel

Languages: C, SQL, T-SQL, PL/SQL, UNIX and C#.Net

Operating Systems: Windows 2010/2008/Vista/XP, Windows 2010/2008 Server, UNIX

Databases: SQL Server 2016/2014/2008, Oracle 10g/9i/8i, MYSQL, MS Access

ETL Tools: MS SQL Server Integration Services (SSIS), Informatica Power Center

Scripting: HTML, Shell scripting

Database Tools: Enterprise Manager SQL Profiler, T-SQL, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON, Quest Lite speed, SQL Safe, Red gate, Tivoli, App Dynamics, Azure.

SAP: Business Objects Lumira, HANA

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Power BI/MSBI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS.
• Scheduled the job to do this task periodically.
• Loaded data from ODS to data warehouse using SSIS packages.
• Used Power BI to design interactive reports and data visualization using Power BI Desktop.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Strategic expertise in design of experiments, data collection, analysis and visualization.
• Used SSIS script tasks, look up transformations and data flow tasks using T-SQL, C# and VB scripts.
• Used multi-dimensional models such as star schemas and snow flake schema for developing cubes.
• Designed and developed matrix, tabular and parametric reports using SSRS 2016.
• Designed and developed drill down and drill through reports with drop down menu option using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
• Wrote new stored procedures for new system and optimized old store procedures and functions on production server.
• Improved data load performance by analyzing database design and query plans.
• Modified and created joins to improve the database and execution speed.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Expert in data visualization using Power BI to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2016.
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Created Time Calculations like MTD, QTD, YTD, YoY and %YoY based requirement
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Microsoft SQL Server SSRS, SSAS, SSIS 2016/ 2012/ 2008 R2, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau 8.3, Power BI 2013.Windows Server, Power Map, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2008, Reports Builder.

Confidential

Power BI/MBSI Developer

Responsibilities:

• Wrote complex SQL statements using joins, sub queries and correlated sub queries. Involved in creation of data modeling techniques.
• Analyzed complex queries and tune the same to optimize application and system performance to set up SQL Server configuration settings.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Worked with full life cycle development of reporting projects, includes requirements gathering/analysis, design, development, testing and production rollover.
• Helped troubleshoot, performance tune reports and resolve issues with sql server and reports.
• Migrated existing data into the Power BI and created reports preview portal utilizing the SSAS Tabular.
• Published Power BI desktop reports created in Report View to the Power BI service.
• Transformed and combined the data using Query Editor in Power BI.
• Worked with Power BI mobile app and created layouts to view reports and dashboards effectively.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2012.
• Worked as a DBA in creating and managing tables, indexes, and triggers.
• Worked with Exception handling with @@error and with Try/catch.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems.
• Deployed SSIS packages and Scheduled Jobs. Involved in Analyzing and integrating the data.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversions.
• Optimized long running stored procedures and queries for effective data retrieval.
• Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2012, T-SQL, Windows Server 2008, Power BI, SQL Profiler, SQL Server Reporting services, Visio

Confidential

MSBI Developer

Responsibilities:

• Installed and configured SQL Server 2012 and SQL Server 2008R2.
• Analyzed and evaluated requests for reports and develop, created and modified procedures to extract data extract tools.
• Participated in the data warehouse design and development team.
• Conducted data analysis, designed and developed standardized management computer reporting tools.
• Provided decision support through reporting and data analysis supporting Beacon’s internal and external data/information customers.
• Oversaw the operation and maintenance of the activities necessary to insure the timely production and dissemination of accurate reports and data and management information.
• Performed project-based analysis and the reporting data projects and executive ad hoc report requests.
• Created mapping documents and technical analysis on paper claims and Medicaid claims.
• Conducted ongoing requirement analysis for data needs for Business Users.
• Created data/reports specifications for IT technical for development using SSRS Reports.
• Ensured that the reports are created and generated accurately in a timely manner for review, analysis and subsequent submission to the customers.
• Conducted project-based data analysis and ad hoc reporting.
• Involved in gathering the requirements from different health plans to create the reports.

Environment: MS SQL Server 2012/2008 R2 SSIS, SSRS, SSAS, Power BI, Visual Studio 2008, T- SQL, Crystal Reports, Performance point server 2010, Share point server 2010, Windows 2008 Server, Team Foundation Server, XMLA, MS Access, MS Excel, Cognos reports, BusinessObjects

Confidential

SQL Server DBA/MSBI Dev

Responsibilities:

• Developed backup restore scripts for MS SQL Server as needed.
• Upgraded to latest version from MS SQL server 2000 to 2005.
• Responsible for Disaster recovery and database maintenance plan.
• Designed and implemented data access stored procedures and automating tasks.
• Performed Job scheduling and alerts.
• Optimized queries and performances using varies MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
• I have created packages to extract data from Source to Destination using various tasks and transformations
• I have involved in Creating packages to implement Business Logic
• I have involved in Cleansing the data using SSIS Packages
• I have involved in Creating Packages to Extract data from Source to Staging database and from Staging database to Data Warehouse
• I have involved in Unit Testing as per test cases

Environment: SQL Server 2000/2005 Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSRS.