Kumar Ram Email & Phone Number

Charlotte, Nc, Us

Concord, Nc

Calgary, Alberta, Ca

Manage and deliver analytics projects across the public and private sectors.Recent engagements include:•Architect & implement an application to automate recording and reporting of treatment information for Ministry of Health.•Design & implement Corporate Performance Management (CPM) solution for a real estate firm. •Financial Operational (Service Scheduling) and Funding Allocation modeling for Ministry of Health.•Advisory & implementation services on integrating data from multiple sources into one corporate reporting database for a multi-site health care business intelligence platform.•Architect & document on integrating different BI applications into reporting module for a multi-site health care business intelligence platform.•Housing Capital Repair Financial Planning and Scenario modeling for City Municipality.•Assess existing technology stack; define business and technology requirements for a non-destructive testing, inspection and engineering firm to procure Workforce Management.•Audit IT monitoring system for a financial organization.•Design & implement Fraud Detection data mining solution. •Focus on year around sales performance - delivering internal (self-service) analytics solution by integrating different niche data repositories and building in-memory data models.•Solely responsible for designing a business case and developing an internal end-to-end BI solution for internal & external demo purposes.

Santa Clara, California, Us

Embedded Analytics: Integrate enterprise resource planning platform with reporting application that helps in viewing business data in desired format. •Design, develop & test templates, format reports and then import to ERP system

London, Ontario, Ca

Upgrade BI environment and implement data repository that holds tactical information to make strategic decisions for a local energy organization. •Business requirements development for dimensional modeling and data warehouse implementation•Defined data management strategy to serve short-term and long-term business needs•Identify & define KPIs at all levels from enterprise wide to individual departments and prioritized them accordingly •Supported the team with major business application migration•Designed & implemented reporting module•Involved in pre-assessment sessions of software procurement (in-memory solution)•Planned, designed, implemented and administered relational & data warehouse databases (staging & target) •Responsible for writing complex transformation scripts which includes (source to target) mappings, lookups and to invoke cleansing functions such as duplicates handling, address parsing etc.•Build efficient logic for processing fact tables (handling late arriving facts) and dimension tables (handling late arriving dimensions & all type changes i.e. type 1-6) •Developed various workflows and data flows for data conversion where the data is extracted from the sources then loaded into staging tables•Created new views and aggregate tables for report performance•Worked with the testing team to derive test cases for efficient data reporting•Documentation for users on how to use developed BI objects

Palo Alto, Ca, Us

Workaround to fix performance issues by re-configuring existing BI environments and develop internal analytics solution for Production and Sales departments.•Studied business process, understood landscape and architecture of existing business intelligence landscape•Architect analytics solution to serve business users with ad-hoc data needs•Involved in Joint Application Design (JAD) sessions to determine dimensions, hierarchies, and levels, basic and derived measure to be used in multidimensional model for the system, designing extended-star, star and snowflake schemas•Involved in migration from previous to the latest versions of database application•Defined logical models and designed dimensional modeling data warehouse based upon Kimball Methodology •Designed dynamic (extract, transform, load) logic to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS•Involved in performance enhancements of database servers, performance tuning, optimization, troubleshooting and backing up the databases•Involved in setting up, managing and maintaining High availability technologies: Log shipping, Mirroring and Replication•Extensively involved in information systems data profiling activities

Data warehouse development for an online groceries and food services firm.•Defined several KPIs that contribute to the business intelligence program objectives•Worked closely with business teams to develop mapping speculations and design docs that were used by the development team•Involved in the complete data warehouse development life cycle; Actively supported business users for change requests•Installed, configured and administered business & database application as per the best practices guidelines•Defined new database structures, data conversion strategy and conversion specifications•Worked on different vendor database products; Stored procedures & triggers, cursors for implementing business rules and transformations •Responsible for creating/implementing both source and target based change data capture mechanism using time stamp and history preserving transforms•Created various work flows, data flows to coordinate the initial data loads as well as incremental load in to development, QA and Production environments for the warehouse and data mart•Created procedures to drop and recreate the indexes in the target data warehouse before and after the sessions•Worked extensively on data maintenance like re-indexing, integrity checking, database shrinking•Scheduled administrative tasks like database integrity checks and maintenance plans•Performance tuned complex SQL queries, views and materialized views by building indexes on underlying tables, procedures and functions to apply business requirements that integrated the organization's demands and fine tuning the underlying joins•Worked on providing visual formatting effects to show the trend patterns within the subject of analysis

Miami, Fl, Us

Implement logistics business warehouse, provide strategic information about quality products at competitive prices and with optimum customer service.

Master Of Science (M.Sc.), Computer Science

Bachelor'S Degree, Information Technology