SUMMARY

• Experience in various Business Intelligence Tools like Microstrategy, Tableau, Cognos, Hyperion, OBIEE and Crystal Reports.
• Around 20 years of experience in customizing MicroStrategy and various Business intelligence tools.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Migrating BI applications from various BI Tools like Tableau, OBIEE, Hyperion and Crystal reports to Microstrategy.
• Sound knowledge of the Microstrategy tool suite MicroStrategy Desktop, Intelligence Server, Administrator, Architect, Web, Command manager, Object manager, Enterprise manager and Narrowcast Server.
• Manage the team of 6 developers and admin.
• Experience in creating Schema Objects (Attributes, Facts, Hierarchies, Transformations) and Public Objects (metrics, filters, prompts, Custom Groups, Consolidations, Templates) to develop Documents, Dashboards and reports.
• Have experience in ETL (Informatica) to move files from various sources to Data Warehouse.
• Performed adding activities like creating user, enable subscription, report security control, assign users to roles and groups.
• Adequate knowledge of Data Warehousing concepts (Star and Snowflake schema, ER Diagram, Multi Dimension model) and ability to understand and write complex SQL
• Proven ability to identify problem, analyze possible solutions and determine best course of action to meet objectives.
• Ability to work in environments with fluctuating priorities and deadlines, foresight to handle upcoming issues and dedication to solve complex problems with experience and research.
• A team player with excellent Interpersonal, Communication, and Presentation skills.
• Good knowledge in database development and expert in writing SQL Queries, Stored Procedures and Functions using SQL.
• Proficient in working with applications based on n - Tier Architecture.
• Experience in Financial Services, Travel and Federal Government Projects.
• Experience in working as Tech Lead/Manager and ability to mentor peers on Microstrategy and other business intelligence tools.
• Experience in both Waterfall and Agile Methodologies.
• Created prototype on AWS, Redshift and PostgreSQL.

TECHNICAL SKILLS

Software: Microsoft Office (Excel, Word, Power Point, and Access), Visio, Dreamweaver

Reporting Suites: MicroStrategy 7 to 10.4 Version, Cognos Power play, Upfront, Impromptu

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux

Languages: PL/SQL, SQL, HTML, Java, Java Script

Databases Environments: Oracle RDBMS V7, 8, 8i, 9i, and 10g, DB2 UDB, SQL Server, Access, Teradata, Redshift

Web Servers: Apache Web Server, Tomcat, WebLogic, Websphere

Tools: SQL*Plus, SQL*Loader, Toad, HTML, Quest Central, ERWIN, Teradata SQL Assistant.

Other: Excellent problem-solving, organization and leadership skills

PROFESSIONAL EXPERIENCE

Confidential, Delaware

Application Architect

Responsibilities:

• Involved in design activities of Dashboard and Report Development.
• Involved in requirement gathering reviews and Mockup review sessions.
• Attended the status meeting for MSTR and Business Intelligence team and with Business Users.
• Perform system development life cycle stages to meet business goals.
• Creation of Visual Insight Reports for adhoc reports as well as the requirements from the business users.
• Creation of adhoc. Reports in Tableau based on user inputs.
• Integrate the reports developed by other developer in the DEV environment from the developer’s own MicroStrategy environment.
• Prepare the migration list and involved in Migration activity to higher environment (VAL, INT and Prod).
• Creation and modification of Attributes, Facts, Hierarchies and Transformations as per the data model.
• Help the ETL team by validating the data load process and resolve the issues.
• Develop and maintain bash and SAS scripts in Development environment.
• Provide inputs to data modelling team for the model which satisfies the business need for MSTR Reporting.
• Analyze the DB log files for any production job failures and working with respective team to fix the issue.
• Update the project and timeline status to the Senior VP in continuous manner.

Environment: Microstrategy Suites 10.4.0 (MicroStrategy Developer, Architect, Desktop, Narrowcast Server, Object Manager, Tableau, Enterprise Manager, OLAP Services, Intelligence Server), SQL, Teradata, Linux, Teradata SQL Assistant, Autosys, Nexus, SAS Grid, PL/SQL

Confidential, Silver Spring

MSTR Architect /Tech Lead

Responsibilities:

