SUMMARY

• An Information technology professional wif more TEMPthan 9+ years of extensive experience
• Internet and Automotive Media Industry
• Industry: - Tele Communications - Human Services - Whole Sale Banking- Payment industry -Product services.
• Functional Areas:- - Business Analysis -Database Analysis - Data Warehousing - Data Modeling - ETL
• Extensive experience working wif relational and dimensional databases models host on MS SQL Server, Oracle, Teradata, and Netezza database.
• Create and manage conceptual models, logical data models and Meta Data Dictionary using tools like ERWIN, Power designer, MS Visio
• Create and maintain physical data model constructed on normalized relational / dimensional and data vault techniques to process data upto 500 TB and 1 billion records
• Provide constant suggestions and improvements artifacts for the existing data models, to information and enterprise architects and helped to achieve and raise standard for the Data and its quality.
• Work wif DBAs and platform team to estimate the data ingestion volumes, the data retention policy based on the data sources like files and physical tables.
• Worked wif stake holder and product owner to brain storm and collect requirements during JAD sessions, to upkeep business use-cases and business requirements reviews.
• Engaged in compressive business analysis activities, leveraging various techniques like Business Process modeling, Role/Integration Activity Diagrams, UML Diagrams and Data flowing Diagrams.
• Provide data cleansing and data integration strategies and rules, based on the detailed data profile and analyses preform via techniques like Typology, Constant Comparison, Analytical Induction and Domain analysis.
• Design and develop work break down structure and paths for the development and data quality teams to work using Waterfall and Agile methodologies.

TECHNICAL SKILLS

Database: NETEZZA, Teradata 13.0,12.0,, Oracle 11g,10g/9i, MS-ACCESS SQL Server 2005, IMS

ETL Tools: Informatica Power Center 8.6,7.1, 9.1

Data Modeling Tools: Erwin 7.1, Microsoft Visio 2003

Reporting Tools: Business Objects, Crystal Reports

Languages: PL/SQL, SQL, UNIX SHELL Scripting, C#.Net

OS: Windows XP/2000, UNIX

Oracle E Business S: OIC,OM, CRM, GL, AP, AR

Version Control: PVCS, VSS,CVS

Schedulers: Dollar Universe, Cron

Deployment: KintanaOthers: MS Project, MS Office, Toad, SQL Developer, VI, Business Objects, SAS, Lotus Notes, WebEx

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler / Data Architect

Responsibilities:-

• Pre design data analysis and determine the feasibility of the requirements
• Designed and implemented 60+ data extraction views to extract data from source systems hosted on Oracle
• Designed Normalized subject area specified logical and physical data models for Sales Order, Customer and Inventory to meeting the data model Netezza EDW standards
• Designed data extraction and load strategies.
• Designed and implemented cross subject area 40+ information layer views for reporting.
• Review data mapping documents, RTM and ETL code

Data Feeds

Confidential

Responsibilities:-

• Analyze the requirement for the data feeds
• High Level Design Architecture for data feeds
• Designed and implemented a data extraction framework and reduce the repeated data processes sing and use 50% less space and made data available 2 hrs before agreed timing in SLA
• Determine and negotiating the data feed standards wif different vendors
• Negotiating the SLA for the delivery of the data feed to different vendors.Responsibilities in BI Operations team:-
• Part of BI team who is responsible for ensuring data Integrity and data availability for 70+ BI/Operation reporting applications on Netezza and Oracle platforms
• Trouble shooting failure and Data issue that are cross platform
• Propose solutions to improve performance and quality of data
• Analyze/Develop/QA and Deliver the enhancement request on the BI environment
• Develop complex Advanced Analytical SQL to support the Adhoc Reporting Data request
• Work wif various data sources like Site Weg logs/ Machine generated data/ MDM / Sales Order / Employee / Inventory / Product

Environment: Oracle 10g, NETEZZA, Informatica 9.1, Micro Strategy, UNIX, Power Designer

Confidential, Charlotte NC

ETL Architect

Responsibilities:

• Transposing the Business Requirements into the Technical Requirement and Requirement Traceability Matrix.
• Reviewing the Business requirements, Technical Requirement wif various teams like Architecture Team, Data Modeling, Development Team, Reporting team and QA team
• Working wif Architecture team to put down the Architecture for data sourcing, integration and moving the data to Enterprise Reporting layer
• Working wif Vendors on data transfer and encryption and security standard, SLA and Support agreements.
• Worked wif Business Team to draft the requirements for the data file which was delivered to vendors
• Validating the data model against the RTM document wif the Micro Strategy team
• Educating the business user and other technical/testing team about the data validation process and implementation
• Prepared the source to target data mapping document wif BR
• Prepared the data Load Strategies and Tidal Scheduling Designs
• Defining NZSQL coding standards, best practices and assisting in performance tuning NZSQL used in ETL
• Scripting ETL PDO SQL.
• Assisted the development teams on the Code review Sessions
• Supported the production release activities
• Supported the production issues not just related to data/ file transfer /Encryption and many more
• Conducted daily Scrum to prioritize the work effort and resource allocations
• Prepared Weekly PMO status Reports
• Assisted Project manager on the Building and maintaining the project plan and resource planning

Environment: Oracle 10g, NETEZZA, MS SQL Server 2005, Informatica 9.1, TIDAL, Flat File, Micro Strategy, MS Projects, ERWIN

Confidential, Nashville TN

ETL Analyst/Data Architect

Responsibilities:

• Understanding the existing business programs which are benefits, claims and eligibility and it functionalities through the Business Information Model sessions wif various group like business user, worker, external teams and internal technical teams.
• Working wif data conversion stake holders to understanding the needs, timelines, fallbacks and the criticality of the data.
• Performing the technical feasibility study for and providing guidelines in form of white paper on selection of tool to measure the quality of the converted data.
• Architecting a data validation frame work which would be integrated at various stages of the existing data conversion process.
• Drafting the Data Validation Architecture diagram not limited to source system, target system, nightly processes, jobs, applications, feedback etc.
• Educating the business user and other technical/testing team about the data validation process and implementation
• Defining the source and target data validation report formats which where CSV, business metrics report, performance report
• Introduced the concept of Rules set for Data Correction based on the data validation reports
• Defining and reducing the dependency on different source and target system
• Performing Walkthrough sessions wif internal and externals teams, not limited to business, product and techno functional etc.
• Extensively used complex SQL queries for mining and analysis of data in Toad and SQL Developer
• Redesigned Oracle post conversion PL/SQL framework to increase the performance and meet the batch window
• Helping project manager on estimation and status reporting for the business scrum meetings

Environment: Oracle 10g, IMS DB, Windows XP, UNIX, Microsoft Visio2003, MS Excel, Informatica 8.6.1, CVS, Toad, ERWIN

Confidential, San Leandro CA

Data Analyst/ Data Modeler

Responsibilities:

• Understanding the existing business, the whole sale products line and it functionalities in JAD session and walkthrough
• Understanding the customer functionalities, services and how internal users administer the application on the portal and review current operational data structures
• Leveraging the data analysis expertise and the business noledge gained by JAD session wif the different teams like business analyst, SMEs, Quality assurance analyst.
• Drafting the Data migration Architecture diagram not limited to source system, target system, nightly processes, jobs, applications, feedback etc.
• Educating the business and other technical team about the data migration process and implementation
• Drafting the logical approaches for the data analysis and data mapping which includes source and target system integration-System Integration Approach
• Define the source and target data formats like flat file, dump file, xml files for both 3RD party vendors and internal Confidential environment.
• Perform Data profiling activities to understand the existing data and its properties and generating report to support the defining Data Correction report.
• Defining full-data migration life cycle architectural best practice and ensure quality technical deliverables.
• Delivering the Data Mapping doc wif various levels information like High level rule, Resource Rules, data Transformations rules and Data correction rules.
• Defining ETL development strategy and ETL Framework which reduced the dependency on different system.
• Design the data models for the ETL source, intermediate and target tables
• Defining the source and target data validation rules, feedback process.
• Performing Walkthrough sessions wif internal and externals teams, not limited to business, product and techno functional etc.
• Educating different team on the data migration, data mapping and ETL Framework.
• Extensively used complex SQL queries for mining and analysis of data in Toad and SQL Developer
• Used Portal and its application/services to verify the migrated data.
• Responsible for the developing work breakdown structure for development team, estimation and status reporting.

Environment: Oracle 10g, MS SQL Server 2005, Windows XP, HP UNIX, Microsoft Visio2003, MS Excel, Informatica 8.6.1, CVS, Toad, NDM

Confidential, San Jose CA

Data Modeler/Data Analyst

Responsibilities:

• Analyzed the existing documentation, reporting applications using Zachman Framework approach, and research findings to prepare a recommendation through a logical approach that includes: drafting future state diagrams, technical topologies, detailing assumptions and preparing a risk assessment to support the integration process strategy.
• Working wif the reporting team and ETL team to understand the existing DB structure of OIC, OM, and the ETL process
• Data profiling to understand the existing data and its properties and generating report to support the defining Data quality and enrichment approach
• Validated the findings wif the application owners and internal both informal socialization and formal presentations.
• Defining the integration approach using the Ontology approach the existing system need reporting needs that would process report over about 10-20 million transactional data.
• Designed Dimension & Fact tables based on the needs reporting needs and CUBE structure
• Defining the Conceptual business views and logical data model using Visio
• Define the representation for the derived data using SQL reports from Teradata SQL Assistance.
• Define the Data Quality and assurance objective process to support the Data conversion and integration processes which were not just restricted to data source selection, input criteria, defining the boundaries, clarity and completeness for the output data.
• Defining the acceptance criteria which for measure and dimension in terms of statistical, confidence, tolerance and predictable intervals.
• Validated the data in the 3NF data model by manually executing the query through the data models.
• Defining the dependency wifin the ETL process and on the external ETL and the data.
• Defining and Design the Dollar Universe scheduler for the ELT execution process.
• Designing the Deployment plans working wif Kintana.

Environment: Teradata 12.0, Oracle 10g, Windows XP, HP UNIX, Microsoft Visio2003, MS Excel, Business Objects, WebEx, Windows XP, HP UNIX, Business Objects, WebEx, Dollar Universe, Kintana, PVCS.

Confidential, Houston TX

Data Modeler / Data Analyst

Responsibilities:

• Providing functional supporting information for key business initiatives as well as performing customer segmentations and analysis from existing production data stores. Also, include but not limited to work wif operational managers, analysts, and project managers for data analysis and reporting projects.
• Analyzed the business/data migration requirements, documentation, and research findings to prepare a recommendation through a logical approach that includes: organizing and tracking requirements from the source documents, preparing use cases, detailed solution explanation, drafting future state diagrams, technical topologies, detailing assumptions and preparing a risk assessment.
• Validated the findings and recommendation through the Data Retention process which gives persistent and reliable data.
• Worked wif Product Management teams to obtain an understanding of the varied business needs of multiple interrelated products. Developed the business process diagram using BPMN standard.
• Define the scope and data quality assurance for the data to be migrated.
• Determine if metadata in the source, actions must be performed to “initialize” content in the new system, external integrations that need to be maintained or created.
• Understanding the data structures, process and the input and output data and data quality elements.
• Producing the data mapping and the meta data documents for the new system which is the result of the text and predictive analytics.
• Implementing Kimball’s Bus architecture and designed Dimension & Fact tables based on the business process diagrams and bus matrix.
• Used Erwin to design multiple Conceptual and Logical Data Models and deciding on naming conventions.
• Define the entities and their relationships and the domain for the attributes.
• Used Erwin to design multiple Logical Data Model perform forward engineering and reverse engineering, creating DDL scripts, publishing model to PDF and HTML format, generating various data modeling reports etc.
• BETQ was used to run and Teradata SQL scripts to create physical data model.
• Defining the Data conversion process and data profiling approach which included data structure analysis, data mapping and conversion process design and execution which TEMPhas less data governance activities to be performed me.e. decommissioning.
• Creating the CRUD charts for multiple data models based on the data profiling reports which would be use for capacity planning and Index selections and creation
• Involved in the environment setups for the QA and UAT.
• Setting challenging targets, monitoring progress, and delivering results that meet or exceed expectations; taking on additional responsibilities; proactively tackling problems and trying new approaches.

Environment: Erwin 7, Teradata V2R5, Oracle 10g, SAS, Windows XP, HP UNIX, Microsoft Visio2003

Confidential

Oracle Developer

Responsibilities:

• System Requirement Spec, Detail Design Documentation
• Creating of Oracle objects Packages, Functions, Procedures, Sequence, Synonyms, Views
• Data migration scripts to load CSV files tables using SQL* Loader and TOAD.
• Extensively worked in SQL Performance query tuning creating Indexes and query rewriting
• Worked closely wif the Database Developers to ensure adherence of the database guidelines, standards and procedures and generated system test plans.
• Designed, Developed and documented the new reports and customizing existing reports.
• Involved in fine tuning the SQL queries using hints for maximum efficiency and performance.
• Involved in configuring the Web enabled Oracle reports and put it on the intranet.

Environment: Oracle 8i, Unix Shell scripts, Reports 6, Forms 4.5/5, PL/SQL, TOAD, Navigator-SQL*Net/Plus,VB.Net 2003, C#2003, Java