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 which involves JAVA and .NET technologies
• Hands - on experience with Oracle, Sybase, MS SQL Server 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 Change, Incident, Problem and Release management
• Experienced in supporting FIX connections to clients for Electronic Trading
• Experienced in providing Tier 2 and 3 Production support to Autosys batch processes and perform trouble shooting using power center logs, LINUX/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 deploying, integrating, and administrate Tomcat/Apache, Java, WebLogic Servers, IIS and other middleware systems
• Experienced in Automating the user Monthly and Daily reports based on the requirement
• Extensive experience in working with ERP systems, Enterprise software applications developed using Confidential 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
• Expertise in working with middleware and networking teams in Installing, Configuring servers from scratch with OS of Red Hat Linux
• 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
• Worked closely with Architects when designing the Data Marts and Data Warehouses, with Business Analyst in understanding the business needs and interacting with other team members in completing the task as scheduled
• Excellent analytical skills, oral and written communication skills
• Self-motivated team player with excellent problem-solving skills and ability to quickly learn new technologies and tools

TECHNICAL SKILLS:

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

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

Operating Systems: Windows, Unix, Linux

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

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

Other Tools/Technologies: AWS, Remedy, Trackit, ITSM, Autosys, Office365, Control-M SQL Server Management Studio, MS Visio, Putty, Toad, Rapid SQL, Secure CRT, Secure FX, Splunk, Putty, MS Office, Service Now, JIRA, Confidential . Confidential

PROFFESIONAL EXPERIENCE:

Confidential, Irvine, CA

ETL Production Support Analyst

Responsibilities:

• Involved in performing regular system audits to ensure accuracy of the various environments and applications along with monitoring Autosys batch processes and perform trouble shooting using Power center logs, UNIX scripts and Database SQL processes
• Perform Weekend Checkouts for the applications after maintenance activities and scheduled server bounces
• Experienced using SPLUNK and looking up the TIBCO RV messages that interface with several orders management applications
• Expertise in generating reports and addressing Ad-hoc report requests from the customers using SQL Server, Rapid SQL, Toad and Crystal reports
• Involved in debugging the IIS issues along with Middleware support team and troubleshooting the . NET applications using IIS tracing techniques
• Maintained many applications used by the agents which are hosted on IIS Windows and IBM WebSphere Application Server on UNIX Solaris 10 platform
• Involved in migration and updating JDK versions, applying patches and installing service packs for WebLogic/tomcat server
• Create and maintain UNIX scripts, Sybase/Oracle stored procedures Autosys 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
• Experienced in verifying and changing File permissions, checking network connection problems, FTP management, and knowledge of core Internet and networking protocols, firewalls and other network security systems
• Involved in checking Windows, Unix logs and resolving performance issues by coordinating with L2 and DBA teams
• Responsible for writing AUTOSYS JILs and scheduling the Informatica workflows on the Autosys server
• 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
• Documenting the resolution for known issues and responsible for updating and maintain the articles in the Knowledge Base
• Provide knowledge transfer sessions for trainees and uploading the documentation in SharePoint
• Involved in communicating the issues to the incident teams so that the information is provided to the vendors and customers.
• Identifying risks proactively and proposing solutions to resolve them.

Environment: Remedy, Tibco, Linux, Oracle ERP, Sales Force, Tivoli, Splunk, Oracle 10g, SQL Server 2008, Sybase, Tableau 9.1, Secure CRT, Autosys, Toad, Perl, Unix Shell scripting

Production Support Informatica

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 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
• Engaged in creating UNIX Shell scripts to invoke workflows and used PL/SQL to create the dynamic pmcmd commands and parameter files for the workflows
• Responsible for writing Autosys JILs and scheduling the Informatica workflows on the Autosys server
• Responsible for monitoring Tableau Server schedules, background tasks, data refreshes to ensure data in dashboards is up to date
• 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 9.6, ITSM, Oracle 11g, Tableau 8.1, Business Objects, Toad, Perl, Unix Shell scripting

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, QC, DB2

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