• Participated in collection of business requirements from end users and transferring them as reporting requirements for MicroStrategy platform.
• Involved in design and development of US Weekly Scheduling Grid Document.
• Prepared the migration list and involved in Migration activity to higher environment (VAL, INT and Prod).
• Performed system development life cycle stages to meet business goals.
• Designed Prompts and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report
• Designed schema and public objects using Pass Through functions like ApplySimple, ApplyAgg, ApplyComparison etc.
• Generated custom groups, included consolidations in order to group attributes, and customized the report.
• Generated Report Services Documents and implemented MicroStrategy Reports by creating Projects, attributes, hierarchies, metrics, filters, and templates.
• Helping the team for any issues identified during the development cycle.
• Tested all the reports by running queries against the warehouse-using SQL Server Query builder. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Created complex queries and designed reports using basic requirements provided by internal customers.
• Conversion of reports from Tableau to Microstrategy.
• Fulfilled daily, weekly, monthly, and special internal customer requests for reporting and business metrics.
• Trained and supported users of MicroStrategy report suites, Microsoft Office and other software.

Environment: Microstrategy Suites (MicroStrategy Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, OLAP Services, Intelligence Server), SQL, Oracle 11g, Microsoft Windows Environment, IBM Rational RequisitePro, ServiceNow, Erwin Data Modeler, SQL Developer, Tableau, Unix, SAS Grid, AWS, Redshift

Confidential, BALTIMORE

Tech Lead/Developer

Responsibilities:

• Involved in the development of 10+ intelligent cubes for the dashboard development.
• Handling large database (300 fact tables and 400 dimension tables).
• Handle report/data access control to various user groups (users at DDS offices, users at regional offices, users at SSA HQ, etc.)
• Used MicroStrategy Subscriptions to deliver 25+ reports directly to business.
• Manage the MSTR team to deliver the reports on time.
• Integrated the reports developed by other developer in the DEV environment from the developer’s own MicroStrategy environment.
• Prepared the migration list and involved in Migration activity to higher environment (VAL, INT and Prod).
• Performed User Managament, Security Control and Access Management and email subscriptions.
• Attended various workgroup sessions in all IPTs. Involved in the impact analysis for the Change Requests for MI Beta requirements.
• Helping the team for any issues identified during the development cycle.
• Performed system development life cycle stages to meet business goals.
• Creation and modification of Attributes, Facts, Hierarchies and Transformations as per the data model.
• Analyze the time hierarchy in Hyperion Project and implement the solution in the project.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Templates and Dashboard using MicroStrategy Desktop.
• Attended the weekly status meeting for MSTR and MI team.
• Involved in requirement gathering reviews and Mockup review sessions.

Environment: Microstrategy Suites (MicroStrategy Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, OLAP Services, Intelligence Server), SQL, Oracle 11g, Microsoft Windows Environment, IBM Rational RequisitePro, HP Application Lifecycle management, Erwin Data Modeler, SAS Grid, Unix, SQL Developer, Hyperion

Confidential, PHOENIX

Onsite Senior Developer/Architect

Responsibilities:

• Design and develop 15 Dashboards, 30 Canned Reports, and 400+ microstrategy objects.
• Manage the database of 500 TB to handle the warehouse tables.
• Involved in development of 10 intelligent cubes.
• Manage more than 300+ internal users and 2000+ email subscription users.
• Migrating projects from different business intelligence tools like Cognos, Tableau into Microstrategy.
• Creating users, roles, groups and assign to all employees in the organization. Managed Email subscriptions using distribution services.
• Performed system development life cycle stages to meet business goals, increase revenue.
• Creation and modification of Attributes, Facts, Hierarchies and Transformations as per the data model.
• Analyzed data to identify trends, areas to improve efficiency, reduce costs, increase customer satisfaction.
• Automated manual data-related processes, allowing more analysis time, which led to better business decisions.
• Created Freeform SQL reports writing SQL queries for complex reports
• Used MicroStrategy Subscriptions to deliver reports directly to business.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy Desktop.
• Involved in troubleshooting of reports and eliminating cross-joins in the SQL.
• Identified and recommended scalable, effective solutions to business problems.
• Coordinated MIS related activities and initiatives across the region and between departments.
• Created complex queries and designed reports using basic requirements provided by internal customers.
• Fulfilled daily, weekly, monthly, and special internal customer requests for reporting and business metrics.
• Provided trending and analysis of premise, customer, and product information for other departments.
• Coordinated with department analysts to plan, design, test, and implement reporting solutions.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing, Thresholds and Report Optimization.
• Tested all the reports by running queries and with the MicroStrategy SQL engine generated queries.
• Trained and supported users of MicroStrategy report suites, Microsoft Office, billing system, and other software.

