SUMMARY

• Software Application Developer vast in all phases of the software development lifecycle process with a passion to create solutions that improve critical business processes.
• 9+ Years of diverse experience utilizing Oracle and Java technologies and frameworks to build client and server side software applications.
• Certified in Oracle Database Administration and PL/SQL Development (OCA).
• Extensive experience implementing Oracle Database Applications by writing Oracle PL/SQL Packages, Procedures and Functions and Database Triggers.
• Fluid understanding of designing, implementing and deploying enterprise web applications that interact with Oracle Stored procedures.
• Good hands on experience with performance tuning techniques, table DE normalization, using indexes, PL/SQL Collections, bulk binding and function based indexes.
• Mastered Data warehouse architecture and designing Star schema, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Advance UNIX Shell scripting: Bash, C - shell and KORN Shell.
• Good understanding of mapping business processes into technical specifications.
• Excellent communications skills. Adept at building strong working relationships with coworkers and management.
• Consistently demonstrates ability as a problem solver, innovative and knowledgeable developer that goes above and beyond in order to exceed expectations.
• Constantly learning and leveraging emerging technologies

TECHNICAL SKILLS

Technologies: PL/SQL, Java J2EE technologies, JUnit, Spring, Hibernate, JPA, JAX-RS API, (Jersey RESTful), XML, JSON, C, C++, SQL, T- SQL, Cobol, JSP & Servlets, PHP, JavaScript, XML, HTML, Python and Shell Script(korn shell, bash) SOAP, Ant, Maven

Software’s: SQL Developer, Toad, IBM DataStage 8.1, Microsoft SSIS, Oracle Forms & Reports, SQL Navigator, SQL *Plus, SQL Optimizer, PVCS, Subversion, C++ Builder IDE, VERITAS Backup Exec, Microsoft Office Suite, Power Designer, AMISYS Healthcare, Microsoft TFS, UC4/Appworx,Spotfire.

Object Oriented: OOA/D, UML, Spring, EJB

Databases: Oracle RDBMS Databases, MySQL PostgreSQL, SQL Server, NoSQL (HBase)

Big Data Ecosystem: HDFS (Hadoop), MapReduce, YARN, Hbase, Pig, Hive, Sqoop

Application/Web Servers: Apache, Tomcat 5.5, Glassfish, XAMPP

Platforms: Windows 2000/XP/Vista/7, Mac OS, and Linux

Methodologies: Agile, Design Patterns

PROFESSIONAL EXPERIENCE

Confidential, Edina, MN

Oracle PL/SQL Developer / Technical Analyst

Environment: Oracle Database 11g, PL/SQL, Java, Spring MVC, Ant, HTML, Glassfish4, CSS, JQuery, JSON, UNIX, JIRA, TOAD 12. Eclipse

Responsibilities:

• Wrote the technical specifications for new features and was in charge of making sure the enhancements were successfully implemented to client standards.
• Work closely with technical analyst and business analyst to understand the clients need, propose technology solutions and followed SDLC procedures.
• Designed and implemented a report management database that provides our clients daily adhoc reports by making use of Oracle analytical functions.
• Developed PL/SQL packages to encrypt username and password information that is stored in database.
• Performance enhancements to Oracle processes and procedures with regards to automated daily, weekly and monthly LTS and ARZ processes.
• Lead technical resource responsible for supporting the business operations team with data pull needs and LTS application questions.
• Worked with the business operations team to streamline the process of making hotfixes to the production database.
• Daily activities include troubleshooting, debugging and optimizing existing processes for peak performance.

Confidential, Columbus, OH

Oracle Application Consultant

Environment: Oracle Database 11g, Teradata, PL/SQL, Java, Spring, HTML, Apache POI, CSS, JQuery, JSON, UNIX, PUTTY, Git, SVN, Confluence, SAS, Spotfire (Visualization tool), Sql Developer, Eclipse

Responsibilities:

• Participated in designing the interface and backend framework to upload, edit and manage critical data information.
• Create the database architecture required to support the linking, loading, and storage of the new data in the Oracle Database, consistent with the existing architecture.
• Develop the Spring MVC application logic that links and loads excel data sets into the Oracle Database.
• Created packages, procedures, triggers, tables, views and ref cursors for data management.
• Implement object oriented designs using design patterns in business tiers (Business Delegate Pattern)
• Built tool to visualize data forecast using Spotfire (Visualization tool)
• Developed the DAO layer for frontend application
• Configured SSO (single-sign on) on development server for frontend application.
• Conduct code reviews and provided guidance to less experienced associates.
• Develop manuals for new software installation and managements
• Wrote Unix Shell Scripts to automate the creation and loading of Oracle Database tables, packages, procedures, functions, and triggers.
• Use Git and SVN as versioning tool.

Confidential, Minneapolis, MN

Senior Programmer Analyst

Responsibilities:

• Analyze business requirements and recommend appropriate technology with estimates of the time and effort required for development.
• Participate in stand-up, pre-planning and planning meetings.
• Developed Technical Design based on business functional and non-functional requirements
• Design and build detailed and complex logic in PL/SQL packages and shell scripts that integrate with Amisys healthcare software, which is used to pay healthcare claims and manage subscriber eligibility.
• Developed PL/SQL packages to encrypt and decrypt patient medical information over email.
• Developed ETL process to extract source data and load it into enterprise data warehouse after cleansing, transforming and integrating
• Performance Tuning on Data Staging jobs.
• Wrote UNIX KORN shell scripts for batch job invocation.
• Automate the generation of daily and monthly data extracts using Unix shell scripts, PL/SQL packages and jobs.
• Collaborate with Project Lead to develop and implement user test plans and new software implementations including Amisys modules, extensions to the Amisys systems, and internal and third party systems/applications.
• Conduct code reviews and provided guidance to less experienced associates.
• Assist with developing required interface documentation.
• Use TFS as versioning tool.

Confidential, Bloomington, MN

Application Developer

Responsibilities:

• Active member of a team, that provides continuous technical support to various clients of FLEXCUBE Banking Product called Daybreak. A web based Banking application, built on the Oracle Application Development Framework an end-end Java EE framework.
• Developed customized programs using Java/J2EE technology.
• Enhanced and Customized existing UI modules using JavaServer Pages (JSP), JavaScript and ADF RAD tools
• Developed and performance tuned Oracle PL/SQL packages and modules to support extended functionality.
• Performed and documented unit and integration testing of developed modules and regression testing for subsequent releases.
• Enhanced SOAP Web Services application implemented in Java that integrates with third-party systems like Dealer Track, Route One and Kelly Blue Book.
• Followed strong and efficient SDLC proceedings that resolve and deliver an average of 15 development-required fixes to client in a month.
• Performed code review for other team members implementations
• Wrote UNIX Shell Script for Batch Data load processes.
• Used PVCS as versioning tool.

Confidential, Plymouth, MN

Oracle PL/SQL Developer

Responsibilities:

• Enhanced and maintained a web reporting application site with an oracle back end utilizing PL/SQL, HTML,Java, and JavaScript that allows warehouse data manipulation activity
• Initiated and oversaw the creation of a Java API that emails period end reports to clients in a safe and efficient manner.
• Built the middle and persistence layer using the JavaMail API and Java Activation Framework (JAF)
• Designed front end desktop interactive screens
• Designed, developed and maintained Oracle PL/SQL packages and procedures that implement weekly and monthly data imports and export processes.
• Developed and Enhance daily data import batch process using Pro C.
• Converted manual weekly data import and export reporting processes to automated processes.
• Established necessary sequences and realistic timescales for tasks in order to achieve a goal.
• Installed and configured Oracle production test database environment
• Create and document new IT methodology for daily IT processes
• Provide ongoing technical support to clients utilizing the online data reporting applications
• Generate ad hoc reports using Oracle PL/SQL on a weekly basis
• Used subversion as versioning tool.