SUMMARY:

• Over all 10 years of Information Technology experiencein Business Analysis, Design, Development and implementation of Business Applications, Master Data Management, Data Modeling, Business Process Reengineering (BPR), Project Management, Data/System Analysis and ETL development.
• Excellent knowledge on building Logical/Physical Models and design database as per Physical Model.
• 8+ Years of Experience in Teradata.
• Having main area of expertise is Informatica, Teradata and Oracle.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Erwin 7x/6x/5x, ER Studio 7.6.1/7.5.1./7.0.
• Strong analytical, problem - solving and communication skills, with particular emphasis on clear, detailed Business Requirements and exposure to end to end DW Implementations.
• Worked on solutions with business and technical metadata that is consistent across all its deliverables and components. Business Metadata relates to the informational model, data dictionary, business logic and other details related to the information presented to the end users.
• Worked on mapping between source and target data, as well as performing logical model to physical model mapping and mapping from third normal form to dimensional (presentation layer).
• Expertise in maintaining data quality, data organization, data profiling, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensively used ETL methodology for supporting data extraction, transformation and loading process, in a corporate-wide-ETL Solution using Informatica.
• Extensively worked on Teradata tools and utilities like Teradata Parallel Transporter (TPT), FastLoad, FastExport, Multiload, TPump, BTEQ.
• Experience in optimizing long running report queries and the database structures that support the reports using Teradata tools viz DBQL, Priority Scheduler, Teradata ViewPoint, SQL Assistant and Teradata Administrator
• Experience in analyzing query performance and tuning, physical node behavior, and amp distribution using Teradata Manager and PMON.
• Excellent hands on experience on implementing performance tuning techniques using Join indexes(JI), collecting statistics, partitioned primary indexes(PPI).
• Industry experience in Banking & Finance (Commercial Finance) domain.
• Hands-on experience in large-scale Data Warehousing projects. Expertise in using Business Objects 6.x/XIR2/XIR3/BOBI 4.0, Developer Suite products like Universe Designer, Web Intelligence, CMC, CMS, Desktop Intelligence Broadcast Agent, Excelsius, Info view, Crystal Reports XI, Import Wizard, Publishing Wizard, Report Conversion tool, Report Migration Wizard, Software Inventory Tool, Universe Builder, Business view manager, Data source migration wizard.
• Lead the development and production support activities for smooth pre and post deployment activities working as Onsite Project/Technical Lead.
• Extensive experience in all stages of Data warehouse development with strong coding, debugging and analytical skills.
• Worked with Source system implementers performing root cause analysis, GAP analysis and produce high level and detail level specification documents and functional specifications accordingly.
• Excellent group and individual based problem solving and decision making skills.

TECHNICAL SKILLS:

Software: Teradata, Informatica 8.x/9.x, Data Modeling, Oracle SQL, PL/SQL, C/C++, Business Objects, Erwin 7x/6x/5x, ER Studio 7.6.1/7.5.1/7.0, Power designer, Abinitio, kintana, HP Quality Center, PVCS, $Universe.

Reporting tools: Business objects, Cognos, Crystal Reports, SQL Server Reporting services(SSRS)

Operating Systems: Microsoft Windows XP, NT, 2000, 98 & 95,UNIX

Markup Language: HTML

Processes/Technologies: Rational Unified Process (RUP), Clear case, Use Cases, Workflow and UML.

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

• Developing and maintaining thorough business knowledge of source data in Enterprise Data Warehouse supporting clientXM’s Enterprise Marketing Management (EMM) solution
• Performing source target mapping in support of report and warehouse technical designs
• Implementing business-driven requirements using Informatica
• Working closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs.
• Conducting ETL performance tuning, troubleshooting, support and capacity estimation
• Developing, adhering to, and being a proponent for Data Warehouse development standards, including ETL standards and best practices
• Working with business intelligence analyst and project teams to understand analysis and reporting requirements; ensuring work product meets users’ needs
• Creating and maintaining logical data maps identifying information linkages between critical operational systems and Enterprise Data Warehouse
• Maintaining thorough understanding of business processes and ETL processes, and identifying efficiencies and needed controls to fine-tune ETL operation
• Supporting validation and testing of developed workflows and business intelligence system integration testing
• Providing documentation for all developed ETL processes, including process flow and data mapping
• Developing audit reporting and quality improvement processes to ensure accurate and consistent delivery of data
• Acting as liaison between various business units and technology
• Work with BI Architecture and Innovations group to craft solution for data integration and business layer
• Establish and maintain self-service business layers to support campaign activities, business intelligence and analytics on the customer/household data
• Integrate new data sources for clientXM’s EMM solution - structured/semi-structured and unstructured data from various sources in support of the electronic marketing management tools and other related systems
• Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures
• Manage the development of data controls to ensure the integrity of the marketing database.
• Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data.

