Rss

Senthilkumar S

Datawarehouse Designer - 11 Years of Experience - Near 37214

Occupation:

Business Analyst

Education Level:

Master

Will Relocate:

YES

CollapseDescription

Professional Summary - Senthil kumar Selvaraj PMP Highly analytical, strategically focused Business Intelligence Architecture with an extensive history spanning over 11 years on IT contracts in Developing/ Designing/ Architect / Data modelling, administration & production support in Data warehouse environment Extensive experience leading Business Intelligence Information Management (BIIM) assessments, facilitating requirements gathering, developing methodology and implementing Master Data Management (MDM), Reporting, Data Governance and Stewardship strategies for companies in the: Healthcare, Financial service, Manlog industries Architecture development and analysis tool to boost data-centric approach, visualization, analytics, and business intelligence and Architecture and implementation strategies to deliver effective business and technical solutions Led teams of business and technical analysts in the collection and documentation of business and technical requirements gathering for the development of MDM, Data Warehousing and Reporting implementation roadmaps Designed and developed several data warehouse data model and oversaw all aspects development including ETL, Metadata, Reports and Dashboards Demonstrated strong knowledge of cross-functional business processes in Healthcare (Members, Providers, Claims) marketing, sales, service, finance, supply chain and manufacturing Effectively managed large teams and reported weekly project status to upper management detailing current performance against project goals and budget for 10 Business Intelligence projects Hands on experience in Business Analysis Framework, Data Warehouse Models, Load and Warehouse manager, Star Schema, Snowflake Schema and normalized schema design Proven ability to engage with stakeholders at all levels to understand data, process, and program requirements for large-scale, highly complex projects involving big data and multiple enterprise systems Delivered comprehensive BI through MS solutions including MS Excel, Microsoft office SharePoint Server and Performance Point Server Skilled project leader coordinating all stages of the project lifecycle - Requirements, Design, Analysis, Development, Testing, Implementation and Maintenance for complicated technical implementations Managed/Designed end to end OLAP/OLTP application, Data mart, Data Warehouse, Operational Data Store (ODS), and Data Migration, SQL Database Migration planning and upgrade * Extensive Experience of being a Technical Analyst primarily responsible for assessing requirements, estimating the timeline and planning the technical workflow of a development/enhancement including team size, effort variance and post-implementation support As a Business Analyst was responsible for coordinating and the implementing MEMR to ProEHR migration which include migration of Midmark devices, Burn Annotation, Full Patient Records, Glossaries, Template mappings, Social and Family history, procedures and Assessment plan. * Experience in configuration management: Identifying and controlling the release of a product and its changes. Ensuring completeness and consistency of product among components. Managing the process and tools used for builds and making sure every defect has traceability back to the source * Building Database Relations, Access Paths, Function Types, Device Designs and Action Diagrams. Worked on and completed Horse Model and Query Log Case Studies * Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications * Analyzing the recurring issues and providing permanent solution by creating problem tickets. Evaluation of the user's need with sensitivity, present alternative Solutions for preferred result effectively * Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Accomplishments * Project Management Professional (PMP) and Service Oriented Architecture Professional (SoA) * Won Delivery Reward & Recognition Certificate from Cummins Inc. for the contribution towards exceptional quality of deliverables * Received innumerable appreciations from the client on various kinds of deliverables and known among customers as the 'go-to' resource when in need of a solution Accomplishments * Project Management Professional (PMP) and Service Oriented Architecture Professional (SoA) * Won Delivery Reward & Recognition Certificate from Cummins Inc. for the contribution towards exceptional quality of deliverables * Received innumerable appreciations from the client on various kinds of deliverables and known among customers as the 'go-to' resource when in need of a solution Project Name: CES Pricing Database - MSBI Application Implementation - Facilitated Data Governance Steering Committee sessions to drive decision making - Expanded the product governance strategy and plan to include offer management and reporting - Facilitated the modification of operational processes to support the offer management implementation - Involved in the analysis of the requirements and gathering requirements for closed loop project - Involved in analysing and gathering the requirements for Row level Security and Role based security - Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities - Designed and implemented a project dashboard to track each project's performance against baseline enabling the management to make better, faster and more informed business decisions

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom