PROFILE SUMMARY

• MicroStrategy Certified Master of Analyst (MCMA) wif more TEMPthan 7 years of experience on varied IT applications like Business Intelligence reporting; Big Data applications; Artificial Intelligence and Machine Learning using AWS.
• Involved in End to End Data Warehousing Projects like Project planning, Business Requirement Analysis, Data Analysis, Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security.
• Experience working wif data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked wif complex de - normalized and normalized data models.
• Well versed and experienced in Dimensional, Data Modeling (Star Schema, Snow-Flake Schema), Data Architecture, Business and Data Analysis.
• Strong noledge of Software Development Life Cycle (SDLC) methodologies like Agile and Waterfall Models.
• Good Experience in Creating Schema Objects (Facts, Attributes, Hierarchies, and Transformations) to develop User Objects.
• Expertise in Developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, Drill Maps, Templates, Searches) to develop Documents and Reports.
• Hands on Experience in Creating Documents from multiple Datasets like Map Application Diagram, Grid and Graph.
• Expertise in Creating Hyper Links in Documents and Drill Reports.
• Expertise in Developing Reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
• Extensively worked, in Creating Interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Developed Dashboards specific to Mobile (iPad and iPhone) using various visualizations supporting Mobile.
• Experience wif revamping existing dashboards to Mobile and creating new Mobile dashboards.
• Fine Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregate Tables and Intelligent Cubes.
• Proficient in using RDBMS Such as Oracle, SQL Server 2000/2005/2008, DB2, Redshift, MySQL, Hive, Impala and Teradata.
• Extensively worked on writing T-SQL stored procedures and automating them in batch process.
• Expertise in developing complex Scorecards using MS Excel and VBA.
• 18-month experience in developing Big Data applications via Hadoop framework, Java MapReduce, Talend.
• Developed Java Map Reduce jobs to process huge amounts of data on distributed platforms.
• Hands on experience in developing Talend jobs using components like tHDFSInput, tMap, tFilter, tSort.
• Experience in importing and exporting data from HDFS/S3 to RDBMS/Data Warehouse platforms using Sqoop.
• Used R Shiny and R analytics to create seasonal adjustment dashboard.
• Generated efficient, quick proof-of-concepts using Alexa and Google Assistant.
• Experience in developing NLP solutions using chatbot frameworks, AWS Lambda, AWS Comprehend, API Gateway.
• Have noledge on creating Restful API using AWS API gateway integration.

TECHNICAL SKILLS

BI/DSS Tools: MicroStrategy 10.4.1/10.2.1/9.4.1/9.3, Microsoft BI Stack, Tableau, Power BI

Databases: Oracle 11g/10g/ SQL Server 2005/2008/2012, MySQL, Teradata, Amazon Redshift

Programming: NodeJS, Java, R Analytics, SQL, PL/SQL, Visual Basic, Python

Big Data Technologies: Hadoop, HDFS, Map Reduce, Sqoop, Hive

ETL Tool: Talend, Informatica

Other: Elastic search, Twilio, AWS Connect, Redis Cache

NLP Services: Amazon Lex, Amazon Polly, AWS Comprehend, Converse AI, Dialog flow, MS Bot framework

PROFESSIONAL EXPERIENCE

Sr. Application Developer

Confidential

Responsibilities:

• Scraped off six hours per testing cycle by developing an automated model comparison report using MicroStrategy- which approximately removed 120 hours from the total testing effort
• Implemented reusable pieces of scripts, queries, and reporting components for current as well as the anticipated models
• Redesigned a solution to implement easy-to-modify features. The implementation reduced the time spent on trivial modifications
• Implemented vital performance metrics such as True-positives rate, False-positives rate, True-negative rate, and False-negative rate to highlight potential anomalies in the model

Sr. Business Intelligence Developer

Confidential

Responsibilities:

• Designed and developed "Adtalem Virtual Assistant" Chatbot implementation to improve automated communication and resolve users' issues minimizing manual intervention of Customer Support.
• Lead and developed Chatbot conversational flows to utilize the available FAQ database for solving customer’s problem and increasing customer satisfaction.
• Developed real-time reporting system for "Adtalem Virtual Assistant" Chatbot to identify missed utterances and low confidence answers.
• Responsible for complete Functional Analysis and development Data Marts and Data Warehouse for the Projects
• Designed MicroStrategy schema and created schema objects such as, attribute, facts, hierarchies, consolidations.
• Developed Dossier and Mobile Dashboards to monitor the performance of the Chat bot.
• Created Drill Reports and hyperlinks to connect the reports wif the main dashboard.
• Involved in writing the Functional & Technical Design documents.
• Coordinated development activities and ensured timely delivery of modules to business wif good quality.
• Reverse engineered existing Java MapReduce workflows to process the vehicle advertisement data.
• Design and develop ETL, data transformation, data migrations and data management processes using Talend Cloud Platform
• Analyze existing Java MapReduce jobs and design equivalent Talend implementation wif enhanced features.
• Designed and developed data processing workflow using Talend Big Data batch jobs.
• Used various Talend components like tMap, tSort, tHiveInput, tHiveOutput, tHDFSInput, tHDFSOutput to develop ETL jobs.
• Worked wif business to gather requirements and responsible for project delivery.
• Extended current shell scripts and Sqoop jobs to import and export required data from the database.
• Developed a Power BI, MicroStrategy report and a Google Assistant skill using Dialog flow to provide summarized sales price data to the management.
• Developed MapReduce jobs in java to process the input data and generate output files to be consumed by Teradata.
• Created MicroStrategy Dossier to provide summary report.
• Contributed to the development of the seasonality adjustment tool using R.
• Used R shiny to improve the user interface of the tool and added variously functionalities
• Connected R functions wif MSTR report to provide real time data
• Created information source, devices, and services in Narrowcast server-MicroStrategy.
• Implemented dynamic subscription using Narrowcast server
• Designed real time dashboards by developing APIs using AWS Lambda, R functions, DynamoDB, etc.

Market Basket Analysis

Confidential

Responsibilities:

• Worked on proof of concept, requirements gathering and estimation of efforts including analysis of existing system and analysis of data.
• Designed and created the architecture for the MicroStrategy Reporting Platform.
• Built Visual Insights Dashboards and Self-Service Reports for the Business Users.
• Proposed and built intelligent cubes to enhance the performance of Field Operations VI Dashboards.
• Created and used different types of prompts including element prompt, expression prompt, object prompt and numeric prompt among others to satisfy the user needs and expectations.
• Created advanced filters and custom group to dynamically define the transformations for metric calculations.
• Created MicroStrategy Report Services Documents for Ledger and Accounting Users.
• Created templates for Self Service reports wif large numbers of attributes and metrics on them.
• Created attributes for various dimensions and keys to map them to the correct table to regulate the table joins in SQL.
• Created other schema objects including facts, system hierarchies and user-defined hierarchies, and table alias among others for the reporting needs.
• Created transaction services report to insert, update and delete records in database views.
• Created and configured reports for end users in MicroStrategy Desktop and MicroStrategy Web.
• Created various services on MicroStrategy Narrowcast Server wif different schedules and subscriptions.
• Created various templates in excel and wrote VBA codes and used them as documents in Narrowcast Server.
• Designed various reports in MS Excel and imported and refreshed data from I-server through MicroStrategy Office.
• Extensively worked on creating Metrics, Derived Metrics and Filters for Complex Reports.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Built performance Scorecards on MS excel.
• Wrote Stored Procedures in SQL Server to import and refresh data monthly.
• Integrated data from various databases to build BI reports.
• Performed data filtering and cleansing using the Data Quality Client for building the Scorecards.
• Wrote Stored Procedures for building the aggregate tables and lookup tables from the raw data.
• Used power pivot and VBA codes to customize the Scorecards as per the business requirements.

Senior Associate

Confidential

Responsibilities:

• Worked wif the architect and the ETL team to determine the need of Data Mart for enhancing the performance of the report.
• Built reports in MicroStrategy to replicate the views of Tableau Dashboards.
• Created and used advanced filters such as Report as a filter and Relationship filter for my reports.
• Created and used all sorts of metrics such as compound metric, level metric, conditional metric, smart metric etc.
• Created public objects such as Consolidations and Custom Groups depending upon the reporting requirement and optimized the SQL.
• Created complex reports involving concepts such as Table Alias and Self Join.
• Built reports on transactional data to define the association rule wif the goal of identifying cross-selling opportunities.
• Created, documented, and executed various test cases for the existing reports and newly built reports.
• Wrote SQL for MicroStrategy Free Form SQL Reports and to build views in Tableau.
• Created Dimensions, Measures, Parameters and Views in Tableau Desktop.
• Developed MicroStrategy Schema, KPIs/Metrics definition, UI Design, Security, Intelligent Cubes and Data Marts.
• Performed all the administration tasks like Monitoring and Analysing the system usage and managing the projects.
• Used free form SQL editor for complex report creation.
• Created Public and Schema objects Schema Objects (Facts / Attributes, Metrics / Filters / Reports).
• Modified Existing version of MicroStrategy objects in order to meet the requirements.
• Created Custom Groups and Consolidation for special reporting requirements.
• Created various reports which are part of dashboard having different interactive widgets dat are accessed by top level executives.
• Created objects list to migrate objects between Dev to UAT/ UAT to Prod.