SUMMARY:

• More than 12+ years of IT experience in major multinational companies in USA (10+ years in Confidential).
• Strong Business Intelligence & Analytics domain knowledge in Finance, Sales, Supply chain, Banking, Master Data Management & Airlines.
• Performed various roles as Business / Data Analyst / BI - Solution Architect, MDM Architect, BI Consultant & Project Manager.
• Hands on experience on Data Migration, Data Integration, Business Continuity/Disater Recovery, Master Data Management.
• Hands on experience on large-scale initiatives, migration projects, Data migration, OracleR12 upgrade & major program/project initiatives in Cisco, Telstra, Citibank, HP, Singapore Airlines etc.,
• Strong expertise in all phases of the software development lifecycle (Agile/Scrum, waterfall), translating business requirements into technical solutions and fanatical about quality, usability, security, scalability.
• Project Management, DMAIC, Kimball methodology, Change Management, SaaS, Management experience of multiple projects with globally distributed teams, Well-versed with planning, scoping and mapping requirements to data and technologies.
• Extensively worked in Support & Development, Test cases, Advanced SQL coding, Tuning and Query optimization, BAT/UAT, Security, Governance and Operations metrics.
• Hands on experience in Business Intelligence &Analytics domain, data profiling, modeling (Erwin, ERStudio, LucidChart), ETLs ( PL/SQL, Informatica, BTEQs, T-SQL, Hive/Spark/Python, SQLs, GoogleSQL, Dremel) & reporting tools ( Business Objects, Tableau etc.,) & Databases like Oracle, SQL Server,Teradata, BigQuery & Hadoop/Big Data etc.,
• Experienced in gathering Functional & System Requirements, and Data/Gap/Business analysis. Passionate about driving business value based on metrics.
• Proficient in evaluating (Predictive & Forecast Analytics) and resolving business challenges by collecting, reviewing and analyzing business process information.
• Exceptional skills in influencing, globally distributed teams and delivering solutions in a highly complex, always changing, and nebulous environment.
• Excellent verbal, written communication skills, the ability to interact professionally with cross functional groups including senior executives, managers, business users & architects.

TECHNICAL SKILLS:

• Data Warehousing & Business Intelligence, Data Analytics, Data & BI Governance, Data Quality, Data Integration & ETL, Master Data Management, IT Architecture, Solution Architecture, Kimball methodology, Data Architecture, Project Management, Finance & Budget Management, Waterfall & Agile Methodologies, Scrum Master, Leadership & Team Development and Global Delivery.
• Oracle, MySQL, SQL Server, Teradata, BigQuery, Unix, Informatica, Oracle TCA, SQLs, PL/SQL, BTEQs, GoogleSQL, Dremel, Hive, Python, Big Data/Hadoop and BI Tools - SAP Business Objects, Tableau, Microsoft Office, LucidChart, Erwin and ER Studio .

PROFESSIONAL EXPERIENCE:

Confidential, CA

Data/Business Analyst & MDM/BI Architect

Responsibilities:

• Performing MDS Functional (customer hub, product hub, supplier hub) & Integrated solutions for multiple systems.
• Capturing the business requirements
• Providing the Architectural solutions on Master Data Management (MDM) and Business Intelligence (BI) platform & applications.
• Performing the Data Analysis, Gap analysis, Analytics and Business Analysis.
• Preparing business rules, mapping rules, and data clean up.
• Involved in Functional & System Requirements and Data/Gap/Business analysis.
• Support on Finance BI applications and enhancements on data & BI reports.
• Gathering the requirements as part of R12 upgrade and BI impacts.
• Performing/Supporting to Design, Modeling, Development, UAT and Deployment.

Data Analyst/Engineer, Business Analyst & BI Architect

Responsibilities:

• Played Subject Matter Expert and knowledge anchor role in Finance, Sales, and Supply chain domain.
• Performed and support on Mast Data Management (Customer Hub, Supplier Hub, & Item Hub), Sales Hierarachy, Product Hierarchy, Business Entity, TMS and Identity Access Management.
• Involved in Functional & System Requirements and Data/Gap/Business analysis.
• Provided the IT architecture, Solution Architecture framework on business need, platform and Enterprise solutions.
• Accelerated new data discoveries and self-service by conceptualizing Data Lab (or Sandbox) concept, Data Lake environment, creating service model for scalability and partnered with enterprise platform team.
• Performed Data profiling, Modeling, Development, BAT/UAT and Deployment.
• Performed on Standardization of ETLs, XML/CSV/Binary files, Automation, Change Management, Releases and Process improvements.
• Worked in Oracle to Teradata migration, Oracle R12 Migration and adoption of new Business Model like LSS, Software enablement etc.,
• Hands on Business Continuity/Disater Recovery process.
• Dev Ops support for Sales, Finance (inventory, GAAP, attribution, deferred revenue, metrics) and Supply chain BI applications.
• Migration business objects reports to Business Objects4.0
• Tuning & Performance improvements in ETLs and business reports.
• Proficient in evaluating Predictive & Forecast Analytics and resolving business challenges by collecting, reviewing and analyzing business process information.
• Project Management, Globally Distributed teams, Team building and Cross Functional Delivery/Ops solutions.
• Generate the Project metrics and Operational metrics.
• Involved in Security & Data Governance and Best practices.
• Involved in end to end solutions in major initiatives/Projects - Operations, Finance, MDM, AM Migration, EPS, LSS, R12 migration, CCW, Software enablement Program initiatives by using Oracle, Oracle TCA (Oracle MDM - Customer Hub, Supplier Hub, & Item Hub ), Teradata, Hadoop, Informatica, SQL, PL/SQL, Hive, Golden Gate, Business Objects, Tableau, ERStudio and Rally.

BI Consultant/IT Architect/Solution Architect

Responsibilities:

• Played Subject Matter Expert and knowledge anchor role in Master data, Sales, Finance and Supply chain domain.
• Involved in Functional & System Requirements and Data/Gap/Business analysis.
• Provided the IT architecture, Solution Architecture framework on business need, platform and Enterprise solutions.
• Accelerated new data discoveries and self-service by conceptualizing Data Lab concept, creating service model for scalability and partnered with enterprise platform team.
• Performed Data profiling, Modeling, Development, BAT/UAT and Deployment.
• Performed on Standardization of ETLs, Automation, Change Management, Releases and Process improvements.
• Worked in Oracle to Teradata migration, Oracle R12 Migration and adoption of new Business Model like LSS, Software enablement etc.,
• Dev Ops support for Sales, Finance and Supply chain BI applications.
• Tuning & Performance improvements in ETLs and Queries, business reports
• Proficient in evaluating Predictive & Forecast Analytics and resolving business challenges by collecting, reviewing and analyzing business process information.
• Project Management, Globally Distributed teams, Team building and Delivery/Ops solutions.
• Generate the Project metrics and Operational metrics.
• Involved in Security & Data Governance and Best practices.
• Involved in end to end delivery solutions on Telstra & Cisco major initiatives/Projects - Operations, IDM to TDM migration, Micro strategy to Business Objects, AM Migration, CCW by using SQL Server, Oracle, Teradata, Informatica, SQL, PL/SQL, BTEQs Business Objects, & Erwin.