Summary:

• Over 13 years of experience in IT industry with the core competency as design, development, and administration of DW Data Warehouse software solutions using world wide cutting-edge data warehouse technologies: Teradata and BI Tools.
• Technically sophisticated with Computer Science and Engineering background and accomplished professional with demonstrated expertise in complete System Development Life Cycle SDLC : Requirements Analysis, Design, Development, Testing, Implementation, and Support.
• Proficient in full-suite of Teradata V2R5/V2R6/V12/V13.10/14.10 platform tools including Administrator, SQL Assistant, PMON, Teradata Manager, Viewpoint, TASM, Priority Scheduler, TSET, Index Wizard, Statistics Wizard, Visual Explain, Query Log, Locking Logger, DBSControl, GTWControl, CheckTable, ScanDisk, PackDisk, UpdateSpace, PDCR, BTEQ, FastLoad, MultiLoad, TPump, FastExport etc., and also have extensive experience as a DBA.
• Well-versed in Transact-SQL, Query Optimization, Dynamic SQL, Materialized Views and other system performance tuning techniques.
• Had great exposure to data modeling techniques like E-R modeling, Star schema and Snow-flake schema and also more knowledgeable in Conceptual, Logical and Physical data modeling concepts.
• Strong knowledge of big data technologies such as Hortonworks Apache Hadoop 2.0/2.1
• Extensively worked on MicroStrategy BI platform as an Administrator, an architect, a report developer, a web professional, and a migration lead by using MicroStrategy Desktop, Web, Administrator and I-server components.
• Had hands-on experience with Business Objects Platform in Windows environment.
• Skilled software engineer, with proven ability to lead and motivate teams to maximize the productivity.
• An accomplished database administrator with demonstrated success in designing and implementing database solutions that improve business functionality.
• Possess diversified technical background with Enterprise Systems solutions.
• Track record for diagnosing complex problems and consistently delivering effective solutions.
• Demonstrate commitment to leadership/teamwork through positive contributions in streamlining systems and providing superior customer service.
• Have extensive experience in understanding the business requirements and transform them into the technical solutions.
• Proficient at setting priorities and meeting goals.
• Evaluate stated requirements and expectations in terms of technical feasibility and cost outcomes.
• Possess strong analytical thinking, troubleshooting capabilities, and excellent interpersonal communication skills.
• Quick learner with ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.

Technical Skills:

• Operating Systems: Windows NT4.0/95/2000/2003/XP, MS DOS, and Unix/Linux
• Languages: C, C , .NET, Java-2, C
• Web Technologies: HTML, JavaScript, VB Script, ASP.Net, and XML
• Databases: Teradata V2R3/V2R4/V2R5/V2R6/V12/V13.10/14.10, SQL Server 2000, Oracle 7.0/8.0/9.0/10g/11g and Sybase 7.0
• Design Tools: UML, ERWin, MS Visio
• Data Warehousing Tools: MicroStrategy 7i/8.0.2, BusinessObjects Enterprise 6, Cognos Impromptu, Power Play
• Shell Programming: Perl, Python, Awk, Sed, Korn Shell, Bourne Shell, C Shell, PHP
• Big Data Technologies: Hortonworks Apache Hadoop 2.0/2.1

Professional Experience:

• Working as a Senior Teradata DBA from September 2012 to till date Client: Capital One, VA .
• Worked as a Software Engineer from November 2008 to September 2012 Client: IBM Global Services/Capital One, VA .
• Worked as a Data Warehousing Specialist from May 2005 to November 2008 Client: IBM Global Services/Capital One, VA .
• Worked as a Software Engineer for Intel Technology India Pvt. Ltd. from February 2001 to May 2005 Client: Intel Corp., OR .

Project Summary:

CONFIDENTAIL

Role: Senior Teradata DBA

Description: CONFIDENTAILprovides the day-to-day support for the installation, configuration, operation, maintenance, proactive monitoring, and administration of the Teradata data warehouse environments Development, Testing, Production and DR that run on SUSE Linux 10 Operating System. This includes undertaking both remedial and scheduled preventative maintenance, backup and recovery, implementation of production changes, issue resolution, on-call support, shell script job scheduling, defining the model for identifying, classifying, and managing the infrastructure components that make up the environment, and working within the frameworks provided by the Change Management, Incident Management, Release Management, Configuration Management, and Problem Management processes.

