Information Technology Developer

Bijal Modi

***** ******* **** ** 551-***-****

Clarksburg, MD 20871. ac1roz@r.postjobfree.com

Seeking a challenging position in a progressive organization where I can utilize my skills, enhance them and prove to be a valuable asset to the industry.

Summary:

9 years of working experience in software development especially in Oracle and PL/SQL development; interaction with business users; created business design document and technical design document for applications.

Excellent command over SQL, PL/SQL programming in Oracle databases along with writing unit test cases to prove the quality and result as per the business demands.

Good experience on Exception Handling extensively for the ease of debugging and displaying error messages in the application.

Good Knowledge on Data Modeling concepts..

Experienced in a fast-paced diverse environment where multi- tasking is one of the demand.

Excellent experience to prepare the Technical Design Document on the Business requirement basis.

Hands on experience on Materialized views, Query Optimization, debugging and Performance tuning.

Maintained and updated source code using Version control.

Excellent command on I- Report tool to generate reports as Business demands.

Extensive experience in developing stored procedures, Packages, functions, Views and Triggers, Complex queries using SQL and Oracle PL/SQL.

Experience in resolving on-going maintenance issues and bug fixes; monitoring DB logs as well as performance tuning of mappings and sessions

SDLC: 8 years of IT experience in system analysis, design, coding, code-review and testing. Extensive experience in the Oracle Database Development including implementations, Data Migration and ETL for Finance and Tele Domain.

Worked on Oracle collections and bulk operations as part of PL/SQL Tuning.

Good Experience in Pro*c and UNIX shell scripting using Vi Editor.

Experienced working with DB Link to access remote database.

Worked in Migration team for Server Migration along with DB upgrade.

Working Experience in Oracle Forms and preparing the Design document from the Business requirement.

Having some experience with Oracle utilities like SQL*Loader, Export/Import.

Experienced in scheduling jobs using crontab in UNIX environment.

Working Experience on writing Medium to complex sql queries, Packages, Function, Procedure.

Good team player with excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies.

Experience in coding and implementation of integrating applications using Oracle SOA Suite.

Hands on SQL Tuning Experience while dealing with users interface application.

Understanding of ETL process and working experience with data warehouse team closely.

Education:

Master in Electrical Engineering from University of Bridgeport, CT, U.S.A

Certifications:

1Z0-007 Introduction to Oracle SQL 9i.

1Z0-147 Oracle 9i Program with PL/SQL.

Brain bench certified Oracle PL/SQL Developer.

Brain bench certified RDBMS.

Certified in Performance Optimization for developers from Hotsos Enterprises, Ltd.

Professional Experience:

Technogen Inc. Sep ’15 - Till today

Client: Verizon

Technogen supports end to end IT services spanning the enterprise that brings the most value, Innovative service and Flexible Engagement models to its customers.

I am working as a Senior Software developer, supporting existing DB modules and involved in new application DB design and development task.

One of the project goal is to combine data from 4 different systems to one centralized place which involved lot of business and technical analysis.

Responsibilities:

Involved in the analysis of the user requirements and identifying the sources.

Created technical specification documents based on the requirements and explain the same to dev team to meet the deliverables, also doing code-review to make sure we are delivering quality and meeting the expectation.

Involved in the preparation of High level design documents and Low level design documents.

Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.

Prepared UNIX Shell Scripts and these shell scripts will be scheduled in CRON to make data load automated for weather and other modules.

Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.

Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.

Used Analytic functions, Decode, case statement while writing complex SQL queries.

Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.

Exported the database and imported the same into development and test environment whenever required.

Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.

Created Wallet to make sure we don’t use the DB password in readable format anywhere in UNIX.

Modifying Existing DB objects (Procedure, Packages, Materialized Views, and Tables etc.) on Business enhancement Projects and keep the current business running by participating in maintenance of Database.

Playing key role in DB production support to resolve the data issue on daily basis.

Developed various complex and efficient queries to generate various reports to predict business trend.

Created Process to generate Alert Email on critical data load issue and wherever it needs attention.

Developed scripts to create tables, views, Materialized view and also updated millions of rows without locking table through PL/SQL Block with use of bulk collect.

Created Schedulers, Stored procedures, Functions, Packages to provide backend processing using PL/SQL.

Created Indexes and sequences for faster retrieval of data and enhance the database performance.

Handled Oracle errors using Exception Handling extensively for the ease of debugging.

Developed the Data driven code for easy implementation in case of any addition features to the existing application.

Used materialized views to maintain copies of remote database to local node.

