GNANASUNDARAM DHANDAPANI

Senior Software Engineer (Oracle PL/SQL and Performance Tuning Developer/DBA-APPS Support/Data Analyst/Database Architect/Batch Management Support/Production Support/GCP and BIG Query Support) ad12a3@r.postjobfree.com

571-***-**** (M)

Status: Permanent Resident

Manassas, VA 20110

Executive Summary:

I’m energetic software professional with 32 plus years of experience developing robust code for high-volume software businesses. Possess rich experience in working with multiple complex ETL (Data Extraction, Transformation And Loading) Tools and Data integration Projects by implementing a solid, robust, extensible design that supports key business flows to increase code-efficiency and defined system specifications for the extract, transform, and load (ETL) of the source-to-target data, executing data transfer using the Informatica PowerCenter, Abinitio, IBM Infosphere Data Stage tools. Possess exclusive knowledge to integrate, manipulate, and extract large disconnected datasets and manage vast amounts of data into the next generation of data analytic solutions for clients. Interact with multi-disciplinary teams of analysts, data scientists, developers, and users to comprehend the data requirements to develop a robust data processing pipeline that ingest, manipulate, normalize, and expose potentially billions of records per day to support advanced analytics. Play a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing. Implemented data storage solutions for several high-volume businesses for heavy concentration in data structures for improved data quality, and metadata management (including ETL design, data modeling and implementations) My daily duties, included leveraging subject matter expertise in data design, data management, data owner relationship management, data ingest and ETL, and maintain documentation of data architecture, database monitoring and maintenance, and SQL job management and creation. In addition, I’m a versatile Team Player with a can-do attitude, phenomenal time management skills, and a strong user focus. Professional Summary:

• Areas of specialization include Performance Tuning techniques at schema and Server level, Data Modeling, and ORACLE PL/SQL and Oracle 8i/9i/10g/11g/12c/19c/19c EE (ExaData).

• Advanced Analytical functions and JSON generation for application and reports.

• Application tuning: Tuned both front-end and back-end which involves SQL and PL/SQL using the Oracle tuning methodology like Partition, Index, clustering and Parallel query techniques for CPUs; have also used SQL tuning tools like stat pack, auto trace, dba views, oracle Grid control and explain plan table.

• Database administration: Experience with data modeling, PL/SQL and SQL tuning, tuning the SGA and ETL type of works except the backup and restore techniques of RMAN. Have also done Unix automation process Scripts using KSH scripting and Windows scripting.

• Data modeling: Have done schema re-engineering as well as new schema modeling using Erwin. Possesses strong data modeling knowledge in star and snow-flex schema. Have also re-engineered existing schema and plugged in many new process models using Erwin tool and have strong normalization techniques which can be used for old or new process models.

• Data warehousing and ETL (extract, transformation and load process) architecture using Ab-initio, IBM Datastage, SQL and PL/SQL.

• Experience with Oracle OEM/Grid Control and DBA Tools using SQL Developer.

• Performed on the job DBA work viz, OEM, DATAGUARD, GOLDENGATE REPLCAT, RMAN, ASM, PARTITION, STANDBY DATABASE, EXPORT/IMPORT, SQLLOADER, PERFORMANCE TUNING, SQL, DYNAMIC SQL. etc.

• Have experts experience in REMOTE database extract using Oracle BULK processing techniques and performance tuning techniques, which involves TWO PETABYTES of data storage in process.

• I have worked with python3.6 and Oracle ODM techniques and Contributed to High hand public domain Kaggle and other Data Science competitions and Rank few in the Top list. Areas of specialization on

ORACLE Platform

Year

s of

Exp

Last

used

Other ETL tool in

ORACLE Platform

Years

of Exp

Last

used

Other ETL tool and supporting

tools

Years of

Exp

Last used

Oracle

8i/9i/10g/11g/12c/19c/

19c EE

20+ 2023 Sql server 2000+ 4+ 2022 Abinitio,IBM Infosphere DataStage

2+ 2023

Oracle PL/SQL and

JSON

20+ 2023 T-SQL 4+ 2022 Unix/Windows shell

scripting

9 + 2023

Oracle Performance

Tuning Techniques

20+ 2023 ETL Tool 5+ 2023 Autosys 1+ 2006

Oracle Bulk

Processing

Methodology

14+ 2023 Transformation of

data from ORACLE

data to

SQLSERVER

Methodology

3+ 2022 Informatics

PowerCenter Workflow

Monitoring

1+ 2018

Oracle ETL Tool (SQL

loader/Export/

Import/PL-SQL/Ab-

initio,Shell scripts)

19+ 2023 Access DB for

transformation and

for comparisons

2+ 2022 ANSI/NATIVE SQL 26 2023

Crystal Report BI Tool 1+ Data visualization

Tools–

Spreadsheet/ crystal

reports/Access

Report

20 2022 Windows Server 10 2022

Skill set relating to Oracle

DBA on the Job

Level of Efforts

Data Modeling Expertise in existing database schema re-engineering and new schema modeling using Erwin/ER-Studio tool. Strong data modeling knowledge in star and snow-flex schema. Also re-engineered existing schema and plugged in many new process models using Erwin/ER-Studio tool and have strong normalization techniques which can be used for old or new process model. PL/SQL 20+ years of strong Oracle back-end experience using SQL JSON and PL/SQL techniques from version 8.0 to 11g/12c/19c/19c EE. During the PL/SQL coding in multiple projects I have used different features available in 9i/10g/11g/12c/19c like objects-oriented techniques and also dynamic Sql to facilitate the latest features. While writing the SQL inside the PL/SQL blocks also used latest Analytical query techniques. Expert experience in REMOTE database extract using Oracle BULK processing techniques and performance tuning techniques, which involves TWO PETABYTES of data storage in process. Application tuning Tuned both front-end and back –end which involves SQL and PL/SQL using the oracle tuning methodology like Partition, Index, clustering and Parallel query techniques for CPUs…etc. and also used the following SQL tuning tools like stat pack, auto trace and explain table, TKProf, sql tune. The optimizer techniques like Oracle wait event, optimizer, Histogram, clustering factor. DBA experience Considerable hands on experience in the DBA’s work like data modeling, pl/sql, sql tuning, tuning the SGA and ETL type of work with a large volume of work. Worked on OEM, DATAGUARD, GOLDENGATE REPLCAT, RMAN, ASM, PARTITION, STANDBY DATABASE, EXPORT/IMPORT, SQLLOADER, PERFORMANCE TUNING, SQL, DYNAMIC SQL, CDC using SQLs. Etc. I have also done Unix/LINUX automation process Scripts using KSH scripting also windows Scripting. Cloud like AWS, GCP

and Business Object

Tool

Worked with business object crystal report/BI and considerable knowledge on Tableau /Redshift /Mangodb exports/imports and other db techniques using VBA and Command line. PostgreSQL/BIG Query : knowledge only, which is similar to PL/SQL coding and using database query tools like RazorSQL...etc.

Solid Knowledge and experience in Data source, Data Lake, Data warehouse, Data mart and Dashboard at the level of Data Architect/Database developer at the level of Data Architect/Database Developer.

Developer 2000

Tool

Worked with Developer/2000 tools like form and report and hands on experience in Oracle APEX web server.

Customized Database

DB Tool (Developed

by me)

I have customized DB script to Analyze Oracle based APPLICATION quality using DBA view tools and also Trap Application Error by type/session using DBA view tools. Data Science

Techniques

Worked with python3.6 and Oracle ODM techniques and Contributed to High hand Kaggle... competitions and Rank few in the Top list. Can read the code and troubleshot platforms and the Configurations.

Federal Projects:

FAA

DOL

USPS

FANNIEMAE

FMCS

A DOD

TSA

PCA

Other Projects:

Telecommunication

Students information system

Pharmacy and Production

Finance and Accounting

Ctep

Cigna

