SUMMARY

• Over 6+ years of IT experience with expertise in analysis, design, development and implementation of data warehouses, data marts using Power BI, Tableau, ETL Tool (SSIS) and RDBMS like Oracle 10g/11g, MS SQL Server 2014/16, Teradata and Azure SQL DB.
• 4+ Experience as a report developer using Power BI and Tableau visualization tool, also used SSIS for data integration prospective.
• 2 years of strong experience in Power BI 2.5x/2.7x designed, developed and published multiple innovative visualization report and dashboard in MS SQL Server/Azure cloud environment.
• 2+ years of strong experience in Tableau 8x/9x, designed and developed multiple advanced visualization report and dashboard in using MySQL, Teradata etc.
• Experience in working with banking, financial and insurance verticals.
• Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status.
• Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL Query/ T - SQL /MS Excel.
• Hands on Experience in performance tuning and query optimization in different databases like using SQL Server 2014/2016, Oracle 10g/11g and Teradata 15.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, Information, Text and Date functions.
• Heavily used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau.
• Hands on designing and deploying rich graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Generated context filters and data source filters while handling large volume of data using Power BI.
• Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Hands on experience with MSBI (SSIS) to extract, transform and load data into database.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing, system testing and defect tracking using Clear Quest.
• Adeptness to organize information, communicate and present research findings in a clear and useful manner.
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem-solving skills and document function/process flows.
• Good communication skills inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop (2.68), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools: SQL Server Integration Services (SSIS).

Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15, Azure SQL DB

Operating System: Windows, UNIX

Languages: C, C++, SQL, PL/SQL, T-SQL

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Power BI Developer

Responsibilities:

• Participated in the user requirement gathering and design meetings.
• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Participate in Microsoft SSIS ETL Framework to perform tasks synchronously and/or asynchronously.
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Experiences in various types of tasks like: Execute SQL Task, For each Loop Container Task, Sequence Container, Data Flow Task, File System Task, Execute Package Task, Bulk Insert Task, FTP Task and Send Mail Task on control flow and data flow in SSIS and Implementing like: Conditional Split, Look-up, Merge, Merge Join, Multicast, Union, Row Count, Fuzzy Look-up, Fuzzy Grouping and Checkpoint, Transactions in SSIS.
• Read source data from Azure SQL DB, CSV, ORACLE 11g, SQL Server 2016. through Power BI.
• Generated context filters and data source filters while handling large volume of data.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Have used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Created Row level security so based on role, the end user can view the data.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns and measures.

Environment: Microsoft Power BI 2.68, SSIS, SQL Server 2016, ORACLE 12c, UNIX

Confidential, Denver, CO

Tableau developer

Responsibilities:

• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop 9.0.
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
• Created story using sequence of worksheets to convey information using Tableau.
• In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.
• Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
• Used different functions like number, string, date, Type conversions, aggregate functions.
• Created performance recording to improve Tableau’s performance.
• Effectively used data blending feature in tableau desktop 9.0.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Written complex SQL queries to read data from source databases like Teradata and SQL Server 2014.
• Modified existing Unix shell script to automate the process.

Environment: Tableau 9.1 (Tableau Desktop, Tableau Server, Tableau online), MS Office Suite, Oracle 10g, MySQL, Unix, SQL Server 2014

Confidential, Irving, TX

Tableau Developer

Responsibilities:

• Understand the business requirement, existing Architecture, database details to work on this project.
• Have gone through the Business requirement document as well as dataflow, business logic and Business rules that need to be applied. clarify the doubts with Business user to understand requirement clearly and propose technical solutions to meet the business requirement wherever needed.
• Created dashboards in tableau according to user specifications and prepared stories to provide an understandable and helpful vision.
• Involved in creating dashboards by extracting data from different sources and used data blending to blend two data tables in case of merging data.
• Created data visualizations, applied various actions (URL, Filter, Parameters) in Tableau Desktop 8.0.
• Develop, Organize, manage and maintain graphs, tables and document templates for the reports.
• Using different source systems such as Excel, Oracle, SQL Server and MS SQL Server, Created tableau desktop reports and dashboards.
• Designed standardized data mart with aggregated data, calculated metrics to suffice the source that the data need for various tableau reports and also worked with ETL developers, DBAs to implement the same in Development, Test and Production environment.
• Participated in QlikView and tableau comparison sessions.
• Used SQL, PowerPoint, Info View and Excel daily to generate various performance reports for analysis.

Environment: Tableau Desktop 8.2, Tableau Server, MS Office Suite, Oracle 10g, T-SQL, Unix, SQL Server 2014