SUMMARY:

• 6+ years of experience in Information Technology with demonstrated expertise in providing cost effective, unconstrained, integrated and optimized business solutions in Financial Services domain.
• Areas of Strength - Data Analysis, Data Integration, Data Modeling, Database Development and Data Warehousing.
• Experience in working with very large data sets. Experience building robust and high performance distributed batch processing and Real-time data processing applications.
• Strong development background using technologies - Oracle SQL/PLSQL, Informatica PowerCenter and UNIX Shell Scripting.
• Experience working on LINUX platform. Experience working with UNIX shell scripts.
• Excellent communicator and liaison between business and technology, with reputation for managing and delivering multiple, large-scale projects.
• Experience working in Agile and Waterfall based development methodologies.

Technical Expertise:

• In-depth Knowledge of Oracle Database Architecture, Oracle Replication, Oracle Advanced Features like Partitioning and Parallelism, Oracle 11g (Exadata). Extensively used Oracle Partitioning and Parallelism, Oracle Bulk PL/SQL and Dynamic SQL features for processing large amount of transaction data.
• Good knowledge in Relational and Dimensional Modeling. Good knowledge of Type 1, 2 Dimensions, Bridges, and Fact Tables.
• In-depth knowledge in Oracle SQL, Stored Procedures, Functions, Packages, Sequences, Triggers, and Materialized Views. Proficient in using TOAD, SQL Developer.
• Expert knowledge in Oracle SQL and PL/SQL Performance Tuning. Expert knowledge of Oracle Optimizer, Join Methods, Indexing techniques, Hints, Partitioning and Parallel execution process.
• Strong experience in Informatica Power Center 10x/9.X/8.X. Well acquainted with Informatica client tools Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in performance tuning of Informatica Sources, Transformations, Targets, Mappings, Worklets, Workflows, and Sessions.
• Good Knowledge in UNIX Shell Scripting and Python Programming. Used extensively for job automation. Good knowledge of secure file transmission protocols like SFTP, SCP and SSH. Good knowledge of Advanced UNIX programming in AWK and SED.
• Extensive working knowledge in ControlM Enterprise Job Scheduling tool. Used ControlM Enterprise Manager for Monitoring Jobs on distributed platform. Used ControlM Planning tool for designing Jobs and Calendars. Used ControlM advanced features like BIM (Business Impact Manager) services for tracking SLA’s and monitoring critical batch cycles. Used ControlM Node Group feature for load balancing. Used ControlM cyclic jobs for real-time processing.
• Good Knowledge in Code Build and Deployment Process using IBM Rational Team Concert.

TECHNICAL SKILLS:

Database: Oracle 11g (Exadata)/10g/9i

Programming: Oracle SQL, PL/SQL, UNIX Scripting

Job Scheduling Tools: BMC ControlM

Source Code Control: IBM RTC, Clear Case

Server Side Scripting: UNIX Shell Scripting

Database Tools: TOAD, SQL Developer, PL/SQL Developer

ETL Tools: Informatica PowerCenter 10.1,9.1, 8.6

Development Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential 

Database Developer

Responsibilities:

• Responsible for Requirement Analysis, Technical Design and Development of Distributed Batch and Data Warehouse Applications.
• Design and Develop high performance Batch and Realtime processing applications.
• Project development which includes - Oracle PL/SQL development, ETL development in Informatica PowerCenter 9.1/ Informatica Data Quality, Shell Scripting in UNIX.
• Work closely with Architecture and Data Engineering Teams to develop Data Models. Work closely with Systems Analyst Team to develop Technical Specification documents and Mapping documents.
• Collaborate with Architects, Analysts, Developers, and Data Engineers, Infrastructure Support Engineers and DBA’s to design and develop scalable, cost effective and production stable solutions.
• Collaborate with Project Managers/Business Partners for Project Planning, Financial Planning, Resource Planning, Estimation, Risk/Issue Management and Status reporting.
• Work closely with QA team and Business Users during SIT and UAT phases to resolve defects and performance issues, and Data validation.
• Create and publish install and build deployment plans. Work closely with release management team during release weekends.
• Improve Production Stability through continuous performance tuning of batch jobs.
• Maintain High Availability of the Systems and Improve Data Quality to Business users through increased collaboration between Business and Technology, and develop real time data validation processes in the system.
• Drive the culture of innovation in the team. Automate daily routine production support tasks to increase operational efficiency and resource utilization.

Environment:RedHat Linux, Oracle 11g, BMC ControlM, Informatica PowerCenter 9.1, SQL Developer, IBM RTC

Confidential

Senior Software Engineer

Responsibilities:

• Responsible for Requirement Analysis, Technical Design and Development of Distributed Batch processing high performance Batch and Realtime processing applications.
• Project development which includes - Oracle PL/SQL development, ETL development in Informatica PowerCenter 9.1, Shell Scripting in UNIX.
• Work closely with Architecture and Data Engineering Teams to develop Data Models. Work closely with Systems Analyst Team to develop Technical Specification documents and Mapping documents.
• Collaborate with Architects, Analysts, Developers, and Data Engineers, Infrastructure Support Engineers and DBA’s to design and develop scalable, cost effective and production stable solutions.
• Collaborate with Project Managers/Business Partners for Project Planning, Financial Planning, Resource Planning, Estimation, Risk/Issue Management and Status reporting.
• Work closely with QA team and Business Users during SIT and UAT phases to resolve defects and performance issues, and Data validation.
• Create and publish install and build deployment plans. Work closely with release management team during release weekends.
• Improve Production Stability through continuous performance tuning of batch jobs.
• Maintain High Availability of the Systems and Improve Data Quality to Business users through increased collaboration between Business and Technology, and develop real time data validation processes in the system.
• Drive the culture of innovation in the team. Automate daily routine production support tasks to increase operational efficiency and resource utilization.

Environment:RedHat Linux, Oracle 11g, Informatica PowerCenter 9.1/8.6, Informatica IDQ SQL Developer, Clearcase

Confidential

Software Engineer

Responsibilities:

• Requirement Analysis, produce Technical Design documents. Work closely with Systems Analyst Team to develop Technical Specification documents and Data Mapping documents.
• Project development which includes - Oracle PL/SQL development, ETL development in Informatica PowerCenter 9.1/ Informatica Data Quality, Shell Scripting in UNIX.
• Develop Oracle Stored procedures, Functions, Packages and Triggers. Develop complex SQL queries to perform store and process data coming from front end applications.
• Develop UNIX shell scripts for job configuration and automation on LINUX environment.
• Develop SQL Loader scripts to process and store data coming from external and internal source systems.
• Perform peer code reviews.
• Document and Maintain System functionality. Create and execute Unit Test cases.
• Work closely with QA team and Business Users during SIT and UAT phases to resolve defects and performance issues, and Data validation.
• Create and publish install and build deployment plans. Work closely with release management team during release weekends.

Environment:Informatica PowerCenter, Oracle 10g, PLSQL Developer, SQL PLUS, Windows, Toad, LINUX