We provide IT Staff Augmentation Services!

Etl Developer/ Sql Developer Resume

Virginia Beach, VA

PROFESSIONAL SUMMARY:

  • Sr.Consultant with 7 years of experience working in various technologies such as Business Intelligence, Data warehousing and RDBMS.
  • Proven experience in implementing complete software life cycle involving various phases of design, development and implementation of Data Warehouses, Data marts, Reports with ETL and BI Tools.
  • Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment
  • Expertise in developing applications with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Services (SSAS) and Power BI.
  • Expertise in designing back end database structures and generating stored procedures that are complex in nature using SQL Server 2012/14/16.
  • Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica PowerCenter 10.2/9.1/8.6/7.1/6.1/5.1 and Power Exchange 9.1
  • Over five years of experience in implementing Oracle Business Intelligence (10.1.x) (11.1.1.3, 11.1.1.5, 11.1.1.6) Siebel Analytics (7.x) reports.
  • Extensive experience in writing, testing and implementing of the triggers, functions, packages using PL/SQL.
  • Having knowledge on developing reports using POWER BI.
  • Have good knowledge on TriZetto FACETS Data model and Extensions including FXI core Extension and Interactive Embedded Extension.
  • Created the Linked servers to pull the data from FACETS Server and used them in the stored procedure which will be executing on the scheduled basis through Tidal agent
  • Excellent Team Management Skills with good business acumen, effective communicator, good team mentoring and training skills, experience in working with Business Users, Controllers, Directors, Senior Managers, Executives, Department Heads and Project Stake Holders.
  • Best team player and able to work under pressure, using own initiation and motivation to meet deadlines and set priorities without close supervision.

TECHNICAL SKILLS:

Operating Systems: Windows (NT,2000/03/XP/Vista/7), Mac (10.4/10.5/10.6 ), Linux (Red Hat), UNIX

Languages: SQL, PL/SQL, T: SQL, UNIX Shell Scripts, Java, XML

Tools: Microsoft SQL Server 2016,2014,2012, SQL Server Integration Services (SSIS) 2010/2012/14/16 , SQL Server Reporting Services (SSRS) 2010/2012/14/16 MS Visual Studio 2013/2012/2010 , Informatica Power Center 9.5,10.2.0, Oracle BI Publisher 10.1.3.X, Toad for Oracle, SQL Developer

Databases: Oracle 8i/9i/10g/11g, Siebel, MS SQL Server 2008/2014/2016 , IBM DB2

Others: Web Services, MS Office, MS Visio, TOAD, AutoSys, Tidal, Control - M, Informatica Scheduler, SQL Navigator,SVN

WORK EXPERIENCE:

Confidential, Virginia Beach, VA

ETL Developer/ SQL Developer

Responsibilities:

  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.5.1 and SQL Server Integration Services (SSIS).
  • Created various SSIS Packages to load the data mart. The packages involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
  • Extensively wrote user SQL coding for overriding generated SQL query in Informatica.
  • Extensively used SSIS to load data from Flat Files to oracle, SQL server to Flat Files and oracle to SQL server.
  • Analyzing the data/performance issues or issues reported by the users and resolving them and maintaining the application
  • Performed Back end testing by writing SQL statements like Join, Inner Joins and Outer joins used TOAD, SQL Developer and SQL server.
  • Conformed to project standards for Unit test/UAT testing. Carried out end - to end testing and supported UAT effort with immediate requirement change/fixes/resolution for all changes/defects.
  • Analyzing the data/performance issues or issues reported by the users and resolving them.
  • Developing and doing enhancements and Bug Fixes in SSIS packages/Stored Procedures
  • Created ETL design documents and flow diagrams.
  • Created Tidal Job streams for each subject area and scheduled as per the business requirements.
  • Extensive usage of tidal for calling SSIS Package using PMCMD and also tidal Adapter
  • Worked in different Environments DEV, QA and Prod along with QA Team and Business.
  • Worked closely with database administrators and application development team(s) on the Design and implementation of the database.
  • Involved in Initial setup of the Informatica application from development environment to testing environment.
  • Responsible for creating, publishing and running SSRS reports to support the Business Requests.
  • Creating the SSRS Subscriptions to execute on a Schedule basis and Invoking the SSRS Reports through Tidal Scheduler.
  • Involved in creating test plans, test cases to unit test the mappings, sessions and workflows.
  • Worked on Informatica migration from 9.5.1 to 10.2.0
  • Worked on the SSIS to load tables and execute stored procedure and packages from the SSIS package.
  • Experience in working in Agile Environment and extensively used Jira for updating the stories.

Environment: Informatica Power Center 9.5.1,10.2.0, Databases Oracle 11g, Microsoft SQL Server 2012,SQL Server Data Tools 2012,SSRS, Visual Studio 2012, SQL Developer, Toad and Tidal, Jira, SVN.

Confidential, Portland, OR

SQL Developer

