SUMMARY

• Around 7 years of IT experience as Microsoft SQL Server developer implementing SSIS, SSRS and SSAS, and PowerBI.
• Extensive knowledge in analyzing, designing and developing Client/Server,BIapplications and various segments of software development life cycle (SDLC) involving business process analysis, requirement gathering and development.
• Experience on publishing Power BI Desktop reports on dashboards in Power BI server and in designing, developing Power BI graphical and visualization solutions based on business.
• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.
• Expert in Data Modeling and Multi - Dimensional Modeling.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
• Experience in SFDC Integration using Web Service and Salesforce.com
• Extensive experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience on publishingPowerBIreports on dashboards inPowerBIserver andPowerBIMobile App.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Exploring App exchange applications and integrating them with Sales force.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/ T-SQL /MS excel.
• Experience inPowerBI,PowerBIPro,PowerBIMobile.
• Maintained securities, roles, subscriptions in report manager in SSRS.
• Sound knowledge of Data Marts, Operational Data Store (ODS), OLAP, dimensional Data Modeling with Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Expertise in creating OLAP Cubes and Dimensions in SSAS.
• Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs.
• Strong experience in designing ETL data flows, developing workflows to extract data from various data sources (Excel, XML, Flat file, SQL Server etc.), Synchronous and Asynchronous transformations using SSIS.
• Expert in Debugging, Logging, Error handling and Event handling for SSIS Packages.
• Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
• Strong experience in creating tables, writing complex SQL Queries using functions, stored procedures, cursors, Indexes, joins, triggers, views in T-SQL for optimum performance.
• Experience with creating reports by connecting different data sources to Power BI and using geographical visualizations as per the insights provided.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI.
• Heavily used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Highly experienced in Designing, Developing and Deploying various reports like Tabular, Matrix, Chart, drill down, List, Ad-hoc, Parameterized, Cascading and other reports using SSRS.
• Experienced in migrating reports from Crystal Enterprise to SSRS.
• Extensive experience in creating SQL Server analysis projects using MS SQL Server.
• Experienced in creating complex SSIS and DTS packages for ETL purposes.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
• Thorough knowledge in data warehouse concepts, Relational Database Management Systems (RDBMS), Normalization, Data Modeling and Documentation.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, RDB models, data dictionaries, and data integrity, SQL joins and query writing.
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
• Excellent communication, analytical and interpersonal skills, self-motivated, quick learner and an active team player and team leader. Very flexible and ready to take new challenges.
• Have worked and successfully delivered many projects at onsite coordinating with stakeholders and developers, during various phases of delivery.

TECHNICAL SKILLS

Methodologies: SDLC Waterfall, Scrum, Agile

BI Tools: Power BI (Power Query, Power Pivot, Power View), MS BI (SSAS, SSIS, SSRS)

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio (2012/2014/2016/2017 ), Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS (2014/ 2012/2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Tableau Desktop, PowerBI

Database: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle 11g/10g/9i

Programming: T-SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET, VB.Net

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSS

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows 7,Windows 8,Windows 10

Other Tools: MS Office Suite (MS Word, Power Point, MS Visio), ERWIN, Toad, Accurev, GITHUB

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring - MD

Power BI Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from the client.
• Involved in KT sessions and different Controllers meeting to understand the Business.
• Publishing Power BI reports on dashboards in Power BI server.
• Modified existing dashboards as per new requirements inPowerBI.
• Recreated reports from MS Excel toPowerBI.
• Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Microsoft PowerBI Desktop and visualizations
• Used PowerBI,PowerPivot to develop data analysis prototype, and used PowerView andPowerMap to visualize reports.
• Involved in dealing with the backend data retrieval team, data mart team to guide the proper structuring of data forPowerBIreporting.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in thePowerBI.
• Performed tasks like execute SQL task, data flow task, file system task for ETL process.
• Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view in PowerBI application.
• Used Microsoft PowerBI Power Query to extract data from external sources and modify data to certain format as required in Excel
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) inPowerBIaccording to the requirements.
• Generated Monthly, Yearly, Quarterly and daily reports in Power BI.
• Worked and joining the queries and merging the tables in Power BI.
• Load and transform large sets of structured, semi structured and unstructureddata.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Created KPI, Guage, Clustered column chart, Slicers for better understanding of the report
• Developed reports like Ad-hoc report, charts, tabular, matrixes, and sub report.
• Created and maintained tables, stored procedures, indexes, database check constraints, and business rules using SQL.
• Assisted in implementing Azure Data Factory v2 for a major financial institution by ingesting their risks and control data into Azuredatalake store.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Handling Azure Storage like Blob Storage and File Storage.
• Worked on Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
• Developed U-SQL Scripts for schematizing the data in Azure Data Lake Analytics
• Ability to create scripts using Azure PowerShell during for automation and build process.
• Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using SQL Profiler.

Environment: Power BI, Power BI Server, Power BI Desktop, PowerPivot, PowerView, PowerMap, DAX, ETL, SSIS, SSAS, SSRA, Power Query, KPI, MS Azure, OLAP, OLTP, TFS, SQL Profiler, SQL, SQL Server, Oracle, MS Excel, Windows.

