Education

• Master of Technology (Computer Science)

Certification

• Teradata Certified Master V2R5

Affiliations

• Project Management Institute (PMI)
• The Data Warehousing Institute(TDWI)

Experience Summary

10 years of experience in IT at various international locations like United States, Germany, Netherland and India in multiple roles such as BI Architecture and Design Lead and Mentor, Data Modeller, Data Analyst, Data Warehouse Consultant and Programmer/Application Analyst.

• Well experienced in defining, designing, integrating and re-engineering the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle with multiple Terabytes of size and various levels of complexity.
• Good understanding of project management methodologies and SDLC
• Proficient in data warehouse development practices and processes
• Working experience in implementing large Teradata DBMSs
• Experienced in master data management (MDM), Metadata management, data quality
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling with Teradata and Oracle
• Proficiency in overall ETL design (from staging to presentation layer), using market leading ETL tool Informatica.
• Expertise in Logical and Physical Data Model design using various modelling Toolslike Erwin 7.3 and Power Designer
• Expertise in working in Teradata V2R12.x systems and used utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump, Teradata SQL
• Experienced in building Data marts, data structures, data storages, data warehouses, data archives, and data analysis.
• Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
• Ability to work independently and as a team and able to effectively communicate with customers, peers and management at all levels in and outside the organization.
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Experienced in UNIX shell scripts to write wrapper scripts to call ETL Jobs
• Ability to achieve and be accountable for timely delivery of architectural results that support business needs
• Excellent Team player and Quick learner with positive attitude and self motivation.
• Excellent Communication, Interpersonal and problem solving skills and Implementation skills.
• Performed database management including updating, quality assurance, metrics, writing user documentation, table level specification documents, table process flow documents and training.
• Excellent PowerPoint, Excel, Word and Visio skills.
• Managed internal websites for ticketing system and writing html code.

TECHNICAL SKILLS

• Operating Systems: Windows XP, 2000, UNIX/Linux
• Modelling tool: Erwin ,Power Designer ,Visio
• Database: Teradata14.0, Oracle (8i/9i/10g)
• Teradata tools & Utilities query facilities: SQLAssistant, BTEQ ,PMON, Visual Explain ,Index Wizard ,View point
• Load & Export: FastLoad, MultiLoad, FastExport, BTEQ, OLE load, Oracle SQL Loader
• ETL: Informatica Pwer centre 9.1, CDC ,Power exchange, Datastage7.5
• Languages: C, C++, Java, Visual Basic
• Scripting languages: UNIXShell, Java Script, VB Script, Perl
• Scheduler: AutoSys ,Maestro ,Crontab
• Others: Business Objects, Crystal Report

Career Profile

With a vast experience in Data warehouse architecture and design, it is quite a unique experience to work with Frontier. The customer database is used in driving, analyzing and execution of marketing programs to improve customer retention and increase revenue. The data warehouse mandate includes logical and physical database design and implementation, business intelligence application development and rollout, and enterprise-wide information and reporting applications. The main challenge is to provide real time data to users with the quality and accuracy. Focused on design improvement, developing tools and database features that facilitate query-plan analysis and performance tuning.

Responsibilities

• Data Analysis and issue identification
• Propose Architectural design changes to improve data warehouse performance
• Visualize a data architecture design from high level to low level, and design performance objects for each level
• Troubleshooting database issues related to performance ,queries, stored procedure
• Create ER diagram and conceptual ,logical, physical data model
• Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance
• Accountable for Architect related deliverables to ensure all project goals are met within the project time lines
• Performs 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).
• Creates, validates and updates the data dictionary and analysing documentation to make sure that the information captured is correct
• Design logical and physical data model using Erwin data modelling tool and visio
• Architecture and design support to provide solution for business initiated requests/ projects
• Writing teradata sql queries to join or any modifications in the table
• Creation of customized Mload scripts on UNIX platform for Teradata loads
• Provide design for CDC implementation for real time data solutions
• Interact with business to collect critical business metrics and provide solution to certify data for business use
• Analyse and recommend solutions for data issues
• Writing Teradata BTEQ scripts to implement the business logic

Special Software Informatica Power Center, Oracle, Teradata ,Erwin,Crystal Reports

Aug 2007 - Dec 2010 Confidential, Plano TX , USA
Sr Data Architect

Confidential, is the largest wireless company in the United States, with approximately 79.6 million subscribers as of the second quarter 2009, who use the nation\'s largest digital voice and data network, carrying 16.8 petabytes of data traffic on an average business day to nearly every continent and country.
Confidential, Data Quality Program is to ensure the availability of the highest quality data in the BIDW environment that enables business value generation to BIDW stakeholders.Purpose of program is to have established processes in place where all BIDW data is objectively measured for accuracy, enabling proactive and continuous improvement.This program started with the business need to have established processes in place where key business metrics are certified through systematic validation processes.
Responsibilities

• Lead Data Architect for Design and development of data quality Tools
• Coordinate with cross-functional teams in different locations for quality data and analysis
• Architecture and design support to provide quality controls on critical business data sets
• Create ER diagram and conceptual ,logical, physical data model
• Design and implement data model for Data Quality Audits
• Develop data strategies and road map for Data Governance
• Perform analysis on business requirements , KPI and provide solution to certify data for business use
• Analyse the current data movement process and procedures
• Interact with technical and business analyst, operation analyst to resolve data issues
• Creation of BTEQ, Fast export, MultiLoad, TPump, Fast load scripts for extracting data from various production systems
• Develop source to target mappings
• Profile Data coming from different source systems coming from different countries and performed Data Quality Audit
• Analysed massive and highly complex data sets, performing ad-hoc analysis and data manipulation
• Define and maintained metadata, data sources and set up Validation Rules
• Create the Customer and Product hierarchies
• Develop a scalable architecture for staging and loading data using Teradata database
• Provide data quality process improvement strategy
• Analyse and recommend enterprise data warehouse data quality controls
• Design and development of data controls
• Data modelling for data quality tools design

