SUMMARY

• Having a solid 7+ years of Application Support experience for mission critical applications.
• Having a Good knowledge in Bigdata Hadoop, ETL Infomatica, Unix, SQL, Oracle, Tableau, Autosys.
• Having 2+ years of experience in Hadoop Ecosystems in Bigdata Technologies - mainly in Hadoop HDFS, Sqoop, Flume, Hive, Pig, MapReduce, Oozie, Hue and Zookeeper.
• Having 3+ years of experience in ETL tool: Informatica Power Center (Power center Designer (Mapping Designer, Mapplet Designer, Transformations), Workflow Manager( Workflow Designer), and Workflow Monitor)
• Having 2 years of experience in SQL, Unix, Oracle, MS SQL server.
• Having a good experience on working of high pressure dynamic environment.
• Have a good experience in handling 250+ node cluster in Hadoop Production.
• Enhance organization reputation by accepting ownership for accomplishing new and different requests and exploring opportunities to add value.
• Experience in adding value adds by automating existing application systems and saved a huge manual effort which results in profit for the Project.
• Experienced in delivering solutions for multi-play offerings with successful production experience of multiple projects.
• Develop, maintain and report production system application metrics.
• Used coding methods in specific programming language to initiate or enhance program execution and functionality.
• Strong understanding of Banking and Financial domain concepts and their security policies.
• Experience in Integrating and working with various databases including ORACLE, Microsoft Sql server.
• Experience in working on a Unix environment and shell scripts.
• Having a good knowledge on Change Management process.
• Worked on many DR test activity and BCP programs.
• Proficient in handling the production incidents and production related issues involving multiple vendors.
• Resource management for 18 associates for global coverage (24x7x365).
• Leading an eleven member enhancement come support team and have successfully reduced the response time on user queries and production support issues substantially.
• Excellent communication skills, Interpersonal skills and leadership qualities.

TECHNICAL SKILLS

Bigdata Ecosystems: Hadoop, HDFS, Sqoop, Flume, Hive, Pig, MapReduce, Oozie, Hue

Tools: Tableau, Nagios, Informatica 9.1, ITRS, Autosys, Ticketing tools (JIRA and PAPA)

Database: Hbase, Oracle 10g/11g, SQL server, TOAD 9.5.

Operating Systems: CentOS, Windows, Unix

Language: Oracle SQL, PYTHON

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Application Support Lead

Responsibilities:

• Working on a live 210 node production cluster.
• Monitoring and working on Sqoop jobs with incremental load to populate Hive External tables.
• Good understanding of Partitions, bucketing, SERDE in hive.
• Maintaining and working on Hive and Pig scripts for ad-hoc requests.
• Creating Oozie workflow jobs for scheduling and orchestrating the ETL process.
• Experience in using sequence files, AVRO and Parquet file formats with snappy and bzip compressions.
• Worked in data visualization tool Tableau for creating dashboards for business analysts.
• Provide technical/functional support and project implementation for mission-critical applications.
• Effectively performed in performance tuning to improve the processing time of jobs.
• Any changes to the production environment required to resolve an incident will be performed in accordance with the company's change management process.
• An incident raised from level 1 support team has been resolved in a much faster way.
• Worked on preparing Support trouble shooting documents and uploaded in shared path for future.
• Worked with Developers to improve the performance of existing applications.
• Involved in project’s audit and Risk audits and maintained as per strict audit policies.
• Worked as Lead for 12 member support team on offshore-onshore model to provide global coverage.
• Coordinating daily metrics status reports and status meeting.
• Coordinating weekly status calls with developer team to discuss on application performance.
• Created Weekly, Monthly trending reports on the issues resolved, incidents worked, development escalated issues and support involvement in deployment releases.
• Worked on user ad-hoc queries and provide them with their needs on priority.
• Performed weekend maintenance activity of servers and systems.
• Provided L3 support on mission critical applications and awarded as best team lead twice.

