PROFISSIONAL SUMMARY:

• Over 12 plus years of experience in IT industry as Oracle Project Lead, Technical Lead, Team Lead, and Developer with all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Debugging, Testing, Implementation and Maintenance of projects.
• 10 years of Strong Database Design, Modeling and PL/SQL Programming experience of Business Applications using Oracle RDBMS, ETL Data flows/Processing and Data warehouse.
• Strong experience on Advanced PL/SQL programming in implementing the concepts and features using bulk collect, bind variables, ref cursors, execute Immediate, Exception handling, Procedures, Functions, Packages, Triggers, Merge statements, Autonomous transactions, Global Temporary tables, external tables, Hierarchical Queries, Aggregate Functions, Analytical Functions, Batch Jobs.
• Having extensive working experience in design, modeling and development using DB technologies like Oracle 10g/11g/12c, PL/SQL, SQL, Toad, PLSQL Developer, ETL, OLTP, OLAP, Query Tuning and Optimization and Web technologies like C#.Net, ASP.Net, ADO.Net, Web forms, Web API, REST Web services, Java Script, AJAX.
• Strong experience on Oracle SQL Performance Tuning using TKProf, analyzing the explain plan and implement the required optimizer hints in executing optimized queries.
• Experience in using ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Familiarity with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data.
• Experience with developing system design specifications such as Entity Relationship(ER) Diagrams, Process Models, Data Modes Data Flow Diagrams.
• Having Experience with UNIX Cron Jobs, Batch Processing with highly complex data model and UNIX shell scripting.
• Excellent experience in interacting with the Business and stakeholders, Gathering the requirements, analyze the requirements, design and recommend solutions.
• Experience on authoring technical design document and functional specifications and providing the solution from design in the software development life - cycle (SDLC) to implementation.
• Strong experience in coordinating and providing support to UAT/QAT Team during testing phase of Project life cycle.
• Experience on working in a production support (24x7) environment, resolving the issues, providing support with technical and business issues.
• Experience in providing knowledge transfer and support to the team.
• Experience in working in an Agile and Waterfall Methodology.
• Experience in the project deliverables within the project timelines.
• Having experience in Project Management for distributed enterprise projects with cross-functional and geographical teams in an agile environment.
• Experienced Working in onsite-offshore development and delivery model for projects and products development.
• Strong Technical background mixed with Excellent Communication (Oral/Written), Inter-Personal Skills and Analytical skills.
• Good Team player and ability to lead and mentor the team.

TECHNICAL SKILLS:

DB Technologies: Oracle 8i, 9i, 10g, 11g, 12c, Oracle SQL, PL/SQL, Microsoft SQL Server, T-SQL, SQL*Plus, SQL Server, MySQL, Toad, Oracle Developer, PLSQL Developer, SQL Navigator

ETL Tool: Informatica, SSIS, ODI, Talend.

Front End Tool: Crystal Reports 2008, XI, 10, 9, Oracle Developer 2000 (Forms 10g/6i, Reports 10g/6i), Oracle Apex, JSP, Java Script

Languages: Java 6.0, VB 6.0, ASP, SQL, PL/SQL, C, C++, UNIX Shell Scripting

Database Tool: Toad, SQL Navigator, Rapid SQL, PL/SQL Developer, SQL Developer, SQL*Loader

Scheduling Tools: Control: M, Autosys, Opcon

Application Server: IIS 5.0, Websphere 8.0, Oracle 9iAS/10gAS

Configuration Mgt Tool: PVCS, MS VSS, Rational Clear Case, Harvest, Subversion, Tortoise SVN, Team Foundation Server (TFS)

Defect Mgt Tool: Rational Clear Quest

Other Tools: Putty, Win SCP, Secure Shell, SVN, MS-Visio, MS-Office

PROFESSIONAL EXPERIENCE:

Confidential, Southfield, MI

Sr. Oracle/PL/SQL Developer

Responsibilities:

• Extensively involved in Analysis, Design, Development, Integration, Debugging, Testing, Build, Release, Implementation and Production/Technical Support.
• Implemented Complex Packages for New Vehicle(MNVB), Used Vehicle(MUVB), CARFAX, CAF, and SWIFT modules.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s.
• Extensively involved in Performing database, SQL’s, tuning and optimization.
• Created various objects such as Tables, Views, Materialized Views, Stored Procedures, Analytical Functions and Triggers.
• Responsible for the development and delivery of projects in onshore and offshore model.
• Preparing technical DFD’s, data pipelines, design documents, Visio Class and ERD diagrams as per Business functional and technical requirements.
• Design and development of complex PL/SQL scripts for business requirements, mappings, stored Procs, Packages and batch programs for Hourly, BOD and EOD.
• Worked on design of conceptual, logical and physical data models using Data modeling tools MS Visio.
• Worked on the queries for improving the load performance in various schemas across databases using appropriate SQL hints.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database faster and easier to maintain.
• Worked on the export and import of data.
• Used the UTL FILE functions for the data loading activities for complex business logic.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Involved in Code Promotion and Build & Release process.
• Developed the Batch job configurations (Hourly, BOD, EOD) in batch scheduler Control-M.
• Performed DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.

Environment:, Oracle 11g/12c PL/SQL,TOAD,SQL Developer, Talend, SVN, PUTTY, Control-M, OneView 360.

Confidential, Lansing, MI

Sr. Programmer Analyst/PLSQL Developer

Responsibilities:

• Involved in requirements gathering process and assisted the business analysts in understanding the functional specifications.
• Participate in client interaction session, analyzed the business requirement.
• Responsible for delivering the Case Management and Administration modules including testing and java development, all the way from Integration to UAT.
• Worked on Performance tuning using indexing concepts.
• Created various objects such as Tables, Views, Materialized Views, Stored Procedures, Functions and Triggers.
• Extensively used SQL*Loader to load Data from flat files from various Data Sources to Database tables in Oracle.
• Involved in continuous enhancement, optimization and fixing of problems.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Designed and developed PL/SQL Packages, stored procedures, functions and database triggers required in the application.
• Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors.
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Working with database administrators to define new data model or changing the existing data model for accommodating the new business requirements by providing the best technical solutions to the client using Oracle 11g.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Better understanding of MISACWIS projects in terms of various modules ‘Provider Management’, ’Case Management’, ’Intake’, ’Investigation’, ’Financial Module and understanding of various terminology within the MiSACWIS application like ‘Person’,’ Case’, ’Intake’, ’Investigation’, ’Home Study’, ’Placement’, ‘Workload Item’, ‘Provider’, ‘Agency’, Case Service Plan’ etc.
• Worked with Analytic Functions (DENSE RANK, LISTAGG, ROW NUMBER,LEAD,LAG,etc)
• Developed BATCHES for Interfaces and Financial Modules.
• Optimized existing queries for better performance and less impact on database.
• Developed XML inbound and outbound files for different agencies.
• Worked with Indexes to avoid full table scans on large tables for the fast retrieval of data.
• Worked withBulk Collectsto improve the performance of multi-row queries by reducing the context switching.
• Designed and developed reports using Crystal Reports XI version.
• Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Extensively used PLSQL tables and Bulk loader utility for processing data and loading into oracle tables.
• Involved in analysis, design and coding of Oracle processes in PL/SQLto built packages.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files for Merge Case, Person, and Provider Use Cases.
• CreatedTables, Views, Materialized views, and constraints.
• Develop PL/SQL code for designing the reports mapping each report to its own package.
• Used Clear case for version controlling and Clear Quest for ticketing system.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked with Informatica - Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Repository Manager to load various source data to data warehouse (ETL/DW).
• Extracted data from sources like Flat Files and Relational tables and loaded into staging and informatica analytical Data Mart
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Implemented incremental loads and historical loads.
• Worked with Data modeler in developing STAR Schemas and Snowflake schemas.
• Involved in the design and development of mappings from legacy system to target Confidential environment.
• Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
• Extensively worked with performance tuning at mapping levels like implementing active transformation like filter as early as possible in the mapping. Worked extensively with Update Strategy transformation for implementing inserts and updates.
• Monitored Workflows and Sessions using Informatica Power center.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval. Worked with short cuts for various Power Center objects like sources, targets and transformations.
• Followed Ralph Kimball approach (Bottom Up Data warehouse Methodology for various data marts).
• Created Mapping variables, Mapping Parameters, Session parameters.
• Solved the complicated run time errors while running the process along with DBA team members.
• Responsible for providing essential support to team members to meet the common goal.
• Actively support testing team to archive the end result.
• DevelopedShell Scriptsfor executing PL/SQL Scripts, and the Shell scripts are scheduled throughOpCon.

Environment:, Oracle 11g, UNIX, TOAD, SQL Loader, JAVA, J2EE, Websphere 8.5, SQL Developer, PL/SQL Developer, Crystal Reports XI, XML, SQL, PL/SQL, Rational Clear Case and Clear Quest, Opcon, Struts 1.3, JSP, EJB, RAD.

Confidential, Lansing, MI

Programmer Analyst

Responsibilities:

