Manager Reports
Resume:
RAM POLAM
Phone: 248-***-****
Email: ***.********@*****.***
PROFESSIONAL SUMMARY:
Versatile IT consultant with over 8 years of experience as a MicroStrategy Developer/Architect in gaming, retail, logistics, finance and banking sectors. A self-starter who enjoys working in a team environment, and who also works very well independently. Well reputed among superiors, colleagues, and associates for analytical, project management, problem solving, team building and leadership skills, as well as for commitment and work ethic.
Over 8 years of strong experience using MicroStrategy 10.1/9.4.1/9.3/9.2/9.0.2/8.2 (Desktop, Intelligence Server, Architect, Object Manager, Integrity Manager, Web, Mobile and Narrowcast Server)
Highly experienced in gathering and documenting business requirements, creating business and functional documents.
Extensively worked in creating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
Experience in Microstrategy Architect, Office, Narrowcast, User security & management, Object Manager & designing reports (grid, freeform, drilldown, ad hoc, OLAP cube) and dashboards in Microstrategy7.2.4/8.0.1/8.0.3/8.1.2/9.0,9.2.1,9.4.1, 10.2
Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 10g /9i/8i/7.x, DB2, NCR TERADATA, SQL Server 2000/7.0/6.5.
Very good knowledge of SQL and created Free-Form SQL reports on Demand.
Worked extensively on MicroStrategy mobile for IPad & IPhone on design, architecture and mobile administration.
Strong knowledge in Retail, Technology domains.
Participated in designing of Multidimensional Modeling in Microstrategy, regulating Star and Snowflake Schemas.
Expert UI designer specialized in developing visually stunning MicroStrategy Dashboards using Report Service
Developed MicroStrategy mobile applications using mobile platform
Highly experienced in fine tuning reports by applying MicroStrategy analytical and database optimizations.
Expert in building Intelligent Cubes for supporting reports and dashboards as well as developing ad-hoc reports
Good understanding in setting up Narrowcast Server concepts
Strong SQL skills.
Proficient in working with Star Schema and Snow Flake schema.
Good experience in building Tableau workbooks, Data Sources, Views and Dashboard
Excellent communication, presentation and interpersonal skills.
TECHNICAL SKILLS
BI Tools : MicroStrategy 10.1, 9.4.1, 9.3, 9.2, 9.0/8.x (Administrator, Desktop, Intelligence Server, Web, Architect, Visual Insight, Object Manager, Integrity Manager, Narrowcast Server, Enterprise Manager, Distribution Services, MicroStrategy Office), Tableau, Cognos Reporting
Database Tools : SQL Server, Oracle, Netezza, Teradata, DB2, Vertica.
Languages : C, C++, SQL, Java
Web Technologies : HTML, XML
PROFESSIONAL EXPERIENCE:
Client: Bayer Healthcare Pharmaceuticals Inc.
Location: Whippany, NJ
Duration: Sep 2016 – Present
Role: Microstrategy/Tableau Developer - Lead
Description: Bayer is a German multinational chemical, pharmaceutical and life sciences company. Bayer's primary areas of business include human and veterinary pharmaceuticals; consumer healthcare products; agricultural chemicals and biotechnology products; and high value polymers.
Responsibilities:
Lead transition process from Deloitte to Infosys for Microstrategy
Only Microstrategy Developer for the project responsible for all the development
Created Ad-hoc reports by gathering specific requirements from the different business units (Oncology, Radiology, WHC, etc.)
Interacted with users from different functional teams across the organization in gathering requirements for developing Sales dashboard and Performance Index Healthcare dashboards
Worked closely with Offshore Admin team in building Attributes, facts, Hierarchies across different BU’s
Built various MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
Created report services documents for IC (Incentive Compensation) records and Sales analysis.
Worked on the Excel formatting, macros and templates of the documents which are used in different services.
Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
Extensive Testing and Data validation of Reports before delivering it as Business takes important decisions on data we provide.
Used Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary
Experience in using Teradata utilities such as Fastload, Multiload and Fast Export.
Developed complex dashboards in Tableau as a part of MDM-Tableau uplift project from scratch.
Gathered requirements from different stake holders from MDM team to develop 30 dashboards across multiple Business Units.
Performed as onsite Admin for Tableau, scheduling refreshes for dashboards, granting end users access, managing user groups, migrating groups from old domain to new domain (Active Directory Migration Project)
Involved in giving demos/Presentations and training to end users on using Microstrategy Web
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
Created status reports and used Jira for tracking the issues and Data Service Request(DSR’s) from Business users.
Environment: MicroStrategy 9.4.1 (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services), Teradata 14.10, 15.10, Tableau 10.1,10.2, 10.3, Informatica 9.6.1, Jira, Windows 7
Client: Hachette Book Group,
Location: NYC
Duration: Feb 2016 – August 2016
Role: MicroStrategy Admin/Developer
Description: Hachette Book Group is a publishing company owned by Hachette Livre, the largest publishing company in France, and the third largest trade and educational publisher in the world. Hachette Livre is a wholly owned subsidiary of Lagardère Group.
Responsibilities:
Administered MicroStrategy environments and formulated end user groups.
Worked with Narrowcast server for sending reports via email to a large executive distribution group.
Handled end user licenses for initiatives.
Implemented Nested Prompts, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
Used the Object Manager to move the objects from one Environment to other in MicroStrategy. And duplicated the project to various other environments when required.
Involved in creating user groups and security filters for users and assign privileges.
Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
Wrote specification for the development.
Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
Extensively used report services to create dashboards to create summary level reports using multiple datasets.
Optimized the performance of the MicroStrategy platform by implementing suitable report design processes, and SQL tuning.
Built visually stunning dashboards as per the requirement of end user.
Upgraded MicroStrategy from 9.4.1 to 10.1
Environment: MicroStrategy 10.1/9.4.1 (MicroStrategy Admin, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Object Manager, MicroStrategy Integrity Manager, MicroStrategy Intelligence Server), DB2, Windows 7, MicroStrategy Tool Suite 9.3.0, 9.4.1, 10.2 (Desktop, Intelligence Server, Narrowcast Server, Web), Toad, MS Excel, Informatica.
Client: Oneida Nation Enterprises,
Location: Verona, NY
Duration: Oct 2014 – Jan 2016
Role: MicroStrategy Developer/Architect
Description: The Oneida Nation or Oneida Indian Nation is a federally recognized tribe of Oneida people. Oneida Indian Nation owns tribal land in Verona, Oneida, and Canastota, New York, on which it operates a number of businesses. These include a resort with a Class III gambling casino.
Responsibilities:
Migration of reports from Cognos to MicroStrategy
Worked on advanced MicroStrategy Reports concepts by creating attributes, facts, metrics, filters, Custom groups and templates using MicroStrategy Desktop
Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
Create highly interactive Microstrategy dashboards by using Visual Insights that replaced legacy reports
Analyzed and developed the new objects in Dev environment. Migrated them to QA environment after unit testing
Created complex Logical Views in MicroStrategy
Worked with Pass through Functions like Apply Simple, Apply Comparison & Customized attribute Qualification Filters
Used SDK for web customization.
Designed and built schema objects using MicroStrategy Architect
Hands on knowledge on upgrading Microstrategy from 9.4.1 to 10.1
Performed as a lead in educating the end users of Supply Chain, Retail, Finance and Gaming departments making them understand the importance and usage of Documents and Dashboards as its their first time using Microstrategy
Working with Business Users to fix reports which required minor changes.
Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
Built Documents and visually stunning dashboards as per the requirement of end users.
Worked on developing Expression and Table based Transformation.
Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
Created Schedules for the reports and documents suggested by the End Users.
Involved in migration of projects from Dev to UAT and UAT to PROD.
Environment: MicroStrategy Tool Suite 9.2.1,9.3.0 (Desktop, Intelligence Server, Narrowcast Server, Web, Office), Oracle 10g R2, Toad, Data stage 7.5.1, Cognos, PLSQL, SDK, MS Access, MS Excel.
Client: BIG LOTS
Location: Columbus, OH
Duration: May 2013 – July 2014
Role: MicroStrategy Developer
Description: Big Lots department stores sell a wide variety of merchandise, including packaged food and beverages, toys, furniture, clothing, housewares, and small electronics, much of which is closed out or overstocked merchandise. I was part of the OMINI project to create Ecommerce report for stores.
Responsibilities:
Worked with business users and analysts and gathered all the reporting needs and worked on a week to week basis to meet the expectation in terms of reporting needs and timelines
Involved in the Analysis, Design, Development and Implementation of Business Intelligence and maintaining applications using MicroStrategy Tool suite
Extensively worked on advanced MicroStrategy Reports concepts by creating attributes, hierarchies, facts, metrics, filters, Custom groups and templates using MicroStrategy Desktop and Web.
Used the Object Manager to move the objects from one Environment to other in MicroStrategy. And duplicated the project to various other environments when required.
Train users on how to efficiently develop simple reports and visual insights through Microstrategy Web
Involved in Testing and Data validation of Reports.
Developed Reports enabling Data Drilling across multiple Dimensions using MicroStrategy Desktop and MicroStrategy Web.
Used SDK or DSS object to create VB application to find out if cache is created in the dss_cat schema
Worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
Extensively used report services for creating Different Dashboards summary level documents with grids & graph combinations.
Worked extensively with the End Users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
Involved in creation of logical views and Freeform SQL Report.
Worked with Pass through Functions like Apply Simple, Apply Comparison & Customized attribute Qualification Filters
Educated the business users on creating their own reports. Provided Ad-hoc reporting for the users.
Performed testing of all reports for the final deployment.
Environment: MicroStrategy 9.0/9.2.1 (Architect, Agent, Object Manager, WEB, Administrator, Enterprise Manager), Narrowcast Server, Dash Boards, SDK, SQL Server, PLSQL, Teradata V2R3, Informatica, Windows NT, Windows 2000 ProfessionalOracle 10g, Teradata V2R6.0.2, Windows XP.
Client: Yum Brand
Location: Louisville KY
Duration: Feb 2012 to May 2013
Role: MicroStrategy Architect/Developer
Description: Yum! Brands is the parent company of KFC, Taco Bell and Pizza Hut. Multiple MicroStrategy projects that support operational reporting and corporate reporting were undertaken with high degree of success and meeting client expectation.
Responsibilities:
Participated in agile meetings to develop business requirement documents for operational report project
Captured user requirements and design specifications
Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
Optimized MicroStrategy reports to run efficiently by using MicroStrategy Intelligent cubes, aggregates, VLDB settings and database optimizations
Developed reports and dashboards that provide insight into customer identification of revenue and potential sales lead.
Used various narrowcast services and distribution services to deliver the files to users via e-mails as well as to the file locations.
Converted Tableau reports and dashboards to MicroStrategy using Visual Insights, Transaction Services, Freeform SQL and Report Services while also creating necessary MicroStrategy schema and public objects.
Created prompted as well as non-prompted freeform reports when the requirements could not be satisfied by regular reports
Designed and built schema objects using MicroStrategy Architect
Created weekly status reports to communicate project status, activities, accomplishments, risks and next steps
Developed reports and dashboards on Transaction Services.
Environment: MicroStrategy 9.4.1/9.3(MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager), Teradata.
Client: Methanex Corporation
Location: Addison, Texas
Duration: May 2010- Feb 2012
Role: MicroStrategy Architect/Developer
Description: Methanex is the world's largest supplier of methanol to major international markets in North America, Asia Pacific, Europe and Latin America. Project involved creating highly optimized adhoc reports, dashboard and Mobile reporting for corporate and field office.
Responsibilities:
Responsible for gathering and refining business requirements from the Business users.
Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
Created facts, dimensions, and attributes using MicroStrategy Architect.
Created metrics, filters, and templates for the reports.
Designed Dashboards using radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
Implemented Nested Prompts, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
Analyzed and developed the new objects in Dev environment. Migrated them to QA environment after unit testing.
Performed Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
Used Command Manager to write scripts for the auto deletion and auto creation of users
Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
Environment: MicroStrategy 8.2.1/9.0.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Dash Boards, SQL Server, Oracle 9i, SQL Navigator, HTML & DHTML Netezza
Client: Accenture
Location: Bangalore, India
Duration: Nov 2009- Feb 2010
Role: Sr. MicroStrategy Developer
Description: Accenture is one of the world’s leading professional services companies, with capabilities in strategy, consulting, digital, technology and operations.
Responsibilities:
Worked with business analysts to baseline the reporting requirements.
Hands on the dimension model with Data Modelling team to close out the gaps in the model to best use the underlying tables needed for BI layer.
Worked with data architects on data needed for testing the reports and dashboards.
Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies and transformations etc.
Profusely used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups and consolidations.
Created drill maps for end users to drill down and recover data.
Worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
Tuned and improved the performance of the dashboards using VLDB properties, database tuning and using cubes.
Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
Took part in design and development of Data marts and integrating them with Data warehouse.
Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
Designed and Developed Microstrategy Dashboards using customized Widgets.
Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
Extensively used report services to create dashboards to create summary level reports using multiple datasets.
Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
Environment: NCR Teradata V2R3, Fast Load, MultiLoad, Fast Export, BTEQ, TPump, Microstrategy Desktop7.x, Microstrategy Intelligence Server 7.x, Microstrategy Web7.x, Microstrategy Narrowcast Server7.x, Microstrategy SDK 7.x Oracle8.0/8i, Informatica 7.0, Windows NT
Contact this candidate