Information Systems Engineer Resume
SUMMARY:
- 6+ Years of experience in relational database technologies
- 1 Year of Project Management experience
- Certified Oracle PL/SQL developer associate
- Good knowledge on using Pentaho ETL tool
- Experience in translating Business requirements in to Project Tasks and Code Modules
- Designed and created reports using MS Access and Oracle SQL Developer reporting tool
- Very Good experience in using tools like FileZilla and Cuteftp in managing file transfers
- Excellent experience in writing SQL queries and PL/SQL programming units
- Good familiarity with Linux Operating System
- Worked as a Cultural Secretary for a non - profit community organization
TECHNICAL SKILLS:
Operating Systems/Tools: putty, FTP, SFTP, HTTPS, Windows 7/NT/XP, Clarity PPM, Cast Iron
Languages: VB6, VB.NET, ASP.NET, C#, C, C++, Basic Java, PL/SQL
Databases: DB2, SQL Server 2000, Oracle 10g/9i, ODBC, JDBC, MS Access 2010
Scripting: VB Script, IIS, XML, Java Script
Environment: .NET Framework, Oracle, MS VS.NET, IIS, Windows 2000, SQL Star Plus, XP
PROFESSIONAL EXPERIENCE:
Confidential
Information Systems Engineer
Responsibilities:
- Providing the Access rights to the UsersMaintaining the Access Roles, generating Reports to ensure Data Quality
- Data Quality using SQL Queries
- Support Role for the Tool includes troubleshooting the issues
- Managing Cast Iron WebSphere Live
- Worked on Cast Iron Orchestrations
Confidential
Database Analyst
Responsibilities:
- Designed and Developed Databases to create COBRA Eligibility Files to various
- Carriers
- Transferred Eligibility Files using FTP, SFTP and HTTPS Protocols
- Massaged raw data which comes from file formats into a staging database
- Designed Reports using SQL Queries
- Designed Open Enrollment Databases to create Open Enrollment forms for Clients during Open Enrollment season
- Worked as a PMO for a project which involved migrating data from MS Access databases to CBAS database (internal tool)
- Defined data structures per client’s business requirement
Environment: Windows 7, MS Access 2010, SFTP, FTP, HTTPS, FileZilla, CBAS, Pentaho ETL tool
Confidential
ASP.NET Developer
Responsibilities:
- Modified old software code and added additional functionality
- Implemented Paging in Table Reports to give the Data cleaner look using ADO.NET
- Displaying friendly messages to the User if there is no match
Environment: Windows 2000, IIS, ASP.NET, VB.NET, Oracle, SQL Server 2000
Confidential
.NET Developer
Responsibilities:
- Created Tables, Views and Stored Procedures in Oracle, SQL Server
- Used ASP.NET to create Web pages
- Used ADO.NET to access the Databases and retrieving the Record sets
- Admin Module Architecture Design and Developed in Win Forms, VB.NET
- XML was used to store Privileges and Stored Procedures Packages entries
- Modified old software code and added additional functionality
- Designed and Developed rich User Interfaces using ASP.NET
- Designed and Developed Web User Controls in using VB.NET
- Developed Web pages using Grid View and Detail View
- Used .NET web controls for User Interface Design
- Wrote Complex PL/SQL functions for the Client side Operation
Environment: Windows 2000, IIS, ASP.NET, VB.NET, Oracle, SQL Server 2000
Confidential
Programmer Analyst
Responsibilities:
- Created PL/SQL Functions to facilitate business functions and calculations
- Wrote CASE Statement Process flow
- Wrote Complex SQL statements to extract data from multiple Tables using various Joins
- Developed Well-Structured and Error-Free code
- Used Oracle DBMS Packages to carry out Dynamic SQL Processing
- Coded Stored Procedures, Triggers to in corporate the business logic into the application
- Simplifying testing and debugging with conditional compilation
Environment: Windows 98, telnet, oracle database 8i/9i,Unix, SQL*Plus, PL/SQL, FTP