SUMMARY

• Around 8+ years of IT experience in Data warehousing and Business Intelligence with emphasis on Business requirements analysis, Application design, development, testing, implementation and Maintenance of client/server Data warehouse and DataMart systems in Financial, Banking, Retail, Insurance and Pharmaceutical industries.
• Involvement in all phases of SDLC - System development Life Cycle from analysis and planning to development and deployment.
• Strong Experience in Logical and Physical Data Modeling using Erwin tool including Star Schema and Snowflake Schema, designing of Data Mart, Fact and Dimension Tables.
• Hands on experience in Teradata SQL, Tools & Utilities (FastExport, MultiLoad, FastLoad, Tpump, BTEQ and Queryman).
• Extensively worked on Viewpoint for Teradata to look at performance Monitoring and performance tuning. Well versed with Teradata Analyst Pack including Statistics Wizard, Index Wizard and Visual Explain.
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins in Teradata database
• Well versed with understanding of Explain Plans and confidence levels and very good understanding of Database Skew. Knowledge in Query performance tuning using Explain, Collect Statistics, Compression, NUSI and Join Indexes including Join and Sparse Indexes
• Experience in design and develop ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica power center (9.6/9.5/8.6/8.5 ).
• PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in Mapping Server/parallel Jobs in Informatica to populate tables in Data warehouse and Data marts.
• Developed parallel jobs using various stages like Joins, Merger, Funnel, Lookup, Sort, Transformer, Copy, Remove duplicate, Filter, Peek, Column generated, Pivot and Aggregator stage for grouping and summarizing on key performance indicators used in decision support systems.
• Extensively used Mapping Variables, Mapping Parameters, and Dynamic Parameter Files for improved performance and increased flexibility and also worked with XML Sources & Targets.
• Experienced in Developing and Monitoring Batch Jobs using UNIX KRON, AWK, UNIX Shell Script and PERL Scripts.
• Experienced in Cognos 10, 8, ReportNet with Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Experience in interacting with endusersto gatherrequirementsfor reporting.
• Experience in using Automation Scheduling tools like Control M and Autosys.
• Experienced in working with off-shore and On Site model
• Experience of 24x7 production support

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), power center Information Analyzer

Languages: SQL, PL/SQL, C, C++, C#, UNIX Shell Scripting, visual basic

Databases: Teradata T14/T13/T12/V2R6, Oracle8.i/9.i/10g/11g, SQLserver2000/2005, MS Access, DB2

DB Utilities/Tools: BTEQ, fast Load, Multi Load, Fast Export, T Pump, SQL *Loader, Teradata Manager, Teradata Query Manager, Teradata Manager, Teradata Administrator and Teradata SQL Assistance,Rational UML, ERWIN 3.5/4.0, ER Studio, Visual Studio.net, Visual Interdev, Visual Source Safe, MS Office, MS Front Page, Win Runner, Load Runner

Scheduling Tool: Control-M, Autosys

Modeling Tools: Visio and Erwin

Operating Systems: HP-UX, Sun Solaris, Red Hat Linux, Windows2003/2000/XP/NT, IBM AIX,MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Teradata/ETL Developer

Responsibilities:

• Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements.
• Provide a technical leadership to technical resources and customers to meet project timelines and ensure project objectives are met.
• Extensively worked with Parallel Extender/Orchestrate using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Used Informatica Designer for developing various jobs to extract, cleanse, transform, integrate and load data into Data Warehouse.
• Used Informatica Director to schedule running jobs, monitoring scheduling and validating its components.
• Used Power center Manager for managing repository, Imported and Exported items between different Informatica systems or exchange metadata with other data warehousing tools.
• Used debug/development stages for troubleshooting activities in jobs.
• Used Datasets and Lookup file sets instead of flat files to store intermediate data and reference data for improving performance of Informatica jobs.
• Accomplished data movement process that load data from DB2 into Teradata by the development of Korn Shell scripts, using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Winddi and Queryman reviewed and improved the design of Extract and Load specifications.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited).
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Provided sizing, security and configuration assistance on Ratings Stream data mart.
• Supported other ongoing projects: Software Upgrade project from Teradata T13 to T14.
• Create and execute test plans for Unit, Integration, and System test phases.
• Designed and Developed the Framework Manager models and Published into the Cognos Connection.
• Designed & developed the reports using Cognos 8 Report Studio, Query Studio, Analysis Studio reports.
• Developed various reports using functionalities like Render Variables,ConditionalBlocking, Cascading Prompts, and Conditional Formatting.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Used SQL Server ManagementTool to check the data in the database as compared to the requirement given.
• Handled Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Early Data Inventory, Data Profiling, Data Mapping, and Programmer Specs Assisted SIT/UAT testers in optimizing testing scripts and to ensure data accuracy and integrity.
• Assisted in troubleshooting the Production support problems, which are related with Teradata database and involved in Performance tuning in analysis and identify potential data issues, provide root cause analysis and ensure to apply fixes at source, target, mappings, and at system levels.

