Ravi Lochan Kallur
VA
Summary
Dynamic IT professional with over 17 years of leadership and hands-on experience in the full SDLC of Business Intelligence, Data Analytics, and Reporting solutions. Specializes in the MicroStrategy product suite and adept at utilizing Scaled Agile, Waterfall, and iterative methodologies to drive successful project completions across complex data systems and diverse business domains. Proven expertise in leading technical teams, managing projects, and implementing end-to-end Data Warehousing solutions while fostering collaboration among cross-functional teams. Committed to delivering high-quality results through effective time management, problem-solving skills, and a proactive approach to meeting team objectives.
Overview
18
18
years of professional experience
Work History
Agile Development Senior
Freddie Mac
03.2023 - Current
- Lead implementations for multiple Modernization efforts – Database upgrade and Cloud migration of On-prem technology setup including Microstrategy Cloud Enterprise.
- Responsible for maintenance and monitoring of automated deployment process using CI/CD pipelines, managing code artifacts and repositories.
- Created and migrated deployment packages and peer reviewed - maintained versions using Git and Bitbucket to support automated deployment process.
- Collaborated with cross functional teams of data scientists, quality assurance teams and business stake holders to prioritize tasks efficiently.
- Responsible for maintaining the resilience and reliability of the applications through execution of continuous testing and monitoring strategy.
- Worked on revamp of the Servicer Success Scorecards, Manager Series solutions incompliance with Government regulations and ongoing changes made to the performance metrics, KPIs.
- Directly worked with business users as release engineer to manage smooth hand of UAT to Prod migration of the report changes and effectively communicated.
- Worked with ETL Developers and Business Analysts to integrate changes in accordance with changes to the business requirements to make sure the integrity of product delivery.
- Conducted Root Cause Analysis and Data Analysis approach for handling erroneous jobs and setup processes for product improvement and contributing to future tool enhancements.
- Extensively worked on Interactive Dashboard and Document Design for internal and external user groups, helped audit teams and business teams for assurance of data integrity and methodology walkthrough.
- Agile Development Senior. Environment: MicroStrategy One, 11.x, Snowflake, Vertica, Windows 11, Microsoft Professional Product suite.
MicroStrategy Consultant
GSA/REI Systems
12.2016 - 03.2023
- Leading the efforts of upgrading Federal Acquisition Services, Federal Business Opportunities reports as part of SAM.Gov modernization and other Integrated Award Environment system reports using MicroStrategy Analytics.
- Successfully completed development and migration of Federal Procurement Data System – Reporting system and Business Intelligence Adhoc system from legacy tools into Microstrategy Platform.
- Integrated multiple Reporting domains for Data Bank under SAM.gov, including development of new custom reports and modernized, standardized, duplicated existing reports.
- Successfully integrated MicroStrategy Platform with Spark SQL, leveraging the power of in-memory cluster computing to run analytics against Hadoop and other big data sources.
- Involved extensively in troubleshooting, defect triage, operations and production support of existing analytics platform and resolving outstanding issues.
- Designed and developed Schema objects, defined relationships, maintained the schematic layer and worked on Performance tuning of reports, optimizing the SQL using the VLDB Properties.
- Identified key metrics in data and helped Analysts by creating reporting solutions with complex calculations using advanced metrics and filter definitions.
- Worked on user profile creation, setting up user level and object level security and scheduling cube build, sharing and delivery of reports periodically.
- Created best practices, standard operating procedures and technical documentation needed for the installation, monitoring and maintenance of MicroStrategy application programs.
- Extensively worked on Interactive Dashboard and Document Design for Integrated Award Environment Management and officials to address qualitative and quantitative KPIs of business.
- Extensively participated and successfully implemented several projects and demonstrated Agile and SAFe (Scaled Agile Framework) principles and methodologies in data driven technical solutions.
- Conducted daily Scrum meetings, team backlog grooming sessions and Product Increment planning meetings, participated in incremental development demos to end users.
- MicroStrategy Consultant. Environment: MicroStrategy 2019, 11.x, 10.x, Amazon Redshift, PostgreSQL, Windows 10 Professional, iOS.
MicroStrategy Developer
Freddie Mac
09.2015 - 12.2016
- Successfully developed and migrated strategic performance, servicer portfolio scorecards supporting the Business Unit head for a secondary mortgage industry leading client.
- Design and develop data warehouse projects and data marts, model and create MicroStrategy projects, logical data marts and table structures and define attributes, dimensions, hierarchies and metrics.
- Involved in different phases of MicroStrategy Upgrade from version 9.5 to 10.2 and planned UAT phase.
- Develop and maintain the reporting solutions for the multiple releases and deployment between enterprise environments.
- Successful demonstration of integration of Agile methodologies and data analytics implementation using core concepts of agile principles and data warehousing development cycles.
- Perform problem assessment, resolution, coordinate and perform data quality validation on new and existing reports providing design and testing documentation.
- Participate in requirements gathering and design for ongoing development projects rigorously involved with both technical and business personnel understanding the bottlenecks in both areas to provide solutions.
- Assisting users in the creation of ad hoc data warehouse queries as needed and support answering potential audit questions and created artifacts for validation.
- Used agile test methods to provide rapid feedback to the developers significantly helping them uncover important risks while requirement gathering and development phase.
- MicroStrategy Developer. Environment: MicroStrategy 9.5.1, MSTR 10.2, Informatica 9.6, MS Office 2010, Windows 7 Professional.
Lead BI Consultant
RaceTrac Petroleum
05.2014 - 09.2015
- Leading a team of ETL and BI developers, managing project delivery and release migrations through standard lifecycle development while ensuring highest quality design and delivery of projects with required scope.
- Manage Datawarehouse and Business Intelligence Projects for the client as an implementation partner and coordinating Onsite- Offshore teams.
- Design and development of end to end data flow through Informatica Workflows and architecting Business Intelligence Analytical reporting solutions through MicroStrategy Intelligent Cubes.
- Handled several migrations of report objects between different Project layers, clustered environments and also extensively worked on production support.
- Rigorously involved in various Business units within company to gather requirements and translate business needs into long-term information architecture solution via BI Platform.
- Integrated different business domains to combine different data sources to create an MDM system to support enterprise data warehouse and enterprise level data analytical solutions for various business units with in.
- Responsible for successful testing and implementation of MicroStrategy upgrade from 9.3 versions to 9.41. and Informatica from 9.1 to 9.6.1.
- Worked on complete data warehouse implementations, review and successful migration of code evaluate and reusability of current data for additional analysis.
- Involved in project planning of an agile environment for setting up goals, user stories, test plans, testing, debugging, modification and support for MicroStrategy business intelligence system.
- Provided advanced technical troubleshooting for MicroStrategy reporting platforms emphasis on root cause analysis including data issues and SQL validation and performance tuning techniques.
- Extensively involved architecting schema objects, builds grids, graphs, report objects, advanced metrics and interactive dashboards.
- Lead BI Consultant. Environment: MicroStrategy 9.4.1; 9.3.1, SQL Server 2012, SQL Server Management Studio, Informatica 9.x, Cognos Decision Stream, MS Office 2010, Windows 7 Professional, iOS.
MicroStrategy Technical Lead
QVC
06.2013 - 04.2014
- Effectively participated in Agile methodologies along with cross functional teams and successfully demonstrated multitasking capabilities by involving in multiple projects.
- Involved in complete SDLC of report development and delivered BI Solutions for different end user groups coordinating between business and IT simultaneously.
- Implemented constantly evolving data model changes in MicroStrategy to adopt new reporting needs by creating specific data views when required.
- Worked extensively with ETL team to understand the schema and warehouse changes to provide inputs for reporting needs per the client requirements.
- Defined Schema Objects and extensively involved in design and development of Attributes, Facts and Hierarchies and created logical views for complex reporting purposes.
- Refactored and redesigned adaptive metrics according to the changing data definitions per client requirements and extensively involved in retesting the new design.
- Created Database Instances for different projects and change VLDB property for migration into Netezza.
- Involved in meetings with Business units to understand the requirements, translated them into MSTR design documents and requirement documents.
- Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop that can be re-used to build any number of metrics.
- Proposed and implemented changes to existing reporting templates according to the data changes for enhancements and new releases.
- Handled the delivery of the workbooks to the Business depending on the load schedules on a Weekly, BI-weekly and Monthly Basis.
- Involved extensively in troubleshooting, production support and resolving outstanding issues.
- MicroStrategy Technical Lead. Environment: MicroStrategy 9.3.1, Netezza, Aginity for Netezza, Oracle 11g, Informatica 9.1, MS Office 2010, Windows 7 Professional.
MicroStrategy Architect/Developer
Lockheed Martin
01.2013 - 05.2013
- Extensively worked with Business team to understand the requirements and prepared design specification documents accordingly.
- Proposed and implemented changes to existing reporting templates according to the data changes for enhancements and new releases.
- Worked with Data Warehouse Architect in the development of the dimensional and logical data models.
- Involved in logical and physical database schema design, SQL tuning, and SQL/PLSQL programming knowledge and mapping business objects into database objects.
- Created complex report service documents involving large number of data sets calculated at different levels of aggregation.
- Designed dynamic Dashboards using MicroStrategy Report services to address constantly changing user data needs.
- Customized new and existing reports, Documents and deployed them between Development, testing, production environments along with MicroStrategy web.
- Created Static and Dynamic Dashboards, scorecards and documents using various out of the box widgets based on the requirement.
- Involved in complete SDLC of new enhancements and source releases from gathering requirements through creating reports.
- Effectively used Quality Center for defect tracking and future reference for design changes and interacted with testing team to itemize testing objectives.
- MicroStrategy Architect/Developer. Environment: MicroStrategy 9x, Oracle 11g, MS Office 2010, Windows XP Professional, Vista Professional.
MicroStrategy Consultant
HSBC
09.2012 - 01.2013
- Involved in design, development and implementation of financial stress testing, planning application using TM1 for Capital Analysis.
- Assisting BI Data Warehouse Architect in the development of the dimensional and logical data models.
- Involved in logical and physical database schema design, SQL tuning, and SQL/PLSQL programming knowledge and mapping business objects into database objects.
- Preparing MicroStrategy development estimation for schema and application objects.
- Designing dynamic Dashboards using MicroStrategy Report services.
- Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
- Design and creation of reports transformation and derived metrics filter objects prompts drill maps user hierarchies, dynamic custom groups consolidations.
- Worked with DBA's to tune SQL generated by MicroStrategy reports and to collect DB statistics and in creation of additional indexes if necessary Designed dynamic dashboards for easy data magnification.
- Extensively used filters, prompts, metrics, consolidations and custom groups to generate reports.
- Communicated with the business, Data Modeling team and ETL team in various levels for the stabilization of the reports.
- MicroStrategy Consultant. Environment: MicroStrategy 9.2.1, Netezza, Oracle 11g, MS Office 2010, Windows XP Professional.
MicroStrategy Consultant
Quintiles
10.2011 - 08.2012
- Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
- Worked with data architect to design and build MicroStrategy schema.
- Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.
- Provided the users the facility to create customized reports for Business Analysis by creating Hierarchical filter prompts Attribute filter prompts Attribute.
- Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
- Metric prompts templates and drill downs. The end users were able to generate ad-hoc reports by drilling up down within and across dimension or anywhere.
- Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
- Configured the Enterprise Manager for statistical reporting purposes.
- Design and creation of reports transformation and derived metrics filter objects prompts drill maps user hierarchies’ dynamic custom groups consolidations.
- Worked with DBA's to tune SQL generated by MicroStrategy reports and to collect DB statistics and in creation of additional indexes if necessary.
- Designed dynamic dashboards for easy data magnification.
- Performed administrative activities like invalidating the report cache loading and unloading the projects merging & deleting projects and creating security roles.
- Assisting project team with determining the appropriate technical platform (hardware and software) for new applications.
- MicroStrategy Consultant. Environment: Micro Strategy 9x/8x, Cognos, Oracle 11g/10g, TOAD, HP QC, Windows XP Professional.
MicroStrategy Developer
TeleworX
03.2010 - 09.2011
- Involved in the gathering of business requirements and translating them to the report specifications for the MicroStrategy platform.
- Participated in BI team meetings to discuss the user requirements.
- Worked extensively with public objects such as Metrics, Reports, Advance Filters, Relationship Filters, Custom Groups, Consolidations and Advance Prompts.
- Created Schema objects such as Attributes, Facts, and Transformations etc.
- Designing and Creation of Dynamic Dashboards and Documents using Report Services and deployed to the end users using Distribution Services.
- Have used several widgets and controls to Design and Develop Dashboards in Flash like Interactive bubble graph, Heat maps, Gauge, Time slider, Fish Eye etc.
- Created transformations (Table Based and Expression Based) for YTD (Year to date), QTD (Quarter to date), MTD (Month to date) and WTD (Week to date) analysis.
- Implemented OLAP Functions like Apply Simple, Apply Comparison, NullToZero for the complicated filters, attributes and metrics.
- Involved in troubleshooting Micro Strategy Web Reports, optimizing the SQL using the VLDB Properties.
- Involved in preparing high level design document and Technical Requirement Documents for reports.
- Prepared for Unit Testing, UAT and created Logs, Defect Tracking using Quality Center.
- MicroStrategy Developer. Environment: Micro Strategy 9x/8x, Cognos TM1 9.5, MS Office 2007, SQL, Windows OS, HP QC.
Reports Developer/ Data Analyst
HP
03.2009 - 03.2010
- Worked with Business Analysts/Subject Matter Experts to identify and understand requirements.
- Extensively worked with Ad hoc reporting and standard reporting environment and validated reports based on Functional Requirements.
- Created filters, prompts (Object prompt, Level prompt, filter definition prompt) for creation of MicroStrategy reports. Created various complex objects like dimensional metrics, conditional metrics, set filters, relationship filters and object prompts.
- Used conditional formatting feature to project trends for product sales and to enhance grid and graphs in documents. Involved in troubleshooting MicroStrategy Web reports, prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse environment.
- Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
- Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop that can be re-used to build any number of metrics. Used report services for various banded report to satisfy the printing requirements of the user.
- Validation of data flow and ETL workflows from multiple Source systems through ODS to Data marts.
- Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
- Reports Developer/ Data Analyst. Environment: MicroStrategy 8x, HP QC, Cognos BI, Oracle, SQL Server, Oracle, DataStage, Win XP.
Graduate Research Assistant
UTEP
08.2007 - 12.2008
- Worked on integration of industrial and manufacturing data points with various data mining theories like Principle Component Analysis, Fuzzy Logics as an active participating research member of IMSE lab.
- Reviewed Data Mining applications in real world scenarios and documented requirements (Data Mapping and Data Mining documents) with research analysts for thorough understanding of theoretical application.
- Validated data through various stages of data movement from staging to Data Store to Data warehouse schemas using statistical analysis methodologies.
- Participated in Data mining methodology studies, researches and worked with different academic instructors in publishing technical papers and articles.
- Provided flexible and high quality support to wider Testing strategies on key regular deliverables and KPI based reporting issues.
- Graduate Research Assistant. Environment: Microsoft Windows XP Professional, TOAD, Oracle, Teradata, HP Quality Center, MS Office.
Education
M.S. (Master of Science - Engineering
Skills
- Technical Skill Set:
- BI/OLAP Tools: MicroStrategy Product suit (2019, 11x, 10x), Cognos BI, Tableau, Informatica Reporting
- Databases: Redshift, PostgreSQL, Oracle, Netezza, Teradata, SQL Server, Apache Spark SQL, Hadoop
- ETL Tools: Informatica PowerCenter 9x/8x, Cognos TM1(Turbo Integrator), Cognos Decision Stream
- Data Modeling: Erwin, Visio, TOAD for Data Analysts, SQL Server Management Studio
- Testing Tools: HP Quality Center/ALM, Mercury QTP, Quality Center, Load Runner
- Operating System: Windows, Mac, iOS, Android
- Other Tools: TOAD for Oracle, Aginity, SQL Plus, Squirrel Net, SharePoint, Remedy, MS Office, VM Ware Workstation, Citrix, JIIRA, Confluence, BitBucket, Jenkins, GitHub, Pentaho Data Integration
- Problem-solving, Result oriented implementation of Projects with effective Teamwork and collaboration and Attention to detail, engaging customer ensuring satisfactory delivery of products in a timely manner
Veer Bhartiya (Founder's) Award at REI Systems for exceptional Project Implementation
First and only consultant to receieve the annual Veer Bhartiya Award for Innovation and Impactful Solutions
Timeline
Agile Development Senior - Freddie Mac
03.2023 - Current
MicroStrategy Consultant - GSA/REI Systems
12.2016 - 03.2023
MicroStrategy Developer - Freddie Mac
09.2015 - 12.2016
Lead BI Consultant - RaceTrac Petroleum
05.2014 - 09.2015
MicroStrategy Technical Lead - QVC
06.2013 - 04.2014
MicroStrategy Architect/Developer - Lockheed Martin
01.2013 - 05.2013
MicroStrategy Consultant - HSBC
09.2012 - 01.2013
MicroStrategy Consultant - Quintiles
10.2011 - 08.2012
MicroStrategy Developer - TeleworX
03.2010 - 09.2011
Reports Developer/ Data Analyst - HP
03.2009 - 03.2010
Graduate Research Assistant - UTEP
08.2007 - 12.2008
University of Texas - M.S. (Master of Science, Engineering