sql developer

Pradeep Narayanamurthy

Mobile: 812-***-****

*******.**************@*****.***

Experience Summary

• 5 years of experience in Data Base Design, Application Development and Architecture in Client/Server Environment using SQL.

• Good knowledge of Software Development Life cycle (SDLC) process and Software testing Life cycle process. Extensively involved in preparation/execution of test scenarios, test plan, and test cases.

• Knowledge of the database architecture, backup and recovery, database performance tuning, database migration.

• Good working knowledge on UNIX.

• Proficient in programming with C, C++, VB, Java, JSP.

• Good communication and interpersonal skills with good analytic power.

• Team player with excellent communication skills, committed and open approach and ability to play an effective role in any team.

• Good management and team handling ability.

• Support developed code, debug and document software.

• Maintain and support programs/tools for internal and external clients.

• Provide level 3 and above operational and customer support.

• Serve as contact point for all the production issues of software systems / applications.

• Supported for 24 X 7 “on-call” to respond to emergencies and support.

• Troubleshoot and resolve issues of software system / applications in production / testing / development environments.

• Proactively identifying areas of risk and recommending solutions to eliminate or minimize them.

• Escalation of incidents to development team(s). Recommend priorities for resolution of escalated incidents. Monitor for status and resolution.

• Administration, monitoring, supporting, configuration and change management of software System/applications.

• Planning, implementing and supporting of software delivery / deployment / release from development environment to testing environment (QA) and from testing environment (QA) to production environment in a distributed environment.

• Plan and implement application support packages and version upgrades.

• Lead and/or participate in conference calls and meetings related to technical issues.

• Generate weekly, monthly, quarterly and yearly Summary and Trend reports.

• Assist, train and mentor users (internal/external), members of the technical/production support and client services or customer support teams.

• Assist in defining project plans requiring software development and hardware installations.

• Assist in capacity planning.

• Analyze business operations and processes to understand their relationships.

• Software system / applications testing and re-engineering to improving quality, performance, availability, stability and reliability.

• Assist software development team(s) and QA team(s) for developing, maintaining, testing, and delivering the products as per the client/user requirements and system/applications monitoring tools for system availability, stability and performance.

Onsite Experience – Overseas

1. Worked in Cummins Inc, Indiana, US.

2. Working in Bank of America, Charlotte, NC, US.

Qualifications

• M.S (Computer Science and Engineering) from 2003 - 2005

• B.S (Computer Science and Engineering) from 1999 – 2003

Professional Memberships / Certifications

Professional Society / Certification Member Since / Date Certified

Appreciation Award Cummins Inc

Technology

Software Products

Languages known C, C++, CQCS

Java Technologies Java 1.2, JSP, Servlets, JDBC.

Microsoft Technologies VB , ASP , .NET, SQL Server 2000/2005

Application Servers Web logic 6.0., IBM websphere5.0. 6.1

Databases/Database Tools Oracle 9i, TOAD and PL/SQL Developer, SQL assistant

Web Technologies Java Script, HTML

Operating Systems Windows XP and WIN 2003, Unix, DOS, Windows NT.

Tools

Version Tools VSS, Clear Case

Reporting Tools Clear Quest , Remedy , Service Centre

Testing Tools Load runner 8.1.

PROJECTS:

Project Title INFOCENTRE

Customer Bank of America, Charlotte,NC, US

Role SQL Developer / ETL Analysts / Reports Developer

Period Jan 2009 to Feb 2010

Description:

InfoCentre is a powerful information management tool that allows users to gain control of vast quantities of data and significantly improve the decision-making process. InfoCentre can provide student loan organizations with valuable portfolio analysis information including loan volume trends, delinquency and default rates, school type mix, static pool reporting, and countless other types of reports that are needed to manage a student loan portfolio. InfoCentre provides a central repository point for all of the loans serviced. InfoCentre provides Data Warehousing for Student Loans originated for and by Bank of America and are currently being externally serviced.

Responsibilities:

 Based on business requirement, developed the SQL queries and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.

 Designed the logical and physical model architecture for database using Erwin.

 Interacted directly with the various SME for gathering the business requirements.

 Convert data from Legacy system to SQL Database.

 Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

 Prepared the complete data mapping for all the migrated jobs.

 Data Migration from Flat files, MS-Access, Excel, OLE DB to SQL Database.

 Created /modified and maintained the ETL packages- Extraction, Transformation and Loading of data from various Database tables i.e., from Source Tables to Mapping the Target table in respective databases.

 Collected data from Various Heterogeneous database/files like MS SQL, ORACLE, Flat File, MS Access, EXCEL sheets, CSV format and used complex data conversion to target.

 Writing SQL Queries on SQL Assistant according to the process needs.

 Scheduling and monitoring the ETL packages for daily load.

 Created Stored Procedure and Triggers to enforce business rules.

 Involved in Query optimization, performance tuning and index creation.

 Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

 Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

 Developed SQL Server Business Intelligence Development Studio using SSRS and SSAS

 Developing and designing Cubes using SSAS

 Developed reports using SSRS and published as PDF, Excel, and CSV formats.

 Generated Reports using Excel spreadsheets.

 Database Backup and restoring the database from one server to other.

 Worked in Database Security, Replication, and Log shipping activities.

 Validating and testing of the codes and application (White box and Black box)

 Prepared Documentation of the system.