Responsibilities:

• Managed Teradata database and client software on Unix/Linux and Windows servers to provide for the accessibility and integrity of data in accordance with security requirements.
• Designed and implemented the Backup, Archive and Recovery BAR solution for the Teradata database systems.
• Performed the space management of database containers as per business user requirements.

• Monitored capacity utilization and performed capacity analysis and reviews to ensure sufficient capacity is provided to meet the forecasted requirements.
• Effectively supported the client's user security model by creating profiles, roles and assign appropriate access rights to them.
• Served as a technical lead for the configuration of Viewpoint application for the monitoring of Teradata systems. Configured SSL and LDAP user authentication mechanisms, system registration, data collectors, backups, roles manager, port lets, and metrics.
• Responsible for ensuring Teradata systems are 100 compliant against ITRO Information Technology Risk Office security standards by resolving all those issues OS and database levels reported in the bi-weekly scans through the automation scripts and change controls.
• Responsible for ensuring compliance to the change management and incident resolution in a production environment using the HP Service Manager.
• Optimized the performance of the Teradata platform by configuring Viewpoint, Workload Management TASM , PDCR, PMON and setting up the automated alerts.
• Performed the node level administration tasks: Sysinit, Tpareset, DBSControl, GTWControl, etc.
• Managed the roll-out of the Teradata Tools and Utilities TTU 13.10 over ETL servers and redefined the ODBC.ini and host file entries as per the new changes and performed the system access CLI, ODBC.ini validation using BTEQ and adhoc utility.
• Provided proactive first-response to system generated alerts such as capacity system availability , and ad-hoc user requests.
• Optimized the user query response times by adding statistics, proper indices and PPIs Partitioned Primary Indexes to the user tables.
• Led and performed the multiple DR Disaster Recovery exercises for Teradata systems to prove that we had technical capability in place to support the recovery of mission critical and essential services within recovery time objective 72 hours .
• Managed, reviewed, and approved product design and changes, also ensure proper product documentation.
• Managed CMDB Configuration Management Database setup and responded to CMDB audit reviews for Teradata systems Development, Testing, Production and DR .
• Performed key role as technical consultant during the migrations Hardware upgrades, cross-site migrations, Intra-System migrations, etc. . Prepared firewall and DNS entry forms for new systems. Created SQL scripts to generate a list of databases by a size and a table count.
• Played a vital role in the implementation of Dual Instance project. Created and reviewed the design document. Prepared DNS document for new system. Rolled out the ODBC.ini file over ETL servers. Did the proof of concept for the table restores using restore and copy options.

• Responsible for reviewing the Tech alerts and acting on them with the help of vendor.
• Installed and configured TPT Teradata Parallel Transporter components: API, Infrastructure, Export Operator, Load Operator, Stream Operator, and Update Operators on ETL servers.
• Managed and led the backup optimization efforts that reduced backup, replication and restore schedule completion times.
• Coordinated with the Teradata vendor and performed the infrastructure changes, hardware and database upgrades, patch management and resolved the system outage and disk failure issues.

• Resolved the user issues/tickets effectively using the Incident management and change management processes.
• Setup the automated job schedules for: CheckTable, ScanDisk, Packdisk and UpdateSpace utilities through the CRON tab.
• Designed and created daily automated health alert reports for Teradata systems and run them through the CRON job schedules.
• Performed instrumental role in project development from inception to implementation. Supported development and implementation of relational database environments. Interfaced with initial application project teams to ensure success.
• Effectively coordinated with the EMC team to resolve the hot swappable disk failure issues for Teradata systems using the change and incident management controls.
• Provided application development support for internal developers.
• Participated in 24/7 on-call support rotation.

Technologies: Teradata V13.10/14.10 Product Suite Administrator, SQL Assistant, PMON, Teradata Manager,TDWM/TASM, Priority Scheduler, TSET, Index Wizard, Statistics Wizard, Visual Explain, Query Log, Locking Logger, DBSControl, GTWControl, GTWGloabl, CheckTable, ScanDisk, PackDisk, UpdateSpace, PDCR, BTEQ, FastLoad, MultiLoad, TPump, FastExport, etc Viewpoint 14.01, PDCR 13.10, SUSE Linux Enterprise Server 10 SP3, Windows Server 2003, HP Service, Manager 9.20,NetBackup 6.5/7.5, TARA 14.00, EMC Data Domain 890, Cyber-Ark 6.0, WebEx 7.0, Perl 5.16.1, Aster 5.10, Hortonworks Hadoop 2.0/2.1 HDFS, MapReduce, HBase, HCatalog, Pig, Hive, ZooKeeper, Oozie, Sqoop, Hue, etc Python 2.4.2, Awk, Sed, PHP 5

CONFIDENTAILRole: Teradata DBA

Description: CONFIDENTAIL project provides the day-to-day support for the installation, configuration, operation, maintenance, proactive monitoring, and administration of all the Teradata database environments Development, Testing, Production and DR that run on SUSE Linux 10 Operating System. This includes undertaking both remedial and scheduled preventative maintenance, backup and recovery, implementation of production changes, issue resolution, on-call support, shell script job scheduling, defining the model for identifying, classifying, and managing the infrastructure components that make up the environment, and working within the frameworks provided by the Change Management, Incident Management, Release Management, Configuration Management, and Problem Management processes.

Responsibilities:

• Managed Teradata database and client software on Unix/Linux and Windows servers to provide for the accessibility, security and integrity of data in accordance with security requirements.
• Performed upgrades, patch maintenance and integration with vendor software on MP-RAS UNIX, SUSE Linux, and NT platforms.

• Optimized the performance of the Teradata platform by configuring Teradata Manager, PMON and Scheduler Manager Components and setting up the alerts.
• Designed and implemented the Backup, Archive and Recovery BAR solution for the Teradata database systems.
• Served as a technical lead for the configuration of Viewpoint application for the monitoring of Teradata systems. Configured for SSL and LDAP user authentication mechanisms, system registration, data collectors, backups, roles manager, port lets, and metrics.
• Performed instrumental role in project development from inception to implementation. Supported development and implementation of relational database environments. Interfaced with initial application project teams to ensure success.
• Managed and led the backup optimization efforts that reduced backup schedule completion times by 20 , replication schedule completion times by 40 , and restore job schedule completion times by 40 .
• Led and performed the multiple DR Disaster Recovery exercises for Teradata systems to prove that we had technical capability in place to support the recovery of mission critical and essential services within recovery time objective 72 hours .
• Performed key role as technical consultant during system migration from MP-RAS Unix to SUSE Linux. Recommended database and backup server network change that contributed to eliminating additional backup schedule changes with 35 decrease in support costs.
• Managed, reviewed, and approved product design and changes, also ensure proper product documentation.
• Initialized utilization of standardized ODBC.ini/host file templates on ETL servers which resulted in the successful execution of data loads into Teradata system in the DR environment.
• Monitored capacity utilization and performed capacity analysis and reviews to ensure sufficient capacity is provided to meet the forecasted requirements.
• Provided proactive first-response to system generated alerts such as capacity system availability , and ad-hoc user requests.
• Managed and led product and application design, development, testing through full product development life cycle, and release process.
• Identified opportunities for the improvisation of ETL Extract, Transform and Load , backup, and system monitoring processes and implemented them successfully.
• Managed project activities corresponding to the product development and directing the integration of required technical activities.
• Consulted and negotiated with the customers to effectively identify, write, and communicate detailed product requirements PRDs and specifications.
• Organized and managed customer advisory board, beta testing programs, and CMDB Configuration Management Database reviews.
• Established systems to provide limited access to vendors over extranet, resulting in dramatically reduced workload on accounting staff.
• Worked with NCR Teradata to resolve problems, outages to make sure the system is available for user access.
• Optimized the user query response times by adding statistics and indices to the user tables.
• Effectively supported the client's user security model by creating profiles, roles and assign appropriate access rights to them.
• Performed the space management of database containers as per business user requirements.
• Designed and created automated scripts for purging of data and cleaning up of security violations created by user activities.
• Managed the roll-out of the Teradata Tools and Utilities TTU 13.10 over the BAR Backup, Archive and Recovery servers and performed the integration testing among BAR servers.

