We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

Tampa, FL

Summary:

Having 8 years of experience in developing business related applications in the Client/Server, Unix / Windows, Web, Distributed Full Life Cycle FLCD environments using PowerBuilder, PFC, Asp, Jaguar EA Server, Visual Basic, C , Web Services, XML, SOA, Crystal Reports, ,oracle, Sybase EAS server and Ms-Sql Server, MS-access and Unix shell scripting.

  • Extensive experience in Information Systems Analysis, Design, Development, Coding, Testing, Migration, Enhancements program maintenance , QA Management, Team Management, Documentation and Implementation.
  • Implemented business logic as .NET Framework assemblies C , VB.NET , strongly motivated person with a proven record of accomplishments at various levels.
  • Strong expertise in user interface, specification development and troubleshooting. Solid knowledge of programming and Design methodologies related to RDBMS Applications.
  • Solid understanding of Systems life cycle SDLC , relational databases and software engineering discipline.
  • Strong expertise in Advanced software engineering and design principles, including object-oriented methodologies and design patterns, multithreading and massively parallel computing, distributed and multi-tier models, cross-platform development reliable and redundant server and service design, database-backed persistent services, encryption, authentication, and secure software et cetera.
  • Extensive experience in relational database administration, design, development and implementation using Oracle Designer, PL/SQL and other Oracle tools and utilities.
  • Knowledge of standard languages, coding methods, operations requirements, company coding standards and quality requirements.
  • Experience in working with large databases and in designing robust, complex databases, expertise in Client / Server architecture.
  • 2 years of professional programming experience using C , VC and MFC.
  • Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communications to maintain effective work relationships with all levels of personnel in a team environment or independently.
  • Having exposure in Compensation, Health insurance, Budget Information systems, Child welfare Systems, Health care industries, telecommunication industries, Banking, Financial, HRA, inventory management industries.
  • Strong with RDBMS features like Triggers, Procedures, Packages and Functions.
  • Good knowledge of Agile Methodology SCRUM and Extreme Programming and Unifies Process
  • Strong in all aspects application development process.
  • Strong experience creating User Guide and Design Documentation.
  • Highly skilled, self-motivated, outstanding, excellent communication and interpersonal skills with result oriented dedication towards goals.

Skills:

  • GUI: PowerBuilder 5/6/7/8.03/10.5/11.5/12.5, VB 5/6, Developer 2000 and Data window Builder
  • Languages: C, C , VC , Java, .NET, COBOL, JCL, CICS, HTML, PL/SQL, ISQL/TSQL and SQL PLUS
  • RDBMS: Access 97/98, Oracle 7.x/8.x/8i, Sybase 10x/11x, Adaptive server, Sybase SQL anywhere 5/6, WatcomSQL4, DB2, VSAM, MS-SQL server
  • Script Language: VBScript, JavaScript, JScript, HTML and ASP.
  • O/S: Windows 2000, Windows NT/95/98, UNIX, Novell Netware3.12, MVS
  • Design Tools: Erwin, Power S Designer, UML, Rational Rose, OOAD
  • Reporting Tools: Seagate CrystalReports6/7, Oracle Reports 2.5, Discoverer3.x, SPUFI, QMF, PEGASYS, MQ-Series, and EASYTRIEVE
  • ERP Tools: PeopleSoft7x HRMS, People Code, SQR , SIEBEL E-CRM2000
  • Hardware: ES-9000, DEC Alpha, UNIX Server, HP-9000, IBM Compatible Pentium PCs.

Confidential

ETL developer

Synchronize Data Stores in a Distributed Application. Created, customized, and managed stored procedures, functions and to triggers for database's Implementation of business rules and implemented database conversion.

  • Analyze the user requirements and create Use Case documents for each module, technical specifications about the module including the screen design, business process involved and the various ways of implementing the business rules including all the validations, SQL to be written and pseudo code wherever applicable.
  • Developed SQR programs to generate reports from a Sybase database including requirements gathering .
  • Developed distributed and multi-threaded parallel processing SOAP/WSDL/XML web services by using Java and used Multi-Tier PowerBuilder apps.
  • Created Standard Custom Visual User objects. Used Non Visual User Objects for implementing business rules.
  • Responsible for setting up and maintaining Ms-Sql Server development and production environments. Helped Database Administrator for 3 productions and 2 developments Ms-Sql Server Servers.
  • Led all project efforts including requirements gathering and JAD sessions.
  • Developed Systems were designed and implemented using Sybase products and Java J2EE technologies and were founded on a complete Service Oriented Application SOA architecture.
  • Experience with developing distributed applications with Jaguar/EAServer, J2EE or equivalent technology
  • Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
  • Designing standard Framework as per PowerBuilder Foundation class.

Power Builder12.5/ 9.0/11.5, SQR, PFC, EA server, N-Tier, Web Services, XML UNIX shell scripting, AUTOSYS scheduling, Novel client, Power Designer, Infomaker8.0, Sybase11/12.5, Ms-Sql Server 2008, Windows-NT, PVCS, VSS, MS-Office'2000

Confidential

PowerBuilder developer

