Anup Saxena

Anup Saxena MCA, M.Tech,Phd (persuing , IIIT A) Email :-Contact - Introduction Strategic Minded and result driven IT professional with a career marked by documented achievements, strong business and technical acumen with 18+ years of IT experience in Leading large implementation, Projects and teams. Experience in providing direction to utilize a strategic approach to achieve organizational goals through the use of right kind of technology, tools, human resource and processes and use of data to measure, track and achieve those goals. Work with all levels of organizational hierarchy to translate business needs to data and information resources. Lead data acquisition, design, and model and analyses effort to transform data into enhanced decision making capabilities. Professional Synopsis Strong leader, manager and team player with the ability to persuade stakeholders at all levels to drive business with data and analysis. Having strong passion for data and analysis based decision making. Certified in various Analytics and BI programs. Knowledge of and experience in IT, data, Analytics and BI architecture, infrastructure and solution design, data visualization. Having strong hands in advance data access, Data integration, Extraction, Storage, Data modeling and reporting/analytic tools and methods as well as database development and design technologies, including SQL server, MySQL, Oracle, Designer, Erwin, Visual Studio, Jreports, SSRS and Power BI. Excellent understanding of Big Data technologies like Hadoop Map reduces, HDFS, HBASE, Pig Latin, HIVE etc. Strong presentation, communication and influencing skills with ability to work, collaborate and cultivate win-win relationship at all levels of an organization. Excellent team building, coaching and mentoring skills. Expert in implementing Power BI solutions using both Direct Query and import methods. Excellent skills in DAX queries. Experience in SDLC projects using Oracle, PL/SQL, Perl, Centos, Ubuntu, Linux, Pro*C, Forms, Reports, Designer, DWH using ETL tools like Informatica and BO. Managed Project using BI tools SSIS, SSRS, SSAS 2012 rel2, Excel Power Pivot, Jreport, and Power BI. Good programming exposure in ‘R’ & Python programming for Data Analytics (Regression, Clustering, Trees, Time Series, Association mining etc.). Good understanding in Deep Learning Model e.g. ANN, CNN, RNN, LSTM ,Tensorflow , keras. Domain Expertise in Life and Non life Insurance with Special expertise in Implementation of Reinsurance Processes and Products. Onsite experience (UK) of approx. 2 yrs. for project implementations. Certifications Insurance Foundation Course (IFC), Chartered Insurance Institute, London. GIOS (CGI), Bristol Certified Professional with Merit. Certificate in Advance Data Analysis in Management from IIT, Delhi. Certificate in Predictive Analytics from IIM, Bangalore. Certificate in Python for Data Science from eDX(DataCamp). Certificate in Deep Learning from Udemy. Certificate in Machine Learning from Kaggle. EXPERIENCE Company: GarudaUAV, Noida (08/2018 – current) Sr. Consultant Data Analytics & Machine Learning Currently Involved in Image processing Piece for Automation of Reporting Process using computer vision. Company: Icreon Communications (08/2016 – 08/2018) Sr. Data Architect BI & Analytics COE Hired to provide leadership and direction in setting up BI & Analytics Centre of Excellence in the company. Provide leadership and focus in increasing Data Analysis and Advance Analytics to positively affect and directly influence the presence of company in the global market. Mentor junior developer on career development and Business Intelligence tools and technologies. Designed and implemented BI Reporting and Analytics solution for four Major U.S & U.K clients using Power BI, Jreports, Analytical models using ‘R’ and ‘Python’ . Created a comprehensive documentation on various models to implement in power BI for various clients as per their business needs. Mentored developers for designing and developing Recommendation Engine for a TV channel using python’s scikit toolkit (using Collaborative and content based filtering using Cosine and Matrix factorization methods). Mentored developer to implement Time series and regression model for predictive analytics for one of U.S based client using R programming. Designed a recommendation engine for recommending the learning items to the users based on their past behavior of learnings and scores using Association mining technique in R for a LMS used by a big telco customer. Company: Opallios Inc. (10/2014 – 05/2016) Technical Manager/Big data consultant (Big Data Practice) Project: Network Log Analysis (Hadoop) This project was to create an alternate framework other than ELSA using Hadoop stack. It involves collecting various formats of network logs generated from different network devices, Process them on Hadoop clusters and store these logs in HBASE for further Analysis and reporting. R studio was used to perform Analytics on the stored data. Storing the log file into HDFS. Loading data into Hive table. Summarizing the data with Hive and pig. Generation of customer reports. Creation the 6 node Hadoop cluster environment by using Cloudera CDH4 version on Ubuntu boxes. Importing the data from various formats logs like JSON, Apache, netflow, custom logs to HDFS environment. Installation of Hadoop ecosystem components (Map Reduce, Hive, HBase, Pig) performance testing and benchmarks. Map Reduce program for Top Analysis of network attributes. Design for Hive tables and Queries. Visualization using R studio. Company: Opallios Inc. Technical Manager/Big data consultant (Big Data Practice) Project: ODE (Opallios distribution of ELSA) Defining new features for ODE as part of Core product development. Architecting /Design of Aggregate, Analytics functions and enabling ODE to accept various input format as sources viz syslog, Netflow, Json , Custom formats. Enabling product to accept both Streams and File as input source. Implementing Query module using Sphinx. Developing core functionalities. Implementing new features using Open source products available in market. Technical team mentorship. Implementing new features for various Platform like Ubuntu, Linux, and Centos. Distributions of ODE for Debian and RPM repository. Product maintenance and Support. Performance and Load Testing. Company: Opallios Inc, Noida Technical Manager/Big data consultant (Big Data Practice) Project: Red Vector & Herosoft Installation of ELSA pseudo and distributed Clusters for Red Vector. Technical mentorship for Client initiated customizations. Stakeholder in product development for “ODE”. Herosoft Application management and Support. Onsite Offshore Team Management. Handling Client escalation. Company: Corbus India, Noida (10/2011 – 10/2014) Project Manager (Business Intelligence Practice) Project – POC for big CPG customer Installation of Hadoop pseudo and distributed Clusters. Installation of PIG Latin, Hive and HBASE. Writing Hive and PIG script for storing and querying big data. Project - UK BI Reporting Client is a global leader in Media and advertising industry. The project was specific to Business Intelligence Reporting Needs of UK segment. There are Advertising Agencies having reporting needs specific to their customer. The raw data is provided by the different data sources. The raw data needs to be processed in the BI system to provide valuable information. The Major Modules of the System Includes ETL on Data sources, Data Quality, Instrumentation, Logging, Notifications, Reporting and Dashboard. Managed Implementation & Support, Handled Client Interaction, Requirement Gathering, Project planning, Estimates, UAT Sign off’s and Production movements. Handled warranty, Post production support SLA’s and Change request implementation. Responsible for ISO compliance and Audits.  Project - Reports and Audits Management System (RAMS) Client is global leader in talent Assessment utilizes industry leading research, predictive analytics and advisory services to clients. Client is having large number of heterogeneous Databases that has gained huge data over the years. Redundant Data Structures were prorogated. A new optimized structure for reporting to be created and a Data warehouse needs to be setup for that purpose. Managed Implementation & Support, Handled Client Interaction, Requirement Gathering, Project planning, Estimates, UAT Sign off’s and Production movements. Responsible for ISO compliance and Audits. Company: Qualtech Consultants, New Delhi (01/2009 – Oct 2011) Project Manager Managed the Functional & UAT testing for Implementation of LOS & LMS Modules of Indus System at Germany based Car Finance Company in Mumbai, main responsibilities includes Client Management, Test Strategy ,Test plan and Test Scenarios preparation and Status reporting and Reviews with Senior Management. Managed and implemented Reinsurance system at an Insurance Giant in Gurgaon was responsible for Vendor management, Functional Analyst for Interface creation with Finance, Claims and Actuarial dept and Treaty setup for Facultative and Obligatory arrangements with four Major Reinsurers. Submitted CBA report to senior management after Evaluation of Asset Management system for IT and Non –IT as a single solution. Submitted FSD’s and design for creation of IRDA Schedules and Reports from Data warehouse. Act as Technical Architect for Schema & DB Objects (Packages, procs, Function and DB triggers) Design using Oracle 10g, for Automatic loading of Valuation Extract from core policy system. Company: Nucleus Software, Noida (02/2007 – 12/ 2008) Associate Project Manager Managed Implementation & Support of Nucleus’s Cash Management Product Cash @ will at threes Major Bank’s, viz ICICI, Development Bank of Singapore and Allahabad bank in Mumbai Handled Client Interaction, Requirement Gathering, Functional Analysis, Project planning, Estimates, Monitoring, Control, UAT Sign off’s and Production movements. Handled warranty, Post production support SLA’s and Change request implementation. Responsible for CMM and ISO compliance and Audits. Company: Cognizant Technologies Services, Bangalore (08/2005 – 02/2007) Technology Specialist Worked on onsite Offshore Model for Cisco, Austin (U.S) as client. Handled the Development of Network support System using Oracle 8i and developer 6i as development suite. Lead a team of Fresher’s and brings them up the curve to deliver. Major responsibilities includes Requirement understanding , creation of BRD’s and FSD’s, Module Estimation, Development , Code and design reviews.SIT, UAT , CMMI process compliance and Audit support, Team mentoring and Appraisals. Provide Oracle development Supports for seven Application for this Account. Received Guiding Light Award from Manlog Vertical. Company: Xchanging Technologies, India (02/2004 – 08/2005) Senior Software Engineer Brought in Support of an Insurance product from Xchanging U.K to Xchanging India Provided the off shore support to Xchanging U.K. Responsibilities Includes Requirement Analysis, Design, Development (using Oracle Designer 6i Tool), Estimation, Reviews and provide technical guidance to the Team. Company: Royal Bank of Scotland, India (06/2001 – 01/2004) Lead Analyst Was involved in the development of two Major Insurance projects i.e. Broker Addition & New World policy System Majorly responsible for Design and development of the changes using Oracle PL/SQL programming, writing of Procedures, Packages, Functions and DB triggers. Also worked on UNIX and developed shell scripts for generating automated reports and mails. Company: IIS, Noida (05/1999 – 12/2000) Software Engineer Was involved with two Legacy Conversion projects ‘Utility’ & ‘Payroll & Finance’ System Majorly responsible Preparation of Functional Specifications documents, Understanding Unisys COBOL programs and converting the code in PL/SQL programming - Writing Oracle Stored Procedures, Functions and Database Triggers. Development of Prototypes, Forms module and Report Design. ACADEMIC QUALIFICATIONS M.tech In Computer Engineering (2014) From M.D University, Rohtak, Haryana with 78%. Master of Computer Application (1997) From K.N.I.T Sultanpur, U.P, with 72%. B.sc (Math’s, Physics), B.N Degree College, Kanpur with 67%.