SUMMARY:

• Senior BI professional with great amount of technical skills and a passion for resolving complex problems with 13+ years of IT experience in Business Intelligence and Analytics space.
• Experienced in heading Full Life - cycle BI projects right from requirements analysis, proof-of- concepts, design, development, administration testing and implementation in Microstrategy BI solutions
• Experience in managing agile development process using Scrum methodology.
• Experience in dimensional data modelling.
• Experience in working with Microstrategy Dossiers.
• Experience in managing the reporting practice and designing enterprise-wide BI solutions in OLAP space.
• Experience in using MicroStrategy Developer, Architect, Command Manager, Integrity Manager,; Narrowcast Server, mobile dashboards development and transaction enabled dashboards development.
• Extensive experience in retail, finance and digital advertising and pharma domains.
• Created mobile reporting solutions, Transaction Service enabled dashboards with write back feature
• Experience in tuning reports and schema objects for optimal performance.
• Led design presentations to product management team and solution architecture team
• Streamlined acquisition of reporting requirements and specifications to disseminate across multiple business lines and IT support teams
• Developed application framework that served as the cornerstone for a highly successful mobile and transaction based reporting and dashboard strategy
• Good understanding of basic customization using SDK.
• Developed and managed project plans while providing status updates to management
• Prepared technical architecture proposals for enhancements and integration of existing third-party database systems
• Ensuring that all milestones are achieved within the agreed timeframes.
• Ensuring effective quality control processes are in place to monitor deliverables produced.
• Responsible for identifying, analyzing, measuring and managing project risks.
• Conducting regular impact analysis in order to assess the consequences of the project deliverables on other sections of the business.
• Keeping accurate administrative records of expenditure, accounting, costing and billing.
• Good knowledge of News and Media domain.

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy 8/9/10.7, Tableau, Microsoft Power BI, SSRS, Webfocus, Qlikview and OBIE

Data Modeling: Normalized, Denormalized, Star and Snowflake Schemas

ETL Tool: Machine Learning

Big Data Technologies: SQL Server Integration Services, Ab Initio,Azure ML, Scikit-learn, Shogun, Accord.Net Framework, Apache Mahout, Spark mLib, GoLearn, Deeplearn.jsHadoop, HBase, Hive, Spark, Pig, Python

Databases: Teradata, Net Ezza, Azure SQL, KYVOS, SSAS SAP HANA

Web Technologies: ASP, ASP.NET, XML/XSL, HTML, DHTML, Node JS, Angular JS

Quality Assurance Tools: Bugzilla, Jira, HP Quality Center

Programming Languages: VB.NET, C #, Java, Python, Scala, Java

Scrum Tools: Scrum, Kanban,Jira, IceScrum

PROFESSIONAL EXPERIENCE:

Confidential,San Jose,CA

Senior BI Consultant/Architect

• Creating schema objects and public objects.
• Creating the design documents and reviewing the data models.
• Creating dashboards and Dossiers in Desktop and sharing with business users.
• Creating best practices to gather, model, manipulate and present data. Gather business requirements and translates business questions into requirements.
• Enable the business to concentrate on driving results, through access to centralized self-service reporting and metrics, supporting a one version of the truth environment.
• Developing transaction enabled documents to provide write-back feature.
• Developing and maintaining mobile dashboards.
• Migrations using the object manager and system manager.
• Working on enterprise manager reports to deliver the stats on various usage scenarios.
• Creating and scheduling cubes and optimising cubes for parallel processing and better data access.

Technical Environment: Microstrategy 10.7, SAP HANA, HADOOP, Kyvos, Collibra, Spark, Snaplogic

Confidential,Pasadena,CA

BI Consultant/Architect

Responsibilities:

• Business Intelligence document/report development, working with advanced visualizations and data from multiple data sources
• Developing Schema, reports and dashboards.
• Guiding the users and team on best practices and performance standards for the BI environments
• Developing Power BI dashboards from multiple data sources using Data Blending and multi sourcing.
• Converting business requirements into dynamic dashboards and optimizing the existing dashboard performance.
• Train and mentor end users to become proficient with self-service analytics.
• Working with upgradation, I server monitoring, package migration using System Manager.
• Updating existing cubes to utilize parallel processing and cube partitioning.
• Liaising with business users for requirements gathering, wireframe creation and providing UAT support.
• Creating and managing relationships between tables and optimizing data models for better visualizations.
• Setting up best practices for the self-service analysis setup
• I-server monitoring, usage statistics, user management, package migrations and working with MSTR upgrades.

Technical Environment: Microstrategy 10.5, Vertica, Impala, Salesforce.

Confidential,Woonsocket, RI

Reporting Project Lead

• Review, Analysis, decoding of existing BI environment in Omnicare.
• Planning the design strategy and review of design documents done by team members.
• Creating the re-design documents by translating the existing Webfocus/OBIE/Qlikview applications.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed dashboards with multiple panels and parameters that became a favorite sales tool for most of the business users.r
• Creating custom hierarchies
• R-integration
• Developed Dashboards and scorecards for YOY, YTD, QTD and MTD type of analysis
• Applying the best design practices to the project and reviewing the development.
• Creating the data model for the current reporting requirements.
• Architect and oversee development for MSTR BI Solutions including data models, ETL packages, OLAP cubes, and reports.
• Document source-to-target mappings, data dictionaries, and database design for BI solutions
• Lead design, development, and testing of BI solution based on specifications, sound development and testing methodologies, and best practices
• Providing the possible recommendations for data model structure and the existing ETL processes
• Tracking and sending the project status on weekly basis to the management.
• Performance tuning of reports.

Technical Environment: Microstrategy, 9.4.1/10.3, Oracle 14, Webfocus, Qlikview, OBIE, Hive, Hadoop

Confidential, Atlanta,GA

Project Lead

• Reviewing the existing BI platform and the data models implemented to analyze the gaps in the current Microstrategy architecture.
• Project planning estimation and team management of 10 resources
• Designing Microstrategy reports using OLAP features and cubes.
• Reviewing the design and suggesting best design practices to the project team
• Creating the data model which supports the Microstrategy reporting requirements.
• Planning and implementing the migration and creating Microstrategy security model
• Designing the Microstrategy transaction services models to suit the requirements and providing the POC’s
• Liaising with the business team, project team and users.
• Creating Microstrategy Schema objects.
• Reviewing and providing recommendations for the reports and schema/public objects.
• Providing the possible recommendations for data model structure and the existing ETL processes.
• Extensively worked on developing Microstrategy dynamic dashboards and mobile dashboards and Transaction service enabled documents which provides write-back feature.
• Tracking and sending the project status on weekly basis to the management.
• Strategizing post production support and performance tuning.

Technical Environment: Microstrategy 9.4.1/10, Tableau 8.x, Teradata 14, Control M, Machine Learning

Confidential,Hoffman Estates, IL

Microstrategy Architect / Project Lead

• Used Tableau Desktop to analyze and obtain insights into data sets
• Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines.
• Created MicroStrategy Transaction service enabled documents which provides write-back feature.
• Created visually compelling and actionable interactive MicroStrategy reports and dashboards
• Created MicroStrategy reports/dashboards having visibility of BU Heads
• Managed and optimized the datasets which connects to multiple data sources like Hadoop, Essbase Cubes, SQL Server, Mainframes and Teradata
• Designed the MicroStrategy Schema Objects and Maintained all the MicroStrategy Components
• Created automated schedules by which the users receive the updated MicroStrategy reports as soon as the data loads
• Involved & contributed to MicroStrategy architecture review board meetings
• Tuned MicroStrategy reports and schema objects for optimal performance
• Architected Schema and designed mobile dashboards for iPad & iPhone
• Maintained optimal performance of the MicroStrategy reporting application
• Monitored and evaluated team performance