Confidential, West Bend - WI

Power BI developer

Responsibilities:

• Analysis of Project Requirements and functional specifications of the project.
• Gained experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation.
• Published reports using PowerBI service and used gateways to refresh data when needed.
• Understand customer requirement and translate it into appropriate solution.
• Deployed the PowerBI reports to PowerBI services and pinned visuals to improve visualizations and presentations.
• Created dashboards in line with the analytical uniformity using the advanced analysis features of PowerBI Desktop.
• Creation and delivery of detailed technical presentations.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Shared dashboards and reports with user groups by usingPowerBIApp and content packs.
• Involved in design and development of SSIS (ETL) packages.
• Utilized PowerQuery to pivot and un pivot the tables for data cleansing and data manipulation.
• Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
• Understand and translate business needs into data models.
• Established DAX while creating data models inPowerBI.
• Converted SQL Query code into DAX code for reports.
• Utilized Slicers and Filters in Power BI to accurately sort visuals and make sure the end user has the relevant information available
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile app
• Also created and managed Power BI Apps for sharing the Power BI reports to the end users and stake holders through different AD Groups.
• Created conceptual, logical and physical data models using best practices.
• Created Custom Visuals inPowerBIto help end users visualize their reports effectively.
• Formulated complicated reports like parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report usingPowerBI.
• Optimize and update data models to support new and existing projects.
• Built Ad-Hoc reports inPowerBIdepending on business requirements was one of the major responsibilities.
• Create Source to Target Mapping as necessary
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS.
• Designed and Developed SSAS Cubes
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Designed and developed SSRS Reports

Environment: SQL Server, SSRS, SSIS, SSAS, Power BI, C#, Windows, VSTS, TFS, OLTP, OLAP, DSS, SQL Profiler, DAX, Power BI Apps, SQL, Power Query, ETL, PowerBIreports,PowerBIservices.

Confidential, Jefferson City - MO

Power BI Consultant

Responsibilities:

• Gathered, analyzed and defined business rules used and produced requirement documents to define the scope of the various analytical reports
• Collaborated with senior management, subject matter experts, and IT teams to define business requirements
• Created SSIS packages to extract data from different sources from legacy systems for individual data set requirements
• Designed and developed views for aggregating and drilling across the fact tables
• Generating and applying surrogate keys in the Power BI Query Editor
• Creating calculated measures, renaming queries and fields, created several DAX calculations to create measure like YTD, QTD, MTD calculations
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server.
• Used different kind of visualizations inPowerBIlike Line Chart, Clustered bar chat, Pie chart, Matrix table, Gauges, Scatter chart, Map, Card, Slicers Etc.
• Always ensured to eliminate NULL and Blank values on the Dashboards/Reports for the best end user experience created Power BI App Workspaces for collaborating and sharing the development across developers.
• Conducted complicated calculation to develop KPI reports/dashboards according to clients' requirement
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Scheduled the Dashboard’s at regular intervals to make sure data refresh is up to date.
• Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server.
• Utilized Buttons inPowerBIto make changes to reports and configure them for when they are selected.
• Generate performance indicators to locate opportunities of Growth across the BU.
• Involved in generating and maintaining SQL scripts.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Exceptionally deliver stunning interactive reports in your app with the Power BI Embedded service
• Performance tuning of reports and dashboard’s using power analyzer from Interworks and there by taking extra steps to remove the unnecessary column, calculations and getting only required data for analysis
• Perform unit testing on all datasets and dashboards to ensure proper implementation.

Environment: Microsoft SQL Server, Power BI, DAX, YTD, QTD, MTD, SSIS, Net Suite, OLTP, Oracle, MS Access, MS Excel, Flat files, CSV, Salesforce, Power BI App, ETL, SQL, Visualizations.

Confidential

SQL BI Developer

Responsibilities:

• Worked with project teams and business analysts to outline project requirements in JRD meetings.
• Created logical and physical design phases of the database utilizing Erwin as data modeler tool.
• Participated in all the phases of Software Development Life Cycle (SDLC) methodologies Throughout the project life cycle.
• Created staging procedures to load and migrate data for report databases with multiple features.
• Wrote SQL queries and stored procedures to generate data for reports from various sources.
• Designed and deployed SSAS multidimensional cubes used in analytic research and report generation.
• Utilized Power BI to create various analytical dashboards that depict critical KPIs along with slicers and dicers enabling end-user to make filters.
• Integrated custom visuals based on business requirements in Power BI Desktop.
• Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Installed and managed gateways to do automatic data refresh of Power BI datasets.
• Deployed Power BI gateway to keep dashboards and reports up-to-date with on premise Data Source’s.
• Created various reports such as drilldown, drill through, parameterized, cascading parameterized chart, and freeform reports with reporting services (SSRS).
• Developed, designed and deployed reports throughSSRSandExcel, per business requirements.
• Administered project related documents and scripts in Team Foundation Server (TFS).

Environment: SQL Server 2016, Erwin, T-SQL, SSAS, SSRS, SSMS, SSDT, Power BI, TFS.