Post Job Free

Resume

Sign in

Data Developer

Location:
Frisco, TX
Posted:
February 22, 2018

Contact this candidate

Resume:

Bharathi J. Shimoga

**** **** ***** ****, ****** Tx-75034

Cell No : 210-***-****

Email: b ac4kor@r.postjobfree.com

Summary:

● Over 6+ years of IT experience as Analyst, developer and Tester involved in all phases of development lifecycle from gathering data requirements, analysis, design, development, testing, implementation and maintenance.

● Worked on Data warehousing

● Worked on different databases like SQL Server, Oracle, Teradata.

● Very strong in SQL queries, TSQL, PL/SQL, DML, DDL, DCL.

● Worked on several tools and technologies like SSIS, SSRS, Crystal reports, Toad for analyst, Oracle E-Business Suite

● Quality driven, dependable, easily adaptable, fast learner, multitasks, resolve problems, organized, efficient, independent able to effectively coordinate tasks, team player with strong written and oral communication skills and highly motivated to deliver consistent quality work. Technical Skills:

Scripts VBScript, HTML

Languages C, C++, Java 1.2

Database Foxpro 2.5, Ms Access, Oracle 8.x, SQL server, Teradata 12.2 Front ends Visual Basic 6, Developer 2000

ERP Oracle E-Business Suite

Tools Crystal reports, SSRS, SSIS, Toad for analyst, Argos Testing Tools Selenium, Test Manager, IBM Clear case Professional Experiance:

Oracle Technical Designer/Developer

Accenture Federal Service San Antonio, TX (September 2014 – August 2016) Project : FAR: Nicklaus - Dayton

● Worked on Oracle E-Business Suite applications for accounts payable/accounts receivable

(AP/AR), Purchasing(PO), iProcurement

● Experience in Workflow Customization according to business needs.

● Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.

● Involved in defining and reviewing requirements and use cases for the application.

● Involved in creating the Technical Design document for reports, Extensions, workflow and conversions.

● Involved in creating the unit test plan for the defects.

● Involved in finding the differences in R12 and the current version of forms for oracle application for upgrading the application from 11i to R12.

Project : Accenture Internal

● Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work.

● Work with other developers, designers, and architects to make sure that the configuration and custom components meet application requirements and performance goals. Follow good security coding practices to ensure the application is free of most common coding vulnerabilities.

● Fix any defects and performance problems discovered in testing.

● Process Execution and Improvement. Meet milestones and related effort/time commitments for assigned deliverables and provide work status Project : Fanniemae

● As a Data Analyst was responsible for the performance, integrity and analysis of the current state of the Databases.

● Involved in the planning and development of the database as well as troubleshooting any issues on behalf of the users.

● Involved in researching which tool is best for migration of data from Sybase to sql server according to the requirements.

● Worked very closely with the development team in order to define potential changes to the current databases. Involved in migration of Sybase database to SQL server 2012 using the SSIS as the ETL tool for data transformation, custom staging table, data conversion and loading the data to database.

● Involved in Data mapping, interface creation documents (ICD's)

● Also Involved in optimizing query for report developer’s (BI reports) in extracting report data and formatting the reports as required for report formatting and development by using aggregate, analytical, date, string functions. Application Support Analyst

Randstad technology

(University of Incarnate World) San Antonio, TX July.22.2013 –Aug 24.2013

● Involved in creating reports using Argos reporting service.

● Involved in creating views using SQL code on faculty information and their schedule for class.

● Involved in optimization of reports using SQL and PL/SQL code for their active net and cash net application.

● Involved in creating reports of Alumni students birthday mailing list.

● Involved in data extraction and reporting for donor codes for the alumni’s for previous 5 years list.

Data Analyst

GroupO (AT&T) San Antonio, TX Sept.2010 - Sept.2011

● Responsible for monthly archiving of the data from different data sources(EDW, ECDW, RDW data warehouses) involved in ETL process like extracting data using SQL code, loading data using fast load and MVS mainframe

● Responsible for completing the data mapping documentation of the archiving data.

● Responsible for analysis of the campaign marketing (consumer insight analysts ) by writing complex SQL queries using aggregate function, sub-queries and report generation using excel, SSRS as per the client requirement.

● Also worked TOAD for analyst for automating the reports which runs quarterly, monthly and weekly.

Project Coordinator

Systel Infos India, Bangalore Aug.1996 –Aug. 2000

● Worked as a computer faculty and then promoted to project coordinator.

● Involved in mentoring corporate employees/trainees for various courses like word, excel, access, Oracle 8, 9 Developer 2000(forms 6ver and report 3ver), Unix, Visual Basic 6, Foxpro and designing course material.

● As a Project coordinator was responsible for gathering data requirements, user and business requirements, data validation, data mapping etc and completed many small builds for the corporate.

● As DBS was responsible for creating users, managing tablespace, giving roles and permission to users.

EDUCATION:

Bachelor’s degree in science from Bangalore University, India. Post graduate diploma in computer application from Indragandhi open university, India. Work Status:

US Citizen.



Contact this candidate