SUMMARY:

• An Innovative thinker with extensive experience designing, coding, testing and supporting next generation database solution possesses Over 17 years of experience in IT Industry performed as DBA, QA, Business Intelligence Analyst and Report Developer.
• Expertise in Business Intelligence architecture and design.
• Expertise in reporting analysis and design and develop the reports on business Intelligence environment.
• Highly developed SQL and PL/SQL query and procedure optimization skills.
• Extremely comfortable with scripting languages including Bash, Python.
• Had done various projects using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, cloning, patching, Performance Tuning.
• Excellent experience in Installation and configuration of different databases on Operating Systems UNIX and Windows platforms.
• Planning and scheduling the cold/Hot as well as RMAN backups.
• Experience in management tools like Oracle Enterprise Manager, TOAD and SQL Developer.
• Provided 24x7 Remote/on - call production supports Experience in testing the applications by using PL/SQL (stored procedures, triggers, Cursors, and Functions) and SQL statements in databases like ORACLE, MySQL and PostgreSQL.
• Database administration and schema design for MySQL, PostgreSQL,Oracle and SQLServer.
• Excellent experience in Oracle Service Bus integration on UNIX(Centos,Redhat)
• Excellent Team Member with good communication and Interpersonal skills.
• Have Excellent Quick Learning Skills.
• Excellent experience in Agile Methodology.

TECHNICAL SKILLS:

• QTP
• IVR/VOIP
• CTI
• Oracle
• Quality Center
• Visual Basic
• VC++
• Win Runner
• DB2
• Java
• TCP/IP, TAPI
• JIRA
• Siebel
• Compuware tools
• Dialogic Cards
• PosgreSQL
• Rational Tools
• MySQL

WORK EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Installing the Unidata on Linux conducted the POC
• Connected all applications and make sure Unidata on Linux working with all apps
• Setup the replication and EDA solution using SQLServer 2014.
• Automated the database build process on Linux environment with shell scripts.
• Working on Mysql database support in prod.
• Involved in Postgres database support in prod.

Environment: Linux/Unix, Unidata 8.1, Mysql5.6, Postgres9.4, SQLServer 2014, Shell Scripts, Python.

Confidential

Database Consultant

Responsibilities:

• Writing stored procedure and functions to build the ETL architecture with Pgsql.
• Built a Data warehouse Environment for Business Users from scratch.
• Conducted Requirement meetings and gather requirements and build the data in DW environment.
• Created Adhoc reports based on User requirements and done POC of that data.
• Strong MySql and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Setup MySQL multi-master replication setup.
• Performance tuning in critical areas.
• Created triggers and stored procedures to provide complex inter-table relationships.
• Created Database links to support and manage different database objects from one database to other.
• Establish standard operating procedures for administering PostgreSQL databases.
• Backup & Recover PostgreSQL databases.
• Setup a replication on online postgres databases.
• Mentor fellow DBA’s in PostgreSQL DBA techniques.
• Design and develop the data warehouse environment in postgres
• Maintained and process the ETL scripts and batch jobs in loading the incremental data
• Backup and restore of the databases
• 24/7 on-call rotation

Environment: Linux/Unix, Oracle10g, Oracle11gR2, Oracle12c, Mysql5.6, Postgres9.4, AWS, SQL Manager, Shell Scripts, Python.

Confidential

Database Administrator

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Create & Managing Database Structure, Storage Allocation.
• Created Backup procedures using Hot, Cold, RMAN and Logical backups.
• Setup and configuration of Data guard.
• Responsible for Load and Performance testing of the database servers and application servers.
• Created automated scripts by using Python programming.
• Implemented the Oracle Service Bus to implement the middle ware process and communication.
• Implemented Oracle Forms and Reports to server to maintain the data warehouse reports.
• PL/SQL development: packages, stored procedures, functions, triggers
• Users and roles management, FGA (Fine Grained Auditing)
• Performance Tuning of the database using AWR,TKPROF, STATSPACK for optimum performance and to meet user requirements. Assisting Developers in writing and tuning their queries.
• Tuning the database: Instance and SQL tuning
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
• Strong MySql and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Implemented of comprehensive backup and database replication solutions.
• MySQL multi-master replication setup.
• Performance tuning in critical areas.
• Designed and implemented PostgreSQL databases used to track software changes.
• Implemented backup systems
• Created triggers and stored procedures to provide complex inter-table relationships.
• Created Database links to support and manage different database objects from one database to other.
• Establish standard operating procedures for administering PostgreSQL databases.
• Backup & Recover PostgreSQL databases.
• Setup a replication on online postgres databases.
• Mentor fellow DBA’s in PostgreSQL DBA techniques.

Environment: Oracle 10g, 11gR2, Toad 12.6, Python, Cognos, Java, PL/SQL, SQL, Mysql 5.6.22, postgreSQL9.2.

