SUMMARY:

• Over 12+ years of IT experience in software development, design and implementing with major focus on Business Intelligence tools, Data Warehousing and Database Applications in retail, mobile and finance companies.
• Strong experience using MicroStrategy product suites including MicroStrategy Desktop, Web, Architect, MicroStrategy Intelligence Server, and Narrowcast server.
• Hands - on experience in data warehouse/business intelligence report development ideally with MicroStrategy, Experience working in a production environment with change management, defect tracking and status reporting processes.
• Good experience with BOXI, Microsoft SQL server, Oracle, Microsoft Office tools along with Project & Visio.
• Extensively worked in creating and integrating MicroStrategy reports, and objects like Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups with the data warehouse.
• Implemented proactive delivery reports as HTML, email, SMS etc., and implemented the business intelligence solutions using MicroStrategy Narrowcast Server.
• Extensive experience in creation of Dashboards and scorecards allows understanding of the Business trends.
• Extensive work experience with Ad hoc reporting using SQL queries and standard reporting environment.
• Experience in Designing Data Marts using different Multi-dimensional modeling techniques such as Star Schema and Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modeling.
• System Optimization, performance monitoring and tuning experience in the BI application.
• Migrated and created multiple interactive dashboards in Tableau Desktop.
• Published multiple workbooks on tableau online, by providing required region wise security to users.
• Created required live or extract connections to database, created various tableau objects like calculated fields, sets, groups and parameters using tableau desktop.
• Good exposure to client interaction, user-requirement analysis and User support.
• Excellent team player with good interpersonal skills. Excellent communication and documentation skills.
• Excellent multitasking capability, good mentoring and training skills, advise development teams on effective procedure, can efficiently plan and prioritize projects with strong technical and business management skills.

TECHNICAL EXPERTISE:

BI Tools: Microstrategy 8.x - 11.x, Microstrategy Desktop, Microstrategy Architect, Microstrategy Web, Microstrategy Intelligent Server, Microstrategy OLAP Services, Microstrategy Narrowcast server, Microsoft BI, Business objects,Tableau Desktop,Tableau Online, Tableau server

ETL tools: Informatica Power Center 9.1,BOXI,Hadoop.

Databases: Oracle 11/10g/9i, Microsoft SQL Server, IBM Data studio 4.1.3

Languages: SQL, Unix/Shell Scripting

Operating Systems: UNIX, Linux, Windows 7/Vista/XP

Web technologies: HTML, DHTML, CSS, XML

Methodologies: SDLC, Agile and Scrum Development

WORK EXPERIENCE:

Confidential, Columbus, Ohio

Snr Developer (MicroStrategy/Tableau)

Responsibilities:

• Involve in all the phases of new projects under MicroStrategy BI at Huntington, gather requirements, design, develop and perform unit testing and provide UAT support, then deploy projects on production environment by following the Agile methodology here.
• Involve in dimensional data modeling, create logical tables or views, Business Intelligence schema and public objects.
• Write specs that meet MicroStrategy BI Adhoc reporting needs.
• Conduct analysis, design products and provide solutions to the team for metrics and analytical information with the technical reporting expertise, data capture level and leveraging dashboard features in the tool.
• Actively involve from the inception through the design and development phases, led the team in the right path
• To provide best solutions. Written spec documents, design documents for the project. Participate in the requirement gathering and conduct detail data analysis of the backend tables, work closely with the SQL server database team to review data models and ensure model meets the needs and for any changes.
• Develop complex datasets, dashboards with latest cube blending approach, to source data from multiple cubes that will allow data breakdown allowing better cube memory management on the I-server.
• Develop required objects creation scripts and execute in MicroStrategy Command manager to create bulk objects.
• Design MicroStrategy Schema, hierarchies, expression-based transformations, complex filters and other application objects to develop trending reports.
• Develop sets, filters calculation fields or parameters required for tableau requirements.
• Develop dashboards, Adhoc wizards, Dossiers, reports based upon users request either on Tableau or MicroStrategy.
• Develop required security filters and LDAP group’s configuration, create the user group users, provide access to projects and configure object level security for the user/user groups as per user lists in all working environments.
• Report performance tuning, SQL optimization at different levels for keeping the execution times below the threshold values. Monitoring and scheduling intelligent cubes to deliver the reports based on data loads.
• Perform detail unit testing, data testing, writing SQL queries to ensure reporting data matching with the application tool, support user in resolving issues during test phases, and the test results documentation.
• Migrate the code developed on other environments like Dev, QA or Preprod.
• Provide user trainings, set up several sessions for bringing up to speed the users to create their own reports.
• Provide user training on technical aspects of the new tool and support the defect tracking and resolution over the product testing phases.
• Provide support on user acceptance testing resolve the issues raised by users and deploy the project in production environment on time, then support application on production environment.

