SUMMARY

• Over 5+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2/2005 in Development, Test and Production Environments wif various business domains.
• Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load wif SSIS, SSAS, SSRS and POWERBI
• Hands on experience in dealing wif Relational Database Management Systems, includingStored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Developed PL/SQLTriggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored Procedures, Functions and Packages for moving teh data from staging area to data.
• Good knowledge on Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL).
• Created data base on Microsoft Azure, setting up connection strings and connecting SQL server AZURE databases from locally installed SQL Server Management Studio(SSMS) for developers
• Experienced in redesigining and successfully migrating applications to new platforms.
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server by Play Now Radio">Analysis Services (SSAS) and Reporting solutions using Microsoft by Play Now Radio">SQL Server Reporting Services (SSRS).
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill throughand drill down operations in Powerbi.
• Hands-on experience in development of strategic and complex reports using most of teh features and tools included wifin teh report builder (list, matrix, graphs, sub-reports, tablix).
• Created and scheduled subscriptions for teh reports using SSRS 2008/2012.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player wif an ability to take new roles.
• Conversant wif all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.

TECHNICAL SKILLS

OLAP/Reporting Tools: (SSRS), MDX, Power BI, Tableau

Relational Databases: SQL Server 2016/2014/2012/2008 R2, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Other Tools: Microsoft Office 2003/2007/2010 and 2013, Power pivot.

SQL Server Tools: SQL server Management Studio, Microsoft Visual Studio 2010/2013/2015

Programming languages: C, SQL, PL/SQL, T-SQL, Python

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

POWERBI Developer

Responsibilities:

• Created different visualizations using slicers, lines, pies, histograms, maps, scatters, bullets, heats maps, tree maps, etc.
• Integrated custom visuals based on business requirements using PowerBi Desktop.
• Developed complex calculated measures using Data analysis Expression language (DAX).
• Creating different types of user-defined functions using T-SQL.
• Developed parameterized reports, drill down, Drill through reports, sub reports as per report specifications and functionality.
• Development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering teh desired KPI’s using powerbi.
• Worked wif Metadata-Driven Packages to pull teh data from different sources and loaded them to teh Data Mart.
• Developing Powerbi Reports, ad-hoc reports usingReport Designer.
• Involved in building database Model, APIs and Views utilizing Python, in order to build an interactive web-based solution
• Generating several types of drill down and drill through reports using powerbi Desktop.
• Developing complexreports using multiple data providers, global variables, expressions, user-defined objects, aggregate-aware objects, charts, and synchronized queries.
• Developed consumer-based features and applications using Python and Django in Test Driven Development.
• Designing and implementing parameterized and cascading-parameterized reports using Powerbi.
• Developing, publishing customized interactive reports and dashboards, report scheduling usingPowerbi.
• Hands on experience in building queries to retrieve data into Tableaufrom SQL Server and Oracle server.
• DesignedTableaudashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.
• Generated interactive web sharing dashboards wif simple drag and drop options.
• Worked extensively on trend lines, statistics, dual axis, groups and sets to develop detailed level of summary reports.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Excel, Windows XP, Tableau, SQL Server Reporting Services(SSRS).

Confidential, New York

MSBI DEVELOPER

Responsibilities:

• Actively involved in teh user requirement gathering process.
• Documented teh technical specifications and generated teh reports for teh implementation and testing of teh application.
• Created database objects such as tables, views, indexes, stored procedures, and functions per requirement.
• Collaborated wif multiple teams under agile methodology for implementing application needs.
• Established joins and created indexes whenever necessary, based on requirements.
• Implemented SSIS packages to import data from MS Access, Oracle10g, text files and Excel files.
• Created multiple complex queries for data profiling and auditing purposes utilized in teh ETL process.
• Performed a multitude of ETL, data operations to support data loads and transformations wif SSIS.
• Improved teh performance of SSIS packages wif non-blocking transformations and row transformations.
• Implemented event handlers, loggings, breakpoints, and data viewers to debug packages.
• Implemented OLAP process for changing and maintaining teh warehouse, optimizing dimensions, hierarchies and adding teh aggregations to teh cube wif SSAS.
• Created named calculation in teh data source view and calculated members in cube based on OLAP reporting needs utilizing SSAS.
• Generated context filters and data source filters while handling huge volume of data in Tableau.
• Built dashboards for measures wif forecast, trend line and reference lines in Tableau.
• Generated reports utilizing relational databases and OLAP cubes.
• Optimized SSRS reports wif snapshots, caches, execution log views, embedded queries, and stored procedures.
• Scheduled report deliveries to multiple users utilizing subscriptions (standard/data driven).
• Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.

Environment: SQL Server 2012, SSIS, SSAS, SSRS, T-SQL, Oracle 11g, 10g, Tableau.

Confidential

MSBI DEVELOPER

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per teh functional/technical design and conforming to teh data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to teh power users.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.
• Developed parameterized reports, drill down, drill through reports, sub reports as per teh report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of teh actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of teh existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per teh specifications using SQL Server Data Tools. Participated in teh design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering teh desired KPI’s in teh Cubes.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio,Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2, Power BI Desktop, Power BI Service.