PROFESSIONAL SUMMARY:

• Lead Consultant with 8+ years of experience in Information Technology on Oracle PL/SQL, DB2, Sybase database, Python, Shell and Perl scripting, Oracle forms and Reports
• Oracle Certified PL/SQL Associate
• Expertise in all stages of SDLC: Requirements &Analysis, Design, Development, Unit Testing etc
• Experience with Python Object Oriented Programming concepts, Multi - Threading, Exception Handling and Collections
• Excellent Experience on various Python integrated IDE’s such as PyCharm, Sublime text, Pytest, PyDev
• Domain Experience of 5 years in Capital Markets and Risk management.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and support/maintenance with timely delivery against aggressive deadlines.
• Worked on Production Support, attending production calls, troubleshooting the application, and resolving bugs.
• Experience with continuous integration and automation.
• Good understanding of the Middleware technologies (WebLogic, WebSphere, IBM MQ Series)
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in supporting JAVA/J2EE web applications
• Good knowledge of XML, SOAP/REST, Django Restframework, ORM etc
• Good experience in creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Tables, Views, Sequences, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Effectively worked on Oracle provided packages DBMS JOBS, DBMS SQL, UTL FILE and DBMS SCHEDULER
• Experience in performance tuning and Query optimization using Explain Plan, SQL Trace utilities.
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans, and Indexes, for faster execution.
• Developed External tables to access data in external sources as if it were in a table in oracle.
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
• Work experience in creating Database links between two different databases.
• Excellent oral and written communication and extensive experience in onsite- offshore coordination and communication
• Have Ability to multitask across development priorities and tracking multiple deliverables at the same time.

TECHNICAL SKILLS:

Operating Systems: Unix, Windows

Prog. Languages: ORACLE PL/SQL, Python, Unix, Perl scripting

Databases: DB2 UDB v10.7, Oracle 10g/11g/12c, Sybase, SQL Server

Tools: Toad, SQL Developer,, DB Artisan, VSS, SVN, Perforce (Version Control), Jira, Putty, GitHub, PyCharm, Pytest, Control M, Tidal, IBM Websphere MQ

Domain Knowledge: Finance Domain

PROFESSIONAL EXPERIENCE:

Confidential, Monroeville, PA

Lead Consultant

Responsibilities:

• Provide resolution to Application issues in a time bound fashion to ensure Business Continuity
• Proactive escalation if operational established thresholds and SLA are broken
• Monitoring and tracking of support requests, issues, and incidents
• Fulfillment of request, issue, or incident resolution
• Management of Support Run Books, Knowledge Base, FAQs, etc.
• Report daily, weekly, and monthly status
• Prepare documents for day to day routine problems & resolutions, escalations, track tickets & coordinate with support functions, Root Cause Analysis.
• Meeting with clients, Onsite coordinator and developers for debug session and defect resolution
• Create, Update & Review Technical Documents including Design
• Involved in Developing Python/Django based web application using Python for data processing, Oracle DB for the database
• Involve in technical discussion/design related to project
• Involve in code implementation using Design & Requirement Document
• Involve in Debugging issues/defects related to project
• Involved in working with Oracle database design, development, and performance tuning.
• Written database stored procedures to build XML out of a database and write to a directory. Then a MQ adapter was developed to take the XML file and write to MQ Queue.
• Worked using SOAP UI to test the Web services.
• Involve in creating and executing Unit Test Cases
• Involve in Bug Fixing and Defect Verification
• Providing support during development and post deployment

Environment: Oracle PL/SQL, Python3,Oracle Forms and Reports, Shell Scripting

Confidential, VA

Senior Software Engineer

Responsibilities:

• Assist in the requirement gathering, design, development, and implementation
• Modified, maintained, and developed complex PL/SQL codes to develop new enhancements
• Worked with team of developers on Python applications for RISK management.
• Used Python scripts to update content in the database and manipulate files.
• Extensive code reviewing using GitHub pull requests, improved code quality, and also conducted meetings among peers.
• Wrote Python scripts to parse XML documents and load the data in database. .
• Rewrite existing Python modules to deliver certain format of data
• Tuning Procedures used by Application UI and improve performance.
• Identify and Fixing bugs in application flow.
• Identifying risks proactively and proposing solutions to resolve them
• Addressing the issues raised by the users and providing relevant information to them as needed
• Coordinate with customers to resolve technical support issues
• Monitor queues, batch jobs and application errors
• Utilize technical expertise to manage multiple assignments, to assure timely and cost-effect objectives delivery.
• Worked on agile and test-driven environment, participated on daily scrum meeting, discuss and finalize road block
• Coordinate development activities, evaluate and report performance of project.
• Schedule and prioritize work and plan a sequence of development activities that accomplish the planned targets. Set priorities and provide reports to the management.
• Proactive escalation if operational established thresholds and SLA are broken
• Writing complex SQL queries to pull reports as per business requirements

Environment: Oracle 11g, Shell, Python3, Perl scripting

Confidential, Alpena, MI

Senior Developer

Responsibilities:

• Developed Python based API (RESTful Web Service) to track the events and perform analysis using Django..
• Designed Cassandra schema for the APIs and Parsed XML file using Python to extract data from database.
• Involved in working with Oracle database design, development and performance tuning.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Implemented Materialized view as part of improving the performance of the application.
• Analyzed tables and indexes for cost based optimization (CBO) to work efficiently.
• Used the advanced features of PL/SQL like Arrays, Records, Nested Tables, Bulk collect and Dynamic SQL
• Created Batch Job Interfaces for Data Cleaning, processing and loading using shell scripts and SQL Loader.
• Created Batch Job Interfaces using Unix Shell Scripts and PL/SQL for daily file transfers using FTP and SFTP.
• Automated tasks like Analyze Tables, Collapse Partition Monthly, pulling data using PL/SQL packages.
• Developed a fully automated continuous integration system using Git, Gerrit, Jenkins, MySQL and custom tools developed in Python and Bash.
• Built web-services using SOAP that allowed integrating the business application with the legacy applications and also facilitates for future applications.
• Involved in debugging the applications monitored on JIRA using agile methodology.

Confidential

Senior Software Engineer

Responsibilities:

• Requirements gathering and Designing
• Worked with team of developers on Python applications for Enterprise Risk.
• Used Python scripts to update content in the database and manipulate files.
• Extensive code reviewing using GitHub pull requests, improved code quality, and also conducted meetings among peer
• Developed, modified and maintained the PL/SQL codes for new enhancements based on business requirement.
• Responsible for the fixation of the errors in data and scripts
• Develop and maintain the documentation to support the team and business.
• Generate reports as requested by business.

Environment: Oracle 11g, Python 2.7, UNIX and Perl Scripting

Confidential

Application Developer

Responsibilities:

• Provide technical support for Confidential
• Modified, maintained and developed the PL/SQL codes to develop new enhancements.
• Modified, maintained and developed the Report Files with the help of Crystal Reports.
• Create and maintain the documentation to support the team and business.
• Coordinate with customers to resolve technical support issues.
• Responsibilities as an oracle developer include management of the queries, enhancement and support service issues.
• Monitoring the successful completion of the jobs daily which were scheduled for accurate flow of data from one application to another.
• Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
• Work on cross-functional teams to proactively address support issues.
• Writing the Test Conditions and Test Scripts which makes quality deliverables
• Reviewing the Test Scripts and documenting comments in Review Logs
• Performed unit testing and End-End testing.
• Ensure timely delivery of the project
• Providing KT to the new team members
• Attending Team discussion whenever necessary, which helps team to get more insight
• Generate reports from the database using PL/SQL and SQL.

Environment: Oracle 11g, Crystal Reports