Ups

Education/Certifications:

Bachelor of Science Degree Madras University, India (1985) Institute of Chartered Accountants of India Intermediate (1988) NIIT, India -Post Graduate Diploma in Software Systems Management. (1991) Employment Experience:

UPS Google Cloud Project -(USA) Dec 2022-Oct 2023

Oracle PL/SQL and UNIX/LINUX Technical Support Analyst -REMOTE (PL/SQL, SQL, Shell Script, Mainframe ESP Jobs, IBM Data Stage, Design, Documentation) and this position plays a key role in daily Unix/Oracle Transiting the ups PAYROLL Mainframe and Data Mart information to Google Cloud project. UPS Global Payroll system (Mainframe) and data mart maintains Employees Daily /Weekly /Monthly Wage details, other pre-paid benefits and tax details for employee, which was used in GCP project and I supported the transformation of existing PAYROLL mainframe and PAYROLL data mart details. As a Technical support role to get the existing processes in the payroll and Data mart information and pass across or through (an area), which requires a combination of strong analytical, planning, communications and hands-on technical skills.

• Transiting Job Processes to GCP

1. Creating details schema and Process document for PAYROLL system from Mainframe Linux and ESP scripts.

Creating detail schema and Process document for DATA MART (PDM) system from Oracle and Linux scripts.

• GCP Design session

1. Providing and supporting Oracle Data mart details for Design queries.

Creating Oracle Data mart sample and validation data for GCP using PL/SQL and SQL scripts based on Data Mart FACTS AND DIMENSIONS tables.

Attending Design sessions and providing support based on the data mart schema.

• Data Mart to GCP ETL staging data process and sample scripts.

Creating generative Oracle Dynamic PL/SQL script based on the PDM table structures for GCP ETL like Partitions, for performance and CDC.

Creating SQL tracing scripts for legacy system.

Other related DB supports relating to DB access etc.

• Transforming the IBM Data Stage CDC Job Processes to GCP 1. Creating details schema and Process document for Data stage Change data capture (CDC) .

Creating supporting SQLs for cdc process using pdm schema objects (staging to original table). Tools: SQL and advanced SQL statements Reports, Unix/LINUX, Allround Automation PL/SQL Developer tool, Oracle PL/SQL, Linux Shell Scripting,, Mainframe ESP, IBM info sphere Data Stage, SQLPLUS, Service Now, Azure Devops, BIG Query.

CIGNA HealthCare Batch Management Project- (USA) Feb 2022-Aug 2022 Oracle PL/SQL Technical Support Analyst -REMOTE (SQL, Shell Script, T-SQL, SSIS, PL/SQL, Java) and this position plays a key role in daily Unix/DB batch process for the extraction and transformation of data from the Cigna Healthcare gateway to accounting system. Cigna provides Medicare, Provider, Broker and employers type of Health benefits throughout the world and I supported NA production support. As a Technical support role to get the BATCH MANAGEMENT processes move, requires a combination of strong analytical, planning, communications and hands-on technical skills.

• Monitor and review incidents reported by business teams.

• Propose DB scripts/Shell scripts changes for the most impacted area of application incident tickets and Batch process failures.

• Providing hands-on technical tier 2 research and root cause analysis.

• Perform in-depth data and systems analysis.

• Propose DBA performance impacts for the schemas for the on going batch processes and monitor db bottlenecks using DBA views.

• Daily or so run adhoc data extraction and transformation using shell script for failed and other type of data's.

• Providing 24/7 on-call support for production application outages and critical incidents and maximize the productivity.

• worked with a variety of staff and resources in multiple time zones and locations.

• Managing configuration changes and develops batch data updates.

• Troubleshooting High priority issues and fixing the Custom Oracle DEAMON and other type external servers/com products during processes and upgrades to the system.

• Maintaining process and troubleshooting documentation to be utilized by the team.

• Organize and coordinate meetings with business users for specific application areas, as well as work to prioritize requests from business users for those areas.

• Perform code review.

