Srikanth

ad490u@r.postjobfree.com

Mobile number: +1-813-***-****

PROFESSIONAL PROFILE

I’m an innovative IT professional, 10+ years of diverse working experience in Tableau, MicroStrategy and Power BI in large scale data and professional focus on Business Intelligence and Analytics projects with world’s largest financial Banking, Insurance, Retail and Pharma companies.

● Technical IT expertise across all phases of the Software Development Life Cycle (SDLC), I possess a diverse skill set encompassing data analysis, design, development, testing, and software system deployment.

●Excellent Knowledge in Data warehousing – Business Intelligence Analytics projects as a Data Analyst, Data Mapper, and development of reports and design of Data visualization & Dashboards using (MicroStrategy, Tableau and Power Bi).

●Experience in working in agile teams and working independently with Business stakeholders providing solutions and regular updates.

●Expertise on Public objects like Reports, Filters, Prompts, Custom groups, Consolidations, Derived elements and FF reports.

●Expertise on building schema as per the requirement creating Attributes, Facts, Transformations, Hierarchies and Logical tables.

●Extensively worked on Dashboards, documents and dossiers.

●Utilized MicroStrategy tools (Desktop, Web, Object Manager, Command Manager, Enterprise Manager, Integrity Manager).

●I have expertise in freeform SQL reports, SQL analysis, Performance tuning and report debugging. I worked on i-cubes and incremental cubes to handle large datasets to improve Report and Dashboard performance.

●Extensively used VLDB properties for improving the performance of large reports.

●Have expertise in freeform SQL reports, SQL analysis and report debugging.

●Created a words chart, tree map, bullet chart, stacked bar chart, Filters, Map and dashboard formatting, etc. for showing better visualization with KPI’s.

●Hands on experience on MicroStrategy Admin activities and Unix Shell scripting.

●Worked on MicroStrategy and Tableau Desktop for diverse visualizations (Cross tab, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, etc.)

●Experience with Tableau to create reports, visualizations, and interactive dashboards.

●Experience in Tableau connection types, including Oracle direct, Azure SQL data warehouse, and ODBC and configurations and data flows.

●Created interactive filters, parameters and calculations for preparing dashboards and worksheets in Tableau.

●Experience in administering Tableau permissions, roles, and security and securing data layers based on specific identifiers, including role or agency.

●Created interactive filters, Parameters, Calculations, Sets and Groups for preparing dashboards and worksheets in Tableau.

●Applying advanced analytics to large data sets as needed.

●Experience in data and database integration techniques, including data modeling and data normalization.

●Experience in creating T-SQL Packages, Procedures, Functions, Triggers, and Views.

●Worked on action, set, context and advance sorting for showing the better trend/visualization.

●Performed activity on Tableau server like creating schedule, alert, extract refresh, user & group creation, user permission, etc.

●Experienced in publishing and sharing dashboards, scheduling data refreshes and Tableau server level maintenance including User Level accesses.

●Data validation against source site before sending it to client.

●Instrumental in finalization of project requirements and playing a key role in strategic planning to assure achievement of agreed functional and business objectives.

●Managing project deliveries in a timely manner involving seamless onsite/ offshore coordination and transparent communication with all stakeholders at all phases.

●Adept at understanding and translating the project scope into well-articulated requirements and objectives for the team.

●Extensive knowledge in ETL and Data Warehousing with a focus on BI and SDLC.

●Experience in working both Agile and Water fall Methodologies.

●In-Depth understanding of fundamental data ware housing concepts such as Dimensional Modelling, Relational Modelling, Star and Snowflake schemas, Datamart’s, Security and deployment, Fact and Dimensional tables, Logical data modelling.

●Creation of interactive Business Intelligence and Analytics tools, dashboards and data warehousing solutions in MicroStrategy and Tableau.

●Utilized Tableau tools (Desktop, Server, Reader, and Public) for effective data visualization.

●Worked on Tableau Desktop and MicroStrategy for diverse visualizations (Cross tab, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, etc.)

●Experience in Tableau server and MicroStrategy Admin activities.

●Worked extensively on Report Service documents, which were delivered in PDF, and Excel formats.

●Experience in various databases like Hive, Mongo DB, Teradata, Oracle 12C, SQL Server, DB2, Netezza and Snowflake.

●Proficient in SQL stored procedures for business rules and transformations.

●Provided technical walk through to various stake holders (QA Team, UAT Team, etc.)

●Creating filters to restrict end user database access depending on security privileges.

●Providing post-implementation, application maintenance and enhancement support to the client regarding the product/ software application. Interfacing with vendor/s for technical support.

