PROFESSIONAL SUMMARY

• Over Six Years of experience in Information Technology with full s/wdevelopment life cycle including Analysis, Database Administering, System Integration and s/w Configuration.
• Strong Knowledge in Data Warehousing, Data mining, Data modeling andSQL, PL/SQL, T-SQL tuning Techniques.
• Strong Knowledge on MS SQL and Oracle 10g Database Administration activities.
• Experience in Server Installation, cloning of databases, Backup & Recovery & Performance Tuning.
• Experience in ERP system (ORACLE APPLICATIONS). Administering using AD utilities.
• Strong Knowledge in normalizing the databases.
• Worked with long term projects and have experience on SQL Developer, Oracle Discoverer, Microsoft SQL server that support SQL, T-SQL, Forms, Reports, Oracle Jdeveloper, Oracle Business Intelligence Discoverer.
• Experience in programming DTS/SSIS and SSRS packages.
• Experience in writing Stored Procedures, Functions, Cursors, Packages and Database triggers and upgrading the Database, Forms and Reports to higher versions.
• Experience in n-tiered architecture, developing web forms using C# and ASP.NET and console applications.
• Strong in database management concepts, UNIX skills and excellent understanding of E-R diagrams and Oracle Data Dictionary.
• Experience in working on Sun Solaris System.
• Experience in using advanced PL/SQL concepts like Bulk Collects, Bulk Binds, Global Temporary Tables, External Tables, REF Cursors and Collections (Nested Tables and VARRAYS).
• Experience in writing Interface and Conversion Programs to import and extract data using PL/SQL, import and export utilities, SQLLDR and External Tables.
• Experience in performance tuning using Explain Plan, SQLTRACE and TKPROF and Built in Packages DBMS_PROFILER and DBMS_SQLTUNE.
• Excellent Interpersonal skills, Analytical, Communication skills and Leadership responsibilities.
• Awarded as Beta Gamma Sigma Inductee, the international honor society for collegiate schools of business for high scholastic achievement.

EDUCATION 
Masters in Management Information Systems 

Technical Skills

RDBMS: SQL Server 2008 R2,2008,2005; Oracle (10g, 9i, 8i,8,7x) TOOLS: SQL Server Management Studio, SQL YOG, PLSQL Developer, SQL * Loader, Oracle Developer, Aqua Data Studio, MS Visual Studio 2003 HP Quality center, Adobe Dreamweaver MX, MS Front page, MS Office, MS project, Microsoft Visio, MS Access, Adobe Fireworks, Adobe Photoshop, UML, XML, XSLT/XPATH PROGRAMMING: SQL,T-SQL, PL/SQL, Java/J2EE (JDBC-ODBC,JAXB, Struts2.0, Hibernate) & JSP, Foxpro, Linux Shell scripting, Batch programming, C, Pro* C , Visual C++, Visual basic, UML WEB APPLICATION SERVER: 10g Oracle Application Server, SQL Server, Tomcat Apache OPERATING SYSTEM: Linux/Unix, Windows 95/98/2000/NT, Sun Solaris System REPORTS: SSRS, Data Reports, Sql* Reports, Framemaker7.2,Crystal Reports 8.0/8.5/9.0, Crystal Enterprise 9.0 GUI’s: Developer 2000 (Forms 4.5/6i/9i/10g, Reports 2.5/6i/10g), Designer 2000/6i, Oracle Enterprise Manager (OEM), SQL*Loader, Export, Import ERP: Oracle Applications11i – Sys Admin, Ebizframe, SAP

PROFESSIONAL EXPERIENCE

Client: Confidential June 2011 to Present Role: Database Developer/Administrator
Responsibilities:

• Normalizing the databases on MS SQL Server 2008 R2 and MYSQL.
• Created E-R diagrams, Data Flow Diagrams and Built Logical and Physical Modules using Designer/ Erwin.
• Undertook Code Optimization and Performance Tuning for the application using Parallelism, Aggregation techniques, Indexing and Partitioning of tables.
• Created Partitioned tables, Views and Indexes on tables for Optimum performance of code.
• Administrating all the SQL jobs, backups and recovery process.
• Performed SQL database upgrades and participated in all the meeting to improve the databases physical and logical design.
• Monitored database server performance and if required tuning the TSQL queries using Query Optimizing Techniques.
• Generated Ad Hoc Reports Using SQL Server Reporting Services (SSRS).
• Developed packages using SSIS for data loading.
• Created Dashboards for the end users to generate their own reports.
• Experienced in DBxtra.
• Creating the dynamic reports(Agents leaderboards-weekly, monthly and year to date, Agent levels, graphs to show the production of the company).
• Experienced in converting the foxpro code to SQL code.