Environment: Teradata T14/T13,Informatica Power Center8.6.1,Cognos 8.3/8.4,Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange,SQL Assistant, BTEQ, FastLoad, Multiload, FastExport, Putty, UNIX shell.

Confidential, Charlotte, NC

Teradata/ETL Developer

Responsibilities:

• Scheduling the sessions to extract, transform and load data in to warehouse database on business requirements
• Wrote numerous BTEQ scripts to run complex queries on the Teradata Database directly rather than implementing the same in Datastage, to reduce the time it takes for successful execution.
• Work closely with the Architecture and Design team to ensure all the required information is being provided and to regularly access the impact of design on development.
• Involved in JAD sessions for the requirements gathering and understanding.
• Developed Test cases for Unit Testing of the Mappings, and also was involved in the Integration Testing.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ERWIN
• Sorted the Extraction from heterogeneous source systems, like Oracle, Teradata internal and external flat files and building of the Transformations and Loading formatted data into the Multi-file and Serial files during the intermediate and the final stages of the processes (ETL) using datastage.
• Dynamically set query priorities using Teradata scheduler. Capacity Planning: Re-size storage and spool space proactively, to accommodate growing data content.
• Performance tuning of Report queries using Teradata explain results.
• Performed Data validation and Data integrity checks on the data mart.
• Working with QC and UAT teams for respect team approvals.
• Working with offshore team for development and administrative activities.
• Extracted DTS (Data Transformation Services) packages from the SQL server 2000.
• Developed Datastage SCD Type-I, Type-II and Type III stage jobs and tuned them for better performance.
• Automated related tasks by developing UNIX shell scripts used to maintain the Core EDW.
• Worked on loading the data from mainframe PS files into Teradata staging tables with Teradata utilities Multi load (Mload) and Tpump. Performed post load data quality checks
• Extensively used SVN andChangeman for versioning the components.
• Created multiple reusable macros to validate the data post Model Change and Post Load.
• Replaced full table statistics with Sample statistics and reduced the usage of Teradata resources.
• Providing warranty production support and working on enhancements.

Environment: Teradata T13/T12, Oracle 10g, Datastage 9.1, Putty, Control-M 6.3.01/7.0, Windows XP, UNIX, Quality Center, HP service Manger

Confidential, Hartford, CT

Teradata Developer

Responsibilities:

• Worked on loading of data from several flat files sources using Teradata FastLoad and MultiLoad.
• Writing teradatasql queries to join or any modifications in the table.
• Transfer of large volumes of data using Teradata FastLoad, MultiLoad and T-Pump.
• Database-to-Database transfer of data using BTEQs within Teradata system.
• Fined tuned the existing mappings and achieved increased performance and reduced load times for faster user query performance.
• Used Trillium for Data Quality checking, data cleansing, data standardization, and matching (Converter, Parser,Geocoder, Matcher)
• Name parsing and standardization performed through Trillium supplied tables built at Harte Hank’s data processing center
• Address parsing and correction through Trillium postal tables and geocoding modules
• The file will get sent through the Trillium Converter, Parser, Geocoder, and winkey processes to cleanse, parse, and validate address information
• Developed UNIX shell scripts for data manipulation
• Involved in writing proactive data audit scripts.
• Involved in writing data quality scripts for new market integration

Environment: Teradata T12, Teradata Administrator, SQL Assistant (QueryMan), BTEQ, FastLoad, Multiload, FastExport, MVS, TSO/ISPF 6.1

Confidential

Teradata Developer

Responsibilities:

• Involved in High-level design, coding, testing and implementation.
• Created views on top of Teradata tables based on business needs. Good in implementing privacy views for any requirements
• Writing teradatasql queries to join or any modifications in the table.
• Participated in the development team for writing procedures and functions.
• Participated well in design of database schema and wrote stored procedures for database.
• Involved in Tuning SQL statements in existing programs and created new SQL queries for projects as part of creating program Specs.
• Developed forms Coded, tested and implemented components for querying and updating the database.

Environment: TeradataV2R5, Unix Shell Scripts, SQL Assistant, BTEQ, FastLoad, Multiload, FastExport, FTP, Putty, Word, Excel, PowerPoint, Visio, Erwin, Windows XP