SUMMARY

• Seasoned Business Intelligence and analytics consultant with more than 12 years experience.
• Expertise in Retail, Oil& gas drilling, and utilities.
• Experience working with C - level executives and collaborate with cross functional teams.
• Defined strategic roadmap for BI reporting and data ingestion at enterprise level.
• Experience in Dimensional modeling (Star / Snowflake), data profiling, and data analysis.
• Extensive design experience and environment recommendations on various BI
• And Datawarehouse platforms like MicroStrategy and Tableau, Teradata and defined and set standards and guidelines for BI reporting projects.
• Developed products Relogix as point solution for Confidential and presented in NRF 2012.
• Certifications in Microstrategy9.x and Teradata.
• Expertise in SQL performance tuning and reporting performance optimization.
• Experience in defining logical data model and semantic layer for self service reporting.
• 1+ year experience Data Science and analytics using R (with big data technology)
• Managed a team of 20+ consultants that include ( BI architects, developers, ETL architect, PM’s)
• Conducted numerous user demonstrations, architecture presentations and user training sessions.

TECHNICAL SKILLS

Database: Oracle 9i/10g/11g, SQL Server, Teradata, Netezza

Big Data: Hive, HBase, MapR (drill)

Data Visualization: MicroStrategy 8.x / 9.x/10.x, Tableau 8.x/9.x, Oracle BI

ETL Tools: DataStage 7.5, Informatica 8

SDLC: Agile Scrum, Waterfall

Functional Domain: Inventory and WH, Merchandising, Ecommerce, Customer analytics, Energy trading, Energy forecasting, Retail planning, Campaign analytics, GL Finance, Supply Chain, HR reporting, Store reporting, Smart metering

PROFESSIONAL EXPERIENCE

Confidential

BI Solution Architect

Responsibilities:

• Gather and document requirements working with business and executives for different projects.
• Designed dimensional modelling for store dashboard, ecommerce, Inventory and oversee BI architecture solution for all the projects.
• Also responsible for working with vendors to provide right BI environment architecture
• Developed and presented documents as required by Michaels SDLC process.
• Successfully architected Microstrategy semantic layer creating logical BI layer, Attributes, facts, hierarchies and transformations, intelligence cubes
• Designed and developed reports and dashboards
• Design and oversee Dimensional modelling, ETL implementation
• Worked with enterprise support team in setting up the cache handling strategy and emailing printed versions to executives using distribution manager.
• Defined specifications, sizing, oversight of policies, standards and procedures
• Status update to stakeholders, escalation and change management
• Developed reports, workbooks, Dashboards in both Microstrategy and Tableau
• Archived the data through files to MAPR poc system
• Created ODBC with drill, queried MapR through drill and configured and showcased visual insights reports on top of the data
• Currently working with Cloudera in setting up the BigData environment

Confidential

Technical Manager (Microstrategy 9.5/10.2, Oracle, Informatica, Hadoop, R)

Responsibilities:

• Collaborated with PMO/CIO/Director in developing road map, review project status
• Responsible for technical leadership in the design, development and execution of BI/DW-ETL.
• Owned and governed administration of BI /EDW/ environment i.e. security, performance, environment readiness, ownership of DEV/QA/Prod boxes with less than 2% downtime.
• Worked with infrastructure team in sizing and capacity planning
• Performed market analysis on emerging trends suggested solutions aligning with corporate goals.
• Optimized delivery with reduced staffing with 20% saving in support operations.
• Created and led BI architecture review group, setup data quality and governance with Sox compliance, Designed and reviewed dimensional modelling and was responsible for EDW / BI.
• MicroStrategy Report development, MicroStrategy Document/Dashboard, MicroStrategy Architect, MicroStrategy Administrator, ETL tool, Data modeling, and SQL.
• Successfully implemented 10 subject areas in 1 year (HR, FIN, SCM, and Service Quality KPI).
• Developed initiatives with business for advanced visualization -Baby steps on Hadoop.
• Implementing real time data integration for predictive analytics-Insights on failure/ maintenance.
• Developed Schema objects (Attributes, facts, and hierarchies), public objects, and Visual insights.
• Upgraded Microstrategy environment from 9.4 to 10.2

Confidential

Senior Manager BI (Microstrategy9.x, Teradata, Tableau8, OBIEE, Oracle)

Responsibilities:

• Collaborated with various teams in planning and Roadmap for tableau deployment.
• Setting up the environment and installations.
• Working with Tableau consultant in designing the security and project setup and users.
• Developing initial set of dashboards for system performance and BI DW health check in tableau
• Performance tuning on queries and views developed in teradata.
• Enable data visualization for Hadoop big data environment.
• Design and architect OLTP reporting for order and assortment planning and forecasting with BI Publisher on oracle which involved writing queries and views.
• This project helped in quarterly projections and planning for buyers and DMM
• Work with support team in getting the migration and resolving admin related challenges
• Managed project delivery from scope, estimation, planning and implementation

Confidential

Offshore Delivery Manager

Responsibilities:

• Provide solutions from design to development for various BI projects.
• Define and enforce best practices in using MicroStrategy.
• Recommendations for database performance enhancement.
• Work along with business to understand change requirements and assess the impact.
• Architecture of dashboards in MicroStrategy and performance tuning to meet the stringent SLA
• Numerous innovative solutions using in-memory cubes and multi panel dashboard refresh best practices were implemented to overcome the performance bottle necks.
• One of dashboards was presented in Microstrategy world as part of Confidential implementation award.

Confidential

BI Architect

Responsibilities:

• Actively work with product manager to define the KPIs and understand business impacts.
• Architect/Develop/Enhance semantic layer and reports in MicroStrategy projects to support various projects.
• Data modelling and schema design.
• Define governance for reporting environment.
• Design and Development of ETL jobs using Teradata ( BTEQ)
• Setup Microstrategy Mobile BI
• Coordinate with release team and application teams to handle intermediate production releases as defined by Gap agile process.
• Performance tuning of MicroStrategy reports

Confidential

DW/BI Architect and agile lead

Responsibilities:

• Design and development of logical data model and BI semantic layer.
• Effort estimation.
• Actively involved in the design and planning of ETL jobs.
• Architecture and implementation of dynamic security structure.
• Performance testing to determine required MicroStrategy server capacity for handling data volume of detailed reports.
• User training and coordination of user acceptance testing.