Client: Confidential July 2009 to May 2011 Project: Data Analysis 
Role: Database Analyst
Responsibilities:

• Creating, troubleshooting, and improving routines to extract, transfer and load (ETL) data into client databases and generate reports on data anomalies.
• Data Conversion of non-relational Schema to Relation Schema using Microsoft SQL Server.
• Developed packages using DTS/SSIS for data loading.
• Involved in creation of data warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Created E-R diagrams, Data Flow Diagrams and Built Logical and Physical Modules using Designer/ Erwin.
• Creating Tables, synonyms and views using DDL statements.
• Examining all incoming data for anomalies and make corrections as needed before appending to the RMS/client database.
• Experienced in Query Optimizing techniques.
• Preparing Validation Ad hoc Report and Compared Ad hoc Report.
• Developed T-SQL Packages to do the business validation and data validation before loading data into Main tables.
• Developed Ad Hoc Reports Using SQL Queries.
• Undertook Code Optimization and Performance Tuning for the application using Parallelism, Aggregation techniques, Indexing and Partitioning of tables.
• Performance tuned SQL statements using Explain Plan and Analyzed events using SQLTRACE and profiled trace files using TKPROF.
• Created Partitioned tables, Views and Indexes on tables for Optimum performance of code.
• Developed Report scheduling, Report bursting and Page streaming etc.
• Reviewing and analyzing client data and assist in integrating the data into the RMS system.
• Preparing preliminary data analysis and post revenue report analysis for client reports.
• Worked on the Data Access Layer of the n-tiered architecture.
• Developed web forms using C# and ASP.NET.
• Developed console applications for user authentication and file transfer.
• Handled production issues and enhancement to existing live portals.
• Used XPath, XmlNode to access files and to synchronize with datasets.
• Assisting Consultants and Analysts with SQL Query writing, ad hoc data extraction and template creation.
• Setting up the new clients so as to match the company standardized analysis.
• Developed the Unit Test plans, created the scripts and executed Test cases by loading bulk data.

Client: Confidential Dec 2007 to Jun 2009 Project: TRIALNET, RDCRN 
Role: Oracle Database Analyst and Quality Assurance Analyst 
Responsibilities:

• Involved in understanding the domain functionality to provide the clear picture for Development using Oracle database.
• Data Conversion of non relational Schema to Relation Schema using Oracle 9i.
• Maintained databases using Oracle and ensured accuracy of information.
• Developed data load scripts – control files to load data into Oracle database using SQL*Loader and External Tables.
• Developed data mappings between source systems and warehouse components using mapping Designer.
• Maintained back-end Database and integrity of all test scripts.
• Created Tables, synonyms and views using DDL for different Projects.
• Involved in developing Business Logic for developing different interface application aims using PL/SQL.
• Used AutoSys as Job scheduler tool for scheduling jobs.
• Prepared documentation such as functional, technical, unit test plan and System Interface agreement documents.
• Migrated production database from Oracle9i to Oracle 10g and Created schemas and table spaces for TRIALNET project.
• Troubleshooting errors by interacting with the developers, writing SQL and PLSQL scripts, and stored procedures.
• Developed Ad Hoc Reports Using SQL queries.
• Participated in the Production Support for resolving various patient diabetic issues.
• Prepared system architecture diagrams, data flow diagrams and user interface details for TRIALNET and RDCRN.
• Regular monitoring of mandatory BACKGROUND PROCESSES to avoid downtimes.
• Used SQL*Plus for command line interface, used SQL* Navigator.
• Good experience on UNIX and writing UNIX shell scripts.
• Performance tuned SQL statements using Explain Plan and Analyzed events using SQLTRACE and profiled trace files using TKPROF.
• Created Partitioned tables and Materialized view and Indexes on tables for Optimum performance of code.
• Analyzed indexes and tables using DBMS_STATS and DBMS_ANALYZE.
• Involved in the creation of tables by using all SQL constraints and data types like Blob, varrays etc.
• Used inheritance, polymorphism, Encapsulation and oops conceptson Oracle environment.
• Developed, implemented, maintained, and enhanced test plans and test scripts and executed test cases to ensure exhaustive testing of all assigned software systems and ensure compliance with system specifications using HP Quality Center.

