SUMMARY

• Over 10+years of experience in application development as BI developer in various projects in their design, development, testing, implementation and maintenance phases .
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using the multi - dimensional expression (MDX), Perspectives and Roles.
• Design ed and implement ed BI solutions using Tableau, PowerBI and Developed dashboards and visualizations that empower decision makers .
• Strong hands-on experience implementing dashboarding, data visualizations and analytics using Tableau desktop, Tableau server, Power BI.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Expertise configuring repository, Create/Manage Dashboards, Reports/Answers and building Physical, Business Model and Presentation layer in OBIEE.
• Assist ed in the QA of critical dashboards and visualization .
• Excellent T-SQL development skills to write complex queries involving multiple tables.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using Informatica,BCP utility, DTS, SSIS/ADF.
• Experience in developing ETL mappings and scripts using Informatica PowerCenter 9.6/9.1/8.6 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Experience in creating Transformations and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating simple and parameterized reports, complex reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Hands on experience in designing complex reports using SSRS /Power BI based on SSAS cubes.
• Good knowledge of Normalization, Collations, Data Modelling like Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables using Analysis Services.
• Excellent knowledge in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube s for better database performance and in Deploying and Processing SSAS objects .
• Experienced in building a Tabular Model Cube from Scratch in Databases with different Measures and Dimensions.
• Experience in performance tuning, processing and deploying the cubes.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down andDrill-through reports using SSRS .
• Worked with various versions in Tableau, Tableau Public, Tableau Reader, and Tableau Online
• Extensive experience in Data warehousing environment and with SSIS/ ADF/Oracle data integrator, SSRS, SSAS, Oracle Discoverer and OBIEE.

TECHNICAL SKILLS

RDBMS: MSSQLServer 7.0/ 2000/2005/2008 /2012/2016 , Oracle12c/10g/9i/8i, MS Access.Database Tools Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, SSAS, DTS. GUI/ DB Utilities SQL* Loader, TOAD 6.5/7.0

Reporting Tools: PowerBI, Tableau, SSRS, Cognos, Business Objects, Crystal Reports 9.0/10, OBIEE, MicroStrategy, Oracle Reports, Discoverer10g, SAS, QlikView SSAS, MS Excel, Tabular Models

ETL TOOLS: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert, BCP, Informatica Power Center 9.5/8.6/7.1, ADF. Job Schedulers Autosys, Informatica Scheduler. Operating Systems Windows 2016/2003/2000 Advanced Server, NT & Windows 9x, XP

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

PROFESSIONAL EXPERIENCE

BI DEVELOPER/Tableau developer

Confidential

Responsibilities:

• Confidential utilizes technology to support companies of Allstar Financial Group which are in surety, commercial, and personal lines insurance business . Confidential is a full service, internal program and web development company that designs systems for underwriting, rating, binding & processing across many insurance programs & supporting divisions like Allstar Underwriters Inc, Allstar Surety, Aspen Insurance, Venture Underwriters Inc, RIS Insurance within Allstar Financial group.
• Developed Power BI model, based on that created Dashboards and Reports Showing all key indicators of the Insurance Business of the Group.
• Migrated reports which are already developed in Tableau.
• Developed Executive level and Division level dashboards with Premium, Loss Ratio, Claim Payments, Claim Reserves and Earnings as Key Indicator s based on Tableau Reports and Visualizations which are already exist in system.
• Creat ed Row level security with Power BI in integration with Power BI service portal.
• Explore d data in a variety of ways and across multiple visualizations using Power BI .
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power B I Services.
• Published reports and dashboards to PowerBI Service using Power BI.
• Worked on all types of transformations that are available in Power BI query editor.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Created reports using time intelligence calculations and functions.
• Experienced on data manipulation using DAX.
• Created Reports by pulling data (into Power BI using Both Direct Query and Import options) from SQL Server .
• Created Workspace, content packs and apps for different Companies within Allstar Financial Group and groups of business users within those companies to view the developed reports.
• Wrote calculated columns, Measures in power bi desktop to show good data analysis techniques.

Environment: SQL Server 2017, SSAS, MDX, OLAP, T-SQL, SSRS, PowerBI, Tableau 10.0.1.

Tableau developer

Confidential

Responsibilities:

• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications. created different visualizations using Bars, Lines, and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables using Tableau
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Reports.
• Creating data blending in case of merging two different datasets using Tableau.
• Design ed and develop Tableau visualization solutions.
• Work on generating various dashboards in tableau server using the various data source s.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for tableau report development.
• Prepared dashboards using calculations, parameters in the tableau.
• Developed Power BI model to author Standard Reports comprising all key indicators of the business.
• Create d Power bi reports using data of the cubes of Tabular model
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Installed and configured Enterprise gateway in Power bi service.
• Created content packs and apps for business users to view the developed reports.
• Wrote calculated columns, Measures, the query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Experienced on all types of transformations that are available in Power bi query editor
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Creating and Modifying Tables, Views, Indexes, User-defined Functions, and Triggers as required.
• Develops PowerCenter Workflows and Sessions, and sets up Power Exchange connections to database and mainframe files
• Develops logical and physical data flow models for ETL applications
• Provide System and Application Administration for Informatica PowerCenter and Power Exchange
• Designs, develops, automates, and supports complex applications to extract, transform, and load data
• Identifies and manages interfaces, service levels, standards and configurations
• Plans work and leads team of others; mentors others on the team with product functionality
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week using Charts, Gauges, Tables, a matrix which includes Drill Down Reports, Drill Through Report by Region .

Environment: SQL Server 2017, Azure SQL Server, SSAS, Tabular Models, MDX, OLAP, Informatica PWC & PWX 8.6.1 or 9.x, T-SQL, SSRS, Windows Server 2016, PowerBI, Tableau10.1.3, Tableau Server.

Tableau developer

Confidential

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server /Oracle using SSIS.
• Loading data from various sources like OLEDB, flat files Using SSIS by using various data components to load the data from source to destination.
• Experience in working with SSAS in creating data sources, data source views, named queries, calculated columns, cubes, dimensions, roles and deploying analysis services projects and SSAS cube analysis using MS EXCEL and PowerPivot
• Experience in SSAS OLAP cubes implemented with dimensional data modeling and snowflake schema
• Experience in Defining regular, referenced, many-to-many relationships and creating Hierarchies key
• Experience in Creating MDX queries with calculations, KPIs, Actions, AND Partitions in SSAS.
• Experience in Creating calculations with a new calculated member, new script command and new name set.
• Experience in Defining the relationship between dimensions and measure groups.
• Built a Tabular Model cube from scratch data.
• Built Measures in the tabular model using DAX queries and created partitions in the tabular model.
• Experience in Creating user role-based security from cubes, dimensions, measure groups, etc.
• Deployed cubes, dimensions, and partitions in DEV, UAT, and Production/live servers. Configured ETL packages, cubes in jobs and scheduling jobs using SQL Server
• Our team authored a number of reports based on requests of management and delivered reports using Tableau, PowerBI.
• Designed, developed, tested and maintained Tableau functional reports on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and parameters using Tableau.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Converted existing BO reports to tableau reports.
• Created different KPI using calculated key figures and parameters.
• Developed Tableau data visualizations using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Charts.
• Developed donut charts and implemented complex features in charts like creating bar charts in the tooltip.
• Worked extensively with Advance analysis actions, Calculations, Parameters, Background images, Maps, Trendlines, Statistics and table calculations.
• 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.
• Responsible for creating calculated fields, combine field, bins, sets, geocoding and hierarchies using Tableau desktop.
• Implemented data blending to blend related data from different data sources.
• Developed a Tabular model and generates Power BI dashboards on top of that
• Designed and documented the entire Architecture of Power bi Proof of Concept.
• Created number of reports showing the status of orders placed by customers, Customer satisfaction summary reports based on age, location is provided to management on a daily basis.
• Designed testing procedures for data pulled from the Customer database and for reports authored based on different requirements
• Followed AGILE methodology and involved in testing and related activities too.
• Supervised a team of Report developers and QA testers and also co-authored various reports.
• Actively participated in the Testing cycle of the data warehouse from start to finish.

