SUMMARY

• Overall 7+ years of IT experience as Microsoft SQL Server developer implementing SSIS, SSRS and SSAS, PowerBI & Tableau.
• 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.
• 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.
• Experience inPowerBI,PowerBIPro,PowerBIMobile
• Hands on experience in Tableau Desktop, Tableau Server, Tableau Public and Tableau Reader in various versions of Tableau.
• Published Tableau workbooks on Tableau Server with view permissions, scheduling and authentication features for refreshing the extracts on a schedule.
• 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.
• 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.
• 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.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Experience including analysis, modeling, design, and development of Tableau reports
• 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.
• Thorough knowledge in data warehouse concepts, Relational Database Management Systems (RDBMS), Normalization, Data Modeling and Documentation.
• 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 Confidential 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), Tableau

Database Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio(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), MS Access, MS Excel, Crystal Reports, Tableau Desktop, PowerBI

Database: MS SQL Server 2012/2008, 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, Atlanta GA

Power BI Senior Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from the clients.
• Involved in KT sessions and different Controllers meeting to understand the Business.
• PublishingPowerBIreports on dashboards inPowerBIserver.
• 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 MicrosoftPowerBIDesktop and visualizations
• UsedPowerBI,PowerPivot to develop data analysis prototype, and usedPowerView 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 inPowerBIapplication.
• Used MicrosoftPowerBIPowerQuery 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 implementingAzureDataFactory v2 for a major financial institution by ingesting their risks and controldataintoAzuredatalake 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
• HandlingAzureStorage 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 inAzureData Lake Analytics
• Ability to create scripts usingAzurePowerShell 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, Atlanta, GA

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.
• Involved in planning, defining and designing data based on business requirements and provide documentation.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Developed SSIS packages using for each loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute SQL task to insert transaction log data into the SQL table.
• Ensure data quality in all Tableau reports by examining data sets and reducing aggregation errors.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Involved in Onsite & Offshore coordination to ensure the completeness of deliverables.
• Developed, organized, managed and maintained graphs, tables and document templates for the efficient creation of reports.
• Transformed the logic developed by Spotfire, OBIEE, WEBI reports into Tableau with enhanced data visualization.
• Worked on developing Tables, Indexes, Views, complex stored procedures, Triggers, Functions.
• Combined visualizations into Interactive Dashboards and publish them to the web by created groups and users in Tableau Server.
• Creating New Schedules and checking the daily tasks on the server.
• Created symbol maps to understand the geo-spatial distribution of projects with custom symbols to represent the application category.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Participated in the user requirement gathering and design meetings. Translated business needs into reporting and analytic requirements.
• Creation and delivery of detailed technical presentations.
• Optimize and update data models to support new and existing projects.

Environment: Tableau Desktop 9.0/9.2/10.0/10.2 , Tableau Server 9.0/9.2, IBM Cognos, SQL Server 2008/2013, Teradata, MS Excel, MS Access, SAP BO, SSIS

Confidential, Altanta, GA

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
• Developed tabular model infrastructure in SSAS for various lines of business and created over different interactive dashboards using various visualizations in Power BI Desktop.
• Created multiple dimensions, perspectives, hierarchies, and dynamic measures (DAX) to analyze performances of each KPI.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Used MDX to create custom groupings, parameters, named sets, main reports and sub-reports (including reports with line and pie charts).
• Created interactive reports using custom visuals and PowerApps.
• Expert in developing Power BI Reports and dashboards from multiple data sources using data blending and composite models.
• Applied transform rules data conversion, data cleansing, data aggregation, data merging and data split.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Created data visualizations using various visual objects (line chart, bar chart, tree map, single card, KPI, map, pie chart, custom visuals)

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, Auburn Hills, MI

SQL Developer

Responsibilities:

• Configured SQL Server Environment.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Designed Entity-Relationship diagrams and thus the database schema
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Developed stored procedures, triggers, row level audit tables in SQL Server.
• Developed cursors and views to improve performance in data transactions.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.

Environment: MS SQL Server 2000/05, MS SQL Enterprise Manager, SSIS, DTS, T-SQL, and Windows NT