Anshul Mehediratta
Shrewsbury,MA
Summary
Energetic and accomplished technical leader with over 14+ years of professional experienced in design, development, implementation, and maintenance of various Databases in various domains like Healthcare, Finance and Marketing Solutions. Proven ability and expertise in processing huge data, performance tuning, automation of data processing, as well as, developing and automating ETL processes Experience in managing and delivering cloud Projects
Overview
13
13
years of professional experience
1
1
Certification
Work History
Lead Database Developer
Data Axle
12.2015 - Current
- Led built and managed a cross functional team of 4-6 engineers with heavy focus on cloud migration and data warehouse implementation on cloud.
- Involved in database development by creating Oracle PL/SQL Functions, Stored Procedures and Packages.
- Extensively worked in AWS environment for Implementing new health care Client.
- Worked on creating the external tables from Athena to Redshift.
- Designed and developed functional Data Lake on AWS S3 that allows large scale ingestion of
- Raw health care date files to facilitate ad hoc querying using Redshift, S3.
- Built cloud-based Data Lake AWS to provide data analytics and machine learning services for a global financial client.
- Extensively worked creating Airflow Dag’s using Python for running the Automation of the jobs.
- Responsible for analyzing Requirement Documents and converting Functional Requirements into Technical Specifications.
- Worked in a Scrum Team to implement the Various Change Requests.
- Responsible for Conducting code reviews and ensure that proper Developers Checklist is there.
- Develop and automate ETL processes using Talend, PL/SQL.
- Write backend SQL, VBA, ftp control, Perl, and batch scripts for automated load processes and custom reporting.
- Successfully Designed the Campaign and Appointment Process using AWS cloud Technologies
- (AWS-S3, Redshift, Lambda)
- Leverage Amazon Web Services for implementation of a financial client.
- Worked on running the Raw Files through DP, Hygiene Process and Matching.
- Extensively used Partitions & Hints and created materialized views for faster data retrieval
- Created Various Reports by creating complex SQL queries
- Created Various jobs for Ad hoc Customer Matching Process.
- Developed various Shell scripts & SQL scripts to automate data processing.
Sr. Software Developer
Randstad Technologies- Client Cigna
06.2015 - 12.2015
- Analyzed the Business requirements of the project by studying the interface Control document.
- Gathered business requirements and worked with Client/BA’s to create functional and technical specifications.
- Worked on AWS Environment to develop Cigna claim System
- Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
- Extensively used advanced features of Oracle such as bulk SQL, Partitions, CTAS for effective and efficient coding.
- Created Various Reports by creating complex SQL queries as part of Prod Support.
- Involved in creating SQL Scripts for new ASO company Set ups.
- Involved in Creating Procedures to Remove the Hold from the claims.
- Develop and automate ETL processes using Informatica.
- Extensively worked on Unix Environment.
- Created Error handling Procedures in Shell scripting for SQL errors.
- Loaded data into database tables from flat files using SQL * Loader utility.
- Worked with Bulk Collects to improve the performance of multi-row queries.
Software Developer
UST Global - Client Vangaurd
06.2014 - 05.2015
- As a Middle office Developer was involved in Requirement Analysis, Preparing Functional and Design Specifications.
- Wrote complex SQL Queries in resolving trade discrepancies caused from trade failures, breaks, etc.
- Extensively worked on Creating various SQL scripts for configuring CTM Profile and Matching
- Configuration on Trade flow.
- Written Procedures and database triggers for the validation of input data and to implement business rules.
- Created indexes on the tables for faster retrieval of the data to enhance database performance
- Created database objects like tables, views, Materialized views using Oracle tools like SQL Developer and Toad.
- Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
- Involved in Working on TIBCO Designer for implementing the new Fixed Income Trade Fields and deploying it in TIBCO Administrator.
- Worked on Data Pump and Export/Import Utility.
- Coordinate with front office and other support teams, locally and globally, to address trade related enquiries and issues.
- Extensively Involved in Dropping Equity and Fixed Incomes Trades by MQ Tool and Debugging the Issues.
System Engineer III
Ikasystems Corporation
04.2010 - 06.2014
- Created various SQL and PL/SQL scripts for verification of the required functionalities.
- Loaded traffic data logs into staging tables using SQL * Loader and shell scripts.
- Analyzed, designed, and developed reports, procedure, and functions for billing modules.
- Modified existing codes and developed oracle Reports, PL/SQL packages to perform Certain Specialized functions/enhancement on oracle Application.
- Extensively involved in Ordering/Loading/Forcing of Control-M jobs or tables into the schedule, monitoring of schedule to include fixes or escalation.
Education
Master's - Computer Science
New York Institute of Technology
New York05.2008
B.Tech - Information Technology
Kurukshetra University
Haryana ,India06.2004
Skills
PL/SQL(Oracle,Redshift), SQL Server, PERL,HTML, Athena, Redshift Spectrum, Glue, Lamba, PySpark
Airflow, Python, Talend, Informatica, TIBCO, SSIS, SSRS, Control-M, Shell Script, Oracle11g/12C/19C
Project planning and estimation, Decision making, Resource and budget Management, Mentoring,
JIRA Prioritization, Project delivery, People management, Agile Methodology, Team building (onsite and offshore)
Certification
- Oracle Certified Associate SQL certification (IZ0 007)
- Oracle Certified Associate PL/SQL Developer Certification (IZ0 147)
- AWS Associate Certified.
Timeline
Lead Database Developer
Data Axle
12.2015 - Current
Sr. Software Developer
Randstad Technologies- Client Cigna
06.2015 - 12.2015
Software Developer
UST Global - Client Vangaurd
06.2014 - 05.2015
System Engineer III
Ikasystems Corporation
04.2010 - 06.2014
Master's - Computer Science
New York Institute of Technology
B.Tech - Information Technology
Kurukshetra University