Bharat Varma Sagi Email & Phone Number

Plano, Tx, Us

Dallas, Texas, Us

Thoroughly understand the Business needs and value they are looking that technology will add to support current business process and future business needs.Come up with Roadmap for IT Projects ensuring high ROI for the project Stake holders.Building an accountable team to deliver the project on time with high quality.

Helping the team in creating road maps for the projects and designing an implementation strategy to achieve the project milestones.Identifying the right set of tools and technologies to be used on a project based on data volume , usage , financials and existing team competency.Discussing with Product and Service vendors to understand the new technologies and features and see how they can be leveraged to add value to the projects.Working with vendors and selecting the vendors by accessing their technical and implementation abilities to provide services for cost effective , high quality project implementations

Atlanta, Georgia, Us

Studied existing Reporting process and created a road map for the BI/Data warehouse/data mart designing.Recommended the technology stack needed to build the Data warehouse based on the existing Technology infrastructure and future reporting needs.Responsible for the Business Analysis and Requirements gathering.Translated user requirements into system solutions.Designed end to end BI architecture and coached the team in implementing the same.Coached the team to design interactive dashboards that can be viewed on Tablets , PC's driving quicker insights of KPI's.Build Global BI team from ground up ensuring that work is executed 24 hr round the clock seamlessly reducing the project costs and delivering projects at a great pace.Created a Project execution frame work and worked with team to deliver the Project in Agile methodology.Guided team to design the security frame work for both Internal and external business and technical users.

Dallas, Texas, Us

Designed and developed Dimensional models(Star schema / Snowflake schema) , 3 NF models and Relational models using Data modeling tools like ERWIN to meet the adhoc and canned Business reporting requirements.Designed end to end Data Integration Architecture factoring in usage of best practices , reusable components , data quality and performance.Designed Reporting framework for both Canned and Adhoc reporting.Coached Development team in creating ETL jobs , Reports and Semantic Layer for adhoc reporting.

Dallas, Tx, Us

Created road Map for BI projects.Designed and developed Dimensional models(Star schema / Snowflake schema) , 3 NF models and Relational models using Data modeling tools like ERWIN to meet the adhoc and canned Business reporting requirements.Designed end to end Data Integration Architecture factoring in usage of best practices , reusable components , data quality and performance.Designed Reporting framework for both Canned and Adhoc reporting.Coached Development team in creating ETL jobs , Reports and Semantic Layer for adhoc reporting.Defined user access strategies based on level of information access need for each user in the organization.Coached development team to build dynamic site ( row level) security.

Translated user requirements into system solution.Data Analysis of the OLTP system to identify the sources for extraction of the data.Conducted Data lineage Analysis for assessing the impact of new deployments.Designed Ragged dimensions, structure tables and snapshot and accumulating snapshot fact tablesDesigned and developed Confirmed ETL/ELT architecture to incorporate reusable components in ETL environment.Designed, Developed and implemented Audit and Error control Mechanisms.Implemented CDC using Oracle Golden gate.Created Table level spec/Data Map document for each and every Target warehouse table that gives the business rules for every column in the table.Designed Semantic Layer to support the Adhoc reporting capabilities.Developed Data integration jobs involving complex logic and created automatic mechanism that will handle data related job failures.Created Reports for executive team.Guided Development team in creating ETL jobs and Reports.

Pune, Maharashtra, In

Implemented Dynamic Site Security.Designed, Analyzed, Implemented and monitored ETL processes. Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.Designed and developed various kinds of mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, and Look up, Filter, Joiner, Rank, Router, Update Strategy and XML. Redesigned some of the existing mappings in the system to meet new functionality.Implemented Workflows partitioning using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions. Prepared ETL mapping Documents, Data Migration documentsOptimized/Tuned ETL jobs and sessions for better performance and efficiency.Designed reporting semantic layer- BO Universe.Created various classes and objects in the Universe.Created Measure and Dimension objects keeping in view of the end-user adhoc requirement.Developed BO and WEBI reports (Full client and Thin Client Reports).Designed and scheduled different kinds of reports – Master/ Detail report, Interactive reports with Cascaded prompts, Drill option reports etc.Administered security through Supervisor.