Ebi Jayakumar Email & Phone Number

New York, United States

Designed and developed the entire AWS environment from the ground up, including translating complex logic from existing models as well as designing the full warehouse layout using AWS Lambda, Glue S3 and Step functions.1. Developed Glue crawler to create the data catalog for CSV files and Redshift tables. 2. Developed the AWS Lambda functions to export the Delta data load to S3 in CSV format.3. Glue jobs were configured to load the delta data to Redshift tables.4. Step functions were put in place to run the Lambda functions and Glue jobs along with Error handling mechanism and Email notifications.

India

Technical offshore lead for BI/DW applications at Restaurant Brand International (RBI) leading a team of 5 members with primary responsibilities such as, • Taking ownership of customer issues reported and seeing problems through to resolution • Researching, diagnosing, troubleshooting and identifying solutions to resolve system issues• Following standard procedures for proper escalation of unresolved issues to the appropriate internal teamsIndividual responsibilities include but not limited to, • Managed SPLASH BI application supporting business users with new data requests, clarify questions related to sales numbers, new report requirements.• Developed Python scripts which helps in day-to-day monitoring. For example, Count of json files in S3 Bucket.• Worked in Informatica ETL development • Created Business Objects reports for business users• Analyze data in AWS Redshift DW for a. Data duplicates in sales detailsb. Data validation failures based on business rulesc. Source file issuesd. Unavailability of source datae. Data format issues and inform the source vendor to send us the corrected information.• Monitor scheduled Tidal jobs• Troubleshoot any issues in Informatica jobs and take action based on criticality of the job.• Monitor AWS Glue and Step functions • Query AWS Athena to check we have day -1 sales for expected restaurant threshold to report for executive scorecards. • Create new Tableau reports that help in monitoring the DW & creating Data sources for data requests from business users• Attend change management meetings and present change management plans for any new deployments.

Waukegan, Illinois, United States

Implementation Project Manager for large scale programs in multiple ITO’s (AbbVie – R&D Data and Statistical Sciences and Clinical Pharmacology), spearheading project planning, implementation and overseeing project teams (PWC, Deloitte) in application migration from the current Abbott Data Center to the new AbbVie Data Center. Manage all key stakeholder relationships and cross -functional project teams up to 40. Utilized Waterfall and Agile project management strategies, depending on migration wave. 100% of migration waves were completed on time and achieved intended outcomes.• Creating a detailed schedule and plan for application migration• Identifying the various platform dependencies for the applications• Coordinate stakeholder discussions to review the plan and approach for migration• Schedule and track the various activities required pre and post migration on a day-to-day basis• Coordinating communications with all the business stakeholders’ pre and post migration• Documented Lessons Learnt and worked with migration coordinators to improve the migration process• Mitigated risk factors through careful analysis of financial and statistical data.• Achieved seamless migrations and integrations that were transparent to client customers, accomplished with no unscheduled downtime and delivered within the budget.Gathered Business Requirements for Operational Data Store and documented the Analysis of the legacy system and defined the proposed system to meet the business requirements and implement ODS solution.• Assessment of requirements for the operational data store to improve trial performance visibility and resolution of site level operational data issues, and compliance issues• Development of AbbVie-wide clinical development performance indicators and governance to proactively manage clinical trial performance

Delivery Management System, here after referred to as DMS, which runs on Microsoft SQL Server 2008 and .NET Framework 4.0. This project involves maintenance of SQL Server, Data and File archival. 1. File archival and make sure all the subscribers have completed the final sync and transactions have been committed to data servers at home office.2. As a result of SQL Server lock and result of data discrepancies in multiple delivery office, implemented review maintenance process to validate the following tasks, A. Reorganize index B. Update statisticsC. History cleanup D. Rebuild index

• Identifies client needs and customizes programs and applications• Once the customization has occurred, ensures that the application is properly integrated into client’s existing information technology infrastructure• Performed application/performance engineering, capability studies, and server sizing to expertly deploy BWIR specific applications such as its .NET framework, SQL Server replication, check factory tool integration, and MSMQ configuration tool• Worked extensively with rapid fire framework which is a reusable component developed for Data connectivity, Encryption/decryption of business sensitive information• Assist in drafting documentation and software manuals for end-users.