SUMMARY

• Over 6 years of experience in Information Technology with focus on Production support, ETL, and Reporting tools
• Extensive experience providing application support to a suite of Transport, Front office, Back office, Trading, & web applications based on JAVA and .NET technologies which includes Android, ios apps
• Hands - on experience with Oracle, Sybase and MS SQL Server and Strong Unix, SQL and Database development skills (PL/SQL and T SQL)
• Strong knowledge on various stages of Trade life cycle and have extensive experience in working with Equity and Trading platforms
• Proficient in ITIL concepts for Change Management and Configuration Management.
• Strong Knowledge on Active Directory group and LDAP authentication.
• Strong Knowledge on FIX protocol and experienced in providing support to investment and compliance applications
• Strong knowledge on web methods and experienced in EDI/B2B using web methods integration services
• Tier 2 support for application web services and webMethods infrastructure.
• Strong knowledge on change, Incident, Problem and Release management
• Experienced in providing Tier 2 and 3 Production support to Control-M batch processes and perform trouble shooting using power center logs, UNIX scripts and DB processes
• Hands-on experience using SPLUNK, looking up TIBCO RV messages and have good knowledge on CA site minder user authentication
• Experienced in providing support to Oracle E-Business suite and Oracle financial modules
• Experienced in deploying, integrating, and administrate Tomcat/Apache, Java, WebLogic Servers, IIS and other middleware systems
• Extensive experience in providing support Mainframe environment and working with ERP systems, Enterprise software applications developed using Salesforce and third-party applications like Citrix, Markitwire, Matlab, Electra, Bloomberg
• Experienced in all phases of System Development Life Cycle (SDLC) such as strategy analyzing, designing, coding, testing, support and documentation of software products
• Good understanding of Agile SCRUM process and extensive experience working in a collaborative environment
• Experienced in developing Tasks- Session, Command and Event wait, Workflows and Batch Processes
• Implemented Pre-Session and Post-Session shell scripting to run workflows using pmcmd command
• Extraction of data from Sources to Targets- Staging Area, Data Marts or Data Warehouses
• Extensive use of Informatica Debugging in mappings and used Session Log File to trace the errors when loading into targets
• Excellent analytical skills, oral and written communication skills
• Self-motivated team player with excellent problem-solving skills and ability to quickly learn modern technologies and tools

TECHNICAL SKILLS

ETL/BI Tools: Informatica 8.x/9.x, Tableau, Microsoft SSIS, Microsoft SSRS

Databases: MS SQL Server 2005/2008, Oracle 9i/10g/11g, Sybase ASE 15, Netezza, MS Access

Operating Systems: Windows, Unix, Linux

Programming Languages and tools: Shell Scripting, MS Visual Basic, HTML, SQL, PL/SQL, Adobe Dreamweaver

Web/Application Servers: IIS 6.0, Tomcat, Apache, Weblogic, Webmethods, JBoss

Other Tools/Technologies: OMS, Remedy, Trackit, ITSM, JCL, Active Batch, Autosys, Office365, Control-M SQL Server Management Studio, Oracle Financials ERP, MS Visio, Putty, Toad, Rapid SQL, Secure CRT, Secure FX, Splunk, Putty, MS Office, Service Now, JIRA, Salesforce.com

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Production Support Analyst

Responsibilities:

• Involved in performing regular system audits to ensure accuracy of the various environments and applications along with monitoring Control-M batch processes, ETL workflows and perform trouble shooting using Power center logs, UNIX scripts and Database SQL processes.
• Involved in troubleshooting issues occurred on Trade floor and work closely with Portfolio managers and traders
• Perform Weekend Checkouts for the applications after patching maintenance activities and scheduled server bounces.
• Experienced using SPLUNK, and looking up the TIBCO RV messages that interface with several orders management applications
• Involved in debugging front end and mainframe flow services (web methods) related issues
• Expertise in generating reports and addressing Ad-hoc report requests from the customers using SQL Server, Rapid SQL, Toad and Crystal reports.
• Provide regular status updates to customers, stakeholders and management (trade floor) during extended troubleshooting efforts
• Involved in providing support to the Web Methods services for inbound and outbound transactions.
• Monitored and guided the requests sent to B2B Web Methods server
• Involved in migration and upgradation of WebLogic/Tomcat/WebSphere Server and updating JAVA JDK versions, applying patches and installing service packs for WebLogic/tomcat server
• Involved in decommission of various LINUX/Redhat based servers and in various patching activities of LINUX environment
• Involved in debugging the IIS issues along with Middleware support team and troubleshooting the Java, .NET applications using IIS tracing techniques
• Integrating WebLogic Environments with Apache/WebSphere web server 2.2 for reverse proxy
• Involved in trouble shooting issues related to web based Windows applications and restart the services if necessary. Also worked on Windows Patching activities followed by application checkouts.
• Involved in checking Windows logs, Unix logs and resolving performance issues by coordinating with L2 and DBA teams. Collaborate with database technical teams to ensure proper integration of the environment and Performance tuning
• Create and maintain UNIX scripts, Sybase/Oracle stored procedures Control-M job dependencies
• Extensively Worked with Data Warehouse team to create and export data scripts
• Experienced in checking file transfer activities via FTP and SFTP
• Aided to the data migration and Disaster Recovery- DRE activities
• Experienced in identifying the MD entry types between FIX host and FIX gateway
• Experienced in Identifying the versions and disabling Stop orders on a TT FIX Gateway
• Responsible for writing Control-M and scheduling the Informatica workflows on the Control-M
• Engaged in mapping different application job flow entitled to Tableau dashboard
• Created several advanced ad-hoc data visualizations in Tableau and worked on series of production deployments
• Created monthly, quarterly dashboards for executive management and published to Tableau Server
• Involved in performing Root Cause Analysis for all the repeated issues and communicating them to the incident teams so that the information is provided to the vendors and customers
• Documenting the resolution for known issues and responsible for updating and maintain the articles in the Knowledge Base
• Provide knowledge transfer sessions for trainees on Trade life cycle, Equites, Securities, TIPS and uploading the documentation in SharePoint

