SUMMARY:

• Over 4+ years of experience in IT, with proficiency as application developer in health care domain and strong expertise in Teradata and SQL.
• Skilled in all phases of the software development lifecycle and e xperienced in designing, developing, integrating, and supporting corporate tools and applications.
• Experience in working with data modelling and ETL teams to convert logical data models into physical data models on Teradata warehouse.
• Extensively worked with Teradata utilities like BTEQ, TPT, Fast Load, Multi Load to export and load data to/from different source systems.
• Proficient in performance analysis, monitoring, tuning and optimized various complex SQL queries.
• Hands - on experience of Automation and Configuration Management using the principles of CICD.
• Use of Agile Methodology and the scrum process since 2015

TECHNICAL SKILLS:

Databases: Teradata 15.0, 14.10 (TTU), Oracle 9i, 10g, 11g

Languages/Scripting: SQL, PL/SQL, Shell Scripting (Linux/AIX), Python, SAS

Big Data: Hadoop/Sqoop

CICD Tools: Ansible, Jenkins, Udeploy, GitLab, Virtualized Cloud Servers

Version Control: GIT, SVN

Other Tools: TOAD for Data Analysts, SQL Assistant, Putty, Rally, CA WA Workstation, FitNesse, WinSCP, BASE SAS, SAS Enterprise Guide, Viewpoint

PROFESSIONAL EXPERIENCE:

Sr. Application developer

Confidential,CT

• Automated Jenkins builds, QA checks following CICD processes.
• Provisioned and configure virtual servers as per the application using Ansible as a service.
• Migrated BTEQ and Informatica jobs to GIT and Python framework.
• Participated in requirement gathering, data analysis, preparation of mapping documents, review meetings with business and working with data modellers for several projects.
• Involved in the analysis of test results, preparing test cases and test data, documenting the test results and participated in end-end testing activities.
• Coordinated work across various applications, operations as necessary to maintain or deliver the business solution.
• Enhanced SQL performance tuning by collecting/refreshing statistics and worked on performance tuning activities for table loads.
• Monitored query level and system level performance using Viewpoint.
• Drafted implementation plan, obtained all the approvals, scheduling jobs and complete all the necessary tasks for production releases.
• Worked with Information Protection team to draft Application Security Review (ASR) document and abide by the laws to meet the architectural goals for the projects.
• Have led various production releases, documented job schedules in runbooks and been involved in the analysis of production issues, proposing the solutions and post release validations.
• Worked with DBAs to connect a Teradata & Hadoop system to enable bi-directional data movement using QueryGrid.
• Successfully loaded data from different sources into Hadoop using Sqoop to implement tactical solutions.

Application developer

Confidential,CT

• Heavily involved in building out data mart.
• Participated in building a parallel database (DEV2) to Production, which involved masking PHI data from production and loading into the new database as per the business requirements.
• Actively participated in “Code-a-thon” and was part of the successful delivery of various reports for 1/1/2016.
• Participated in requirement gathering, data analysis, preparation of mapping documents, review meetings with business for several projects.
• Prepared various technical design documents.
• Developed various scripts using teradata utilities like BTEQ, Fastload, Multiload, TPT and also used SAS programming for migrating data from different legacy sources into Teradata.
• Involved in the analysis of test results, preparing test cases and test data, documenting the test results and participated in end-end testing activities.
• Enhanced SQL performance tuning by collecting/refreshing statistics and worked on performance tuning activities for table loads.
• Monitored query level and system level performance using Viewpoint.
• Drafted implementation plan, obtained all the approvals, scheduling jobs and complete all the necessary tasks for production releases.
• Have led various production releases, documented job schedules in runbooks and been involved in the analysis of production issues, proposing the solutions and post release validations.

Associate Technical Analyst

Confidential

• Responsible for daily activities on production and non production Database and Application servers.
• Pro-active Monitoring/Health check of Database/Backup and any other errors and troubleshoot accordingly.
• Responsible for Sys-Admin activities and space management of server.
• Administering Workflow mail, concurrent managers/parallel concurrent processing and troubleshooting.
• Responsible for setting of environment for all databases and also experienced with RAC environment.
• Sound knowledge of Data Tablespace, Undo Tablespace and Temporary Tablespace.
• Experienced in handling ORA errors, trace, tkprof.
• Sound knowledge in Data guard (physical/logical), MRP/Gap troubleshooting.
• Submitting periodical reports on the activities performed and finding permanent fix for repeated issues.
• Experienced in maintaining and supporting multiple oracle databases and applications in high availability (24*7) heterogeneous environment.
• Responsible for the support and maintenance of the applications and databases in onshore and offshore model.
• Collaborated with multi-vendor global teams.