SUMMARY

• Over 9 Years of experience in DWH and ETL Technologies.
• Experience in Requirement Gathering, Source system analysis and ETL Design.
• Involved in Development, Implementation and Support of various DWH Projects.
• Involved in Migration of ETL projects and server Migrations.
• Experience on New server setup and Successfully Executed Disaster Recovery programs
• Experience on ETL administration (Worked as COE for Abinitio projects)
• Extensively worked in Abinitio using latest GDE V3.5.2 and Latest Co - operating System V3.5.1
• Developed Graphs using Abinitio latest GDE 3.5 and worked with various Abinitio components. Database and program Components like SORT, REFORMAT, JOIN, DEDUPSORT, REPLICATE, GATHER, MERGE, PARTITION Components, JOIN WITH DB, ROLL UP, SCAN, And LOOKUP for the Development.
• Familiar with Third party components like HDFS components, JMS, Webservice, Excel (Read and Write), Hive (Read and Write) & MVS components
• Experience on Query>It
• Experience on Control Center, TRW, AG
• Familiar with Parallelism techniques and implemented Data Parallelism using multi Partitioned data in the graphs. experience on SQL, PL/SQL
• Strong knowledge on PGP & AES-256 encryption processes
• Extensive experience on SSH
• Strong knowledge on SQL Loader concepts
• Good knowledge on performance tuning and explain plan
• Good knowledge on packages and procedures
• Strong experience on joins and types of joins
• Strong experience on SQL analytical functions and constraints
• Hands on Experience in Unix commands and shell scripting which is used for automation process.
• Creating scripts for automation using shell scripting for Archiving and deleting older files.
• Experience on Data Warehousing Concepts.
• Experience on Hadoop & cloud Computing concepts
• Reading and Writing Data from/To Hive Tables, Parquet, Avro, Json files
• Knowledge on Agile methodologies like Scrum & Kanban.
• Involved in Pentaho POC (Proof of Concept)
• Experience on Jenkins, Jira, Confluence, Microsoft Teams
• Experience on Scheduling tools Control-M, TWS
• Strong communication skills, systematic approach, and quick adaptability to new technologies and work environment.
• Experience in Telecom and Insurance Domains.
• Onsite Experience as a coordinator for Technical Production Support.
• Experience in leading the Development and Support Team
• Excellent Experience and Exposure on Production support for Enterprise applications
• Vastly involved in ITILV3 processes incident management, change management, problem management, capacity management and CSI (continual service improvement).
• In depth knowledge in managing ASM (Application Support and Maintenance) projects and ISG (Information Service Groups) Projects

TECHNICAL SKILLS

ETL: Abinitio, Informatica, Pentaho

Programing: XML, UNIX shell scripting, C

DATABASE: Oracle, mssql, mysql, DB2

OS: UNIX, LINUX, Windows95/98/NT/2000/XP/2007

PACKAGES: MS Office 2007, 2010

Scheduling Tools: Control M, TWS,Splunk

Workflow tools: ServiceNow

Ticketing tools: Bridge Clarify, ServiceNow, JRS

Big Data tools: Hadoop, Hive

Collaboration tools: Jira, Confluence, Microsoft Teams

PROFESSIONAL EXPERIENCE

Confidential

Sr. IT Consultant

Responsibilities:

• Developed Graphs using I/O Table components, Sort, Join, Rollup, Partition/De-partition components
• Writing/Improving SQL queries based on business requirements
• Involved in exploring POC (Proof of Concept) on Various Products (Query>It, Jenkins Integration, Pentaho &Express>It BRE, ACE)
• Creating the automated scripts for server monitoring, DR exercise and Patching activities
• Handling he EOSL (End of server life projects)
• Conducting the DR (Disaster Recovery) exercise.
• Handling SAN and NAS storages.
• Implemented the SSH connections for individual and application Id’s.
• Implemented the Encryption method for Archived files
• Performing the Code reviews for new functionality and enhancements
• Creating Unit test cases, creating tags and migrating code to higher environments.
• Deploying code and writing wrapper scripts and scheduling the same to automate the process.
• Provide training and educate people to bring up to speed with in team.
• Used different types of Joins to extract the Data from tables for reporting purpose.
• Managing the ETL Platform across the enterprise for 200+ applications
• Upgrading/Installing the GDE & Co>op Versions
• Providing solutions to different issues faced by application teams.
• Handling the requests raised by the Application teams.
• Working with Abinitio Vendor for new updates and releases
• Performed Data Profiling using Metadata Import and TRW.
• Monitoring the jobs through Control Center
• Handling monthly server Patching and Validations
• Co-ordinating the Global team and providing the solutions to users
• Working with environmental teams to identify the RCA for unknown issues
• Maintaining server and GDE License keys
• Performing Quarterly, Yearly reverification
• Creating tasks using Jira, Microsoft Teams

