SUMMARY

• Around 5+ years of IT experience in Database Design, Development and business intelligence of Microsoft SQL Server, Power BI, Tableau, Informatica, SSIS, SSRS with various business domains like Health, Electrical, Technology, Education and Health domains.
• Worked with .net team in order to generate Embed tokens, Report Id’s, Object Id’s and Group Id’s and Embed Power BI reports as well as individual Tiles
• Created complex reports, dashboards and workbooks using Power BI Desktop and Published to Power BI Server and SQL Server Reporting Services
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as billing hours and case proceedings along with slicers and dicers enabling end - user to make filters.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Installed and Upgraded Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Expertise in designing SSIS Packages and Informatica to import and transform data between databases and external data sources using various transformations.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL) and Excellent command of writing ad hoc queries utilizing dynamic SQL.
• Expertise in creating reports of all types in SSRS, like ad hoc, drill-down, pivot, and tabular reports.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in creating data models and DataMart’s based on user requirements and available data fields.
• Worked on motion chart, Bubble chart, and drilldown analysis using Tableau desktop. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, report design and monitoring of system usage.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Experience on publishing Power BI reports on dashboards in Power BI server. Designed and developed Power BI graphical and visualization solutions based on business requirement.
• Published reports to Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Experience in working with PowerCenter Client tools such as PowerCenter Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

TECHNICAL SKILLS

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

Monitoring & compliance Tools: Lite-Speed, Spotlight, SCOM, SQL secure

ETL& Reporting Tools: SSIS, SSRS, SSAS, Crystal Reports, Business Objects

Databases: MS-SQL Server, Oracle 11g, MYSQL

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, JAVA, C#, VB.

Operating System: Windows 95/98,NT,Windows XP/2003/2000, Unix & Linux

Web technologies: HTML, XML, VBScript, JavaScript

Tools: Erwin, Visual Studio 2008/2005, Visio, Visual Source Safe, Salesforce.com

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

SQL SSIS/SSRS/Power BI Developer

Responsibilities:

• Created look up tables and imported fact table from Oracle and designed the data model
• Designed and documented the entire Architecture of Power BI POC.
• Designed and Optimised SQL code in order to pull necessary columns and improve data loading
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2016 and unit test SSIS load processes for performance check.
• Created Cross- filter relationships, and maintained Row- Level Security for Embedding Power BI reports for Customers
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Created Navigation reports using Buttons, Bookmarks in Power BI Desktop
• Created Index Keys in look up tables and maintained relationships in order to improve the performance of repots
• Designed Pie charts, Bar charts, Trend charts in order to display three years of Historical data
• Created complex DAX Queries in order to meet the business requirement of conditional hiding of data, created conditional columns and measures
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications. Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager. Created Reports using Charts, Gauges, Tables, matrix.
• Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Embedded Individual Tiles into Application and also worked on Embedding complete Report using Report ID
• Enabled Query Caching in Power BI Service to meet SLA’s for Performance of the report

Environment: Power BI Embedded, ORACLE, PL/ SQL Developer, SSIS, SSRS, SQL, Power BI Desktop, Windows 10, MS Word, MS Excel, C#, Visio, DAX Studio.

Confidential, Denver, CO

SQL SSSIS/SSRS/Power BI Developer

Responsibilities:

• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Worked on all types of transformations that are available in Power bi query editor
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created and configured an OLTP replication database for disaster recovery purpose.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Extensively worked on creating SSIS packages and have used for each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
• Created the SSIS packages and scheduled them using SQL Server agent.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Creating data blending in case of merging two different datasets using Tableau
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Designed and documented the entire Architecture of Power BI POC.
• Wrote complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as SQL Server, Oracle, etc.
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Scheduled Automatic refresh and scheduling refresh in power BI service.
• Wrote calculated columns, Measures query's in power BI desktop to show good data analysis techniques.
• Worked on all types of transformations that are available in Power BI query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyse business requirements and outline the proposed solution.
• Database creation (DDL, DML), database tuning, SQL tuning, performance planning.
• Transformed complex business logic into Database design and maintaining it by using SQL Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
• Created Technical and Non- Technical Reports using Power BI Desktop
• Validated and Tested Data across Power BI reports and Published to Power BI Services
• Created DAX functions for various fact calculations for efficient data visualization in Power BI.
• Installed Power BI Gateway and Scheduled Power BI refresh to Maintain fresh data

Environment: SSMS 2017, POWER BI, SSIS, ORACLE SQL DEVELOPER.