● Setting up and driving process, documentation, and quality standards for all phases of the SDLC.

●Familiar with Windows (98/2000/XP), Windows Server 2003 and Linux OS.

●Managed offshore teams, ensuring high quality output and motivated team members. Proven ability to adapt to changing priorities and solve technical issues while meeting agreed deadlines.

TECHNICAL SKILLS

Business Analytical Tools

MicroStrategy 11.3,10.11,10.6,9.4.1,9.3.1/9.3.0/9.2.1 (Administrator, Desktop, Web, Architect, Intelligence Server, System Manager, Object Manager, Command Manager), Tableau Desktop, Sever and Power Bi

Database and Tools

Oracle 9i/10g/11g/12c, Netezza, Teradata, Hive, Impala, Mongo DB, SQL Server, Snowflake, Big query

Data Modeling

Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Languages and Utilities

SQL, PL/SQL, Python

Environment

Windows (95, 98, 2000, NT, XP,7,8,10), UNIX

Agile Tools

Jira, Git Hub, Jenkins

EDUCATION

University of Hyderabad, Telangana - India - MSc, July -2013.

CERTIFICATIONS

MicroStrategy - Architect.

MicroStrategy - Analyst.

MicroStrategy - Analytics Architect.

Tableau Developer – Simplilearn

Project Experience:

Client: Citi Bank, Tampa, FL Jan 2020 – Feb 2024

Specialist Data Engineer

Project 1: US Regulatory Reporting

Roles & Responsibilities:

●Providing leadership to the technology team in development of standards, reporting and monitoring systems with the aim of providing high quality service and optimization of performance.

●Analysis, design, and development of ad-hoc reporting requirements.

●Developed Annual, Quarterly, weekly and Daily Regulatory Reports for filing using MicroStrategy.

●Worked closely with data modelling and ETL teams to develop the data model and used Python for exploratory analysis use case.

●Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.

●Well versed with the MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy intelligence server, MSTR Architect, MSTR Web, MicroStrategy Report service documents, MicroStrategy Dashboard, and I-Cubes.

●Created Transformations, Custom filters, and Cube Automation.

●Worked extensively in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom groups) with the data warehouse.

●Have expertise in freeform SQL reports, SQL analysis and report debugging.

●Worked extensively in creating Filters, Calculated fields, Actions for Tableau Worksheets and Dashboards. Worked on Row level security and Extract scheduling.

●Worked extensively on Parameters, Sets, Groups and created dynamic interactive reports.

●Experience using Tableau tool to handle the various data feeds from different data sources using Tableau Desktop and developed Executive level Dashboards.

●Designed developed and maintained reports, involved in data validation, analysis, testing and debugging.

●Created Intelligent cubes to solve the performance issues.

●Developed several Dashboards, Dossiers in MicroStrategy and Workbooks in Tableau.

●Extensively used VLDB properties for improving the performance of large reports.

●Responsible for delivery of the project on solution, design and delivery.

Environment:

Tableau, Oracle11g,12C, Hive, Arcadia, Mongo DB, Impala, Snowflake

Client: Citi Bank, Tampa, FL Dec 2016 – Jan 2020

Data Engineer

Project 2: CCAR

Roles & Responsibilities:

●Analysis, design, and development of Tableau and MicroStrategy ad-hoc reporting requirements.

●Developed CCAR Reports for filing using Tableau and MicroStrategy.

●Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.

●Defined best experience for creating customized interactive Tableau dashboards with using Action filters, Quick filters, Parameters and Calculation fields for measures with forecast, trend line and reference lines to handle views more efficiently and by matching requirements to the charts to be chosen, color patterns as per user’s needs, standardizing dashboard’s size, annotation of points and clusters for good look and feel.

●Experience in implementing all types of functions like Number, String, Date, Logical, Agg, User, and Table calc functions.

●Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

●Worked extensively on creating custom filters, prompts, custom groups and consolidations as per requirement.

●Created Reconciliation reports and complex dashboards, documents and dossiers.

●Created static tables, logical tables and created customized reports.

●Designed developed and maintained reports, involved in data validation, analysis, testing and debugging.

●Created I-cubes and incremental Cubes for large scale data.

●Worked extensively on Tableau filters, Parameters, Actions and Custom queries.

●Designed developed and maintained reports, involved in data validation, analysis, testing and debugging.

●Created Intelligent cubes to solve the performance issues.

●Developed several Dashboards, Dossiers in MicroStrategy and Workbooks in Tableau.

●Extensively used VLDB properties for improving the performance of large reports.

●Responsible for delivery of the project on solution, design and delivery.

Environment:

Tableau, MicroStrategy 11.3,10.11, 10.4 (Administrator, Architect, Desktop, Web, Intelligence Server, Object Manager), Oracle 11g, Hive, Arcadia, Mongo DB, Impala, Snowflake

Client: Modspace, Berwyn, PA Jan 2016 – Nov 2016

Senior Software Engineer

Roles & Responsibilities:

●Working at Genpact in their project to Modspace account creating dashboards for fleet sale, custom sale and providing self service capability to users.

●Reporting tool for Vendors and Suppliers for maintaining modular spaces which provides Modspace in detail business overview.

●Working with the business to understand requirements and translate them into technical requirements.

●Responsible for end-to-end delivery of the project on solution, design, and delivery

●Perform analysis and effort estimation.

●Business Intelligence Analytics Solution and design and Production implementation activities.

●Get final sign off from users for delivery of Business Intelligence Analytics and data discovery objects.

●Designed the MicroStrategy Project Schema/Architecture and involved in suggesting changes to the Logical Data Model as per the Business Requests and implementing the same in the MicroStrategy Project Schema.

●Created and modified attributes, facts, hierarchies, and transformation objects as part of the development work for a project.

●Employed various schema modeling techniques like heterogeneous mapping, role attributes by aliasing the tables and other techniques.

●Extensively used report services to create Dynamic Dashboards using Panel stacks, Selectors, and widgets in flash Mode.

●Have used several new controls for Dashboards like time series slider, radio buttons, and drop-down menus.

●I have used several Widgets for Dashboard reporting.

●Heavily worked on testing and validating the data and involved in optimizing SQL, troubleshooting reports using VLDB properties.

●Created subscriptions for Delivery of reports using Distribution Services.

●Design, development, testing and deployment of reports that meet business expectations and are in line with the enterprise-wide Business Intelligence and Analytics standards.

●Reports and dashboards were created using various Business Intelligence tools like MicroStrategy and Power BI.

Environment:

MicroStrategy 9.4, (Architect, Desktop, Web, Object Manager), Power BI, SQL Server, Netezza

Client: Optum Rx, Minnesota Aug 2015 – Nov 2015

Senior Software Engineer

Roles & Responsibilities:

●Rebates and Claims Data Analysis – Optum is working on the Rebate Analysis for the Marketing, worldwide. We were providing services for the Rebates and Claims Business Data-as-a-Service, with Data Discovery, Data Modeling, Data preparation, Cleansing & Quality Visualizations in MicroStrategy, Teradata helping them to view dashboards and take decisions analytically on their expenditure. Optum Data is spread across, Developed Interactive MicroStrategy dashboards for the Marketing and Sales analytical team for quantitative, operational and management reporting of Spend data at enterprise level.

●Analyzed existing reports to discover new patterns and trends in each Categories i.e., SMART Analytics.

●Design and develop MicroStrategy interactive dashboard, Perform Technical unit testing of Data Integration, BI Reports, Create technical design documents, test case documents & code review documents.

●Addressed high priority production issues for quick resolution.

●Developed mappings and implemented SCD Type2 in mapping logic as part of the project requirement.

●Analyzing Business Requirement Document.

●Preparation of Technical Design Document.

●Preparation of Unit Test Plan.

●Coding as per technical design document.

●Unit testing and Preparing Unit test Result’s Document.

●Research & analysis.

●Ad hoc Reporting.

●Job Monitoring

●Monitored Workflows and Sessions using Workflow Monitor.

●Developed Informatica workflows, worklets, sessions associated with the mappings using Workflow Manager.

●Prepared test cases and executed test scripts in cleansing area.

Environment:

MicroStrategy 9.2.1,9.4 (Architect, Desktop, Web, Intelligence Server, Object Manager), Teradata, Informatica

Client: Bharath Biotech, Hyderabad Feb 2014 - Aug 2015

Software Engineer

Roles & Responsibilities:

●Analysis of requirements and prepared Technical design documents.

●Develop reports, dashboards and perform unit testing.

●Developed customized reports using Public objects, Schema objects and performed performance tuning.

●Conducted in-depth analysis including data collection to generate key insight for projects using MicroStrategy documents and dashboards.

●Performed data analysis of dispensing output, as well as providing trending dispensing information to management.

●Created Metrics and Filters for quality improvement and data accuracy, with weekly reporting of any noticeable trends.

●Assisted in developing project charters and communicating key project updates to management and executive leadership.

●Prepared monthly ad-hoc reporting in alignment with organizational needs.

Environment:

MicroStrategy 9.2.1 (Desktop, Web) Oracle 10, Excel

Contact this candidate