SUMMARY:

• 7 years of experience in Information Technology with focus on Production support, ETL, and Reporting tools
• Extensive experience in BI / Data warehouse projects involving Informatica Power Center, Informatica Data Quality and Tableau Data visualization products
• Strong SQL and Database development skills (PL SQL and T SQL)
• Extensive experience in Unix shell scripting
• Hands - on experience providing application support in a web based applications which involves JAVA and .NET technologies
• Clear Knowledge on AD group and LDAP authentication.
• Clear knowledge on change, Incident and Release management
• Hands-on experience with Oracle, Sybase and MS SQL Server
• Experienced in providing Tier 2 and 3 Production support to Autosys batch processes and perform trouble shooting using power center logs, UNIX scripts and DB processes
• Hands-on experience using SPLUNK and looking up TIBCO RV messages.
• 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
• Extensive knowledge on ETL, ELT & data integration tools including Informatica Power Center, SSIS, BO Data Integrator and extracting data from Oracle, MS SQL Server, and other source such as flat files, XML (various file feeds etc.)
• Clear knowledge on OLTP and OLAP systems, developing Database schema - Star and Snowflake schema (Dimensions and Facts), E-R modeling - Logical and Physical Modeling concepts
• Experienced in developing Tasks- Session, Command and Event wait, Workflows and Batch Processes
• Profound knowledge in implementing several types of Caches for Lookup’s- Dynamic, Persistent and Static Experience in creating Parameters and Variables
• 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
• 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, 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: Shell Scripting, Java Script, HTML, SQL, PL/SQL, Transact SQL

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

Other Tools/Technologies: Remedy, Autosys, SQL Server Management Studio, Putty, Toad, Rapid SQL, Secure CRT, Secure FX, Splunk, Putty, MS Office, Service Now, JIRA, Salesforce.com

PROFFESIONAL EXPERIENCE:

Confidential 

Application 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.
• Responsible for overseeing and performing technical research and development to enable continuing innovation with in the infrastructure.
• Assisted project teams with implementation phases and investigating issues, utilization monitoring and back up strategies.
• Perform Weekend Checkouts for the applications after maintenance activities and scheduled server bounces.
• Provided assistance to the data migration and Disaster Recovery- DRE activities.
• 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.
• Engaged in mapping different application job flow entitled to Tableau dashboard
• Developed and executed SQL Scripts for Referential Integrity check, which checks validity of incoming data with master tables in database
• Create and maintain UNIX scripts, Sybase/Oracle stored procedures Autosys job dependencies
• Extensively Worked with Data Warehouse team to create and export data scripts
• Responsible for resolving escalated production incidents related to performance using Remedy ticketing tool
• Experienced in checking file transfer activities via FTP and SFTP
• Experienced in FTP management, and knowledge of core Internet and networking protocols, firewalls and other network security systems
• Monitored health and performance of the Share Point environment by using unified logging service, usage service application, developer dashboard and usage reporting.
• Involved in 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, Splunk, Oracle 10g, SQL Server 2008, Sybase, Tableau 9.1, Secure CRT, Autosys, Toad, Perl, Unix Shell scripting

Confidential, Chester brook, PA

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 and processes for better performance
• 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
• Attended daily SCRUM stand up meetings
• Responsible for resolving Production issues and participate in Root Cause Analysis
• 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, Oracle 11g, Tableau 8.1, Business Objects, Toad, Perl, Unix Shell scripting

Confidential, Phoenix, AZ

Production support Informatica

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
• Scheduled Workflows in Autosys and configured the event based trigger to kick off the conversion engine.
• Involved in fixing defects found in QA and production
• 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, SQL Query Analyzer, Oracle 11g, Informatica 9.1, Autosys, QC, DB2

Confidential, Novato, CA

IT Anlayst

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 Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE
• 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