| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior Data AnalystSummarySenior Data Analyst Specialist professional providing solutions in Data Analytics. Proficient in business intelligence analysis and problem solving. Excellent handling of large and complex projects providing detailed analysis and presentations. Impressive career record spanning twenty years and business acumen required to deliver practical IT solutions marked by the ability to architect complex systems that are flexible, easy to maintain, reuseable, rules based, aligned to business objectives. Provide stakeholders with meaningful results through PowerBI dashboards. Manage multiple cross functional workgroups to accomplish tasks. Work closely with data partners to identify required source data and develop extensive validation process flows to ensure accuracy. Previous experience as a Business Analyst in Oracle Applications-Financial Modules.Functional Expertise: Data Lake, Agile methodology, DevOps, B2B, Data warehousing concepts, Oracle Financials, Order Entry, Inventory, Purchasing.Industry Expertise: Manufacturing, Distribution, Healthcare, Banking, Retail.Technical Expertise: DevOps, Power BI, MSMDS, Data Bricks, Snowflake, TOAD, SQL Developer, MS Excel, Microsoft SQL Server, Oracle PL/SQLExperiencePPG Industries Mar 2015 Apr 2024Lead Data AnalystProject: EHS Cority Data LakeRoles & ResponsibilitiesProject Lead for EHS Dashboard Modernization.Create Mapping documents for Gold/Curated layer.Lead technical meetings and coordinate with business on requirements and UAT.Work on DevOps and follow Agile methodology.Create PowerBI Data ModelCreate PowerBI Reports for Leading and Lagging Indicators.Coordinated cutover activities for go-live with cross functional teamProject: AC USCA ACDW ExitRoles & ResponsibilitiesProject Lead for the AC USCA home center (big box stores) business Home Depot, Walmart, Lowes, Menards, RonaCreate functional Mapping documents.Validation of data layers gold, curated in Data Bricks/Snowflake.Create MS MDS tables and load data.Report design and validation in Power BICoordinated with various teams -Business, FL-IT, DE's.Trained users on MS MDSCreated cut over plan and coordinated go-live.Created Reports on PowerBIWorked on PowerBI ModelSenior IT Business AnalystProject: Oracle R12 Financials Support and EnhancementRoles & ResponsibilitiesM&A integration in AR for Multiple Acquisitions into Oracle Application. Responsible for coordinating end-to-end cycle for implementing (Requirements, Solution Design, Setups, Documentation, Testing and Conversions).Manage Oracle Support Services (8 FTEs at peak) workload for AR tickets. Prioritization, root cause identification, triaging for workload balance.Lead several Process Improvement Initiatives including reduction of month end closing cycle from 3 days to 1 day, Improve on Collections, Optimization of Lockbox Cash Application auto-apply process, Customer Aging Analysis Dashboard.Ormet Corporation Aug 2011 Sep 2013Oracle Financial AnalystPart of the R12 implementation team for Accounts Payable and Purchase Order modules.Support User Issues on AP and PO.Created several BI Publisher ReportsHitachi Digital Services Jun 2006 Aug 2011Senior Oracle Apps Technical ConsultantProject: Welchs R12 Upgrade ProjectInterpret OM and Shipping Functional and Technical design specs written for 11i objects and make code changes to the custom objects based on the Release Change Document for R11.5.10 to R12.Unit and Integration test custom objects modified for the R12 environment.Coordinate with DBA team for migration of custom objects to the R12 environment.Project: BankON Product DevelopmentDesign and Develop Code for the Product (Red Stack Version).Prepare and lead presales demo to Potential Banks.Project: Care Hospitals Oracle R12 ImplementationParticipate in Requirement Gathering.Prepare Technical Spec and AR Conversion Code.Developed outbound scripts (Supplier Master and details, Customer Master and Details Store Master and Store details) for moving Oracle applications data to HIS.Identified and helped setup MRO items on Supplier Consignment. Analysis and mapping of the requirements and technical solution design.COGNIZANT TECHNOLOGY SOLUTIONS, INDIA Apr 2005 Feb 2006Technical LeadProject : OMAR, Maritz IncCreated Technical Specs. Developed packages for OMAR using PL/SQL web toolkit. Created and executed unit and integration test cases.TATA CONSULTANCY SERVICES Apr 2001 April 2005Technical LeadProject: Motorola Inc., Collaboration Planning and ForecastingSingle point of contact for Customer and Offshore Project Team for Custom Development Code Module. Setting Custom Derived Formulae. Training Co-ordination, Tickets, On Boarding activities, etc., coordinating Offshore ActivitiesProject: Centralized Application Support-Unix/Tandem, Target, MinneapolisAnalyzing and implementing the System Change Requests (SCRs) and Service Requests (SRs): Analysis, development and implementation of SCRs/SRs for systems pertaining to the 3D and other DC and store applications. Receiving Client problems and solving the issues to provide a persistent resolution to the problem with-in Service Level Agreement (SLA). Documenting the tasks performed for future reference, to guide the team member to avoid the re-work. Up gradation of SHARP tool for meeting Target Corporation store client needs.Project: Corporate Information Service, Compensation Planning, GEEnhancement of existing and development of new functionality. Receiving Client problems and solving the issues to provide a persistent resolution to the problem with-in Service Level Agreement (SLA). Production SupportEducation and CertificationsBachelor of Engineering, National Institute of Science and Technology, IndiaOracle Certificate for PL/SQLOracle Application Certification in HR and Payroll.Azure Data FundamentalsAzure Solutions Architect |
