Data Manager

Shamili

Microstrategy Developer

Email:**************@*****.***

Number: 510-***-****

SUMMARY:

Around 7+ years of professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 9/8i/7i/7.0.

Experience in BI applications in many industrial sectors like Banking, Health Care, Telecom and Retail.

Strong experience using MicroStrategySuite (Intelligence Server, Desktop, MDX Adapter/ OLAP Provider, Web, Narrowcast Server, Report Services).

Experience with all the modules of MicroStrategy Product Suite namely MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Dashboard, MicroStrategy Narrowcast Server, and MicroStrategy Desktop.

Extensive knowledge of Logical and Physical modeling along with design on SQL Server.

Implemented proactive delivery reports and used the business intelligence solutions on the web using Microstrategy narrowcast servers.

Extensively worked in MicroStrategy Reporting - Templates, Filters, Metrics, consolidations, Prompts, custom group, and Datamarting Reports.

Generated reports by developing various Schema objects and Application objects in MicroStrategy platform.

Excellent working knowledge with business units to gather requirements and to build POCs

Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

Involved in MicroStrategy Report Services by designing the Documents, Creating Dashboards and Scorecards.

Designed and created Reports from multiple data sources in MicroStrategy.

Expert in performing MicroStrategy upgrade/installation and tuning performance

Performance Optimization, performance monitoring, configuring and tuning experience in Microstrategy Business Intelligence tool suite (Intelligence server, Web) and in database.

Prepared Implementation plan, best practices, document for achievements& learning from the projects.

Expert in implementing, designing and integrating MicroStrategy products

Extensively worked on various Pass-Through functions like ApplySimple, Apply Comparison.

Data modeling experience using Dimensional Data modeling and Star & Snow Flake Schema modeling.

Pro-active involvement in continuous performance improvements for existing OLAP systems.

Worked extensively on MicroStrategy Narrowcast Server applications

Experience working with the Business Analysts and Business users in gathering and documenting user requirements.

Experience includes implementing all phases of the System Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Client-Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP/Business Intelligence Applications.

Expert in setting up the MicroStrategy Security and Administration

High-end database experience using Oracle 10g/9i/8i, MS SQL Server 2005, DB2, Retek, MS Access

7.0/2000, Teradata, SQL, PL/SQL, SQL*Plus, SQL*Loader.

Positive work attitude, interpersonal, and organizing skills matched with the ability to manage stress, time and people effectively.

Expert in designing Web/Mobile Dashboards and Visual Insight

Excellent data analysis and SQL skills

Strong Data Modeling for the MicroStrategy application

Achievement oriented with an ability to manage change with ease. Willing to learn and upgrade Skills.

TECHNICAL SKILLS:

BI Tools

MicroStrategy9.x/8.x (Administrator, Architect, Desktop, Web, Intelligence Server, Narrowcast Server, Report Services and OLAP Services), SAP Business Objects XI 3.1

Databases

Teradata 14.0,V2R4.1,Oracle 12c,11g,11i, and SQL Server (2005/2008), IBM DB2, MS Access 2000 and V2R6.0, Netezza 4.0

Data Modeling

Microsoft Visio, Erwin 4.5

Supporting Tools

MS Project, SQL Navigator, TOAD, Adobe Flash, Flex, SSH Client, Reflection X

ETL Tool

SSIS, Informatica

Languages

C, Java, SQL, PL/SQL, Transact SQL, UNIX shell scripting.

Web

HTML, DHTML, XML, XSL, JSP, JavaScript, Microsoft Front Page, Excel and HomeSite 4.0.

OS

Windows7/ XP/2003/2000,UNIX and Linux

PROFESSIONAL EXPERIENCE:

State Street, Massachusetts,BA Jul’ 2015– Present

Role: Sr. MicroStrategy Developer

Responsibilities:

Interacted with the Business Analysts and Enterprise users.

Involved in the development of Data Models (physical/logical) using Erwin tool as KBB data and reporting requirements are completely different from the existing scenario.

Involved in architecting the schema objects Attributes, Facts, Hierarchies.

Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.

Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.

Customized reports using Custom Groups and Consolidations.

Designed Compound metrics and Complex filters and Time filters.

Developed various Prompts supporting end users to interactively choose different filtering criterion.

Optimized query performance by updating VLDB properties at project level and report level.

Performed optimizations using Report Data Options.

Involved in development of interactive dashboards and scorecards for high level management.

Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.

Used Microstrategy Web to offer interactive reporting to the end users through a web browser

Extensively used Microstrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.

Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.

Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.

Unit tested the reports developed by the other developers.

Assisted the team in integrating the current project with new Enterprise analytics.

Assisted the team in identifying the errors in the underlying data.

Environment: MicroStrategy 9.3.1 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows 7.

Express Scripts, stlouis Missouri Nov’ 2013- Jun’2015

Role: MicroStrategy Developer

Responsibilities:

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

●Involved in Dimensional Modeling by selecting the business process and choosing the dimensions and facts.

●Took part in full data warehousing application lifecycle starting from creating logical and physical data model.