• Responsible for ensuring compliance to the change management and defect tracking standards in a production environment using the HP Service Manager.
• Implemented infrastructure changes in accordance with the Change Management processes.
• Responsible for ensuring Teradata systems are 100 compliant against company's ITRO Information Technology Risk Office security standards.
• Resolved the user issues effectively using the Incident management and change management processes.
• Effectively coordinated with the EMC team to resolve the hot swappable issues for Teradata systems using the change management controls.
• Provided application development support for internal developers.
• Provided training to off-shore team.
• Participated in 7/24 on-call support rotation.

Technologies: Teradata V12/V13.10 Product Suite Administrator, SQL Assistant, Performance Monitor, Dynamic Workload Manager, Teradata Manager, Index Wizard, Statistics Wizard, System Emulation Tool, Work Load Analyzer, Priority Scheduler, Visual Explain, Bteq, Bteqwin, FastLoad, FastExport, Multiload, Tpump , Viewpoint 13.11, AWS 4.5, SWS 2.6, SUSE Linux Enterprise Server 10, Windows Server 2003, HP Service Manager 9.20, Netvault 8.2.1, NetBackup 6.5, TARA 13.01, EMC Console 4.1, Cyber-Ark 6.0, WebEx 7.0, Perl 5.16.1

CONFIDENTAIL

Role: Teradata DBA

Description: CONFIDENTAIL team provides the day-to-day support for the operation, maintenance, proactive monitoring, and administration of all Teradata databases Development, Testing, Production and DR . This includes undertaking both remedial and scheduled preventative maintenance, backup and recovery, implementation of production projects, on-call support, working within the frameworks provided by the Change, Incident and Problem Management processes.

Responsibilities:

• Worked closely with IT and business partners to provide solution definition to new and ongoing business requirements.
• Managed Teradata database and client software on UNIX and Windows servers to provide for the accessibility, security and integrity of data in accordance with security requirements.

• Optimized the performance of the Teradata platform by configuring Teradata Manager, PMON and Priority Scheduler components and setting up the alerts.
• Designed and implemented the Backup and Recovery BAR solution for the Teradata database systems.
• Effectively coordinated with the EMC vendor to resolve the hot swappable Disk issues for Teradata systems using the change management controls.
• Coordinated with the Teradata vendor to schedule system downtimes and to install and upgrade the software patches.
• Effectively supported the client's user security model by creating profiles, roles and assign appropriate access rights to them.
• Performed the space management of database containers as per business user requirements.
• Responsible for ensuring compliance to the change management processes in a production environment using the HP OpenView Service Desk.
• Resolved the user issues effectively using the Incident management and change management processes.
• Participated in 24x7 on-call support rotation.

Technologies: Teradata V2R6 Suite Administrator, SQL Assistant, Performance Monitor, Dynamic Workload Manager, Teradata Manager, Index Wizard, Statistics Wizard, System Emulation Tool, Work Load Analyzer, Visual Explain, Priority Scheduler, Bteq, Bteqwin, FastLoad, FastExport, Multiload, Tpump , NCR UNIX MP-RAS SVR 4.2, HP OpenView Service Desk 4.5 and Peregrine ServiceCenter 5.1.4.

Project 4:

CONFIDENTAIL

Role: Data Warehousing Specialist

Description: CONFIDENTAILTools Administration project supports the day-to-day operations of MicroStrategy application which runs on the NT Servers. The objective of this project is to provide installation, consultation and support for MicroStrategy software development, administration and support for the OLAP services.

Responsibilities:

• Setup the BI Business Intelligence Reporting platform for multiple environments development, pre-production, and production by installing and configuring the MicroStrategy server components: Intelligence Server, Web Server and Narrowcast Server.
• Created metadata shells for the I-servers and the Narrowcast servers.

