SUMMARY:

• BI SQL/ETL Developer/Power BI development professional with strong verbal and written communication skills and solid analytical skills for writing relational database solutions for businesses. A self - starter who can work independently with 7 years of experience.
• Expert in creating and developing Power BI Dashboards in to rich look and configuring data gateways to have automatic refresh of the dataset.
• Highly experienced in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Working knowledge in SQL Server Analysis Services (OLAP).
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Good knowledge on OOPS, SOLID Principles Object creational design patterns.
• Very good experience in Entity Framework, LINQ to SQL.
• Expertise in creating reports from importing, Direct Query and Live data from several data sources.
• Good at developing and implementing reporting and data solutions, including custom user interfaces. In-depth understanding of all stages of software development life cycle (SDLC).
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. Provide database coding to support business applications using Sybase T- SQL.
• Expertise in installing, maintaining and troubleshooting the Personal and On-Premise Gateway
• Import data from different data source to create Power BI reports and dashboards
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Worked on end to end project in Azure Environment by pulling the source data from SQL Server and storing the data in Azure SQL Server using Blob Storage and creating reports using Power BI Desktop.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created different reports in Power BI Desktop and publish to Power BI online.
• Strong knowledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
• Worked on Power BI desktop and power BI service to publish the reports.
• Involved in writing Complex SQL queries, stored procedures and Triggers accessed SQL SERVER Management Studio (SSMS).
• Worked with developing events and delegates in implementing Multi-threaded application.
• Experience in Creating Reports using SQL Server Reporting Services (SSRS).
• Effective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.
• Excellent verbal and written communication skills, analytical and inter personnel skills.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. BI Analyst/SQL Developer/Power BI Developer

Responsibilities:

• Involved in understanding the client's business processes and gathering technical requirement.
• Analyzing the KPI's based on the end user requirements and needs to develop dashboards using POWER BI.
• Worked on preparing for the development estimation time and technical design documents and setting up different environments.
• Worked with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Liaised with project management and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Involved in creating dynamic well-organized, accurate an insightful Power BI reports/dashboard to support strategic decisions.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Analyzed the KPI insights provided by the client using POWERBI DESKTOP.
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Collaborated with Business Analysts, SMEs and other BI developers across departments to identify existing report needs, new reporting requirements and translated them into deliverable solutions.
• Extracting business data from different OLTP systems and loads into data warehouse using SQL server Integration Services (SSIS)
• Worked on providing row level securities using power bi to restrict data access for various users.
• Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Worked in establishing the migration of data source connection between the Credit and collections power BI reports from SQL DB to the Azure blob storage and extracting the data.
• Involved in certificates to be renewed/ rotated and storage to be re-mounted into CDS-A without impacting Power BI reports.
• Used TFS (Team Foundation Server) and Visual studio Team services (VSTS) to share all the work, code, to sort out the exceptions raised during work.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.

Environment: SQL Server Management Studio, Visual Studio 2015, Confidential Azure, Team Foundation Server (TFS), Power BI Desktop, Power BI service, Agile/Scrum, Power BI, SSIS, SSAS, Visio, MS Excel, and Windows.

Confidential - Redmond, WA

Sr. SQL Developer/Power BI Developer

Responsibilities:

• Assisted customer in configuring and troubleshooting their row-level security for their company
• Created a timetable using Dax to show monthly, weekly, yearly reports of the company, marketers, and agents.
• Gather information from the end user create BRD. Created Power BI reports using normalized and de-normalized data, created calculate measures and calculated columns.
• Assisted customer in configuring and troubleshooting their row-level security for their company
• Created a timetable using Dax to show monthly, weekly, yearly reports of the company, marketers, and agents.
• Performed updates to the SQL system as assigned by management. Collaborated with business support professionals to provide full system maintenance.
• Created Power BI reports using normalized and de-normalized data, created calculate measures and calculated columns.
• Use the different transformation in Power BI to transform the unstructured data. Worked on providing row level securities using power bi to restrict data access for various users.
• Worked on providing row level securities using power bi to restrict data access for various users.
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Created different visualization in the reports using Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc.
• Created and review SQL queries to review and understand the data better.

Environment: MS SQL Server, T- SQL, Power BI, SSIS, SSAS, Visual Studio, Visio, MS Excel, and Windows.

Confidential - Minneapolis, MN

Sr. ETL Developer/SQL Server

Responsibilities:

• Expert in preparing performance Dashboard, Job Failure stats, Data Volume check using SSRS, SSIS, and SQL.
• Create reports in Power BI utilizing the SSAS Tabular via Analysis connector as Data Source.
• Project Specific Activities:
• Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access
• Involved in Data Scrubbing and Data Cleansing using MDS, DQS.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.
• Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Design and write elastic queries to access data across database and Migrate an existing SQL Server Database to use Azure Database.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT,FILTER Functions.
• Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks.

Environment: MS SQL Server 2014, SQL Server Integration Services 2014 (SSIS), SQL Server Analysis Services 2014 (SSAS), SQL Server Reporting Services (SSRS),MDX, DAX,T- SQL, Shell Scripts, Confidential Visual Studio 2014, JIRA, MDS, DQS, Power BI Desktop, Power Query, TFS, Tableau, Azure, MS Access, ETL, Excel.

Confidential - Minneapolis, MN

SQL Developer

Responsibilities:

• Experience with Development and Testing of Restful Services based on Specifications.
• Analyzing different user requirements and coming up with specifications for the various database applications
• Created Request/Response classes to abstract the underlying database model from the API payloads.
• Worked in creating different organization content pack, and service packs
• Expertise in creating reports from importing, Direct Query and Live data from several data sources.
• Worked in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Involved in creating DAX queries.
• Worked in scheduling refresh and troubleshooting refresh issues
• Created PL/ SQL module which was used to integrate the existing data from third parties and on to the database
• Involved in installing, maintaining and troubleshooting the Personal and On-Premise Gateway
• Import data from different data source to create Power BI reports and dashboards
• Writing Unit test across the layer including API controllers.
• Used TFS (Team Foundation Server) to share all the work, code, to sort out the exceptions raised during work.
• Provided daily Status Updates on work completed and the progress.

Environment: SQL Server Management Studio, Visual Studio 2011, MS Excel, MS Outlook, MS Access, Team Foundation Server (TFS), Agile, Unit Testing.