• Worked on Service now user incident tickets for Accounts payable Payment (AP) reconciliation process reports as a Unix batch script.

Tools: SQL statements Reports, Unix, SQL Server T-SQL, SSIS, Oracle PL/SQL, AIX Shell Scripting, Java, Cognos, Qlikview, Mainframe ESP, IBM Workstation, Crystal reports, Service Now. CTEP Therapy and Evaluation program Application - (MD, USA) Aug 2021-Dec 2021 Database Developer at ctep application, MD (REMOTE) and this position plays a key role in converting an ORACLE FORMS/REPORT for commercial and investigational application to java based application using oracle19c and ctep aurora application system, is the data collection of information about the Agent, formulation, investigator, restrictions rules and the order placement for clinical trail and track major events encounter through the process. As a database developer role to get the conversion of db objects from oracle application to java/JSON based application, involving analysis/design and develop PL/SQL program to accommodate the java/oracle based application.

• Used SQLdeveloper data model for Analysis and database design for JSON format db objects.

• Generate JSON based single and multiple input and output results for java grids and reports like PDF, xls etc

• Executed advanced JSON Oracle PL/SQL using PL/SQL objects Release 19c capabilities viz, Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement and Optimized SQL statements for the application and reports.

• Analyzed oracle forms and reports SQL, DB objects for conversion to oracle SQL JSON, packages and procedures. .

