SUMMARY

• Around 4+ years of IT experience as Confidential SQL Server developer implementing Power BI.
• Extensive knowledge in analyzing, designing and developing Client/Server, BI applications 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, and DB2 to MS SQL Server by using Import Export Wizard, DTS, and 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
• Experience on publishing Power BI reports on dashboards in Power BI server and Power BI Mobile App.
• 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 in Power BI, Power BI Pro, Power BI Mobile.
• 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.
• Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating sub query 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, and drill down, List, Ad-hoc, Parameterized, and Cascading.
• Extensive experience in creating SQL Server analysis projects using MS SQL Server.
• 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).

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

ETL Tools: Data Transformation Services (DTS) - Export/Import.

Reporting Tools: MS Access, MS Excel, Crystal Reports, Tableau Desktop, PowerBI

Database: MS SQL Server 2019/2016/2014/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, Cleveland OH

Power BI Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from the clients.
• 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 in Power BI.
• Recreated reports from MS Excel to Power BI.
• Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Confidential Power BI Desktop and visualizations
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Involved in dealing with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.
• 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 Power BI application.
• Used Confidential Power BI 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.) in Power BI according 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 unstructured data.
• 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 Azure data lake 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.
• 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, Power Pivot, Power View, Power Map, DAX, ETL, SSRA, Power Query, KPI, MS Azure, OLAP, OLTP, TFS, SQL Profiler, SQL, SQL Server, Oracle, MS Excel, Windows.

Confidential, charlotte, NC

Power BI/Azure 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 Power BI service and used gateways to refresh data when needed.
• Understand customer requirement and translate it into appropriate solution.
• Deployed the Power BI reports to Power BI services and pinned visuals to improve visualizations and presentations.
• Created dashboards in line with the analytical uniformity using the advanced analysis features of Power BI 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 using Power BI App and content packs.
• Utilized Power Query to pivot and UN pivot the tables for data cleansing and data manipulation.
• Understand and translate business needs into data models.
• Established DAX while creating data models in Power BI.
• 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 in Power BI to help end users visualize their reports effectively.
• Formulated complicated reports like parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report using Power BI.
• Optimize and update data models to support new and existing projects.
• Built Ad-Hoc reports in Power BI depending 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.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

Environment: SQL Server, Power BI, C#, Windows, VSTS, TFS, OLTP, OLAP, DSS, SQL Profiler, DAX, Power BI Apps, SQL, Power Query, ETL, Power BI reports, Power BI services.