Environment: Java J2EE, MQSeries, IBM Websphere Mainframe, DB2, Unix, Linux, KeyNote, Oracle 9i, SQL, PLSQL, Microstrategy (MicroStrategy Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, OLAP Services, Project Manager, Intelligence Server), Tableau, Cognos Impromptu, Powerplay etc.

Confidential, Phoenix

Senior Microstrategy Developer/Architect

Responsibilities:

• Involved in the development of 15 reports, 6 dashboards, 200+ microstrategy objects and 5 intelligent cubes.
• Manage the DB of size 300 TB.
• Migrate the reports from OBIEE and Tableau to Microstrategy.
• Interacted with users extensively and gathered the requirements, and analyzed the reporting needs of the end users.
• Migrating the existing BI application from Tableau to Microstrategy.
• Used MicroStrategy Desktop in creating different Reports to meet the in-house Business Requirements.
• Implemented MicroStrategy Reports concepts by creating Projects, Attributes, Hierarchies, Facts, Metrics, Filters, and Templates using MicroStrategy Architect.
• Extensively used Filters, Facts, Consolidations, Transformations and Custom Groups to generate reports for Business analysis.
• Gone through various Levels of Dimensionalities to execute the reports with different result sets.
• Used Project Creation wizard for creating Facts and Attributes.
• Created Advance Metrics like non-aggregate, rank, Conditional etc. using different Conditional and Level settings.
• Created Complex Filters with advanced qualifications involving the 'Apply' functions like ApplySimple, ApplyAgg, and ApplyComparison etc.
• Created Complex reports for Analysis with Transformations, Consolidation, Custom Groups and Complex Filters.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Created Transformations for using in comparative reports like this year sales to last year sales.
• Created reports for sales and marketing with the drill up and down methodology in all options.
• Tested all the reports by running queries against the warehouse-using SQL Server Query builder. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Coordinate with the Quality Assurance team to plan and execute QA testing and resolve of any defects in project.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like Star Join, Query and Sub Query Optimizations.
• Writing PL/SQL procedures for processing business logic in the database. Tuning up SQL queries for better performance.

Environment: Java 1.4, J2EE, TEP, TBSM, Oracle 9i, Tomcat, DB2, Unix, Linux, KeyNote, Adlex, Microstrategy (Desktop, Narrowcast Server, Intelligence server, Object manager, Enterprise manager), Tableau, OBIEE and Informatica.

Confidential, Phoenix

Tech Lead/Architect

Responsibilities:

• Migration of BI projects from cognos to microstrategy.
• Participated in collection of business requirements from end users and transferring them as reporting requirements for MicroStrategy platform.
• Involved in Analysis of Business Requirements, Strategies to improve decision-making power for system users.
• Designed Prompts and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report
• Designed schema and public objects using Pass Through functions like ApplySimple, ApplyAgg, ApplyComparison etc.
• Generated custom groups, included consolidations in order to group attributes, and customized the report.
• Generated Report services Documents and implemented MicroStrategy Reports by creating Projects, attributes, hierarchies, metrics, filters, and templates.
• Developed Transformations to generate reports of type Sales this period to Sales this period Last Year and so on.
• Installed, upgraded and managed MicroStrategy 7.1.5 - 7.2.2 Intelligent and Web servers for development, test and production environments
• Defined and created facts, metrics, attributes, filters, prompts and consolidation objects in MicroStrategy
• Created and managed database connections to various data store.
• Created and managed users
• Created project plans for development of MicroStrategy projects
• Defined and created reports in MicroStrategy 7.1.5 for card member analysis and warehouse loading process
• Troubleshot and validated reports
• Performance tuned system
• Cognos PowerPlay and Impromptu
• Evaluated Cognos PowerPlay and Impromptu
• Administered server
• Developed 30 reports and 100+ microstrategy objects.

Environment: Java, J2EE, Oracle 9i, Tomcat, DB2, UNIX, Linux, Microstrategy, Cognos

Confidential

Senior Developer

Responsibilities:

• Performed system development life cycle stages to meet business goals, increase revenue.
• Creation and modification of Attributes, Facts, Hierarchies and Transformations as per the data model.
• Analyzed data to identify trends, areas to improve efficiency, reduce costs, increase customer satisfaction.
• Automated manual data-related processes, allowing more analysis time, which led to better business decisions.
• Created 10 Freeform SQL reports writing 25 SQL queries for complex reports.
• Used MicroStrategy Subscriptions to deliver reports directly to business.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy Desktop.
• Involved in troubleshooting of reports and eliminating cross-joins in the SQL.
• Identified and recommended scalable, effective solutions to business problems.
• Coordinated MIS related activities and initiatives across the region and between departments.
• Created complex queries and designed reports using basic requirements provided by internal customers.
• Solid working experience in customizing Micro Strategy
• Sound knowledge of the Micro Strategy tool suite
• Immense ability to design complex reports for Data marts
• Amazing ability to integrate Micro strategy into existing environments
• Uncommon ability to mentor and train peers on Micro strategy

Environment: Java, J2EE, Websphere, DB2, UNIX, Linux, Microstrategy Suite, PL/SQL.

Confidential, Detroit MI

Software Engineer/Oracle Developer

Responsibilities:

• Spearheaded transition from outdated views used to generate auto quote summaries, to highly functional and streamlined procedures, which could also generate any previous period's quote based on history tables.
• Incorporated IT solutions and developed scripts to calculate the quotes in accordance with the constantly changing contract terms and rebate business solutions.
• Created migration packages for maintaining records of previous quotes.
• Created queries, views and PL/SQL Procedures in Oracle database to calculate and extract quarterly quote calculations and exceptions for payment and reporting purposes.
• Updated tables to validate quotes using periods instead of calendar quarters and making provisions in the database to cater to functional change as the financial processes changed.
• Coordinated with Business Team, created processes to retrieve and store critical Data sales information for volume quote percentage calculation, and incorporated with existing business solution.
• Created summarization procedure, which determined total quote, paid over various runs, for each contract. This was developed for Finance's accrual purposes.
• Developed and provided solutions for changes required in quote calculation method.
• Developed quote calculation sheets in Excel for Finance verification and for testing program output for every quote period.
• Used procedures to verify and “cleanse” incoming sales transactions based on prime vendor discount percentages.
• Ensured that all IT Audit solutions and data adhered to FDA requirements.

Environment: PL/SQL; SQL; SQL*Plus; Oracle 8i & 9i, Sun Solaris UNIX; Windows XP; TOAD; Oracle Developer

System Analyst

Confidential

Responsibilities:

• Developed and maintained Oracle databases for all insurance products.
• Designed and created table, triggers, views and stored procedures in Oracle PL/SQL for accommodating new feature, at the same time maintaining referential integrity between tables.
• Analyzed, developed and maintained Oracle Reports for the Insurance System. (i.e. new configuration of product)
• Enhanced existing product table in Oracle to indicate rate override functionality so that rates for existing customer need not be obsoleted to make way for price revision.
• Configured insurance plans using SQL scripts and created UNIX Shell Scripts to run tests and process the bill amounts as well as to check for penalty charges, rate discount overrides.
• Created process workflows and use cases, standardizing the business processes.
• Assigned to be SPOC (single point of contact) for issues raised during Audit Checks and did follow-ups with various teams for closure.
• Investigated and resolved various production issues and performed data patches, reversals & extractions.
• Selected into Migration Team and performed system integration testing and UAT (User Acceptance Tests) on applications and developed Oracle PL/SQL scripts to conduct integrity checks on databases with converted data.
• Involved in data conversion (loading data from legacy systems to Oracle 9 database) activities and provided 24x7 support for mapping issues during Migration phase.

Environment: PL/SQL; SQL; SQL*Plus; Oracle 8i & 9i, Sun Solaris UNIX; Windows XP; TOAD; Oracle Developer

Systems Support Analyst

Confidential

Responsibilities:

• Supported production issues in oracle and rdbms databases. Solely responsible for server issues.
• Designed, developed, Enhanced and Scheduled processes in UNIX.
• Performed month-end runs for General Ledger and provided 24x7 supports for processes in different servers and for customers over Asia Pacific.
• Tracked all production calls using Remedy tool, resolved production issues in a timely manner, and prevented escalations.
• Conducted reversals, data patch, data recovery, extractions for users as well as generated financial reports posted on Intranet.
• Participated in company meetings for the vendor and performed application configurations.
• Tested, documented and maintained system enhancements.
• Provided knowledge transfer and training to new staff.

Environment: PL/SQL; SQL; SQL*Plus; Oracle 8i, Sun Solaris UNIX; Windows XP; TOAD; Oracle Developer