Data Sql

Sudhakarachary Sirigadha

Summary:

IT Professional with over 10 years experience including:

. Extensive experience in data extracting and loading using Informatica,

UNIX Shell scripts, DB2, Oracle PL/SQL with various job scheduling tools

including Crontab, Qmaster, Autosys, Job Track.

. Have developed/maintained applications across different business

domains including Investment Banking, Insurance, Wholesale Banking,

Retail Marketing information, Cargo shipping.

. Knowledge in Data Warehouse processes, ETL Tools and Business

Intelligence.

. Have developed Informatica ETL mappings for loading the data from

various source systems to the Data marts.

. Experience in Data Modeling.

. System analysis, Data Analysis, table design, preparation and review

of technical documentation, preparation of test plans, analysis of

data problems and development of the programs.

. Extensive experience in working with fixed income instruments like

Bonds, Investment Trusts, Stocks, Brokerage, Mutual funds, family

wealth group business.

. Strong understanding of ER Modeling and Dimensional Data Modeling such

as star and snowflake schema.

. Experience in working Multi Terabyte data mart environment.

. Implemented Data Warehousing concepts using Informatica with emphasis

on Extraction, Transformation and Loading data of a business

requirement which involves analysis, design, development, testing and

implementation.

. Developed Back end Oracle processes relating to the system. This

consisted of the creation of tables, indexes, triggers, stored

procedures, functions and packages.

. Loading data from flat file using SQL*LOADER.

. Proficient in working on databases Oracle, DB2 and Tera data

. Migration of Oracle tables to DB2.

. Analysis, design, review, coding and testing of enhancement requests.

. Developed several complex shell scripts for a wide range of

applications.

. Good experience in performing code reviews.

. Installing, configuring and setting up the batch jobs for various

environments for the testing, building new environments for the

testing as well as for production.

. Experience in the performance tuning of Sql queries.

. Good problem solving skills.

. Automating routine activities using shell scripts.

. Good Communication, organizational, Analytical skills, Time management

skills and strong interpersonal skills.

. Working with cross-functional teams for impact analysis.

. Guiding junior team members and reviewing their work.

. Ability to excel as a team and also individually with minimum

supervision

. Experience in working as Team Lead.

. Ability to handle concurrent, multiple high priority tasks.

. Aptitude to learn new things quickly.

Technical Skills:

Programming & Database Tools:

Informatica 7.1/ 8.6, Oracle 8i/9i/10g, PL/SQL, DB2, TERA DATA, UNIX

Shell scripts, Pro*C, Sed, Awk, Pro*Cobol, HYPERION

Software Engineering and Special software/Tools:

SCCS, CLEAR CASE, PVCS, CVS, REFLECTION, PUTTY, XTERM,TOAD, PL/SQL

DEVELOPER, RAPID SQL, ARS, HEAT, AUTOSYS, QMASTER,JOB TRACK, ErWin,

ER Studio

Operating System:

Windows 95/98/NT/2000/XP, UNIX (AIX 4x, 5x, HP UNIX, Linux 2.6.9)

Education:

. Master of Technology, Regional Engineering College, Kakatiya

University, Warangal, India

Contact: ********@*****.***

Phone: 510-***-****

Professional Experience:

Wells Fargo Bank, San Francisco, CA

July'08 - Till date

Sr Programmer/Analyst

Wells Fargo is a diversified financial services company with more than $500

billion in assets, providing banking, insurance, investments, mortgage and

consumer finance to more than 23 million customers and the internet

(wellsfargo.com) across North America and elsewhere internationally. Wealth

Management Group ( WMG) supports various data warehousing applications(Data

Marts) which handles the data for Bonds, Stocks, Brokerage, Mutual funds,

Investment Trusts, Private banking, Loans from various source systems and

generates reports for the end users & down stream applications.

Projects:

Wealth Management Master Data Mart (MDM)

Trust data integration

Anti Money Laundering Compliance Reporting

Compliance Engine

Netcool Interface

License Banker

Performance Reporting

Vendor Extracts

Responsibilities:

. Responsible for design, development, testing & implementation of the

enhancement requests.

. Loading the data from flat files using ETL Tool Informatica and UNIX

Shell scripts, DB2 load utility.

. Developed and maintained Oracle Stored Procedures, Functions,

packages.

. Have developed Informatica ETL mappings for loading the data from

various source systems to the Data marts.

. Working with cross-functional teams for impact analysis and was

involved in converting the business requirements into technical design

document.

. Leading junior team members and reviewing their work.

. Designed and developed complex mappings from varied transformation

logics like Unconnected and Connected lookups, Router, Filter,

Expression, Aggregator, Joiner, Sorter, Update Strategy and more

. Developed and maintained extracts for external vendors like ROCKIT,

INFORMA, WEALTH TOUCH, INVESTOR TOOLS, PIMCO, INGFUNDS, FORTRESS using

complex sql queries and db2 command line options.

. Worked on applications involving fixed income instruments like Bonds,

Investment Trusts, Stocks, Brokerage, Mutual funds.

. Have converted Tera Data sql queries into DB2 queries.

. Have automated routine activities using Shell scripts.

. Scheduling/setting up the batch jobs using Crontab and Shell scripts.

. Migrated Oracle tables to DB2

. Analysis of data for data related issues in production environment.

. Troubleshooting the problems and analyzing the solution to them.

. Performance Tuning of the sql queries.

. Developed several complex shell scripts for a wide range of

applications.

. Efficiently worked in multiple projects / tasks at the same time.