Environment: Ab Initio GDE V3.5 Ab Initio Co>Operative System V3.5, Linux X86, Windows2010, Control Center, Oracle 12C, TWS, Service now, Confluence, Jira, Microsoft Teams

Confidential

IT Consultant

Responsibilities:

• Developing the Graphs using Abinitio GDE, as per the Business requirements.
• Developed Graphs using I/O Table components, Sort, Join, Rollup, Partition/De-partition components
• Writing/Improving SQL queries based on business requirements
• Worked on UNIX commands to run the graphs in UNIX server and to find the space utilization.
• Creating scripts for automation using shell scripting for Archiving and deleting older files.
• Involved in performing unit testing and creating Tag and handover the code to QA Team
• Involved in Live Deployment of new releases to Production
• Providing Solutions for repeated problems occurring in production and developing the new code for the same.
• Created the sql loader scripts to load the data into tables using control files and data files.
• Used joins to write the SQL queries to extract and load into tables.
• Co-ordinating with onshore and offshore Team members.
• Working on new initiatives to improve the process.
• Introduced New Process to help in better reporting
• Working on security related tasks to meet the Allstate security standards.
• Involved in exploring the knowledge into new technologies to work and Conduct POC’s with different vendors.
• Monitoring the scheduled jobs through TWS (Tivoli Work Load Scheduler)
• Attaining the failed jobs and finding the root cause and resolve it within point of time.
• Analyzing and resolving the Incidents as per agreed SLA.
• Proactively Monitoring Schedule and informing the stakeholders if there is any delay in the BAU Schedule.
• Handling the ASG Handover calls, pre & post deployment calls, and client calls etc.

Environment: Ab Initio GDE V3.2.2 Ab Initio Co>Operative SystemV3.0.2,3.2.5, Linux X86, Windows2007, Oracle 12C, TWS, ServiceNow, Confluence, Jira, Microsoft Teams

Confidential

IT Consultant

Responsibilities:

• Monitoring the scheduled jobs through TWS (Tivoli Work Load Scheduler)
• Attaining the failed jobs and finding the root cause and resolve it within point of time.
• Analyzing and resolving the Incidents as per agreed SLA.
• Involved in Live Deployment of new releases to Production
• Worked on UNIX commands to run the graphs in UNIX server and to find the space utilization.
• Developing the Graphs using Abinitio GDE, as per the Business requirements.
• Providing Solutions for repeated problems occurring in production and developing the new code for the same.
• Involved in performing unit testing and creating Tag and handover the code to QA Team
• Worked on Ab Initio Components like Sort, Partition, Rollups, Reformat Replicate, Join, and Gather etc.
• Worked on DB Components.
• Solving the DB and Abinitio issues in Production environment to Meet agreed SLA for Priority applications.
• Creating scripts for automation using shell scripting for Archiving and deleting older files.
• Proactively Monitoring Schedule and informing the stakeholders if there is any delay in the BAU Schedule.
• Handling the ASG Handover calls, pre& post deployment calls, and client calls etc.
• Co-ordinating team members to deliver seamless results to the clients.

Environment: Ab Initio GDE V3.2.2 Ab Initio Co>Operative SystemV3.0.2, UNIX, Windows2007, Oracle 11g, TWS, Service now, JRS .

Confidential

Sr. Software Engineer

Responsibilities:

• Monitoring the scheduled jobs through Control-M
• Running the Jobs based on space utilization and preventing from failures.
• Attaining the failed jobs and finding the root cause and resolve it within point of time.
• Analyzing and resolving the Incidents as per agreed SLA.
• Involved in Live Deployment of new releases to Production
• Worked on UNIX commands to run the graphs in UNIX server and to find the space utilization.
• Developing the Graphs using Abinitio GDE, as per the Business requirements.
• Worked on Ab Initio Components like Sort, Partition, Rollups, Reformat Replicate, Join, and Gather etc.
• Worked on DB Components like Input Table, Join with DB etc.,
• Proactively Monitoring Schedule and informing the stakeholders if there is any delay in the BAU Schedule.
• Handling the ASG Handover calls, pre& post deployment calls, and client calls etc.
• Co-ordinating team members to deliver seamless results to the clients.

Environment: Ab Initio GDE V1.14, Ab Initio Co>Operating System V2.13.1, UNIX, Windows2007&2003, Oracle10g, 11g, Bridge Clarify, Control-M