SUMMARY:

• Around 5 years of experience in Production support and development.
• Worked in various roles as specialist, analyst/programmer and senior analyst/programmer with focus on ETL, data warehousing solutions and in sustenance of data warehousing systems
• Experienced in problem management, incident management, change management functions and service level management
• Specialties: Support and maintenance of multiple ETL projects on Abinitio, Datastage, Teradata, DB2, UNIX, Linux, Autosys and ITILv3 concepts platforms
• Familiar with: Tableau and UNIX shell scripting
• Worked on a wide range of technologies Abinitio Products - GDE, Operational Console, Co -Operating system, EME.
• Experienced in L3 production support and IT Service Management in wide range of Banking, Finance applications and products
• Expertise in technical documentation, functional documentation and reviewing
• Strong Team player and skills in troubleshooting and debugging of code
• Rich domain experience in Banking and Finance
• Excellent verbal and written communication, presentation skills, effective listening
• Focused and proactive, capable of delivering independently with high quality
• Proven ability to manage stringent timelines and pressure situations
• Maintenance of various environments - Production, UAT and BCP
• On -time status reporting to customers/management
• L2/L3 production support (24x7 model)
• Technical documentation, functional documentation and learning documentation
• Coaching and mentoring new team members and supervising effective induction
• Process improvement and defining guidelines/procedures/standards
• Building reusable assets and code for use beyond the project
• Raising Change Request/ECMS (Enterprise Change management System), Alacrity and SR (Service Request) requests for different changes in Production and diverse UAT (User Acceptance testing) environments
• Automating & Optimizing the work to minimize the manual work by the support team

TECHNICAL FORTE:

ETL: Abinitio GDE 3.2.6, Abinitio Co>Opsys 3.2.6, Informatica

O/S & Utilities: UNIX, LINUX, SED, AWK, Teradata utilities

Monitoring/Debugging Tools: Teradata Viewpoint, SQL Assistant, Microsoft Office, Business Objects And Ops console

Reporting: Tableau Desktop, Cognos

Version Control: CA Harvest, IBM Anthill

Database and DB tools: Teradata, Oracle, SQL Server

IT Tracker: BMC Remedy, PAC 2000, Service now

Scheduler: Autosys

PROFESSIONAL EXPERIENCE:

Confidential

Technology services Analyst

Responsibilities:

• Senior member of global finance team supporting the critical functionality of General Ledger processing, Confidential reconciliations and journal processing with strong experience of liaising with business stakeholders acting as the bridge between development teams and the users to communicate and resolve issues in a timely and efficient manner.
• Host and organiser for start of business day calls and other project related meetings.
• Day to day interactions with business partners, developers and other teams to maintain the stability of applications.
• Providing timely resolutions to system errors and problems caused at system and application level, by following the ticketing system service now and acting as per priority to minimize downtime and restore service.
• Providing permanent fixes to recurring issues by analysing the root cause and taking necessary actions.
• SME for Business objects reporting applications.
• Key member in planning & implementation of all changes and deployment activities in various applications like Business Objects, Cognos and many other internal applications of Confidential .
• Regional SME for the bank’s General Ledger processing via a third party vendor product (COBRA) used for P&L reconciliation, attribution, adjustments and trader sign-off.
• Responsibility for providing training on a global level for bespoke vendor product (COBRA) that interfaces the General Ledger and provides insight into P&L breaks, Clean P&L, Outright Inventory and Trader Sign-Off.
• Provided extensive support for critical platinum level data warehouse application NCDI ( Confidential Centralized Data Inventory) receiving data from several upstream systems, processing it and distributing it to US Finance applications, Business Objects Reporting system as well as Compliance applications like Actimize.
• Responsible for timely generation of quarterly regulatory FAS157 report.

Confidential, Jersey city, New Jersey

Production Support Specialist

Responsibilities:

• Batch support which includes monitoring the feed delivery, debugging the Autosys and job failures.
• Experienced in L2/L3 production support and IT Service Management in wide range of Finance applications and products.
• Analyzing various scheduled jobs (Autosys); studying their nature and performance
• Support and maintenance of multiple ETL projects on Abinitio, Teradata, DB2, UNIX, Linux, Autosys, SQL server and ITILv3 concepts platforms.
• Data quality checks and promoting feed for various applications with data related to trade and position data repository that services enterprise wide business functions including: Credit, Margin, Regulatory, Compliance, Client Valuation Group, Treasury and Finance.
• Working on various in-house built tools for scheduling, monitoring jobs, performing data level checks.
• Use of ITSM tool for creating incidents and for problem investigations.
• Project management activities for improving and enhancing the system.
• Working on ETL related applications which help in the enrichment of data.
• Sending status mails, updates and answering queries to downstream as part of user support.

Confidential

Senior Analyst/Programmer

Responsibilities:

• Extensively worked in debugging production related issues using various tools -- Abinitio GDE, Teradata, EME, Operational console and Autosys
• Good knowledge in Abinitio related processing (plan, pset, graphs, flat file processing and Multi-file processing).
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check-in and checkout were used for this purpose
• Maintained locks on objects while working in the sandbox to maintain the privacy
• Worked on developing various projects/utilities like Autosys Job reset, finding file watchers, status mail reports, queue wait monitoring report
• Strong working knowledge of Data Warehousing techniques and concepts including ETL processes, Star Schema/Snowflake Schema
• Worked with the source system teams to understand their file delivery standards/Standardize the Autosys jobs to avoid the load/dependency issues on the system
• Create Shell scripts to automate the production processes & schedule those using Autosys
• Creating Reports, Dashboards and stories using Tableau on the production and responsible for report distribution and security privileges
• Worked in machine changes for autosys jils based on the job functionality for avoiding queue waits which in turn reduced the SLA breaches

Analyst/Programmer

Confidential

Responsibilities:

• Worked in ETL(Abinitio) Production support for various projects such as, Enterprise Information Warehouse (EIW), Capital markets Operational data store (CMODS), Integrated data store (IDS), Mortgage Integrated data environment(MIDE) and Metadata Hub
• Initial research on production issues and primary contact for escalation
• Effective problem resolution within SLA. Communicating to customers about the status of processes
• Experience in production support involved in monitoring, analyzing and reporting of various technical issues encountered in ETL process as part of L1 support
• Worked with other developers/BA to create a Best in class production support solutions which will avoid the delivery issues
• Analyzing various scheduled jobs (Autosys); studying their nature and performance
• Knowledge in Teradata and worked on utilities like Viewpoint and SQL Assistant
• As part of Lead responsibilities conducted effective training sessions for new team members
• Involved in internal automations for better monitoring and reporting capabilities for the function
• Lead maintenance, enhancement activities and basic hands on experience in navigation of Mainframes
• Worked on automating internal ticket handling mechanism, which involved manual effort in handling PAC tickets
• Documented the day-to-day project activities. Created and maintained the knowledge base for project related technical aspects processes.