Environment: MicroStrategy Desktop 11.1, MicroStrategy Command Manager, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Tableau Desktop, Tableau Online, Tableau server, Microsoft SQL Server 2017, Windows 7, IBM Data studio 4.1.3.

Confidential, Overland Park, Kansas

Sr. MicroStrategy Developer /Architect

Responsibilities:

• Conduct analysis, design products and provide solutions to the team for metrics and analytical information with the technical reporting expertise, data capture level and leveraging dashboard features in the tool.
• Actively involved from the inception through the design and development phases, led the team in the right path to provide best solutions. Written spec documents, design documents for the project.
• Participate in the requirement gathering and conduct detail data analysis of the backend tables, work closely with the Oracle database team to review data models and ensure model meets the needs and for any changes.
• Developed complex dashboards with latest cube blending approach, to source data from multiple cubes that will allow data breakdown allowing better cube memory management on the I-server. Develop scripts to execute in CM.
• Design MicroStrategy Schema, hierarchies, expression-based transformations, complex filters and other application objects to develop trending reports.
• Develop mobile dashboards for the Finance users and resolve various iPad related issues.
• Design UI/UX dashboard prototypes as per requirements using Adobe XD tool, upon users’ approvals I have developed dashboards on MicroStrategy.
• I Perform SQL query on Hive, to obtain specific set of data and import as in-memory cubes, allow users to create dynamic self-service reporting using in built MicroStrategy visualizations.
• Developed security filters and LDAP groups configuration, create the user group/users, provide access to projects and configure object level security for the user/user groups as per user lists in all working environments.
• Extensive Report performance tuning, SQL optimization at different levels for keeping the execution times below the threshold values. Monitoring and scheduling intelligent cubes to deliver the reports based on data loads.
• Perform detail data testing, writing SQL queries to ensure reporting data matching with the application tool, support user resolving issues during test phases, and the test results documentation.
• Provide User trainings, set up several sessions for bringing up to speed the users to create their own reports.
• Lead the team and help them resolve the issues by workaround solutions.

Environment: MicroStrategy Desktop 10.2, 10.4, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Oracle SQL Developer, Hadoop, Autosys, Windows 7, Linux

Confidential, Rye, NY

Sr. Developer /Lead (Micro Strategy/Tableau)

Responsibilities:

• Support multiple projects and Interact with multiple business users to analyze the requirement and leverage BI tool capabilities to deliver the features in the best visual display format using widgets and Microstrategy Visualizations.
• Understand the data in the warehouse tables and their dimensionality, discuss with ETL and Data modeling team and design the needs of reporting model as per requirement, designed dimensional data modeling.
• Design Schema and Public objects involving complex metrics calculations for performance and target metrics.
• Performance tuning, SQL optimization, scheduling intelligent cubes to deliver the reports in efficient way.
• Created Facts, Attributes and Hierarchies using the Micro Strategy Architect.
• Optimizing the Performance of Micro Strategy Reports and Dashboards.
• Developed various Metrics, filters, consolidations, custom groups, derived elements and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Knowledge of complete SDLC methodologies around major upgrades, new implementations and mapping to requirements.
• Develop and define test strategy and test plans based on product requirements and functional specifications.
• Worked as team lead for the development team and lead 15 people.
• Created PowerPoint PPT’s using Micro Strategy Office to enable reports handy in the required format.
• Provided report wizards to enable ad-hoc reporting for end users, which would make decision makers life easier and provides the flexibility to generate need-based reports.
• Involved in creating various transformations to analyze different metric values across years and specific campaign conversions using Micro Strategy Architect.
• Migrated key dashboards and Reports from MicroStrategy to Tableau.
• Created dashboards connecting to Oracle database with Live and Extract tableau desktop.
• Created required parameters, sets groups and calculated fields as per the requirement using tableau desktop.
• Published key dashboards to Tableau online so that Major users can view their sales and gross Margin reports region wise.
• Design and develop Business Intelligence Reports using Micro Strategy.
• Involved in administrator tasks like setting up user security, managing projects providing usage reports, clustering multiple servers and scheduling jobs etc.

