SUMMARY:

• About 5+ years of experience as IT Professional with excellent analytics skills.
• Proven expertise in SQL, Oracle, Teradata, UNIX shell scripting, Base SAS, MS SQL Server and GreenPlum.
• Working experience in various aspects of the SDLC and software methodologies such as Waterfall and Agile for project implementations
• Extensive experience in banking and telecommunication domain
• Good experience in Migration Projects
• Excellent experience in design, development and implementation of ETL processes
• Comprehensive understanding and knowledge of Python and big data solutions such as Hadoop
• Experience in assisting project team to resolve issues, retesting the defects, validating results and communicating status/issues and leading triage calls
• Collaborative teamwork skills and experience in working with multiple clients and geographically distributed teams following Onshore - Offshore model
• Exceptional ability to learn and master new technologies as required to meet business needs
• Efficient time management and organizational skills honed by successfully completing multiple detail-oriented work assignments within tight deadlines through prioritization and effective planning
• Persuasive communication, problem solving and inter personnel skills
• Fluent in English, Punjabi and Hindi

TECHNICAL SKILLS

Operating System: Windows XP/7/10, UNIX, Linux

Databases: Oracle, Teradata, MS SQL Server, GreenPlum

Programming Languages: SQL, UNIX Shell Scripting, Base SAS, Python

ETL Tool: Ab Initio

Schedulers: Autosys, Crontab

Others: Putty, TOAD, SQL Developer, WinSCP, SuperPutty, Teradata SQL Assistant, SSRS, SAS Enterprise Guide

WORK EXPERIENCE:

Confidential

Environment: Teradata SQL Assistant, SQL Developer, SAS Enterprise Guide, Putty, SuperPutty, Teradata SQL, SQL, UNIX Shell Scripting, Base SAS, DB2, Autosys, SCCS, BMC Remedy IT Service Management, Data Modeling, MS Excel, Data Warehousing

Responsibilities:

• Full life cycle experience including requirements analysis, data model design, coding, testing and documentation
• Implemented and optimized data models in Plug and Play environment
• Scheduled jobs on Autosys to ensure their timely execution
• Provided BAU execution support for quantitative models through break fixing and troubleshooting any issues
• Developed extensible and adaptable code, setting code review meetings with client and maintain review comments in share point
• Supported business partners in analytical decision making to deliver tailored customer solutions
• Extraction/analysis of vast customer data and generation of PSI reports and score datasets
• Connect with clients to better understand the requirements
• Determine and develop strategies for replacing existing modules with advanced/better modules.
• Developed automation solutions leveraging UNIX shell scripting, Teradata utilities, SAS and Autosys Scheduler to increase operational efficiency and achieve time and effort savings
• Significantly reduced generation of ITSM BMC remedy tickets caused due to failure of obsolete and redundant Autosys scheduler jobs by decommissioning such jobs
• Ensured successful migration of UNIX servers and models/data from DB2 to Teradata database
• Have used SCCS to track changes insourcecode and to retrieve any of the previousversionsof the originalsourcecode

Confidential

Environment: Oracle SQL Developer, TOAD, Putty, SuperPutty, GreenPlum, Oracle SQL, UNIX Shell Scripting, PL/SQL, WinSCP, Crontab, MS Excel

Responsibilities:

• Developed ETL processes for generating reports using Oracle SQL, GreenPlum and UNIX Shell Scripting
• Enhanced existing scripts/codes and automated various processes utilizing UNIX shell scripting and Oracle SQL to ensure timely production backup and manage space usage to avoid job failures
• Developed operational documentation including standard operating procedures, process manuals, and technical documents to effectively meet business needs
• Monitored production activities including execution of MIS reports generation processes and resolved any related errors (causing delays in reports availability) under tight deadlines
• Timely communicated impacts to internal/external clients and senior level executives
• Ensured timely access of MIS reports on shared client portal through executing UNIX scripts
• Migrated all existing MIS reports generation processes from Oracle database to GreenPlum
• Worked on query optimization and performance tuning
• Co-ordination with multiple teams
• Worked on ad hoc requests from clients such as re-generation of data

Confidential

Environment: MS SQL Server 2000, Oracle SQL Developer, TOAD, ETL, MS Excel, Data Warehousing

Responsibilities:

• Responsible for the Analysis, Design, Implementation, Testing and documentation of ETL processes
• Creating design documents based on inputs during design discussions with mentors.
• Successfully developed DTS Packages (now SSIS) on SQL Server 2000 to upload raw data from heterogeneous sources such as Oracle, SQL Server and Flat files into database tables
• Code development and code walkthrough with clients.
• Effectively handled data processing using data transformation services
• Involved in daily meetings with the onshore clients to update status of projects and any related issues
• Resolved faults, issues and errors affecting data integrity through debugging, break-fixing DTS packages and performing sanity checks on source feeds and/or reprocessing data packages
• Configured and analyzed processed data on NetviewPlus (measure integrity system to develop MIS reports)
• Migrated data from SQL Server to Oracle database within tight time constraints
• Worked extensively on query optimization, performance tuning and index utilization
• Worked on enhancement of existing processes
• Creating and maintaining process manuals as per client requirement.
• Onshore-offshore coordination
• Cross trained in different teams including BI teams and support team
• Technical go-to person for Onshore