We provide IT Staff Augmentation Services!

Sql Developer Resume

Greenbelt, MarylanD

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

Hire Now