. Participated in hiring process to hire new contractors for integration

project.

Environment: DB2, Unix (AIX), Shell Script, Informatica, Oracle 9i/10g,

SQL, PL/SQL, SQL Loader, Sed, Crontab, Rapid SQL, HYPERION, ER Studio

ACNielsen, Schaumburg, Chicago

Sep'07 - Jun'07

Sr Programmer/Analyst

ACNielsen, a Nielsen company, is the world's leading marketing information

company. ACNielsen provides market research, information, analysis and

insights to the consumer products and service industries. Nielsen Answers

Integration Platform is an end-to-end ACNielsen data management(warehouse)

process that supports the following key features:

. Business Intelligent (BI) Data Enhancements

. Integrated Relational Output Databases

. End-to-End Operational Management

Responsibilities:

. Responsible for design, development, testing & implementation of the

enhancement requests.

. Developed and maintained Oracle Stored Procedures, Functions, packages

and Db-Triggers.

. Loading data from flat file using SQL*LOADER, Shell scripts, Oracle

stored procedures, functions, packages and ETL Tool Abinitio.

. Working with cross-functional teams for impact analysis and was

involved in converting the business requirements into technical design

document

. Have automated routine activities using Shell scripts.

. Created several stored procedures, triggers to implement business

rules.

. Scheduling/setting up the batch jobs using Crontab and Autosys.

. Analysis of data for data related issues in production environment.

. Troubleshooting the problems and analyzing the solution to them.

Environment: Oracle 9i/10g, SQL, PL/SQL and Unix (AIX & Linux), Shell

Script, SQL Loader, Sed, AUTOSYS, Abinitio

AXA Insurance, Ipswich, UK, India

Jun'05 - Aug'07

Sr. Programmer/Analyst

AXA Insurance is a UK based insurance company engaged in the general and

life insurance.

It has a business Intelligence application (Management Information) that

receives data from various source systems and loads into the data warehouse

after calculating various key performance indicators. The system generates

a lot of Management Information reports during the Month End including the

feed to SAP system.

Responsibilities:

. Developed Stored Procedures, Functions and Db-Triggers using PL/SQL.

. Maintain and support AXA Detailed Database.

. Have developed and enhanced Pro*C batch programs and shell scripts to

extract the data from source systems into target systems.

. Developing new reconciliation process for the existing system for SOX

compliance.

. To resolve the incidents raised by customer.

. Analysis, Development, Review and Testing for new Change Requests.

. Loading data from flat file using SQL*LOADER and Informatica

. Created several stored procedures, triggers to implement business

rules.

. Data Modeling using Erwin.

Environment: Oracle 9i/10g, Pro*C, Shell scripts, SQL, PL/SQL and Unix (HP

Unix, Linux), SQL Loader, Informatica 7.1, SCCS,REFLECTION, TOAD,

PEREGRINE, Job Track, Xterm, Erwin

Standard Chartered Bank, Chennai, India Oct'03 - May'05

Sr. Programmer/Analyst

Quantum Leap is a project started to serve various purposes of the

corporate customers of SCB. It has various modules spread over various

back offices, having different ways of message formats, Databases. DS (Data

Services) Module of Quantum Leap for Web Bank is intended for common data

storage and reporting purpose. Various Back Offices will send their data

to DS through various channels. The format of these data feeds varies from

Back Office to Back Office. Data feeds will come in XML, CSV, Fixed Length

Records, GREC formats.

The Role of DS is in uploading the data into Database and downloading from

the Database and Report Generation.

Responsibilities:

. Data massage, Data analysis, Data Conversion, Generating Reports

. Created several stored procedures, triggers to implement business

rules.

. Preparation of Technical Specifications using Business Spec Docs

provided by Client

. Designing, Developing, Review and Testing for new Change Requests of

the module DS for Web bank Roll out for MESA countries. This includes

developing new XML loaders for Cash (Operating Accounts, Loan Accounts

and Deposit Accounts) & Trade (Letter of credit, Bill and Guarantee)

and enhancing the existing components to customize for MESA countries.

. Loading data from flat file using SQL*LOADER.

. Customer User Interface testing coordinator.

. Converting data from different sources into Oracle database.

. Involved in SQL tuning.

Environment: Oracle 8i, Pro*C, Shell Script, Sed, SQL, PL/SQL and Windows

2000, CVS, TOAD

P&O Nedlloyd, London, UK, India

May'99 - Sep'03

Programmer/System Analyst/Technical Analyst/Module specialist

P&O Nedlloyd is one of the largest cargo shipping company based in London

has a IT division to support its cargo operations, vessel scheduling,

revenue and global e-commerce applications.

Responsibilities:

. Have worked in four different projects including product support and

technical support teams.

. Analysis of problems, data fix, bug fixing, coding and testing of the

various problems reported in production environment.

. Handling client queries, liaising with other teams.

. Installing, configuring and setting up the batch jobs for various

environments for the testing.

. To provide Go Live support for the project.

. To assist production support team in resolving critical

problems/issues.

. Writing shell scripts, analyzing and fixing the job failures.

. To provide technical support for the User Acceptance Testing (UAT) and

Business Acceptance Testing (BAT)

. Building new environments for the testing as well as for production.

. Automate the day to day activities using shell scripts to develop and

enhance/customize the existing client's tools.

Environment: Oracle 7.3.4/8i, Pro*Cobol, Shell Script, Sed, Awk, SQL,

PL/SQL, Windows 95/98, AIX 4.2, Clear Case, TOAD

REFERENCES: Available.

Contact this candidate