• Involved in Technical Analysis of the business requirements.
• Involved in requirements analysis, design and development of the system.
• Involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Written/Debugged Packages, Procedures, Functions and Triggers.
• Developed and edited ETL job in DW tables, Datamart tables and Oracle Data Integrator.
• Transferred SQL and Korn shell programs into ODI and created data extracts.
• Conducted ETL development tuning, examined uncertain glitches and supported Integration testing conditions.
• Responsible for migrating ODI code (Scenarios, Projects, Models, Topology and connections) across different environments.
• Automated ETL tools, tested functional designs and monitored activities and process.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Extensively used SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Administered development, designing and testing of applications.
• Planned and conducted data integration activities as per fixed technicalities.
• Involved in Designing/Customization/Debugging of Forms and Reports.
• Develop the Complex SQL Constructs required for the Datamart Database.
• Developed the New Pl/SQL units and prepare the Unit Test cases as per the new CR.
• Developed the Generic Pl/SQL unit using the Dynamic SQL.
• Involved in the logical and physical data modeling using ER-win
• Used the UTL FILE functions for the data loading activities for complex business logic.
• Assisted in the enhancement of back end routines for the AYP application.
• Expertise in Moving the database objects using traditional import and export.
• Designed the Oracle Partition strategies, Performance tuning and data analysis.
• Expertise in writing Complex SQL queries, structure hierarchy by using Analytical functions, data validation using Regular Expressions
• Created adhoc scripts, reports by using sql and plsql for the bug fixes and pre and post verification script for the data verification.
• Loaded data into Datamarts by using Hardcore PL/SQL by writing procedures and loaded the data by using sql loader and utl file programming and also using Merge.
• Optimized the queries by creating the indexes and re-write the SQL’s for best performance.
• Developed the shell scripts to automate the jobs by using UNIX.
• Configured job dependencies, automated the jobs via Unix scripts to be called in Control-M (production batch execution tool).

Environment: Oracle Data Integrator (ODI), UNIX, SQL Developer, Crystal reports 2008, Oracle 11g, IBM Clear Case/Clear Quest.

Confidential, Lansing, MI

Programmer Analyst

Responsibilities:

• Created SSIS/DTS packages for application that would transfer data among servers and perform other data transformations, scheduled the same SSIS packages by creating the corresponding job tasks.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Configured XML Config files (.dtsconfig files) to change properties of packages dynamically.
• Migrating MS Access databases to SQL Server, Creating new database / tables to put in the extracted data and rebuilding the relationship, Created ETL SSIS packages both design and code to process data to target databases.
• As a member of BI Reporting team Developed SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2005 using different transformations; derived column, sort, aggregate.
• Created complex DTS Packages DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc., Involved in migration from SQL Server 2000 to SQL Server 2005.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Drilldown, drill through, Charts and graphs, Generated complex custom Reports as per customer requirements Using SSRS with .NET applications.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Created and deployed Crystal Reports into Reporting Services (SSRS) by using SQL Server Reporting Services.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence (BI) using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Customization and enhancement of the existing software based on user requirements.
• Worked on Dynamic Link Libraries (DLL) using Visual Basic classes.
• Worked on modules such as Participation rate, proficiency rates /safe harbor, Attendance and graduation rates.
• Involved in designing of batch files.
• Worked on AYP Admin App modules using VB and Oracle 10/11g for School AYP status and District AYP Status.
• Used Stored Procedures for most of the database operations for the Quick Access of data from the Database.
• Worked with policy people to identify the business processes, rules and application user requirements.
• Involved in gathering user requirements.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Designed and developed reports using Crystal Reports XI version.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Developed batch script to deploy SSIS packages on to the MSDB database
• Designed, Developed and implemented various reports for Confidential departments on production and test servers.
• Created heavy stored procedures for financial transaction by using procedural parameters & worked with packages, blocks & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Created various adhoc reports as of when required for the production analysis and bug fixing.
• Converted reports to browser supportable XML format.
• Extensively utilized TOAD for performance tuning by generating explain Plans.
• Involved in data validation/testing and debugging code for school report card system.
• Involved in fixing the bugs while using different versions of crystal reports and work station issues.
• Configured packages using Package configuration wizard to allow package run on different environments.
• Created complex Oracle Stored Procedure, packages using TOAD tool to migrate data from heterogeneous data sources such as MS Access, Excel etc., and Involved in migration from SQL Server 2005/2008 to Oracle11g Servers.
• Experience with SQL performance tuning, error handling, event handling, re-running of failed PL/SQL packages using checkpoints and scripting with Active-X and VB.NET in Oracle.
• Done performance tuning to SQL query on manipulating and retrieving data from Oracle/SQLSERVER 2008 for migration.
• Involved in writing test plans and writing test scripts for unit testing.
• Experience in Quality Assurance and application testing methodologies.
• Written stored procedures, triggers, views, packages, PL/SQL programming using Oracle 10/11g as backend.
• Involved in create a detail design documentation, flow charts, and procedures around organizational Infrastructure, defining standards and templates to ensure consistency

