PL/SQL Developer Resume Plano, Texas - Hire IT People

SUMMARY:

SQL and Business Intelligence Developer with 5 years of experience in business analysis, designing, data modeling, data warehousing, developing, and management of application systems.
Solution oriented working with teams and demonstrated excellence in building and deploying multi - valued parameterized reports.
Demonstrated leadership abilities and teamwork skills as well as teh ability to accomplish teh task under minimal direction and supervision.
Remarkable Verbal and written communication skills.
Good understanding of Waterfall and Agile Methodologies and Scrum Framework.
Performed tuning on teh instance of SQL Server Database using SQL Server Profiler.
Excellent Problem-Solving Skills, Attention to Detail, and Project Management Skills.
Comprehensive noledge in teh field of Business Analysis, ETL Development, and Data Modeling.
In-depth noledge on Tableau Desktop, Tableau Reader and Tableau Server.
Extensive noledge of teh development of PL/SQL and T-SQL Stored Procedures, Packages, Functions, Triggers, Cursors and Views.

TECHNICAL SKILLS:

Languages: C#, .NET, HTML5 & CSS3, SQL, Python, PL/SQL and T-SQL

ETL Tools: Integration Services(SSIS)

Database Tools: MS Access, MS SQL Server 2012/2016 and Oracle 11g

Reporting Tools: SQL Server Reporting Services(SSRS), Tableau and Power BI

Other Tools: Microsoft Visual Studio, SQL Server Data Tools(SSDT), SQL Server Management Studio(SSMS), SQL Server Analysis Services(SSAS) and Eclipse IDE

MSOffice: Microsoft Word, Excel, Access, Publisher, PowerPoint, and Outlook.

Operating System: Windows NT/XP/Vista/7/10, Windows Server 2003/2008, Unix & Linux.

PROFESSIONAL EXPERIENCE:

PL/SQL Developer

Confidential - Plano, Texas

Responsibilities:

Extensively involved in writing SQL queries and PL/SQL programming.
Coordinated with DBA in creating and managing Tables, Indexes, DB links and Privileges.
Developed Application Interfaces usingPL/SQLstored Packages, Procedures, Functions, Collections, Object types and Triggers.
Hands on experience on TFS, we used to have Sprint Iterations for two weeks.
Updated Status of teh tasks daily with estimated hours, remaining hours and completed hours.
Created Indexes for faster retrieval of teh customer information and enhance teh database performance.
Extensively used teh advanced features of PL/SQL like collections, ref cursors, and dynamic SQL, nested table, arrays, materialized views and dynamic SQL.
Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming and loading data into teh data warehouse
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Created Event Handlers to Handling Errors and Debugging for teh Packages.
Designed packages using Transformations such as Execute SQL Task, Sequence Container, For Each Loop Container, Lookup, OLE DB Command and Derived Column.

SQL/MSBI Developer

Confidential

Responsibilities:

Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
Maintained MS SQL Server 2012 configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables.
Optimized teh performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
Created Jobs and implemented it for scheduling teh SSIS packages on a daily basis.
Responsible for building teh report solution like drill-down, drill-through and linked report using SSRS, testing for quality and finally review with teh customer to ensure teh solutions meet requirements.
Hands on experience with SSRS and OLAP Cube Report Development and Design.
Used Tableau to Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Jr. Database Developer

Confidential

Responsibilities:

Develop database, table, stored procedure, and data integration/management solutions for projects related to our internal SQL Server data environment
Headed SQL Server migration from SQL Server 2008 to SQL Server 2012
Involved in ETL architecture enhancements to increase teh performance, automate teh processes.
Extensively used teh SQL profiler to trace out teh execution of SQL objects and capturing teh input parameter values of teh stored procedures.
Optimized teh database by creating various clustered, non-clustered indexes and indexed views.
Increased teh performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.

We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Plano, TexaS

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship