Home

Krishnakumar subramani - Data Architect / Data Lead SAP BI DW

[email protected]

Location: Dallas, Texas, USA

Relocation: NO

Visa:

PROFESSIONAL SUMMARY Over 15+ years of experience in implementation of information technology systems within medium to large-sized organizations for data integrity, data governance and master data management. Proven leader and hands-on experience in leading all stages of system development efforts. Experienced in managing multiple programs of IT modernization, new capability enablement and process improvements for major brand retailers, consumer and product goods, utilities, and more. Lead the design, development, implementation, and support of business solutions around data management; managed data applications through complete lifecycle; cross cultural and cross domain teams, led teams for data cleansing for both projects and standard processes. Strong experience assuring adherence to all SOX and Global Data Governance policies and procedures. Experienced in project planning, stakeholder management, issue and risk management and delivery management and Budgeting. Experienced in managing global teams of up to 20 members operating an offshore/onsite model; leading cross-functional teams with diverse technical backgrounds. Experienced in managing large centralized EDW s and knowledge in big data such as Hadoop and Teradata. Ability to develop and maintain effective relationships with stakeholders and business partners. Experienced in developing BI strategy, roadmaps, and setting up BI competency/Data Governance. Broad experience in Business Intelligence such as Data /Analytics/Delivery EDUCATION | TRAINING & CERTIFICATIONS Madras University, Chennai, India Masters of Computer Applications (MCA) Madras Christian College, Chennai, India Bachelors of Science in Physics PROFESSIONAL EXPERIENCE FLOWERS FOODS 01/02/2018 - TILL DATE SOLUTION ARCHITECT Oversees the D&A team's priorities and tools on Data management, reporting and analytics. Led the projects, upgrade activities and go-live cutover tasks etc. Good understanding in Master data, BI and Security and formulate the data quality check. Encouraged the team members to lead the tasks and work with business and across functional teams such as the Order to cash, procurement, Finance & Controlling and TPM defects fix etc. Organized and coordinated the overall Analytics team meetings with vendors and across functional teams, organized BI/Security Bi-weekly checkpoint Led the DR project for Analytics teams to be successful with the lesions learned session Led the Clear Story to Alteryx Go live project to be successful from BI application side by leading the new design of Alteryx schema views. Implemented CRM and Trade planning, promotion, Pricing, and funds for Flowers customers. Worked with IRI and Nielson for dashboard sales and metrics for retailer and Noncustomers. Led the completion of Sales and Trade promotion Management yearend tasks by coordinating the backend/frond end tasks with Business teams and Release Management director. Implemented, developed, and implemented the new extract process to mobility system for the data consumed by over multiple bakery users. Conducted the resource allocation in Clarity and project/tasks creation on weekly basis. Encouraged the team members to lead the tasks and work with business and across functional teams. Implemented the Data Management & Archiving strategy for sales data to increase the data load performance and report execution. It would free up HANA memory to allow additional data for business. Continue data archiving for other applications and ready for archive criteria. Implemented the integration and pipeline for the Finance and TPM, Pricing, promotion, Planning, Marketing analytics and Integration & Data Movement between SAP HANA to Azure (ADF). This is to set up connectivity and pipeline for data movement to Digital product team. Experience in leveraging data and analytics tools, platforms, and technologies such as SAP HANA, SAP Business Objects, SQL BI stack, Data science, Databricks, Spark, Azure Synapse Analytics, Tableau, Power BI, R, Python, ML, SQL, S4HANA, ERP, S4, AWS Cloud Infrastructure and Alteryx and API s Client: City of Dallas /State Government Dallas, Texas Jan 2017 to till date BI Architect Working as a Project Manager on the Work order life cycle management project for Dallas Water utility is to automate and Manage the work order/ Service request for different department /function such as Water purification, Waste Water Management, Pumping, distribution, waste water collection, Trinity river Management, Equipment and Building services, Automation and Mobility and others. The platform involves such as Maximo/IBM, SAP (Billing), GIS, HANSEN, AMS (Advantage management system) Tri riga, Hierarchy classification, SQL, JAVA, Oracle etc. Managing resources of Maximo application development, GIS and Interfaces such as SAP (Billing, Inventory and Finance), GIS (Geographical Information system) and 3-1-1 (Customer Call request) and Infrastructure Conducted a Workshop for all department of City Water Utility users to capture the detail requirement from role owner. Helped business Analyst to document the Business Context diagram(BRD), Entity relationship Model(ERD) Conceptual Model and development and Testing Deep understanding of Data Management software and tools in both operational and analytical solutions, architect and model the data as well as experience in managing ERP data to support business Responsible for collaborating across business and technology teams to understand the various data domains to support our strategic initiatives. Managed platform security and SOX compliance, managed current model and Master Data Management(MDM) and reporting of SAP BW Architecture with new development which followed the governed process in terms of defining the architecture, operational focus on data by day to day, identify the data domain, data quality and support the critical data for business. Created a Test plan and Test Script and conducted user training for all department Documenting issues and GAP that need to be addressed for City of Dallas Work order life cycle include Inventory and Purchasing process. Managed and worked in data modeling, ETL Mapping, data flows, data analysis for data extraction and transformation and Loading into Enterprise data layer Developed various analytics, data integration with other application such as SAP, Billing system and HCM which involving both operational and analytical reporting Keurig Green Mountain Inc. | Dallas, TX May 2015 Dec 2016 BI Architect Responsible for project scope and development from inception through go-live. Involved in various projects including leading an implementation project and delivered around 30 metrics for various business and management users. Developed SOW and project plan for roughly 1 million plus additional change requests. Overall team size of 33 personnel. Accountable for achieving results and end objectives around IT projects for Master Data. Lead for integrating the business in governance, business functions, processes, and other information. Estimate project timelines and assess architectural designs to develop transformational roadmap. As part of an Information Technology modernization initiative, designed an enterprise data solution and roadmap to replace multiple legacy transactional, data retention and reporting systems. The recommended solution would allow users and stakeholders access to quality information from utilizing an Operational Data Store, Enterprise Data Warehouse, and Business Intelligence. Responsible for driving the fit gap assessment/design, configuration, development and testing efforts to deliver programs on time, within the budget and meeting the scope. Managed platform security and SOX compliance, managed current model and Master Data Management (MDM) and reporting of BI Architecture with new development which followed the governed process in terms of defining the architecture, operational focus on data by day to day, identify the data domain, data quality and supported the critical data for business. Involved in the governance meeting for SAP BI transport approval process/Governance approval and managed the current BI batch process. Implemented GL account model hierarchy and replicated P&L and balance sheet for BI reporting. Used virtual table and built a Views and model off (Live data). The data in the model was made available for real time reporting. Managed the reporting team and delivered analytics in various business areas using Tableau, BOBJ, Business Objects, and Business Explorer. Implemented road mapping methodologies and other planning processes of SAP enterprise reporting to consolidate data and helped with financial month end closing. JP Morgan Chase | Columbus, OH May 2014 April 2015 BI fucntional lead Managed requirements phase of London project as part of multi-year initiative which included migrating ledgers and sub ledger conversion from financial to reporting in enterprise BI Established and maintained engagements with the business partners regarding on-boarding of the data ensuring the integrity of the data. Established and enforced a standard format for the delivery of the data to the Enterprise Data Warehouse (EDW). Work with business to formalize and document processes and procedures on a global scale. Created and implemented a Global Data Governance organization. Implemented ITIL deployment practices for Enterprise Architecture group. Established and utilized a robust QA methodology to ensure that optimal verification and validation was performed at each stage of the ETL process and managed source to target mappings. Facilitated discussions with data owners and business partners to get conformance around reference data and hierarchies. Conducted presentations for the senior leadership to communicate the status and escalate any issues requiring their intervention. Coordinated and implemented SAP ERP/SAP BW/BI balance sheet, P&L, expenses management and project system for internal and external reporting using BOBJ. Managed and delivered SAP BPC business consolidation enhancement project for line of business consolidation and migrated from Hyperion system. Stanley Black & Decker | Noblesville, IN June 2013 May 2014 BI Consultant SAP BW/BI Project Manager on financial transformation project which included SAP and Non-SAP financial data for Hyperion Planning and consolidation reporting. Responsible for portfolios of $4 $10 million dollars across multiple clients. Coordinated BI blueprint reporting meeting with financial customer and department and gathered current and future requirements. Used Lean management approach to streamline the change process for current and future state. Provided an enterprise-level Data Management Strategy, Data Lifecycle, Data Quality Improvement, Decision Support, Master Data Management (MDM), and Metadata Management. Managed financial project of around 14 financial systems across North America, Europe and Asia centered around the consolidation of Business Object Data services BODS layer and updated to operational data store to EPM layer and further updated to reporting layer. Defined a Data Quality Improvement Methodology which included data entity selection, quality tolerance levels, data sampling, profiling, cleansing, prevention, monitoring and an estimated project plan with Work Breakdown Structure and Man Hour Cost Estimate. Managed migration and consolidation of financial project using Business Objects and Tableau as enterprise reporting tool to support business. Mettler Toledo International Inc. | Columbus, OH September 2012 March 2013 BI consultant SAP BI Project Manager in North America implementation project and generated analytics on SAP CRM Sales and Marketing, Service Management and FICO reporting. Responsible for development activities include blueprint, workshop, design back end and front-end development using Perl and SQL data extract Responsible for delivering a dashboard lead-to-quote (unlinked) where it generated leads, quotes and opportunities for sales and billing details Directed the team for promotional activities on Business Objects WEBI reports from development to pre/post production. Barnes & Noble | Lyndhurst, NJ February 2012 August 2012 BI Lead Coordinated BI blueprint reporting meetings with B&N customer services teams and department to gather current and future requirements. Responsible for creating functional and technical specifications and successfully implemented a B&N call center project. Delivered various metrics and reports on applications such as call statistics, interaction, service request, complaints, mishandled calls, and repeated calls. Delivered call center dashboard and metrics using Business Objects and WEBI for North America locations. Managed BI tool Used tool Business Objects for reporting and Dashboard for B&N Call Center department. University of Cincinnati | Cincinnati, OH September 2011 January 2012 BI Consultant Delivery Lead on the following areas: funds management, general ledger, planning, budgeting, controlling, cost center allocation, and supported BI applications of PBF (Public Budget formulation) and HR (Personnel, TM and Payroll, Benefits) for University of Cincinnati employees. Responsible for finance and controlling projects with the business in organizing, prioritizing and finalizing the scope of each release. Delivered an employee history management reporting/dashboard using Business Objects. Managed enhancement pack to 702 upgrade, and supported pack implementation across all environments with DB2 and managed the performance of improving queries with multi-provider design and reduced the runtime of queries. Managed UC Employee conversion project into SAP. Monsanto | St. Louis, MO May 2010 September 2011 BI Lead SAP CRM project Manager responsible for the implementation of CRM activities, service management, marketing, and planning to support the Monsanto customer, dealer, and/or agent to perform forecasting and planning on upcoming events. Responsible for BW implementation project work and developed technical design specifications for CIC Web Survey project for Monsanto dealers and customers. Implemented functionality and WEBI reports in BO of email management system for Monsanto dealers and partners to send and receive status of product and notifications from CRM to BI. Educated the team to use Solution Manager to migrate the development changes to different environment and followed the Monsanto governance process and BI Development process. Kraft Foods | Glenview, IL January 2010 April 2010 SAP Data Lead Served as a consultant on a customer trade project in CRM/IP and SCM APO production support enhancement project with IBM to support customer budget planning system and trade reporting for Kraft customers. Led and directed team for customs hierarchy for customer and sales into SAP BI. Implemented funding, spending, and claims using the CRM, I/IP planning A/R and dispute data to generate OTC reports for Kraft customers. Coordinated and directed a team with Patch/OSS notes due to version upgrade and short dump. Limited Brands | Columbus, OH December 2005 January 2010 BI Managing Consultant Limited Brands corporate strategy was to implement SAP systems for Enterprise Resource Planning (ERP and BI) which includes, Accounting, Product Costing, Profitability analysis COPA, and more to report to various departments and brands. The Limited Brands umbrella includes Bath & Body Works, Victoria s Secret, MAST Industries and Limited Technology. Bath and Body Works Successfully planned and executed finance/accounting process development project. Implemented the standard functionality of GL and cost allocations, project systems, COPA and statistical key figures and configured mappings to extract the balance sheet specially formatted reports like income statement, cost accounting reports, and management P&L reports using BEX (Business Explorer) reporting tools. Managed cost center allocation and internal orders to help management for month-end closing. Managed and configured POS/PIPE data management to view the sales achieved in the store and details extracted for the credit card settlement process. Delivered and managed the master data project using Dashboard (WAD) to display the article in different views (Daily and Weekly reports). Victoria Secret Stores Configured, developed and implemented the data modeling design in SCM APO4.1 (demand planning/SNP) to extract the data from planning area to BW cube and push the data back to APO box for back up. Created the finished goods and raw material reports for vendor and factory from DP/SNP planning projection by monthly bucket. Owner of deliverables for a dashboard with metrics of 3 company s financial details in one view. Customized the income statement and balance sheet based on FSV update. MAST Companies Delivered tool customer order visibility report, transport weight report, transport gross weight by purchase orders reports for building the BI and Supply Chain Event Management. Managed performance tuning both back-end and front-end sides. Coordinated and mapped a code block to transfer the GL data from PeopleSoft to BI using data stage interface. Limited Technology Services Managed BW support project and developed technical design specifications for developments. Activated the business content for xRPM loaded the data for Resource Project Management (SAP xRPM) and configured, and validated the xRPM reports in SAP Enterprise Portal. Supported and monitored the production live system 24/7 and resolved technical and functional issues. Resolved problems, incidents, risk, compliance, and change management issues using Peregrine Service Center and complied with ITIL (IT Infrastructure Library) Service Management using governance, risk and compliance processes. Proctor & Gamble | Cincinnati, OH March 2005 December 2005 SAP BW Consultant Enhanced HR Master Data and updated the HR cube and report accordingly. Worked with backend security and enabled new reports available to users. Worked on Gillette acquisition project for BI. Gillette | Boston, MA May 2004 - February 2005 BI Consultant Extracted the A/P, A/R, GL, and Controlling/COPA and built the customs reports for stockholders and internal management. Extracted purchasing documents and inventory data from R/3 using LO cockpit, implemented Report-to-Report Interface and R/3 thrill-through for drill-down analysis. Developed SAP BW reports to analyze purchasing documents and inventory management. Alstom (I) Ltd | Chennai, India May 2002 April 2004 Analyst Reviewed business-initiated integration tests, and test problem reports (TPRs) against design, replicated problems, identified causes, and proposed solutions. Identified the problem which was directly related to a requirement in the DER (Development Request). Keywords: quality analyst machine learning business intelligence sfour rlang information technology golang business works Illinois Massachusetts Missouri New Jersey Ohio Texas