PROFESSIONAL SUMMARY:

• More than 9 years of IT experience with BI / Data warehousing Consulting, Design, Architect & Managing (Data Modeling, ETL, and Reporting) and Process Standardization
• Experience in Dimensional Data Modeling (Star and Snowflake Schemas)
• Experience in MicroStrategy Architect and Development to build Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment
• Sound knowledge of QlikView Script and Dashboard development
• Exploring Machine Learning and Data Science
• Worked extensively on MicroStrategy Desktop, Administrator, Intelligence Server and Web.
• Very strong experience in working with various reporting tools like MicroStrategy, Qlikview, Tableau
• Knowledge of other BI tools as well such as Power BI and Paxata
• Technically very strong in Data modeling, performance tuning, creating the complex reports and providing the solutions in all critical scenarios
• Skilled in managing ETL, Design and Architecture with ability to manage end - to-end delivery encompassing project management, architecture, consulting, gap analysis, data profiling, data modeling, Planning, effort & cost estimation in BI/DW space
• Hands-on experience in heading teams of BI/DW professionals at onsite and offshore centers.
• Demonstrated excellence in managing large development & delivery solutions in various BI platforms & technologies.
• Assisted the end users in UAT procedures and understanding the reports and the associated desktop/web-based applications.
• Assisted Business analysts and end users with understanding and clarifying business requirements vs. design issues.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models
• Provided complex Reports in MicroStrategy Desktop and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups.
• Expertise on Visual Insights
• Extensively worked on the intelligent cubes and created reports out of it.
• Experience in creating Custom Documents in MicroStrategy to combine the Data sets of multiple reports and also created Custom Dashboards.
• Knowledge and experience in development & deployment of reporting solutions on large volumes of Financial,, Sales & Marketing data using Crystal Reports/Business Objects and database querying using PL/SQL.
• Created interactive Dashboards in Qlikview using multiple graphs and used set analysis for interactivity control
• Created multiple Interactive Dashboards and Stories in Tableau
• Worked on POC to explore Power BI and Paxata

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy (9.3.1, 9.4.x, 10.4,10.11), Qlikview, Tableau, Power BI Big Data

Normalized, De: normalized, Star and Snowflake Schemas

MS: SQL Server, MySQL, Oracle, Mem SQL, Teradata

ML Tool: Spyder (Python 3.7)

PROFESSIONAL EXPERIENCE:

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Understanding business and technology needs
• Designing, analyzing and implementing efficient IT systems
• Gathering feedback from end users to continue improving systems
• Communicate with stakeholders to understand their requirements
• Develop and analyze functional specifications
• Design efficient IT systems to meet business and technology needs
• Integrate multiple systems and reconcile needs of different teams
• Gather feedback from end users about system performance
• Plan and oversee projects (e.g. upgrades, hardware/software installations)
• Provide advice and technical training
• Work with management to determine IT objectives that will improve business outcomes
• Leverage knowledge of cutting-edge technologies to optimize organizational efficiency
• Work as MicroStrategy Architect

Technologies: AWS Cloud, Lembda, Spark, S3, Tableau, Oracle Fusion, SalesForce Data Structure, Erwin, Dell Boomi

Confidential

Onsite Lead

Responsibilities:

• Responsible for LATAM region Reporting development and delivery
• Working as an Onsite Lead
• Working closely with the Business Analyst, Data modeling and ETL team for the new tasks or enhancements and make sure questions are answered for IFW and EAP report developments and implementations

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Responsible for all MicroStrategy Architecture & Development work across VIC project.
• Participate in meetings with business users/business analysts to discuss reporting requirements to handle complex business requirements in BI Reporting.
• Worked closely with the managers and business users to gather business requirements for the new tasks or enhancements and make sure questions are answered for MicroStrategy developments and implementations.
• Started with generating MicroStrategy objects Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy developer.
• Created Partition mappings by using MicroStrategy Architect to increase the performance.
• Created Transformations to use them to create Year-to-date, Month-to-date type metrics and also to create Prior Year Metrics.
• Created Roles, Privileges, Shared folders, Access controls Lists using security roles as a MicroStrategy administrator and developed sdk code to add the users into MicroStrategy roles to get the access to projects, reports, creating security filters for row level and column level.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
• Created Custom Documents in MicroStrategy to combine the Data sets of multiple reports and also created Dashboards.
• Interfaced with Sr. Management, providing reports, presentations, and recommendations covering the operational aspects of the BI system.
• Identifying risks and system needs, defining solutions and appropriate standards, establishing standards and procedures.
• Implemented row level and column security as per the requirements

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Responsible for all MicroStrategy Architecture & Development work across RMS project.
• Architectural and functional understanding of Business Intelligence information architecture, master data, data modeling and dimensions providing recommendations for standards on achieving maximum performance and efficiency of BI DW.
• Performing problem assessment, resolution and documentation for new and existing report objects using MicroStrategy schema modeling for the reporting layer.
• Started with generating MicroStrategy objects Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy developer.
• Created Partition mappings by using MicroStrategy Architect to increase the performance.
• Resolved cross joins in the SQL’s by modifying the attribute definitions to generate the accurate results.
• Created Transformations to use them to create Year-to-date, Month-to-date type metrics and also to create Prior Year Metrics.
• Created Roles, Privileges, Shared folders, Access controls Lists using security roles as a MicroStrategy administrator and developed sdk code to add the users into MicroStrategy roles to get the access to projects, reports, creating security filters for row level and column level.
• For complex reporting needs, worked extensively on creating Metrics and Compound
• Metrics, Filters, Custom Groups and Consolidations.
• Created Custom Documents in MicroStrategy to combine the Data sets of multiple reports and also created Dashboards.
• Interfaced with Sr. Management, providing reports, presentations, and recommendations covering the operational aspects of the BI system.
• Identifying risks and system needs, defining solutions and appropriate standards, establishing standards and procedures.
• Implemented row level and column security as per the requirements and also developed sdk code to create users and alter the security filters.
• Delivered several proofs of concepts and demo’s to Business users providing a clear and precise understanding of the product.
• Helped the team in integrating the reporting module with Java web application.

Confidential

Qlikview Developer

Responsibilities:

• D efined Qlikview Application Architecture
• Designed Data modeling
• Developed complex Qlikview scripts to build model, to support various KPIs and time comparison
• Designed and Developed interactive Qlikview Reports and Dashboards
• Used Set Analysis for Comparative Analysis
• Performance tuning of the script
• Implemented Security using Section Access

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Work closely with the Data Model team to develop the Dimension model as per the business needs and reporting needs
• Work with the database team closely to get the Implementation done
• Involved in data analysis
• Analyzed the complete data and created the semantic layer for MicroStrategy
• Designed the Schema layer for MicroStrategy
• Implemented MR code and Pig script to development component
• Used Scoop for data ingestion
• Created interactive Dashboard
• Carried out the testing of the reports
• Create views/Dashboard for the end Users and help business with suggesting/recommending different analysis
• Handle the team and get the solution delivered on time

Confidential

Business Analysis Senior Analyst

Responsibilities:

• Analyzed the Data Model and work with the team to enhance the model as per the business needs
• Worked with the database team closely to get the Implementation done
• Designed the semantic layer for Qlikview
• Worked closely with QA team for testing
• Implemented Data standardization
• Implemented data security using data encryption technique
• Followed best practices, documenting all the artifacts required as a part of SDLC
• Created views/Dashboard for the end Users and help business with suggesting/recommending different analysis
• Handled the team and get the solution delivered on time

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Analyzed the source data and the requirement document
• Analyzed the different unified platform - spend analytics, sourcing, contract management, supplier management, P2P
• Worked with the database team to restructure Table and data as per the report requirement
• Played a role of MSTR Lead. Handled 2 associates under me.
• Worked on User Management
• Implemented Subtotals
• Created Microstrategy Schema objects like facts, attributes
• Created Microstrategy Application objects such as Metrics, Filters, Autostyle, Drill Maps, Custom Group
• Worked with SDK team
• Worked on VLDB settings
• Created Prompt in Prompt reports
• Created interactive dashboards
• Created RSD’s with different layouts
• Created different POC’s to achieve task not provided by MicroStrategy out of the box
• Followed Scrum of 2 weeks
• Created dashboards for Mobile
• Worked on MicroStrategy WEB

Confidential

MicroStrategy Architect and Developer

Responsibilities:

• Analyzed the source data and the requirement document
• Analyzed the different Business processes
• Created BusMetric document to identify the Facts and the formula to create Metric from Report requirement document
• Analyzed the source tables using SQL and different relationship between them
• Created Microstrategy Schema objects like facts, attributes, hierarchies
• Created Microstrategy Application objects such as Metrics, Filters, Autostyle, Drill Maps, Custom Group and Consolidation
• Created Compound Attributes, Smart Metrics
• Created Prompts to give user a choice to see reports based on different filter condition
• Formatted reports using threshold, banding and applied various auto styles
• Cross-Checked the report result with the custom SQL result