Sql Developer Resume
3.00/5 (Submit Your Rating)
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