• Interfaced with report developers to create and configure projects, user groups, users, security roles, security filters and ACLs Access Control Lists .
• Managed the rollout of the MicroStrategy client components: Desktop, Office, SDK Software Development Kit and Narrowcast Server to the development teams.
• Effectively administered the production, pre-production and development systems that use MicroStrategy platform: Intelligence Server, Narrowcast Server and Web Server.
• Setup the MicroStrategy Web Services to facilitate the end users to access MicroStrategy report data from the Office components: Excel, PowerPoint, and Word.
• Regularly monitored the MicroStrategy environment using: Job monitor, Project Monitor, User Connection Monitor, Database Connection Monitor, Schedule Monitor, Cache Monitor, Cluster Monitor, Database Instance Manager, Scheduler Manager and User Manager and optimized it.
• Managed the migration of different schema and reporting objects between the Development, Pre-Production and Production environments using the Object Manager and Project Duplication processes.
• Optimized the performance of the MicroStrategy system by enabling I-server level, project level and Web server level settings for Governing, Memory, VLDB Very Large Databases properties, Caching, Statistics, Security Filters and Data Export options.
• Monitored capacity utilization and performed capacity analysis and reviews to ensure sufficient capacity is provided to meet forecasted requirements.
• Effectively resolved the system wide issues by engaging with the Vendor.

• Managed Metadata cleanups at the I-server and project levels using the MDDoctor, Scan MD and Command Manager utilities.
• Configured the Enterprise Manager EM component to monitor and collect statistical data on MicroStrategy production environment.
• Performed the Narrowcast server migrations from the Development to Production environment.
• Created Narrowcast services and delivered report data to the customers using the Narrowcast objects: Control Documents, Documents, Information Objects, Publications, Question Objects, Schedules, Services, Subscriptions, and Templates.
• Performed the MicroStrategy platform upgrade from 7.2.2 version to 8.0.2 version and setup the MicroStrategy environment.
• Performed the Teradata V2R6 ODBC upgrade on MicroStrategy servers.
• Responsible for ensuring compliance to the change and incident management and defect tracking standards in a production environment using the HP OpenView Service Desk.

Technologies: Teradata V2R5 Suite Administrator, SQL Assistant, Bteq, Bteqwin , Oracle 8i/9i, SQL Server 2000, MicroStrategy 7.2.2/8.0.2 Product Suite Intelligence Server, Administrator, Desktop, Web, Narrowcast Server, Object Manager, Command Manager, Project Merge Wizard, Office, Project Builder, Configuration Wizard , HP OpenView Service Desk 4.5 and Peregrine ServiceCenter 5.1.4

CONFIDENTAIL

Role: BI Architect

Description: The purpose of CONFIDENTAIL project is to provide standard customs report for each site Malaysia, Cavite, Costa Rica wherein all data coming from SAP to be moved to EDW where it would be available to users at a flash when needed. With the reports available in EDW through the use of the MSTR tool, accuracy and productivity can also be achieved and one repository for all data elements used by the various sites when generating their monthly customs reports.

Responsibilities:

• Worked closely with the data modeler to understand the data of the project and help implement a data model solution that works effectively with MicroStrategy
• Worked closely with the business analysts to understand the report requirements to ensure that the appropriate schema objects are developed
• Worked with Business Analyst and Data Modelers for finalizing report requirements and deriving logical model for MicroStrategy metadata
• Prepared a LRDM Logical Reporting Data Model for project
• Writing ETL procedural code for new report requirements using Teradata loading utilities
• Be part of the internal reviews/design review sessions to provide architectural inputs
• Implemented the core schema in MicroStrategy, which would be used by report developers to develop reports very effectively
• Tracked and prioritized schema object development to meet the report development schedule
• Managed schema development changes/enhancements effectively
• Worked with the Data Modelers and ET L Developers to understand handoff schedules to identify impacts to the development timelines
• Helped the report developers to prepare LRDM for their own reports
• Provided technical support to the report development team during development phase
• Responsible to co-ordinate with EDS team for migration of reports from the Test to the Production environment
• Managed migration issues and metadata corruptions
• Analyzed the reports that have bad performance and come up with optimal reporting solution by recommending simplification options like aggregate tables, relationship tables etc.

Technologies: Teradata V2R5 Suite Administrator, WinDDI, SQL Assistant, Index Wizard, Statistics Wizard, Visual Explain, Priority Scheduler, Performance Monitor, BTEQ, FastLoad, MultiLoad, TPump, FastExport , MicroStrategy Desktop 7.5.2, MicroStrategy Web, MicroStrategy Administrator, MS Visio, SAP R/3, Business Objects Enterprise 6.

