Data Sql Server

Rajesh Arra

Phone: *** 647-***-****

Email: ****.******@*****.**

Address: **,**** ****** *******,**-m4y2p8

Visa: Canada PR Visa

Career Summary

Over 8+ years of IT experience with 6 years in data migration, data warehousing database design and design of

ETL methodology for supporting data transformations and processing ETL Solution using Teradata

V13/12/V2R5/V2R6 on various Data Warehouse Environments.

• Software Development Life Cycle ( SDLC) analysis, design, development, testing, implementation and

maintenance in Data Warehousing environment.

• Proficient using in RDBMS like Oracle, SQL Server, Teradata, SQL *PLUS

•Expertise in using Teradata utilities like BTEQ, Fastload, Multiload, DDL and DML Commands (SQL).

• Performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right

primary Index, scheduled collection of statistics, secondary or various join indexes

•Data Warehouse and BI methodologies and strong understanding of Relational, Multi-Dimensional Database

concepts

• Proficient in converting logical data models to physical database designs in Data warehousing Environment

and in-depth understanding in Database Hierarchy, Data Integrity concepts.

• Skilled in Data Warehousing Data Modeling using Star Schema and Snowflake Schema.

• Sourced data from disparate sources like Mainframe Z/OS, UNIX flat files, Oracle, and SQL Server and

loaded into Oracle and Teradata DW.

• Extensive experience with ETL/Data warehousing tools.

• Expertise in Oracle 9i/8.x/7.x, SQL/PLSQL, Procedures, Functions, and Triggers. Experience in trouble

shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.

• Expertise in preparing code documentation in support of application development, including High level and

detailed design documents and unit test

• Writing Deployment/Release Notes before the project release and End User Manual for production team.

•Generated Crystal reports, User Reports in Excel with automation and wrote complex queries including Sub queries,

Unions, Intersect and Aliases

• Experienced in Informatica Power center Repository from 8.1.1 to 9.1

• Expert in data modelling and Reverse Engineer by using ERWIN, Microsoft VISIO and Oracle Designer

• Performed production EDW data validation and ETL testing

• Presented the UAT’s for business/end users as per their requirements

• Expert to create the FDS (functional design spec), ETL mapping documents and data dictionary’s

• Highly enthusiastic, self-motivated and rapidly assimilate new concepts and technologies.

• Excellent Interpersonal skills and can work efficiently independently or as part of a team.

Academics

MCA from Visvesvaraya Technological University, Belgaum (2003)

Technical Skills

• Operating System Windows 2000 NT/XP, UNIX

• RDBMS Teradata, Oracle and SQL Server

• ETL Tool Informatica Power Center 8.6

• Teradata tools & Utilities SQL Assistant, BTEQ

• Load & Export Fast Load, Multi Load, Fast Export, BTEQ, TOAD 7.6,

Other Tools

MS Project, MS Visio, MS Word, MS Excel, VSS, MS, PowerPoint, Crystal Reports, .NET Framework, XML,

ASP.NET, ADO.NET, C#, VB.NET, Visual Studio.NET, Visual Basic, Active Server Pages (ASP), MS -SQL Server,

PL/SQL, Visual Basic for Applications (VBA) and Oracle APEX.

Professional Experience

Wipro Technologies, Bangalore, India – Project Leader Aug ‘12 -Till date

Client: Lloyds Banking Group plc is a major British financial institution and its activities are organized into Retail,

Banking, Wholesale, Life, Pensions & Insurance, and Wealth & International.

Environment: Teradata V13.10 (BTEQ, Fast Load, Multi Load, Teradata SQL), Oracle, Mainframes MVS/OS, JCL,

TSO/ISPF

Responsibilities

• Based on the Impact analysis documents, prepared the Midlevel platform design(MLPD)

• Worked with the SME and Business user for preparing the MLPD and Technical Design document

• Prepared the Datalib’s in mainframes and executed it

• Loading of data from several flat files sources using Teradata Fast Load and Multi Load.

• Transfer of large volumes of data using Teradata Fast Load, Multi Load and T-Pump.

• Fine tuning of Mload scripts considering the number of loads scheduled and volumes of load data.

• Writing Teradata SQL queries to join or any modifications in the table.

• Scripts to extract the data from Oracle and load into Teradata.

• Teradata BTEQ scripts to implement the business logic and proactive data audit scripts.

• Worked datasets for analysis.

• Written Teradata BTEQ scripts to implement the business logic and proactive data audit scripts.

• Hands on with Teradata Queryman to interface with the Teradata.

• Developed BTEQ scripts to extract data from the detail tables for reporting requirements

• Prepared the Release notes for the code delivered and Dependency diagrams

Mahindra Satyam, Hyderabad, India – Module Leader Mar ‘10 – Aug ‘12

Client: Cisco is the worldwide leader in networking that transforms how people connect, communicate & collaborate

Responsibilities

• Worked with the SME and business to prepare the ETL Data mapping sheet

• Data Profiling tool for the data analysis on Oracle tables (Excel macros), based on this created DDLs in

