.Balaji K Gopalan, PMP

**-** ****** ******, #**, Flushing, NY 11355

adgnb9@r.postjobfree.com; 917-***-****

PROFESSIONAL SUMMARY:

A strong data analytics leader experienced in Data Analysis, Data Migration, Data Visualization, Data Warehousing, Business Intelligence, Project Management, Delivery Management, Presales support, Program Management. Expertise include:

Planning Program Roadmap, Project Sprints and WBS for various projects within the program portfolio.

Report to senior management and PMO regarding project statuses and progress.

Mentor and oversee project resources.

Being the primary POC for project / resource issues.

Managing and maintain client stakeholder relationships.

Design and develop project artifacts for expanding business footprint and contribute to multiple projects across the portfolio.

Monitor new and evolving requirements and oversee intelligent architecture evolution.

Actively manage source to target data mapping, data migration, data transformation, data validation using appropriate data testing strategies, data extraction and data visualization for BI, EI and DS systems.

Act as a liaison between tech partners and customers/end users in developing user friendly help desk personnel, and product documentation.

Ability to orchestrate multiple projects and manage client delivery.

Form and mentor team members as needed and establish a highly dynamic team environment and encourage members to own and champion various aspects of product development. PROFESSIONAL EXPERIENCE:

May 2019 – Sept 2020, Sabbatical

Took a sabbatical from professional life and volunteered for multiple not-for-profit organizations promoting human welfare and world peace.

Jan 2019 – April 2019, Development Manager, R&D EDL Projects Johnson & Johnson, 920 US Hwy 202, Raritan, NJ 08869 Tech Stack: Apache Spark, Kudu, Cloudera 5, Tableau, Qlik, SQL Server, Oracle, Amazon RDS As a deputy general manager for the Johnson & Johnson account for Birlasoft, responsible for managing multiple EDL projects including GSDL (Global Safety Data Lake) project, LIFT

(Labelling Information for Tracking) project, EP (Established Products), overseeing requirements gathering and elicitation, reviewing solution architecture and detail design, recommending architectural improvements, managing onsite and offshore teams, optimize resource allocation in a matrixed environment, conduct regular status meetings, understanding revenue forecast and expectations for the account and making strategic recommendations to maintain and grow the account, managing clients and contractors.

Jan 2018 – July 2018, AWS Security Controls Implementation Manager CACI, 14360 Newbrook Drive, Chantilly, VA 20151

Tech Stack: AWS Workspaces, EC2, EMR, Cloud Trail, Cloud Watch, Splunk, Python, Spark, Hadoop, Tableau, Qlik, Redshift, Oracle RDS, SPSS, SAS As a part of the CMS (Center For Medicare and Medicaid Services) MIDAS project, participated in guiding and managing the end to end implementation of the ARS 3.1 security controls for the

.Balaji K Gopalan, PMP

42-60 Colden Street, #2B, Flushing, NY 11355

adgnb9@r.postjobfree.com; 917-***-****

MIDAS project components – AWS EC2, AWS EMR, Tableau, Qlik, Amazon RDSs(Redshift, MySQL), SAS, Cognos, Kong API etc. In order to migrate the MIDAS system from the existing data center to AWS cloud, all the AWS components involved in the MIDAS project needed to be verified and validated for security compliance, prior to receiving an ATO (Authority to Operate). The security controls were implemented on time to complete third party validation of the secured cloud environment that will host the migrated application. The management and delivery approach of this crucial project was duly recognized by the senior management. Oct 2016 – July 2017, Big Data Principal Consultant / Solution Architect Round Tower Technologies, 5905 East Galbraith Rd, 3rd Floor, Cincinnati, OH, USA

Tech Stack: Big Data Ecosystem (Hadoop, Cloudera, Hortonworks, Spark, NOSQL) As a Big Data Principal Consultant, focused on presales consulting for multiple clients in the East Coast across various domains including Healthcare, Publishing, Manufacturing, Data Resellers and Finance by proposing big data solutions, data lake road maps, conducting data science POCs using Data Robot, developing technical materials for training in the big data ecosystem and developing big data artifacts for executive briefing. Apr 2016 – Sep 2016, Big Data Consultant, Apache Hive, Apache Pig G. Krishnan LLC, Flushing, New York 11355, USA

As a training consultant, worked in developing big data training materials for Apache Hive and Apache Pig.

Dec 2015 – March 2016, Big Data Technical Project Manager American Express, 3, 200 Vesey Street, New York, New York, USA Tech Stack: MapR, Pig, Hive, Shell Scripting, MS Excel As a technical manager for a six-member team, led the data migration phase of Performance Marketing Project within Risk Management group at American Express. This role was closed due to budget cut within two months.

Aug 2013 – July 2015, Big Data Analytics, Chennai Delivery Head / COE Lead Tata Consulting Services, 415/21-24 Kumaran Nagar, Chennai 600119, Tamil Nadu, India Tech Stack: Big Data Ecosystem (Apache Hadoop, Hive, HBase, Pig, Spark, NOSQL) As Delivery Head: Managing a large horizontal team comprising a delivery manager, project leaders and developers in the Big Data lab, developing a roadmap for the Chennai Delivery Center, identifying key use cases for Banking, Airlines, Telecom, mentoring the team members in understanding the requirements for those use cases to build POCs using the Hadoop Clusters and corporate Cloud, collaborating with multiple vertical client accounts to study their business processes and recommending adoption of big data solutions, collaborating with DTCC account in studying their BI processes and deploying members for building MPP database solutions, collaborating with Morgan Stanley account in understanding their pain areas related to server log analysis and deploying a five-member team to develop machine learning models and building analytic solutions, collaborating with the Tata Communications team in studying their requirements and deploying a two-member team to build a big data solution, visiting Elisa Telecom in Helsinki, Finland (on invitation from the CEO of Elisa Telecom) and building a roadmap to meet their immediate goals of license fee savings by offloading their data from Netezza to Hadoop, providing pre-sales technical support for pursuing new Big Data opportunities across verticals.

.Balaji K Gopalan, PMP

42-60 Colden Street, #2B, Flushing, NY 11355

adgnb9@r.postjobfree.com; 917-***-****

As a Lead for Big Data Assurance: Developing a one-year road map for building the Big Data Testing COE, providing guidance for building Hadoop functional testing and Hadoop performance testing handbooks, developing a methodology for converting the process handbook into technical artifacts, facilitating training in Big Data and collaborating with a retail client to develop thought leadership in Big Data Test Automation, attending the National Software Testing Conference 2014 and coming up with recommendations for implementing big data testing approaches as per industry best practices.

Sept 2012 – May 2013, Technical Project Manager, National Levee Database Project US Army Corps of Engineers, Booz Allen Hamilton, McLean, VA 22102 Tech Stack: Oracle 11g, Java Script, Oracle APEX

Conducting daily scrum, developing project schedule estimates, redesigning media file submission process, overseeing promotion of new releases across dev, test and prod. May 2011 – September 2012, BI Development Lead, EMDS Project US Army, Crystal City, Arlington, VA 22022

Tech Stack: Oracle Database 10g, OBIEE 10g/11g

Studying the existing Enterprise Management and Decision Support (7.2x) system, building an enhanced BI system using Oracle 11g, Composite software and OBIEE 11g. Received Booz Allen Hamilton’s Performance and Team Award.

April 2010 – May 2011, BI Dashboard Architect, ICE Secure Communities Project Department of Homeland Security, Washington DC, USA Tech Stack: Oracle Database 10g, Oracle Hyperion Interactive Reporting 11 Building the data transformation layer, building the Interoperability Dashboard, setting up the development server, importing interoperability data, developing SQL scripts for data transformation, developing the functional and technical design documentation. Received Booz Allen’s Performance and Team Award for speedy delivery. Nov 2009 – Jan 2010, BI Team Lead, ORBIT Project

Environmental Protection Agency, Mclean, Virginia

Tech Stack: Oracle 10g, SAP Business Objects XI 3.1 As a team lead, participated in developing BI reports using SAP BO XI R3, mentoring the team on technical enhancements to the data layer, participating in design meetings related to BO Universe enhancement, data analysis and report generation.

