RAM REDDY

925-***-****(cell)

ac4arb@r.postjobfree.com

Summary:

•Over 11 plus years of IT experience in the Analysis, Design, Development, Testing and Implementation Production Support and Maintenance of Data Warehouse Business Applications in Finance and Insurance industries

•Strong Experience in Data modeling using PowerDesigner – Conceptual Data Model, Logical Data Model and Physical Data Model, Reverse Engineering, Merge Models and Reports.

•Experienced in integration of various data sources like Oracle 11g/10g/9i/8i, IBM DB2, MS SQL Server 2005/2000, XML files into staging area

•Strong experience in data extraction, transformation and loading data using Informatica PowerCenter 7.1.4,8.1.1, 9.0.1, 9.6 (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica.

•Worked on non-relational sources like Flat files and used secure FTP, SSH, Hummingbird

•Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.

•Worked extensively with slowly changing dimensions SCD Type1 and Type2.

•Good Experience on UNIX Shell Scripting and Autosys scheduling

•Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

•Experience in Teradata utilities (Fast Load, MultiLoad, Fast Export, SQL Assistant, BTEQ), SQL Loader and UTL_FILE package, Sybase IQ, Oracle, PL/SQL.

•Worked on Performance Tuning in Informatica at various levels. Targets, Sources, mappings and sessions.Employed Session Partitioning and Pushdown Optimization.

•Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions

• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling

•Good communication and interpersonal skills and Strong understanding of ETL best practices.

•Assigning work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Skill Set:

ETL Tools: SQL Server Integration Service (SSIS), Informatica Power Center 9.6, Informatica Power Exchange.

OLAP/Reporting Tools: Cognos 10.2/10.1/8.3/8.4 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection), Cognos Report Net 1.1, Transformer,PowerPlay, Access Manager

Testing Tools: Win Runner 7.5, Load Runner 6.0, Test Director 7.6, SQA Suite 6, SQA Robot, and QTP

Languages: Visual Basic, PL/SQL, Java, C, C++, C#, VB.NET, VC++, Perl,

DBMS/RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server, MS-Access, DB2,Teradata

Database Tools : TOAD 8.6, SQL plus, ERwin 4.0, Query Analyzer, SQL Assistant

Operating Systems: UNIX, Windows NT 4.0/2000 Server and Windows 98/95

Scheduling Tools: AUTOSYS, Tivoli, Control-M,TIDAL.

Academic Details:

B. S in Computer Science & Engineering

Professional Experience:

State Farm Insurance, Bloomington, IL Aug 11 – Till Date

ETL Developer/Production support

•Involved in complete Software Development Life Cycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.

•Designed and customized data models for Data warehouse supporting data from multiple sources on real time. Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

•Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.

•Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

•Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.

•Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV/QA/PRD environment.

•Developed UNIX shell scripts to schedule the Informatica processes using UNIX pmcmd commands and used Autosys for automation of ETL processes.

•Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.

•Perform troubleshooting analysis and resolution of critical applications and batch processes.

•Coordinate with vendors to troubleshoot and resolve issues.

•Support the Client Reporting Production Environment as a first priority.

•Managed and resolved production tickets assigned through PAC2000. Monitoring and status reporting production jobs. Participated in EACO and Release calls co-ordinating and supporting the business clients and developers.

•Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions..

•Participated in the full development life cycle within the reporting framework, from developing business intelligence requirements to QA and production deployment

•Written SQL Scripts and PL/SQL Scripts to extract data from Databases Power Exchange Change Data Capture has been done for data updates.

•Developed data models according to company standards. Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and also 24*7 Production support for data warehousing

Environment: Informatics 9.6 Power Center Client (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL Server 2005 & 2008, DB2, Oracle10g&11g, Unix scripting, HP Service Manager,DB2 Exchange,Autosys.

Wells Fargo, CA Nov 09 – June 11

ETL Developer

•Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA

•Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

•Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.

•Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.

•Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.

•Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools

•Documented Informatica mappings in Excel spread sheet.

•Tuned the Informatica mappings for optimal load performance.

•Scheduled the tasks using Autosys.

•Created correct NDM control cards for sending the files to MasterCard server.

•Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.

•Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.

•Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

•Constantly interacted with business users to discuss requirements.

•Involved in 24 X 7production support on a rotation basis.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, Teradata,, PL/SQL,SQL Developer,JIRA,Autosys,NDM

SAVI, Mountain View, CA May 09 – Oct 09

Sr.ETL Developer

•Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.

•Designed ETL specification documents for all the projects

•Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.

•Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.

•Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

•Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.

•Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

•Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.

•Extensively used workflow variables, mapping parameters and mapping variables.

•Created sessions, batches for incremental load into staging tables and scheduled them to run daily.

•.Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.

•Involved in Unit, Integration, System, and Performance testing levels.

•Written documentation to describe program development, logic, coding, testing, changes and corrections.

•Migrated the code into QA (Testing) and supported QA team and UAT (User).

•Prepared migration document to move the mappings from development to testing and then to production repositories.

•Provided 24x7 support for any issues or impact caused by the New Changes.

Environment: Informatica PowerCenter 9.1.0, Oracle 11g, SQLServer2008, IBM ISeries (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Wells Fargo, CA Oct 07 – Apr 09

ETL Developer

•Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA

•Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

•Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.

•Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.

•Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.

•Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools

•Documented Informatica mappings in Excel spread sheet.

•Tuned the Informatica mappings for optimal load performance.

•Scheduled the tasks using Autosys.

•Created correct NDM control cards for sending the files to MasterCard server.

•Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.

•Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.

•Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

•Constantly interacted with business users to discuss requirements.

•Involved in 24 X 7production support on a rotation basis.

Environment: Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, Teradata,, PL/SQL,SQL Developer,JIRA,Autosys,NDM

Summit Information Systems, Corvallis, OR July’05 – Sep 07

Informatica Developer

•Understand existing business model and customer requirements.

•Used Source Analyzer and Warehouse Designer to import the sources and targets and the mapping designer to transfer data from sources to the target.

•Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.

•Experience in integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.

•Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.

•Improved session Performance by enabling property incremental aggregation to load incremental data into target table.

•Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader,SQL Developer, Autosys, Flat files, UNIX, Windows 2000.

Intel, Hillsboro, OR Jan 2005 to June 2005

ETL Developer

•Gathered business requirements from Business Analyst.

•Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.

•Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load

•Installed and Configured the Informatica Client tools.

•Worked on loading of data from several flat files to XML Targets

•Designed the procedures for getting the data from all systems to Data Warehousing system.

•Created the environment for Staging area, loading the Staging area with data from multiple sources.

•Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

•Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 5.1.2/7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX Shell Scripts.

Contact this candidate