Environment: Remedy, Tibco, IBM WebSphere,Webmethods, Oracle ERP, SalesForce, Tivoli, Splunk, Oracle 10g, SQL Server 2008, Sybase, Tableau 9.1, Secure CRT, Autosys, Control-M Toad, Perl, Unix Shell scripting

Confidential, Chester brook, PA

Production Support Analyst

Responsibilities:

• Interacting with the clients on a regular basis to discuss day-to-day issues and matters
• Provide support for Informatica workflows/mappings developed using 9.0.1 which are running into production environment at client location
• Conduct training and knowledge sharing sessions for the onsite and offshore developers and testers on investment banking domain and functional areas
• Involved in Performance tuning of sessions, mappings, ETL procedures, processes for better performance and support integration testing
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and resolve the issues as part of production support
• Performed debugging by checking the errors in the mapping using Debugger utility of the Designer tool and made appropriate changes to generate the required results
• Liaison with cross functional teams across the enterprise, including OLTP development team, Testing team and various data-warehouse teams (on site and off shore team members)
• Implemented Error Handling Strategy in ETL mappings and route the problematic records to exception tables
• Worked on optimizing and tuning theTeradataviews andSQL’sto improve the performance of batch and response time of data for users
• Used Teradata utilities fast load, multi load, t pump to load the data.
• Responsible for writing Control-M and scheduling the Informatica workflows on the Control-M
• Responsible for monitoring Tableau Server schedules, background tasks, data refreshes to ensure data in dashboards is up to date
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques
• Performance tuning of reports and working on tickets within Tableau Server and Reports
• Generating several ad-hoc reports using Tableau desktop for the business end users
• Created several prototypes in Tableau and presented them to the business users
• Developed dashboards for recurring ad-hoc report requests from users and published to Tableau Server

Environment: Informatica MDM, Teradata, Tableau 8.1, Business Objects, Toad, Perl, Unix Shell scripting

Confidential

ETL Production support

Responsibilities:

• Provide support for Informatica workflows/mappings (developed using Informatica 8.0.1) which are running into Production environment
• Configured Sessions and workflows using Power Center Work flow manager
• Involved in end to end ETL process including unit testing and deployment
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support
• Conduct training and knowledge sharing sessions for the onsite and offshore developers and testers on insurance domain and functional areas
• Supported the Production system until system is fully stabilized
• Involved in triaging the issues ahead of reaching to any kind of priority issues hence preventing serious business scenarios and Leading major incident calls, leading problem management and writing post problem reviews.
• Follow-up with the Development team regarding the status of the pending changes required by creating Problem records

Environment: SQL Server 2008, Remedy, CA site minder, SQL Query Analyzer, Oracle 11g, Abinitio, Autosys, Control-M, QC, DB2

Confidential

IT Analyst

Responsibilities:

• Designing, programming and implementing software application packages, database and programming requirements of clients, testing and implementing appropriate information systems
• Day-to-day performance and support of mission critical applications and technologies, acts as the single point of contact for business users, ensuring that incident and problem management processes are followed and supported
• Developed and reported metrics associated with systems performance, assisted management in establishing SLA’s (Service Level Agreements) with primary customers, and identified opportunities to eliminate unnecessary ad hoc reporting requests by developing alternative strategies to internal and external customers.
• Fixed, troubleshoot and managed problem-solving calls. Escalated critical outages to managers, deployed, upgraded, monitored, generated and analyzed service level agreement reports (SLQ).
• Analyzed fall-outs within the system and resolved trouble tickets.
• Developed the automated and scheduled load processes using Tidal scheduler, Involved in migration of mappings and sessions from development repository to production repository
• Automated the reports and processes using BizTalk server
• Developed Shell scripts to load data from Application database to Staging Database
• Actively participating in agile process development style like attending scrum meetings

Environment: Toad, SQL Query Analyzer 8.0, Oracle 10g/11g, OBIEE, BI Publisher, Erwin, Unix, Putty, Quick Test Professional