Shravan Banda
Sacramento,CA
Summary
Close to 14 years of IT Experience in the Analysis, Design, Development, and Implementation of Relational Databases, OLTP AND OLAP Tools. Experience working in Analytics and Reporting have given strong understanding of both business objectives and technical capabilities. Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
Overview
14
14
years of professional experience
Work History
Sr. Business Intelligence Engineer
EviCore healthcare
12.2014 - Current
- Work with Business Users to determine goals and requirements for project and determine solution that fit their needs
- Gathered Business requirements and created use cases to support building of self-service tool for clients to access pharmacy sales data
- Established standards for object names, project layout, object promotions, and security model
- Built Enterprise Reporting on Authorizations, Claims and Membership data
- Worked on Creating several projects based on Authorizations, Membership, Compliance, PAC and Claims
- Using Agile process to create and modify reports, visual insights, dossiers, dashboards and cubes
- Worked with DBAs on performance issue and developing new data structures
- Responsible to convert Reporting Solutions from one BI platform to other
- Reports Conversion from Cognos to MicroStrategy
- Established Enterprise level Project
- Held role of key technical resource and project coordinator
- Was directly involved or leading all aspects of project including planning, developing, and validation testing
- Created scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using various functionalities
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
- Technologies Used – SQL Server, Microsoft Azure, SSRS, MicroStrategy, Cognos, Power BI and Tableau.
Sr. BI Lead Consultant
Momentum Consulting Corp
05.2014 - 12.2014
- Led cross functional team to review repeatable reports being delivered to clients resulting in 30% reduction in number of reports team created on regular basis
- Setup security Filters
- Production Support.
Sr. BI Lead Consultant
Franklin Templeton Investments
08.2013 - 05.2014
- Responsible for post Implementation FA Mart Project support
- Held role of key technical resource and project coordinator for upgrade of 600+ user environment
- Was directly involved or leading all aspects of project including planning, installing and upgrading, and validation testing
- Technical Issue Management - Analysis, Isolation, Diagnosis and resolution of reported technical platform or configuration issues
- End-User Application Privilege and Security Administration – addition of deletion of and change to user and group IDs
- Application and data security definitions
- BI Server Configuration Management – Planning and implementing growth and change to BI server infrastructure
- Precise tracking of current and future states
- Application Performance Management and Capacity Planning – Tracking of application usage and performance measurement histories
- Analysis, diagnosis and resolution of performance issues
- BI Application Deployment Management – Support to developers and project teams in release of applications and application change management
- Processing and logging of new capabilities as migrate from development to pre-production and from pre-production to production
- Daily Operations Monitoring and Management Introduced concept of Dashboard and Visual analysis to client
- Automated data load subscriptions
- Daily based update meetings with Team in California and India
- Technologies Used – Green plum, Oracle, SQL Server, SSRS and MicroStrategy.
Lead BI Consultant
High Impact Technologies, Inc.
02.2012 - 08.2013
- High Impact Technologies is committed to helping clients turn their volumes of data into actionable information
- It offers experienced resources for entire development lifecycle of business intelligence
- Here are few clients worked through High Impact Technologies Inc
- 1
- Adventist Health - Roseville, California Worked on building extensive Doctor Dashboards
- Effectively used data blending feature in Tableau
- Defined best practices in Business Intelligence Reporting Solutions
- 2
- Michael Kors - New York Responsible for Developing 8 Report Service Documents
- Mastered ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down functionalities
- 3
- Panda Express - Rosemead, California Responsible to connect ODBCs to new databases and test performance of SQL Server and Netezza.
- Used Integrity Manager to make some Performance Tests between 2 different databases
- 4
- Saddle Creek Corporation - Lakeland, Florida Gathered all upgrade requirements and documented all requirements
- Lead BI technical resource on large Windows server migration
- MicroStrategy upgrade to 9.2.1
- Held role of key technical resource and project coordinator for upgrade of 200+ User MicroStrategy environment
- Was directly involved or leading all aspects of project including planning, installing and upgrading, and validation testing
- Was also tasked with upgrading all client’s security module
- Fixed all Migration Errors reported from Users
- Technologies Used – MicroStrategy, Oracle, Netezza, SQL Server 2008, Tableau, SSRS.
BI Administrator/Developer
J. D. Power and Associates
01.2011 - 02.2012
- Responsible for Application Platform Installation, Administration and Report Development
- Responsible for maintaining and creating new users, providing access to objects and reports, password resets, as well as, including all connectivity to SQL Server/Oracle 11g database
- Client moved from ColdFusion Platform to MicroStrategy Platform
- Build reports on MicroStrategy and compared them with ColdFusion Reports
- Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and Application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create MicroStrategy objects necessary for deliverable
- Involved in creation of Advanced Metrics like Conditional, Level, Non-Aggregation, Rank and Transformation Metrics
- Designed Intelligence Cubes for better performance of dashboards
- Created different kind of Dashboards in both the interactive & flash mode
- Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations
- Migrated project into Testing and Production environments using Project Duplication Wizard
- Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls Lists
- Used Enterprise Manager to monitor activities
- Technologies Used - MicroStrategy, SQL Server 2008/Oracle 11g Database.
BI Developer
Ogilvy CommonHealth Worldwide
09.2010 - 01.2011
- Worked closely with Business Analysts and Financial Analysts to know requirements
- Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create MicroStrategy objects necessary for deliverable
- Involved in Data Modeling, data mart and OLAP for business analysis using star & snowflake schemas, for faster and effective querying
- Involved in creation of Advanced Metrics like Conditional, Level, Non-Aggregation, Rank and Transformation Metrics
- Improved report performance tuning SQL at all levels
- Created Data Mart reports based on specific requirements and running existing Data mart reports for weekly and monthly loads
- Created different kind of Dashboards in both the interactive & flash mode
- Created Ad-hoc reports by drilling up, down, within and across Hierarchies
- Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations
- Migrated project into Testing and Production environments using Project Duplication Wizard
- Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, access controls Lists
- Used Enterprise Manager to monitor activities
- Technologies Used - MicroStrategy, SQL Server, SSRS.
Education
MBA - Information Management Systems
Schiller International University
Largo, FL12.2009
Skills
- Project Management
- Project Planning
- Technical reporting
- Engineering Documentation
- Root Cause Analysis
Personal Information
Title: Business Intelligence Consultant
Timeline
Sr. Business Intelligence Engineer
EviCore healthcare
12.2014 - Current
Sr. BI Lead Consultant
Momentum Consulting Corp
05.2014 - 12.2014
Sr. BI Lead Consultant
Franklin Templeton Investments
08.2013 - 05.2014
Lead BI Consultant
High Impact Technologies, Inc.
02.2012 - 08.2013
BI Administrator/Developer
J. D. Power and Associates
01.2011 - 02.2012
BI Developer
Ogilvy CommonHealth Worldwide
09.2010 - 01.2011
MBA - Information Management Systems
Schiller International University
Similar Profiles
Talisha BusbyTalisha Busby
Intake at EviCore HealthcareIntake at EviCore Healthcare
Laquita PirtleLaquita Pirtle
Prior Authorization Specialist at Evicore HealthcarePrior Authorization Specialist at Evicore Healthcare
Tynia DavisTynia Davis
Client Service Representative at Evicore HealthcareClient Service Representative at Evicore Healthcare