Confidential

Data architect / ETL architect /Teradata Developer

Responsibilities:

• To fetch policy 5.0 exposures to a new or existing GECS customer.
• Determine aggregate enterprise-wide risk exposure to commercial customers.
• Manage existing customer exposures in conducting risk screening for soliciting new business from an existing or former GE Capital customer.
• Worked on gathering report requirements based on high level discussions with management and detailing fields to extract layout to extract data from various source systems.
• Develop and maintain conceptual, logical models based on Teradata FSLDM and design physical database architecture adhering to company wide data, database standards and policies.
• Collaborating with the Enterprise Architecture team to establish and implement strategic initiatives and working with both technical and business stakeholders to understand the data needs for projects.
• Performance tuning for Teradata SQL statements using Teradata EXPLAIN
• Extensively worked on reports generated based on (as applicable) the obligor, lessee, counterparty, guarantor, credit tenant, real estate property name, unique ID and address for all the GE capital business requirements.
• Generating and analyzing monthly expense accruals and prepare/submit reconciliation.
• Involved in Implementation of Change Data Capture (CDC's), Data Modeling frequently from the source systems using the Power Exchange Utility.

  Conversion of all the Oracle Functions and Procedures to Teradata BTEQ/SQL scripts.

• Involved in loading of data into Teradata, Teradata Macro Data Modeling from legacy systems and flat files using complexMLOAD scriptsand FASTLOAD scripts.
• Actively involved in Database designs, Data Modeling, Identifying the Fact tables and Type 2 & 3 slowly changing dimensional tables for the warehouse.
• Resolving the issues reported by business users by preforming root cause analysis and follow-up with development teams for fix and explaining results to requestors, where necessary.
• Applying technical knowledge to ensure compliance of SOX and other external regulatory policies
• Developing Data Modeling and analyzing existing Teradata SQL and load processes, identifying improvement opportunities, indexes, partitioning strategies and making recommendations to improve the processes and load scripts.

Confidential

ETL architect /Teradata Developer, San Jose, CA

Responsibilities:

• Lead the Development for Cisco Fin BI Revenue BO Subscription.
• Identifying the GAPs and accommodating them in the model for end user reporting.
• Worked on end user presentation layer physical structures to support end user reporting needs.
• Worked on mapping between source and target data, as well as performing logical model to physical model mapping and mapping from third normal form to dimensional/Presentation layer.
• Extensively Worked on reconciliation of metrics comparing the results between old legacy systems built on Oracle and newly built Teradata data warehouse.
• Resolving the issues reported by business users by preforming root cause analysis and follow-up with development teams for fix and explaining results to requestors, where necessary.
• Developing and analyzing ETL jobs and load processes, identifying improvement opportunities, indexes, partitioning strategies and making recommendations to improve the processes and load scripts.
• Worked on Performance tuning techniques using Join index, Partition primary index, collecting statistics.

Confidential

ETL analyst/Teradata Developer

Responsibilities:

• Preparing High Level & Detail Design Documents.
• DevelopingInformatica Mappings and workflows.
• Preparing Unit-Test Cases and validating source and target data.
• Working on the Scheduling Tool ($Universe) to schedule the ETL jobs
• End to end ETL Development & unit testing of the ETL jobs.
• Developing the schedules for ETL jobs
• Maintaining Quality Assurance documents and supporting testing phases.
• Giving Knowledge Transfer to Support and maintenance team about the application developed.
• ETL methodology for supporting data extraction, transformation and loading process, in a corporate-wide-ETL Solution using Informatica.

Confidential

ETL developer

Location

Responsibilities:

• Preparation of the technical specifications.
• ETL development and enhancements.
• Involved in Coding, Unit Testing, and System Integration Testing for the enhancements and new projects.
• Deciphering index codes based on Business Requirement and loading into warehouse.
• Preparation of Deliverables and release note from the project module perspective.
• Unit Testing and End-to-end data loading activities.