Confidential

Risk BI Technical Lead, VP

Responsibilities:

• Implemented the strategies those met quality assurance financial objectives and estimating requirements.
• Managed a team comprised of contract and full time employees.
• Involved in design sessions and Implemented and coordinate the solution and design for some critical business requirements and develop the Sqls to process the data in Production region.
• Involved in testing SQL Server Integration Services (SSIS) and analyzed the databased on the extraction and loading criteria from the DB2 and Oracle.
• Involved in developing the ETL validation strategies and have hands on testing.
• Setup the test data for the Testing team during the system acceptance testing.
• Excellent Experience with Oracle 10G/11G, BI tools.
• Expertise in developing the reports for financial requirements.
• Designed and major involvement in analysis of architectural design of data warehouse environment.
• Experience in developing SQL applications and writing complex SQL code.
• Good experience with PL/SQL programming and processing Sqls and hands on experience in developing the Packages, Table partitioning, sql tuning and Triggers and Dynamic SQL
• Overseeing multiple processes and successfully implemented and managed the release testing process in place.
• Define the automation strategy and implemented the automated process across the data bases.
• Wrote a Java script which facilitated the data base link between the DB2 and Oracle to pull the data from DB2 environment by using JDBC drivers.

Environment: Oracle 10g, Toad 9.6, DB2, SQLServer2005, Python, Cognos, Java, PL/SQL, SQL, Data stage.

Confidential

Lead BI Specialist

Responsibilities:

• Involved in Database support to test and develop the Batch cycles.
• Understood the reporting structure develop a test strategy on report validation.
• Wrote automated scripts for regression testing by using UNIX.
• Developed the Automated test cases on the Batch application with Python Scripts.
• Designing and analyzing the datawarehouse reports and ETL workflows.
• Involved in ETL workflow analysis and data validation.
• Business objects report analysis and identified the data pitfalls and design issues.

Environment: Oracle 10g, Toad 8.6, DB2, J2EE, Informatica, Python, Java, Unix, Linux, Business Objects.

Confidential

Sr.BackendQA/Developer

Responsibilities:

• Developed the Installed shield script to set up the Web Server as a Service.
• Created and maintained the Test databases.
• Set up the applications on Terminal services in windows2008.
• Setup the Remote Desktop Services from scratch on win2008R2 servers.
• Restore and back up of QA databases.
• Involved in testing the backend in different databases like oracle, mssql2005.
• Involved in testing the complex stored procedures, Views which are developed for populating the data into the reports.

Environment: Oracle 9i, QTP10.0, Toad 7.6, Power Builder, MSSQL2005/2008, DB2, J2EE, JEdit, XML, JIRA, MKS Tool Kit.

Confidential

Business Intelligence QA Lead

Responsibilities:

• Managed 4 resources in order to complete the each release.
• Good experience with the offshore model.
• Involved in writing QTP scripts for the complex data validation.
• Involved in verifying the data, which came through from daily cycles and history loads.
• Wrote very complex SQL queries in validating the Data.
• Good experience in testing the relational and dimensional database models.

Environment: Oracle 10g,Toad 7.2, Business Objects 6.5,QMF 8.1,Mainframe,Sql Server Manager 2000,Quality Center 9.0,QTP 9.2

Confidential, PA

Software Tester

Responsibilities:

• Involved in End to End, white box, black box, Unit, Integration, System and Data conversion Testing
• Performed Data conversion testing by writing SQL queries.
• Performed Report testing by using Crystal reports tool.
• Involved in writing the Complex functions by Using VBScript.
• Involved in writing the Dynamic checkpoint functions by using VBscript

Environment: VB, net, Quick Test Pro 8.0, Toad9.0, Oracle 9i, VBScript, ATS (Automated Tracking System2.0), HTML, XML, CrystalReports8.5.

Confidential, FL

Sr.QA Analyst

Responsibilities:

• Performed Testing on Siebel Sales, Siebel Call center, Siebel Product Configurator e.t.c.
• Performed the Siebel Functional Testing.
• Involved in Testing and Debugging of a Web Based and Client Server Applications.
• Writing and executing Test Plans and Test cases based on requirements and documentation.
• Involved in Functional, Regression, Integration and System testing.
• Data Conversion Testing
• Tested the data in the database by using TOAD.

Environment: Siebel 7.5.2, Toad7.6, Softrax, Oracle9i, Sql, Bugzilla, HTML, XML.

Confidential, FL

Siebel QA Tester

Responsibilities:

• Perform the regression and manual Testing on IVR environment with different Orders.
• Involver in Siebel Call Center Application using IVR.
• Tested the Mainframe environment by writing the DB2 queries.
• Tested the results in Siebel by using Toad environment.

Environment: Siebel 7.5.2, IVR, Toad, Rational Clear quest, PVCS, JCL, DB2, Oracle9.0.