DIPTI PATEL
PARTLAND, OR 97267
SUMMARY OF EXPERIENCE
. Proficient in SQL procedures, database maintenance, tuning and
load balancing, DTS Packages, Triggers and DBA skills with SSIS in
SQL server 2000/2007.Advanced extensible reporting skills using
SQL Server Reporting Services (SSRS)
. Expertise in full project life cycle development for
implementation and integration.
. Experience in Designing and implementing dynamic image rendering
web service which is consumed by PHP and MYSQL.
. Strong experience of analysis, design, program development, system
test, integration test, installation and preparation of user and
system documentation
. Four years of engineering in software field involves basic
knowledge of Computer networking, database structure, database
system,System, programming language
. Preparing data set and research tools by using Oracle PL/SQL,
Oracle discoverer, and Crystal Report.
. Designed the data modeling for the .net applications of new
projects and reviewed high and low level designs.
. Data warehousing experience with collecting and organizing data so
it can easily analyzed, extracted, synthesized. Also keeping
Operational and transactional Information stored in Database to
favor efficient data analysis and reporting.
. Oracle 9i and Database Architecture expert in a project dedicated
to the design and implementation using .NET technology.
. Experience of working and creating dynamic and interactive Web
Pages using WPF graphical subsystem and scripts using ASP. Net and
XML.
. Experience in ETL data integration / migration / data quality
/data backups/data normalization /data modeling/data tuning and
creation of database device logical and physical design of the
database.
TECHNICAL SUMMARY
Project Role: Software Engineer
Language: Visual Basic 6.0, VB.NET, C#.Net,
Visual Studio, PHP, Basic C, XML, HTML,
Basic C++
Database: Oracle9i/10g, SQL Server 2005, Sybase, MS
Access, MS SQL, SQL Server, MS SQL Server
Operating System: Windows, DOS, Linux, WCF
Tools:
Reporting tools: Oracle Discoverer, Crystal
Reports, MS
Access
Data analysis tools: Oracle Data Mining, Oracle
Text Mining
EDUCATION
Degree: Bachelor's Degree in Computer Science and
Engineering
(Amravati University, India 2000-2003)
Advanced VB.Net and C# Programming
(Portland Community College 2005-2006)
Certification: Oracle 9i certified
PROFESSIONAL EXPERIENCE
. Verification Engineer (Portland, OR)
Company: Intel (Currently Employer)
Environment: SQL Server, Microsoft Excel,HP Quality Center
WEBUI, SSRS
Job Duties:
. Develop and execute system test procedures
. Document and report findings and status
. Develop automation to test the system
. Working with SSRS Reporting to deploy health care reports
form patients using PHS(Physical Healthcare System)
. Installation, enhancement, automation and maintenance of SW
configuration management tools
. Analyzed test results and defect data. Created test cases.
Defined system test benches. Developed procedures,
qualification test procedures, specifications and test
procedures
. Implement and execute test cases using HP Quality Center to
verify data on HCMS (HealthCareManagementService) and PHS and
documented the test results.\
. Developed and Modify SQL Server Stored Procedure to bulk
Insert Patient Data
. Responsible for running and modify AUTOIT Scripts on PHS
device to enter Measurement for patients.
. Sr.BI Analyst / Web Developer (Portland, OR)
Company: Lease Dimensions (April 2007- April 2009)
Environment: SQL Server 2005/2008, PHP,
Sybase, C#, Oracle, HTML, SSRS
Job Duties:
. Developed custom SQL utilities to recreate customer problem
scenarios on a variety of platforms and databases to enable
rapid root cause identification and resolution. Creating
Stored Procedures, views, Packages in Oracle and SQL Server
2005/2008 to run daily Transaction for Hyundai Company
. Data Mining. Creating stored procedure to run daily
transaction. Implementing
data from
Sybase to file format in C# programming Language
. Working with web services, by creating a common programming
standard, that enhance programming productivity to work with
different types of clients.
. Creating web based reports in PHP to view data in MYSQL on
client side. Web redesign and maintenance using HTML
. Created SSIS packages for data Importing, Cleansing, and
Parsing etc. Extracted, cleaned and validated. Advanced
extensible reporting skills using SQL Server Reporting
Services (SSRS)
. Using T_SQL accessing and processing functions, procedures
and controlling errors and exceptions. Maintained create/
alter/ drop/ grant/ revoke DB2 objects.
. Executing DB2 reports/ utilities for performance/ database
organization & database growth analysis.
. Participated in the testing of the software for the Content
Management System to ensure the highest level of quality for
managing all phases of testing for assigned components
ensuring test plans and test cases are completed and met
business requirements
. Developed and executed SQL ad hoc queries with Group by,
Order By and different types of Joins to retrieve system and
application metrics and troubleshoot reported problems.
Designed and developed PL/SQL stored procedures, complex
queries to integrate .NET framework and security solutions
with the database layer.
. System Analyst (Portland, OR)
Company: Signature Graphics (June 2006- April 2007)
Environment: SQL Server 2005, VB.Net, ASP, C#, MS Access, T-
SQL
Job Duties:
. Data Mining, Data Warehousing, Creating Stored Procedures,
Views, Triggers, reports. Designed, developed, and
implemented SQL scripts, and Sync Sort scripts to automate
the loading of SQL and Sync Sort customer data into
databases.
. Develop front-end applications Script Writing in VB. Net and
ASP to convert data from flat file to Table Format.
. Responsible for designing and implementing system modules and
data parsing using C# Programming. Responsible for supporting
existing VB. Net and ASP (vb-script) code base. Port of
existing code and all future development to be performed
using C# with .Net programming.
. Maintaining Profiles in MS-Access to create and manage
databases.
. Work with Linked Servers with SQL and Oracle Database to load
data from remote servers and flat files
. Develop complex queries and stored procedure in T-SQL.
. Writing Data centric Programs to manipulate data in database
using PL/SQL block
. Working with PL/SQL to execute procedural code with
conditional, iterative and sequential statements. Upgraded
the Oracle database environment to higher Oracle database
version levels.
. Dimensional Data Modeling and Cube development in SQL Server
Analysis Services (SSAS)
. Migrating Data from MS Access to Sybase using .Net
Programming Language
. Extract Transform Load (ETL) development using SQL Server
Integration Services (SSIS)
. QA Engineer (INDIA)
Company: Govt. Office of Maharashtra (OMS) (Jan 2004- Feb
2005)
Main Project: GIS (Geographical Information System)
Environment: VB.Net.DB2,SQL,SSRS,PL/SQL Crystal Reports, Oracle
Job Duties
. Primary responsibilities included: migration of database,
table spaces, tables, indexes, foreign keys, and production
data; porting of over 200 functions, triggers, and stored
procedures; installing and configuring DB2 Information
Integrator v8.2.2; establishing federated database table
access and user defined function mappings from DB2 UDB to
Sybase SQL Anywhere.
. Designed and reviewed VB. Net application architecture;
analyzed software development process and suggested
alternative technologies
. Using Oracle and PL/SQL Database in Project maintaining and
developing data information, creating views to view data as
report online.
. Deploying and scheduling Reports using SSRS to generate all
daily, weekly, monthly and quarterly Reports including
current status.DB2 reporting, Database tuning, Backup &
recovery procedures, Execution of DB2 utilities.
. Working with N-Tire Application to document and design
project with algorithmic chart to explain contents to users
and clients.
. Creating stored procedures, package, cursors and also for
handing exceptions in database using SQL Server. Supported
ETL process of Projects to provide better model and
structure of database system.ETL Development using DTS
packages and importing SAP data into database
. Creating online web pages using Crystal report tools to
display information about county as reports by pulling data
from various data structures. Designed and implemented all
internal and client solutions by using reporting packages
like crystal report, SQL server 2005.
. Implement the use of standard templates to create up-to-date
SDLC documents Reviewed and adjusted deliverables involved
during SDLC involving database changes/development. Using DTS
package to access data from Microsoft Access and also from
Flat (.txt file)
. Project Coordinator
Company: SSI (India) (Oct 2003- Jan 2004)
Main Project: SUPERMARKET
Environment: Visual Basic 6.0, C#, Oracle, MS Access, Crystal
Reports.
Job Duties:
. Developing Team management in the implementation of changes
and additional features in the application and databases.
Reviewed and optimized SQL queries, stored procedures, views
and triggers from other developers to achieve maximum
efficiency and scalability
. Defining requirements, analyze existing system, and find a
package, conversion and customization mainly in the Foreign
exchange and precious metals modules, Data Modeling, Database
Design.
. Using Visual Studio tools for office which allows building
applications based on the Microsoft Office System and also
for web based applications as project is using VB6 and .Net
framework for front end.
. Working with C# .Net to write front end code to meet user's
requirements.
. Using Crystal report tool to create, design and present
reports for Daily, monthly, yearly sale transaction, Tax
Calculation, Total sale and Gross calculations.
. Working with N-Tire Application to demonstrate project
requirement in different phases e.g. Presentation Layer which
gather all information required for the projects from
customer and vendors, Business Logic Layer which is
responsible for coding and debugging code and Data Layer
where data is used by the system.
. Developing ETL Packages to design and meet project
requirements
. Created user define functions in SSRS using VB script
Role: Worked in full SDLC Phase to complete project.