Pankaj G.

Experience

• 

  Tech Mahindra

  Oct 2006 - Jul 2010

  Technical Associate/ Software Developer

  •Analysis & Study of Business Requirements, Technical & Functional Specifications, Interface Design Development, Testing, Integration, Implementation along with Service Support•Mainly responsible for Project participation on customization of ACBS Datamart product based on client requirement.•Participating in Requirement Refinement and gap analysis, Providing Development Estimates and Development of FDD & TDD.•Designing and developing Complex Reports using Business Objects (Web Intelligence & Desktop Intelligence) and Crystal Reports with various data sources.•Designing & developing required Databases, users, tablespaces & tables, Packages, Procedures, Triggers & Functions for ETL purpose. Tuning & Code Optimization of SQL packages, procedures & Functions •Imported and exported BIAR files for various clients (From 6.5 to XI and XI to XIR2).•Expertise over preparing report specifications, database designs to support the reporting requirements.•Responsible for liaising with business users and finalize on any enhancements/new requirements needed by reporting department.* Rising Star Award - August 2007 Show less

• 

  Tata Consultancy Services

  Feb 2010 - Feb 2012

  IT Analyst

  Business Intelligence Module Leader Involved in development , implementation and Support for SAP BO on SAP BW 7.0 Key role in design, development and delivery of BI Reporting solutions using SAP BW and SAP BusinessObjects for a Major Pharmaceutical Client.Lead the development team for SAP Dashboard solutions for a Major Pharmaceutical and manufacturing clientConducted feasibility of business process, requirement gathering and impact analysisManaged process walkthrough's with key stakeholders for sign-off and initiate gap analysis for to-be business processes Show less

• 

  Wipro

  Mar 2012 - Apr 2019

  Technical Lead

  Our client is one of the leading manufacturer of computing devices including Laptops and Printers. My Responsibilities includes - - Analyzing the requirements and working with Business Teams to create solution architecture.- Design and develop new enhancements for the Project in Hadoop/Talend and other technologies.- Engage with various stakeholders from Business to get the requirement and map them in forthcoming releases- End to End Implementation of components in Hadoop, Talend, Oracle, Unix Scripts, Informatica workflows and BOE reports- Requirement gathering, deciding the architecture, designing, programming and unit testing- Managing team of 6 resources and training them across all the technologies used in project.- Working on POC to present Hadoop components for specific requirements.Client : British American Tobacco - Technical lead of Business Objects Team Development and Support team overseeing a complex system of SAP Business Objects and SAP BW solution for British American Tobacco.- Promoting Thought leadership / Subject matter expertise. Formulating Technical/ Compliance Standards in SAP BI landscapes.- Design and implementation of Frameworks for BO Upgrades/ Rollouts, Performance Optimization of SAP systems.- Involved in testing of all phases (UNIT, IST & UAT) of BI system from extraction to the end user reporting and resolved issues.- Conducted Business Requirements Analysis workshops to assess the reporting requirements.- Prepared the business Blueprint and Functional Spec and analyzed the Business Content for the Gaps.- Designed and Prepared the Technical Spec to fit the business requirement.- Worked with onsite team and customers for quick resolution for all production issues- Trained other teams in BOE for bridging gap in communication across teams Show less

• 

  Amazon

  Apr 2019 - now

  • Data Engineering Manager

    Feb 2022 - now

  • Data Engineer

    Apr 2019 - Feb 2022