SUMMARY

• Expertise in implementing enterprise data warehouse projects with major emphasis on Business Intelligence, Business Analysis, Project Management, Dashboard design, Dossier Design, Schema Design.
• Upgraded MicroStrategy platform from 9.4 version to 10.2 along with many other MicroStrategy upgrades.
• Expertise in managing and administering some of the largest MicroStrategy Clients Infrastructure, providing product support, project support, troubleshooting, user and project access controls for various MicroStrategy projects.
• Strong skill and experience in developing MicroStrategy interactive and dynamic dashboards in 9x,10x and KPI Reports using flash functionality.
• High Proficiency in MicroStrategy Metadata, Enterprise Manager Metadata and Enterprise Manager Data Warehouse. Ability to write complex SQL against these data models and generating Reports for performance baselines, troubleshooting and monitoring activities in the Metadata and Microstrategy infrastructure.
• Strong skills in design, development, architecting, administration and maintenance of Business Intelligence applications using MicroStrategy 9x and 10x, extensive experience with reporting, architecting, design and development.
• Designed and developed Level Metrics, Role Attributes, Value Prompts, Market Basket analysis, Relationship Filters, Logical Views, complex Attribute parent child relationships, Multi - data set Dashboards with the latest Panel, Panel Stock and Widgets, Object Prompts, DataMart Reports, Custom groups and Consolidations, complex Transformations with pass though functions, Drill Maps and Hierarchies.
• Working on Tableau certification.
• Expertise in Teradata, Oracle 11/10g/9i/8i/8.0, Netezza, DB2, BigData and AWS OLAP and Building Data Marts on Client-Server environment.
• Designing Star and Snowflake schemas for business needs.
• Solid understanding in Meta data Strategies, warehouse standards, OOP and Component Based development.
• Experience in all phases of the System Development Life Cycle (SDLC).

TECHNICAL SKILLS

RDBMS: Teradata, Oracle 11/10g/9i /8I / 8.0 / 7.X, Netezza, MS SQL Server, DB2, MS Access

Data Modeling: VISIO, ERwin 3.5.2 / 4.0

Cloud Architecture: Google Bigquery

Project Management: MS Projects

OLAP Tools: MicroStrategy suite (Intelligence Server, Desktop, Web, Architect, Object Manager) of products 9x, 10x and 11

Languages: SQL, PL/SQL

Internet Technology: ASP, HTML and XML

ETL: Informatica and SQL* Loader.

Operating Systems: Windows 2000/NT 4.0, Windows 95, MS-DOS, UNIX and Linux.

GUI: Visual Basic, Oracle Developer 2000, MS Access.

Others: Ms-PowerPoint, Ms-Word, Ms-Excel & Visio 5.0 & Toad. Structured Systems Analysis & Design, Internet/Intranet Application Design & Development

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Responsibilities:

• Develop new reporting schema/ public objects layer as required by various clients.
• Create database Views.
• Design datamodel for clients new requests and adding new features to Confidential Nia.
• Participate in client demo discussions
• Work with ETL and DB people to design data model and data sourcing, fetching
• Resolve client’s escalation issues regarding reporting, data and functionality.
• Resolved many high escalations of various clients in different domains.
• Continued monitoring of production issues around mobile solutions.
• Worked as Team lead for 3 offshore Engineers.
• Developed many MicroStrategy standards documentations and made them available in shared locations which are serving as standard templates to other team members and offshore people.
• Involved in the administration of MSTR application on Windows platform
• Involved in the Administration of MSTR I-Server, Web Server, Narrowcast Server and Metadata.
• Troubleshooted various administration and Architectural MSTR issues.
• Performed MSTR architectural services for various clients MSTR projects.
• Performed as business analyst on many MSTR projects.
• Acted as constant support to report analyst who develop Adhoc reporting in MSTR project.
• Conducted various training sessions to Sales Force.
• Agile environment type of development.
• Managing and mentoring a team of MSTR developers.
• Responsible for Object Migration using Object Manager.
• Responsible for performance monitoring of the MSTR reports and activity involved in fine tuning the report SQL using VLDB properties.
• Participated in various SDK related meeting with web developers.
• Installed and evaluated MSTR 10.11 and certified suitable version for indigenous reporting tool.
• Used Command manager scripts.

Environment: SQL Server, Windows, Microstrategy 9.1/9.2.1/ 10.2/10.11 BI Tool (Administrator, Intelligence Server, Desktop, Object Manager, Web, Command Manager), WEB SDK, .Net, Java.

Confidential, Atlanta, GA

Responsibilities:

• Successfully implemented mobile solutions to 1000 field account executives and over 30000 external dealers.
• Developed many iPad perfect dashboards for the field force.
• Continued monitoring of production issues around mobile solutions.
• Acted as a team lead for 3 offshore MSTR developers.
• Simultaneously handled around 4 projects SDLC.
• Developed many MicroStrategy standards documentations and made them available in shared locations which are serving as standard templates to other team members and offshore people.
• Won many business impact awards within the organization as a team member and as an individual.
• Assisted data architecture team to design suitable data model, adopting star and snowflake schemas for MicroStrategy applications.
• Involved in the administration of MSTR application on Windows platform
• Successfully migrated MSTR application components from Windows to Linux platform.
• Involved in the Administration of MSTR application on Linux platform.
• Involved in the Administration of MSTR I-Server, Web Server, Narrowcast Server and Metadata.
• Troubleshooted various administration and Architectural MSTR issues.
• Performed MSTR architectural services for 8 MSTR projects.
• Performed data model and data architect services for 4 warehouse projects.
• Acted as a business analyst to 5 MSTR projects.
• Developed around 5 MSTR projects.
• Developed around 90 MSTR dashboards. Some of the dashboards are of award winning quality.
• Developed and published 100’s of MSTR reports and report services documents.
• Performed constant support to report analyst who developed Adhoc reporting in MSTR project.
• Involved in migration of datawarehouse from Oracle to Netezza.
• Supported Informatica ETL team in source and target analysis and design of the ETL mappings.
• Conducted various training sessions to national reporting analyst team with and without MicroStrategy corporation team.
• Managed and mentored a team of MSTR developers.
• Responsible for object Migration using Object Manager.
• Responsible for performance monitoring of the MSTR reports and actively involved in fine tuning the report SQL using VLDB properties.

Environment: Oracle 11/10g/9i, Netezza, Windows, Linux, Microstrategy 8.0.1/8.1.2/ 9.1/9.2.1/ 10.2 BI Tool (Administrator, Intelligence Server, Desktop, Object Manager, Web, Narrowcaster, Command Manager), Visio, Erwin.