SUMMARY

• Highly motivated Senior Python, Tableau, Oracle PLSQL Developer with 14+ Years of IT Experience with expertise on Data Analytics, Data Visualization, Data Mining, Query Optimization - Performance Tuning in various domains like Finance, Telecom, Insurance, Manufacturing, and Human Resource.
• Extensive involvement in all the stages of System Development Life Cycles (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, Implementation and Support.
• Expertise in Data Analytics, Data Onboarding, Data Quality Check, and Data Blessing, and Data Visualization.
• Expertise in applying complex Data Mining concepts using Python, Secdb slang.
• Expertise in handling Test Data Management
• Expertise in consuming data from various APIs
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Expert in Query Optimization-Performance Tuning using Execution plan and Performance monitor.
• Having experience in using temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Having experience in importing/exporting data between different sources like Oracle/Sybase/SQL Server/Access/Excel etc.,
• Having experience to transform data from Sybase server to MSSQL Server using Bulk Copy Program (BCP) tool.
• Having good experience in report designing using Tableau, Spotfire, and Crystal reports
• Having knowledge in developing cubes using Cognos Reporting
• Having experience in data migration between Oracle and SQL server, Oracle and MS Access.
• Hands on experience with replication - Snapshot, Transactional and Merge.
• Hands on experience with Database backup and restore.
• Worked on creating various technical design documentation.
• Hands on experience with source control system like Visual Source Safe 6.0
• Working experience in Agile Methodologies project and involved in Sprint Planning Meeting and Daily Scrum meeting.
• Expertise in Tracking Systems like BMC Remedy and Jira.
• Hands on experience in Project Management Activities like Estimation, Planning, Resourcing, Time Sheet Approval, Task Allocation, Team Mentoring, Audit Deliverables etc.,

TECHNICAL SKILLS

Databases: Oracle PL/SQL, MS SQL Server, Teradata, Sybase

Database Tools: Management Studio, SQL Developer, AQT, Toad

Reporting Tools: Tableau, Spotfire, Crystal Reports, Cognos

Programming Language: Python, Secdb Slang, VB.Net, C

Operating Systems: Windows, Unix, MAC

Tracking Tools: BMC Remedy, Jira

ETL Tool: Informatica Powercenter, IBM Datastage

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Environment: Oracle 12c PLSQL, Unix

Responsibilities:

• Discuss with various stakeholders to understand reporting requirements before onboarding application data
• Involved in applying Data Profiling, Data Mining concepts for Data Validation
• Create Profile Check scripts for various data onboarding
• Responsible for Batch tables maintenance
• Support Testers in identifying defects in data requests and ensure right data is available in all environments at right time
• Conduct analysis of the issues assigned, identify and evaluate different solution alternatives and implement the most optimal solution.
• Responsible for production deployment

Confidential

Technology Lead

Environment: Python, Tableau, Spotfire Sybase, Oracle 12c PLSQL

Responsibilities:

• Involved in the design, development and support of new enhancements to the Existing framework.
• Discuss with various stake holders to access different sources from datalake for developing dashboards
• Involved in applying Data Profiling, Data Mining concepts for Data Blessing
• Seek inputs from the architecture/design team to provide deliverables that are in line with architectural requirements.
• Create Design Specifications as per the high-level design to develop the dashboards as per requirements.
• Create Unit Test Plans to validate / maintain the dashboards as per the requirements.
• Develop reports using knowledge of relevant technology as per design documents.
• Writing unit tests as per the test plan created during design phase.
• Preparing the technical environment for the system.
• Seek approvals to push the code to testing phase.
• Support peers in identifying defects and ensuring that the dashboards are as per the given specifications and SLAs.
• Coordinate with the offshore and make sure the tasks are completed on time and as per the requirements.
• Prepare User documents and conduct KT session with Production support team.
• Support deployment activities.
• Conduct analysis of the issues assigned, identify and evaluate different solution alternatives and implement the most optimal solution.
• Support other team members in resolving issues in areas of expertise.

Confidential

Technology Lead

Environment: Oracle 12c PLSQL

Responsibilities:

• The beneficiary would be involved in development activities and integrate new functionalities to the existing application.
• Involved in the design, development and support of new enhancements to the Existing framework.
• Seek inputs from the architecture/design team to provide deliverables that are in line with architectural requirements.
• Conduct Impact Analysis.
• Create Design Specifications as per the high-level design to develop the application as per requirements.
• Create Unit Test Plans to validate / maintain the application as per the requirements.
• Develop code using knowledge of relevant technology as per design documents.
• Writing unit tests as per the test plan created during design phase.
• Preparing the technical environment for the system.
• Seek approvals to push the code to testing phase.
• Testing and integrating the units into larger components.
• Support peers in identifying code defects and ensuring that the output is as per the given specifications and SLAs.
• Coordinate with the offshore and make sure the tasks are completed on time and as per the requirements.
• Prepare User documents and conduct KT session with Production support team.
• Support deployment activities.
• Respond to the issues assigned within SLA.
• Conduct analysis of the issues assigned, identify and evaluate different solution alternatives and implement the most optimal solution.
• Support other team members in resolving issues in areas of expertise.

Confidential

Technology Lead

Environment: Oracle 11i PLSQL, MS SQL Server, PowerBuilder

Responsibilities:

• Involved in getting business requirements from clients
• Involved in design and development of requirements into the system
• Involved in Offshore co-ordination, Team Mentoring
• Involved in System Testing
• Involved in training new members into the Team
• Involved in Production Implementation
• Involved in 24*7 Production Support

Confidential

Technology Lead

Environment: SharePoint, MS Excel

Responsibilities:

• Involved in performing QA for different types of documents
• Involved in applying standards to the documents wrt document type
• Involved in maintaining documents in SharePoint
• Involved in Onsite co-ordination
• Involved in Planning and Estimation

Confidential

Technology Lead

Environment: Unix, Perl, Oracle PLSQL, Teradata

Responsibilities:

• Involved in SDLC which included requirements gathering, analysis, design, and development.
• Involved in Estimation for various modules
• Created database objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in Task Allocation and Status Tracking for entire team members
• Involved in Team Mentoring

Confidential

Technology Lead

Environment: Pro C, COBOL, Oracle PLSQL, UNIX, Visual Studio

Responsibilities:

• Involved in SDLC which included requirements gathering, analysis, design, and development.
• Involved in Estimation for various modules
• Created database objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Involved in designing GUI screens using Visual Studio
• Involved in Task Allocation and Status Tracking for entire team members
• Involved in Team Mentoring

Confidential

Project Lead

Environment: Oracle PLSQL, Visual Basic 6.0, Windows XP & Vista

Responsibilities:

• Involved in SDLC which included requirements gathering, analysis, design, and development.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Analyzing client requirements
• Involved in code development as per requirements
• Involved in Unit and System Testing
• Involved in Technical Documents and User Manual preparation
• Involved in UAT Assistance
• Provided 24 x 7 Production support for the database and application issues

Confidential

Project Lead

Environment: Orangescape Cloud, MS-SQL 5.3

Responsibilities:

• Involved in Data Modelling
• Analyzing client requirements
• Involved in developing pseudo codes for complex logic
• Involved in developing Design Documents for Test Cases
• Involved in Unit and System Testing

Confidential

Analyst Programmer

Environment: Oracle PLSQL, Visual Basic 6.0

Responsibilities:

• Involved in analysis again client requirements
• Involved in developing Procedures, Functions, Triggers and Packages
• Involved in developing new forms as per client requirements
• Involved in Design, Validation, Integration Testing
• Provided Production support for application issues

Confidential

Analyst Programmer

Environment: Oracle PLSQL, Visual Basic 6.0

Responsibilities:

• Base lining of source code and configuration items based on the approved change requests
• To facilitate the product installation in the locations
• To plan and manage a country team for getting technically trained for the first level support after the production rollouts
• To plan and manage individual country UKRBS infrastructure and logistics during the entire project development life cycle until production rollout and post-production rollout stages.
• To monitor Configuration related activities
• To perform baseline audit and reviews the entire set of testing documents
• Verification of checksum for source code received from the development team
• Compilation of source code and Check in of source code into IST views of clear case
• Involved in daily database backup & restore.
• Maintaining databases of QA & development environment
• Provided 24 x 7 Production support for the database and application issues

Confidential

Developer

Environment: Oracle PLSQL, Visual Basic 6.0, Sacs Report

Responsibilities:

• Developed data access layer to connect database using Microsoft’s ADO technology in visual basic
• Designed Windows Forms/ActiveX Dll and Exe for Reports
• Designed and developed Procedure, Functions, Triggers and Packages
• Provided Ongoing training and support to the end user

Confidential

Software Engineer

Environment: Visual Basic 6.0, MS-SQL Server 2000, Crystal Report

Responsibilities:

• Developed data access layer to connect database using Microsoft’s ADO technology in visual basic
• Designed graphical user interfaces
• Involved in Coding wrt both Front End and Back End
• Tested the application as per the test cases