SUMMARY:

• Over 14 years of experience in IT industry with the core competency as design, development, and administration of DW (Data Warehouse) software solutions using worldwide cutting - edge data warehouse technologies: Teradata, ETL, and Big Data.
• 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/V 13.10/ 14.10/15.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.
• 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.
• Well-versed in Query Optimization, Materialized Views and other system performance tuning techniques.
• Over two years of experience with the installation and configuration of Hadoop, Map Reduce, Hive, Pig, Sqoop, storm, solr, spark, etc.,
• Good experience with with NoSql databases like Cassandra, MongoDB and HBase
• An accomplished database administrator with demonstrated success in designing and implementing database solutions that improve business functionality.
• Possess diversified technical background with Enterprise System 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.
• Evaluate stated requirements and expectations in terms of technical feasibility and cost outcomes.
• Possess strong analytical thinking, troubleshooting capabilities, and excellent interpersonal communication skills.
• Skilled software engineer, with proven ability to lead and motivate teams to maximize the productivity.
• Quick learner with ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.

TECHNICAL SKILLS:

Operating Systems: Windows NT 4.0/95/2000/2003/ XP/10, 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/V 13.10/ 14.10/15.10, SQL Server 2000, Oracle 7.0/8.0/9.0/10 g/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, Tableau 8.2

Shell Programming: Perl, Python, Awk, Sed, Korn Shell, Bourne Shell, C Shell, PHP

Big Data Technologies: Hortonworks Apache Hadoop 2.1/2.2, MongoDB, HBase, Cassandra

PROFESSIONAL EXPERIENCE:

Confidential

Senior Teradata DBA

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 compliance to the change management and incident resolution in a production environment using the Autotask.
• Defined, tested, and scheduled the load jobs through the Univiewer tool
• Optimized the performance of the Teradata platform by configuring Viewpoint, Workload Management (TASM)/TIWM (Teradata Integrated Workload Management), PDCR schedules, 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) 14.10 software over ETL servers and OBIEE servers;
• 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 utilities.
• Performed the data migration tasks between 13.10 and 14.10 Teradata database systems.
• Optimized the user query response times by adding statistics, proper indices and PPIs (Partitioned Primary Indexes) to the user tables.
• Played a key role in performing the database upgrade from 1 .10 version
• Managed, reviewed, and approved product design and changes, also ensure proper product documentation.
• 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.
• 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.
• Provided application development support to Datastage, Informatica, and SOA ETL teams.
• Configured AUTOSTATS component for Teradata systems through the Viewpoint; Redefined the existing STATS collection schedules in the Stats Manager.
• Converted the existing TASM configuration into TIWM configuration
• Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.
• Configured MySql Database to store Hive metadata.
• Responsible for loading unstructured data into Hadoop File System (HDFS).
• Exported data from Teradata into Hadoop HDFS for the data analysis
• Participated in 24/7 on-call support rotation.

Technologies: Teradata 14.10/15.10 Product Suite (Administrator, SQL Assistant,TIWM, TSET, AutoStats, Query Log, Locking Logger, DBSControl, GTWControl, GTWGloabl, CheckTable, ScanDisk, PackDisk, UpdateSpace, BTEQ, FastLoad, MultiLoad, TPump, FastExport, PDCR, etc.,), Viewpoint 15.00, SUSE Linux Enterprise Server 11 SP1, Windows Server 2003,NetBackup 7.5, TARA 14.00, EMC Data Domain 890, Autotask Build 4946, WebEx 7.0, Perl 5.16.1, Aster 5.10, Hortonworks Hadoop 2.1/2.2 (HDFS, MapReduce, HBase, HCatalog, Pig, Hive, Cascading, Accumulo, Pheonix, Storm, Solr, Spark, etc.,), DataStax Cassandra, Spark, Python 2.6.9, Awk, Sed, PHP 5, MongoDB 3.2, JSON,Tableau 8.2, Protegrity 6.0, Web Logic, Tibco Object Works, Informatica Power Center 9.0.1, OBIEE 11.1.1.7, IBM AIX 6.1, SQL Server 2008/2012 R2 (SSIS,SSAS, SSRS), Oracle 11g/12c, Hyperion 9, Datastage 8.5, Qlikview, MDM, Univiewer Management Server 4.0.14 (Orsyp)

Confidential

Senior Teradata DBA

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.
• Installed and configured Aster Database Cluster Terminal (ACT).
• Installed and configured ODBC driver, unixODBC Driver Manager, .Net Data Provider, Data Loader tool, Data Export tool, and TD Wallet for Aster Database.
• Managed, configured and monitored Aster database activities using Aster Management Console (AMC).
• Create scripts and User Defined Functions (UDF) and run them using SQL-MapReduce and Stream API.
• Transfer data between Aster and Teradata databases using SQL-MR fucntions such as Load to Teradata, Load From Teradata, etc.
• Copy data from Hadoop server into Aster database using SQL-H data connector and Load from HCatalog SQL-MR function.
• Export data from Teradata into Hadoop HDFS for the data analysis
• Participated in 24/7 on-call support rotation.

Technologies: Teradata V 13.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, 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, Tableau 8.2, Protegrity 6.0, Oracle Key Manager 3, Tivoli Storage Manager (TSM) 6.2/7.1, Tibco Spotfire 6.0/6.5, Informatica Power Center 8.6/9.5., OBIEE,JEE, SQL Server 2008/2012 R2 (SSIS,SSAS, SSRS), SAS 9.3,Oracle 11g/12c, Datastage 9.1, Talend, MDM, SAP XI Business Objects(BO) 4.0 suite (Universe Designer, Crystal Reports, WebI/InfoView, Xcelsius)

Confidential

Teradata DBA

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 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,, Informatica Power Center 8.6/9.5, Oracle 10g/11g, OBIEE,JEE, SQL Server 2008 (SSIS,SSAS, SSRS), Datastage 8.1, Business Objects(BO) XI 3.2 suite (Universe Designer, Crystal Reports, WebI/InfoView, Xcelsius), SAS 9.3, Talend. MDM, Tableau 8.2

Confidential

Teradata DBA

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.
• Effectively supported the client’s user security model by creating profiles, roles and assign appropriate access rights to them.
• Performed the Teradata V2R6 ODBC upgrade on BI servers.
• Implemented code changes on Teradata Production system as per the given Change Orders
• Performed the space management of database containers as per business user requirements.
• Created user users and resolved access rights issue with the users
• Reviewed the Security Standard reports that published by the Nezumi scanning tool and fixed the respective issue
• Performed the SQL Tuning for the user queries
• Monitored the system and aborted user queries that were offending the system performance
• 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.
• 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 V2R5V2R6 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., Informatica Power Center 8.6/9.5, SQL Server 2005 (SSIS,SSAS, SSRS), Oracle 8i/9i, OBIEE,JEE, Datastage 8.0, Talend, MDM, Business Objects (BO) XI 3.1 suite (Universe Designer, Crystal Reports, WebI/InfoView, Xcelsius), SAS 9.0, Tableau 8.2 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)Project# 5:

Confidential

Teradata ETL Architect

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 EDW
• 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
• 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, BusinessObjects Enterprise 6.

Confidential

Teradata ETL Architect

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 EDW
• 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 ETL 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.

Confidential

Teradata ETL Architect

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 EDW
• 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.

Confidential

Migration Lead

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 EDW
• 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.

Confidential

Teradata ETL Developer

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

Confidential

Application Developer

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