EXPERIENCE SUMMARY:

• Extensive experience working withMSBI, ETL, Oracle 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 knowledge 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.
• 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:

Sr. MSBI/Power BI/Tableau Developer

Confidential, Colombia, SC

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Tableau and Power BI.
• Installed and configuredPower BI and Tableau Desktop.
• Created BIVisualizations and Dashboards as per the requirements.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. inPower BI.
• Developed complexTableau Dashboard reports by gathering requirement on direct interactions withBusiness/Operation teams.
• Created and managed Tableau sites, projects, and workbooks, groups, data views, data sources and data connections
• Established Tableau security, back-up and restore process.
• Maintained and scheduled of Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
• Designed and developedSSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Writing complexSQL Queries, Stored Procedures,Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• CreatedSSIS packagesto integrate the data coming from flat files
• Migrated SSIS Packages from during data migration.
• Optimized queries by looking atExecution Plan for better tuning of the database.
• UsedTemp Tablesto reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Created SSIS packages for loading data from SAP BW/BI to SQL Server.
• Performeddatabase backupand deployment to the production server.
• Involved in modifying existingDataStage Jobsfor better performance.
• Created detail Technical documentation of various staging area operations for future reference and guidance.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports(SSRS 2008/20012).
• Installation and configuration ofSQL Server Reporting Services(SSRS) 2008/2012
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports(SSRS 2008/2012).
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Involved inSIT(System Integration Testing) andUATtesting, bug fixing and documentation for the project.
• DesignedSTAR,SNOW FLAKESchemas.

SQL/Power BI Developer

Confidential, Virginia, VA

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
• Gathered 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, Des Moines, Iowa

Sr. SQL/Tableau/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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• 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 effective 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 effectively 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.

Sr. SQL/MSBI Developer

Confidential

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.

SQL/QlikView Developer

Confidential

Responsibilities:

• 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.
• Worked as a technical consultant for Qlikview. Was a part of the implementation life cycle.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Performed time over time analysis of sales and performance related data.
• Generated daily, weekly and monthly reports for the managers.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• 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.