Environment: Tableau desktop 9.1.1, Tableau Server, PowerBI, SSIS/ Informatica, SSRS, SSAS, Tabular Models, Oracle Discoverer 11 g R1 (11.1.1.7.0 ), Windows Server 2008 R2, MS Access, SQL Server 2016/ 2012/2008 , Teradata, Oracle12c

BI DEVELOPER

Confidential

Responsibilities:

• Successfully migrated data between different heterogeneous sources using SSIS, BCP and Bulk Insert.
• Used Informatica to transform data from SQL 2005 to MS SQL 2008
• Used MDX on Cubes in SSAS to create reports in SSRS. Working as part of the ETL team, moved data as required.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy. Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services
• Responsible for maintaining and creating Reports using Discoverer Desktop, Discoverer Plus and other tools accessing multiple data sources.
• Created a number of reports based on the status of customers and named as Case ownership changes, Case aging summary by workgroup, Active pipeline report, Active loss mitigation, delinquency by investor
• Authored a number of custom reports based on the various requirements from the management.
• Designed and documented the report development and Designed testing procedures
• Involved in QA Team meetings and walkthroughs and weekly QA testing reviews.
• Coordinated with a team of 4 QA testers, used SCRUM techniques for AGILE development.
• Involved in Functional, Regression and User Acceptance Testing of Data Warehouse and Reports and Tracked defects and change requests were submitted using Quality Center

Environment: SQL Server 2000/2005/2008 , SSAS, MDX, OLAP, SSIS, Informatica Power Center 8.6.1, SQL/ T-SQL, SSRS, Oracle BI Discoverer 10.1.2.48.18 , oracle Portal 10.1.4, oracle 10 g

BI DEVELOPER

Confidential

Responsibilities:

• Archway markets and analyses different promotion and their performance.
• Utilized Informatica to produce a Data Mart for reporting and
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Design and Develop and Test ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter
• Work in a fast-paced environment, under minimal supervision providing technical guidance to the team members
• Responsible for database schema design, extensive T-SQL development, integration testing and other projects that may be necessary to help the team achieve their goals
• Working closely with Onshore and offshore application development leads
• ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter
• Identify efficiencies and ways to improve design and development processes
• Identify ways to increase efficiency of production support - Find solutions that allow operations to better do their job without involving development resource time
• Provide reporting services and best practices in developing reports with Oracle Reports, BI Publisher, Oracle Discoverer, Micro Strategy against client’s proprietary systems.
• Created and maintained portals for three different clients. Supported existing Oracle Discoverer 10g reports and modified them as per business user’s requests
• Attached discoverer reports to the portals. Developed Customized and Ad-hoc reports using Templates, Metrics, Filters, Auto Prompts, Custom Groups, and Transformations.
• Created Customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats. Configured Metrics, Attributes, and Filters for each Report.
• Actively used Data Modeling & Technical Diagramming Tools Erwin & Visio. Relationships were figured out and mapping was done accordingly. Conceptual Data Modeling, analysis, etc. were made.
• Used MicroStrategy Desktop (Templates, Filters, and Metrics) to generate advanced reports in the grid, graph, and SQL mode, consisting of data analysis by combining a template with filters.
• Created MicroStrategy Filters, Documents, Facts, Attributes, Hierarchies, etc. Created Complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality. Involved in Testing and Tuning of Reports and Objects.

Environment: SQL Server 2000/2005, SSIS, Informatica PowerCenter 7.1, T-SQL, Oracle Discoverer 10g, BI Publisher, MicroStrategy 7.5.2/7.2.3/7. x (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle 9i AS Portal, Oracle 8, Windows NT, Unix