Responsibilities:

  • Modified and created tables, stored procedures, database triggers and complex queries for reports of Oracle and sql server Databases.
  • Developed applications with browser based clients accessing PowerBuilder and components deployed on clustered application servers, such as web server and Jaguar EAS N-Tier Service .
  • Implementing various window Interfaces using Tab Controls and Tree views. A Non-Visual Object NVO for the Tree view control was designed which included the object functions to populate, add, and delete items in the tree view object.
  • Developed and maintained UNIX and Solaris batch cycle is intended to be run in the nightly to process large quantities of database records, thus making policy valuations, transaction status, summary reports and different cycles are implemented monthly, quarterly, yearly and daily .
  • Designed and developed XML-based metadata verifier that compared database metadata to class definition using model XML file.
  • Analyzed and developed a general business logic for the system software C/C
  • Migrated Conversion the application from PB 8.03/9.0/10.5.
  • Extensively used Embedded Dynamic SQL in PowerBuilder for Dynamic Reports and Queries.
  • Involved in Frame work design using PFC.
  • Extract Transform Load ETL development using SQL Server Integration Services SSIS
  • Dimensional Data Modeling and Cube development in SQL Server Analysis Services SSAS
  • Advanced extensible reporting skills using SQL Server Reporting Services SSRS

PowerBuilder9/10.5/11.5, SQL Server 2000. PFC, EAServer, PVCS, ETL,SSIS,SSRS, .NET, VB6.0, sybase12.5, C/C , Oracle 11i, UNIX, Shell Scripting, Sun Solaris, Control-M, Windows-NT, MS-Office2000

Confidential

PowerBuilder developer

Responsibilities:

  • Designed GUI Database developed business objects and lead a team of 4 members during construction phase. Wrote PL/SQL Stored procedure, Packages and Trigger, created Sequence and tables. Conducted and participated in Peer reviews and Code review.
  • Created and altered tables, procedures, Packages, functions triggers functions and pl/Sql sub programs.
  • Three-tiered architecture, with the business processing separated from the user interface and the database interface.
  • The application programs are developed using C and designed using object oriented methodology.
  • Extensively involved in hands on coding and debugging of new and existing Applications with large scale / high volume databases Experienced and managing development efforts using a configuration management tool, such as PVCS.
  • Developed common application architecture by using PFC/PFE for state of JPMC Standards.
  • Investigate and resolving issues relating to the PowerBuilder, Oracle and UNIX scripts in the application code.
  • Extensive use of Oracle Designer as a modeling and design tool.
  • Preparation of validation scripts for the Database modifications for the projects. Co-coordinating with Offshore team developing the system. Conducted and participated in Peer reviews and Code review.
  • Designed and developed web forms using ASP.NET 2.0 and C .NET
  • Design, create and populate back-end SQL Server2000 Database
  • Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
  • Involved in creating Datasets from an XML file for data interaction
  • Used Java Script and .NET Validation Controls for the Page Validations.
  • Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
  • Designed and support a scalable distributed SOA application environment in order to migrate from a single legacy midrange system

Power Builder 8.03/9.0/10, PFC, Visual Studio .NET 2005, ASP.NET, IIS Server , C .NET, ADO.NET,UNIX shell scripting, SOA, VB 6.0,COM,Com ,DCOM, MTS OOD, Jaguar EAS, SQL Server 2000/2005, Power Designer, Oracle 9.i/10g, Crystal Reports8.0, Windows-NT, PVCS,VSS, MS-Office'2000

Confidential

Technical Developer

Responsibilities:

  • Involved in application testing to make sure that all the functionality is implemented for each of the module.
  • Created tables, stored procedures, functions, database triggers and Optimized query plans with DBAs.
  • Facilitated Application Design Sessions JADS for the development of the financial management module of Macws and Data Conversion related to Finance and maintain state of Maine PFC standards.
  • Modified and enhancing the application by making appropriate code changes and testing the software as per the specifications, Data Conversion, Interfacing with other DBMS, Pilot testing
  • Migrated Conversion the application from PB 7.0 to PB 8.01/9.0.
  • Extensive coding, testing, fixing bugs, enhancement was in C/C and use of Win NT for batch jobs.
  • Extensively used Embedded Dynamic SQL in PowerBuilder for Dynamic Reports and Queries.
  • Created Linked ODBC tables to Sybase Server to facilitate Inserts and updates.
  • Extensively used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
  • Designed, implemented, and documented the client and task runtime APIs.
  • Performed troubleshooting and maintenance of applications in a distributed environment consisting of Sybase, Jaguar CTS.
  • Written stored Procedures and triggers for batch conversion for auto scheduler.
  • Implemented C classes other than MFC classes that uses polymorphism and inheritance.
  • Responsible for system administration and continuous process improvements as needed.
  • Create and deploy components on to application server Sybase's.
  • Experienced in Windows GUI development using MFC which includes implementation of custom print preview and video prompter interface.
  • Responsible for setting up and maintaining SYBASE SQL Server11.x, 12.x development and production environments. Database Administrator for 5 productions and 2 development SYBASE SQL Servers.
  • Developed RPC for extensively used in communicating with database.

PowerBuilder 8.03/9.0, PFC, C/C , JAVA, JSP, Sybase 12.5, EA Server4.2, Visio 2000,API, PVCS, Installsheild, Windows2000, MS-Office'2000

Hire Now