Ravi Kumar
Senior Technical Architect at Valiance Solutions- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Hindi Professional working proficiency
-
Telugu Native or bilingual proficiency
-
Kannada Native or bilingual proficiency
Topline Score
Bio
Experience
-
Valiance Solutions
-
India
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Technical Architect
-
Mar 2021 - Present
Working at Valiance Solutions as Sr. Technical Architect --overseeing Technical Architecture or IT Architecture of a projects currently assigned. Majorly working with o9 Solutions: Primarily responsible for design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics Understand o9 platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases Review and analyze the data provided by customers along with its technical/functional intent and interdependencies Lead customer sessions in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery Design and support execution of test plans, document issues and track progress at resolving issues. Integrate o9 platform with the external client ERP like D365, SAP, Oracle for a agreed data feeds/exchange. Show less
-
-
-
Ever Fashion Luxury Group
-
Qatar
-
Retail Luxury Goods and Jewelry
-
1 - 100 Employee
-
Information Technology Manager
-
May 2015 - Jun 2019
Responsible overall computer systems, devices, peripherals, security systems, telecommunications, IT networks, ERP & their operations of the organization. • Manage Information Technology (IT) and Computer Systems • Head the BI team through interaction with business users to gather reporting and analytic requirements • Design, Build, Deploy and Manage BI Dashboards/Solutions/Projects. Consult on optimized existing reporting and visualization. Provide reports, processes and Excel VBA applications. • Collaborate with different departments and analyze business processes and requirements. And also integrate reporting into their processes. • Design, Build, Deploy and Monitor the SSIS packages. Troubleshoot for errors and ensure execution of all scheduled packages • Identify opportunities to improve processes and strategies with technology solutions. Identify development needs in order to improve and streamline operations • Overseeing and determining timeframes for major IT projects including system updates, upgrades, migrations and outages • Plan, organize, control and evaluate IT and electronic data operations • Ensure security of data, network access and backup systems • Developing and implementing IT policy and best practice guides for the organization • Audit systems and assess their outcomes. Preserve assets, Information Security and control structures Show less
-
-
-
Maersk Oil
-
Denmark
-
Oil and Gas
-
700 & Above Employee
-
IT Consultant
-
May 2012 - Dec 2014
• Worked with the SAP MOUSE team as Data Expert. SAP MOUSE project being the migration project from legacy ERP system Microsoft Navision to SAP ERP system. The key role played in the project is the extraction of the data from the legacy ERP tool applying the transformation, optimizing the data for SAP. Preparation, optimization, fetching of the data for all the mandated requirements of the SAP systems requirements. Carried out the Data preparation for Bank Master Data and Vendor Master Data modules. Co-ordinating with the Finance team and SAP team to ensure data validation during migration. o SAP Finance Functional • SAP Accounts Payable End-To-End processing (invoice -> payments) • SAP workflow Exceptions handling in the Accounts Payable -complete. • Generate and present KPI dashboard for the Finance department; Generate Open & Overdue report and share with all the departments • Carrying out the payment processing batches to the vendors & employee expense claims on a bi-weekly basis in SAP. This involves the creation of a payment proposal, edit proposal & run the payment proposal. Generate the EDI files to be uploaded to the corporate house bank. • Creating and clearing the down-payments; Reversals, Releases, and clearing of the blocked invoices in SAP • Indexing vendor finance documents invoices & credit notes for Material Purchase Orders & Service Orders using OpenText application Readsoft. Show less
-
-
-
Wipro
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
Business Intelligence Analyst
-
Feb 2011 - May 2012
Client: Bluestem Brands, Inc located at Minneapolis, Minnesota. Working as part of the Retail domain for Bluestem Account for BI – DW applications & IT systems.Roles & Responsibilities• Monitoring the Build process of the major Data Warehouses used for Business. Maintenance & support BI – DW applications.• Preparation of SMTD documentation. On-Call support during the failures of the scheduled jobs.• For major incidents, it would be tracked in HPSM to keep the business running based on the severity and priority.• Ad hoc small projects/enhancements including a code fix to the existing SSIS package or development of a new SSIS package for deployment based on the CR or new Requirements Specifications.• Preparations of the MIS/SLA reports. Show less
-
-
Team Lead
-
Jul 2007 - Feb 2011
Client: Wipro Technologies – Information Systems, Sarjapur road, BangaloreRoles & Responsibilities• Worked as a team lead handling 8 teams (overall team size of 17 members) /applications (E-Cube, Clarity, PCT, POC, Knet, CMAS, Legal & Audit) with 9 direct reportees & was made the SPOC for entire Mysore Team.• MSBI activities include processing of the SAP dumps and loading them into the database used for the project. Involved in ETL activities between the source and the destination. Worked with flat file data, XL data and other database like MS Access, SQL database etc. Strong holds on the SSIS component of the MSBI; also exposed to the SSRS and have developed many reports based on the requirement.• Primarily handled E-Cube & Clarity applications for all L2 activities key tools used are MS SQL Server 2005/SAP application.• Review & Verify all the L2.2 activities like SQL Scripts before execution in production Server.• Identify bugs in the application also review Enhancements by the business users.• Exposure to SAP application where the data (project details) from SAP (HR module) was imported for E-Cube Application. • Involved in preparations of various reports like MIS/SLA/Review reports and sharing the same to the Supervisors and clients. • Involved in MIS monthly meeting in order to monitor the productivity and projections of all the teams assigned to me.• Managerial roles - Annual appraisal & rating of the team. Setting Goals & Objectives, KPI, Norms etc. Also involved in BCP for the team. Show less
-
-
Education
-
Gulbarga University
Master of Computer Applications (MCA), Computer Programming, Specific Applications -
Gulbarga University
Bachelor of Science (B.Sc.), Computer Science