Data Engineer Database Developer

Sunil Keshri Email: ***********@*****.***

Linkedin: https://www.linkedin.com/in/sunil-keshri-71488225 Mob: +(1-786-***-**** EDUCATION

Birla Institue of Technologies Mesra, Ranchi, India Master of Computer Applications(MCA) June, 2006

SKILLS SUMMARY

Domain: Insurance, SCM, Banking & Finance, HRMS.

Architect: Database and Application designing.

Database: Oracle, SQL Server, DB2, Mongo DB. Generating and interpreting Trace files, SQL/PLSQL performance tuning, JSON webservice integration with the database.

Programming: Database developer - Advance PLSQL using collections and object-oriented programming,

Python (Programming, NumPy, Pandas, libraries), C#, Azure Data Factory, SSIS, SQR reporting, JSON, XML, Unix Shell scripting.

Well versed in ETL, Data Migration. Code Conversion and Datawarehouse processes.

Data Engineer: Ingest, Transform & Load, data orchestration, data storage, validations, reconciliations, logging, reporting, scheduling data movement processes and pipelines.

Cloud Technologies: Azure, ADF, Azure Synapse, Azure functions, event grid, power BI.

Scripting: UNIX Shell scripting.

Mainframe: Creating jobs using JCL’s, SAR reports, Endeavor job, code versioning, PBS Jobs and job monitoring.

ERP: Oracle EBS (SCM), Oracle PeopleSoft. Hands on experience on Oracle forms.

Job Schedulers: Automic, Octopus, AutoSys, $Universe, Oracle Scheduler, CRON Jobs,

Mainframe.

Soft Skills: Excellent verbal and written communication, continuous learning.

Process: Agile, ITIL (Incident, Problem and Outage management), Release planning, knowledge base creation, participating in Hackathons for knowledge sharing. WORK EXPERIENCE

Created efficient database and application design and enhanced existing design which drastically increased data availability, integrity, correctness, visualization and audit in the form of logging.

Built efficient data conversion process.

Created end to end ETL process to migrate data to the live database from distributed environment and data sources, reducing migration time to 70% and accuracy to 100%.

Created ETL process to ingest data from multiple sources, transform and load process using data engineering concepts.

Refactored legacy code, increased performance of the processes by more than 50% and prevented data loss by 20%.

Automated monotonous works performed by the Ops and business, reduced human effort by 30% and support tickets by 20%.

Applied performance fix to the SQL’s, PLSQL and applications, increased performance by 40%.

Enhanced applications to integrate database with JSON webservices, which increased capabilities of the application to integrate with numerous external sources.

Data virtualization to publish data as a service, eliminated need of exposing databases.

Collaborated with PO, Scrum master and team members in the distributed environment to define project scope, understanding requirements, defining dependencies, ensure alignment with the business objective, fostering team work and achieving business goals.

Conducted in-depth research and analysis resulting in identification of the issue which helped in giving flawless deliveries.

Played leading role in transforming waterfall to the Agile framework.

Performed data analysis which reduced data loss and increased opportunity by 20%.

Performed automations which completely eliminated man hours in doing repetitive cumbersome tasks and housekeeping activities.

Tools

SqlDeveloper, Toad, Microsoft Azure Storage Explorer, Graph API, JSON and XML webservices, FileZilla, CIS Studio, FileNet, HTML2PDF, ServiceNow, SailPoint, Dynatrace, Microsoft SSIS, Corticon, SVN, TFS, Microsoft Visual Studio, AppDB, Kintana, DB Doppler, XML, PVCS, SVN, HP Mercury Quality center, Putty, Alliance, PeopleSoft App designer, Remedy, Rally, falcon,, Automic job, Autosys and

$Universe job monitoring tool, Sonar, Artifact, Jenkins, DB Artisan, DB Designer,, SQL*Plus, Data Virtualization using CISCO Information Server (CIS), Oracle Apps, Oracle PeopleSoft HRMS and Oracle Forms Builder.

PROJECTS

AssurTrack April 2020 - till date

Lead Developer Miami, FL, USA

Collaborating with business, operations, product owners, scrum masters and cross functional teams in performing requirement analysis, defining dependencies and estimations.

Responsible for database and application designing, advance PLSQL coding, creation of ETL/ELT process, integration, load testing, release management, code review and development of complex email templates using Html2pdf and FileNet.

Responsible for database integration with distributed database, external JSON webservices, Graph API and creating applications to bring data in the real time.

Responsible for maintaining Azure Blob storage. Pipeline creation using Azure data factory.

Responsible for performing data analysis using SQL queries, data reconciliation and publishing results in the form of reports for data visualization and making decisions.

Responsible for database re-architecture, code refactoring, code review, application, database and SQL performance tuning, automations, migration of Mainframe applications to Oracle, system upgradation and writing processes for Data warehouse.

Actively involved in performing coverage, performing bug analysis and fixes.

