EXPERIENCE SUMMARY:

• Over 8 Years of Experience in developing Database, Software and Web Based solutions using skillsets such as Oracle PL/SQL, ASP.NET, Java, Javascript, HTML, AJAX, WebServices and CSS
• Over 5 Years of Experience in IT Requirement Gathering, Production Support, Design Implementation and Data Analysis by adopting development lifecycle such as SDLC, Agile Methodologies and Service Life Cycle Management
• Over 4 Years of Experience in leading cross functional team and interacting with business users to translate business requirements to IT requirements
• Over 3 Years of Experience in Server Sizing, Capacity Planning and Management assessing various existing architecture and suggested migration strategy and best practices to develop efficient solutions
• Implemented Production environments and test bed environments for mission critical applications
• Implemented new PL/SQL Procedures, triggers and Packages on Test Environment and deployed in Production Environment such as 10g, 11g and 12c databases
• Resolved bugs and performance issues for Production environment and shared fixes in stipulated time
• Developed new ETL methodologies by implementing stored procedures, triggers and PL/SQL scripts
• Conducted requirement analysis for production environment and implemented stored procedures and jobs for data extraction
• Gathered requirements to automate reports assessing database performance and made changes in the database environments for optimal performance
• Documented project design, data model, data flow diagram and entity relationship models
• Over 3 Years of Experience working on shell scripts
• Proficiency in using SQL Developer, SQL Loader tools, EXPDP and Export Utilities and utilities
• Proficiency in Working on multiple OS environments such as Windows, Linux, CentOs, Solaris
• Assessed Production environment bugs and validated test cases in test environment and shared documentation for fixes
• Experience working on more than 4 TB of Database Production Environment
• Upgraded high volume databases for critical production environment in aviation industry
• Monitored performance of database and automated health check reports to proactively resolve database performance issues
• Proficient with SQL query and worked on projects to optimize database performance issues
• Worked on Proof of Concept projects for Oracle Confidential, Oracle Golden Gate, Hive Servers, Tableau Environment
• Developed scripts to extract data sources from Cloud Environment in AWS and R Programming
• Mentored new associates in the team and conducted sessions
• Build test beds for new associates in the team to build skillsets and improve competency matrix through hands on experience
• Strong experience in working on Project Management roles and proficiency in handling Microsoft Project Management Tools for Project Tracking
• Ability to work on a fast - paced environment, Good team player and a good mentor to guide new team members
• History of winning performance in environment building/implementation, decision making and problem solving, knowledge sharing within team members and customer satisfaction

TECHNICAL SKILLS:

Oracle Database: 9i,10g, 11g R1,11g R2,12c

Application Tools: SQL Developer, SQL Plus, SQL Loader, Java Eclipse, Visual Studio 2008, Visual Studio 2012, SSIS, SSRS, Tableau, R Studio, Javascript, Notepad++, Citrix Virtual Servers

Operating System: Windows Server 2008, RHEL 5, RHEL 6, Solaris SPARC

Application Tools: Oracle Confidential 10g

Microsoft Databases: SQL Server 2005, SQL Server 2008

Other Databases: Hive Server, PostgreSQL 9.6

Microsoft Office: Microsoft Project Management 2012, Microsoft Word, Microsoft Excel, Microsoft Power Point

PROFESSIONAL EXPERIENCE:

Confidential

Senior Implementation Engineer, Dallas, Texas

Responsibilities:

• Managed multiple database environments such as Oracle 11g, SQL Server 2016, Postgre for Development and Premium support clients
• Designed PL/SQL scripts to automate ETL process in Oracle and SQL Servers
• Reviewed PL/SQL procedure and scripts developed by clients and shared strategies to implement best practice and improve performance
• Shared migration strategy with clients to upgrade database to new Production Environment and configured features and functionalities to monitor resource consumptions for Premium and Development Support clients
• Resolved issues observed by clients in deploying triggers, procedures and PL/SQL scripts in Production and in test environment
• Automated SSIS packages and validated test cases to mitigate the risk observed in test environments during ETL process
• Resolved bugs in PL/SQL scripts and procedures and developed test cases for thorough analysis on test environments
• Worked closely with Premium and Development Support clients to implement reports using Tableau Servers and methodologies to extract data and build extracts and live database connections
• Developed Tableau reports using various techniques such as Bar Charts, Context Filters, Heat Map, Group and Sorting techniques on test and production environment
• Coordinated with functional and technical team to resolve database and troubleshooting issues in test and production environment for Premium support clients
• Reviewed architecture of current database environments and suggested migration policies to new versions of Oracle database
• Created user policy to assign appropriate system privileges and policies to database users
• Documented user policy and changes and shared with concerned stakeholders and conducted regular follow ups
• Conducted weekly standups with cross functional teams to assess possible issues being observed to the current projects being assigned
• Assessed production environments and developed environments to conduct Proof of Concept on Hive and Postgre servers to load data from CSV and JSON files by developing scripts in R Studio

Environment: s: Oracle 11g, Oracle SQL Developer, SQL Server 2012, SSIS, Tableau 9.x, Postgre 9.6, R Studio

Confidential

Senior Oracle PL/SQL Database Developer

Responsibilities:

• Managed a team of 5 Oracle Developers and reviewed daily operations and issues observed in Oracle Database environment such as 10g, 11g
• Designed and developed SQL procedures and batch jobs to automate data extraction and loading
• Resolved bugs in PL/SQL scripts and procedures and developed test cases for thorough analysis on test environments
• Created audit trail database in Oracle and developed PL/SQL triggers and scripts to monitor database authorization and access for various users
• Developed report of monthly audit using Microsoft Excel and audit trail data as part of Business Compliance policy and shared with business users
• Shared migration strategy with the team and mentored associates in resolving database issues and challenges in test and production environment for Premium and Development Support clients
• Worked with database administration team in resolving issues in query performance during Performance Acceptance Testing
• Deployed triggers, procedures and PL/SQL scripts to extract, transform data to improve data quality
• Assessed database environments and developed data flow diagrams and entity relationship models to document data architecture
• Developed PL/SQL scripts and procedures to assess the sales data and resolved performance issues observed in generating sales report
• Coordinated with functional and technical team to resolve database and troubleshooting issues in test and production environment
• Reviewed architecture of current database environments and suggested migration policies to new versions of Oracle database
• Developed PL/SQL scripts and procedures to gather and assess data for operational efficiency of engineers deployed at client locations along with work categories and types of engagements

Environment: s: Oracle 11g R1, Oracle 11g R2, Oracle SQL Loader, Oracle SQL Developer, Oracle SQL Loader

Confidential

Senior Oracle Database Developer

Naperville, Illinois

Responsibilities:

• Assessed data architecture design and data objects and normalized entity relationships between tables to implement best practice
• Documented project design, data flow diagram and entity relationship models
• Deployed jobs and PL/SQL procedures in production environment to analyze KPI for sales data
• Developed SSIS packages in Microsoft SQL Server 2012 and automated data ETL process
• Designed and tested PL/SQL procedures in test environment and build a cutover plan to deploy on production environment
• Deployed shell scripts to monitor and notify performance issues to cross functional team and concerned stakeholders
• Gathered requirements and documented strategy to build data architecture and necessary database performance requirements for successful implementation
• Developed test beds to assess risks associated with deliverables and mitigate risk on production environment
• Conducted disaster recovery drills and validated disaster recovery environment as part of Business Continuity Plan
• Performed database and sql tuning using EXPLAIN PLAN, AWR, TKPROF and hints
• Developed Golden Gate test bed environment to create extractors and replicators for real time data replication
• Mentored new associates in the team and conducted knowledge transfer sessions to improve their Oracle DBA skills

Environment: s- Oracle 9i, Oracle 10g, Oracle 11g R2, Oracle SQL Developer, SQL Loader, Oracle Golden Gate

Confidential

Oracle Database Developer

Responsibilities-

• Developed and deployed jobs using SQL Loader in Linux and Windows environments
• Prepared project documents such as database architecture, business engagement of applications, database design and business requirements
• Created test environment and assisted production team in assessing all possible risks associated with the production cutover
• Conducted reorganization of critical database schemas to improve performance of database
• Automated scripts to assess roles and privileges granted on production environment and shared the output with clients to adhere their compliance standards
• Revoked roles and privileges from test bed environment and assisted in validating the risks associated at Production Environment
• Highlighted index and tables which required index rebuild and table reorg and incorporated them in automated scripts
• Extracted AWR, ADDM report from Production environment and analayzed reports to resolve resource contention and performance issues
• Performed 24/7 on call support during weekend with dedicated application team members including night time and monthly production outage
• Automated jobs to backup database using EXPDP utilities and RMAN backup
• Conducted disaster recovery drills for clients using Production Database and Oracle Dataguard, Physical standby environment as part of business continuity exercise

Environment: s- Oracle 9i, Oracle 10g, Oracle 11g R1, Oracle 11g R2, Oracle SQL Developer, Oracle SQL Loader

Confidential, Junior Oracle Database Developer

Responsibilities-

• Scheduled cold backup, export backup and RMAN backup for critical production and test environment
• Conducted lights on activity and shared report with seniors to assess performance of database
• Granted privileges and roles in compliance with the business requirements of clients
• Executed scripts to remove data from staging tables in test environment
• Created databases for test environment and migrated data from Production Environment to Test Database.
• Executed index rebuild and stats gather scripts to improve performance of database
• Developed and automated PL/SQL jobs in test environments to assess possible risk impact and resolve it
• Received recognition from client for proactively resolving database troubleshooting issues
• Coordinated with business and technical team members to gather approval and implement changes in test and production environment
• Refreshed test database environments using EXPDP and RMAN backup and reviewed with team to assess possible issues post refresh
• Installation of Oracle Binaries 11g R1 and 11g R2 on test beds and lab environments
• Deployed test databases in lab environments
• Replicated issues in test environment and shared root cause analysis report with clients

Environment: s- Oracle 9i, Oracle 10g, Oracle 11g R1, Oracle 11g R2

Confidential, Junior Web Developer

Responsibilities-

• Developed thick client application for a warehouse client to generate invoice using technologies such as C#, SQL Server
• Developed web based technologies using MVC architecture for a marketing client using technologies such as ASP.NET, Javascript, AJAX and SQL Server 2008
• Resolved bugs and documented fixes for team and shared with clients and concerned stakeholders
• Documented steps to host web based applications using capabilities and features of web hosting services such as Aurion Pro
• Assessed existing web based and thick client application and documented strategy to build and enhance features for new clients using build in templates and resources
• Developed PL/SQL scripts and SQL queries using Execute Reader and SQL Server libraries to validate data controls and text fields and developed logic to transform data before loading
• Implemented Proof of Concepts for advertisement client using HTML, Javascript and CSS

Environment: s- Microsoft Visual Studio, ASP.NET 2.0, C#, HTML, CSS, Javascript