OBJECTIVE:

An ambitious problem solver with a passion and who would like to join a team of like - minded developers. I have much experience of creating logical and innovative solutions to complex problems. Right now I am looking for a SQL Database Developer with a company where outstanding performance is recognized and where I can work on a variety of high profile projects.

SUMMARY:

• A logical, analytical thinker with excellent managerial skills possesses 2+ experience as a Database Developer.
• Extensive experience in writing stored procedures, functions and views.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Experience in requirement analysis, coding and testing various modules in a software development life cycle.
• Expertise preparing report specifications and database designs to support reporting requirements.
• Good experience in PL/SQL and ETL scripting and query optimization.
• An in-depth grasp of SQL reporting, analytics and business intelligence.
• Great expertise in processing data and flowcharting techniques.
• Excellent understanding of database structures, principles, theories and practices.
• Conversant with T-SQL coding.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Able to manage all the stages of software development.
• Ability to develop applications in a detail oriented environment.
• Great experience in the Oracle platform especially on SQL standards and Java
• Excellent grasp of data warehousing and such processes as extracting, transforming and loading.

TECHNICAL TOOLBOX:

Reporting Tools: Business Objects, Crystal Reports

Designing Tool: Erwin Data Modeler

Database: Oracle 10g/9i/8i, SQL Server 2005, MS Access

Languages: SQL, PL SQL, Oracle Developer 2000, C, C++, HTML, Java

Operating Systems: Windows95/98/2000/NT, MS DOS, UNIX

Other Tools: TOAD, SQL Loader, SQL Plus, Query Analyzer

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Development of MOCA components for Part Purge Routine Process.
• Customization in the Part Override Maintenance for adding Custom Fields.
• Developing Integrator transaction for Part Creation using Processing Algorithms for Warehouse specific creation.
• Working on Coopervision Tickets.
• Database relations in Warehouse Management system
• MOCA architecture and concepts such as context and transactions, triggers, etc.
• Integration concepts such as Inbound and Outbound communication, Integrator transactions, Events and Interface File Definition.
• Inventory Adjustment cum Cycle Counting on GUI & RF.

Confidential, VA

SQL server database Developer

Responsibilities:

• Analyzed different user requirements and coming up with specifications for the various database applications.
• Developed database applications which are automated.
• Planned and implementing capacity expansion in order to ensure that the company’s databases are scalable.
• Identified issues with the database and resolved them.
• Installed and configured the necessary components so as to ensure that the database is accessible.
• Diagnosed and resolved database access and checked on performance issues
• Created Entity Relationship (ER) Diagrams to the proposed database
• Created database objects such as tables,views, stored procedures, Triggers, Rules etc.
• Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Created functions to provide custom functionality as per the requirements.
• Endured that the code is written keeping in mind any security issues such as SQL Injection.
• Developed reports in SQL Server Reporting Services.
• Designed, Develop and Deploy SSIS Packages.
• Identified and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Participated in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Participated in development and creation of Data warehouses.
• Created cubes in SQL Server Analysis Services.
• Implemented database standards and naming convention for the database objects.

Environment: DEL 6850 Servers, MS SQL Server 2005/2012, T-SQL, DTS, VB.Net, ASP.Net, Visual Source Safe 6.0, Windows 2003 Server and Compuware QA Load test

Confidential

Software Tester

Responsibilities:

• Developed and coordinate test plans.
• Developed relationship with internal operating groups and external customers.
• Managed test environment for integration testing activities.
• Managed testing software scripts.
• Developed functional specifications and new customer report templates for technical Analysis.
• Reviewed Bugs, Assigning the Bugs, Preparing Test Plans and writing Test Cases.
• Functional study of the application, Designing and Execution of Test Cases & prepared Bug Report.
• Coordinating with the client for on time delivery of the build tested.
• Conducted Regular meeting with the Team over project related information sharing and suggestions in improving the team's productivity.