Home

Hari Haran - Microstrategy Architect or developer

[email protected]

Location: Plainsboro, New Jersey, USA

Relocation: Yes

Visa: H1B

Hariharan Vajiravel Contact: +1 732-538-4964 MicroStrategy Architect Email: [email protected] PROFESSIONAL SUMMARY: Proficient in development of end-to-end BI Solutions in MicroStrategy based on business requirements. Good hands-on experience in creating Schema, Public objects, Reports, Dashboards, and Dossiers in MicroStrategy. Having overall 15+ years of experience in IT, in which 9+ years of experience in MicroStrategy and remaining in Oracle Database. Extensively worked on MicroStrategy Desktop/Developer(9.X,10.X,11.X) Web, Visual Insights, Object Manager, Integrity Manager, Enterprise Manager. Worked on different MSTR features and functionalities like ICubes, Free form SQL, VLDB properties, Transaction Services, pass through functions. Experience in moving the Objects from Development Environment to QA Environment by using Object Manager. Performing R&D on new MicroStrategy Features and sharing idea with PROS and CONS with existing workflow. Strong knowledge of data warehouse concepts like Star schema and Snow Flake Schema. Exposure in creating Time based subscription in MicroStrategy. Worked on MSTR advanced features MicroStrategy Library and MicroStrategy Workstation. Created Security filters and Security roles to provide user level security. Good Hands on experience in creating MicroStrategy Intelligent Cubes with Dynamic Sourcing. Performing R&D on new MicroStrategy Features and sharing idea with PROS and CONS with existing workflow. Involved in Unit testing, Functional testing and Bug fixing of reports/Dashboards. Analysed and debugged the existing databases and SQL stored procedures and provided solutions if necessary. TECHNICAL SKILLS: MicroStrategy: MicroStrategy 9.X, 10.X, 11.X, Object Manager, User Manager and Command Manager Database Management Systems: Oracle, Exasol, Netezza, SAP HANA, Snowflake Scripting Languages: PL/SQL, LUA Script CERTIFICATIONS: Certified in PL-300 Microsoft Power BI Data Analyst Certified in AZ-900 Azure Fundamentals. Certified in DP-900 Azure Data Fundamentals. Certified in Exasol Certified Database Developer PROFESSIONAL EXPERIENCE: Role: Senior Architect | Client: Tapestry Duration: June 2023 Present | Location: New York City, NY Responsibilities: Involved in Agile methodology to design/develop MicroStrategy objects(Attributes, Metrics, Reports and Dossiers) we are following two weeks Sprint in this project. Involved in creating Daily Sales Report (DSR) and Hourly Sales Report (HSR) for Tapestry brand stores (Coach, Kate Spade and Stuart Weitzman). Also involved in validating the Daily Sales Report data with plan data to avoid data discrepancy. I have involved in Snowflake migration project, which includes schema changes and public objects changes and report validation against existing PROD reports. I have involved in solving PROD issue which impacts entire MSTR by checking recently migrated objects definition. I have involved in creating Technical attribute to create proper join condition between fact tables and dimension tables. Also involved in creating Technical attribute between fact to fact joins in some business cases. I have involved in creating Technical attribute using Join child attribute if fact and dimension tables hot have proper mapping fields. Involved in solving Intelligent cubes memory size related issues also Involved in creating Intelligent cubes for better dashboard performance. Involved in updating the view name in MSTR if view renamed in backend DB by using Architect editor. Involved in creating below mentioned self-service documents. o Name Capture Report o Tabby Evergreen Report Involved in creating user configuration object and also providing project access to the existing users using User manager. . Involved in changing the Subscription owner from one user to another using Command manager. Environment: MicroStrategy 11.3.9, Document and Dossier, Jira, Confluence and Service Now, Object Manager, Command Manager, SAP HANA and Snowflake. Role: Technical Manager | Client: adidas Duration: Jan 2018 May 2023 Location: Portland, OR Responsibilities: Involved in Agile methodology to design/develop MicroStrategy objects (Attributes, Metrics, Reports and Dossiers) we are following two weeks Sprint in this project. All the requirements are gathered in confluence page, and we have Sprint refinement bi-weekly to analyze all the requirement and its feasibility. And we have created jira stories in Agile board backlog, and then based on the business priority we will pick the stories from backlog for Sprint Planning. I have Involved in mentoring the ten members team to deliver the stories on time. I have involved in Daily scrum calls to provide update. Also Involved in monitoring the object deployments from DEV environment to PROD environment and also Experience in moving the objects from one environment to another environment using Object manager. Also Involved in updating the table structure in MicroStrategy warehouse catalog to include new fields from DB. And also used Architect editor to rename the table name in MSTR without disturbing objects. Also worked in ETL script update to add/update logic in DB, And Involved in creating backend views to achieve business use cases. Involved in creating below mentioned self-service reports. o MRP Template o PO Template o SO Template o PR Template Involved in creating Transactional Service reports to do CRUD operation. Also involved in Sprint Retrospective to discuss about what went well during previous sprint and what can be improved for the next sprint. Environment: MicroStrategy 10,11, Object Manager, Transactional Services, Exasol, Jira, Confluence, Power BI and Snowflake. Role: Senior Programmer Analyst | Client: Sanmina - SCI Duration: July 2012 Dec 2017 Location: San Jose, CA Responsibilities: Involved in design/development life cycle including gathering requirements, user interaction and report design and development Analysing the requirements and providing the best and performance driven solutions. Experience in Developing, Debugging, Optimizing the MicroStrategy Dossiers/Dashboards/Reports and Performance Tuning of Dossiers / Dashboards / Reports by using VLDB Settings Expertise in creating complex reports and implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering on the reports & dashboards Getting the inputs from the other team in terms of DB related or reporting purpose which will be helpful in creating new reports Experience in moving the objects from one environment to another environment using Object manager. Environment: MicroStrategy, Dashboard, and Netezza Role: Software Development Engineer | Client: OLAM Duration: Sep 2008 July 2012 Location: Singapore Responsibilities: Understanding the Client Requirements as per the Estimation and Prototypes. Preparing the Design Documents and Check List such as Functional Specifications. Attending the Client calls for understanding change requests, Bug fixing and Clarifications. Designing and Developing Code according to the Functionality. Writing Functions and Stored Procedures. Reviewing the Design and Code as part of Designing. Unit Testing the functionality according to the Requirements. Environment: Oracle 9i, PL/SQL Worked as a trainee in HTC Global services from July 2007 to April 2008 EDUCATION: Bachelor of Technology in Information Technology, University of Madras, India, 2004 Keywords: quality analyst business intelligence database rlang information technology purchase order procedural language Arizona California New York