GAYATRI PATEL

540-***-****

ad2a66@r.postjobfree.com

CAREER OBJECTIVE

I would like to be able to use my technical skills to effectively execute software development.

SUMMARY

Over Ten (10) years of hands-on experience in the software industry with the complete knowledge of Software Development Life Cycle through requirements, design, development, testing, documentation, and delivery.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.

Has worked in Windows, UNIX and LINUX based environments.

Providing day to day production support and off hours support as required.

Experienced in Software Design, Analysis, Coding, Development and Testing with specialization in Oracle based Client-Server Computing, Database Administration, Implementation, Maintenance and Quality Assurance.

Experienced in PL/SQL, developing stored procedures, functions, packages, triggers, views and Sequences.

Experienced in writing complex SQL Queries, creating Materialized views.

TECHINCAL EXPERTISE

DBMS/RDBMS

Teradata13.10, Oracle 6i/8/8i/9i/11i, MS SQL Server 2000, MS Access, Postgres, Snowflakes.

Languages

SQL, PL/SQL, Informatica Power Center 9.5.1, C, C++, Java, Visual Basic, SQL, Advance Java (Spring Framework, Swing, Servlet, JSP, EJB), ASP

Operating Systems

Windows 95/98/2000/XP, UNIX, LINUX

Scripting Languages

UNIX, LINUX, HTML, DHTML, VB Script, Java Script.

Web Design Tools

Corel Draw, Adobe Photoshop, Flash, Maya, Dream weaver.

Tools/Applications

Oracle Enterprise Manager, Teradata 13.10, SQL Server Enterprise Manager, SQL Server Query Analyzer, MS Project, MS Visio, DBA Studio, Matillion, Adobe Acrobat Professional, Toad 8.x/9.x,PL/SQL Developer, SQL Plus, TestComplete 9.

EDUCATION

MS in Computer science

UNVA (University of Northern Virginia), Annandale, VA 22003, USA

Bachelor’s of Technology in Computer Science and Engineering.

Gujarat University, INDIA.

PROFESSIONAL WORK EXPERIENCE

Network Solutions, A Web.com service

Herndon – VA 20171

Senior Engineer, BI (Business Intelligence –Data Warehouse) Feb 2013 – Cont…

At Network Solutions®, we focus on helping small businesses start and market their businesses on the Web, enabling them to realize their dreams of self-reliance, entrepreneurship, creativity, and financial independence. We pioneered the service for creating and acquiring specific “web addresses” (known as domain name registration), and today offer a full range of Web-related services.

Responsibilities:

Developed ETL programs using Informatica to implement the business requirements.

Created shell scripts to fine tune the ETL flow of the Informatica workflows.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Identified problems in existing production data and developed one-time scripts to correct them.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Regularly communicate and work on joint tasks with both remote and on-site team members. - Serve as Engineering Point of Contact for enterprise service platforms.

Collaborate across teams to troubleshoot reported problems in both UNIX and Windows environments.

Experience in developing Dashboard Report, Parameterized Reports, and Linked reports, Sub reports by Region, Year, Quarter, Month and Week.

Design, development, testing and deployment of Tableau Dashboards.

Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.

Develop and deploy cube using SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).

Basic knowledge of Cloud Strategies based on AWS (Amazon Web Services).

Providing day to day production support and off hours support as required.

Experienced in PL/SQL, developing stored procedures, functions, packages, triggers, views and Sequences.

Experienced in writing complex SQL Queries, creating Materialized views.

Developed Database for EMS, HR Portal, Budget Add system and created packages for each.

Created tables and developed Stored Procedures for EMS, HR Portal and Budget Add.

Designed and developed system for Web.com using J2EE, Spring, Servlets, JSP under the Apache Struts Framework.

I also involved in designed and development of web interface using JSP, Servlets, JavaScript and JDBC for administering and managing users and clients.

ENVIRONMENTS

Oracle 11g, Informatica 9.5.1, Teradata 13.10, SSRS Reporting Tool, Tableau 10.1, Postgres, SQL Server, MySQL, Eclipse, JSP, JavaScript, PHP, Windows 7 Professional.

Assetworks Inc.

Wayne – PA 19087

Software Design Engg Nov 2012 – Feb 2013

AssetWorks delivers industry-leading business solutions that help asset and infrastructure intensive organizations control capital and operating expenditures, reduce operational complexity, and manage regulatory and policy-driven risk. Leveraging a comprehensive portfolio of software and consulting solutions, helps organizations like yours work more efficiently by improving access to shared asset data, promoting greater transparency across the organization, speeding response times and mean time to repair (MTTR), maximizing asset availability and uptime, and reducing total cost of ownership (TCO).

Responsibilities:

Develop and strategize web page design(s) for the FleetFocusM5 product.

Consult with Project Managers, Quality Assurance and Support staff on the development of FleetFocus products and customer facing web pages.

Assist in defining system interfaces, data conversion requirements, and software modifications required by customer or to support general enhancement of the application.

Discuss development activities with ASSETWORKS Trainers and Support staffers who provide services as part of the implementation and on-going maintenance, and provide training, if required.

Assist in the development of specifications of enhancements and functional additions to the ASSETWORKS product line.

Prepare and deliver technical correspondence to Support both internal and external communications associated with the development of new FleetFocus, including program modification specification, data interface specifications, and data conversion specifications.

ENVIRONMENTS

TestComplete 9, JavaScript, Oracle, SQL Server, Windows 7 Professional.

Jyoti Limited Jan 2006 – Mar 2010

India

Oracle Developer

Jyoti Ltd., an engineering company offering reliable quality products and services to clients in India and in the international market. Previously the system was in Forms 3 (0racle 7.3 DB), then it has been converted to Form 6i and Reports 6i (Oracle 9i DB), we have made it more user friendly, added the New features as per the users requirement.

Responsibilities:

Development of company ERP using Oracle Forms and Reports.

I developed modules

i)Master and FGS Module

ii)Inventory Module

iii)Purchase Accounting

iv)Row Martial Batch Processing

v)PF (Provident Fund)

vi)BOM (Bill of Material)

vii)A/C Maintenance

viii)Income Tax Planning

ix)Payroll Accounting

Configure entire application for Web Deployment using Jinitiator, Form Server and Report Server.

Converts the Forms 3 to Forms 6i and deploy them on the web.

Understands the pro*c reports and convert them to Reports 6i.

Preparing Working plans for the projects and distribute the work between the technical team members.

Ensure that each module of the system is delivered at the time with the expected outputs.

Dealing with clients and gathering their requirements, in addition to collect their comments on the deliverables.

Conduct meetings with decision makers from the customer side to confirm their satisfaction of the delivered systems.

Analyzed the table’s structures and their integrity constraints for reports creation strategies.

Involved in Database Administration activities like creating users, granting privileges, assigning roles to users.

Tune and improve the performance of the Oracle databases using SQL Tuning Advisor and number of VIEWS.

Loading data into oracle database from flat files using SQL Loader and External tables

Involved in Database Administration activities like creating users, granting privileges, assigning roles to users.

Creation of Database Package, Triggers, Functions and Procedures

Involved in installing and configuring Oracle 9i databases on Windows as wells as UNIX Operating systems.

ENVIRONMENTS

Oracle database 10g,9i, Forms 6i, Report 6i, 3-tier Internet Application Server (IAS), PL/SQL, Stored procedures and triggers, Red hat Linux, Windows 2000 professional.

Contact this candidate