Sharmistha Khan

Contact: 334-***-****

Email: acvuxj@r.postjobfree.com

***** ** **** ** *, Houston, TX 77065

PROFESSIONAL SUMMARY

• Around 3 years of experience in Application Development using Oracle SQL, PL/SQL, Developer Forms and Reports.

• Hands on professional IT Experience in Analysis, Design & Development, Testing, Bug Fixing and Deployment in Web based and Windows Applications using Microsoft Technologies and various database (Oracle, MySQL, Microsoft SQL Server).

• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyse business requirements and translating requirements to functional and technical design specifications.

• Excellent conceptual knowledge of Oracle 9i/10g/11g, PL/SQL and SQL.

• Experience in Database design using Normalization and E/R Diagrams.

• Rich experience in writing SQL queries, Views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, system reference cursor, Dynamic SQL.

• Experience in developing External Tables, Joins, Indexes and sequences.

• Good knowledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

• Good knowledge in front end development using oracle forms/reports6i/9i/10g.

• Experience in developing forms based on views, tables and procedures in tabular and form layouts.

• Experience in developing both web layout and paper lay out reports in various styles based on the user requirements.

• Extensive experience in developing various applications using Visual Studio.NET technologies like C#, ASP.NET, ADO.NET, XML, CSS.

• Experience in designing and developing Databases in Oracle 9i/10g, SQL Server 2008/2012 which includes the development of functions, stored procedures and triggers

• Good working experience with different SDLC methodologies such as Agile and Waterfall model with an ability to be creative.

• Expertise in Object Oriented concepts in C#.

• Strong knowledge of Design Patterns and the UML methodology.

• Excellent communication, interpersonal and analytical skills that balance work, team support and responsibilities in timely and professional manner.

• Ability to learn quickly and adapt to new technologies. TECHNICAL SKILLS

Languages: C# 4.5/4.0/3.0, C, C++, Java, PL/SQL

Web Technology: ASP.NET, ADO.NET, HTML, XML, JavaScript, and CSS Database: Oracle 9i/10g, SQL Server 2012/2008, MySQL IDE: Microsoft Visual Studio 2008/2010/2012

Tools: SQL Developer, SQL Navigator, SQL plus, MS Office and MS Visio, TOAD.

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g

Framework

methodology:

Microsoft Entity Framework, LINQ to SQL, LINQ to Objects, LINQ to Entity, Design patterns

PROFESSIONAL EXPERIENCE

Segnatek Engineering June 2015- till now

SQL Developer

Project: Inventory Management system

The Inventory Management System is a real-time inventory database for this organization to track the inventory or to manage the distribution of stock for each project those are ongoing in different client’s end. The system records sales and restocking data, provides notification of low stock at any location through email at a specified interval, generates different types of reports according to the clients requirements. The main three features includes: the first feature allows the Stock Manager to view the current stock of products along with the capabilities of searching and sorting the products, the second feature allow the user to modify application settings, such as the threshold for email notifications, frequency of inventory and security settings, and the third feature allow the user to update the inventory during the restocking process. Responsibilities:

Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.

Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.

Co-ordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Implemented complex business logic as per the client requirement in procedures, functions, packages.

Involved in data modeling team for identifying tables and relations between them.

Built complex queries using SQL and wrote stored procedures using PL/SQL.

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Created database objects like tables, views, Indexes on tables, synonyms, materialized views, Stored procedures, packages using oracle tools like SQL* plus.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.

Applied constraints and writing triggers to apply the business rules.

Involved in handling errors and transaction processing in the procedures.

Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.

Designed and developed various reports using Oracle Reports as per requirements.

Managed problems, enhancement, and new functionality requests to meet changes in the business needs.

Prepared the necessary documentation and design specifications of project. Environment: Oracle 9i/10g, SQL, PL/SQL, TOAD, Developer 2000 (Forms 10g, Reports 10g), XML, HTML.

Prairie View A&M University July 2014 – May 2015

Software Developer

Project: Student Information System

This Student Information System project is a web based application for the Department of Engineering to manage student data. The project is mainly use for recruiting, records, class register, student productivity report, degree audit, and self-service for faculty/staff and students. Responsibilities:

Involved in understanding user requirements, designing and developing web application and desktop based applications.

Interacted with business analysts, end users and worked on the application specifications to develop detailed functional, technical design, and test specifications that fully satisfy business requirements.

Involved in database design, creation and fine tuning of database objects.

Involved in data modeling team for identifying tables and relations between them.

Built complex queries using SQL and wrote stored procedures using PL/SQL

