SUMMARY

• Highly skilled and dedicated IT professional with 13 years of experience in applications development, technical support, migration, configuration management, preparing functional requirement documentations and strong leadership skills used to maximize team performance and results.
• Worked on Informatica, Sybase, Microsoft SQL, Python, Unix Scripting with good noledge in Investment Banking and Healthcare domains.
• Committed and motivated employee focused on teh success of teh team, upholding teh company values, with strong focus on ethics and professionalism.
• Extensive experience in System Analysis, Design, Development, Testing, Implementation and Maintenance of Business and Enterprise applications for major Financial and Health care clients.
• 11 years of total IT experience (13 yrs.) primarily in Investment Banking domain.
• Having valuable experience of managing a team size of 10 members.
• Excellent leadership skills and ability to take responsibility in case of crisis situation.
• Experienced in providing quick fixes/workarounds keeping turnaround time minimum.
• Strong troubleshooting skills, strong experience of working with ETL in a data warehouse environment.
• Ability to Multi - task in a fast-paced AGILE environment, deadline driven environment.
• Extensive experience in database programming in writing Cursors, Stored procedures, Triggers and Indexes.
• Responsible for managing scope, planning, tracking, change control, aspects of teh project.
• Expert in analysis, design and Problem solving and experience with performance tuning and system monitoring.
• Good communication skills, interpersonal skills, self-motivated and a quick learner.

TECHNICAL SKILLS

Operating Systems: Unix/Linux, Windows

ETL Tool: Informatica PowerCenter 9.1

Languages: PL/SQL, Python, Unix Shell scripting

Database: Sybase, Microsoft SQL

Tools: Aqua Data Studio, SQL Management Studio, Autosys, Control-M, Putty, Procmon, VSTS

Domain: Banking, Medical

PROFESSIONAL EXPERIENCE

Confidential - Salt Lake, UT

Informatica Developer

Responsibilities:

• Analyze teh functional requirements and convert them into techno functional requirements.
• Develop code using noledge of relevant technology (Informatica Power Center 9.1, Unix scripting, Sybase 15.7 and Python)
• Development, maintenance and performance tuning of DB stored procedures.
• Used Informatica Power center client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded teh process of data flow from source system to data warehouse.
• Implementing Informatica workflows for data feed extractions and data load processing.
• Develop Python code for data feed extraction and also loading data into database.
• Knowledge of software development life cycle and agile development practices
• Bug fix and enhancements to ensure smooth functioning of teh PWM business.
• Manage communication to stakeholders on any issues and ensure efficient support within SLA.
• Good noledge of teh Autosys scheduling tool.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Develop proof of concept (POC) to validate proposed solution and reduce technical risk.
• Automation of Bank processes such as data backfilling, failure checks, validation, reporting
• Experience in Unix shell scripting for teh developing tools to handle teh support tasks.
• Code review, team management and mentoring.

Confidential

Responsibilities:

• Proficient in working on Portia and Perform products in teh Investment management products.
• Perform business and data analysis based on teh functional specifications provided by teh business users and managers to create Profiling data for business and analyst validation.
• Report creation and other business functionality modules in Portia.
• Developed various applications/automation for data retrieval and data import/export from and to teh Asset management system.
• Set up and System administration in Charles River system CRD version 9.1.
• Support and maintenance of teh Wealth and Asset management applications like Portia, Perform, FMDPM which involves batch scripting and data management techniques.
• Crystal Report creation in eReports product.

Confidential

Responsibilities:

• Developed teh functionality of downloading data and settings data manipulation from teh Flow generator device.
• Developed stored procedures using SQL server for Admin related functionalities using dynamic stored procedure concept.
• Performed Integration Testing and Regression testing of windows and web-based application.
• Developed teh database handler module of teh admin functionalities in teh online version of teh application.
• Lead a 3-member team in performing testing of teh windows-based application and teh web-based application.

Confidential

Responsibilities:

• Implemented teh Stores receiving and directs receiving module in Goods Out functionality of teh application using 3 tier architectures in C# 2.0.
• Developed queries in MS SQL for teh database processing in Inter store transfer and Intra store transfer modules.
• Performed Integration testing and Regression testing of teh application.