Environment: SQL Server 2000/2005/2008, SSIS, SSRS, NET, XML, SQL Assistant,

WIN2000/XP, WSFTP, Visual Source Safe.

Project Title Student Online Loan Application Rewrite (SOLAR)

Customer Bank of America, Charlotte,NC, US

Role SQL Developer

Period Jan 2009 to Feb 2010

Description:

SOLAR application that allows students to apply for school loans directly with the bank or through an integrated site from the school site to the bank site. A typical school works with their selected group of lenders to provide loans to students. Based on specific requirements of the institution, loan requests may be processed either from the school directly to the lender, via a pre-established loan originator, or require that a student / guardian process directly with the lender. The area of focus within the SOLAR project deals directly with the online aspect of borrowers (student / guardian) working with Bank of America directly. SOLAR Application redirects the loan request to experience site for Loan processing and disburse loan amount to the student or cancel the loan application after their credit verification and validation.

Responsibilities:

 Actively involved in creation of database, modified tables, triggers, procedures to clean and validate the data about the cable layout, so as to meet the company specifications.

 Design, Developed and Maintenance of the Databases like MS Access, SQL Server.

 Data transformation activities using DTS Import/Export for transferring data between different databases like Oracle. Design new DTS Packages as per needs, resolve problems with existing DTS packages etc.

 Incorporating business logic in DTS while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the stored procedures for automatic scripting to backup transaction logs, flush/grow/shrink log files, maintain archive of objects and so on

 Design a MS Access forms for users to enter the data.

 Generation of Reports using Excel report.

 Wrote Macros and VBA for Excel report.

 Ensured constraints and writing triggers to apply the business rules. Performance Tuning, Backing Up & restoring user databases.

 Created different user level groups, and assigned appropriate permission level to the database.

 Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.

 Created E-R Diagram.

Environment: SQL Server 2000/2005, SSIS, SSRS, .NET, XML, SQL Assistant, WIN2000/XP, WSFTP, Visual Source Safe.

Project Title AppWorks

Customer Bank of America, Charlotte,NC, US

Role SQL Developer

Period Jan 2009 to Feb 2010

Description:

AppWorks is a loan origination system for federal loans. This is a vendor driven application and not a BOA originated system. This is a client/server application using multiple tiers for security and performance. Appworks is a tool used by greater part of the diverse groups of student lending like the Loan origination, Credit Decision, Client Support, Compliance group who process the Loan application through its various stages. It helps users to draw diverse consultations on the state of the loan, i.e. if it has passed to credit, disbursement state etc. Diverse reports and letters are generated through batch processes and user requests during the life-cycle of the loan application. The SmartBatch application helps to monitor the batch jobs running in the Appworks server. These jobs are initiated by the states of the loan application. It can be used to remove or reinitiate the jobs. In the SmartBatch applications there are many procedures that can be maintained..

Responsibilities:

 Based on business requirement, developed the SQL queries and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.

 Interacted directly with the various SME for gathering the business requirements.

 Convert data from Legacy system to SQL Database.

 Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

 Prepared the complete data mapping for all the migrated jobs.

 Data Migration from Flat files, MS-Access, Excel to SQL Database.

 Created /modified and maintained the ETL packages- Extraction, Transformation and Loading of data from various Database tables i.e., from Source Tables to Mapping the Target table in respective databases.

 Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat File, Access, Sybase, EXCEL sheets, CSV format and used complex data conversion to target.

 Exporting the data from SQL DB using Export Utility.

 Writing SQL Queries on SQL Assistant according to the process needs.

 Scheduling and monitoring the ETL packages for daily load.

 Created Stored Procedure and Triggers to enforce business rules.

 Involved in Query optimization, performance tuning and index creation.

 Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

 Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

 Developed SQL Server Business Intelligence Development Studio using SSRS and SSAS

 Developing and designing Cubes using SSAS

 Developed reports using SSRS and published as PDF, Excel, and CSV formats.

 Generated Reports using Excel spreadsheets/ Pivot tables.

 Database Backup and restoring the database from one server to other.

 Worked in Database Security, Replication, Log Shipping activities.

 Validating and testing of the codes and application (White box and Black box)

 Prepared Documentation of the system.

Environment: SQL Server 2000/2005/2008, SSIS, SSRS, MS-Access, .NET, Visio, XML, TOAD, WIN2000/XP, SFTP, VBScript, Visual Source Safe.

Project Title BASLS

Customer Bank of America, Charlotte,NC, US

Role SQL Developer

Period Jan 2009 to Feb 2010

Description:

The Bank of America Student Lending System (BASLS) currently is operating on a Data General MV/25000 and utilizes the Advanced Operating System/Virtual Storage. The operating system manages batch and on-line user sessions, which are called processes; memory usage; and filing system structures. The BASLS system originates Alternative Student Loans to borrowers in financial need. These Alternative (or Private) loans are available for undergraduate and graduate students; each with specific terms depending on School Tier, Product Type and the need of a co-applicant

Responsibilities:

 Design and Developed SQL queries, T-SQL as per the business user requirements to implementing business rules and transformations.

 Interacted directly with the business analysts for gathering the requirements.

 Involved in designing of Data modeling the logical and physical architecture for database.

 Convert data from Legacy system to SQL Database.

 Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

 Analyzing the performance of the jobs and project and enhance the performance using the standard performance-tuning techniques to improve the ETL process.

 Prepared the complete data mapping for all the migrated jobs.

 Created Stored Procedure and Triggers to enforce business rules.

 Collected data from Various Heterogeneous database/files like MS SQL, ORACLE, Flat File, Access, EXCEL sheets, CSV format and used complex data conversion to target.

 Writing SQL Queries on SQL Assistant according to the process needs.

 Writing SQL on DB2 to check the data format.

 Developed SQL Server Business Intelligence Development Studio using SSRS and SSAS

 Developing and designing Cubes using SSAS

 Generated Reports using Excel spreadsheets / Pivot tables

 Used TOAD to run SQL code to manipulate the databases in all environments.

 Development and support on .NET application and issues.

 Prepared Unit test cases and participated in unit testing.

 Prepared system test cases and participated in system testing.

 Writing UNIX shell script and Cron Jobs to scheduling and monitoring the jobs.

 Wrote Shell scripts for automating the process of data loading.

 Code Testing/Validating of DB and applications (White box, Black box)

 Documentation of the system.

Environment: SQL Server 2000/2005, Oracle9i, DG, Ms Access , VMware, Java, Java Script, VBScript, .NET, XML, TOAD, WIN2000/XP, UNIX

Project Title Smart Power Enterprise wide Electronic Distribution

Customer Cummins Inc, Indianapolis, IN, US

Role SQL Developer

Period Apr 2006 to Dec 2008

Responsibilities:

 Was part of the team in designing this data model

 Used DTS jobs for importing data from legacy systems to the current model.

 Developed all the required stored procedures, user defined functions, triggers using T-SQL.

 Used sql server 2000/2005 reporting services for generating reports

 Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.

 Involved in performing Extraction, Transformation and Loading using DTS.

 Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility

 Used “SQLProfilerTSQL_Duration” template for tracking execution time of TSQL Statements.

 Development and implementation of Backup and Recovery strategies

 Optimized the performance of queries with modifications in T-SQL queries,removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.

 Involved as a team member in designing this data model.

 Planned a complete backup on the database and restored database from disaster recovery..

 Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.

Environment: SQL Server 2000 / 2005,Reporting Services, Oracle9i,Windows Server 2003, Windows XP, C#, ASP.NET, JavaScript, XML.

Project Title New Product Introduction (NPID )

Customer Cummins Inc, Indianapolis, IN, US

Role SQL Developer

Period Oct 2005 to Mar 2006

Description:

Cummins Engine Company (CECO) which is in the business of manufacturing engines has been using the current Electronic Software Distribution System (ESDN) set of systems for loading electronic software into Electronic Control Modules of diesel engines within Cummins to develop, release, store and distributes electronic control software for diesel engines. Historically, the ESDN system has only been used for the storage and distribution of electronic engine control software files. As Cummins continues to develop information products to help end-users of diesel engines to monitor and log critical information about engine performance and operation, it is important to automate and maintain the ESDN system support (tools), storage and distribution system of Cummins information products. The ESDN mainframe system needs to be modified considerably for every new ECM product designed for diesel engines.

Responsibilities:

 Created reports using SQL Server

 Used DTS to transfer files from Excel datasheets to SQL server database

 Developed scorecards for the system using SQL Server reporting services.

 Took part in data normalization process along with senior data base analyst.

 Used SharePoint enterprise portal for hosting all the scorecards and reports.

 Creation, manipulation and supporting the SQL Server Database

 Designed and optimized indexes, views, stored procedures and functions using

T-SQL

 Writing database triggers, procedures, packages for applications

 Performed Database Normalization

 Handling database objects with Enterprise Manager and Query Analyzer

 Prepared test reports and bug logs for the testing done.

 Provide support to design/break fix issues in SQL Server 2000 and track to a closure.

 Status reporting to Sr. Management

 Involved in data migration and data integration

 Developed stored procedures, triggers and functions and added/changed tables for

data extraction, transformation and loading

 Tested and configured automated routine maintenance tasks like performance

tuning, indexes and stores procedures, checked deadlocks and created Scheduled

jobs.

Environment: Windows XP, ASP.NET, SQL Server 2000, JavaScript.

Contact this candidate