OBJECTIVE:

• Looking for an opportunity to join/lead a fast growing team to utilize cutting edge technologies and expand footprints in the growing field of Information Technology.

SUMMARY

• Having a solid 6+ years of Application Production Support experience for mission critical applications.
• Acts as a lead in identification and troubleshooting processing issues impacting timely availability of data in the data warehouse or delivery of critical reporting within the established SLA’s.
• Having a Good Experience in Bigdata Hadoop, Quartz framework, ETL Infomatica, Unix, DB2, SQL, Sybase, Sandra, Oracle, Tableau, Autosys, Geneos ITRS.
• Having 2 years of experience in Hadoop Ecosystems in Bigdata Technologies - mainly in Hadoop HDFS, Sqoop, Flume, Hive, Pig, MapReduce, Spark, Oozie, Hue and Zookeeper.
• Having a good experience on Data warehousing project as a Support lead.
• Having a good knowledge on Investment banking, Market risk (GMRT), Derivatives, Equities and Fixed income.
• 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 5 years of experience in SQL, Unix, Oracle, MS SQL server, Java, Python.
• Having a good experience on working of high pressure dynamic environment for mission critical applications.
• Have a good experience in handling 750+ node cluster in Hadoop Production.
• Worked on Qz code review and deployments, scheduling jobs on Qz Bob monitor for the Qz applications.
• Day to day support for the mission critical Quartz applications for the Banking domain.
• Experience in adding value adds by automating existing application tasks 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 on SVN model and usage of version control.
• 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.
• Efficiently handling the resource management for global coverage production support.
• Experience in Integrating and working with various databases including SANDRA, ORACLE, and Microsoft Sql server.
• Experience in working on a UNIX environment, shell scripts and Python scripting.
• Having a good knowledge on Change Management process.
• Worked on many DR test activity and BCP programs.
• Worked on creating weekly, monthly reports to the Business project management.
• Proficient in handling the production incidents and production related issues involving multiple vendors.
• Proficient knowledge in ticketing tool Jira, incident tool Maximo and monitoring tool Geneos ITRS.
• Resource management for 18 associates for global coverage (24x7x365) and providing on call support.
• Leading an eleven member enhancement come support team and have successfully reduced the response time on user queries and production support issues substantially.
• Worked on Supporting trade matching systems TRAM and BART.
• Worked in one of the world’s leading IT organization Tata Consultancy Services for 6years.

TECHNICAL SKILLS

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

Database: SANDRA, Oracle 10g/11g, SQL server,DB2, SYBASE, TOAD 9.5, NoSQL HBase, MySQL

Tools: Bob Job, Nagios, Informatica 9.1, ITRS, Autosys, Ticketing tools (JIRA&PAPA),Maximo.

Operating Systems: CentOS, Windows, Unix, Hortonworks Distribution Platform.

Language: Oracle SQL, PYTHON, Java

Scripting: Unix, Perl, Apache Pig

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Application Support Lead

Responsibilities:

• Working on a live 750 node production cluster.
• Responsible for identifying and troubleshooting the processing issues impacting timely availability of data in the data warehouse or delivery of critical reporting within the established SLA’s.
• Identifying and recommending the improvements in production application solutions or operational processes in support of datawarehouse applications and business intelligence reporting.
• Focuses on overall stability and availability of the Bigdata applications and the associated interfaces, data transport protocols.
• Researches, manages and coordinates resolution of complex issues through root cause analysis as appropriate.
• 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.
• Managed data warehouse enhancements and defects.
• Responsible for data warehouse and report release management.
• Worked in data visualization tool Tableau for creating dashboards for business analysts.
• Successfully re-engineered every application within data warehouse to comply with updated changes.
• Hand coded all the backend working scripts that refresh the entire warehouse.
• Provide technical/functional support and project implementation for mission-critical applications.
• Effectively performed in performance tuning to improve the processing time of jobs.
• Involved extensively in business reporting, data mining, adhoc analysis and business forecasting across various departments.
• 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.
• Performed weekend maintenance activity of servers and systems.
• Provided L3 support on mission critical applications and awarded as best team lead twice.

Confidential

Production Support Analyst

Responsibilities:

• Working on a live 350 nodes production cluster.
• Imported data from ORACLE to HDFS using Sqoop.
• Ingested data from RDBMS through flume agents.
• Developed Hive scripts for data processing to present data to Analytics team.
• Defined and captured metadata and rules associated with Hive and Oozie processes.
• Designed custom serde over Hive and Loaded data to Hbase over Hcatalog.
• Researches, manages and coordinates resolution of complex issues through root cause analysis as appropriate.
• Designed Pig scripts for huge data sets.
• Developed workflow in Oozie to automate the tasks of loading the data into HDFS and pre-processing with Pig.
• Handling structured and unstructured data and applying ETL processes.
• Hands on Experience with installing, configuring and using Hadoop ecosystem components like HDFS, Hbase, Hive, Sqoop, Pig and Flume.
• Monitoring of cluster nodes and space issues through monitoring tools like Nagios and Ambari.
• Hand coded all the backend working scripts that refresh the entire warehouse.
• Provide technical/functional support and project implementation for mission-critical applications.
• Successfully re-engineered every application within data warehouse to comply with updated changes.
• 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.
• Created alerts for production jobs and servers in Geneos ITRS to avoid issues or outage.
• Responsible for Disaster Recovery plans and BCP activities.
• Responsible for analyzing the production issues and creating the root cause analysis post mortem report and also responsible for creating troubleshooting support document.
• Engage third party vendors in project delivery on their responsibilities and conform to Gap’s established standards .
• Responsible for comprehensive knowledge transition from development teams on new or modified applications moving to ongoing production support.

Confidential

ETL 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.
• Responsible for creating alerts for production Informatica jobs and informatica servers.
• Responsible for identifying and troubleshooting the processing issues impacting timely availability of data in the data warehouse or delivery of critical reporting within the established SLA’s.
• Identifying and recommending the improvements in production application solutions or operational processes in support of data warehousing applications and business intelligence reporting.
• 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.
• Generate daily critical reports to UK regulatory systems and to client money systems 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.
• Working on debugging of PL/SQL procedures and shell scripting.
• Experience with various databases like Teradata, MySQL, SQL server.
• Responsible for preproduction and post production testing for the new enhancements.
• Extensive experience with production batch scheduling and monitoring heavy loads.
• 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

Trading Support Analyst

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, 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.