SUMMARY:

• Around 10 years of experience in Business Intelligence solution development, which includes User Interaction, Business Analysis/Modeling, Design/Architecture, Development, Implementation, Integration, Documentation, Testing, and Deployment with various methodologies like Agile, Scrum, and Increment models.
• Proficient Power BI Developer with a good experience in design and development of Business Intelligence applications across various domains.
• Hands on with creating solution driven views and dashboards by developing different visualization types in Tableau, QlikView, Qlik Sense and Power BI.
• Proficient in writing complex T - SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL, Physical, logical database design, and Performance tuning.
• Worked on Designing and Implementation of Business Applications using the Oracle/SQL Server Relational Database Management System (RDBMS).
• Expert in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting the data, Dashboard, Scorecards, Drill - down and Drill-through reports, Defining Data sources and Subtotals for the reports using SSRS and integrating them with SharePoint server and native mode.
• Expert experience improving performance of dashboards and creating incremental refreshes for data sources on Tableau server.
• Hands on experience in connecting Tableau with data bases like Oracle, SQL server, Cisco Hyperion, Archer (Application). Hands on experience with reporting tools like Tableau, QlikView and Qlik sense.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expertise in writing complex DAX Queries and Expressions in Power BI and Power Pivot.
• Created Business Requirement documents (BRD's), such as SRS & FRS, integrated the requirements, and underlying platform functionality.
• Experience in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with the source data. Proven ability to deliver and ensure success in high-pressure/high-risk situations.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various stages of migration/cleansing process, reports, or data validation.
• Good experience on Database execution skills with testing complex SQL, and PL/SQL queries& scripts and worked with Oracle, Microsoft SQL Server, Microsoft Access databases, and Excel Spreadsheet.
• Expert in SQL Server Reporting Services SSRS reports, ad-hoc Reports, Sub Reports, Linked Reports, Report Models and Drill down reports for Sales, Finance and Revenue Management teams.
• Experience in performance tuning and developing existing SSAS Tabular models.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experienced on processing the data files through Talend Data Integration.
• Working knowledge of other ETL tools such as Talend Open Studio.
• Experience in training end users to utilize Power BI reports.
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

TECHNICAL SKILLS:

Reporting Tools: SQL Server Reporting Services (SSRS), Microsoft Power BI, MS Excel, Google data Studio, Tableau

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Query Editor, Informatica Power center, BIDs

Languages: JavaScript, Unix, VBScript

Productivity Tools: Share Point, MS Office Suit, Bitbucket, Bash, Notepad ++, Jira, Squirrel SQL, Oracle SQL Developer

Databases: MS SQL Server, MS Parallel Data Warehouse, SAP Sybase, MySQL, SQL Server 2012

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. Power BI Developer

Responsibilities:

• Developed and published dynamic and complex Visuals, Reports, Dashboard in Power BI Desktop and Power BI service
• Technical lead for SQL Server Analysis Services (SSAS) and Power BI business intelligence program for large retail organization.
• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes, and functions.
• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations.
• Created complex T-SQL queries, stored procedures for data extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, and ad-hoc queries.
• RDBMS (SQL, Oracle, MySQL, MS Access) Application Design and Development -- Implementation, Design, Administration, DB security, Performance Tuning, Data Modeling, migration.
• Extensive DDL/DML design / data quality analysis / ETL work. SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
• Developed SSAS design standards, data models, team processes, and drove migration to SSAS Tabular model.
• Expert in developing Drill through and Drilldown reports using MS SQL Server Reporting Services (SSRS).
• Converted existing multidimensional cubes to tabular model, recreated all existing measures using DAX and release to azure cloud analysis service.
• Led performance tuning and monitoring efforts, provided user training, and led BI project meetings
• Designing Talend ETL jobs to fetch the data from various sources like flat files, SQL Server and MySQL.
• Preparing metadata in Talend Integration studio repository.
• Analyzing business requirements and creating Mappings using Talend.
• Involved in developing graphs using appropriate transformations for implementing the business logics in data loading.
• Involved in testing the SQL Scripts for report development and SSRS and Power BI reports.
• Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL.

Consumer Business and Medicare Project

Confidential

Roles and Responsibilities:

• Performing Application Impact analysis and design arriving high and Low-level design documents.
• Analyzing the given requirements and coordinated among different teams to achieve quality deliverables by preparing workflow diagrams, new process flows and documenting the business process and various business scenarios.
• Interact with Business user’s/end users to diagnose data related issues during data discovery phase.
• Implemented exception handling functionality in SQL queries, batches and stored procedures utilizing Try-Catch block and raise error.
• Designed Talend ETL jobs to fetch the data from various sources like flat files, SQL Server and MySQL.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Transformed data extracted from various sources utilizing Query Editor and Mashup codes in Power BI.
• Used Set Analysis and various QlikView and QlikSense functions in writing expressions for sheet objects.
• Identified unwanted columns, dirty data, and formatted datatypes of columns, rounding values utilizing mashup codes.
• Generated run time values by creating custom measures utilizing DAX in Power BI Desktop.
• Imported custom visuals such as Gantt charts, scroller, hierarchical filters, heat maps to represent data from marketplace in Power BI.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements (SSAS).
• Executed data modeling (Star Schema) with Erwin for the ETL strategy.
• Involved in developing Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Published reports onto Power BI services and pinned visuals to create dashboards to support business decision making.

Confidential, Minneapolis, MN

MSBI/Power BI Developer

Roles and Responsibilities:

• Involved in the entire project lifecycle and communicated with the project teams.
• Provided better insights using Mark types and Mark properties for huge data sets and perform ad-hoc analysis to report the performance monthly and weekly.
• Created Dashboards with interactive views using Dashboard actions, trends, and drill downs along with user level security.
• Created Parameters, customized Calculations, Conditions and Filters for various analytical reports and dashboards.
• Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Performed normalization of the existing OLTP systems (3rd NF), to speed up the DML statements execution time.
• Design Dashboard, Reports using Power BI Desktop.
• Developed First Financial Tabular Model SSAS Cube, Using DAX to develop calculated member, KPI, Dynamic security etc.,
• Designed and Developed the BI Project for multi-dimensional and fact tables
• Designed Dashboard, Report using SSRS
• Design data model and creating the schema on Azure SQL
• Created calculated column and measures with DAX expression and formulas for analysis purpose.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Proactively monitored, determined, and solved issues at SQL/database/server levels.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Maintained ETL strategies while extracting data from different sources such as SQL Server, flat files, and Excel.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business Projects across the organization.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Created data visualizations using various visual objects and Published reports and dashboards to the Power BI service through the Office 365 integration.
• Provided 24X7 production support to ensure timely and error free delivery of reports

Confidential, Columbus, OH

Power BI Developer

Responsibilities:

• Have been involved in the Software engineering concepts that includes Requirement Lifecycle Analysis, SDLC life cycle, Business Process Analysis, Stakeholder Analysis, Business Documentation and Management.
• Worked on Reports from requirement gathering to Report Development and involved in migrating it to production.
• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles to implement business rules and control database access.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Involved in data cleaning to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformation.
• Used Power BI desktop to import and transform data for Business Intelligence, visualize data, author reports, schedule automated refresh, and share dashboards based on reports.
• Migrated few of the SSRS and Excel finance reports to Power BI using Power BI Pro license.
• Utilized DAX queries to design and develop the SSAS Tabular models, KPIs, calculated members as well as hierarchies.
• Used Query Analyzer, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Installation and Configuration of the virtual machine to load the data from On-premises SQL Server to Azure Data warehouse.
• Create the Data Lake Store and Azure Storage to store the structured and unstructured data and set up the firewall rules to specific users to access the data.
• Integrated Custom Visuals like Word Cloud, Chiclet Slicer, Funnel chart, Timeline Slicer, Gantt chart and more based on business requirements using Power BI desktop.
• Created the security model (Row Level Security) in Power BI to restrict the access based on Region and Role of the user.
• Established the relationships among the tables in the database by assigning primary keys, Foreign keys and established the referential integrity.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Involved in physical and logical data modeling using Erwin along with the architects.
• Prepared daily and weekly status reports and collaborated with other team members.

Confidential

Programmer Analyst

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008R2, 2012, 2014.
• Migrated data from SQL Server 2008 R2 to the SQL Server 2012 using SSIS as ETL tool.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2012 backend.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Created SSRS report model projects in bi studio and created, modified, and managed various report models with multiple model objects, source fields and expressions.
• Generated different reports using MS SQL Reporting Services Microsoft Power BI.
• Used/Scheduled the DTS tools and services to run at different intervals in SQL Server that are ideal for developing custom ETL routines for populating decision-support databases using ODBC.
• Designed reports using table filters, single value parameters, multi value parameters, dependent parameters, and Cascading parameters.
• Developed reports using complex TSQL queries using MS SQL 2012/2014, User Defined Functions’, store procedures and views.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services (SSIS).
• Extracted data from various sources like SQL server 2005/2008/2012, Oracle, CSV, Excel, and text file from Client servers and through FTP.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like MS Excel, XML, Flat file and OLEDB data sources.
• Deployed the SQL Server 2008 R2/2012 SSIS packages.