Responsibilities:

  • Collected requirements from Business Users analyzed and prepared the technical specifications
  • Wrote SQL, PL/SQL, stored procedures triggers, cursors for implementing business rules and transformations.
  • Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results.
  • Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
  • Analyzing the data/performance issues or issues reported by the users and resolving them and maintaining the application.
  • Developed and rebuilt the application to minimize the dataset and designed the required logics and flow.
  • Enhancements and Bug Fixes in SSIS packages, Cube and SSRS reports with custom components.
  • Performance improvement of jobs and implemented partitioning to improve the DB performance.
  • Developing the SSIS packages to check the data quality, freshness and availability of the data in an application.
  • Involved in migration of Database, Cube and Report Server.
  • Wrote the code and maintain stored procedures, views, and queries for recurring and ad hoc reports.
  • Wrote the T-SQL queries using inner and outer joins, sub-queries, CTEs and complex where clauses.
  • Responsible for identifying and resolving data discrepancies between systems.
  • Troubleshooting the issues while migrating the custom components having .NET code in reports/SSIS packages and fixing them.

Environment: Informatica Power Center 9.5.1/10.2, Databases Oracle 11g, Sql server 2008/12/14, Windows XP, Windows 2008 server R2 Standard, SQL Developer, SSRS, Toad, SQL, PL/SQL, Erwin r7, Shell Scripts, Microsoft Visio 2010

Confidential, Houston, TX

Backend Developer

Responsibilities:

  • Responsible for gathering and analyzing the Business requirements, Design, Develop the application using C#ASP.NET 4.5. Framework.
  • Developed the application using C#.NET, Entity Framework and back-end database using the TOAD Oracle.
  • Worked on Agile Methodology using Scrum to achieve a highly efficient product.
  • Performing Unit testing and integration testing code review. Attending daily standup meeting for the task’s allocation and status update.
  • Worked on the Enhancements of the Oracle Packages and run the Packages using Console Application for Testing.
  • Worked on the Tidal Agent to run/set automated jobs through SSIS on a Daily/weekly/Monthly Basis.
  • Developed SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Created Materialized Views and partitioning tables for performance reasons.
  • Worked on various backend Procedures and Functions using SQL.
  • Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Developed Exclusive SSIS Packages to move data from stage to target tables
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Development of C# modules for activation, deactivation and modification of these plans in Clarify Front End
  • Created SQL*Loader scripts to load data into the temporary staging tables
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
  • Used TOAD, SQL developer tools for faster application design and development.
  • Developed procedures using Dynamic SQL.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems, Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
  • Created Materialized Views and partitioning tables for performance reasons.

Environment: C#.NET, .NET Framework 5.0/4.0, ASP.NET, Visual Studio. NET 2015, Visual studio developer tools 2013, XML,HTML, REST Web API Services, WPF, TFS, IIS 7.0, Jira, Tidal Agent, Bootstrap 3.0, Oracle 10g, SQL Developer, Entity Framework 6.0, MVC 5.0, SQL

Confidential

Software Engineer

Responsibilities:

  • Interacting with the client for requirements, discussing the feasibility of requirements, design of the layout of web pages, Architecture and participating in the development.
  • Involved in designing, trading and documentation of application flows and developed functional diagrams using Visio.
  • Design & Develop Presentation Layer User Interface screens using Web Forms and used CSS3 to give HTML documents an attractive and consistent appearance.
  • Used Custom Validations, Validation Controls and performed validations both on client side and on server side.
  • Client-side validation was handled using JavaScript and ASP.NET controls.
  • Developed the middle tier business logic components using .net framework that interact with the database and processes all the data for the presentation layer to display and involved in various phases of database design like Logical and Physical layers.
  • Worked extensively on designing database tables, Stored Procedures, Functions and Triggers using SQL Server 2008.
  • Provided Session Management and View State to preserve the state of session variables.
  • Provided Session Management and View State to preserve the state of session variables.
  • Involved in Supporting and Troubleshoot Data conversion activities throughout the phases of development.
  • Handled Run Time & Design Time Errors by implementing appropriate Error Handlers in C# and Tracing.
  • Involved in Creating Web Services (XML standard) From Scratch.
  • Involved in unit testing and integration testing of the application.
  • Used Team Foundation Server as versioning tool and the IDE made use of for coding purposes is MS Visual studio 2008/2010.
  • Expertise in debugging Microsoft SQL Server 2008, including table design, stored procedure, SQL and trigger development.
  • Search Data management handled using no sql databases.
  • Experience with Reporting Services, and tools like Management Studio, SSIS.
  • Aware of the Workflow Design and implementation of the entire project being handled.
  • On the offshore involved in working on IBM FileNet Image Services and Coded a module in SharePoint application
  • Continuous deployment of distributed build management is handled using Team city.

Environment: ASP.NET 4.0, MVC, C#, Vb.Net,.Net Framework 3.5/4.0, ADO.NET, OOPS, HTML, CSS3, JavaScript, JQuery, AJAX, Visual Studio 2008/2010, CODED UI, MVC, WPF, UML, NUnit, SQL Server 2008 R2, SSRS, NOSQL, Web Forms, Web Services(SOA), VSS, IBM FileNet Image Services, SharePoint, Team city.

Hire Now