Environment: Visual Studio.NET 2010/2008/2005 , ASP, VB6.0, C#.NET, VB.Net, crystal reports, ASP.Net,T-SQL, Ajax Control Toolkit, SOM SUITE Methodology, SQL Server 2005/2000,PL/SQL, Oracle 10/11g, DB2, HTML, Win forms,DHTML, Team Foundation Server, Business Objects, JavaScript, XML, XSL, XSLT,IIS 6.0, PVCS, Ms Office 2000, XML Web Services, windows XP, MS-VISIO, MS Office Suite, CSS, 508 Compliance, UML, MS SQL Reporting Services(SSRS), Integration services(SSIS),TOAD,XML Web Services, MS Office Tools.

Confidential, Jackson, MI

Oracle/PL/SQL Developer

Responsibilities:

• Responsible for the detail design documentation, development, unit testing and maintenance of internally developed applications.
• Designed a workflow management system to streamline the process. Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors
• Responsible for creating Data change request and String Testing before deployment to production.
• Responding to Remedy case assigned by help desk.
• Designed and developed PL/SQL stored procedures, functions and database triggers required in the application.
• Used cursors and parameter passing with PL/SQL tables and data types, Reference cursors.
• Created and maintained different constraints on database and developed triggers to maintain database integrity.
• Involved in analyzing data required for the report(s) and assist ETL developers in defining the report needs.
• Give feedback in team meetings when finalizing the estimates for any given reporting requirement.
• Assist with technical expertise in meetings with business to explain things involved in requirement and suggest any improvements/enhancements which could be possible.
• Develop reports, Unit test and circle back with ETL/Database developers if any issues found during development/unit testing process.
• Scheduled oracle jobs through DBMS SCHEDULER.
• Involved in Writing, debugging and optimizing PL/SQL code.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Prepared Build and Unit Testing of Portal Data Differential CR.
• Designing and Developing Reports in Crystal Reports .net compatible version
• Developing Statistical/Graphical Reports in (Visual Basic) VB environment Using SQL Business Objects and Crystal Reports 10.x.
• Involved in Software Development Life Cycle starting from requirements gathering, and performed object oriented analysis and design.
• Involved in Quality Assurance, Technical documentation and application testing methodologies.
• Involved in unit testing and system integration testing

Environment: VS.Net 2003, VB.Net, ASP.Net, C#.NET, WinForms,ASP, VB6.0, HTML, ADO.Net, Oracle 9i, SQL, PL/SQL, Web Services, MS SQL Server 2000, Visual SourceSafe, Crystal reports 10, Designer 2000, IIS 5.0,JavaScript, ERWIN, MS Office Suite 2000, Windows 2003/XP, Unit Testing - nUnit..

Confidential, Irwindale, CA

Oracle/PL/SQL Developer

Responsibilities:

• Created ASP pages using Visual Interdev for user interface as well as on server side update.
• Involved in writing Database Triggers, Stored Procedures and Views using Oracle PL/SQL.
• Developed Data Entry and Report Generation modules.
• Maintaining source code using Visual Source Safe 6.0.
• Developed ASP pages for Authenticating a user, keeping track of user session, accepting subscription for a courses and presenting a my courses page
• Designed COM/Dcom components using ActiveX DLLs and registered in MTS.
• Wrote VBSCRIPT at the Server side and JAVA SCRIPT at the Client side.
• Responsible for integrating several modules developed by various teams
• Responsible for time-management of the development effort
• Involved in Software Development Life Cycle starting from requirements gathering, and performed object oriented analysis and design.
• Working directly with customers to identify their business processes, rules, application user requirements, and business process re-engineering.
• Involved in Quality Assurance and application testing methodologies.
• Written SQL/PLSQL queries and generate aggregates for validate reports in Oracle.

Environment: VB.Net, VB 6.x, ASP,ADO, COM+, MTS, IIS 5.0, XML, Html, Oracle 7.3/8.0, TOAD, MS SQLServer 2000, SQL, PL/SQL, Visual Interdev 6.0, ASP 2.0, Data modeling with ERwin3.0/ MS-VISIO, Crystal Reports 8.0, Java Script,IIS, VBScript,CDO, MS-Access,MS-Excel, VBA, MS Office Suite 2000, MS Visio, Windows 98/NT/2000.

