SUMMARY

• Senior professional with a distinguished 13+ year career leading the design and implementation of advanced data capture, integration, analysis, and reporting & analytics solutions to enhance decision - making. Skilled in partnering with business, leadership, teams and partners to identify needs, define strategy, and guide the delivery of tools, systems, interfaces and analytics to measure performance against goals, identify trends, and respond immediately to new opportunities or issues.
• Natural communicator and team leader with strong motivational skills and ability to produce and succeed.
• Proven ability to quickly grasp and apply new technologies and best practices.
• Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.
• Architect and oversee development for BI Solutions including data models, ETL packages, OLAP cubes, and reports.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy
• Lead design, development, and testing of BI solution based on specifications, sound development and testing methodologies, and best practices
• Experience in managing agile development process using Scrum methodology.
• Experience in managing the BI practice and designing enterprise-wide BI solutions in OLAP space.
• Accomplished Business Intelligence Lead and developed several innovative data mining methods to advance Analytics/BI reporting.
• Adept at generating custom reports, analyzing data and business planning.
• Planning and implementing the BI road map.
• 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
• 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.
• Producing project definitions to include validated functional requirements, scope, roles, responsibilities, budgets, timescales and resources.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy, Tableau, Microsoft Power BI, SSRS, Webfocus, Qlikview and OBIE

Data Modeling: Normalized, De-Normalized, Star and Snow Flake Schemas

ETL Tool: SQL Server Integration Services, Ab Initio, SSIS

Databases: Teradata, NetEzza, SQL Server

Internet Technologies: ASP, ASP.NET, XML/XSL, HTML, DHTMLQuality Assurance Tools Bugzilla, Jira, HP Quality Center

Programming Languages: VB.NET, C #, Java

Operating Systems Agile: Windows 32bit / 64 bit

Methodologies Scrum Tools: Scrum, Kanban Jira, Ice Scrum

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Scrum Master / BI Manager

Responsibilities:

• Business Intelligence document/report design and reviews.
• Implementing/suggesting suitable visualizations and best practices for analytical solutions and dashboards.
• Worked closely with the data modelling and data integration team to come up with efficient data models for the reporting environment.
• Guiding the users and team on best practices and performance standards for the BI environments
• Converting business requirements into dynamic dashboards and optimizing the existing dashboard performance.
• Train and mentor end users to become proficient with self-service analytics.
• Creating and managing relationships between tables and optimizing data models for better visualizations.
• Creating the strategy for data refresh and report/cube schedules.
• Planned and implemented the transformation of existing cubes to utilize the features of PRIME engine and cube partitioning.
• Worked with tool support team on product limitations and communicate limitations and tool capabilities to the IT and business stakeholders.
• Improved analytics solutions by integrating with data mining tools like R Analytics
• Providing continuous on-call production support for users.
• Actively involved in business planning for all departments.
• Conducted regular team meetings to utilize ideas and knowledge sharing sessions.
• Mentored the team and given regular feedback on improvements.
• Continuous liaising with stake holders and business users with the development progress and demos of deliverables and distributing the reports on project KPI’s.

Environment: Microstrategy 10.5,Vertica, Impala, Salesforce, R-Analytics

Confidential, Woonsocket, RI

Project Manager

Responsibilities:

• Review, Analysis, decoding of existing BI environment in Omnicare.
• Planning of KT activities of the existing BI environment and planned activities in phased manner.
• Estimations for the requirements study and designing from the existing system and allocating the team members.
• Planning the design strategy and review of design documents done by team members.
• Reviewing the design documents by translating the existing BI 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.
• Working the cross functional teams to source data from the existing db servers to new db servers.
• Analyzing the data security and designing the security strategy for the new BI solution.
• 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 models for the current reporting requirements.
• Communicate how the new BI solution aligns with client organization's business and strategic objectives
• Oversee development BI Solutions including data models, ETL packages, OLAP cubes, and reports utilizing Microsoft SQL BI Stack.
• 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.

Environment: Microstrategy, 9.4.1/10, Oracle 14, Webfocus, Qlikview, OBIE, Microstrategy

Confidential, Atlanta, GA

Project Lead

Responsibilities:

• Reviewing the existing BI platform and the data models implemented to analyze the gaps in the current Microstrategy architecture.
• 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 suite 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.

Environment: Microstrategy & Microstrategy 9.4.1/10, Tableau 8.x, Teradata 14, Control M.

Confidential, Hoffman Estates, IL

Microstrategy Architect/Project Lead

Responsibilities:

• 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 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

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

Confidential, Hoffman Estates, IL

Microstrategy Architect/Project Lead

Responsibilities:

• 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

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

Confidential, Hoffman Estates, IL

Project Lead/BI Architect

Responsibilities:

• 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

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

Confidential, Hoffman Estates, IL

Project Lead/BI Architect

Responsibilities:

• 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

Environment: Microstrategy Desktop 9.0.2, NetEzza, Tableau 7.xTeradata 14, Data Stage, Control M, DB2

Confidential, Hoffman Estates, IL

Project Lead/BI Architect

Responsibilities:

• 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, MSSQL 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

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

Confidential

Project Lead/BI Architect

Responsibilities:

• Requirement reviews and Data model reviews
• Developed Dashboards, Reports, assisted report developers, and participated in load testing exercise
• Setup and Managed 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

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

Confidential

MicroStrategy Designer & Architect

Responsibilities:

• 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

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

Confidential

MicroStrategy Admin & Designer

Responsibilities:

• 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.

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

Confidential

MicroStrategy Designer

Responsibilities:

• 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

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

Confidential

Microstrategy Developer

Responsibilities:

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

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

Confidential

Microstrategy Developer

Responsibilities:

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

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

Confidential

Crystal Reports Developer

Responsibilities:

• 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

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