Worked in complex queries and do SQL tuning to make sure fast retrieval of dataset.

Set the DB standards while working in new application.

Migrating Procedures from SQL server to ORACLE DB.

Environment: Oracle 11g/10g/9i, SQL Server 2008, UNIX Shell Scripting, TOAD, Jira for Project management, Git Extensions- Stash for version Control

Cognizant Technology Solutions, Feb ’11 - Sep’15

Cognizant is a leading provider of information technology, consulting and business-process outsourcing services.

Cognizant is the first IT services company to organize around vertical industries. Over the years also built expertise that runs broad and deep across almost every major industry so that we can anticipate client requirements and fulfill demand wherever it emerges. I play my role here as an OSP Provider which comes in Horizontal services.

First Data, MD

On Site Team Lead/ Sr. Developer

I am working as a Senior Software developer to facilitate the design and development task, support the production module and also involved in Server Migration project.

Responsibilities:

Prepared the system integration diagram to have documented each interaction with other system.

Attending Business Requirement calls that relevant to our system and understands the TRD.

Working with web services closely to send the requests and pull the Data accordingly.

Reviewing Unit test cases prepared by team members of the requirements.

Playing a developer role by creating and modifying Existing DB objects (Procedure, Packages, Triggers, Views, and Tables etc.) on Business enhancement Projects and keep the current business running by participating in maintenance of Database.

Playing a team lead role to deliver the projects on time and interact with clients to have the clear requirement and then prepare technical spec in order to get it done development work from offshore team.

Creating new objects while keeping company standards in consideration and get approval from Manager when needed.

Actively involved system production support to resolve the issue on daily basis.

Working on Pro*c files and Unix shell scripting while making changes on database objects for example adding new column into table or changing signature for the package or procedure.

Closely worked in Server Migration project to set up the Firewall request and tested them for OUTBOUND call and follow up with other team to do the same for INBOUND call.

Moved the directory structure from one system to another system while separating application and database servers.

Closely working with Transmission team to set up the transmission between two system via SFTP.

Preparing High Level Design documents and technical specification documentation to share with Project Manager and get the sign off.

Gained Experience for Server Migration and Database upgrade projects.

Wrote a script to help DBA while exporting data and objects from one server to another server to validate the status and also participated in testing the objects if all are working as previously.

Maintaining and updating source code using Dimension tool for pro*c and UNIX shell scripting.

Write PL/SQL procedures, package, triggers as per the requirement and also look for the code dependency if presented.

Write Reports as Business Demands and send it in emails.

Doing Code review/ Peer Review to make sure code is written with Company standards and policies.

Do weekly meeting with Senior Resources and manager of the team for the complex Designs, sizing of the Project and also on performance of the system.

Closely working with JAVA Application team to feed the data as per the business requirements.

Working in Production support when it demands.

Environment: Oracle 11g/10g/9i, SQL Server 2008, UNIX Shell Scripting, Pro*c, TOAD tool, Dimension, JBoss Application.

Mapfre Insurance (Auto- Insurance Domain), MA

On Site Team Lead /Oracle Developer

I was involved in Insurance company project to work in three modules (claim, issue, print) and also working with data warehouse team to facilitate the database design and coding as per the requirement.

Also worked as Onsite lead to get and understand the entire business requirement from client and then distribute the work load to the offshore team to get work done.

Responsibilities:

Managed work with off-shore team to compensate the work load on client place.

Give estimate on new requirement and existing code changes before start coding and based on the Technical design document give target date for Integration Release.

Verified the coding done by off-shore team and check all test cases for every module.

Gather the requirement from client and do analysis and prepare the Technical design document to accommodate off -shore team for coding approach.

Created new objects while keeping company standards in consideration and get approval from DBA when needed.

Created DB link to transfer the data from OLTP database to ODS system on nightly basis.

Maintained and updating source code using Eclipse (Version Control).

As merging of two company in one, closely worked with ODS /Data Ware House team to design new supporting database model.

Created new packages, Stored Procedure with extensive use of bulk collect & Cursors and also created new database tables to extract and populate the data on daily basis as per the ODS team requirement.

Created artificial key mechanism to avoid database sequence while constructing new tables which has same structure as ODS system.

Design the execution mechanism to reverse the Daily job without rollback.

Coordinated with team members for any new changes in the coding or requirement.

Supported DBA team with object validation and granting user privileges.

Created new Reference tables while needed data interpretation between two systems.

Developed various complex queries to generate various reports to predict business trend.

Created all required Business Reports in I-report Tool and also facilitate them at agent level by assigning the limited privileges to view or print those based on the requirement.