Confidential, Chevy Chase, Maryland

Oracle Developer

Responsibilities:

• Created staging tables, conversion routines, custom PL/SQL API’s for converting Open Sales Orders, Price Lists including discounts, Customers, Purchase Order and Assets
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality. Data optimization, scrubbing and manipulation of staged data using PL/SQLpackages. Use ofPL/SQLbulk collection and DML (insert/update/delete) methods.
• Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails. Extensively usedPL/SQLfeatures like collections, nested table, Varray and Bulk collect for high performance of stored procedures.
• Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Extensively worked on writing complexSQLqueries (cursors, ref cursors, sub queries, correlated sub queries). Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Responsible forSQLtuning using explain plan, tkprof utility, optimizer hints. Involved in RDBMS design and developed ER-diagrams using Erwin. Participated in code walkthroughs and review sessions with the development team.
• Create various user defined EXCEPTIONS to control the process based on the business requirement.
• Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATEMENT
• Did Unit testing, integration testing and participated in Conference room Pilot (CRP) testing, User Acceptance testing (UAT)
• Prepared training documents and provided training for all Super Users
• Used Crystal REPORT Services for Graphical/Statistical report Generation.(RPTS with .net integration)
• Involved in unit testing and system integration testing.
• Create simple data movement packages with the SQL Loader Import/Export Wizard
• Involved in maintaining data quality and migrating data between all data sources
• Heavily Involved in Source code management processes, Technical documentation, and procedures
• Involved in Quality Assurance, user acceptance testing and application testing methodologies.

Environment: VS.Net 2003, C#, VB.NET, ASP.Net, MS SQL Server2000/2005, TOAD,XML Web Services, ADO.Net, XML, HTML, JavaScript, XML,XSLT, MS SQL Server Reporting Services, Visual SourceSafe, PVCS, MS-VISIO, IIS 6.0,MS Office Suite, SQL,PL/SQL, Oracle 8/9i, crystal reports, Windows 2003/XP

Confidential

Software Developer

Responsibilities:

• Involved in Application design, Business Analysis/Use Case Modeling, System Upgrade, Evaluation and System maintenance
• Involved in Gap Analysis, Preparation of TSD, Unit Test Cases, Coding, Bug fixing, Creating Reports, On-Site production and user support.
• Write/debug Packages, Procedures, Functions and Triggers.
• Designed/Customized Oracle Forms and Reports.
• Used Stored Procedures for most of the database operations for the Quick Access of data from the Database.
• Involved in software development life cycle Methodology- Requirements gathering, Analysis, design, Development and System Testing.
• Used HTML, CSS, JavaScript, VBScript for appealing GUI
• Created components that constitutes the business logic.
• Integrated the COM components to enhance the functionality
• Created User Controls to navigate between web/windows forms
• Created and used custom exception classes
• Implemented online payments processing and updates policy at the same time.
• Implemented online policy payment detail
• Implementing data exchanging between server and administrator’s application using .NET Remoting technology.
• Developed Statistical/Graphical Reports Using Crystal/SQL Server Reporting Services and XML.
• Middle tier business logic ADO.net transacts with either XML/Oracle/SQL Server
• Used web server controls with ASP.NET, ADO.NET and VB. NET
• Data conversion between ADO com and ADO.Net.
• Provided database connectivity using Microsoft OLE-DB Provider.
• Utilized Data Adapter and Data set to access database using ADO.Net.
• Dynamically configured DTS packages and tasks at run time.
• Export data to excel sheet through Data Transformation Services(DTS) package.
• Created Stored Procedures and Triggers to perform automated rules, updating to related tables using Oracle.
• Involved in reverse engineer system documentation from an existing system.
• Involved in Technical documentation, Quality Assurance and application testing methodologies.
• Used the source control tool Visual Source Safe 6.0.
• Designed and Developed Windows Forms, reports are written in MS-Word from VB
• Performed unit testing, integration testing.

Environment: C#.NET, ASP.NET, VB.NET, ADO.NET,WinForms,VB 6.0, ASP, IIS 4.0/5.0, MTS, XML, COM, HTML, Java Script, VB Script, SQL, PL/SQL, XSL,WSDL,SOAP, Crystal Reports 8.0/8.5, MS Visio,DTS,MS SQL Server 7.0/2000, Oracle 8i, TOAD,Visual Interdev, Visual SourceSafe, ADO, Dreamweaver, Windows Forms, .NET Framework 1.1, MS SQL Reporting Services, Visual Studio 2003,IIS, MS Office Suite 2000, WindowServer2003.