Software Developer Resume

PROFESSIONAL SUMMARY:

Having 6+ years of experience in ETL development for Corporate Banking, Financial Service Sectors.
Well versed in Relational Database, Data warehouse concept and Analytical reports using BI tools.
Experienced in implementing end to end Informatica Power Center based ETL solutions.
Expert to write complex SQL query and PL/SQL programming.
Performed fine tune of SQL queries and ETL workflows and also utilized in Query plans.
Hands on experience in Unix & Shell Scripting and AutoSys Scheduler.
Produced attractive visuals/dashboards to convey teh story inside teh data.
Excellent communication and documentation skills.

TECHNICAL SKILLS:

ORACLE, DB2
SQL, Pl/SQL
Erwin
JIRA,Data Warehousing
INFORMATICA
UNIX, Windows
TableauAGILE (Scrum)
AutoSys
Shell Scripting
SVN, PERFORCE

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Responsibilities:

Utilized agile software development life cycle to translate business requirements into robust solutions.
Engaged in requirement gathering by interacting with teh Business Analysts of various teams.
Acted as SME/Module lead with 4 associates under my guidance.
Collaboration with teh clients and Influence team members to discuss Incident and Project Management.
Developed and maintained Extract, Transformation and Loading mappings to extract teh data from multiple source systems like relational databases and Flat files and loaded into Oracle.
Developed and maintained SQL and PL/SQL programming such as Procedure, Function, triggers etc.
Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance Tuning and Unit testing of ETL Sessions, Batches and Target Data.
Involved in troubleshooting, root cause analysis, debugging Informatica mappings, impact analysis and providing innovative vision and solutions.
Prepared Runbook, Test Plan, Test Cases and performed unit testing.
Performed release management and version control using SVN.
Prepared ISO 9000 quality standards Program Specification and Technical Design Specification documents.
Requirement analysis, planning, organizing, prioritizing work, coding and testing various modules.
Utilized agile methodology with JIRA to plan and execute ETL design activities.
Prioritizing a list of tasks and focusing on higher value tasks with more immediate deadlines.
Proactively communicated with teh clients and develop a customized database modeling application.
Proficient in working with various Informatica Client tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
Worked on Data Extraction, Transformation and Loading from various data source systems.
Responsible for batch processing task using AutoSys and UNIX scripting.
Programming, trouble shooting and root cause analysis of SQL, PL/SQL code and PostgreSQL.
Created Tableau dashboards, visualizations, and performing advanced analytics to analyze data.
Involved in trouble shooting of performance issues which were associated with Tableau reports.
Developed Tableau desktop/ server reports and dashboards and Troubleshoot related issues queries.
Performed release management and version control using Perforce.
Prepared standards Technical Specification documents, Test Cases and Run book.
Performed L3 applications production support on a ROTA.

Environment: Informatica Powercenter 9.5, DB2, PostgreSQL, SQL, PL/SQL, Tableau, OLTP, OLAP UNIX/Shell Scripting, AutoSys, Araxis/Dbartisan, JIRA, Perforce, Windows 10, Ms Office (Word, Excel).

Confidential

Software Developer

Responsibilities:

Interacting with teh client to get teh requirement from teh client to enhanced teh business process.
Created different types of user interface using Oracle Forms for teh end users.
Developed Packages, Procedures, Functions and Triggers for designing user interface using Pl/SQL.
Analyze and Troubleshoot Pl/SQL code based on teh Client request.
Utilized DML and DDL statements for data manipulations.
Created Oracle Reports based on teh various requirement of teh clients.
Provided system support to control and run fundamental business tasks.

Environment: Oracle 11g, Oracle Forms, Oracle Reports, Windows Server 2008 R2, SQL, PL/SQL, OLTP, Toad, Ms Office (Word, Excel, power point).

Confidential

Software Developer

Responsibilities:

Gathering business requirements and improving processes based on teh Client Request.
Designed and developed user interface using Oracle Forms and reports based on teh requirements.
Programming using SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views.
Analysis, Debugging and Maintenance of critical issues and live production server support.

Environment: Oracle 10g, Oracle Forms and Reports (10g), Windows Server 2008 R2, SQL, PL/SQL, Toad.s on request.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship