SUMMARY:

• 13 Years of IT experience working in Software development with emphasis on Analysis, Design, Development, Implementation and Management of applications using Oracle PL/SQL with functional expertise in Financial, Retail, Health care and Confidential domains
• Experience Analyzing, designing, developing testing and implementing complex enterprise software applications in comprehensive Software Development Life Cycle (SDLC) using agile, waterfall methodologies.
• Expert level experience in creating requirement specifications, Detailed Design specification, Architecture Diagrams and end - user Manuel
• Expert level experience working with Data in Data Analysis, Data Integration, Data Mapping, Data Conversion, Data Migration, Data flows and Metadata Management Services and Configuration.
• Strong experience in designing & creating database objects in Oracle 7/8i/9i/10g/11g for OLTP applications.
• Strong experience in developing of Complex database objects like Stored Procedures, Functions, Packages, Triggers, Tables, Views, Indexes, Constraints, Synonyms, Materialized Views, Partition Tables using SQL and PL/SQL
• Highly skilled in Performance tuning- analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required
• Expert level development skills in creating and maintaining shell scripts in korn, bash, Perl shells in Solaris, AIX, and HP-UX
• Expert level development skills working with file transfer utilities like NDM, FTP, and SFTP, FTP, Windows Batch.
• Extensive experience in data migration techniques using SQL* Loader, Import/Export.
• Strong exposure handling the production support emergency response calls Level l support.
• Strong exposure working in project management leading technical teams in the delivery of large scale software development, operational and integration efforts.
• Expect level skills in resolving highly complex software development issues that arise in production environments
• Extensive experience in SDLC processes development and post implementation support of various large-scale systems using Six Sigma methodology
• Expert level skills resolving business difficulties and shouldering technical and delivery responsibilities.
• Excellent ability to communicate effectively with internal and external staff despite varying levels of business or technical knowledge
• Accustomed to working in fast paced environments with the ability to think quickly and successfully handle demanding clients
• Strong experience in onsite-offshore business model and coordinating with team in off-shore.
• Excellent Interpersonal skills, team player, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks
• Excellent knowledge in Six Sigma, CMM, AGILE, AIM and SOX compliance.

TECHNICAL SKILLS:

Application: Financial Services, Health Care, Retail, Confidential

Programming: C, C++, Pro* C, SQL, PL/SQL, Korn, Bash, Perl Shell Scripting, Crontab, Autosys 11.3, Autosys 4.5, HTML, XML, CGI

Operating System: UNIX Solaris, Suse Linux, HP UX, IBM AIX, Windows Vista/XP/2003/2008

Databases: Oracle

Data Modeling: Erwin 3.5.2, 4.0

ETL: Informatica

Applications: MS Word, MS Excel, Visio, WCC, JAWS, TOAD, SQL Developer

Tools: VI Editor, F-Secure SSH Client, FTP, SFTP, NDM, Windows Bat, PGP

PROFESSIONAL EXPERIENCE:

Confidential,Madison,WI

Sr. PL/SQL Consultant/Architect

Responsibilities:

• Participation in requirements definition meetings and requirements documentation activities
• Perform data analysis activities to capture data requirements clearly, completely and correctly, and represent them through a logical data model.
• Responsible for gathering definition of architecture standards and data services with accompanying compliance measures
• Responsible for developing, publishing, and maintaining all documentation for data models
• Creating Design for Pl/Sql Packages, Function, Procedure and complete the design review and Modify existing module Packages, Functions depend on Business Requirement.
• Develop new PL/SQL packages and Working with database partitioning, Materlize views.
• Capture and model data requirements, data definitions, business rules, data quality requirements.
• Development of data model design based on analysis of new requirement applying relational and dimensional modeling OLTP and Data Warehousing environment using ERWIN
• Application Performance & Tuning for Sql and PL/SQL code
• Create and maintain data modeling, design and implementation standards.
• Work with Business Analysts, Data Architects, Software developers, DBAs to achieve PPCS-project objectives.
• Coordinate with clients, data users and key stakeholders to develop and achieve long term objectives for data architecture and data quality.
• Mentor team members in the development of complex data movement/SOA/ETL solutions.
• Generate physical database objects based on prepared models to facilitate solutions in accordance with Data Warehouse Architecture standards

Environment: Windows, Control M, Informatica Power Center 9.1, SQL Server, Teradata, ERWIN, XML, Oracle PL/SQL

Confidential,Hillsboro,OR

Sr. PL/SQL Developer

• Interpret functional requirements, create technical design and d evelop application systems, sub-systems, interfaces and libraries
• Developed complex PL/SQL stored procedures, user-defined functions, triggers, sub-queries, views and cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Developed korn shell Scripts to encrypt, decrypt, compress, un-compress, extract, transform and load data from flat files obtained from various facilities every day based on the project and business requirements.
• Perform detailed data analysis to understand the source and target system data and create detailed transformation mapping.
• Review physical Database objects including fact tables, dimensions, staging, materialized views, indexes provided by Data Modeler
• Develop complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations
• Develop SQL* Loader and export/import mechanism for data migration for bulk upload.
• Implemented PL/SQL to perform application security and batch job scheduling
• Prepared system documentation and provided assistance and training to team members by acting as a team advisor.
• Provided support and assistance as necessary during the system integration and user acceptance test phases
• Conducted interviews and work sessions with analysts and IT team members

Environment: Unix, Linux, Solaris, Korn, bash Shell Script, Perl Scripts, crontab, autosys 11.0, Oracle 8i/10g, PL/SQL, SQL, Informatica 9.1 Confidential,Nashville,TN

Sr. Systems Analyst

• Analysis of Confidential 's billing system, by converting Business Requirement Documents to Functional Requirement Document for different widgets of the system.
• Review, analyze and document Confidential ’s Billing System and create detailed functional specification document.
• Create process flows and data models to contribute to the development of project plans including project charter, project deliverables.
• Analyze Design, Develop, Test and Implement automation solutions using Unix Korn Shell and Autosys.
• Develop various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language
• Lead/Support troubleshooting and remediation of process and automation issues.
• Interface with manufacturing and other end users of the system and implement necessary changes to improve system’s overall efficiency.
• Provides technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
• Ensure that all requirements, project plans, and changes to are communicated to all affected team members before and after Implementation of the new changes.

Environment: Windows 8, Linux, Korn, Bash Shell Script, Perl Scripts, Oracle 8i/10g/11g, crontab, C, C++, Pro* C, Autpoys 4.5, crontab.

Confidential,Rogers,AR

Sr. Systems Analyst

• Manage PoC - Store Number Expansion project through the full project lifecycle.
• Assist the Business Analysis Team by reviewing business requirements and feasibility from a technical perspective, and providing time estimates for assigned work.
• Translate business requirements into functional requirements and analyze, design and develop the optimal technical solution for store number expansion
• Design and implement new jobs and work-flows within the scheduling environment to support daily, monthly, quarterly, and yearly data-flow processes
• Develop and implement store number expansion of business needs using C,C++
• Design and implement online and batch processes with Korn shell, Perl shell, Windows Batch, Oracle SQL, PL/SQL
• Ensure software code is well written and error free, with highest quality, through unit testing, code reviews, source control, change control, and documentation.
• Prepare promotion packages and implementation plans for deployment of changes to production, and provide ongoing support of promoted code.
• Address project management process and standards utilized for the requirements gathering, design, implementation and deployment of approved project.
• Evaluate and act on corrective actions to stay on schedule for new projects spawning to expand store number to accept integer value.

Environment: Linux, HP UX, Korn Shell Script, Perl Scripts, C, C++, SAS Scripts, Crontab, Autosys 4.5

Confidential,Egan,MN

Sr. Systems Analyst

• Requirement Gathering with the help of Joint Application Development sessions with Subject Matter Experts including business and technology stakeholders
• Elaborate product requirements and define acceptance criteria with team and Responsible for ensuring all work units are delivered on time
• Make effective use of daily stand-ups, iteration planning meetings, and retrospectives
• Design and build test automation frameworks for the back-end services that drive our systems
• Deliver automated test solutions (acceptance and regression) by developing codes using C# .NET, Spec Flow.
• Developed libraries to help us test field claims software more effectively
• Perform exploratory testing & Review the implementation of software developers and testers to ensure results
• Coordinate work assignments with a team of 5 developers and 2 testers and Maintaining defect data and analysis
• Involve in defect analysis and reduction (improve quality of work) and ensure all defined processes are followed
• Drive software demos to clients and demonstrate stories for acceptance criteria’s
• Document test cases and Create test plans for the back-end services that drive our systems
• Review the test strategies of other software testers to ensure results
• Promote best practices to our software development community and continuously refine our software development process to improve quality
• Provide mentoring to other software developers and testers

Environment: C# .Net, Spec Flow, Microsoft Visual Studio, Team Foundation Server 2010, Visual Studio 2010 Test Edition

Confidential,Wilmington,DE

Sr. Migration Engineer

• Requirement Gathering with the help of Joint Application Development sessions with Subject Matter Experts including business and technology stakeholders
• Documentation Business Requirement Document and conducting meetings with business to provide walk-through of final Business Requirement Document to get their concurrence and approval
• Preparation of Functional Requirement Document based on approved Business Requirement Document
• Extensively Work entire development team Programmers, Database Designers and other technology stakeholders to get their inputs to come up with new architecture suited for new environment
• Review of Mock architecture designed for the project based on approved Functional Requirements and conducting discussion with business stakeholders to get their input, concurrence and approval
• Analyze all the jobs and components which need to be migrated to new server, Also facilitate analysis to reduce the total batch run duration
• Design Job sequence and design scripts to reflect reduced job time lines
• Responsible for Job Sequence related changes for reflecting reduced time-lines
• Co-ordinate with infrastructure admin, unix admin, configuration admin to Setup the performance and production environment
• Designed/developed tables, views, various SQL queries, stored procedures, functions. Complex PL/SQL packages for the new environment.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Developed the Perl Shell Scripts, Unix Shell Sripts and Autosys Jobs to Work in 64 bit HP-Unix Environment.
• Migrate the jobs to new server, trouble shoot and fix the issues faced
• Testing the region by performing a batch cycle testing
• Configured, developed, tested, implemented, supported, and maintained autosys JIL scripts.
• Deliver the Performance Region to Business Testing for Batch Testing, Co-ordinate with Business Users to fix the issues faced.
• Volunteered to Migrated few of the lower level development accounts autosys jobs to its corresponding development itanium servers
• Played key role in validating and Migrating production jobs with the expertise and knowledge gathered setting up performance account jobs and Lower Level Account job Migration
• Migrated the autosys jobs with Higher Quality and delivered the application on planned time.

Environment: HP-UX, Autosys R11, Perl, Korn Shell, Windows Batch, FTP, SFTP, NDM, MF COBOL, Oracle 10g, PL/SQL, SQL Loader, C, C++, XML, HTML

Confidential,Chicago, IL

Sr. Automation Engineer

• Gather requirements from the business stakeholders and Blue Health Intelligence and Medical Intelligence application testers
• Walkthrough of functional requirement document to SME’s and for their input, concurrence and approval.
• Conducting system design sessions for data modeling and technical specification document for the project
• Review of Mock architecture designed for the project based on approved Functional Requirements with SME’s and Project Manager
• Day to day, hands on IBM AIX Operating System with experience in a complex environment
• Design and implement new jobs and workflows within the scheduling environment to support daily, monthly, quarterly, and yearly dataflow processes
• Developed codes using Perl Shell Scripts, Unix Korn Shell Scripts which helps in main functionalities of the application
• Develop Korn Shell Scripts to trigger Autosys, Informatica ETL Jobs.
• Develop PL/SQL Packages, Procedures, Functions and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Extensively involved designing, developing, testing and Implementing Autosys jobs
• Developed codes using C,C++ to act as long running component to accept xml data from jsp front end
• Prepared Test Plan, Test scripts and Test conditions for system and Integration testing.
• Performed Integration, system and regression testing and reported the test results to the users with the Traceability matrix
• Provide Technical support to the testing team members, fixed the issues as and when an error is reported
• Provide technical solutions to the Queries or Issues of the Business Users
• Implemented the project with Higher Quality and With Strict Timelines
• Apply knowledge of computer capabilities, subject matter, and symbolic logic, and prepare technical documentation to guide end users

