Application

Goutham from India applies for Blue Card Germany

Software and applications developers and analysts not elsewhere classified

Personal data:

For personal data please contact us
with the following Applicants-ID: 14177

Profession:

Name of profession: Software and applications developers and analysts not elsewhere classified Name of latest business sector: Latest occupation/title: Latest main activities:

Education:

Completed education: master Title or Qualification: MCA Specialisation: Computers Additional trainings:

Preferred countries:

1. Preferred country | region / city: Germany | 2. Preferred country | region / city: | 3. Preferred country | region / city: |

Language skills:

1. Language skills: english => excellent 2. Language skills: 3. Language skills: =>

Personal note /detailed application:

GOUTHAM LAVETI
Mobile: +91 98855 57936 ? Email: goutamlaveti@gmail.com


Project Management ? Service Management



A dynamic Software professional powered by the knowledge and passion, with the ability to plan, design and enable projects of unmatched scale and complexity. Presently focusing to join some exciting and challenging projects that would nurture to be finest professional with both career flexibility and growth offerings

Key traits:
• Project Performance Management: Hands-on experience in optimizing, implementing and maintaining IT systems, management procedures and ensure their efficient functioning.
• Personal capabilities: Proven track record in imparting significant inputs to the team of service engineers to consistently perform and achieve organizational goals in challenging work environments.
• Customer Relationship Management: Analyzing client and systems needs to upgrade the technical competencies, resolving their issues and queries and to ensure prompt services and spread of goodwill.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, ETL design and implementation, unit testing and support on new and existing applications.
• Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Demonstrated expertise utilizing ETL tools, including Informatica v8.6, 9.0, PL/SQL package design, and RDBM systems like Oracle.
• Expertise in scripting languages like UNIX Shell scripting, JavaScript
• Expertise in Dot Net Programming, implementing the Three tier Architecture, working on SOA and WCF architectures, designing the UI Interface and the Database Architecture
• Proficient and well versed in Asp.Net Programming.
• Self motivated with excellent communication and interpersonal skills.

TECHNICAL SKILL SET

ETL Informatica 8.6, 9.0
Languages C#.NET,VB.NET,C,C++
SQL PL/SQL, TOAD
Database Oracle 11g, MS SQL Server 2000,2005
Scripting Languages Shell script, JAVA Script, VBA
Operating System Windows XP/2003/2007, UNIX
Tools Documentation MS Office, Edit Plus, Putty, HP Service Center, Composite6.2
Web Technologies ASP.NET, HTML

WORK EXPERIENCE

Role: Working as an application development programmer since January 2010 till date.
Current Organization: Ness Technologies (India) Pvt. Ltd., Hyderabad

Role: Worked as an application development programmer from June 2008 to January 2010
Organization: Aquarian IT Solutions, Hyderabad.

CERTIFICATIONS

Oracle Certified Associate

ACADEMIA

• Masters in Computer Application, Jawaharlal Nehru Technological University with distinction.
• Bachelors in Computer Application, Nagarjuna University.
• Intermediate from Board Of Intermediate Education.
• SSC from Secondary School Education.

ACHIEVEMENTS

• Awarded with Quarterly best performer , 2010 for successfully delivering the reports to the client
and increasing the application performance
• Spot award for increasing the performance of a key functionality.
• Spot award for testing complex modules and making the ISRM project implementation smooth and successful


OVERALL RESPONSIBILITIES

• Development
• Unit Testing
• Implementation and Deployment
• Preparing LLD documentation

Application Support:

• Providing seamless support for various applications in production environment.
• Resolving issues and providing remedies during the production load based upon priority.
• Implementing critical change requests.
ETL design and implementation:
• Design and develop PL/SQL packages, stored procedures, tables, views, and functions, dos/unix scripts; implement best practices to maintain optimal performance.
• Build efficient ETL Process for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Implemented complex transformations and mappings.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Involved in ETL job automation and scheduling and design ingenious strategies for implementing complex business requirements.

PROJECTS IMPLEMENTED

Project: ETF (Exchange Traded Fund)
Client: Franklin Templeton Investments (FTT)
Tools/Technology: Informatica v9.0 as ETL Tool, UNIX Shell Scripting, PL/SQL, Composite6.2
Database: Oracle 11i
Duration: 1st July 2013-Sep 2013
Team Size: 5

The Franklin Short Duration U.S. Government ETF will be launching. The fund is an Exchange Traded Fund (ETF) and will be administered by Bank of New York Mellon (BNYM).
ETF has a regulatory requirement to display certain fund and pricing/trading data daily, therefore the web site is required for the launch of the ETF fund.

