We provide IT Staff Augmentation Services!

Lead Consultant Resume

Monroeville, PA

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 Rest framework, 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

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 roadblock
  • 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

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 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 conducted meetings among peers
  • 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 Lawson PSA
  • 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

Hire Now