TECHNICAL SKILLS:

• MSTR BI/Analytics platform Development / Design experience including MicroStrategy BI / Analytics Platform Developer, Mobile, Web and Office tool set
• SDLC experience
• Experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• MSTR BI/Analytics Requirements Gathering, business analysis and modeling, RTM experience
• Design MSTR BI/Analytics solution specifications based on business requirements provided.
• Experience in testing of enterprise wide MSTR BI/Analytics applications.
• MS Office / Project / Visio

EMPLOYMENT HISTORY:

Confidential, Woodlawn, MD

BI Developer

Responsibilities:

• Lead the effort in evaluating business requirements and rules for the projects.
• Dashboard development utilizes interactive selectors, grid/graph, panel stacks, multiple tabs and Web URL SDK approach for linking reports in different projects, allowing drilling from summary reports to detailed reports.
• Experience in full software development life cycle (SDLC) analysis, Design, Development, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• Designed MicroStrategy logical model that aligned with physical data model. Architected the MicroStrategy project.
• Responsible for designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions.
• Created reports with various object prompts to generate various ad - hoc reports.
• Developed dynamic dashboard documents for business users with multiple panel stacks, selectors and customized widgets.
• Involved in requirements gathering and designing MSTR BI specifications based on business requirements from end clients and translating them into report specifications.
• Functional analysis and development of MSTR BI technical design specification documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Involved in MSTR BI requirements gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Worked on the performance tuning of the MicroStrategy reports by using analytical and governing settings in VLDB properties to tune report SQL’s.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Implementation and testing of enterprise wide MSTR BI applications.
• Worked with business analysts to perform unit and regression testing to ensure the data quality prior to production migration.
• Using Integrity Manager for reports and document quality assurance.
• Worked with Microstrategy Admin team to grant users access privilege to the project based on their request.
• Providing support and training to internal and external end users in areas of report development and best practices.
• Continuous evaluation of current systems for areas of improvement.
• Had extensive experience with MS Office, Project, Visio.

Confidential, Irving, TX

Senior MicroStrategy Developer

Responsibilities:

• Implement Visual Crossing web integration as the Microstrategy Widget to fully utilize the map functionality.
• Designed and developed Project document templates based on SDLC methodology.
• Managed several production data warehouse engagements using the entire MicroStrategy 9.x product suite for federal clients, including delivery schedules, sub-contractors, technical approach, systems architecture and resource coordination.
• Worked with MicroStrategy 9.x Object Manager to move objects among the Development, Testing and Production environments.
• Performed customization tasks MicroStrategy Web using Web Customization Editor.
• Designed and implemented a custom web application by embedding MicroStrategy reports and dashboards, using MicroStrategy SDK.
• Created various monthly MicroStrategy dynamic dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets.
• Designing and implementing fulfillments, multi-wave and ad-hoc campaigns (customer/ household level).
• Developed the MicroStrategy data marts for aggregate tables. Optimized data warehouse performance by creating aggregate tables that were frequently used and fact table partition. Fine-tuned the report performance using VLDB settings, SQL join options, metric calculation options and query optimizations.
• Functional analysis and development of MSTR BI technical design specification documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Implementation and testing of enterprise wide MSTR BI applications
• Involved in requirements gathering and designing MSTR BI specifications based on business requirements from end clients and translating them into report specifications.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Involved in MSTR BI requirements gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Worked as a MicroStrategy Administrator in using the Administrator Tools like Object Manager, Project Merge Wizard, Project Duplication and Command Manager in moving the projects/Objects from different Environments. Migrated MicroStrategy from 9.0.1 to 9.2.1 and 9.2.1m.
• Ran ScanMD to remove metadata inconsistencies and worked with MicroStrategy tech support to resolve issues.
• Created and maintained the system user/group accounts and granted privileges and permissions and security roles. Configured user access to database data using connection mappings and created security filters.
• Configured Narrowcasting services to distribute personalized data content to various user groups with customized preferences.
• Administered the Development, Test and Production MicroStrategy environments to ensure proper configuration and Security Settings.
• D eveloped Informatica mappings, enabling the extract, transform and loading large volumes of data into target tables.
• Used Informatica Power Center to build new agent data warehouse by following slowly changing dimensions (SCD) type process.
• Had extensive experience with MS Office, Project, Visio

Confidential, Charlotte, NC

Cognos/MicroStrategy Architect/Administrator

Responsibilities:

• Worked with business analysts to convert the requirements to MicroStrategy reports and dashboards.
• Based on available database schemas, modeled schema objects attributes, facts and hierarchies using MicroStrategy 8.1 Architect. Identified source tables and columns required to create MicroStrategy objects. Developed and configured reports and dashboards for end users in MicroStrategy Desktop and MicroStrategy Web.
• Functional analysis and development of MSTR BI technical design specification documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Involved in MSTR BI requirements gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Experience in full software development life cycle (SDLC) analysis, Design, Development, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• Performed performance tuning using VLDB properties in MicroStrategy 8.1 and building indexes for major fact tables.
• Implementation and testing of enterprise wide MSTR BI applications
• Involved in requirements gathering and designing MSTR BI specifications based on business requirements from end clients and translating them into report specifications.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Created logical views, table alias and role attributes in MicroStrategy to support the new requirements without ETL changes.
• Object migration from DEV to UAT to PROD environment using Object Managers, Project Merge and User Merge. Customized Enterprise Manager Reports for BI managers to monitor report and job performance and follow-ups with business users.
• Embed MicroStrategy analytics in a custom BI application using MicroStrategy Web SDK.
• Created connection mappings to have the same project run against different data sources for different user groups to eliminate project duplication efforts.
• Worked extensively in MicroStrategy administration tasks such as creation of new users, roles, privileges, schedules, shared folders and ACL’s.
• Used Informatica tool to handle complex Mappings and extensively used the various transformations like Source Qualifier, Aggregator, Lookup, Filter, Expression, Sequence Generator, Normalizer, Union and Sorter etc.
• Provided technical and usability training for end users on how to use pre-defined prompted reports and build ad-hoc reports for their business reporting requirements.
• Had extensive experience with MS Office, Project, Visio

Confidential, San Diego, CA

MicroStrategy Developer

Responsibilities:

• Used MicroStrategy 8.0 Architect to build attributes, facts and relationships conforming to the logical model.
• Designed and developed Project document templates based on SDLC methodology.
• Used knowledge of advanced PL/SQL concepts like arrays, tables, cursors, built-in and user defined object types, exception handling and database packages.
• Extensively used MicroStrategy Report Services to generate electronic snapshots of business data and presented them in a visually appealing and intuitive format.
• Worked on the performance tuning of the MicroStrategy reports by using analytical and governing settings in VLDB properties to tune report SQL’s.
• Involved in loading large amounts of data using utilities such as SQL Loader.
• Had extensive experience with MS Office, Project, Visio

Confidential, San Jose, CA

Senior MicroStrategy Analyst

Responsibilities:

• Responsible for leading and defining BI systems strategy, designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions.
• Worked extensively in MicroStrategy 7.5 administration tasks such as creation of new users, roles, privileges, schedules, shared folders and ACL’s.
• Experience in full software development life cycle (SDLC) analysis, Design, Development, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• As a BI architect led and supported key projects like Advertising and Finding Initiative, Trust and Safety, Sojourner Analytics, GEM Analytics M2, Classifieds Analytics, Rent.com, etc.
• Provided architecture guidance, helped in creation of optimal logical model / physical model for reporting to Rent.com.
• Designed MicroStrategy logical model that aligned with physical data model. Set up MicroStrategy metadata and the Intelligence Server. Architected the MicroStrategy project. Created schema objects such as attributes, facts, hierarchies using attribute creation wizard, fact creation wizard, and MicroStrategy Architect.
• Designed and developed MicroStrategy dynamic dashboards, scorecards, strategic and tactical reports (canned & ad-hoc) to the internal eBay customers.
• Conceptualized and led the change to simplify and track the BIX Issues by creating BI Ticketing Process for BI escalations to gain efficiency in tracking and monitoring.
• Championed process improvements within BI team to gain efficiency internally and outside BIA Team.
• Reviewed BI systems to identify Disaster Recovery Gaps and created/tested DR Plan for MicroStrategy.
• Created knowledge base, standard templates and technical specifications for the team members.
• Implemented active capacity planning process by setting up MOM monitoring for disk space, CPU and memory usage for all BIA servers and maintained 99% uptime for eBay Reporting Applications using MicroStrategy 7.5.
• Had extensive experience with MS Office, Project, Visio

Confidential

MicroStrategy System Engineer

Responsibilities:

• Assisted in developing advanced standard and ad-hoc querying and reporting using MicroStrategy 7i including the migration of all Business Objects standard reports into MicroStrategy.
• Designed and developed Project document templates based on SDLC methodology.
• Management of the Systems Access Group in supporting day-to-day campaign execution, standard reporting and ad-hoc data request activities for the campaign management execution team, relationship services and external clients.
• Led the efforts in the business intelligence area to design and develop the first reporting dashboard for the retail credit business group using MicroStrategy 7i.
• Facilitated effective communication across ADS functional groups. Acted as primary business-technical liaison between end users and IT group.
• Responsible for the maintenance, support and enhancements of the DSS and campaign management systems and tools. Engaged in continuous tuning, automation and improvement for all user data accessed environments to reduce complexity and increase efficiency of system components.
• Provided both technical and business expertise in new projects and activities to develop the next generation of campaign execution, reporting and analysis data marts with secure remote data access capabilities via MicroStrategy and Unica Affinium campaign suite.
• Coordination and management of server hardware/software resources related to data access systems.
• Participated in research, feasibility studies, design and development of new products and systems related to data access and privacy compliance.
• Provided support to the analytical group in the generation of complex data extract processes, data files and custom database table population for the purpose of complex modeling and statistical analysis.