Project 6:

CONFIDENTAIL

Role: BI Architect

Description: CONFIDENTAILis to provide robust Decision Support Solution for the shipment data so that: Shipment data is available in EDW for Finished Goods and historical data can be archived from SAP record of origin. DQ Data Quality monitors are set for productivity, cost effectiveness and forecasting purposes using MicroStrategy.

Responsibilities:

• Worked closely with the data modeler to understand the data of the project and help implement a data model solution that works effectively with MicroStrategy
• Worked closely with the business analysts to understand the report requirements to ensure that the appropriate schema objects are developed
• Worked with Business Analyst and Data Modelers for finalizing report requirements and deriving logical model for MicroStrategy metadata
• Prepared a LRDM Logical Reporting Data Model for project
• Be part of the internal reviews/design review sessions to provide architectural inputs
• Writing ETL procedural code for new report requirements using Teradata loading utilities
• Implemented the core schema in MicroStrategy, which would be used by report developers to develop reports very effectively
• Tracked and prioritized schema object development to meet the report development schedule
• Managed schema development changes/enhancements effectively
• Worked with the Data Modelers and ET L Developers to understand handoff schedules to identify impacts to the development timelines
• Helped the report developers to prepare LRDM for their own reports
• Provided technical support to the report development team during development phase
• Responsible to co-ordinate with EDS team for migration of reports from the Test to the Production environment
• Managed migration issues and metadata corruptions
• Analyzing the reports that have bad performance and come up with optimal reporting solution by recommending simplification options like aggregate tables, relationship tables etc.
• Be part of MSTR code and design reviews and provide architectural inputs

Technologies: Teradata V2R5 Suite Administrator, WinDDI, SQL Assistant, Index Wizard, Statistics Wizard, Visual Explain, Priority Scheduler, Performance Monitor, BTEQ, FastLoad, MultiLoad, TPump, FastExport , MicroStrategy Desktop 7.5.1, MicroStrategy Web, MicroStrategy Administrator, MS Visio, SAP R/3, BusinessObjects Enterprise 6.

CONFIDENTAIL

Roles: BI Architect

Description: CONFIDENTAIL is one of the Big 6 DSS Decision Supporting Systems projects being implemented in Intel to support Finance department. The core objective of this program is to provide data for financial reporting and provide analytics to manage and support Intel's Capital Business.

Responsibilities:

• Worked closely with the data modeler to understand the data of the project and help implement a data model solution that works effectively with MicroStrategy
• Worked closely with the business analysts to understand the report requirements to ensure that the appropriate schema objects are developed
• Worked with Business Analyst and Data Modelers for finalizing report requirements and deriving logical model for MicroStrategy metadata
• Writing ETL procedural code for new report requirements using Teradata loading utilities
• Implemented the core schema in MicroStrategy, which would be used by other report developers to develop the report
• Worked with report developers to identify schema's required and implement the report effectively
• Be part of the reviews to provide architectural inputs.
• Tracked and prioritized schema object development to meet the report development schedule
• Managed Schema object development to schedule
• Documented the project schema in a means that assists the report development team's ability to understand the appropriate schema object to build reports
• Worked with the Data Modelers and ET L Developers to understand handoff schedules to identify impacts to the development timelines
• Recommended simplification options like aggregate tables, relationship tables etc for complex reports
• Documented all work products Design document, test plan, test cases
• Responsible to co-ordinate with EDS team for migration of reports from the Test to the Production environment

Technologies: Teradata V2R4 Suite Administrator, WinDDI, SQL Assistant, Index Wizard, Statistics Wizard, Visual Explain, Priority Scheduler, Performance Monitor, BTEQ, FastLoad, MultiLoad, TPump, FastExport , MicroStrategy Desktop 7.3/7.5, MicroStrategy Web, MicroStrategy Administrator, MS Visio, Visual Source Safe, SAP R/3, BusinessObjects Enterprise 6.

Project 8:

CONFIDENTAIL

Roles: Migration Lead

Description:

This project will redesign the current CONFIDENTAIL reporting environment to improve usability, productivity, and access to data. The objective of this project is to extend the functionality of the existing reports by redesigning, optimizing the solution with an alternative approach at the data model level and implement new report requirements as well.