Technical Environment: Microstrategy Desktop 9.3.1, Tableau 8.x/9.x, Teradata 14, Data Stage, Control M, Essbase Cubes, SQL Server, DB2, Salesforce, Excel & Flat files

Confidential, Hoffman Estates, IL

Microstrategy Architect / Project Lead

• Created visually intuitive dashboard using Tableau Desktop and published & scheduled on the server to share with large set of business users
• Trained the peers and business users in tableau visualization analytics
• Managed and optimized the datasets which connects to multiple data sources
• Created mobile reporting solutions, Transaction Service enabled dashboards documents.
• Tuned reports and schema objects for optimal performance
• Led the design presentations to product management team and solution architecture team
• Managed and resolved production issues escalated to the L4 level from support and other departments.
• Streamlined acquisition of reporting requirements and specifications to disseminate across multiple business lines and IT support teams
• Developed application framework that served as the cornerstone for a highly successful mobile and transaction based reporting and dashboard strategy.
• Developed and managed project plans while providing status updates to management
• Prepared technical architecture proposals for enhancements and integration of existing third party database systems
• Designed complex interfaces to support third party databases with reporting systems

Technical Environment: Microstrategy Desktop 9.3.1, Tableau 8.x Teradata 14, Data Stage, Control M

Confidential, Hoffman Estates, IL

Project Lead/BI Architect

• Participated and Contributed in the design and implementation issues of the Logical Data Model and Physical Data Warehouse
• Architected the Schema objects and designed Dashboards and reports for optimal performance
• Creating Design documents
• Integrating MicroStrategy Office and enabling the reports execution updates from MS Office and sending the reports to users and creating email subscriptions
• Conducting Design walkthrough sessions with ARB
• Validating Unit & System Tests
• Performed OLAP services and Freeform SQL reports for advanced analytics and Trend analysis reporting
• Design and implement the process and documentation standards

Technical Environment: Microstrategy Desktop 9.3.1, Tableau 8.x, NetEzza Teradata 14, Data Stage, Control M

Confidential,Hoffman Estates,IL

Project Lead/BI Architect

• Requirements analysis and detailed functional design for the various blocks identified within the application
• Detailed technical design for all the deliverables
• Schema Design and development
• Implementing Multi sourcing and dynamic sourcing
• Report UI design specification to be used for report creation and testing
• OLAP services & Intelligent cube design for advanced analytics and Trend analysis reporting
• Development of OLAP Cubes and Documents for advanced analytics
• Created buyers level Dashboards to analyze the sales and Balance of sales at FLS/Grands, Hometown, Outlet, Online, Kmart levels
• Created High Level metrics to analyze the customers shopping profile, Top Categories of purchase, Marketing Channels used to attract the customer, lifestyle information and the demographics information
• Created iBalance of Sales / Units by Location and Division, iJoliet Mygofer Summary, iWeekly Customer Scorecards to display on the iPad and iPhone

Technical Environment: Microstrategy Desktop 9.0.2, NetEzza, Tableau 7.x, Tera, data 14, Data Stage, Control M, DB2

Confidential, Hoffman Estates, IL

Project Lead/BI Architect

• System study and analysis of the application from various business owners
• Study of various interfaces, Custom built application data and data sources such as, NetEzza, Teradata, Hyperion Essbase, SAP BW, Oracle 9i, MS SQL Server, .csv and MS Excel
• Perform information systems needs assessment, information gathering and recommend appropriate business systems and IT infrastructure for the business user group
• Developed Schema, Public objects to implement the changes
• Report development of standard, Adhoc & Dashboard reports and certain drill through OLAP reports for advance analysis
• Extensive testing & validation of reports and SQL
• Coordinate with DBA to fine-tune the database with respect to reports thereby improving the query response time
• Contribute to knowledge capital by appropriate project documentation and best practice solutions

Technical Environment: Microstrategy Desktop 9.0.2,NetEzza,Tableau 7.x Teradata 13, Data Stage, Control M

Confidential, Hoffman Estates, IL

Project Lead/BI Architect