Involved in development of interface programs to import parts information to inventory base tables.

Designed and developed user interface for web application and intranet application using Visual Studio 2010, ASP.NET, C #.NET, JavaScript, XML and CSS with object oriented programming techniques.

Worked on designing, coding, testing and maintaining database objects, tables, functions, procedures, indexes, and triggers using Oracle 9i/10g, PL/SQL.

Created stored procedures and functions to support efficient data storage and manipulation.

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Used various items like tables, sub report and charts to develop standard and customized Oracle Forms and Reports.

Developed Master Detail reports in Reports 6i to meet the requirements of end users within the system.

Used Ado.Net objects such as Data Adapter, Dataset, Data Reader, and Data View to retrieve and manipulate data and display it in an ASP.NET page. Environment: .NET Framework 4.0/4.5, Visual Studio 2012/2013, SQL Server 2012, ASP.NET, WCF, HTTP, Oracle 9i/10g, ADO.NET, C#, HTML, CSS, JavaScript.

BRAC Bank Limited,

It Department, June 2007 – Jul 2008

Software Developer

Project: Customer Management System (CMS)

CMS is developed for BRAC Bank which is one of the largest private bank in Bangladesh. I have worked on their OMNIBUS ATM Network. OMNIBUS is a nation’s first ever neutral “Inter Banking Switching System”. CMS is a highly customizable and scalable Online Customer Management System. The system contained the features like the user management, document management, different disputed case management, indexing, searching and was targeted for internal users of this banking network.

Responsibilities:

Experienced in all phases of SDLC which Involves Project Planning, Analysis, Design, Documentation, Development, implementation and support of software applications.

Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

Experienced in Database Designing and Database Programming (Created Tables, Stored procedures, Triggers, Cursors, PL/SQL, SQL) using Oracle 9i, SQL Server 2005 and MySQL 5.0

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Loaded the data into database tables using SQL*loader from text and excel files.

Developed data model, SQL Queries, SQL Query tuning process and Schemas.

Created SQL*plus reports as per client's various needs, and developed business objects.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Used ADO.NET for database interactions using Data Adapters, Data Reader and Dataset.

Designed GUI (Graphical User Interface) using Layout Pages, HTML, JavaScript, CSS, Custom and User Controls.

Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.

Developed Master Detail, Detail reports using tabular and Group above reports.

Involved in Unit Testing and Integrated Testing

Environment: Oracle 9i, C#.Net, ASP.Net, ADO.NET, SQL Server 2005, DB2, JavaScript, XML, AJAX, CSS,

SQL Server

Business Automation Ltd May 2006 – May 2007

Software Developer

Project: Customer Relationship Management System (CRMS) Customer Relationship Management System (CRMS) is developed for Sanofi Aventis which is one of the biggest multinational pharmaceutical, biologics, vaccines and consumer healthcare company with multiple locations all over the world. This system is a call centre operation for diabetic patients. The system has IVR, voicemail and CRM application. The components are interlinked and integrated for synchronized performance of the helpdesk doctors. When the calls are coming, the doctors are getting a screen pop for the patients, archiving the advice log in the patient history.

Responsibilities:

Gathered the requirements of the clients and the specific needs of the business projects and analysis the requirements for prototyping the design.

Designed, developed and implemented the web based and desktop based applications, based on C#.NET, ASP.Net Technology and Oracle 9i.

Customized the developed applications as per the client specifications.

Used HTML, JavaScript, CSS, and AJAX for developing the user interface (UI) of different web forms.

Backend Programming using Oracle 9i, screen designing using Forms 6i and developing reports using Reports 6i.

Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming

Wrote stored procedures, triggers using SQL in SQL SERVER 2000.

Created LINQ enabled database layer using API such as LINQ to SQL and Entity Framework.

Extensively used ADO.NET objects like Connection, Command, Data Set and Data Reader to communicate with the MS SQL Server Database.

Tested the developed applications using the various tests tools and performance metrics

Debugged the web applications to rectify the errors that surface during the operations

Adhere to the .NET protocols and standards set for developing the applications Environment: .NET Framework 3.0, C#, XML, CSS, ADO.NET, Oracle 9i, SQL Server 2005

EDUCATION

Prairie View A&M University, Prairie View, TX (May 2015) PhD in Electrical Engineering - 4.00/4.00

Tuskegee University, Tuskegee, AL (May 2011)

MS in Electrical Engineering - 3.73/4.00

American International University-Bangladesh (May, 2006) Bachelor in Computer Science - 3.64/4.00

Contact this candidate