Responsibilities:

• Analyzing the reports that have bad performance
• Collecting statistics for reports' performance
• Worked closely with the data modeler to understand the data of the project and help implement a data model solution that works effectively with MicroStrategy
• Optimizing the reports by using 'cooked table' solution
• Writing ETL procedural code for new report requirements using Teradata loading utilities
• Implemented the core schema in MicroStrategy which would be used by other report developers to develop the report
• Worked with report developers to identify schema's required and implement the report effectively
• Redesigned, developed and unit tested the reports
• Be part of the reviews to provide architectural inputs
• Migrated the reports from the development environment to the Testing environment
• Responsible to co-ordinate with EDS Enterprise Data Solutions team for migration of reports from the Test to the Production environment
• Managed migration issues and metadata corruptions

Technologies: Teradata V2R3 Suite Administrator, WinDDI, SQL Assistant, Index Wizard, Statistics Wizard, Visual Explain, Priority Scheduler, Performance Monitor, BTEQ, FastLoad, MultiLoad, TPump, FastExport , MicroStrategy Desktop 7.2, MicroStrategy Web, MicroStrategy Administrator, SAP R/3, BusinessObjects Enterprise 6.

CONFIDENTAIL

Role: Application Developer

Description: The objective of this tool is to find out the schema differences for data objects in different environments Development/Consolidation/Production . This tool would be used for maintaining the consistency in data definitions on different environments. This tool is a cost effective solution to code maintenance.

Responsibilities:

• Provided consulting to database Sybase, SQL Server, Teradata related queries
• Provided SQL scripts for data objects retrieval from data bases
• Coded some modules using .Net

Technologies: VB.Net, XML.Net, Teradata V2R3 Suite WinDDI, SQL Assistant, Index Wizard, Statistics Wizard, Visual Explain , Sybase 7.0, SQL Server 2000

CONFIDENTAIL

Roles: Application Developer

Description:

CONFIDENTAIL is one of the biggest finance systems' implementations in Intel's history. Its vision is to deliver the solutions that enable Finance to respond to the needs of the 100 e-Corporation. It is the first project that implemented using EDW Enterprise Data Warehouse architecture based on Teradata.

Responsibilities:

• Working with data modeler to understand the data flow and develop ETL Extract, Transform, Load code
• Writing ETL procedural code to upload data into EDW from source systems using Teradata loading utilities: Fast Load, TPump, and Multi-load
• Applying query optimization techniques to get the better performance
• Worked with the Business Analysts to resolve issues with the business requirements
• Designed and developed report code
• Created and maintained required documentation Design documentation, Development Checklists, Report settings, custom code
• Prepared Migration documents and handoff documents for MicroStrategy Migration Lead
• Followed the projects development standards, processes, and development Best Known Methods BKMs
• Communicated issues/risks related to delivery to schedule in a timely manner so that proper adjustments can be made to the project schedule
• Provided technical support during stabilization period

Technologies: Teradata V2R3 Suite WinDDI, SQL Assistant, Index Wizard, Statistics Wizard, Visual Explain, Priority Scheduler, Performance Monitor, BTEQ, FastLoad, MultiLoad, TPump, FastExport , MicroStrategy Desktop 7.1, MicroStrategy Web, MicroStrategy Administrator, SAP R/3

CONFIDENTAIL

Role: Application Developer

Description: CONFIDENTAIL is an enterprise-wide application package that has been adopted by Intel as the standard business software. ICe-SAP is the project in which Intel is using SAP to create an Internet-based solution for requisitioning and purchasing non-production goods and services.

Responsibilities:

• Responsible for writing SQL stored procedures to extract, transform, and load data from SAP and do make this cleaned data available in Corporate Data Warehouse CDW for end-user's report requirements
• Responsible for applying SQL optimization techniques like creating indexed views to improve the query performance
• Responsible for importing or exporting code from one environment to another using DTS Data Transformation Services utilities
• Monitored DW load cycles
• Developed CDW reports using Cognos Impromptu tool to support Intel's capital business needs across the globe

Technologies: SAP R/3, SQL Server 2000, Sybase 7.0, Cognos Impromptu 7.x, and Power Play 7.x