We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

3.00 Rating

Plano, TexaS

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'd love your feedback!