PROFESSIONAL SUMMARY:

• Software Professional with 9+ years of experience in development, testing, and implementation.
• In - depth knowledge of fundamental data warehousing concepts such as entityrelationalmodeling, dimensional modeling,starandsnowflakeschemas, modelingdata marts, Fact & Dimensional Tables.
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipeusing Python / Java.
• Hands-on experience inMicrosoftAzureCloudServices (PaaS & IaaS), Storage, Web Apps, Active Directory, Application Insights, Internet of Things (IoT),AzureSearch, Key Vault, Visual Studio Online (VSO) andSQLAzure
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by usingSSIS services.
• Created SSIS Packages to extract data from Excel Files, MS Access files 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 warehouse
• Extensive work on creating and modifying Micro Strategy Schema objects(such as Attributes, Facts, Hierarchies, Transformations etc.),Application Objects(such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects(such as project, users, user groups, security filter etc.) using Micro strategy desktop.
• Experience in Creating Schema Objects like facts, attributes, Transformations to Develop Public Objects.
• Experience in developing Application objects like Metrics, Filters, prompts, Custom groups, and consolidations.
• Created Reports on MicroStrategy Desktop and Web and Designed Templates, Filters to generate Reports in grid and graph mode.
• Experience in creating Documents and dashboard Reports to view personalized reports based on user requirements by adding different panels, Panel stacks, Selectors and Widgets.
• Experience in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex attributes and Filters.
• Involved in Performance tuning strategies like I cube and VLDB Settings at different levels.
• Worked on Intelligence cubes and created reports from published I - Cubes.
• Created packages to promote objects from one environment to other using Object Manager.
• Developed predictive models using Python& R to predict customers churn and classification of customers.
• Design, developing, deploying, maintaining, and integrating complex Tableau reports, dashboards, and Visualizations.
• Expertise in Business Objectsenterprise Products(Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM)and its deployment.
• Experience in creating Adhoc reporting ready universes usingBusiness Objects Universe Designer.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups ofTableaurepository.
• Involved in installation ofTableaudesktop 9.3,Tableauserver 9.3.Worked on latest versions ofTableau10.x.
• Created extracts and published data sources ontableauServer for the users from various databases .Used complex joins and validated them by running and tuning long SQL queries.
• Hands on experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.
• Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using onSQLServer 2005/2008/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks
• Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.
• Having experience on Database administration like creating the roles, users and giving the permissions for the database, tables, functions etc.
• Experience in creating Ad hoc reports and reports involving complex datasets and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Drill-down, Drill-through and Cascading reports using SSRS.
• Extensively worked with Ranks, alerters, filters, prompts, variables, and calculation contexts in designing reports.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy 10.1/10.0/9.2/9.3/9.4 (Architect, Intelligence Server, Desktop, Web Dash Boards, Web and Report Services), Tableau 9.3/9.5/10.0, 2019.4.0 SSRS, Business Objects XI 4.1/4.0,4.1,4.2 Web Intelligence 4.1 SP5 Patch 3, Patch 7,Power BI, Reporting Services SQL Server.

Databases: Oracle11g, MS SQL Server/2010 r2/2012, MS Access, TOAD 12.11.0, PostGre Sql, MySQL, Teradata, Sap HANAETL: SQL Server Integration Services (SSIS), Data Stage, SQL Server Reporting Services (SSRS) 2008, Power Analyzer, ETL, Data Mining, Data mart, OLAP, OLTP

Cloud Platforms: Amazon Web Services (AWS), Snowflake, SnowSQL, SnowPipeusing.

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential

Responsibilities:

• Designing, developing, and maintaining business intelligence solutions
• Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Presenting information through reports and visualization in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc. in Tableau.
• Experience in creating views, interactive Dashboards and publishing them.
• Understanding fundamental design principles behind scalable application.
• Preparing Dashboards using calculations, parameters in Tableau.
• Deep experience with the design and development of Tableau visualization.
• Design, Development, Implementing Reports and Analyze Data.
• Developed database object as SQL, stored procedures, user defined functions, views, complicated queries.
• Created Dual Axis / Multiple Measures, Combo Charts with different mark types, Geographic Map, Heat Map, Small Multiples, Pie Charts and Bar Charts, Sorting & Grouping and Drilling and Drill Through reports.
• Working with Calculations in Tableau.
• Created workbooks and dashboards by using custom queries and multiple tables.
• Expertise in Designing Aggregations, Hierarchies, Formatting, Sorting, and grouping in Tableau.
• Working with Multiple measures like Individual axis, Axis Blending and Dual Axis.
• Created KPI's for purpose of monitoring/analysis.
• Scheduling the data extracts published to server weekly, Daily and Monthly.
• Creating interactive dashboards with the related views as per client requirements.
• Used calculated fields to compare and analyze data from different perspectives.
• Created dashboards using the data extracted from excel and generating reports by using Tableau desktop.
• Bar charts, line charts, and maps are created
• Worked on possible KPI’s like average revenue per policy, loss ratio, the average cost per claim, claim settlement rate, severity, loss frequency, customer Acquisition rate, customer retention rate and various data insights that can help business.
• Worked extensively with advanced analysis using filters, actions, parameters, and table calculations.
• Created landing dashboard to navigate through the different dashboards.
• Created dashboard using calculated fields, LOD’s, parameters and input controls to give users control over certain values.
• Developing worksheets using calculated fields, hierarchies, parameters, and input controls to give users control over certain values.
• Developing worksheets with different styles like a bar, pie, treemap, dual axis, filled maps.

Environment: Tableau 9.x, 10.x, Tableau Server, Tableau Reader, SQL Server 2014

Sr. Developer

Confidential

Responsibilities:

• Validating the data from SQL Server to Snowflake to make sure it has Apple to Apple match.
• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Worked closely with data modelling and ETL teams to develop the data model.
• Developed the logical and physical data models, created data definition language statements, and worked with database administrators to transition these models to database administrators for successful physical implementation.
• Used MicroStrategy Desktop 9.2.1 to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Extensively used filters, prompts, consolidations, and custom groups to generate canned reports and ad hoc reports.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Generated Key Performance Indicators (KPI) metrics and other metrics
• Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user . Developed reports for MicroStrategy Web users.
• Created Intelligent Cubes to solve the performance issues.
• Extensively used “Apply Simple” function for creating attributes.
• Designed developed and maintained reports, involved in data validation, analysis, testing and debugging
• Introduced the Dashboard to business users and they liked the idea and requested to continue developing the dashboards with the existing reports.
• Developed several dashboards to be delivered to an iPad for the business user.
• Involved in the documentation of technical specifications of the Sales and Inventory Project.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created different Project Sources for different environments like production, testing and development.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
• Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
• Worked on the excel formatting, macros and templates of the documents which are used in different services.
• Exported data from Teradata using Fast Export utility.
• Experience in using Teradata utilities such as Fast load, Multiload and Fast Export.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy Desktop 10.0.x, MicroStrategy Architect; MicroStrategy Web; MicroStrategy Intelligence Server; MicroStrategy Narrowcast Server; MicroStrategy OLAP Services; MicroStrategy Object Manager SQL Server

Sr.Tableau Developer

Confidential

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Understanding and some experience with Big Data; Hadoop, Hive, various other frameworks. Preferably understanding of Cloudera stack including Impala, performance tuning, etc
• Experience with Tableau Server (version 9.0+) and familiarity with Tableau Server administration, configuration, maintenance, and security
• Data mapping of EPIC data elements.
• Wrote SQL Stored procedures for numerous different KPI Metrics from different modules like Average Length of Stay(Epic Care Inpatient), Patients that left the ED without being seen(ASAP), First Case Late Starts (OpTime),Study Turnaround Time (Cardiant), Barcoding Compliance (Willow Inpatient), Average Daily Revenue (Hospital Billing) etc.
• Actively involved in fulfilling the reporting needs from various end users arising due to transition from a legacy EHR system to EPIC .
• Clarity data model knowledge and understanding of clarity data elements / EPIC database structure.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
• CreatedJobs, Workflows, Transformations and Data Flowsaccording to requirement to integrate source data into Target data warehouse
• Extensively worked in creating complex filters, dynamic filters.
• Worked in creating different types of micro charts in dashboards.
• Created custom SQL for generating different complex reports.
• Extensively worked in creating complex Metrics.
• Involved in scheduling dashboards by giving timestamps.
• Created Extracts to reduce the database load and decreasing the report execution by using the Cube Services.
• Worked with back-end Database Administrators to provide requirements for necessary back-end tables.
• Created services using subscription sets, schedules, objects

Environment: Tableau 9.x, 10.x, Tableau Server, Tableau Reader, SQL Server 2014

Confidential

Business Objects Developer

Responsibilities:

• Extensively worked with Ranks, Alerter, filters, prompts, variables, and calculation contexts in designing reports.
• Created theWeb Intelligence Reportand usedEventsforDaily/Weekly /Monthly Schedulingof the reports.
• Designed Universes, incorporating all the business requirements.
• Created complex variables, breaks, sorts, filter, and conditions for various reports.
• Linked multiple data-providers and Used calculation contexts/extended contexts
• Created different Action filters, Parameters, and calculated fields to create most complicated dashboards
• Expertise in Business Intelligence Development in EPIC reporting .
• Interacted with Business Users, Business owners to know their business requirements in developing and modifyingUniverses and Reportsaccordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Appliedsecurity featuresof Business Objectslike row level, report level & object level securityin the universe so as to make the sensitive data secure.
• Designed and maintainedcomplex Universes,resolved loopsby creatingaliasesandcontexts.
• Exported thead-hocready universes to the for makingsemantic layeravailable to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back-end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Created WSDLs using Query as a Web Service (QaaWS) from different Data sources.
• Migrated Xcelsius dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures, and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables, and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created theWeb Intelligence Reportand usedEventsforDaily/Weekly /Monthly Schedulingof the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards, and other Business Objects Applications in new environment.
• Involvedin performance testingof all the reports, which helped in analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, 4.X,WebI, Xcelsius, Universe Designer, Oracle 8i/9i, PL/SQL, Windows XP/7

SQL Developer

Confidential

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Configured and monitored database application.
• Created tables, indexes, and constraints.
• Monitored and tuned database resources and activities for SQL Server databases.
• Performed and automated SQL Server version upgrades and patch installs.
• Designed, developed, and maintained relational databases.
• Developed, implemented, and maintained enterprise business information systems.
• Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients
• Work on support tickets, maintenance tasks and assigned projects at discretion of the Reporting Coordinator.
• Maintain existing Crystal Reports against legacy system and rewrite these reports in SSRS against new data warehouse
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Developed Reports to generate monthly, quarterly, yearly Reports using Tableau and ASP.net
• Prepared of project documentation.
• Prepared test plans for assembly testing & System Integration testing.

Environment: MS SQL Server 2008, ASP.Net

Confidential

Microstrategy Developer.

Responsibilities:

• Involved in creating and scheduling mapping for data loads for warehouse tables.
• Analysis of existing reporting environment and Reports.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created intelligent cube, published it, and defined incremental refresh.
• Developed Tested and Implemented Narrowcast server objects like Documents and
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.
• Performed Adhoc data analysis and created reports on a need basis.
• Extensively worked in developing Metrics Derived metrics Compound metrics and Filters for complex reports.
• Worked on the performance tuning of the MicroStrategy reports.

Environment: MicroStrategy Desktop 9.2.1, 9.0.x, 8 MicroStrategy Architect; MicroStrategy Web; MicroStrategy Intelligence Server; MicroStrategy Narrowcast Server; MicroStrategy OLAP Services; MicroStrategy Object Manager SQL Server