Client: Confidential Aug 2006 to Dec 2007 Role: System Administrator
Responsibilities:

• Created and maintained Engineering email accounts by providing the right space for each individual student in USF Engineering department.
• Good experience on server maintenance and troubleshooting.
• Experience in setting up the server, monitoring the load on servers.
• Applied patches and cloning when required.
• Maintained computer labs at USF engineering department.
• Maintained UNIX accounts for all the research associates in the department.
• Provided technical assistance to students and faculty in maintaining their UNIX accounts.
• Maintained USF Engineering website using MS Front Page.

CURRICULUM PROJECTS EXPERIENCE 

Project: e_HelpDesk 
Responsibilities:

• Implemented complete help desk solution for small to medium sized businesses and organizations.
• Deployed the system as a cost-effective hosted solution and mainly aimed at providing services to a college or university.
• Developed a system which is complete browser based secure password protected control center thereby allowing better communication between the user and support team.
• Implemented application using SQL, Java.

Project: Student Registration System 
Responsibilities:

• Designed Student Registration System using the Aqua Data Studio.
• Developed the system with three main entities: Student, Faculty and Courses.
• The tasks included requirements analysis, logical database design, and physical database design which included many features like capacity planning, tablespace management, file-system management.
• Exposed me to the database organization for a huge system that met all the requirements needed for a successful registration system.
• Monitored users and their actions to database.
• Maintained backups of databases as per the strategy.
• Implemented Integrity Constraints and used SQL (DDL, DML) scripts for data generation, data modification and loading.
• Worked on Performance Tuning using indexing, partitioning and parallel processing.
• Performance tuned SQL statements using Explain Plan and Analyzed events using SQLTRACE and profiled trace files using TKPROF.
• Created Materialized view on tables for Optimum performance of code.
• Analyzed indexes and tables using DBMS_STATS and DBMS_ANALYZE.

Project: Data Warehousing (Confidential) 
Responsibilities:

• Involved in understanding the domain functionality to provide the clear picture for Development using database Oracle.
• Data Conversion of non relational Schema to Relation Schema using Oracle 10g.
• Developed data load scripts – control files to load data into Oracle database using SQL*Loader and External Tables.
• Developed data mappings between source systems and warehouse components using mapping Designer.
• Involved in creation of data warehouse database (Physical Model, Logical Model) using Erwin data modeling tool.
• Created E-R diagrams, Data Flow Diagrams and Built Logical and Physical Modules using Designer/ Erwin.
• Implemented partitioning, indexing, aggregation, parallelism and executed complex queries on the data warehouse based on Sinkhole and Rainfall data.
• Analyzed the relation between Rainfall, Sinkholes and population using Oracle Discoverer.

Project: Click Stream Data and Online Marketing (Data Mining)
Responsibilities:

• Participated in Google online Marketing Challenge 2009.
• Identified a local company and performed marketing campaign for them, provided interim reports and submitted final documentation.
• Exposed me to different marketing strategies.

Project: Business Process Management 
Responsibilities:

• Involved in organizational changes to company’s business process which was in need of process improvement.
• Implemented new business process with the required change.
• Created two process models as-is and to-be using BPMN 1.0 notation.
• Implemented it using functions within an ERP system like SAP.
• Submitted the analysis report with the required change and how certain attributes vary such as Material management, financial management, and risk management.

Project: Information Security and Risk Management 
Responsibilities:

• Implemented firewalls on individual servers.
• Installed and maintained network scanners for having a secured network zone.
• Implemented UNIX and Windows STIGs procedures on individual accounts.
• Implemented and documented COBIT 4.0 processes.

Project: Industry Data Center Relocation (Project Management) 
Responsibilities:

• Exposed to Business process analysis during BAO & G organization data center relocation and merger.
• Implemented in-detail analysis and study of the industry with the development of Project charter, baseline plan, execution and control plan, and finally the Project closure chiefly using Microsoft Project Planner.
• Analyzed and submitted a complete report on PMBOK effects for each individual development.
• Exposed me to great role play as a team member and communication skills by working as a group.