SUMMARY:

• Over 7 years of IT experience in Business Intelligence (BI) Project Development and Implementation Using MicroStrategy 10/9.x/8.x/7.x Product Suites including MicroStrategy Desktop, Web, Architect, Administrator
• 4+ years of extensive Tableau experience in Enterprise Environment, in Tableau 7.0, 8.0, 9.0 and 10.0 as a developer and Administrator
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Experience in MicroStrategy tool Suite including but not limited to MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy OLAP Provider, MicroStrategy Web and MicroStrategy Narrowcast Server
• Exclusive knowledge in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse
• Strong Experience in MicroStrategy Report Services
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
• Expert in creating Dashboards using Tableau features like Quick Filters, Action Filters, Drill down, Hyper linking, Ranking
• Involved in creating dashboards and reports in Tableau
• Created report schedules on Tableau server
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes
• In handling various Relational Databases like Teradata, SQL Server
• Preparing Dashboards using calculations, parameters in Tableau
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production
• Application knowledge of the following industries: Media & Entertainment, Healthcare, Pharmaceutical, Retail, Banking & Financial Services
• Highly motivated team player and excellent communication, interpersonal & analytical skills

SKILL:

• SQL Server 2012/2017
• SSIS, SSRS, SSAS
• T: SQL
• Teradata
• PostgreSQL
• Hadoop
• Spark 16
• Presto
• Hive
• MicroStrategy 10/9.x/8.x/7.x
• Object Manager
• Enterprise Manager
• Command Manager
• Service Manager
• ODBC test tool
• Tableau Desktop 10.1.5, 9.0, 8.0
• Tableau Server

PROFESSIONAL EXPERIENCE:

Confidential, CA

MICROSTRATEGY/TABleau BI DEVELOPER

Responsibilities:

• Created different schema objects like attributes, and facts by using MicroStrategy Architect in the MicroStrategy BI Suite
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
• Extensively worked with MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment
• Designed Prompts and Filters to generate reports in grid and graph mode
• Created complex custom groups using hierarchy to overcome the restriction of MicroStrategy where total on columns and average on rows cannot be calculated at the same time
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets
• Created several Custom tables, Views, Aggregations for developing reports used in MicroStrategy environment
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment
• Created interactive workbooks using Tableau 10 and 9.x with multiple connections to multiple data sources using data integration.
• Created worksheets using Tableau with primary and secondary data sources using data blending where primary and secondary data sources where linked by specified relationships.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports
• Created various views in Tableau - like Tree-maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau
• Worked on creating interactive, real-time dashboards using drilling downs and customization.
• Created views using various axes like Individual Axes, Dual Axes, and Blended Axes
• Used Trend Lines, Reference Lines, and Annotations to describe the data
• Extensively Participated on moving Reports from Excel to Tableau.
• Used parameters and input controls to give users control over certain values
• Customized data pane based on the requirements and made the dashboards more user friendly
• Worked closely with other team members and ETL team for data analysis
• Created Ad-hoc reports by gathering specific requirements from the different users
• Involved extensively in the overall life cycle of the Data Warehouse integration project

Confidential, San Diego, CA

MICROSTRATEGY/tableau BI DEVELOPER

Responsibilities:

• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets
• Involved in Upgrade of MicroStrategy environment from 8.1 to 9
• Validated end user requirements using MicroStrategy tools Involved in design/development life cycle including gathering requirements, user interaction and report design and development
• Developed metrics, filters, prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web
• Developed various data connections from data source to Tableau Desktop for report and dashboard development
• Involved in Tableau server installations, configuration, creating users, groups, and projects
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data
• Mentored business power users to create reports/dashboards using Tableau desktop
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive. Management to view past, current and forecast sales data
• Built compelling, interactive dashboards in Tableau that answer key business questions
• Utilized Data story telling in Tableau to provide more dynamic and more effective stories from the hidden insights locked in the data
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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
• Worked with end users along with Business Analysts to build reports and dynamic dashboards
• Worked with the DBA on issues of database performance and security

Confidential, Lyndhurst, NJ

MICROSTRATEGY BI DEVELOPER

Responsibilities:

• Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies
• Configured the Narrowcast Server for the MicroStrategy Environment
• Created Users, roles & privileges in the MicroStrategy Environment using the Administrator
• Responsible for gathering and refining business requirements from the Business users
• Created the Publications, Information Objects & Services in the Narrowcast application
• Used the Object Manager to migrate objects to different environments
• Worked on cost containment dashboard project for executive users to see penetration, discounts and performance
• Worked on Internet Dashboard project which points to operating system for real time analysis report on claim process.
• Heavily worked with the end users to finalize the Dashboard layouts and also worked on fine detail formatting for a desired look and feel
• Involved in Testing and Data validation of Reports
• Involved in End-User training, Support and Maintenance
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment
• Very good in using the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, week to year and effectively used them with the metrics

Confidential, New York, NY

SQL/SSIS DEVELOPER

Responsibilities:

• Requirement gathering and understanding the trends that is to be shown in the reports
• Used SSIS to create ETL packages (dtsx files) to validate, extract, transform and load data to data warehouse databases
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS
• Written complex stored procedures and SQL queries
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports
• Worked on tuning the queries and fixing the stored procedures to get the data consistency
• Using various SSIS data transformation tasks like SCD, Look-ups, Fuzzy Look-ups, Merge Union-All, Conditional Splits, Multi cast, Derived column etc.
• Wherever required, ETL process was created, the reports, will be stored, refreshed and utilized in the report on daily basis
• Involved in design of SSIS Package configuration, logging, deployment & job scheduling
• Developed SSIS Packages
• Created Tabular, Drill down, and Parameter reports using SSRS and configured Reports Snapshots, Report Caching for reporting performance
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion etc.
• Developed SSRS Reports
• Created indexes on selective columns to speed up efficiency of queries and analysis in SQL Server Management Studio
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL task, Send mail task, for each loop, row count, union all, merge, data conversion etc.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2008
• Developed SSRS reports which include dynamic grouping fields, drilldown and dashboard report and Export reports into various formats such as PDF, HTML, EXCEL, and WORD
• Flexible, multitasked, responsible, enthusiastic and project oriented team player with excellent written, verbal, presentation and interpersonal communication and leadership skills to develop creative solutions for challenging client needs

Confidential

SQL SERVER DEVELOPER

Responsibilities:

• Requirement gathering - Solution design
• Created SSIS Data Migration Template using sql server 2008
• Actively involved in Normalization of database
• Designed DDL and DML for MS SQL Server 2000
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions
• Actively designed the database to fasten certain daily jobs, stored procedures
• Optimize query performance by creating indexes
• Involved in writing SQL batch scripts
• Created reports for users in different departments in different states using web-enabled reporting by SQL server reporting services and Share Point
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Worked on Queries and Stored Procedures
• Involved in merging existing databases and designed new data models to meet the requirements
• Perform daily database backup & restoration and monitor the performance of Database server
• Create joins and sub-queries for complex queries involving multiple tables