PROFESSIONAL SUMMARY:

• Having around 8 years of experience in software development with emphasis in Analysis, Design, Development and Implementation of various Data Warehousing, BI and Software Applications.
• Involved in ETL process from Architecture, Design development to testing and production environments.
• Extracted date from various sources like Flat files, Mainframe using Power exchange navigator data maps, Oracle and loaded it into Target systems like Teradata using Informatica
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Used Informatica Power exchange to connect to SAP,Mainframe sources to informatica and load in to required databases
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Created & Ran shell scripts in UNIX environment.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager
• Updated the odbc.ini file when required.
• Extensively used loader, FTP and Relational loading process in informatica tool to design and develop dataflow paths for loading transforming and maintaining data warehouse
• Involved in conversion of all the FTP scripts to NDM process. Most of the mainframe Files are NDM’d to UNIX/Linux and vice - versa to process the ETL process through Informatica
• Architected and developed Fast Load and MLoad scripts in control file, developed BTEQ scripts to process the data in staging server.
• Involved in identifying the performance bottlenecks and optimizing the time for Efficient data loading databases and processes for performance improvement.
• Performed all Kind of testing phases and uploaded the test cases in QA for user validation
• Experienced in troubleshooting Teradata scripts, fixing bugs and performance tuning.
• Strong development skills including the ability to work through the entire development life (SDLC) cycle from gathering requirements through implementation, development, testing, production, support and documentation of the complete project.
• Sound knowledge of Informatica Power center 9.1 with Teradata DB and hands in designing the mappings Sessions and workflow and writing Teradata SQL’s, BTEQ scripts, making use of Teradata utilities like, Fast Load, Fast Export, Multi Load and TPUMP
• Proficient in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture), Error Handling techniques for ETL process.
• Involved in Requirement Analysis, Functional Studies, Quality Reviews and Testing
• Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements
• Having good knowledge on SDLC and Data Warehousing Concepts.
• Thorough and extensive knowledge on Dimensional modeling, star/snowflake schemas
• Worked with SET and MULTISET tables for performance evaluation of the scripts
• Created tables with appropriate UPI and PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS
• Scheduling workflows and invoking them using Autosys scheduler using PMCMD Commands in Unix shell scripting
• Involved while upgrading the power center from one version to another in Confidential projects
• Generating the reports using Microstrategy framework
• Involved in technical design based on functional requirements
• Interacting with client/business to gather & understand the requirements
• Coordinating with offshore team on development activities on regular basis for efficient project delivery
• Impact analysis for the interface, design changes
• Extensively worked with Functional requirements and Source to Target Mapping documents.
• Worked on design of generic processes for Data extraction, Data Quality check and related transformations.
• Working with Aggregator,Joiner,Custom,Expression,Filter,Look up Transformations
• Working with Transform components
• Involved in Shell scripting to invoke the informatica workflows through Autosys to load the data in to Teradata or other database tables
• Working with Database components
• Working with aggregate and rollup functions for summarizing data
• Exposure to Enterprise Meta environment (EME)
• Involved in unit, integration and system testing
• Involved in implementation by supporting the production team for code migration
• Involved in Unit Testing, System Testing.
• Involved in User Acceptance Test
• Have thorough understanding of Teradata architecture.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata
• Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL
• Performance testing the queries

TECHNICAL SKILLS:

RDBMS: Teradata, Oracle 9i

Tools & Utilities: Informatica 8.X,Informatica 9.X, Mainframe JCL

Operating systems: Unix (AIX),LINUX Windows NT, Windows95/98/XP

Load Utilities: Multi Load, Fast Load, Fast Export, BTEQ, Tpump

Programming Languages: PL/SQL, UNIX Shell Scripting

Scheduling Tools: Autosys

Domain: Banking

Other tools: TOAD,SQL Assistance

PROFESSIONAL EXPERIENCE:

Confidential

Onsite Team Lead

Environment: Unix, Microstrategy,Oracle, Netezza

Responsibilities:

• Assist with Business and production support teams to understand the requirements for the Data warehouse applications 
• Create and maintain documentation of detail design documentation, flow diagram and engineering specifications, build changes, models, troubleshooting and supporting guides, system metrics, and overall project information.
• Work in coordination with the project team to set up the BI applications for configuration of Microstratagy Reports, UNIX shell scripting which also includes ETL set up tools like Informatica, Teradata technologies
• Following the SDLC project cycle to deploy the projects and set up the environments for development, testing and production
• Coordinated with offshore team leads,developers,designers for work assignment and execution
• Assimilate the work done by implementation vendor and transition the same to long term support teams
• Working closely with the Business and production support to get the requirements and generate reports, alerts for both the customer as well as the project team for immediate action on the required items
• Easy retrieval of Reports for the end client to make up the Business decisions
• Working on critical applications such as Audience Measurements and Finance metrics to meet the Customer needs

Confidential

Onsite Team Lead

Environment: Informatica, Unix, Teradata

Responsibilities:

• Involved in Architecture responsibilities like Assess requirements for completeness and accuracy
• Develop full SDLC project plans to implement ETL solution and identify resource requirements.
• Conduct impact assessment and determine size of effort based on requirements
• Determine if requirements are actionable for ETL team
• Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product
• Interacting with client/business to gather & understand the requirements
• Lead and guide development of an Informatica based ETL architecture. 
• Develop solution in highly demanding environment and provide hands on guidance to other team members
• Worked with business users to create the functional and Technical design for ETL process
• Coordinating with Onshore Dev team on development activities on regular basis for efficient project Delivery.
• Involved in technical design for the functional/business requirements.
• To verify if Informatica mappings and workflows were developed according to the requirement given
• Extract the data from different interface systems or sources and transform/ map the data to the target format and load into the Warehouse
• The data is pulled based on the business logic which is turned technically using INFORMAITICA tool
• Shell scripting is developed wherever is necessary.
• Performance tuning and maintenance of existing system.
• Implemented various Quality procedures and Adhered to the coding standards of the company related to the project
• Worked on enhancements of systems and change of code for the changing requirements from the business.
• Performing code review and resolving the queries.
• Involved in incorporating new changes as per business requirements, resolving existing technical issues. Also involved in Bug Fixation and Code promotion
• Writing Unit test plan and documented unit test results.
• Have been involved in Implementation, for migrating the Code to Prod Environment
• Have performed the testing responsibilities

Confidential, NC

Offshore Module Lead and Onsite team Lead

Environment: Informatica,Unix,Teradata,Autosys,Mainframe JCL

Responsibilities:

• Interacting with the client to understand the requirements. Analyzing requirements.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translate business rules and functionality requirements into ETL processes.
• Involved in Design of various workflows using Informatica.
• Developed data Mappings between source systems and warehouse components.
• Responsible for creating business solutions for Incremental and Full loads.
• Extensively used Relational, Loader process to load the file in to database using Informatica
• Populated the Teradata warehouse using utilities Fast Load, Multi Load, BTEQ and TPump.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Involved in design documentation.
• Responsible for creating Test cases to make sure the data originating from source makes it to the target in the proper format
• Coding, Unit Testing, implementation and reviewing the documents viz. Unit Test plan, test cases etc
• Have been involved in Implementation, for migrating the Code to Prod Environment
• Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture
• Resolve difficult design and develop issues. 
• Identify bugs when developers are not able to do so.