Shruthi Mulagada Email & Phone Number

Provo, Ut And Seattle, Wa, Us

Tysons Corner, Va, Us

• Worked as a lead product manager for MicroStrategy Workstation in shaping the product to have legacy MicroStrategy tools merged to MicroStrategy One. • Product expert and conducted product webinars on MicroStrategy enterprise suite that includes License Manager, System Manager, Command Manager, Developer, Workstation, Distribution Services, Gateways, Platform Analytics and Web.• Extensive research on the market analysis to understand industry trends, competitor products, and customer needs. Drive the product roadmap based on metrics that evaluate the customer impact required for prioritization. • Responsible for documentation and video demonstration of product features after product releases on a monthly schedule.• Engage with customers regularly to understand the problem statement and gather requirements on product features. Track the product features to prioritize for roadmap based on business value and customer impact.• Collaborate with sales, marketing, consulting, and tech support to ensure effective product launches and log relevant enhancement requests and defects.• Collaborate with product council (key stakeholders from across various departments) in the company to prioritize an accurate roadmap and get approved for the roadmap scheduled. • Follow up with engineering teams (SEs and QEs) to answer product related questions and engage with product owners for successful product releases.• Design on Figma and Balsamiq to create wireframes that will help shape the user story and feature requirements. Helps to easily communicate with UX with the design requirements.• Ensure to include security and design considerations, accessibility and telemetry requirements for the product developed. Measure the success KPIs for product value and user adoption for the feature proposed.

Tysons Corner, Va, Us

• Gained technical expertise and an in-depth knowledge on AWS and Azure deployments for MicroStrategy Cloud Enterprise customers.• Stayed updated on the latest features and trends in cloud computing to apply the methods for MSTR customers.• Specialized in creating backups for on-prem customers and help them to migrate to cloud-based enterprise systems. • Troubleshooted any issues for our AWS/Azure cloud customers with upgrades and cloud deployments.• Worked with customers to customize cloud solutions based on their unique needs and challenges.• Created comprehensive documentation for cloud deployment processes, best practices, and troubleshooting guides.• Collaborated with support organization to act as a product specialist for all cloud-based customers.• Optimized existing cloud deployments for customers to optimize cost, performance, and scalability.

Tysons Corner, Va, Us

• Create and monitor all the MSTR Administrative/Analytical/Application tasks for the company which includes writing procedures in Command Manager using Java SDK, developing key solution dossiers/dashboards for CXO’s, install/configure MSTR on AWS to latest MSTR product versions and managing all metadata layer development• Deploy MSTR on AWS Cloud provisioning portal and manage all of MicroStrategy’s servers on cloud platform• Manage all the object migrations between projects and environments related to the company.• Hands on experience on Installation and Deployment of MicroStrategy Product Suite from Development to QA and Production environments• Configure Platform Analytics post the MicroStrategy Upgrade to monitor the security, objects usage, environments and projects• Lead MicroStrategy administration and is responsible for overall MicroStrategy security architecture design and implementation• Design data model for the warehouse required for the ETL architecture• Manage all Configuration, Application and Schema objects usage and memory consumption to monitor system breakouts through Platform Analytics• Build super cubes based on SQL queries to efficiently build dossiers with improved performance• Implement software’s like Solar Winds and Pingdom alerts to monitor all the server’s CPU usage• Schedule alerts using Python scripts and integrate with Slack for Tomcat memory alerts, CPU/memory alerts• Automated the scripts for Create, modify and delete users, usergroups, security filters, subscriptions to resolve ad-hoc requests using Command Manager• Publish platform administration periodical reports to the Intelligence center team and the Executives to maintain and monitor the health of the key dossiers on a daily basis

Chicago, Illinois, Us

• Creation of new projects, a metadata repository and the ODBC connections for the new project• Migration of various schema objects, reports and documents using object manager.• Creating schema layer objects for developing reports related to Global Analytics of all units of Mc Donald’s• Interacting with business users to identify dashboard strategies, report layouts, and analysis presentations• Helping to develop and create logic for schema layer development – STAR schema for Web Analytics Data Warehouse• Using the data Integration tool Pentaho for designing ETL jobs in the process of building Data warehouses and Data Marts• Designed Logical and Physical Data models for the US Global Platform and e-commerce platform of Mc Donald’s units keeping in mind the business and technical requirements• Created the conceptual model for the data transformation from Batch files to Data warehouse – created ETL jobs to transform data.• Testing the reports against the database using Teradata SQL assistant and AWS Database management• Applying advanced data analytics techniques to derive meaningful information out of large amounts of data• Collaborate with DBA to understand the data model and develop facts and dimension tables• Used Apply functions to execute the database specific function in the attributes, metrics and filters• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.• Responsible for documentation and configuration of Enterprise Manager for logging statistics and reporting purposes• Executed Command Manger Scripts for Purging Caches, creating Schema and public objects

Foster City, Ca, Us

• Generated reports using MicroStrategy, IBM Cognos, Tableau and Performance Point Services on SharePoint• Designed and planned data visualization in BI reports• Created cubes by using Pentaho Schema Workbench Installation and setup complete BI suite as per the clients requirements• Developed Schema, KPIs/Metrics definition, UI Design, Security, Intelligent Cubes and Data Marts• Used Command Manager to purge caches on database loads• Used free form SQL editor for complex report creation• Created Tableau scorecards, dashboards and publishing reports to Tableau Server• Used Data Blending in tableau to develop reports using multiple data sources• Developed strong understanding of advanced Tableau features including calculated fields, level of detail calculations, table calculations, groups, sets, parameters, data blending, and dashboard actions• Analyzed data from various databases and formatted it into graphs using MicroStrategy Desktop• Analyzed and developed insights on information of all User Security Incident issues related to Texas Tech University• Developed ETL process using Pentaho PDI to extract the data from HIS and Vista, and populated it in to BI Data mart• Created a model which automatically generates reports and translates data analysis into insightful and actionable items using command manager• Experience in designing and maintaining schema and public objects within MicroStrategy• Developed configuration objects required at the architect level

Lubbock, Texas, Us

• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution globally• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions• The packages created included a variety of transformations, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion• Support development of custom reports and data visualization products such as Dashboards• Web mapping of all the locations of Reagor Dykes using Tableau and IBM Cognos• Created metrics, filters, Prompts, Custom Groups, Consolidations, Reports and documents in MicroStrategy Desktop• Tested reports in Tableau Web for fixing formatting issues• Wrote SQL against the database to compare and test report results• Built Tableau dashboards with live connect• Gathered and documented the analysis and reporting requirements required for the university

New York, Ny, Us

• Retrieved, reviewed and transformed client’s data from various LOB’s and loaded into internal system using ETL tools and SQL• Created test plans and validated them using SQL scripts• Identifying the Target Test Items to be evaluated by the test effort• Gathering and managing the Test Data, evaluating the outcome of each test cycle• Ongoing management of the relevant iDDA(International Demand Deposit Account) UAT(User Acceptance Testing) environments supporting key testing programs and iDDA release projects, including:• Running all agreed iDDA batches• Raising, tracking and resolution of environment issues/defects in cooperation with the appropriate Technology teams• Liaison with the off-shore vendor team providing environment support services• Support the Test Event Leads and LOB(Line of Business) Application Leads in the co-ordination of the planning and execution of the test schedule for each testing program• Work with the Test Event Leads, CIB(Commercial International Bank) Technology teams, and LOB test leads to prioritize/track/resolve iDDA UAT environment issues• Production of test environment metric packs (daily, weekly, and monthly as required)• Good analytical skills, challenging and inquiring mind, attention to detail and tenacity

• Used Ab Initio GDE to generate complex graphs for the ETL process using Join, Rollup and Reformat transform components and executed using the defined framework.• Developed and supported the extraction, transformation and load process for the Data Warehouse from heterogeneous source systems using Ab Initio.• Involved in the design and implementation of the Data model using Star Schema.• Extensively used Partition and de-partition components to improve performance by using parallelism.• Involved in automating the ETL processes through scheduling software and also involved in custom ETL process.• Modified the Ab Initio components’ parameters, utilized all three kinds of parallelism and thereby improved the overall performance of the application.• Developed various Ab Initio Graphs for data cleansing, Data validation and Profiling tools and also worked with various Data quality and Data standardization issues• Creating load ready files using Ab Initio ETL tool to load into Oracle Database and Worked with implementing SQL Loading Direct/Conventional and DML approach.• Deployed and test executed the graphs as executable Korn shell scripts in the application system

Master Of Science (M.S.), Management Information Systems And Services

Master Of Science (M.S.), Computer Science

Bachelor Of Technology (B.Tech.), Electrical, Electronics And Communications Engineering