SUMMARY:

• Over 3.5 year of experience in Information Technology that included Requirement gathering, System Analysis, Design, Development, Implementation and Production Support
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data - ware housing tools and technologies such as ODI
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Arrays), Records, Object types and Database Triggers
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Experienced on working with Big Data and Hadoop File System ( Confidential )
• Hands on Experience in working with ecosystems like Hive, Pig, SCOOP, Map Reduce, Flume
• Capturing data from existing databases that provide SQL interfaces using SCOOP
• Implemented Proofs of Concept on Hadoop stack and different big data analytic tools,migration from different databases (i.e. Teradata, Oracle, MYSQL) to Hadoop
• Successfully loaded files to Hive and Confidential from MongoDB, HBase
• Experience in database design using Stored Procedure, Functions and strong experience inwriting queries for DB2, SQL Server
• Good Analytical & Communication skills, Team player, Leadership, Analytical, Problem solving skills and highly self-motivated
• Extensive experience in Desktop Application Development & Designing
• Strong documentation and written presentation skills; developed various functional and technical specs with Test Plans and Training document for users
• Solid working knowledge of Relational Database Management System

FUNCTIONAL SKILLS SET:

• Ability to handle a team of developers and co-ordinate smooth delivery of theProject
• Training the new members in the team and getting them productive quickly
• Strong client facing skills
• Problem solving capability peered with strong communication skills

TECHNICAL SKILLS:

Languages: Java, PIG, SQL, Hive, Shell Scripting

Scripts/Web Technologies: HTML, XML, JavaScript

Big Data Ecosystem: Confidential, PIG, MAPREDUCE, HIVE, SQOOP, FLUME,MongoDB

Databases: Oracle 10g and 11g, SQL Server 2008 and 2012.

Tools: & Utilities SQL Developer, SQL * PLUS.

Operating System: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, GREENBELT, MARYLAND

SQL Developer

Responsibilities:

• Develop test and tune database code and information
• Support product development and quality assurance teams
• Worked with the analysis teams and management teams and supported them by providing variables based on their requirements
• Involved in extraction, transformation and loading of data directly from different source systems
• Design and maintain SQL scripts
• Provide technical support and guidance to staff and clients
• Generate reports and spreadsheets detailing database changes and performance
• Created and optimized diverse SQL queries
• Advised clients on necessary updates and changes to project milestones
• Extracted and collected data to create needed reports
• Followed up with customers to clarify and documents requirements
• Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances
• Created Views and lookup tables in excel
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Query Data from Hadoop/Hive & MySQL data sources to build visualization in Tableau
• Worked on Ms Excel, Ms Word
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created reports using analysis output and exported them to the web to enable the customers to have access through Internet

Confidential

SQL Developer

Responsibilities:

• Reviewed, developed and designed data models, in conjunction with the application development team
• Translated requirements into physical database structures that integrate with existing or proposed database structures
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications
• Assisted development staff with the application design to facilitate effective use of database languages, methodologies and established standards
• Worked with development staff in approving database changes
• Recommended the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures
• Created and maintained database objects
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic
• Created various reports using MS Reporting Services. And deploy public reports in dynamic web portal
• Tuned complex SQL Queries
• Worked on loading data from various data sources using MS Data Transformation Services (DTS)
• Created and integrated user defined functions and stored procedures for reporting purposes
• Designed and developed various complex reports
• Generated reports that can handle dynamic grouping and dynamic sorting
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time

Confidential

Hadoop Developer

Responsibilities:

• Loading files to Confidential and writing Hive queries to process required data
• Writing Pig scripts
• Loading data to Hive tables and writing queries to process
• Maintaining and Administrating the 06 node Hadoop cluster
• Worked on setting up Hadoop over multiple nodes and designed and developed Java map reduce jobs

Hadoop Developer

Confidential

Responsibilities:

• Loading files to Confidential and writing MapReduce queries to process required data
• Writing Pig scripts
• Loading data to Hive tables and writing queries to process
• Archiving files to HAR file
• Maintaining and Administrating the 10 node Hadoop cluster

Environment: Windows 8,10,MS-Office 2010/13 v9.4, Python, Access, SQL, Graph, STAT, Connect, MS SQL Server, Oracle, Teradata, MS-Excel