Teradata

• Loading of data from several flat files sources using Teradata Fast Load

• Database-to-Database transfer of data (Minimum transformations) using ETL (Informatica).

• Fine-tuned the existing mappings and achieved increased performance and reduced load times

• Creation of customized Fload and BTeq scripts on UNIX platform for Teradata loads using Informatica.

• Used data profiler in ETL processes, Data integrators to ensure the requirements of the clients including

checks on column property, column value, and referential integrity.

• Acted as a single resource with sole responsibility of Informatica – Teradata conversions.

• Used UNIX scripts to access Teradata & Oracle Data

• Developed complex transformation code for derived duration fields.

• Loading data from Flat Files into the Staging area using Informatica Power Center.

• Developed complex Informatica mappings to load the data from various sources using different

transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner,

filter, normalizer, rank and router transformations.

• Informatica Power Center - Source Analyzer, Mapping Designer, Workflow Manager, Mapplets, and Reusable

Transformations.

• Debugged and sorted out the errors and problems encountered in the production environment.

• Analyzing data issues and providing strategies to handle such data.

• Wrote the SQL Queries, Procedures and function as required

Qantas Airways, Sydney – Australia - Transition Lead Aug ’06 - Feb ‘10

Qantas is widely regarded as the world's leading long distance airline and one of the strongest brands in Australia.

Responsibilities

• Defined the road map for efficient transition to support group of all Client/Server applications from QF.

• Developed matrix of required resources/skills

• Conducted skill gap analysis against all IS staff and developed training plans

• Identified project activities to be completed before transition can start

• Capacity management and Estimation for small enhancements

• Move development documentation and code to production repository

Application Support

Developed and supported the applications -

• WorldNet- Reporting tool which will be used by 900 users Across globe

• PMO Reports- 8 Application under this was used by Qantas Portfolio Management Office team

• ARaBiS – Appraisal tool for Qantas Employees developed and supported

• Generated the Reports based on the Ad-Hoc request in Teradata DSS from the business users

• Repeatable Request are tracked and

• Developed reusable excel sheets if the requirement is for the Single user or up to 5 users

• Suggest the business to include in the WorldNet application, which can be accessed by all the employees

• Given estimation requirements for changes (RFS)

• Wrote the Document of understanding and other technical documents including user guides

• Involved in the Change management process using ESM tool

• Reviewed all the code developed by the team, before moving to next environment (Peer review)

• Wrote Queries ( Teradata / Oracle), procedures and functions (Oracle)

IBSS Techno-Park Pvt Ltd, Hyderabad - Senior Software Engineer Apr ‘05 – Jul ‘06

Client: IBSS Inc, NJ, USA

Environment: MS.NET, VB.NET, Windows 2000, SQL Server 2000 and Crystal Reports.

Responsibilities

• System analysis based on the discussion with the Business user

• Designing the application based on the requirements

• Developing the application using the ASP and VB Script code and maintaining the code in VSS

• Writing the Quires, Stored procedures and Triggers as required

• Unit and integration testing the application

• Addressing the Technical issues in Pre-Production and Production

Enlume Technologies, Hyderabad, India – Developer Dec’ 04 – Mar ‘05

Client: EgillMorner, Norway- Team Member

Environment: MS.Net, VB and VBA

Responsibilities

• Designing the application based on the requirements

• Documenting the Design (Technical Design Document)

• Developing the application using the ASP and VB Script code and maintaining the code in VSS

• Writing the Queries, Stored procedures and Triggers as required

Wipro Technologies, Hyderabad – Trainee Developer Feb ’04 – Dec ‘04

Client: National Grid plc is a British MNC electricity and gas utility company headquartered in London, UK

Environment: MS.Net, Oracle 8i, Developer 2000, Window 2000 and VBA.

Responsibilities

• Writing the Quires, Stored procedures and Triggers as required

• Unit and integration testing the application

• Maintaining the Reports in Developer 2000

• Developed in house tools to monitor the Jobs in Excel

• Helped the management be developing the Excel tool for their Analysis

ING Vysya Bank, India- Trainee Software Engineer Feb ’03 – Jan ‘04

ING (International Netherlands Group) Vysya Bank is a Bangalore-based private bank

Environment: ASP3.0, VB, VSS, SQL server 2000 and Oracle 8i

Responsibilities

• System analysis based on the discussion with the Business user

• Documenting the Design (Technical Design Document)

• Developing the application using the ASP and VB Script code and maintaining the code in VSS

• Writing the Quires, Stored procedures and Triggers as required

• Addressing the Technical issues in Pre-Production and Production

Awards

• Got ‘Pat on the Back’ award from the company for my work on ARaBiS application ( POB- 2007).

• Roll of Honor for learning’s ( 2007)

Trainings

• PSP –Personal Software process

• DS201-Intermediate Dot Net-Level 2.

• DS301-Intermediate Dot Net-Level 3

• Yukon

• VS 2005 – C#.NET

• FTL- Management and Behavioral

Certifications

Teradata 12 Certified Professional

Contact this candidate