Special Software Informatica Power Center, Oracle, Teradata ,Erwin,BO,Coldfusion

Apr 2006- Jul 2007 Confidential, Amsterdam , Netherland
Lead ETL Architect

The project involves the analysis, design and development of Master data layer for Enterprise data ware house solution of ABN Amro Bank. ABN Amro expressed a need to centralize the management information in one environment (Enterprise Data Warehouse) and standardize tooling and data definitions, as the current management information environment is not efficient and (in the long turn) not able to support the business needs..MDL is data provider of the EDW and will deliver consistent data to solve the current problem of inconsistent management reports.
The Hybrid Interface system was used within, and is a part of, the Banking Data warehouse Netherlands (DWN) architecture. The DWN architecture defines standards and guidelines concerning the data warehouse and complies with the policies, standards and other (e.g. technical) architectures within the bank. Purpose of the project was to change the Hybrid Interface to a more generic solution.
Responsibilities

• Providing strategic and tactical direction to the team.
• HLD and LLD design of the system, development and debugging of the Informatica mappings
• Develop high performance semantic / presentation layer for reporting and analytics
• Design ETL specs for various MLOD ,Bteqs
• Modification of Data mart for storing Error metadata for Rejected Records along with the Rejected Records
• Document and store the error codes generated for each error are classified based on the business rules implemented within Hybrid Interface
• Provide solution approach documentation and functional requirement gathering
• Write Bteq and Mload scripts to load data from Oracle to Teradata
• Providing strategic and tactical direction to the team.
• Determining the resource requirements and hiring the required resources for the projects.
• Functional requirement gathering
• Define the schema, staging tables, and landing table, configuring base object (customer, address, and Organization), foreign-key relationships, query groups and queries
• Create the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy
• Design and development of Hybrid Interface under BASEL II Program
• Changes in software to perform data validations in the mappings before the mutation logic applied
• Conduct training sessions with business and development stakeholders on data models and data strategies

Special Software Informatica,Teradata , DB2,Test Director ,Erwin

May 2004- Mar 2006 Confidential, Munich, Germany
Technical Consultant

Confidential, have implemented various i2 modules to help in production planning of the respective products that they make. These Modules are interconnected to each other & to various other transaction systems. COM / BenQ-does not have necessary expertise to manage the day to day working of these modules and to technically implement the additional requirements as required for their business.
COM / BenQ does not have necessary expertise to manage the day to day working of these modules and to technically implement the additional requirements as required for their business.SISL is therefore engaged by Siemens COM / BenQ to maintain the software and to handle the requirement change management.Maintenance of the Siemens Networks data warehouse solution and change request management for Siemens Networks Germany
Responsibilities

• Post production implementation support responsibility
• Customized Database objects like PL/SQL Procedures, Functions, and Packages
• Create UNIX Scripts to Manipulate and Load the data
• Designed and implemented stored procedures and triggers for automating tasks in SQL
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Unconnected lookup transformations.
• Used Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables.
• Providing strategic and tactical direction to the team
• Responsible for Technical implementation of the change request solution
• Supporting enterprise data warehouse and ETL development activities
• Analysis of change request
• Working in the Production Support environment
• Designing the technical solution of Business requirement
• Analysis of the possibilities of solution enhancement
• Developed UNIX Shell Scripts for scheduling the sessions in Informatica
• Implement the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database

Special Software Informatica, Supply Chain Planner, Demand Planner ,SAP,Oracle,Power Designer

Project is multi-purpose SMS receiving and broadcasting system. This includes bill request, Emergency messages, Ring tone, and Greeting download facilities. At the same time
Client can use this service for commercial purposes too. This application is for administrative purpose too, to maintain the records of SMS receiving and sending, bill information of subscribers and many other functionalities too.
Also project deals with comprehensive touch screens information KIOSK for BSNL. This software includes complete information of BSNL including complaint registration, bill payment by Cheque/DD, duplicate billing, Form printing and many more facilities for fixed line and mobile (GSM and well as CDMA) users
Responsibilities

• Customized and developed Database objects like PL/SQL Procedures, Functions, Packages, and Views Involved in database design/preparing SQL scripts to support the larger databases
• Reviewed and analysed Functional requirements, Mapping documents
• Analysed Requests for Changes and new Business requirements
• Prepared Technical specifications, detailed Design documents Writing the SRS
• Created detailed documentation using Data Flow diagrams, rule-sets/thresholds, and ETL mappings Involved in Unit and Integration Testing

Special Software Sun One Studio,Oracle ,Visual basic , Crystal Report

Thesis
Data warehouse management system for Seed shop

Training / Continuing Education Summary

PMP Study group

PMP certification guide/PMPOK

36 Week

SCM Training ( IIT, Mumbai)

Supply Chain Management concepts

12 days

Informatica training ( I2 Banglore)

Informatica designer,repository manager,workflow manager

10 days

E Commerce (NIIT ,Nagpur)

All the E Commerce coverage
XML,HTML,Oracle,Java,swing,RMI,Net beans etc.

6 months