Confidential, Denver, CO

Informatica L3 Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Confidential New Jersey

Informatica Support Engineer

Responsibilities:

• Effectively handled business scenarios and developed complex mappings.
• Liaise with users, software developers and Business Clients for the delivery of IT solutions and services.
• Effectively performed Application Enhancements and troubleshooting Informatica and Database errors.
• Analysing the Informatica bottleneck and clearing it to improve the performance of workflows.
• Provide technical/functional support and project implementation for mission-critical applications.
• Analysing root cause for the outage issues and work with the developers to put a permanent fix.
• Respond to incidents raised from the L1 level Support and provide Level 2 (L2) production support for the applications with the SLA of 15 minutes. Batch monitoring and deliverables are done on time.
• See through the system changes, manage and resolve user queries and issues in a timely and effective manner. Handling JIRA Enterprise tool and PAPA ticketing tool for tracking incident tickets.
• Support of Application processing (i.e.) attending to alerts and monitoring back end jobs. Jobs are scheduled in Autosys and are also monitored by Informatica monitoring tool and ITRS alerts are set for all jobs.
• Interact with Clients and work with developers for the enhancement of existing applications. Worked with QA team for testing and resolving defects before Enhancements.
• Any changes to the production environment required to resolve an incident will be performed in accordance with the company's change management process.
• Receive and analyze application related faults and data related faults from first line support.
• Provide support for application build and releases.
• Upgrading and deploying software in case of any enhancement or core releases.
• A monthly highlight report, ASPICIO report, fault report, ITES report is made for the management.

Confidential

Application Support Specialist

Responsibilities:

• Experience in writing quality Plsql codes, Analyzing the codes for any bugs, troubleshooting issues, application support functions, deploying the codes on test servers and testing for any issues and then deploying on live.
• Experience in supporting Web Based application which Involves following technology JAVA, PL/SQL.
• Worked on sql server, Oracle Reports, Tableau reporting tool, ITRS monitoring tool, Wiki GUI cpu utilization tool, iprocess client, Citrix.
• Providing post deployment support for upgrades / changes / enhancements done on production (Live) Environment.
• Strong Unix / Oracle skills and very quick learner.
• Have taken the responsibility of deployment, raising change request and coordinating with the AIS team to complete the AIS 100%
• Analyzing and investigating defects and faults, and tracing them till final resolution, developing shell scripts, developing PL/SQL codes and test them on test environment.
• Good Knowledge of Software Development Life Cycle (SDLC).
• Time-efficient, systematic working methodology. Rapid adaptability to new problem-solving and new locations.
• Proficient, dynamic and result oriented team player with excellent analytical and interpersonal skills used to coordinate multi-disciplinary teams and clients and consistently motivated toward success and completion of projects.
• Prioritizes requests in accordance with agreed service level agreement.
• Within own area of knowledge; follows agreed procedures to investigate issues and other requests for support and determines appropriate actions to take.
• Interface with the 1st line support and development team.
• In accordance with agreed procedures; monitors application systems. As a part of this carries out regular scrutiny of the application software, systems software for proactive maintenance.
• Provide on call support out of office hours, during weekends and during major release work for development and customer to help them resolve issues faced.
• Ensures all work is carried out and documented in accordance with required standards, methods and procedures.

Confidential

Trading Support Analyst

Responsibilities:

• Work on incidents raised from the level 1 support and provide level 2 support for the mission critical applications.
• Any changes to the production environment required to resolve an incident will be performed in accordance with the company's change management process.
• Interact with Users and work with Development team for the enhancement of existing applications.
• Involved in weekend application maintenance and server maintenance.
• Worked on ticketing tools Jira and Papa by responding and resolving the user’s registered tickets with the SLA of 15 minutes.
• Lead a support team of 11 members efficiently by providing 24/7 global coverage and reduced the response time on workflows.
• Monitoring Production jobs and work on ad-hoc user queries.