Technology lead

Ayush khanna TECHNOLOGY LEAD Infosys Limited [phone] [e-mail]

PROFESSIONAL SUMMARY A motivated, adaptable, and responsible Senior Business Intelligence Lead looking for opportunities in Business Intelligence wherein I can fully utilize my potential & knowledge to fulfill the desired objective. IT professional with more than 7 years of industry work experience with around 2 years of experience in Big Data technologies Data Stage and Unix Consultant with 6 years’ experience in implementing different end to end BI solutions. Good practical knowledge of SAP HANA & SAP BODS. BIRST Experience of 2 years in implementing cloud based BI solution DB Experience – DB2, Oracle, Strong SQL writing Skills Certified Big Data Apache Spark (pySpark) professional from University of California, Berkeley Certified IBM professional in Hive, Machine Learning, Pig & MapReduce programming

Technical Skill set

Big Data Technologies Hadoop, MapReduce, Hive, Pig, Flume, Sqoop

ETL Tools DataStage, Quality Stage, Fast Track

Cloud Based Solutions BIRST (Admin, Designer and Dashboards)

Programming Languages SQL, PL/SQL, Python, pySpark, UNIX shell, VB Scripting

Databases DB2, HDFS, Oracle, SQL Server

Operating Systems Windows, Linux (Red Hat)

Software Development Methodologies Waterfall model, Agile model

Development IDEs Eclipse

SAP Good knowledge of SAP BW R/3, SAP BODS and SAP HANA

Centre of Excellence DataStage and Big Data COE Lead

CAREER: work and education

Dec 2015 – Feb 2016		TECHNOLOGY LEAD – Infosys Limited, Pune Client: Reckitt Benckiser Inc., London Reckitt Benckiser Group is a multinational consumer goods company headquartered in Slough, England. It is a producer of health, hygiene and home products Responsibilities: Working with Finance Director to transform the business requirement into Technical model Designing the workflow of ETL module for both EDW and SAP front Designing the bridge logic between EDW and SAP BODS Building the data model for SAP BODS and DataStage Leading BICC team and managing all communications between Business users and technical team Onsite and Offshore manager Providing Knowledge transition to different vendors and teams on the design and approach to build the solution
Jan 2015 – Dec 2015		TECHNOLOGY LEAD – [London, United Kingdom (Jan 2015- Aug 2015), Pune, India (Sept 2015 – Dec 2015), Jakarta, Indonesia (Oct 2015- Nov 2015)] Client: Reckitt Benckiser Inc., London Responsibilities: Worked very closely with finance business users to work on their needs and to materialize them into final results Collecting/Importing data into HDFS using Sqoop. Writing MapReduce programs in Python as per Client's requirements. Using Hive and Pig queries/scripts to segregate data for client to get business insights/analysis. Oozie to create workflows. Leading the Big Data team from BICC front Mentoring new team members, providing knowledge transfers.
July 2013 – Dec 2014		TECHNOLOGY ANALYST – Infosys Limited, Pune, India Client: Telenet Group Holding N.V. Telenet Group is the largest provider of cable broadband services in Belgium. Its business comprises the provision of analog and digital cable television, fixed and mobile telephone service Responsibilities: Importing data into HDFS from different locations using flume and Sqoop. Using HIVE / PIG to filter and segregate data as per business requirements taking into consideration different hierarchy, demographics, geographies. Writing MapReduce Python code for handling complex business requirements and running sentiment analysis. Using Sqoop to import/export data between HDFS and SQL databases when needed. Have also worked on Oozie to handle job workflows. Worked very closely with business to work on their needs and to materialize them into final results. Initial Analysis, feasibility and effort estimations for projects towards Infosys; as well as SPOC for the change requests. Technical-Consultant acting as a bridge between different development partners, release management and system engineering. Also, worked closely together with the offshore and other development partners to ensure timely delivery and quality maintenance of code releases
Feb 2012 – June 2013		TECHNOLOGY ANALYST – [Manchester, United Kingdom (Feb 2012 – Feb 2013), Pune, India (Mar 2013 – June 2013), Dubai, UAE (June 2013)] Client: Reckitt Benckiser Inc. Responsibilities: Working as EDW Lead & Architect in this project and building the data model and ETL Code for this project from both EDW and BIRST end Managing a team of 5 people at offshore and 3 people at onsite Providing the domain knowledge of Reckitt to different vendors Working with Business users during the go-live of this project Technical consultant for all DataStage, BIRST or UNIX related problems Vendor co-ordination Manager with Bluefin, Birst and Cervello Onsite offshore manager ETL Technical Lead
Apr 2009 – Jan 2012		SYSTEMS ENGIENEER/SENIOR SYSTEMS ENGINEER – Infosys Limited, Pune, India Client: Reckitt Benckiser Inc. Responsibilities: DataStage Developer – Ensuring the end to end completion of ETL jobs Creating UNIX scripts to schedule and perform ETL tasks Onsite communication with Technical Leads Preparing Technical Design documents for the given requirement from ETL Leads Performing Test cases on the ETL code and ensuring the end to end success of it Knowledge transition on Data Stage and UNIX to new recruits in the team
2004 - 2008		B.TECH Honors in Computer Science and Engineering Dehradun Institute of Technology – Dehradun, India

certifications and awards

Certifications Awards

Certified Data stage and DB2 Developer by IBM	Infosys Star in Business Intelligence [2009 – 2010]
UNIX Certified Professional in Infosys	Most Value Player Award in BI Domain [2010 – 2011]
Introduction to Big Data with Apache Spark Scalable Machine Learning with Apache Spark Big Data Certified Professional from Univ. of California, Berkeley, USA	Bravo Award in Business Intelligence [2012 – 2013] Always Rated Highest Appraisal rating (1+) in Infosys Published a Unix Based tool for Data stage Automation [2015]
CPG Retailing	Two Insta Awards [2015 - 2016]
Certified Cognos 10 BI Author
Certified Birst Professional in Admin and Designer (Exams: 101, 201 and 301) Certified Hive, Pig and MapReduce professional from IBM

References: Available on request