●Identifying and modifying source tables and columns in the warehouse required creating the Microstrategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.

●Created logical data models to recognize source tables and columns, to build Microstrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create Microstrategy project.

●Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports. Worked on Teradata.

●Used Transformations for comparative reports like claims this year to last year (year to date and month to date).

●Generated Key Performance Indicators (KPI) metrics and other metrics.

●Generated reports for the cooperation for Assets period to period.

●Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export / print functionality and drilling options like simple and advanced.

●Delivered documents for Financial Analysis, Statements and Summary, Customer lifetime value and Customer loyalty.

●Developed Flash Dashboards & Scorecards in Microstrategy 9 using Widgets and Selectors for summary level reporting.

●Managed projects through entire Systems Development Life Cycle, including creating timely thorough status reports and leading status meetings.

●Added new users to groups and assigning them security privileges.

●Proactively created report formats and delivered personalized messages from the BI platform through Microstrategy Narrowcast Server to a wide range of users.

Environment: MicroStrategy 9/9.3.1/9.2x, ERWIN 4.0, TOAD 7.0, Microsoft Visual SourceSafe 6, Informatica Power Center, Oracle 11i, Windows XP.

Apple, Sunnyvale, CA

Role:Microstrategy Developer Jan’ 2011 – Oct’2013

Responsibilities:

Active team member and participated in BI team meetings to discuss the user requirements and convert them into MSTR scorecard and dashboards

●Involved with off shore team for development and job responsibilities sharing.

●Created Low Level Design documents (LLD’s) and High Level Design Documents (HLD’s) as per the user requirements.

●Designed the Logical Data Model based on the Physical Data Model to design the Schema.

●Created Schema objects and public objects as per the requirement and also worked on creating the views on database side when needed

●Worked with MicroStrategy Integrity Manager for testing and comparing reports with V8 to V9

●Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Filters, Metrics, Prompts, Templates etc)

●Created ad-hoc reports and freeform SQL reports depending on user requirement.

●Created Interactive Dashboards and Flash Analysis in MicroStrategy Desktop for display in Web.

●Extensively used OLAP services to optimize memory usage and reduce number of hits to database. Hence improved performance.

●Proposed solutions in team meetings involving DAs, ETL and SAs for better reporting standards

●Worked extensively on Advanced Metrics, Advanced Filters, Advanced Prompts, Drill Maps etc

●Worked with MSTR Transformation to leverage MTD and YTD metric

●Fixed the defects created by the testing team within given time.

●Updating Object Mapping document and RLM document for future references.

●Mentoring team members and shared knowledge with them to improve team standards. Assigning work as per the skill sets of team members.

●Worked on debugging complex reports by identifying the issues and doing appropriate enhancements

●Involved in Code Optimization and Query Tuning to improve performance of the reports. Depending on scenario sometimes indexing the database tables with the help of DBA.

●Testing MSTR reports in different environments (DEV, UAT and PROD) for consistency.

●Set up report level security for different users.

●Analyzed the data warehouse data and detected the data quality issues and recommended corrective courses of action

●Involved in UAT Testing Defect resolution.

Environment: MicroStrategy 8, Oracle 10g, MS Office, Quality Center.

Chakkilam Infotech Hyderabad, India June’ 2009-July’ 2010

Jr. Microstrategy Developer

Responsibilities:

Gathered requirements from users and converted them to technical specifications.

Performed SQL tuning to minimize data load time. Excellent gain in performance recorded and also involved in defining requirements, functional specifications, design documentation and test strategy.

Participated actively in Logical design.

Effectively created DDL scripts and populated tables on Data Warehouse.

Developed Data Validation and Polling processes for some of the ETL designs.

Developed ABC (Audit, Balance and Control) processes in ETL.

Created complex metrics with different level dimensionality, condition and transformations for user and business specific reporting needs.

Worked extensively with filters, custom groups, prompts, consolidations and transformations so as to generate reports meeting business needs.

Designed and populated Snowflake Time hierarchy

Set up the initial metadata by creating Schema Objects and Application Object

Environment: MicroStrategy 8.0 (Administrator, Microstrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server), Actuate eReport Designer Professional 6

Indian Oil Corporation- Hyderabad, India Jan’ 2008 – April’ 2009

Role: Oracle PL/SQL Developer

Responsibilities:

Analyzed business requirements from BRD document and worked closely with end Users to get exact business requirements.

Designed and Developed Interfaces using Interface Manager and creating procedures, functions, packages.

Synchronizing data between Cashin and IM/RM system. Integration testing for complete flow.

Comfortably worked in a production environment with change management, defect tracking and status reporting processes.

Played an important role in Analysis, Design, Development, Testing, Documentation, Implementation, Maintenance and Performance tuning of the project.

Participated in daily status and monthly planning meetings.

Involved in deployment of product, 8 months on-site support, Production support and client Interactions.

Environment: CMS Tools, Oracle 10g (PL/SQL), Power Builder, Oracle 10G reports, Report 6i

Contact this candidate