OBJECTIVE

• Over 8+ years of experience as a SQL/ Power BI developer who responds to shifting business needs and priorities in a systematic and effective way. Excels at implementing operational assessments and conducting functional requirements analysis for businesses of all sized.
• Committed to maintain the cutting - edge technical skills and up to date industry knowledge.

TECHNICAL SKILLS

Databases: Oracle 12c, Oracle 18c, SQL Server, Hive, Data Lake, DynamoDB, AWS RedShift

Data Analysis/ETL Tools: Power BI, Tableau, Informatica, Alteryx, MS Excel, SSAS, SSRS, SSIS

Web Technologies: HTML, CSS, JavaScript, PHP

Programing Languages: Python (NumPy, Pandas, Matplotlib, Seaborn, Scitlearn),PostgreSQL, PL/SQL,T-SQL, XML

Project Management/ Agile Tools: JIRA, Pivotal Tracker, Git, Jenkins

SDLC: Agile, Scrum, Waterfall

Testing Tools: HP ALM / Quality Center

OS: Windows, Linux/Unix

Others: AWS, Microsoft Azure, Visio, VBA, Service Now, VS Code

PROFESSIONAL EXPERIENCE

SQL/Power BI DEVELOPER

Confidential, New York, NY

Responsibilities:

• Involved in creating daily support to business users in developing new reports using Power BI for Finance, Marketing and Sales teams.
• Worked on ticketing metrics Dashboard and BI reports migration project from Hyperion, OBIEE, SWR (Simple Web Report), SSRS to Power BI.
• Created complex SQL scripts to extract data from Oracle, SQL Server, AWS Athena, Data Lake, Hive to make data available for enterprise reporting
• Made use of Alteryx, Python scripts and SQL queries for Data Ingestion, analysis, and transformation.
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS), SSMS and SSDT.
• Worked on both live and import mode to bring data to Power BI for creating reports. Used Power BI gateway to schedule daily job to refresh data and establish RLS (Row Level Security).
• Used custom visuals, third party connectors, Power Query, Power Apps, CDS as part of Power BI project.
• Created DAX Queries to generate calculated columns and measures in Power BI.
• Published Power BI Reports on Service and provided access in Web clients and mobile apps
• Extracted data from CRM systems to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer for ETL.
• Utilized Jira to create agile user stories, Log bugs, Track and escalate issues.
• Worked on development and implementation Data Governance and Data management across the organization

Environment: Power BI, Python, Alteryx, Hyperion, OBIEE, SWR (Simple Web Report), SSRS, Oracle, SQL Server, SSAS, SSMS and SSDT, AWS Athena, Dynamo DB, Hive, ETL, Jira

SQL/Tableau/ Power BI Developer

Confidential, Portsmouth, NH

Responsibilities:

• Partnered with Business stakeholders and executives with the goal of providing them with the ability to make decisions and gain insights through data visualization reports and operational reports.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Interact with Business Users, Business Analyst, and source system owners to gather the Requirements and Business logics.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations, and complex calculations to manipulate the data.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, project, time, and location dimension.
• Strong Excel skills, including pivots, VLOOKUP, conditional formatting, large record sets.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Worked on Azure POC for Marketing Data Research and developed pipelines to move the data from Azure blob storage and files shared to Azure SQL Data ware house.
• Used Power BI and Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Gathered reports requirement; collaborated with the business users using wireframe mockups.
• Designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Good understanding of SSRS with Report authoring, created daily, weekly, and monthly reports as per requirement using SSRS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Extensively involved in doing user acceptance testing (UAT).

Environment: Microsoft Power BI, Microsoft Azure, Tableau Server 10.2, Microsoft Excel, MS Access, Power Pivot, Power Query, MS SQL Server.

SQL/POWER BI Developer

Confidential, Westchester, NY

Responsibilities:

• Managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed, and resolved by analyzing data.
• Worked with various data sources such as Oracle, SQL Server, Hadoop, ODBC, and flat file sources
• Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Expert in connecting multiple data sources in Power BI to implement working reports.
• Hands on experience in developing reports and dashboards visualization.
• Developed confidential proprietary analytical tools and reports like Slicer, Pivot chart, Pie Chart, Macros with Microsoft Excel, Power Pivot, and Power Point.
• Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
• Worked on data cleaningof flat files and SharePoint data inPythonusingPandasandNumPy librariesand exporting into Azure data base studio.
• Expert in creating multiple kind of Power BI Reports and Dashboards.
• Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability.
• Implemented subscriptions and snapshots in the SSRS Report Manager.
• Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI.
• Created SSIS package to pull all events and programs data from database server and SharePoint lists.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

Environment: Microsoft Power BI, Microsoft Azure Data Studio, PowerPivot, Oracle, Microsoft Excel, Power Point,Python, NumPy, Pandas, SQL Server, SSRS, SSIS, Hadoop, ODBC.

MSBI Developer

Confidential

Responsibilities:

• Worked on the design and development phases, testing various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bargraphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• Excellent SQL skills for daily testing of data using various SQL queries.
• Managed Power BI Portal to make the data get refreshed and User management to set up a gateway data refresh.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Developing OLAP cubes by identifying tables Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Worked on advanced SQL queries in PostgreSQL for Redshift for leveraging Common Table Expressions, sub-queries, correlated sub-queries, window functions and complex join logic to apply business rules.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures

Environment: Power BI, Tableau, OLAP, SQL Server Analysis Services (SSAS), SQL Server, PostgreSQL, AWS Redshift, AWS DMS.

SQL Developer

Confidential

Responsibilities:

• Designed, implemented, and administrated SQL Server databases.
• Developed various reports to validate the data between source and the target systems.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute Task. Actively SQL involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Created and Modify Stored Procedures, Triggers, Views according to the business.
• Performed database consistency checks at regular intervals.
• Involved in database design process and data modeling process using diagrams and Visio.

Environment: SQL Server, SQL Profiler, Visio, Data Transformation Services, SSIS and T-SQL.