SUMMARY

• 15 + years of US IT experience wif 10+ years as a Database Developer.
• Possess extensive experience using Oracle Database 7.x/8.x/9i/10g/11g, PL/SQL and experience using SQL Server 2003, 2008 R2, 2012,T - SQL, SSIS,Sharepoint
• Expert in SQL wif extensive experience in Performance and Tuning.
• Experienced wif Crystal Reports, Business Objects Web Intelligence and Designing the Business Objects Universe.
• Possess ETL experience using Informatica, Pentaho.
• Possess extensive experience in creating and maintaining Datawarehouse, Data Profiling, Data Migration, Cleansing and Analysis.
• Experienced in IT Service Management (ITSM), Configuration Management Database (CMDB) through BMC Remedy 7.1 and 7.6.
• Possess extensive Design and Development work experience using various versions of Oracle and its tools (Developer, Designer, Portal/WebDB).
• Possess experience in supporting Projects built using J2EE technology,.NET technology.
• Possess extensive experience working on Unix,Windows and Linux platforms.
• Possess experience wif Salesforce, Ruby on Rails.
• Completed ICAA certification in Fundamentals of Agile.

TECHNICAL SKILLS

Database: SQL Server, Oracle, MySQL, MS Access

Languages: PL/SQL, Python, R, Java, SQL, XML, Unix Shell Script, DHTML, HTML, JavaScript, VB

Oracle Tools/Utilities: SQL*Plus, TOAD, Designer 9i/6, Oracle Forms, Oracle Reports, Oracle Portal/WebDB 2.05, SQL Loader, Oracle Enterprise Manager (OEM),Oracle Advance Queueing, Oracle Inermedia, Erwin

Microsoft Tools: Visual Studio 2012/2005/6, Visual Studio .Net 2003,Visual Basic 6/5/4,VB.net

Java Tools: Eclipse

ETL Tools: Pentaho, Informatica

BI Tools: Crystal Reports 10/XI, Business Objects XI

Web/App Servers: Apache Tomcat 5.5/6.0,Oracle Application Server 9ias/4.02, Microsoft IIS

ERP: SAP R/3 Rel 4.0B

Version Control: SVN, Visual Source Safe, CVS, Github

Operating Systems: MS Windows,Linux,UNIX

ITIL Tools: BMC Remedy 7.6/7.1

QA Tools: HP Quality Center 10.0, Clearquest,JIRA

PROFESSIONAL EXPERIENCE

Sr.Technical Consultant

Responsibilities:

• Development DBA for the Enterprise Data warehouse project built on SQL Server 2008 R2 using Informatica 9.6.1/9.1.0. Key responsibilities include Data profiling using Informatica Analyst 9.6.1, Data Analysis, Data Modeling using Erwin 8.0, Creating Tables, Views, Triggers, Creating complex SQL’s to incorporate complex business functionality to be used in ETL as source qualifier for improving ETL performance, Writing complex stored procedures to load the historical data based on business rules to eliminate duplicates on tables wif more than 700+ fields wif large data, Creating reusable SQL Scripts to generate test data for unit and QA testing.
• Data validation Lead wif responsibilities that included End-to-End data validation efforts, oversee data validations performed by team members, develop new data validation routines for data sources, data issue identification, reporting and resolution wif client. The responsibilities also included validating, modifying SAS reports.

Sr. Associate

Responsibilities:

• Worked as Data architect for client FDA. The responsibilities included DBA activities on Oracle 11G database, Informatica 9.1.0 installations and participating in data migration process, Data Analysis, Data modeling using Erwin. Used JIRA for task management and bug tracking.
• Created Audit process to record only the effected fields
• Created reusable PL/SQL package to generate database triggers to be used whenever their is a DDL change.

Associate

Responsibilities:

• Performed end to end data validations for data warehouse built on Informatica 9.1.0, SQL Server 2008 R2 and SAS. Check the Informatica mappings for debugging the issues. Validate the SAS reports comparing the target data wif SAS reports and SAS scripts which generate the reports.
• Supported Incident Management System built on BMC Remedy 7.6, Crystal Reports and SQL Server 2008
• Created Risk and Issue management tool using MS Access, SQL Queries, VBA, Macros and Pivot Tables
• Created Web site using ASP.Net, C#, IIS Server on Windows 2008 R2
• Set up Ruby On Rails Environment on Windows 2008 and Red Hat Linux, creating reports using Ruby on Rails, modifying SQLite database, modifying user interface, importing repository from GitHub.
• Created Web application using ASP, VB.Net, Visual Studio 2012, SQL Server 2008 R2, SSIS, Alfresco, Web Services. The responsibilities also included setting up the environment, building the database, configuring the IIS Server.
• Assisted in proposal writings, created compliance Matrix, cross check compliance matrix against proposal drafts, adding comments for RFI preparation.

Software Engineer

Responsibilities:

• Developed ETL process for getting the source data related to server hardware, locations, network information, host to application and application interface from Oracle, SQL Server, Flat Files from URL and BMC Atrium Discovery and Dependency Mapping (ADDM) reports and load into target tables in Oracle 10g using Pentaho. Generated Excel reports and posted to SharePoint Site using Pentaho.
• Built DataMart on Oracle 11g created ETL Process to load problem, change and incident data from BMC Remedy 7.1 system and Asset Management data from 7.6 System to IRDQ DataMart using Pentaho, PL/SQL and SQL.
• Created Web Intelligence Reports on data quality for BMC Remedy 7.6 Asset data, Problem, Change and Incident data from the DataMart using BOXI 3.1 SP3.
• Wrote SQL scripts to check data integrity and validation between BMC remedy 7.1 asset data and BMC Remedy 7.6 asset data, used Pentaho, Oracle 11g for data load And data storing. Reports were generated in MS Excel.
• Installed ARSystem7.6.04, AtriumCore7.6.04, ITSM Suite 7.6.04, BMC Service Request Management 7.6.04, BMC Service Level Management 7.6.04, Atrium Integration Engine 7.6.04, Atrium Integrator on Suse Linux, BMC Dashboards 7.6.03, BMC Analytics 7.6.04, Business Objects XI 3.1 SP3 on Windows 2008 Server for Test, Acceptance and Production environments. Resolved UI Issues, monitored AIE Jobs, applied Hot Fixes/Patches for IT Asset Management Project (ITAM).
• Evaluated different BI tools and ETL tools which provide flexibility of getting the data from and into Force.com database from different sources and provide the capability of BI reporting on a Cloud Based platform apart from Salesforce.com and can easily integrate into Salesforce.com application.

Senior Software Engineer

Responsibilities:

• Supported web self-service Application built Using Java/J2EE, Struts, Spring framework, Hibernate, Eclipse, Apache Tomcat 6.0. Responsibilities include production Support, bug fixes, adding new functionalities, updating existing functionalities.
• Tuned SQL used for existing Oracle Reports and improved performance by 90%.
• Improved performance of Roster processing through Oracle Partitioning. Roster process includes processing of flat files wif more than million records.
• Supported Enrollment Broker System used for Healthcare solutions built using Oracle Forms Developer, Reports Developer, Oracle Designer, Oracle 10g and Oracle Internet Application Server on Sun Solaris OS. Responsibilities included production support, bug fixes, performance monitoring and improvement, adding new functionalities, updating existing functionalities through Forms, Reports, Packages, Procedures, Functions, Triggers, Views, Java Stored Procedures, Shell Scripts, XML and SQL and monitoring Jobs through OEM(Oracle Enterprise Manager).
• Performed data analysis, created DataMart, developed ETL process using Pentaho, PL/SQL and created reports using Crystal Reports 10..
• Designed and developed process to automate image upload process from a remote ftp server into the database, archival of old images to an external device using shell script, PL/SQL, used OEM for scheduling the daily Jobs.

Senior Software Developer

Responsibilities:

• Supported Content Management System which was built using ASP.NET, C#, AJAX and DOM Manipulation, Oracle 10g database on Linux. Responsibilities included production support, implement the new functionalities by creating PL/SQL packages, procedures, functions, triggers, views, XML transformation through XSL, DOM manipulation on the Database using PL/SQL and SQL and some user interface changes and enhancements using ASP.NET, C#, JavaScript, XML and DOM Manipulation.
• Automated process where IIS Logs are exported to database on daily basis using logparser and windows scheduler for Data mining Purpose.
• Designed and developed process to archive the data in the audit tables based on a time period using PL/SQL and XML.

Software Developer

Responsibilities:

• Created Helpdesk tool and Testing tool using Visual Basic 6 to perform various DML operations for Common Oracle Database (CODB) project.
• Designed and developed process for IIMA (Integrated Invoice Management Application) to import invoice documents residing on a remote server into Oracle using PL/SQL, Oracle Advance Queueing and Oracle Intermedia, XML, T.O.A.D, Oracle 9i, Red Hat Enterprise Linux .
• Designed and developed Web based forms and reports using Oracle 8i on Sun Solaris for Common Oracle Database Automated Functional Environment (CAFÉ) Project using PL/SQL Cartridge, JavaScript, DHTML, T.O.A.D, Oracle 9i Application Server on Windows 2000 Server.
• Designed and developed process to post the database changes in the form of an XML document to a vendor for the Information Technology Solutions Shop (ITSS) XML Messaging Project using PL/SQL, XML. XSL, Oracle Advance Queuing, Java, Oracle 8i on Sun Solaris.
• Designed and developed Web based forms and drill down reports using Designer 6i, PL/SQL, PL/SQL Cartridge, Javascript T.O.A.D, Oracle 8i and Oracle Application Server 4.0.2 on Windows NT for Customer Project Tracking System (CPTS) Project .