SUMMARY:

• Senior Microstrategy developer with over fifteen (15) years of experience in implementation of distributed, multi - tier, data modeling, data warehousing/OLAP and Confidential applications
• Worked on huge reporting and data analysis projects for organizations like Confidential, CISCO, AT&T, BT and HT
• Expertise working with the MicroStrategy suite of products: Developer, Architect, Web, Mobile, Enterprise manager, System Manager, Transaction Services, Object Manager, Command Manager, Narrowcast Server, Distribution Services and Administration
• Proficient with MicroStrategy Confidential
• Involved in planning and implementation of major environmental migrations and upgrades
• Expertise in SQL Server and good working knowledge of SSIS
• Comprehensive knowledge of business intelligence and data warehousing architecture
• Good understanding of RDBMS and Dimensional Modeling, star and snow flake schemas
• Working knowledge of the Confidential ecosystem and associated components, Hadoop, Sqoop, Pig and Hive
• Excellent communication, interpersonal and customer handling skills

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2008 R2/2014

Operating Systems: Windows Server 2008/2003/2000/ NT and Windows XP.

Design Tools: MS Visio 2007/2003

Reporting Tools: MicroStrategy, Actuate, SSRS and Tableau

ETL Tools: SQL Server Integration Services (SSIS)

Confidential Tools: Hadoop, Hive, PIG and Sqoop

PROFESSIONAL EXPERIENCE:

Sr. Microstrategy Developer

Confidential, Durham, NC

Responsibilities:

• Worked closely with the business users to understand the functionality and the requirements
• Analyzed data models, data warehouse (SQL Server 2014) to implement the reporting in MicroStrategy
• Identified and created the health care data domain artifacts needed for the analytics
• Created various Microstrategy objects and relevant KPIs which revealed the provider’s contract information, patient turnover, claims processing, utilization, authorizations and emergency department activities etc.
• Managed the business intelligence reporting needs of end users
• Designed, created and implemented the reports, and query capability in MicroStrategy for the business users
• Coordinated with different team members throughout the project life cycle for seamless deliveries
• Trained team members/business users on an as needed basis
• Created visualizations in Visual Insight and enabled the users for self-service BI

Environment: MicroStrategy 10.2 product suite and SQL Server 2014

Sr. Microstrategy Developer

Confidential

Responsibilities:

• Worked on design and implementation of Microstrategy dashboards (financial reporting, sales and invoice reporting) for various businesses under Confidential
• Developed several executive dashboards with navigation and user interface created in MicroStrategy
• Created SQL scripts to perform data integration from variety of sources into the DWH.
• Involved in creating MicroStrategy logical model by creating relevant objects as needed
• Proficient in debugging the SQL passes of datasets
• Proficient in writing SQL scripts for several Free Form SQL reports
• Worked extensively on creating and configuring the intelligent cubes and developed Visual Insight dashboards
• Created schedules for publishing the intelligent cubes as per the workflow in System Manager
• Worked on configuring mobile servers and realizing dashboards on iPads, also created homepage for iPad dashboards
• Created report subscriptions in Narrowcast server as per the user needs
• Worked on end-to-end delivery process methodology
• Implemented user grouping and created users as per the user privileges
• Implemented transaction services to facilitate users to interact with dashboards to write back to DB dynamically
• Involved in MicroStrategy upgrades from 9.0.1m 9.2.1 9.3.1 9.4.1

Environment: Big Data Hadoop ecosystem, MicroStrategy 9.4.1 product suite, SQL Server 2008 and MS SSIS

Sr. Microstrategy Developer

Confidential, Fort Lauderdale, FL

Responsibilities:

• Gathered requirements from stakeholders and converted them to technical specifications
• Involved in planning of tool migration from Actuate to MicroStrategy
• Created MicroStrategy objects needed for reporting
• Designed and created datasets and dashboards using MicroStrategy.
• Configured the MicroStrategy web server
• Involved in Sprint management calls (agile development methodology)
• Studied the source OLTP sources to understand the data
• Interacted with the data modeling architects for advanced schema and project optimization
• Involved in designing a variety of KPIs required for managed network service activity
• Developed and implemented security roles, user groups, privileges and object security
• Involved in troubleshooting Microstrategy Web reports optimizing the SQL using Confidential properties
• Involved in preparing POC for Network traffic reports for Confidential

Environment: Microstrategy 8.1.1 product suite, Actuate eRDPro 8.0 Oracle 11g, Informatica Power Center 8.6.1, Solaris and Windows XP

Actuate Consultant

Confidential

Responsibilities:

• Designed and developed several sectional/parallel/group reports which depicted the network and utilization statistics of various BT products
• Coordinated with the global user community of Confidential to solve any technical issues
• Implemented several enhancements for various reports
• Conducted code reviews
• Implemented various performance improvement activities for the applications
• Key resource for planning and implementation of migrating Actuate 5 to Actuate 8
• Evaluated migration of reporting solutions from Actuate to MicroStrategy

Environment: Actuate 8/5, Oracle 9i, VisualBasic 6.0, MS IIS 6.0, HTML with ASPs, Unix, Citrix Server, PVCS, HPOpenView and Windows 2003 Server

Actuate Developer

Confidential

Responsibilities:

• Designed and developed spreadsheet reports using Actuate Suite
• Designed and created functionality in reports for generating CVS and XML files at runtime
• Modified a few JSPs to fix the issues reported in the portal using ActivePortal for JSP
• Modified the reports according to the new requirements
• Modified the libraries for the reports to get affected accordingly

Environment: Actuate 8.0, Oracle 9i, JSP and Windows NT/2000

Actuate Developer

Confidential

Responsibilities:

• Modified JSPs to fix the issues reported in the portal using ActivePortal
• Involved in creating the data model
• Responsible for design and implementation of complex reports
• Involved in the Actuate server administration including deploying reports, user roles and privileges
• Involved in the reviews, technical design and client discussions for enhancements

Environment: Actuate 8.0, Oracle 9i, JSP and Windows NT/2000

Actuate Developer

Confidential

Responsibilities:

• Responsible for design and implementation of reporting application
• Assigned issues to the team members raised by the client according to the priority
• Designed and created Ad-Hoc reports
• Responsible for designing data model for the reports
• Tested the reports and prepared the documentation for the report specifications and results.
• Responsible for scheduling the reports on the Actuate server
• Provided page level security for the reports
• Responsible for guiding stress testing the reports and prepared the documentation
• Actively involved in trouble-shooting and training users on Actuate usage

Environment: Actuate 6, SQL Server 2000, Forté Confidential, Visual SourceSafe, RationalRose and Windows NT/2000