Designed the system to accommodate the address changes on the monthly basis through CD provided from USPS, to develop this I have created new packages and temporary tables.

Errors handling using Exception handling extensively for the ease of debugging and displaying the error messages in the application or while running the job.

Environment: Oracle 11g/10g/9i, UNIX Shell Scripting, PL/SQL Developer tool, I-Report tool,

Configuration Management tools- CVS Repository-Eclipse for version control.

Apollo Group Inc, Tempe, AZ Sept’08 - Feb ‘11

Software Developer/ Oracle Developer

Apollo Group, Inc. was founded in 1973 in response to a gradual shift in higher education demographics from a student population dominated by youth to one in which approximately half the students are adults and over 80 percent of whom work full-time. Today, Apollo Group, Inc., through its subsidiaries, the University of Phoenix (including University of Phoenix Online), the Institute for Professional Development, the College for Financial Planning, and Western International University, has established itself as a leading provider of higher education programs for working adults by focusing on servicing the needs of the working adult. I am involved in design, development and unit testing of PL/SQL Coding as per the Business demands. The project involved the Analysis, Designing/modification, Development, Testing and Maintenance for the Student Life Cycle.

Responsibilities:

Involved in laying out database tables and database schema design.

Maintained and updated source code using Version Control.

Developed scripts to create tables, views, Materialized view and also updated millions of rows without locking table through PL/SQL Block with use of bulk collect.

Created Cursors, Stored procedures, Functions, Packages to provide backend processing using PL/SQL.

Coordinate and scheduled changes to database based on requirements.

Created Indexes and sequences for faster retrieval of the visitor information and enhance the database performance.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Gathered new requirement or before making any big changes to the existing system, make a decision in the designing part to write code by keeping future data flexibility over code.

Used materialized views to maintain copies of remote database to local node.

Worked in complex queries and do SQL tuning to make sure fast retrieval of dataset.

Supported DBA team with object validation and granting user privileges.

Developed various complex and efficient queries to generate various reports to predict business trend.

Coordinated with Release team and DBA for deployment plan and rollback plan at the time when changes may cause System unstable.

Modified pro*c code to make system stable and reliable when we are upgrading database server.

Modified oracle forms as per the business Requirement and also added alter message to show up the user’s under stabled errors.

Make a decision on each release before deploying any database changes to production, restrictive mode is required or not and make a check list to verify each step.

Handled production issue which requires developer contribution.

Worked in Agile methodology for software development process.

Worked in XML transformation using Oracle SOA suit closely worked with SOA team to achieve the business requirement.

Used sql*loader utility to load the data from Business given files to Database tables.

Environment : Oracle10g/9i, UNIX Shell Scripting, SQL Server, Windows 2000/XP,PL/SQL Developer tool, Oracle 10g/9i/6i Forms, Pro*C, Service Oriented Architecture .

Infovision Technology Inc, North Brunswick, NJ (Internship) May’08- Sept’08

Infovision Technology is leading consulting firm in the Information Technology field and it has many clients all over globe. I am involved in design, development and testing of PL/SQL Coding for Client. The project involved the Analysis, Designing, Development, Testing and Maintenance for the Client-Business Requirement. Created business design document and technical design document for the end clients.

Responsibilities:

Involved in laying out database tables and database schema design.

Developed scripts to create tables, views, Materialized view and also updated millions of rows without locking table through PL/SQL Block.

Created Cursors, Stored procedures, Functions, Packages to provide backend processing using PL/SQL.

Coordinated and scheduled changes to database based on requirements.

Created Indexes and sequences for faster retrieval of the visitor information and enhance the database performance.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Used materialized views to maintain copies of remote database to local node.

Supported DBA team with object validation and granting user privileges.

Developed various complex queries to generate various reports to predict business trend.

University Of Bridgeport, Bridgeport, CT (On- Campus) Feb’07 – Aug’07

It is an international, doctoral intensive comprehensive university, with award-winning academic programs. A variety of online courses and certificate programs are also available. I was involved in e`2Tutoring and Online Student Services in Connecticut Distance Learning Consortium. I was a Site builder to update the ARC website over the summer.

Responsibilities:

As a Site builder, I was involved to update the website for ARC Department of University of Bridgeport http://www.bridgeport.edu/pages/4624.asp .

I was involved to take classes for undergrad student to teach Mathematics/Physics as a tutor.

Involved to give an online training/tutoring during summer for Mathematics and Physics classes on www.etutoring.org.

Contact this candidate