• I was involved in inventory, communication, restrictions module related conversions using PL/SQL advanced SQLs (anal, JSON and packages, procedures, functions..etc.

• Proposal for the Design implementation for Restrictions,Inventory and Patient Enrollment on/ff treatments. Tools: Oracle Database Enterprise Edition Release 19c PL/SQL and db objects, SQL Developer Tool/Model, Windows platform, and JIRA/bitbucket.

Case Management/Financial Remedy application - DOL-Federal (DC,USA) Feb 2020-Jun 2021 Database Architect/Developer at DOL Washington, DC (REMOTE) and this position plays a key role in Department of Labor Federal Government organization for developing Financial Remedy application and case management system (CMS), is the data collection of OFCCP (OFIS) COs use to record basis information about the contractor, to track major events encounter through the evaluation, and summarize any violation found and remedies obtained. As a database developer/Data architect role to get the optimal workflow at CMS level application and propose a document /scripts to ensure the system shows the optimal workflow and indicate/implement/trap errors at application level based on the data and report monthly the DB status level. This role requires a combination of strong analytical, planning, communications and hands-on technical skills.

• Task 1 Financial Remedy deployment progress monitoring and development of DB tickets

• Task 2 Monthly DB release report -Progress Monitoring/Preparing for next release-db scripts

• Task 3 Analysis of Bug list and Dev Tickets in JIRA

• Task 4 Analysis and Report of inc# and Federal contract manual relating to Database objects and db scripts

• Task 5 Analysis and Report of data model relating to Data and user guide based on the new ERD_OFCCP_<> model

• Task 6 Analysis and Report of sprint items relating to database objects and attending developer/sprint demo

• Task 7 Creating, Validating and Report database scripts relating to application

• Task 8 Validating Preprod, prod and other environment for invalid objects and their errors

• Task 9 Analysis of DB objects to Application for proposed remedial solution based on the JIRA items

• Task 10 DB Performance analysis and generating scripts for future releases Tools: Oracle11g/12, SQL queries, DOS/Unix scripting, SQLDeveloper, Data Architectures for proposals Sirius-XM Satellite Inc (DC, USA) Oct 2018– Dec 2019 Sr. Analyst Production Support at Washington, DC This position plays a key role in the IT Production Support Services organization, supporting operation controls of various applications/functions such as auto-renewal, email notification, supply chain, enterprise service bus (ESB), and subscriber management platform to ensure timely and accurate processing of transactions end-to-end. The Senior Analyst ensures that transaction fallout is identified, categorized, aged and remediated/escalated and that there is transparency around the status reporting, including the implementation and management of IT application/interfaces, dashboard reporting, processes and procedures. This role requires a combination of strong analytical, planning, communications and hands-on technical skills.

• Support multiple production applications (i.e. auto-renewal, email notification, supply chain, enterprise service bus (ESB), and subscriber management).

• Design/develop processes and reporting for cross-application/cross-function control reporting. Identify, track and remediate control weaknesses of production applications. This Includes creating and supporting dashboards, metrics and reporting to isolate and mitigate control weaknesses and data quality issues.

• Support end-to-end process audit, meeting established SLA's and data quality standards.

• Serve as a contributor on a team providing production support for the SOA infrastructure, and Tibco platform for multiple business critical services.

• Work closely with the business and IT teams to troubleshoot/remediate system issues and ensure remediation plans are implemented.

• Work with the project and development teams for system enhancement and to drive remediation of software defects, configuration and performance issues; which impacts production processing, and data quality.

• Develop, track, maintain and document service level agreements, operation run books, and transaction fallout/remediation procedures.

Tools: Oracle11g/12, Microsoft SQL Server, Teradata, SQL queries, DOS/Unix scripting, VBS scripting, MS-Office Suite, Tibco Analytics(spotfire) and developed own cross-functional control point Monitoring Tool using VBS for Production Volume Analysis.

United States Postal service (USPS, DC, USA) Aug 2017 – Sep 2018 SASP System Application Monitoring Support

Served as a Data Architect in Systems Application Monitoring support for the United States Postal Service SASP, in a large-scale Agile development environment. The system requires end to end data analysis and continuous monitoring to retrieve electronic document from customer to Postalone! Application for finalization of postage. which is the oracle-based back-end application engaged in pull, validate and push data to the different end-point of the Postal online business. Provided data analysis, data architecture support at flexible schedules including nights and weekends based on team schedules.

• Provided continuous data monitoring with Automation using Windows scripting Language (VBS)

• Used SQL and UNIX for 24/7 monitoring. Oracle-based production batch schedule runs.

• Investigate and debug process failures and generate metrics to Application support team.

• Identify long-running processes and continuous monitoring of overall batch schedules and accurately assess and report risks to business SLAs.

• Developer monitoring XLS tool accessing oracle to display the current status of the informatica process by group Tools: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0, PL/SQL Release 12.1.0.2.0 – Production, TNS for Linux: Version 12.1.0.2.0 – Production, Linux version 3.0.101-108.18 and windows scripting VBS Federal Motor Carrier Safety Administration (FMCSA VA, USA) May 2016 – Jan 2017 URS Registration Project (Oracle11g)

Served as Oracle PL/SQL Developer / Administrator providing Data analysis to design back end data processing for a web application that focuses on the Motor carrier industry data that’s readily available for screening and other safety administration processes. Developed schema patch maintenance in accordance with PL/SQL ETL, Data Sync, application and support sessions for modification and enhancement of the system.

• Executed schema patches maintenance using Tortoise SVN.

• Used Oracle PL/SQL development using PL/SQL Release 11.2.0.1.0 capabilities viz, Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement. Extensively used Oracle Optimized SQL statements for the application to support production databases.

• Refactored PL/SQL packages for new and existing code coverages.

• Prepared and provided real time test data.

• Coordinated works on URS Data Model, PL/SQL ETL, Data Sync, application and support sessions for modification and enhancement of the system.

Tools: Oracle Database11g Enterprise Edition Release 11.2.0.1.0, PL/SQL Release 11.2.0.1.0 ER Studio modeler, Tortoise SVN, SQL Developer and PL/SQL Developer 11.0.6, Unix.

United States Postal service (USPS, VA, USA) May 2012 – Mar 2016 PostalOne! Project (Oracle 11g)

Worked as a Sr. Oracle Database Developer/Administrator supporting Data analysis and for BULK data processing for a web- based application, for postal online business mailing services, providing complete electronic Data exchange to manage every aspect of the mailing process more efficiently and cost-effectively.

• Provided REMOTE database extract using Oracle BULK processing techniques and performance tuning techniques, which involves TWO PETABYTES of data storage in process

• Executed Oracle SQL Tuning using SQL statement tuning (Hints, Rewrite SQL, SQL Profile) Instance object tuning (PL/SQL packages, procedures) Instance Workload tuning (Optimizer setting, Optimizer statistics tuning, Cursor sharing)

• Supported Oracle PL/SQL development using PL/SQL Release 10g/11.2.0.1.0 capabilities viz, Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement.

• Analyzed Unix process monitoring for SQL, TKPROF for oracle performance tuning.

• Data Architecture for ETL (extract, transformation and load process using PL/SQL. Tools: Oracle Database11g Enterprise Edition Release 11.2.0.1.0, PL/SQL Release 11.2.0.1.0, ER/Studio model, Tortoise SVN, TOAD, Unix.

National Student Clearing House, VA, USA Jun 2011-Mar 2012 Student degree and enrollment verification Project (Oracle 11g) Served as a Database Administrator for an online Student degree and enrollment Verification system.

• Used ER/studio for Analysis and database design.

• Executed Oracle PL/SQL using PL/SQL Release 11.2.0.1.0 capabilities viz, Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement and Optimized SQL statements for the application and reports

• Worked on Oracle SQL Tuning using

o SQL statement tuning (Hints, Rewrite SQL, SQL Profile) o Instance object tuning

o Instance Workload tuning (Optimizer setting, Optimizer statistics tuning, cursor sharing) o Server tuning (iostat, vmstat and CPU) using OEM (grid) enterprises

• Analyzed Unix process monitoring for SQL, TKPROF for oracle performance tuning Tools: Oracle Database11g Enterprise Edition Release 11.2.0.1.0, PL/SQL Release 11.2.0.1.0, ER/Studio model, Tortoise SVN, TOAD, Unix.

Federal Aviation Administration (FAA), VA, USA Dec 2008-Apr 2011 Cru-Time Card and Duty Management

Served as a Sr. Programmer supporting Database analysis on Employees Personnel, Time Card and Duty Management System for each facility in and around USA for Federal Aviation Administration Program.

• Provided thorough data analysis and design of VB6.0 application enhancement for Crux application.

• Created and implemented custom maintenance patches using Oracle SQL and PL/SQL.

• Developed SQL scripts to upgrade database and install new Oracle environment which utilized Windows Authentication for security.

• Provided direct support to the Database team to resolve Oracle related problems.

• Used VB6.0 and Oracle PL/SQL for coding and data management.

• Conducted and improved database performance tuning by SQL statements, index tuning, creating materialized views, and data warehousing.

Tools: Oracle (9.X/10G) PL/SQL, SQL, TOAD, Crystal Reports, VB6.0. Sirius-XM Satellite Inc, VA, USA Jul 2007-Oct 2008 Partner's Settlement System.

Served as an On-site Coordinator for Data base reports and queries and operational tasks for the Project PSS is the in-house Partner's Settlement System, tracking monthly payments process for the Radio sold activity and AP process.

• Provided Support to monitor payment processing system using ad hoc PL/SQL and SQL queries.

• Designed User Manual Documentation for the Apps.

• Modified existing Crystal Reports and Oracle procedures for Bug Fixing and added new functionalities.

• Performance tuned existing SQL and PL/SQL modules.

• Automation Tools for Unix and Oracle processes using Ksh script and Windows scripting. Tools: Oracle PL/SQL, SQL, Erwin, UNIX, KSH scripting, Crystal Reports, TOAD, Visio, VBA/WSC script. Arbinet Inc, VA, USA Nov 2006-May 2007

Online Telecom Trading

Served as a Sr. Developer providing coding and data base support for a Multi-platform product developed in ASP, ASP.NET, COM+ and Oracle

• Supported maintenance, development, and bug fixing of Arbinet Web based Application using ASP, ASP.NET, C# Oracle

(PL/SQL)

• Modified existing Oracle procedures for Bug Fixing and added new functionalities. Tools: Windows XP, Oracle PL/SQL and ASP.NET, C#, COM+, ASP, IIS, TOAD. Erwin FannieMae, VA. USA Mar 2006-Nov 2006

RE-Statement

Served as an Oracle/Access/AB Initio Developer to support a RE-Statement project is to accomplish the Single-Family Non-Accrual information that must be produced for each Type 1 EUC (Ender user Computing) application that will be executed for the RESTATEMENT. For the purpose of Restatement, the Access application was considered for the EUC Type 1 computing and Its a Complete SQL based Computing system using Oracle, AccessDB and Abinitio as an ETL tool. This EUC application is the base for the ORACLE 7 Balance sheet computing.

• Initiated set up and designed EUC Access database for the different Loan Categories viz. TDR, REO, Securities.

• Designed and developed Ab Initio graphs using ORACLE and Unix

• Extracted and Transformed Oracle Legacy systems Data into Oracle server using PL/SQL and Ab Initio.

• Analyzed and wrote SQL queries based on the Requirement EUC computing.

• Created and generated the ADHOC queries using ORACLE and Access databases.

• Scheduled Jobs in Unix using JIL Scripts.

• Data Architecture for ETL (extract, transformation and load process using PL/SQL) Tools: Windows 2000, Unix, Oracle PL/SQL, Access 2000, SQL*Loader, VBS Scripts, Ab-initio Graphs (ETL tool 2.x)), Unix Shell scripts, Access Reports, Erwin, Scheduler Autosys, Data warehouse. Cogent Communications Inc, VA, USA Oct 2004-Mar 2006 Cogent Communications Intranet applications

Worked as a Sr. Developer for Internet service providers having applications running on Oracle/SQL Server 2000 on Windows/Unix Platform. I was leading the effort to process Customers Data in different process levels with the help of intranet application.

• Used ASP2.0/SQL Server 2000/T-SQL for Developing Billing system and application maintenance, development and Bug Fixing of (BOB) Building and tenant Application using Developed dynamic and static Web Reports.

• Maintained VB.NET application for Monthly usage billing data (Meter maid).

• Extracted and transformed Oracle Legacy systems ORACLE data into SQL Server using PL/SQL/T-SQL.

• Created and modified web-based Crystal Report application using IIS and Crystal Report 8.5 and 10.0.

• Created Advanced Procedures and Functions using SQL Server T-SQL for ASP, ASP.NET & Crystal Reports.

• Troubleshot SQL Server procedures, Functions for the above Applications using T-SQL.

• Performance and Optimization Techniques in ASP.NET and SQL Server 2000.

• Database Re-Engineering for the existing modules using Erwin.

• Wrote WSC scripts for Extracting Legacy and External Data for Reporting.

• SOX compliance – CMR procedures.

Tools: Windows 2000, T-SQL, UNIX, Oracle PL/SQL, Erwin SQL Server, ASP.NET, ASP 2.0, IIS and Crystal Reports 8.5/10 in WEB.WSC scripts, VB scripts, Java Scripts, JAVA & Apache Tomcat server. PRA International, VA, USA Aug 2004-Oct 2004

Project Management Worksheet

Served as a Consolidated Reporting Data Analyst generating Data matrices using Documentum Script from Access Database into staging tables for Data remediation on existing and migrated applications.

• Prepared GUI using VB6.x for a Macros in Excel and Access/2002 for an additional functionality to the system.

• Developed performance monitoring processes and worked with Data architects on future strategies

• Improved integrity of the database design and Developed a data migration plan and scripts to convert the existing legacy system Tools: Windows/2000Professional, Visual Basic 6.x, Excel Macros, Erwin, Access/2002, Oracle9i Enterprise Edition Release 9.2.0.4.0, Documentum.

NIS Solutions, VA, USA Oct 2003-Feb 2004

Chemical-Biological-Radiological Defense

Served as a Fund Tracking System Analyst preparing

Contact this candidate