Senior Software Developer Resume
SUMMARY
- 7.5 years of software industry experience with Application Development in Banking, Insurance and Telecom Domain.
- Over 7 years of experience in designing and developing applications using Oracle SQL, PL/SQL, Core Java, Unix Shell scripting.
- 3 Years of experience in developing enterprise - based applications using Hadoop ecosystem.
- Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
- Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, xls files, Flat files and loaded into Oracle database.
- Involved in data modeling for designing and developing various Oracle database objects.
- Experience in developing MapReduce programming model using Core Java and Python.
- Experience with J2EE framework such as Hibernate, Servlet, JSP, JavaScript.
- Experience in working and setting up environments on AWS EC2 instances.
- Build different PL/SQL objects such as function, procedure, package, trigger and complex SQL queries.
- Involved in data loading using SQL*Loader with UNIX shell scripts.
- Performed Database, SQL and Application tuning using various tools like TKPROF, AUTOTRACE.
- Worked on creating and scheduling jobs using DBMS SCHEDULER.
- Extensively worked on UNIX shell scripting with good knowledge of various Unix command line commands.
- Used Oracle collections to bulk bind data from the database.
- Developed Materialized views for transferring data between several environments.
- Extensively used development Tools such as TOAD, PL/SQL developer, SQL*PLUS.
- Involved in data migration from Production to different test environments.
- Managed a small team of five people in the ALIP project at Confidential .
- Well versed in various phases of the software development life cycle - Analysis, Design, Development, Testing, Deployment.
TECHNICAL SKILLS
Programming Capabilities: Oracle PL/SQL, Core Java, Oracle SQL, Informatica PowerCenter, Hadoop, HDFS, MapReduce, Apache Spark Core, Spark SQL, Pig, Hive, HiveQL, HBase, Sqoop, Oozie, Flume, Kafka, Amazon Web Services (AWS), SQL*Loader, Hibernate, JavaScript, Servlet, JSP, Matlab, R, SPARQL, Pro*C, HTML, XML.
Scripting Language: Unix Shell Scripting, Python.
Database: Oracle 11g, Oracle 10g
Operating System: Unix, Linux, Mac OS, Windows XP.
Tools: & Utilities: Informatica PowerCenter 9.x, Eclipse, Anaconda, PL/SQL Developer, Toad, Protégé
Version Control Tools: CCRC, VSS 6.0, CVS, IBM Clear Quest
Domains: Banking, Insurance, Telecom Billing
PROFESSIONAL EXPERIENCE
Confidential
Senior Software Developer
Responsibilities:
- Responsible for generating reports using Hadoop ecosystem and sending it to BA for analysis.
- Designing and development of various Oracle database objects.
- Migrating data from Oracle HRMS to Oracle HCM system using Informatica PowerCenter.
- Interacting with clients, requirement gathering, design and delivery.
- Preparing Unit test plans and documentations for Deployment.
Confidential
Responsibilities:
- The project required rebuilding of complex SQL statements used for generating various reports, into Oracle Procedures, Functions and Packages, so as to tune the report generation time.
- Generating data for analysis using Hadoop ecosystem.
- Interacting with clients, requirement gathering, design and delivery.
- Solving complex SCRs related to product functionality.
- Preparing Unit test plans and documentations for Deployment.
Confidential
Senior Software Developer
Responsibilities:
- Developed Procedures, Functions, Triggers and other database objects based on requirement.
- Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files, to the Oracle database.
- Responsible for deployment at the component level.
- Solving SCRs related to product functionality.
- Preparing Unit test plans and documentations for release.
Confidential
Senior Subject Matter Expert
Responsibilities:
- Development and implementation of Database objects based on change request.
- Investigations of Production issues/Jobs and providing work around and fixes.
- Unit/Integration Testing & UAT test case development.
- Preparing various documents for release.
Confidential
Software Developer
Responsibilities:
- Involved in interaction with client, requirement capturing and component design.
- Designing and development Database objects, shell scripts, front-end applications.
- Preparing Unit test plans and documents for release.
Confidential
Responsibilities:
- Design and development of applications using Pro*C, PL/SQL, Shell Scripting.
- Developing front end application using Core Java.
- Involved in production release & support for new changes.
- Unit/Integration Testing & test case development.
