SUMMARY

• Extensive experience working withMSBI/Power BI, Cognos and SQL Server.
• Worked in different domains likeInsurance, Banking, and Salesorganization applications.
• Experienced working with agile methodology involving inAnalysis, Design, Development and Deployment of MSBI solutions.
• Installationandconfigurationof all the suites of Power BI products, setting upthePower BI environmentto Client locations byInstallingandconfiguring.
• Tested the Report/Cube Performances, Security, Batch Process, Report schedules in the newCognosenvironment.
• Expert in Understanding the Technical Specification and creating and modifying theSSIS packagesaccording to theBusinessrequirements. Experienced working withDatabase ArchitectureforDesign and Development of Data models and Data warehouse.
• Experience in WritingT SQL (DDL, DML AND DCL), developing/creating new database objects such asTables,Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profilerusingSQL SERVER.
• Extensive noledge in dealing withRDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Experience indeveloping SSIS packagesfordata migrationbetween different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS.
• Developed and maintainedSSIS packagesto integrate with different type of sources such asSQL Servers, Oracle, flat files, and non - SQL sources.
• Used Master Data Management (MDM) to reference data.
• Closely working with category for implementation MDM of new projects, Customers and vendors.
• Good Knowledge ofNormalization, Performance Tuning, Development Life Cycle source control and ticketing systemsandVersion Controltools while Design and Development of Data warehouse.
• Developed and maintainedtables, indexes, stored procedures, views, triggersand other objects utilizing the latestDMLandDDLsyntax.
• Worked on differentC# scriptstoAutomate SSISpackages to load the data directly to staging DB.
• ConfiguredCheck Points, Break points, Event HandlersandLoggingto theSSIS packages.
• Proficient in creatingStored Procedures, Views, FunctionsandTriggersinT-SQLfor designing and DevelopingSSIS packages.
• Experience in Developing and ExtendingSSAS Cubes, Building the Dimensions, Deploying, ProcessingSSAS objects, Cubes withSnow Flake SchemasandStar SchemausingSQL Server Analysis Services (SSAS)
• Handled Performance Tuning and Optimization on in large-scale production environments.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters
• Highly skilled in developingOLAP cubesusingSSAS measures,measure groups and dimension membersin SQL Server Analysis Services using Dynamic Analysis expression(DAX), mathematical formulae, and user-defined functions.
• Expertise increating Perspectives, Partitions and Design Aggregationsin cubes using SSAS.
• Excellent hands on experience in creating groups, measures, KPIs, Charts, and summary reports, analysis reports and sub-reports as per business requirements using SSRS.
• Created reports such asParameterized, Cascading, drill through/Drill down Reports, Chartsand specialized in producingSub ReportsusingRelational data warehouseandOLAP Cubes.
• Experience in generatingon-demand and scheduled reportsfor business analysis or management decision usingSSRS.
• Power BIto create self-service BI capabilities like Power pivots, Power views using DAX Scripts.
• Developed Reports, Dashboards inPower BIfrom the Scratch and customized existing visualizations.
• Created Calculated Columns and Measures inPower BIas per requirement using DAX.
• Performed end to end installation and configuration of Microsoft Azure, Power BI and Integrated with other servers.
• Worked in Cloud Azure Portal, Azure Data Lake store, Azure Data factories and Azure SQL databases.
• Connect and fetch millions of JSON documents to Power BI through Elastic Search using REST API.
• Data modeling using Composite models in Power BI, retrieved data from REST Elastic search and SQL server. Implemented Row level security to restrict data access for required users.
• Scheduled Automatic refresh and scheduling refresh in Power BI Services.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: Cognos, SSRS, Excel, Tableau, Power BI.

Programming: Python, C++, TSQL, PL SQL.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Tampa FL

Sr. MSBI/Power BI Developer

Responsibilities:

• Import data from different data source to create Power BI/Cognos reports and dashboards.
• Involved in creating dynamic well-organized, accurate and insightful Power BI/Cognos 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.
• CreatedPower Play cubeas data source from bothCognos series inframework managerand published aspackages.
• Create and maintain data models/Architecture standards including Master Data Management
• 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 noledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Cognos.
• Worked on Power BI desktop and power BI service to publish the reports.
• Created complex calculations using DAX.
• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Provided 24X7 production support to ensure timely and error free delivery of reports.

Confidential

SQL/Power BI Developer

Responsibilities:

• Designed different types of reports like drill down, drill through, sub reports, parameterized reports and cascading reports in SSRS and Power BI
• Data modeling inside of Power BI with mashup code and query editor
• Gatheird user requirements and analyzed and designed the dashboard layout.
• Designed and documented the entire Architecture of Power BI for Poc
• Created Azure Data Factory for Data movement from various sources to Azure SQL Data Warehouse
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using Dimension modelling with Teradata.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Utilized the Agile Scrum methodology to analyze the requirements to create stories
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps
• Executed SQL queries using TOAD for Oracle dB and AQT for DB2, for data extraction and validation
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Worked on Custom Visualizations like Chicklet Slicer, Synoptic Panel, Play Axis and Word Cloud.
• Created various visualizations such as Stacked Charts, Pie Charts, and Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Confidential

Sr Power BI developer

Responsibilities:

• End to End experience in designing and deploying data through different environments.
• Created and modified the schema objects like Attributes, Facts, Views and Logical Tables.
• Heavily built different types of visualizations using Histograms, Scatter plots, Box Whisker plots, Bar charts, Heat Maps, Area charts, Geographic Maps in Tableau Desktop based on the business requirement.
• Installed and setup Power BI environment in the organization.
• Experienced in using various dashboard components like Horizontal, Vertical containers to display multiple chart types and filters in a single dashboard.
• Published extracts to Tableau server with custom extract refresh schedules and tracked and maintained the refresh timelines on a timely basis.
• Migrated Tableau Reports/dashboards to Power BI.
• WroteDAXqueries to retrieve data fromOLAP (SSAS)cubes.
• Used performance recorder extensively to monitor the performance of the reports individually for each action and optimized the reports accordingly for better performance.
• Developed complex SQL queries for querying the data against different data bases for data verification, identifying null values and duplicates as a part of data validation in the reports.
• Active participation in final UAT phases to assist users in ad-hoc testing of the Tableau reports and workbooks.
• Aggressively worked and resolved JIRA tickets as a part of UAT and Production support.
• Maintained and updated Tableau reports on a timely basis for any changes.
• Good hands on experience in developing the Dashboard reports using ‘Key Performance Indicators (KPI)’ for Top management for quick decision making to drive the business.
• Extensive experience in using ‘Level of Detail’ using Fixed, Include and Exclude.
• Provided Production Support to Tableau users and wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as setting permissions, managing ownerships, and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Very strong Dashboard UI/UX design experience and passionate in building TEMPeffective data visualizations for the best user experience.
• Familiar with best Practices around visualization and design.
• Good understanding of business environment, excellent communication skills and ability to work proactively in a fast-paced environment.
• Communicate TEMPeffectively with colleagues and business users.

Environment: Tableau Desktop 2018.02, 10.5, 10.3, 10.2, Tableau Server 10.3, SQL developer, SQL Server 2016, Oracle, Teradata, Service Now, T-SQL, SSIS, SSRS, Microsoft SharePoint, Microsoft Excel, MS Access, Windows 2007 server.

Confidential

MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Developed Stored Procedures, User Defined Functions, Views,and SQLScripts for complex business logic.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views source control and ticketing systems.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Used Joins, CTE's, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and Stored Procedures and enforced business rules via checks and constraints.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration services (SSIS)
• Developed and deployedSSISpackages forETLfromOLTPand various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. PerformedETLmappings usingMS SQLServer Integration.
• CreatedSSISpackages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQLserver, Flat files) into theSQLServer data warehouse usingSSIS.
• Created Jobs inSSISand was responsible forETLjob scheduled to run daily. Solved the issues associated withETLData Warehouse Failure.
• DevelopedSSAS OLAP Cubesand Partitioning Cubes.
• UsingSQLserver reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created jobs for automatically running Stored Procedures for day-end operations usingSQLServer agent such as index rebuild, data loads and summary reports.
• Involved in Performance Tuning of Code using execution plan andSQLprofiler and added Indexes to improve performance on tables.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• Designing and implementing a variety ofSSRSreports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• DesignedSSRSreports with dynamic sorting, defining data source and subtotals for the report.
• Created different types of reports such as Cross-Tab, Drill-down, Drill Through, OLAP and formatting them using bothSSRS.

Confidential

SQL/BI Developer

Responsibilities:

• Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using SQL Server Reporting Services (SSRS).
• Defined the report layout in SSRS. Created complex stored procedures for Reporting services, Analyzed Reports and Fixed Bugs in stored procedures.
• Implemented SSIS packages to load the Data into Staging, ODS and dimensional model.
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then used conditional split to select that new records before inserting into the database.
• Created Dimensions with the cube wizard and T-SQL programming. Refreshing the cube to get the latest information updated for OLAP databases. Deployment of Cubes to the production server.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Generated daily, weekly and monthly reports for the managers.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes TEMPeffectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• SSAS cube development in both SQL 2005 and 2008 for financial planning and operational performance metrics.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters inMDX.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Design web-based resource areas in collaboration with IT guidelines.