• Requirement reviews and Data model reviews
• Developed Dashboards, Reports, assisted report developers, and participated in load testing exercise
• Setup and Managed training sessions
• Provided best practices for MicroStrategy Implementation
• Facilitated report requirements sessions and documentation
• Prepared status report, Issues and risks
• Followed defined software development methodology
• Lead systems projects and technical problem solving

Technical Environment: Microstrategy Desktop 9.0.2,Tableau 7.x Teradata 14, Data Stage, Control M, SQL Server

Confidential

MicroStrategy Designer & Architect

• Developing dynamic, presentation quality dashboards and advanced reports
• Design, develop, implement, and support MicroStrategy reports and Schema
• Maintaining optimal performance of business intelligence application, performance monitoring, and tuning reports.
• Ownership of project schemas and all aspects of MicroStrategy Administration functions for projects, servers, user & security administration
• Providing technical support; troubleshooting report design
• Assisting report developers, and participation in load testing exercises
• Configure metadata and base reporting objects, tune report performance and troubleshoot reporting and data issues

Technical Environment: Microstrategy Desktop 9.0.2,Tableau 7.x Teradata 14, Data Stage, Control M, DB2

Confidential

MicroStrategy Admin & Designer

• Schema development
• Creating users/user groups and setting up user security.
• Upgrading the MicroStrategy from one version to another and also applying the hot fixes for that particular release
• Ownership of the project schemas
• Backup the Metadata on daily, weekly and monthly basis
• Migrating the MicroStrategy Project/Objects from Development to QA and then to production environment
• Development of project schemas based on dimensional models.
• Maintaining optimal performance of business intelligence application
• Supporting and fixing the production issues.

Technical Environment: Microstrategy 8.x, 7.x Desktop, Narrow Cast Server, Teradata V2R5, SQL Server 2000, DB2, Windows NT / 2000.

Confidential

MicroStrategy Designer

• Design of Schema Objects and creating Public Objects
• Creating performance summary analysis Reports
• Creating users/user groups and setting up user security
• Ownership of the project schemas
• Development of project schemas based on dimensional models
• Development of grid, graph, document and dashboard reports
• Interacting effectively with the stakeholders

Technical Environment: Microstrategy 8.x, Desktop, Teradata V2R4.1, SQL Server 2000, Windows 2000.

Confidential

Microstrategy Developer

• Creating Weekly and Monthly reports to measure the performance of the Stores
• Creating Dashboards for product level analysis
• Creating Store wise Over/short reports on daily and Weekly basis
• Creating Unit Scripts & Unit Testing
• Implementation and Supporting

Technical Environment: Microstrategy 8.x Desktop, Microstrategy Intelligence Server, Teradata V2R4.1, SQL Server 2000, DB2, Oracle 8i, Windows NT / 2000.

Confidential

Microstrategy Developer

• Creating Weekly and Monthly reports to measure the performance of the Stores
• Creating Dashboards for product level analysis
• Creating Store wise Over/short reports on daily and Weekly basis
• Creating Unit Scripts & Unit Testing
• Implementation and Supporting

Technical Environment: Microstrategy Desktop 8.x, Teradata V2R4.1, Windows NT / 2000.

Confidential

Crystal Reports Developer

• Involved in creating the SRS for ‘Master Reports Suite’ which included enhancements to existing Adhoc product
• Worked with team on customizing the out-of-box product to get look and feel of the application and abilities of Crystal Enterprise like exporting, previewing, printing and emailing the reports
• Documented the steps of installing and configuring the Crystal Enterprise for the networking department to build the servers when we have releases
• Stress tested the crystal enterprise servers to determine ideal configuration for the best performance
• Tested and implemented SMTP email and FTP scheduling feature of Crystal Enterprise
• Responsible to support the issues with reports on the crystal enterprise environments (Development, UAT, Test and Production )
• Supporting report request and modifications
• Creating and solving the IR’s within the Service levels

Technical Environment: Crystal Reports 8.x/9.x SQL Server 2000, Windows NT / 2000.