SUMMARY:

• Over 10+ years of experience in developing, testing & production support of business critical, large application including Database like PL/SQL, MS SQL Server(MSBI) & PostgreSQL. Also have working experience in Unix Shell Script, AWS architecture.
• 8+ years’ experience in SQL, PL/SQL Development on Oracle 11g,12c. Used PL/SQL features like Built in Functions, hint, Analytical Functions, Cursors, Cursor variables, dynamic SQL, SQL tuning, bulk binding techniques, Materialized view, table partitioning and Packages/Procedures/Functions.
• 2+ years experiences in PowerBuilder, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
• 3+ years of experience in Data warehousing support and develop ETL processes.
• Good Knowledge in NoSQL Database, AWS architecture.
• 4+ years’ experience in Unix/Linux scripting Shell Scripts.
• Extensive working experience in data validation, Functionality testing, System testing, Integration testing, Backend testing, Regression Testing and User Acceptance Testing.
• Experience in using tools like Jira, MS Share Point, Tortoise SVN, Source Tree, GitHub etc.
• Expert in handling multiple project. Strong understanding of with IT project management terms with presentation and facilitation.
• An in - depth understanding of all the phases of Software Development Life Cycle (SDLC).
• Experienced in reviewing Business Requirements Documents (BRD) and Functional Requirements Documents (FRD)
• Excellent verbal and written communication skills - the ability to communicate within Development organization to discuss designs and implementation techniques, and with Product Management to understand specifications.
• ITIL V3 foundation Certified in 2016. Depth knowledge in ITIL Incident Mgt., Problem Mgt., Change Mgt. Business Support System(BSS) management expert, Level 3 support.

SKILL:

Oracle (8 years), Microsoft SQL Server (4 years), PostgresSQL (2 Years), MySQL(2 Years), Java (3 years), AWS Amazon Web Services, Telco Billing(8 years), Unix/ Linux Shell Script (4 years).

PROFESSIONAL EXPERIENCE:

Confidential

Technology Analyst

Responsibilities:

• Interacted with Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.
• Involved with Users for resolving Production issues related to the application.
• Involved in Production support for database and User Interface issues within that application.
• Analyzing the code to understand the transformation and business logic applied.
• Involved in analysis of the requirements with business users in Coordinating and maintenance of source system owners.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Create database objects including tables, indexes and sequences, Package, functions, procedure, use analytical functions, cursors, bulk binding techniques for transforming data as per business requirement.
• Designed competent PL /SQL programs using PL /SQL collections, Records types, and Object types.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk - Prof and Table Partitioning.
• Automated data quality checks by creating PLSQL procedures, Cursors, Functions and dynamic SQL and enhanced with creating exceptions for error handling.
• Created Materialized Views on remote database and automated scheduler for refreshing the materialized View.
• Involved in designing, modelling, performance tuning and analysis, implementing process using ETL tool data Integration tool for data extraction, transformation and loading process.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down using SSRS/Report Builder 3.0.
• Created dashboards for Inpatient, outpatient, Finance and safety using benchmarked data to provide an analytical snapshot of point in time data.
• Deploying SSIS Package, power shell script for feeding data into SSAS cube dynamically, create petition, job scheduler in SLQ server.
• Involved in UNIX shell scripting also placed some of the files in the UNIX server as per the requirement specified by business users.
• Wrote UNIX shell scripts to create daily health reports and generate logs.
• Designing and executing the test scripts and test scenarios.
• Involved in developing detailed test plan, test cases and test scripts using PL /SQL .
• Created unit test case scripts for easy testing and tracking. Created test scripts documentation for all the procedures.
• Worked on extending partitions for Production Database.
• Tested the data in UAT and used to check with Business for Signoff.
• Responsible for creating the Change requests and prepare all the documentation required to move the code changes to production.
• Involved with QA team while testing the data and helped them incase if they need any help.
• Participated in weekly status meetings to update the status of work.
• Used to understand the business from application level to work on the incidents.
• Worked as L3 lead for supporting the application and used to involve in meetings with User's.
• Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built-in as well as User-defined functions and procedures.

Skills/Tools: Unix, Oracle 12c, PL /SQL, SQL Developer, TOAD, GIT, MS Visual Studio 2015/2017, SharePoint, Source Tree.

Environment: Windows, Unix

Confidential, Juno Beach, FL

Database Consultant

Responsibilities:

• Interacted with Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.
• Analyzing the code to understand the transformation and business logic applied.
• Create database objects including tables, indexes and sequences, Package, functions, procedure, use analytical functions, cursors, materialized view, bulk binding techniques for transforming data as per business requirement.
• Designed competent PL /SQL programs using PL /SQL collections, Records types, and Object types.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk - Prof and Table Partitioning.
• Created many DB links to connect remote database to extract and process the data for application reconciliation.
• Develop in UNIX shell scripting to execute database package/procedure, Use unit command, reconciliation report of daily ETL process status as per the requirement specified by business users.
• Wrote UNIX shell scripts to create daily health reports and generate logs.
• Involved in designing, modelling, performance tuning and analysis, implementing process using ETL tool data Integration tool for data extraction, transformation and loading process.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysais Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down using SSRS/Report Builder 3.0.
• Created dashboards for Inpatient, outpatient, Finance and safety using benchmarked data to provide an analytical snapshot of point in time data.
• Deploying SSIS Package, power shell script for feeding data into SSAS cube dynamically, create petition, job scheduler in SLQ server.

Confidential

Team Lead

Responsibilities:

• Create database objects including tables, indexes and sequences, Package, functions, procedure, use analytical functions, cursors, bulk binding techniques for transforming data as per business requirement.
• Designed competent PL /SQL programs using PL /SQL collections, Records types, and Object types.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans & Table Partitioning.
• Develop in UNIX shell scripting to execute database package/procedure, Use unit command, reconciliation report of daily ETL process status as per the requirement specified by business users.
• Production Support: system integration, QA & operations telecom billing, rating of talk time, 3G/4G data usage, tariff configuration, service active/ deactivation, payment & credit control, Vendor management, invoicing and maintaining multiple systems that handled 600+ million records per day, 500K provision requests per day and 30+ million customer based. Designing & developing, testing and deploying business products, ensure daily/weekly/monthly KPI, backup, 24x7 support for customer complain as per SLA/OLA.