SUMMARY:

I am seeking a challenging and rewarding position as a Principal Developer.

TECHNICAL SKILLS:

• Oracle 8i to 12c
• SQL Tuning
• Project Management
• Requirements Analysis
• Data Analysis
• Development Standards
• Agile Methodologies
• Unix
• Dynamic SQL
• Huge Datasets
• ETL development
• Data modeling
• Database design
• Data migration
• SQL and PL/SQL development
• Test Cases / QA
• Stored Procedures
• Packages
• Tables
• Partitions/Subpartitions
• Views
• Analyzing Tables
• CA Workload Scheduling
• MS Excel / VBA
• SAP BW

WORK EXPERIENCE:

Lead Application Developer

Confidential, Chandler, AZ

Responsibilities:

• Act as a primary, dedicated technology interface owning the technical responsibility for architecture, analysis, design, development, and implementation of responsive user interface.
• Work closely with product to define and implement and improve user experience.
• Responsible for day - to-day task management and sprint planning
• Worked closely with product and stakeholders, participating in design sessions
• Lead and mentor developers and engineers to ensure that they follow best practices and guidelines
• Worked with QA to assure top quality deliverables on-time
• Major participant in database application tuning
• Develop complex business logic in the Oracle database using PL/SQL
• Working knowledge of Payroll Tax Process
• Designed and developed technical solutions with long term goals
• Translate business requirements, develop, code, and test transformation
• Provide technical support and worked cohesively with other development teams.

Senior Application Developer

Confidential, Chandler, AZ

Responsibilities:

• Design, implement, and contribute to application development.
• Major participant in database application tuning
• Data migration from DB2 to Oracle
• Develop complex business logic in the Oracle database using PL/SQL
• Working knowledge of Payroll Tax Process
• Designed and developed technical solutions with long term goals
• Translate business requirements, develop, code, and test transformation
• Provide technical support and worked cohesively with other development teams.
• Understanding of the Confidential business process, allowed me to make constructive decisions
• Work with Product Management as needed to understand product direction and strategy
• Support development and deployment of application software releases to production and pre - production environments

Senior Applications Developer

Confidential, Phoenix, AZ

Responsibilities:

• Work with project manager and business analyst to define clear project objectives.
• Developed and presented data analysis for proof of concept plus statistics for preliminary requirements
• Formulated strategy required for SDLC.
• Designed, developed, and implemented solutions to meet goals of business requirements.
• Analyzed, reviewed, and modified SQL to increase operating efficiency or adapt to any new requirements.
• Provided documentation which included timing, sizing, development strategy, detailed data analysis, and implementation strategy.
• Enhanced code to utilizing Dynamic SQL
• Performed functional, regression, user interface and performance testing on modifications/enhancements prior to production release.
• Created and modified CA Workload Scheduling jil files to manage daily or monthly jobs.
• Created and modified UNIX ksh scripts to execute SQL scripts and PL/SQL procedures.
• Work on huge datasets focused on the Pharmacy and practitioner industry.

Senior PL/SQL Developer

Confidential, New York, NY

Responsibilities:

• Utilized both Waterfall and Agile methodologies
• Created logical model including Entity - Relationship diagram
• Converted logical model into physical model
• Designed and implemented schema
• Designed and implemented Warehouse
• Expert in the development of PL/SQL Scripts, Procedures, Functions, Packages, Triggers and Cursors to implement business logic.
• Expert in SQL Tuning for complex queries and query optimization tools like explain plan.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import
• Proficient in Data analysis, Data modeling, Database modeling (both logical and physical)
• Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.
• Investigated data quality issues and implemented appropriate solutions.
• Helped to improve the performance, scalability and stability of database systems.
• Identified and implemented programming enhancements.
• Documented code in accordance with company policies, company standards and industry best practices.
• Designed release management procedures for Development
• Data migration (mapping, validation, cleanup) for Business Intelligence solutions.
• Ensured all applications and reporting solutions were clearly integrated and synchronized.
• Interacted closely with the users to define the new business process requirements.
• Experienced in building and sustaining standards and best practices for data quality standards.
• Excellent interpersonal and communication skills to work cross functionally with other enterprise team members.

Senior Programmer/Analyst

Confidential, New York, NY

Responsibilities:

• Gathered business requirements from product owners Data modeling and software design
• Created test cases for functional and regression testing
• Coordinated and supervised product testing and roll - out
• Coordinated and administered both classroom and one on one training sessions
• Provided training documentation

Primary technologies: Clipper and Visual Basic; dBase and SQL Server; Client-Server System over Novel LAN.

Senior Programmer

Confidential, New York, NY

Responsibilities:

• Data modeling and software design
• Created test cases for functional and regression testing
• Coordinated and supervised product roll - out
• Coordinated training documentation with support team

Primary technologies: Clipper and dBase

Senior Analyst

Confidential, New York, NY

Responsibilities:

• Gathered business requirements from product owners
• Data modeling and software design
• Created test cases for functional and regression testing
• Coordinated and supervised product roll - out
• Coordinated and administered one on one training sessions
• Provided training documentation
• Built servers and client PCs

Primary technologies: Clipper with dBase backend; Client-Server System over Novel LAN