SUMMARY

• 9 years of experience in Design, Development, Data Analysis, Business Intelligence, and implementation of projects with full SDLC (Software Development Life Cycle).
• Experience in writing T - SQL queries, Stored Procedures, User Defined Functions, Database Triggers.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established. Import data from different data source to create Power BI reports and dashboards.
• Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering and deploying reports to Power BI Service.
• Extract data from access, excel, flat file, and different data base and load in SQL data base using SSIS packages. Expert in Troubleshooting and correcting data for obtaining data integrity.
• Strong Experience in creating, configuring, deploying, and testing SSIS packages.
• Expertise in debugging, error logging, error handling and production support for SSIS.
• Expert in developing and testing reports using SSRS.
• Worked with business stakeholders to document report requirement.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Used Power BI and Power View to visualize and easily manage the data and optimized power queries.
• Excellent in creating SSIS Package for integrating data using OLE DB connection from heterogeneous sources.
• Extensive knowledge of Designing, developing reports using SSRS using relational and multidimensional data. ETL experience using BPM Diagram.
• Modeled a BPM diagram to represent a new data request from source system and orchestrated the process of data fetching from source to staging database.
• Excellent communication, interpersonal and analytical skills.
• Involved in BRM (Business Requirement Meeting) sessions with the Client in the finalization of the Business Requirements.
• Experience in identifying entities required and the relation between the entities to create Logical and Physical Model for the Application.
• Created and maintained Logical Data Model (LDM) and Physical Model for the project which includes documentation of all dimension entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Efficient in design test strategies for performance testing and volume testing of PL/SQL solutions.
• Assist project managers with the development of project schedules. Develop requirements and preliminary design for client applications.
• Perform analysis and design projects using a systems development methodology. Experience in creating PL/SQL procedures using Global Temporary Tables and Dynamic SQL that will be used by the UI.
• Working directly with stakeholders for requirements gathering and developing various decision-making Dashboards. Performed ETL using SSIS (Loaded Excel data into SQL server)
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created new reports for the operations user using PL/SQL, Global Temporary Tables and PL/SQL collections. Good understanding of Azure Portal, Setup and Maintain Azure VM.

TECHNICAL SKILLS

Operating systems: Windows XP/ 2007/2008/2010, Linux/UNIX

Programming Language: SQL, PL/SQL, T-SQL, HTML, XML

Tools: /Software: Oracle, ETL, TFS, GIT, SharePoint, Agile, Dashboards, Power BI, SQL Query Analyzer.

Databases: MS Access, MS SQL Server 2008/2012/2014, Oracle9i/11i, SDLC, TFS, GIT, Python, Business Intelligence Development Studio

Application Packages: MS Office, SSIS, SSRS, SSAS, Data Integration

Reporting tools: SQL Server Reporting services 2005/2008, Crystal reports, Power BI, SharePoint

PROFESSIONAL EXPERIENCE

Confidential - Oakland, CA

Sr. SQL BI Developer with Power BI

Responsibilities:

• Responsible for understanding user requirements, designing, and developing the application.
• Analyze and evaluate requests for reports and develop, create, and modify procedures to extract data from various data sources and the corporate data warehouse using report writers and data extract tools.
• Developed Stored procedures, Views and, Pl-SQL scripts for database maintenance, deployment and installation using MS SQL and created global temp tables (GTT) using Oracle.
• Participated in writing Stored Procedures for performing optimization and other database operations such as complex SQL queries, views, and triggers etc.
• Knowledge of publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Create and manage Power BI dashboards.
• Generating ad-hoc reports using Power BI for Weekly service report, Dashboard where client can see daily status.
• Worked on writing complex SQL queries, Sub queries, and nested queries in the process of analyzing the data to solve specific business problems.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.Developed Data Modeling in Power BI Desktop using Star schema, Snowflake Schema, and multiple fact table's scenarios.
• Worked on all types of transformations that are available in Power BI query editor.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Environment: MS SQL Server 2012/2014/2016, Oracle, SSIS, SSRS, SSAS, T- SQL, SAP, B/W, Tableau, Power BI, Crystal Reports, Share point server 2010, Windows 2008 Server, Team Foundation Server, XML, MS-Access, MS-Excel, ASP.NET, MVC, LINQ, Entity Framework, HTML 5, CSS.

Confidential - NYC, NY

Sr. SQL BI Developer with Power BI

Responsibilities:

• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns, and measures.
• Coordinating with business users in analyzing business requirements and translating them to technical specifications.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Worked on Read source data from Azure SQL DB, CSV, SQL Server 2016. through Power BI.
• Worked on Power Data Flows Using CDM in Azure Data Lake.
• Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities.
• Generated context filters and data source filters while handling a large volume of data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text, and date functions in source data. Have used Z-order to overlap the reports on each other using Power BI.
• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients. Hands-on expertise in SQL reporting, development, analytics, or BI.
• Relevant experience in processing flowcharts or data flow diagrams.
• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL Azure, etc.
• Created many complex Query's and used them in Power BI Reports directly to generate reports on the fly.
• Incorporated complex business logic by writing complex SQL procedures and functions.
• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, Bullets using Power BI.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Adheres to department, organization and industry guidelines, standards, policies, and procedures.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in BI according to the requirements.
• Used One Drive for storing different versions of the Power BI report.
• Excellent problem-solving approach, analytics skills, T-SQL coding commands.
• Responsible for complete maintenance and delivery of scheduled releases.
• Good knowledge of data warehouse and ETL (Extraction, Transformation, and Loading) concepts
• Amazing communication skills and problem identification ability.

Environment: Power BI Reports, DAX, T-SQL, Power BI Gateway, Power Pivot, MS SQL Server 2008R2/2012/2014, T-SQL, SSRS, Tableau, SSIS, SQL Server Analysis Services, SSIS, Visual studio 2012.

Confidential - Irving, TX

SQL Developer / Power BI Developer

Responsibilities:

• Developed Power BI model used for financial reporting of P & L and Headcount.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, CDS, Oracle, SQL Azure etc.
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Executed dashboard setups and data manipulation using DAX.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, Power Shell
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Used to connect to CDS environment with the help of connectors and create interactive dashboards. The dashboards are interactive and responsive with CDS apps and do not need any specific refresh.
• Worked on power platform which is easily manipulate, surface, automate and analyze data and can be used with office 365 or Dynamic 365.
• Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Published reports and dashboards using Power BI.
• Converting all operational excel report into Power BI Reports.
• Worked on all types of transformations that are available in Power bi query editor.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Discussed the Data model, data flow and data mapping with the application development team.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 10, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler, Azure SQL, Azure Storage Explorer, Azure Blob

Confidential - Los Angeles, CA

MSBI Developer

Responsibilities:

• Responsible in collecting business requirements from business group. Analysis, design and prepare functional document, technical document, and test plan.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Implemented project using Agile Methodologies.
• Attended the client end meeting for gathering business requirements and make changes accordingly.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints.
• 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 different kinds of transformations using SSIS.
• Designed BPM diagrams.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using SSIS and loaded data into target, by scheduling the sessions.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like PL/SQL Developer and SQL.

Environment: Windows XP Professional, Visual Studio 2010, SQL Server 2012/2014, T- SQL, Oracle SQL Integration Services (SSIS), SharePoint, Power BI, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio.

Confidential - Louisville, KY

SQL Developer/BI Developer

Responsibilities:

• Gathered business requirements and performed an inventory analysis followed by a first level functional decomposition of all existing legacy systems.
• Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly.
• Created several data models/marts using ER Studio Data Architect and Power BI.
• Created SSRS reports to track the status on documentation for different projects and Business process using Tableau.
• Used dashboard functionalities like SharePoint and was responsible to give access to dashboards to end users.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Performed unit testing to ensure that the developed or modified code is as per the client requirements. Review the code entirely to ensure accuracy, completeness, and quality of the deliverables.
• Incorporating code review comments as a part of code review activity.
• Created data visualizations using various visual objects and Published reports and dashboards to the Power BI service through the Office 365 integration.
• Generated reports using SQL Server Reporting Services 2008/2012 from OLTP and OLAP data sources.
• Experience in Managing and Troubleshooting Reporting services in agile software using GIT.

Environment: MS Office, Microsoft Outlook, SQL Server, PL/SQL, T-SQL, Excel, Microsoft SQL Reporting Services 2012 (SSRS), SSAS 2012, DTS, Windows Server 2008, MS Excel, MS Access, Power BI, MSBI, SAP.

Confidential

SQL BI Developer

Responsibilities:

• Excellent report creation skills using Microsoft SQL Server 2012/2008R2 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS). Worked on OLAP Data Warehouse Analytics, Model, Design, and Implementation.
• Experience in Modeling and designing SSAS Analytics Multidimensional cubes.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Responsible for developing and maintaining Tableau dashboards.
• Used MDX and DAX queries to apply calculations to the cube in SSAS 2012/2008.
• Developed reports like Claim Statements, Fee Bills Transactions, and some end request user reports on periodic basis. Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Developed interactive pages of the application using ASP.NET, ADO.NET, Ajax, Entity Framework, Web Forms pages with C# for the code behind modules and agile methodologies for .Net Framework.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Worked in Agile/Scrum Methodology with daily stand-up meetings and vast knowledge in TFS (Team Foundation Server) 2010. Execution of SQL queries to extract data from DB2 tables for running test scripts.
• Performed Testing, Debugging and Migrating ASP.Net Website from Visual Studio 2005 to Visual Studio 2010.
• Major responsibilities include getting requirements from the user, writing stored procedures for reports, and developing reports using Crystal Reports.
• Worked on SSIS to integrate and analyze data from multiple heterogeneous information sources (Oracle).
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
• Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
• Extracted data from SQL Server 2012/2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL. Created integration component to connect CRM with SharePoint2010.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Environment: Windows server, IIS 6.0, MS Access 2007, MS SQL Server- 2012/2010/2008 R2 Enterprise Edition, Tabular, QlikView, Power BI, ANSI SQL, Visual Studio 2008, VBA, ETL, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, .Net framework, OLAP, Crystal reports, OLTP, UNIX, Linux, DAX, MDX, Erwin, Oracle, Performance Point Sever, C++, Tableau, Excel Pivot, Office-2007/ 2010, DB2, MS Excel, C#.NET, Entity framework.

Confidential

SQL Developer

Responsibilities:

• Performed all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2008 environment.
• Developed, monitored, and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database. Involved Automation of Back Office project and Migration of SQL.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Developed application for business to create Internal Rate of Return (IRR) reports for Private Equity using C#.net plugin for Excel, Excel and Access VBA and SQL Server.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSAS Cubes and Dimensions and defined the Referenced Relationships with the measure groups and fact tables. Reviewed and fine-tuned stored procedures and triggers before production migration.
• Involved in designing Partitions in Cubes to improve performance using SSAS and implemented calculations to aggregate physical measures. Formatted the reports using the Global variables and expressions.
• Involved in deploying, configuring, and managing reports using Report Manager and Report Builder.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Create Net Asset reports and charts in Excel using VBA.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Perform reverse engineering in existing legacy financial applications written in Excel and Access VBA to analyze the impact of huge data source migration project coming forth.
• Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server 2008R2, Tableau, MS Access, SSRS, SSAS, SSMS, SSIS, Windows server, Star Team Version Control tool), Erwin, MS Visio, Oracle, C#, .NET, Text Pad, Text Editor, Power Designer, MS Visio, DTS, SQL Query Analyzer, Microsoft Outlook, TFS.