SUMMARY

• 7+ years’ IT Experience with well acquainted in performing as MicroStrategy Developer and Architect with strong domain knowledge of Communication, Financial, Pharmaceutical and Retail.
• Extensive experience as MicroStrategy Developer building projects and creating reports and dashboards using MicroStrategy 9.x/8.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect, Distribution services and OLAP services.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Extensive knowledge on Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill Through the data, Adhoc reports.
• Experience in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation, migration and testing.
• Well versed in developing interactive Dashboards and Scorecards.
• Involved in Upgrades from MicroStrategy 8.x to 9.x on Windows platform.
• In - depth understanding of designing physical Data Models using MicroStrategy Architect.
• Hands-on experience working with VLDB and Optimization of query performance.
• Performance Optimization, performance monitoring, configuring and tuning experience in MicroStrategy Business Intelligence tool suite (Intelligence server, Web) and in database.
• Pro-active involvement in continuous performance improvements for existing OLAP systems.
• Working Experience in installing and Configuring MicroStrategy 9.x/8.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Intelligence Server.
• 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.
• Advocates definition of and adoption of best practices and standards. Adept at assessing existing DW/BI oriented methodology and development process and recommending enhancements to improve deliverable quality, time to market and delivery to requirements
• Dedicated, detail oriented and extremely hard working with extensive technical skills.
• Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
• Created security role for every environment.
• Created security filters for the school users to view their respective reports.

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

Confidential, Orlando FL

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.

Confidential, Atlanta GA

MicroStrategy Developer/ Architect

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the Micro Strategy 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 Micro Strategy 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 Micro Strategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create Micro Strategy 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 Micro Strategy 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 Micro Strategy 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.

Confidential, San Diego CA

MicroStrategy Developer

Responsibilities:

• Co-ordinated meetings with clients and business users to discuss and understand requirements.
• Involved in discussion with data modelers to understand data modeling of existing schema.
• Worked with client to gather requirements and prepared technical specifications documents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.
• Involved in JAD (Joint Application and Design) sessions and GAP analysis sessions to understand existing reports and convert Cognos reports into Microstrategy by creating corresponding Attributes, Metrics, Filters and Prompts.
• Involved in migration of Cognos reports into Microstrategy Reports.
• Involved in designing of schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Expertise in using Applysimple Function in Attributes and Metrics to make manipulations to values.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports) on top of Schema Objects.
• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex Microstrategy reports in an efficient way.
• Involved in creation of logical views and Freeform Sql Reports to translate Freeform Sql Cognos Reports into Microstrategy Reports.
• Expertise in developing Microstrategy reports by combining multiple Cognos reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations.
• Involved in creation of reports at Aggregate Level as well as Detail Level Tables to retrieve data in an efficient way.
• Involved in setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Expertise in developing dashboard reports in Microstrategy by combining multiple reports in Cognos by using selectors.
• Involved in development of reports on Sap Cubes.
• Involved in moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window.
• Involved in creation of Users/User Groups and assigning appropriate privileges through User Manager in Administration.
• Involved preparing Test Plans, Test Conditions for developed reports and uploaded test conditions into the Quality Center and Pass those conditions into the Test Lab.

Environment: Microstrategy 9.0.2,Architect,Web Intelligence, Object Manager, Cognos 8.4.1,Framework Manager, Query Studio, Report Studio, Informatica 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2,SAP, SQL, PL/SQL, Windows NT and UNIX.

Confidential, Austin TX

MicroStrategy Developer

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.

Confidential

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