Responsible for providing support to the Business, Ops, QA and cross functional teams for business continuity. Providing technical guidance to the team members.

Played leading role in application migration to the R12. MAX – Credit card insurance August 2017 to March 2020 Lead Developer Miami, FL, USA

Responsible for designing database, application, ETL- data migration model and processes for Datawarehouse.

Developed a native ETL process to perform data migration from external sources to the Oracle database. The automated data migration process and increased process efficiency by 70%.

Responsible for code refactoring to migrate legacy code and jobs in mainframe system to the Oracle and Automic.

Collaborated in requirement gatherings, requirement analysis, estimations, solution analysis, working with business, ops and cross functional teams in addressing dependencies.

Responsible for PLSQL programming, maintaining database integrity, workflow creation, SQL and PLSQL performance tuning, automations, SSIS package creation, release plan creation, code review. Also created data reconciliation process to minimize data loss during data migration.

Played leading role in transforming waterfall to Agile model, process adoption and improvement.

Responsible for coordination with the offshore team to provide technical guidance. Service Configuration Management(SCM) Sep, 2013 -July, 2017 Technical Specialist Pune, Maharashtra, India

Collaborated in understanding complex requirements, data integrity, business impact and providing solutions.

Worked in Oracle EBS. Good exposure of Inventory, ordering management process, product configuration and install Base creation. Expertise in Q2O, quote creation, validation, Quote conversion process and Contract creation process.

Responsible for designing database and application, customizing Oracle Apps supplied procedures and packages, creating/maintaining jobs in Oracle Apps, applying performance fixes and optimization.

Worked in publishing data as a service using CIS (Cisco Information Server) Tool.

Responsible for supporting Business, Ops and QA for sustaining business.

Responsible for Problem management, Quality, maintaining SOX compliance, Code Release planning and coordination.

Responsible for migration of Oracle EBS to R12.

Client Reference data Dec, 2011 - Sep, 2013

ITA Pune, Maharashtra, India

Responsible for requirement gatherings, requirement analysis, requirement feasibility study, effort estimations and mapping it to FSD and TSD documents.

Responsible for database designing, creating and maintain PLSQL programs, UNIX shell scripts, defect fixes, automations and applying performance fixes.

Developed reconciliations process and reports.

Actively worked in Incident, Problem and Outage management.

Responsible for providing support to Business, Ops and cross functional teams to sustain business continuity needed for the Banking services.

Responsible for creating and maintaining Autosys Jobs critical for the banking system.

Responsible for executing project transition (from other organization to TCS).

Responsible for creating, maintaining knowledge base, grooming team members and team expansion.

Service Configuration Management(SCM) Feb, 2009 - Dec 2011 Senior Developer Pune, Maharashtra, India

Performed coding in Oracle advance PLSQL, customizing Oracle Apps SCM supplied packages and UNIX Shell scripts.

Responsible for developing new features and enhancing existing Quote to Order application such as Quote creation, Contract creation, Install base creation and management, etc.

Worked in enhancing, creating new features in CSCC, SmartCare Quote to Order creation applications, creation of install base, inventory management and supporting applications.

Actively involved in performing data analysis and creating reports used by the business and Ops for analysis, forecasting and making decisions.

Actively involved in creating and maintaining database objects.

Responsible for applying performance fixes to meet SLA, System Monitoring, administration, system stabilization.

Provided support to Business, Ops and cross functional teams for business continuity.

Actively involved in problem, incident and outage management. HRIT June, 2006 – Jan, 2009

Developer Pune, Maharashtra, India

Responsible for creating TSD, requirement analysis and providing solutions.

Performed customization of front-end application in PeopleSoft, SQR report generation, created SQL, PLSQL programs, applied bug fixes, automations, applying performance fixes, created complex SQR reports.

Actively involved in database design and creating and maintaining database objects and integrity.

Responsible for System Monitoring, administration and system stabilization.

Provided support to Business, Ops and cross functional teams for business continuity.

Actively involved in problem, incident and outage management, worked on SOX guidelines to adhere processes.

Played leading role in application migration from Oracle PeopleSoft to the Oracle HRMS.

CERTIFICATES

Microsoft Azure Data Engineer Associate (2024).

Microsoft Power BI Data Analyst Associate (2023).

SAFe (Scaled Agile Framework) (2021).

Microsoft – Implementing an Azure Data Solution (2021).

Microsoft Azure Fundamentals (2020).

Oracle Certified Associate (OCA) 9i (2010).

Oracle Certified Professional (OCP) 11g (2015).

Certified Scrum Master (CSM) (2015).

Parallel processing implementation in Oracle PLSQL (2016).

Professional Membership - Scrum Alliance, Oracle, Digital Architect Hackathon. AWARDS AND RECOGNITION

Received prestigious award from the client on presenting idea on promoting Renter’s business.

Star Award from the client.

Received many appreciations and recognitions.

Contact this candidate