Project: GID ISRM
Client: Franklin Templeton Investments (FTT)
Tools/Technology: Informatica v8.6, Informatica v9.0 as ETL Tool, UNIX Shell Scripting, PL/SQL, BMC CONTROL-M, Java
Database: Oracle 11i
Duration: Aug 2011 – April 2013
Team Size: 9

The ISRM project’s primary goal is to provide a most robust Customer Relationship tool for the International Sales staff. GID will support this goal by loading files containing asset and transaction data for International 3rd party, Supermarket and Institutional lines of business to the GID (Global Integrated Datastore) GID will provide the allocation of this data to the appropriate Sales Office and Business Development Executives, and then pass the data on to ISR where it will be aggregated according to ISRM’s needs. ISR will pass this data to ISRM where it will be used in the CRM for analysis of existing levels of business in various markets. For those data sources that are included in the Riva data, this data would be at a rolled up level; the 3rd party data will provide visibility into the countries where the business is actually being conducted

Contributions:
• Preparing Technical Specs, analyzing Functional Specs, Development and maintenance of code.
• Developing complex ETL mapping and its corresponding sessions & worklets, workflows.
• Developing Stored Procedures and UNIX Shell Scripts
• End-to-end testing of Data warehouse/Data Mart load.
• Implementation of the project in SIT, UAT and Production environments
• Application support in SIT, UAT and Production phases of the project





• Application support:

Created reusable components mentioned below:
? A UNIX script which changes the format of any file into a standard format and this will be used as source to a reusable mapping
? Reusable mappings which contains the logic of all files in the project, so that when a new file comes in there is no need to develop a new mapping, we just need to upload the file to UNIX thereby the script changes the file’s format and the mapping loads the file.
? User-defined functions
? A UNIX script which automatically validates the XML files of mappings and workflows for coding standards
? A UNIX script for insertion of metadata into database tables with the help of Stored Procedure


Project: Resource Management Tool (RMT)
Client: M&T Bank, Buffalo, New York State
Technology: Tools/Technology: Informatica v8.6, Informatica v9.0 as ETL Tool, UNIX Shell Scripting, PL/SQL, VBA, Crystal Reports
Database: Oracle 11i
Duration: Jan 2010 – Aug 2012
Team size: 3

Resource Management Tool is an application used for generation scheduled reports that populates the invoicing details of all the employees, projects and the charges for the projects and their monthly maintenance that the organization is dealing with.

Contributions:
• Application support
• Generation of Adhoc reports
• Providing seamless support for various applications in production environment.
• Resolving issues and providing remedies during the production load based upon priority.
• Implementing critical change requests.
• End-to-end testing of Data warehouse/Data Mart load.
• Application support in SIT, UAT and Production phases of the project


Project: Naidu Motor Services
Client: Naidu Motors Pvt Ltd
Languages: ASP.Net, C#.
Database: SQL Server 2005
Operating System: Windows XP
Duration: Aug 2009 – Dec-2009
Team size: 6

Motor Services is a project about the services given to the customers by Naidu Motors Pvt Ltd. When a car comes for service, first the security registers the car and check in is performed, then a advisor attends the customer and gives the estimation, a job card is opened for the car and sent to floor. When the car is done with its service the invoice is prepared and bill is generated and finally checked out.

Contributions:
• Reviewed and analyzed use cases and requirements, proposed, designed and implemented solutions along with estimates that met the use case and requirements.
• Involved in designing the user forms and data model.

Project: Education Support System
Client: Aryavysya Organisation
Languages: C#.Net.
Database: SQL Server 2005.
Operating System: Windows XP.

Vidhyanidhi is a process of providing education assistance to poor students without interest by Kasi Annapurna AryaVysya Organization. Based on the course the student is joining in, the organization will decide about how much money it can donate and on yearly basis or semester wise and so on. Later when the student completes his/her education has to return the granted amount, the student can return the amount in any number of breaks.
The project deals with creating the forms to input information like student’s personal information, course details, Disbursement details, student returns details, checking out the student’s information, generating the reports like statement of account, dues list, check details, payment information and deployment in the client’s system along with database.




Contributions
• Reviewed and analyzed use cases and requirements, proposed, designed and implemented solutions along with estimates that met the use case and requirements.
• Experienced with SQL Server 2005 along with exposure to performance tuning and configuration knowledge of database.
• Helped to oversee the design development and implementation of quality assurance standards for integrated software testing.
• Checked and Corrected problems (bug fixes) in existing systems or processes.


 

Facebook

Google Plus