PROFESSIONAL SUMMARY:

Around 6 Years of progressive Information Technology Experience in analyzing, developing and testing the Database Management Systems, Hadoop Ecosystem and Big Data platforms.

SKILL:

Databases: Hive, Oracle 10g/11g/12c, Sybase, DB2, SQL - Server, SAS, Teradata

Web Technologies: HTML/DHTML, Bootstrap, jQuery, JavaScript

Query Tools: SQL Developer, Rapid SQL, TOAD, Rumba, Aginity, Teradata SQL Assistant, AQT, SASEG

Programming: C, Shell scripting, Python, SQL, Oracle PL/SQL

Issues Tracking Tools: HP Quality Center, JIRA, RTC

Packages: MS-Word, MS-Excel, MS-Power point, Visio, Visual Studio

Version control tools: Clear Case, SVN, Bitbucket

WORK EXPERIENCE:

Confidential

Bigdata Developer/ Quality Assurance

Responsibilities:

• Involved in meetings with Business, Project Manager and Client Lead to understand business process and project requirements
• Participating in Solution Design meetings and Database Design Meetings.
• Analyzing and Validating the Solution Design and Database Design.
• Validating the STTM against the Physical Data Model for Metadata.
• Designed and developed hive tables as per the existing source data warehouse and ingested the data
• Implemented Partitioning in Hive for better organization of the data.
• Created technical specifications document for the requirements
• Worked on Change Data Capture (CDC) logic to implement type 2 SCD (slowly changing dimensions) using hive queries.
• Worked with Sqoop import and export functionalities and many techniques to speed up the transfers of large data sets between traditional databases and HDFS
• Creating Test scripts and preparing HQL Test Queries during the development phase.
• Reviewing HQL queries prepared by peer testers.
• Identifying test data required for testing different scenarios.
• Validating the Hive table structure once the code is migrated to QA environment.
• Validating the data lineage passing through multiple systems.
• Smoke testing to ensure the most important functions working and the build is stable enough.
• System Testing the Hive tables once the smoke testing is passed for both History and incremental data.
• Testing Hive partitions to validate the accuracy of the data partitioned.
• Tracking issues in Jira, RTC.
• Supporting UAT teams for User Acceptance Testing.
• Creating reusable test cases. coordinating and Managing offshore team and getting daily status updates from the team.
• Conducting meetings with all the testes to understand and identify the areas of improvement.
• Working in Agile methodology.
• Contributed to the Scrum practices and other tracking processes used by the team for work management.

Confidential

Technology Lead - Quality Assurance

Responsibilities:

• Attending meetings with Business, Project Manager and Client Lead to understand business process and project requirements.
• Leading a team of eight and assigning tasks to each team member and getting status updates.
• Creating project On-boarding documents which helped QA testers in understanding project requirements.
• Estimating QA efforts for new projects in pipeline based on the proposed Solution Architect diagram.
• Creating Test Plan, Test strategy and providing project overview to the testing team.
• Creating Test Cases and managing defects in Quality Center.
• Preparing test data that include all the business requirements and testing scenarios.
• Creating the test results document and providing the testing report to the project team.
• Working on continuous improvement of QA process by reviewing and evaluating existing practices with standard testing guidelines.
• Responsible for preparation and circulating the weekly status report among testing and project team members which helped understanding the overall testing health.
• Participated in Walkthrough’s and Technical Reviews all through the testing phase and ensuring the Web site’s security and privacy measures meet or exceed those put forth in the HIPAA regulations.
• Performing Backend Testing by writing SQL statements using Oracle Database. maintaining QA standards and artifacts by continuous process improvement.
• Created reusable test cases in Quality center in order to save QA effort.
• Developing reusable test scripts in SAS.
• Organizing weekly team meetings in order to understand improvement areas and current testing practices.
• Attending meetings with Client lead to provide team progress and status of the project on a weekly basis.
• Creating Test summary, Test closure document and QA Deliverable Sign off reports.
• Used HP Quality Center for tracking the defects.

Confidential

Technology Lead - Oracle PL/SQL Developer

Responsibilities:

• Analyzed data in the current application to understand the business logic by mapping UI to Sybase, DB2 and SQL Server databases
• Analyzed Sybase stored procedures, translated and implemented business logic in Oracle database
• Created Technical Specifications document based on company standards
• Created and maintained PLSQL scripts, Stored procedures and Packages
• Worked on the Bulk techniques, Indexes and Table Partitioning
• Worked on RefCursors, Collections and Exception Handling
• Used QREP process for loading the data from DB2 to Oracle database
• Created reusable test case scripts for testing stored procedures and packages developed.
• Developed a utility tool for non-database developers & Q.A to debug the PLSQL programs.
• Worked closely with Web-services developers to maintain the business logics and data flow from Database through UI.
• Actively participated in creating Data model. Created ER diagrams from Logical data model to Physical data model
• Involved in technical design discussions with Architects to implement business logic
• Experience in developing Data flow diagrams, data dictionary, Entity relation modeling and design techniques.

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed, designed entity relationships and developed the Data Loading Process
• Created Technical Specifications document explaining development scope.
• Developed Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Performed code debugging using SQL Developer
• Designed and developed views, materialized views and cursors
• Extensively worked on SQL queries for extraction and transformation of data from source tables and load back to target tables
• Created SQL scripts, stored procedures to load data from Legacy systems to Oracle Database
• Used Informatica Power Center 8.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse.

Confidential

Data Analyst

Responsibilities:

• Designed and developed Packages, Procedures, Functions efficiently in loading and validating the data.
• Also, worked on creating users and roles as needed for the applications.
• Created various objects such as Tables, Views and Materialized Views and worked on complex Stored Procedures and Functions.
• Worked on Performance tuning using indexing concepts.
• Extensively worked on PL/SQL programs, designed and developed materialized views, packages and triggers
• Extensively worked on performance tuning techniques to enhance the query performance.
• Involved in fixing bugs and unit testing.

Confidential

Technical Assistant

Responsibilities:

• Gathered and analyzed project requirements.
• Designed database objects as per the requirements.
• Created ER Diagrams for Logical and Physical Models.
• Implemented database using Oracle.
• Designed tables and indexes.
• Wrote Complex SQL queries and Stored procedures.
• Developed user and technical documentation.
• Involved in unit testing and system testing.
• Maintained database for University website.
• Contributed in designing and developing the logical and physical model.
• Created additional objects in the existing database as per the requirement.
• Created PLSQL Stored procedures and functions.
• Unit Tested the objects and programs created.
• Supported non-database developers.
• Actively participated in the University Level Database forums.
• Participated in national level workshops.