Hi, I’m
JAYAKANTHAN LAKSHMANAN
Eagan,Minnesota
Summary
A highly motivated and goal oriented Senior Data Engineer with 10+ years of experience in building data intensive applications, tackling challenging architectural and scalability problems, collecting and sorting data in the HealthCare, Banking field. Dedicated software professional with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
12
years of professional experience
1
Certification
Work History
Employer: Synapsis Inc / Client: Optum(UHG)
Senior Data Engineer
02.2021 - Current
Job overview
- Responsible for building Data Warehouse solution by combining data from multiple sources
- Collaborated with business teams to produce customized data solutions for specific goals
- Contributed to internal activities for overall process improvements and efficiencies
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Wrote and optimized in-application SQL statements.
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
- Responsible for highly critical production failure recovery.
- Built table structures following different types of data modeling techniques
- Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
- Utilized code versioning systems such as GitHub to reduce development times.
- Developing DS jobs to acquire data from source systems into Staging, Repository and converting into meaningful data for business reporting
- Compiled, cleaned and manipulated data for proper handling.
- Directed data transformations and transitions using Data Stage
- Performing data quality analysis and data cleansing to remove inconsistencies
- Performing Unit Testing, System Integration Testing to ensure ETL logic aligns with requirement
- Mapping data between source systems and warehouses.
Employer: Randstad / Client: Wells Fargo
Data Consultant
02.2020 - 02.2021
Job overview
- Mapped data between source systems and warehouses.
- Validated warehouse data structure and accuracy.
- Developed and modified programs to meet customer requirements.
- Collaborated with multi-functional roles to communicate and align development efforts.
- Tested software applications and systems to identify enhancement opportunities.
- Monitored and troubleshot data source systems for data flaws and errors and upstream data issues.
- Handled massive quantities of business intelligence data
- Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results.
- Developed and enhanced reports connecting to single or multiple data sources to improve performance.
- Maintained existing applications and designed and delivered new applications.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements.
Employer: Randstad / Client: Optum(UHG)
Data Engineer
09.2018 - 02.2020
Job overview
- Collaborated with different teams on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Created working design and Proof of Concept using Alteryx
- Assisted software engineering team to develop solutions in Agile environment.
- Perform root cause analysis to resolve production failures
- Documented technical specifications and related project artifacts, including solutions-oriented design across data warehouse
- Performed large-scale data acquisition, conversions, integration into data warehouse
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Explained data results clearly and discussed how it can be utilized to support project objectives.
- Aided with development of presentation layer for custom reporting and business intelligence.
- Built and maintained enterprise ETL processes using Data Stage, Alteryx
- Carried out day-to-day duties accurately and efficiently.
- Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
Employer: Infosys / Client: Prime Therapeutics
Senior Data Analyst/QA Analyst
09.2014 - 08.2018
Job overview
- Created the entire end to end frameworks for all the layers using the Metadata and the master control tables
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Interpreted business questions and collaborated with engineering teams to identify data sources.
- Performed the DBA activities to see the performance overload on the database and optimizing accordingly
- Created Universes and reports in Business object Designer
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
- Implemented test scripts and recorded results.
- Proved successful working within tight deadlines and fast-paced atmosphere.
Employer: Cognizant / Client: Lloyds Banking Group
Programmer Analyst
07.2011 - 10.2013
Job overview
- Performed regression and system-level testing to verify software quality and function prior to release.
- Tested functional and compatibility of new programs or updates in comparison to existing applications.
- Authored and maintained well-organized, efficient and successful manual/automated test cases for entire team.
- Advised developers on problems with databases, performance and other issues.
- Debugged code and located root causes of problems by reviewing configuration files and logs.
- Worked alongside management to develop testing and improvement plans.
- Developed and executed comprehensive test plans and workforce breakdown structures for complete systems.
- Defined test strategy to lay out the testing path
- Created accurate and successful test scripts to manage automated testing of certain products and features.
- Reported test findings to development personnel, advising staff on efficacy of subsequent remediation attempts.
- Published diagnostic findings as reports to inform stakeholders of product performance.
Education
AAM Engineering College (Anna University)
Master of Computer Applications
2010
BCSM (Bharathidasan University)
Bachelor of Computer Applications
2006
Skills
- Cloud Technologies - AWS
- ETL Tools - Data Stage, Alteryx
- Databases - Snowflake, Teradata, DB2, Netezza, SQL Server, Oracle, Hive
- Visualization/Reporting - Tableau, SAP Business Objects, OBIEE
- Virtualization - Denodo
- Monitoring Tool - Apache Airflow
Certification
- AWS Certified Cloud Practitioner
Timeline
Senior Data Engineer
Employer: Synapsis Inc / Client: Optum(UHG)
02.2021 - Current
Data Consultant
Employer: Randstad / Client: Wells Fargo
02.2020 - 02.2021
Data Engineer
Employer: Randstad / Client: Optum(UHG)
09.2018 - 02.2020
Senior Data Analyst/QA Analyst
Employer: Infosys / Client: Prime Therapeutics
09.2014 - 08.2018
Programmer Analyst
Employer: Cognizant / Client: Lloyds Banking Group
07.2011 - 10.2013
AAM Engineering College (Anna University)
Master of Computer Applications
BCSM (Bharathidasan University)
Bachelor of Computer Applications
Similar Profiles
Amit MishraAmit Mishra
Senior Software Engineer at Persistent Systems Ltd. (Client- Optum, UHG)Senior Software Engineer at Persistent Systems Ltd. (Client- Optum, UHG)
Tanya HarmonTanya Harmon
Customer Service Representative-REMOTE at UHG/OPTUMCustomer Service Representative-REMOTE at UHG/OPTUM
KRISTIN GREENKRISTIN GREEN
Prior Authorization Department - Escalations Team at UHG/Optum RxPrior Authorization Department - Escalations Team at UHG/Optum Rx