SUMMARY:

• 11 years of IT experience in designing, developing and implementing Complex Business applications, using Oracle Relational Database Management System (RDBMS), Extract Transform Load (ETL) tools, Unix and Core Java technologies.
• Hands on experience in all phases of Software Development Life Cycle (SDLC) like business requirements gathering, analysis, technical design, coding, testing, implementation, primary and secondary production support.
• Experienced in implementing software projects using Waterfall and Agile methodologies.
• Worked closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications, refine conceptual systems design requirements into technical design.
• Extensive experience in developing applications using Oracle database 12c/11g/10g and strong Designing and Coding Experience in Oracle PL/SQL & SQL.
• Expertise in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace on Oracle 12c/11g/10g databases.
• Experience in data Extraction, Transformation and Loading (ETL) processes to load data from various data sources like Oracle, SQL Server utilizing ETL tools and from different file formats using Oracle Utility tools SQL*Loader, Import and Export.
• Expertise in working with Oracle built - in packages and built-in SQL functions.
• Solid background in Object Oriented analysis and design, Core Java, JDBC concepts, JUnit API, XML and XSLT.
• Exposure to Spring Core and Hibernate frameworks and yet willing to broaden my knowledge.
• Experienced with Unix Shell scripting and have worked on many cron-based scripts, which generate reports based on business logic and scheduled them using Autosys concepts.
• Good Knowledge in code merge and maintenance using SVN and GIT.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, possess excellent communication, interpersonal, project management and project documentation skills.
• Received many appreciations from Client for delivering bug free product within the estimated project timelines.
• Developed and managed software projects for the clients in Manufacturing, Human Resources, HealthCare and Finance Domains and yet willing to broaden my exposure in other domains.
• Experienced in Production Support activities which include organizing new development releases, interacting with different support teams, analyze, resolve and effectively communicate to users on the resolution status in case of any production issues.
• Knowledge of AWS, Python, Hadoop, Map Reduce, Sqoop and yet willing to broaden by knowledge.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, Oracle 11g, Oracle 10g, 9i

Scripting: SQL, PL/SQL, Core Java, C and UNIX shell scripting, XSLT

Tools: Toad, Oracle SQL Developer, PL SQL Developer, SQL Plus, Terminal, Eclipse, Maven, ETL Development tools

OS: Mac, Windows

Other Tools: AutoSys, Tidal, SVN, GIT, WinSCP, WIN Merge, iTerm, Putty, TFS

Microsoft Office Suite MSWord, MS: Excel, MS-Power point, MAC utility software - Numbers, Pages, BBEdit

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

Technical Consultant

Responsibilities:

• Create Data loaders using ETL tools to Extract data from multiple sources, Transform the data for calculations and Load it into IDW database.
• Develop Database Schemas using Oracle technology, develop packages, procedures, functions and scripts using Oracle PL/SQL technology as per the business requirements.
• Develop custom publications to publish data to different vendors and customers.
• Create Autosys jobs to auto schedule data loads and publications.
• Work with Business Analyst team to understand the requirements, document technical designs.
• Coordinate with Quality Assurance team for system testing and resolve functionality issues.
• Participate in daily standup, planning meetings to prioritize the tasks for the sprint and develop solutions in Agile methodology.
• Provide technical solutions for day to day production issues which couldn't be resolved by operations team.

Environment: ETL tool, Oracle 12c, 11g, SQL, PL/SQL, SQL*Loader, SVN, GIT, Windows OS.

Confidential, Buffalo, NY

Technical Lead

Responsibilities:

• Understand business requirements and specifications and develop technical specs and Architecture documents as per requirements.
• Develop solutions as per the requirements using Oracle Pl/SQL technology in Agile Methodology
• Schedule jobs using Tidal scheduling tool as per business requirements
• Invoke different SOA services during each stage of Message Broker Orchestration process and convert XML response from one format to a different format as per XSD using XSLTransformation.
• Participate in daily standup, Planning and Backlog grooming meetings to prioritize the stories/tasks for a sprint and report to Scrum Master on the status.
• Coordinating with the testing team for system testing and UAT support for customers.