Environment: IBM AIX, Korn Shell Scripting, FTP, SFTP, Windows Batch, XML, HTML, CGI, Informatica 9.0, Autosys 11, Oracle 11g, PL/SQL.

Confidential, St Petersburg, FL

Production Support

• Respond to the Queries/Issues of Application Developers
• Work on problems in real-time to give accurate and quick problem resolution
• Design and implement monitoring to ensure performance, stability, and scalability of the job scheduling environment and associated systems.
• Provide nighttime phone support when problems arise.
• To investigate application problems exists in the product.

Environment: Linux, Autosys, Korn Shell Scripting, FTP, SFTP, Oracle 10g, PL/SQL, SQL Loader, Sybase (Stored Procedure), and Crontab

Confidential,Shelton,CT

Sr. Software Engineer

• Totally responsible for all the phases of the application development and job scheduling life-cycle, from requirement gathering, analysis design, construction, unit testing, implementation, release and maintenance of the project
• Requirement Gathering with the help of Business System Engineers and Business
• Perform analysis of the business requirements and convert them to functional requirements by conducting meetings with business System Engineers
• Documentation of functional requirement document based on approved Business Requirement Document
• Responsible for building/maintaining the actual application jobs or processes that execute the application batch processes
• Develop codes using C, C++ to communicate with IBM MQ SERIES for accepting data from front end
• Responsible for Analyzing requirements, designing, maintaining and updating data models.
• Created database objects like Tables, Views Indexes, Synonyms and Sequences
• Develop PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Nightly batch activities where scheduled and monitored using autosys crontab job scheduler
• Configures, develops, tests, implements, supports, and maintains autosys JIL scripts.
• Migrated DB tables from Oracle 7 to Oracle 10g and altered tables with new data types.
• Migrated PL/SQL Code from Oracle 7 to 10g and implemented Object types.
• Extensively developed codes using Korn Shell Scripts to accomplish nightly batch activities
• Prepared Test Plan, Test scripts and Test conditions for Unit Testing, Integration testing and System Testing
• Trouble shooting and fixing various testing issues, and co-ordinate in system retesting by business users
• Acted as a release coordinator and supported the systems during implementation during development and release phases
• One month support is being rendered after implementation
• Extensively interested in development of system improvement tasks like automation and cost saving Adhoc tasks
• Impart project-related training to new team-members when required
• Attending 24*7 Emergency Production Support for Nightly Batch and Responsible for trouble shooting and fixing Job abends

Environment: Autosys, Mastro, Solaris, Korn Shell, Perl Shell Scripting, FTP, SFTP, NDM, Windows batch, C, C++, Pro *C, Oracle (RAC) 10g, PL/SQL, SQL Loader, IBM MQ Series

Confidential,Shelton,CT

Software Engineer

• Responsible for all the phases of the development life-cycle, Requirement Gathering, Analysis & Design, Construction, unit testing, Implementation, Release and maintenance
• Analysis: Understanding/Investigating the business requirement and proposing the changes to be made to the application
• Develop codes in C, C++, Pro *C for online related application changes
• Develop codes in Korn, Perl Shell Scripts for changes or any addition to be made to nightly batch processes
• Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences
• Developed PL/SQL Packages and customized functions and Triggers based upon the business logics
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN.
• Creating, maintaining, and supporting autosys command language and Job Instruction Language
• Performing unit testing, Integration testing, System Testing of the application changes
• Responsible for Supporting workload scheduling operations
• Responsible for Integration testing of the application to ensure proper working of the new system as per the requirement
• Set-up the region with new changes for Business Testing, and Business Approval
• Responsible for trouble shooting and Fixing the issues reported
• Responsible for the release activities of the new project and to provide support during and after the release
• Responsible for maintenance and monitoring production, development and testing environments
• Responsible for mentoring and training the new team members
• Working as secondary on-call and provide production support

Environment: Autosys, Solaris, Korn, Perl Shell Scripting, FTP, SFTP, Windows Batch, C, C++, Pro* C, Oracle 7i, PL/SQL, SQL Loader, MQ SERIES and Mastro