Environment: MicroStrategy Desktop 9.4/10, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Tableau Desktop, Tableau Online, Tableau server, Oracle, informatica, Windows 7

Confidential, RYE, NY

Sr. Developer /Lead(MicroStrategy/Tableau)

Responsibilities:

• Involve in dimensional data modeling, create views, Business Intelligence schema and public objects
• Write specs that meet MSTR BI ad-hoc reporting needs.
• Provide user training on technical aspects of the new tool and support the defect tracking and resolution over the product testing phases.
• Develop MicroStrategy Schema and Public Objects, develop complex security filters and user groups to support data level and object level security.
• Developed various Metrics, filters, consolidations, custom groups, derived elements and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Involved in data modeling to create attribute relationships and schema.
• Knowledge of complete SDLC methodologies around major upgrades, new implementations and mapping to requirements.
• Migrated reports and Dashboards to Tableau with discrete and continuous views.
• Developed few key dashboards in Tableau desktop, created required parameters, LODs, sets, groups and calculated fields as per requirement.
• Published the workbooks on tableau online providing region wise security .
• Worked as team lead for the development team and lead 5 people.
• Created PowerPoint PPT’s using Micro Strategy Office to enable reports handy in the required format.
• Develop and define test strategy and test plans based on product requirements and functional specifications.

Environment: MicroStrategy Desktop 9.3/9.4, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Tableau Desktop, Tableau Online, Tableau server, SQL developer for Oracle 11i, Informatica, Windows 7.

Confidential

Sr. MicroStrategy Developer /Lead

Responsibilities:

• Involved in implementing the star and snowflake schema's to fit reporting, querying and business requirements analysis.
• Involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users.
• Have developed the reports using Business Objects Web Intelligence XIR2.
• Build the universe and created the Custom Hierarchies as per the accesses defined by the Customer.
• Migrated the entire reports and universe from one platform to other platform (i.e. from SQL Server 2000 to Oracle 10g) without any discrepancies in the Reports and Universe.
• Responsibility of timely and efficient delivery of phased modules.
• Has provided production support in the form of assisting users in using the tool and also responding to their queries.

Environment: Control - M, Business Objects XIR2 and SQL Server, Windows 7

Confidential

Reporting Developer

Responsibilities:

• Proposed best solutions that fit the business leveraging the features and capabilities of Business objects to great extent and with finest performance tuning at the required level.
• Interact with the clients on regular basis identify the KPIs, code and test with quality data. Involve in data modeling, actively participated in design reviews from the inception and finalize on the models.
• Created reports, documents and dashboards in Flash/interactive modes, used Complex Filters, Compound Metrics and Prompts.
• Creation of universe by analyzing the Data Model using Business Objects XI R2 Universe designer
• Have developed the Headcount, Recruitment and the Attrition reports in the BO framework.
• Involved in finding out the data fields based on the requirements and built the Universe for Headcount, Recruitment and Attrition reports.
• Defined the Universe level user access restrictions based on the accesses defined by the Customer.
• Reports Creation using Business Objects Web Intelligence XIR2 to represent data with all possible combinations of subjects using Drill downs & Roll Up possibilities both at the universe level and the report level.
• Extracting, Transforming and Loading the Data through SQL Server 2000 Scripts and Routines.
• Involved in migration and development of new MicroStrategy reports from BO framework.

Environment: MicroStrategy Desktop 9.2.1, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Control - M, Business Objects XIR2 and SQL Server, Windows 7.