Environment: Oracle 12c, 11g, SQL, PL/SQL, SQL*Loader, Java XSLT, Tidal, SVN, Maven, HP Service Anywhere, HP Service Desk, Windows OS, Junit.

Confidential, Boston, MA

Technical Lead

Responsibilities:

• Understand business requirements and specifications and develop technical specs and architecture documents as per requirements.
• Develop solutions as per the requirements using Oracle Pl/SQL technology in Agile methodology
• Participate in daily standup, Planning and Backlog grooming meetings to prioritize the stories/tasks for the Iterations and report to Scrum Master on the status.
• Coordinating with the testing team for system testing and UAT support for customers.
• Provide technical solutions for day to day production issues which couldn't be resolved by operations team.
• Provided support for existing database migration to Oracle 12C Exadata database.

Confidential, Cupertino, CA

Production Support Analyst

Responsibilities:

• Coordinating new project releases by working with development teams
• Analyze and provide suitable solutions with Kronos workforce configurations.
• Understanding newly introduced features, which are introduced as part of a new development releases and understanding the technical designs through knowledge transfer sessions with development teams.
• Organizing and managing the issues reported by Apple Employees/Managers in the production environment.
• Analyze and debug the problem if customer reports any issue and implement the fix for the reported issue after finding the technical resolution. This involves debugging and coding in different technologies based on the reported product.
• Analyze product performance issues and work with DBAs to fix the problem.
• Interacting with different Application Support teams in case of critical Production issues, proactively inform their Application Managers about the resolution status in a timely manner and resolve the issues with in time so that customers won’t get impacted due to the issue.
• Ensure that the weekend data loads, end-of-month & end-of-quarter processing run successfully.
• Guide the team in understanding and debugging the issues, conduct technical training sessions to the team and document the processes.

Environment: Oracle 10g, 11g Oracle (PL/SQL), Core and Advanced Java, SQL*Loader, ETL, Autosys, UNIX Shell Script, Cocoa, Kronos, MAC OS.

Confidential

Technical Lead

Responsibilities:

• Involved in Requirement Gathering and analysis, development, Integration and User Acceptance Testing, primary and secondary support phases of the project.
• Developed design documents, ER diagrams by analyzing the requirements and worked to define the project implementation strategies.
• Developed database objects like tables, views, indexes, and sequences.
• Involved in writing PL/SQL Packages, Functions, Stored Procedures and DB Triggers to implement complex business functionalities.
• Extensively developed PL/SQL sub-programs with features like
• FOR ALL, Bulk collect, and Save Exceptions etc.
• Dynamic SQL, Bind Variables.
• Inline cursors, Explicit cursor and Ref cursors
• Collections, Records
• PL/SQL Logging
• Pre-Defined and User-Defined Exception handlings.
• Usage of built in functions such as SQLCODE, SQLERRM for error reporting
• Worked on SQL concepts like
• Nested Tables, Global Temporary Tables.
• Materialized Views, DB Links
• SQL Queries and Sub Queries
• Spooling concepts
• Query Tuning using EXPLAIN PLAN, SQL Trace, TKPROF
• Analytical functions
• Understood complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Involved in the loading of the data from different data sources like CSV, XML, FLAT files etc., to the oracle database using SQL Loader.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used PL/SQL Built-in Packages DBMS STANDARD, DBMS OUTPUT, and UTL File etc.
• Wrote SQL Scripts for reports and creating views for reports.
• Have worked on many cron-based scripts, which generate reports based on business logic and sends email to users having the data in the form of HTML Tables/ Excel Attachments/ Txt Documents.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day-to-day administration scripts and setting up batch scripts.
• Supported operations during the build/deployment of a new release to the Integration, QA and Production environments.
• Handling the Web Service calls from PL/SQL.
• Developed java web services, java classes using core java technology.
• Testing using Junit API

Environment: Oracle 10g, 11g, SQL, PL/SQL, UNIX Shell Script, SQL*Loader, Autosys, Core and Advanced Java, SVN, MAC OS.