Feb 2008 – Sept 2009, BI Team Lead, Physical Disability Agency, Walter Reed Army Medical Center, Washington DC. Managed the migration of the PDES system from Oracle to SQL Server. Dec 2007 – Jan 2008, Data Modeler, MCC Project, Mclean, VA. Built the data model for the MCC Mar 2007 – Oct 2007, Development Lead, CRS/CRC/WWE Projects, QBE Insurance, Sydney, Australia. Designed, developed and tested the Claim Risk Segmentation web tool, Compensation Rate Calculator (CRC) and Wage Wizard engines using Excel VBA. Feb 2007, Data Architect, Mid-Office Reporting Project, CITGO Petroleum, Houston, Texas, USA. Supported mid office reporting for Citgo by developing a detail design for data ingestion into SAP BW and designing the data flow across multiple layers. May 2006 – Nov 2006, Data Mining Team Lead, First Responder Project, SPAWAR (Space and

.Balaji K Gopalan, PMP

42-60 Colden Street, #2B, Flushing, NY 11355

adgnb9@r.postjobfree.com; 917-***-****

Naval Warfare), Charleston, North Carolina. Conducted a study for identifying critical needs of the First Responder community, developing a methodology to evaluate data mining tools like SAS Enterprise Miner and SPSS Clementine in supporting the First Responder community. Feb 2006 – Mar 2006, Data Mining Prototype Project. Performed predictive analytics on criminal investigation data extracted from NIBRS (National Incident Based Reporting System) using MINITAB.

Nov 2005 - Jan 2006, Booz Allen Hamilton, McLean, VA. Supporting technical portions of the business proposals related to Data Analysis using SPSS. Dec 2001 – Oct 2005, Data Mining Lead / DW User Support / BI Analyst, eMedNY Data Warehouse Project, Computer Sciences Corporation, East Greenbush, New York, USA. Executed a data mining project to detect sequential patterns in claim diagnosis for the Office of the State Comptroller. Supported state users with developing BI reports and OLAP cubes using BI Query, BI Analyze, BI Cube Creator.

Mar 2001 – Aug 2001, ETL Conversion Specialist, Cigna, CT. Support ETL development. May 1998 – Feb 2001, Programmer System Analyst, Allstate Insurance, Northbrook, Illinois. Developed programs to support the All State Datawarehouse. March 1998 – May 1998, System Analyst, CNA Insurance, Chicago, Illinois. Developed IBM Mainframe scripts to support jobs.

December 1997 – March 1998, Systems Analyst, American Stores, Chicago, Illinois. Supported IMS testing.

November 1995 – August 1997, Systems Analyst, John Deere Health Care, Moline, Illinois. Developed and maintained COBOL programs to support TennCare Claims data. Jan 1995 – Oct 1995, Programmer Analyst, Complete Business Solutions Inc., Farmington Hills, Michigan. Underwent three months training, supported business rules analysis for a Y2K project for Ford and a Telecom client.

EDUCATION

M.S., Applied Math, 1/92 – 12/94, Long Island University, Brookville, New York. GPA = 4.0/4.0. B.S., Computer Science, 8/87 – 5/91, Adelphi University, Garden City, New York. GPA = 3.7/4.0. Received the Mary Louise Buchanan Award for Computer Science upon graduation. PROFESSIONAL AWARDS/CERTIFICATIONS

Project Management Professional (PMP), Jan 2013 - Present Performance and Team Award, Booz Allen Hamilton, March 2011 & Dec 2011 Absolute Personal Best Award, Booz Allen Hamilton, Dec 2009 MS SQL Server (Exam I & III), 2009

SAS Base Programming, 2006

ACADEMIC AWARDS/HONORS

Trustees Achievement Award, Adelphi University, 1987-1991 Dean’s List, Adelphi University, 1987-1991, The National Dean’s List, 1990 HEOP (Higher Education Opportunity Program) Scholarship, Adelphi University, 1990

Contact this candidate