SUMMARY:

• Over 15 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/V13.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 and 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.
• 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.
• 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/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/V13.10/14.10/15.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, 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, OR

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.
• Effectively supported the client’s user security model by creating profiles, roles and assign appropriate access rights to them.
• 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.
• 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.
• 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) 15.10 software over ETL servers and OBIEE servers;
• Performed the data migration tasks between 14.10 and 15.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 14.10 to 15.10 version
• 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.
• Provided application development support to Informatica ETL team.
• Configured AUTOSTATS component for Teradata systems through the Viewpoint; Redefined the existing STATS collection schedules in the Stats Manager.
• Installed and configured Teradata Connector for Hadoop (TDCH) components to move data between Teradata and Hadoop systems.
• Created scripts for Importing and Exporting data between Teradata and Hadoop components.
• Tuned the performance of job flows between Teradata and Hadoop systems by configuring the TDCH parameters.
• 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 Sphere, Tibco Object Works, Informatica Power Center 9.0.1, OBIEE 11.1.1.7, Oracle 11g/12c, Netezza 7.2, Toad 11.0, Univiewer Management Server 4.0.14 (Orsyp),MicroStrategy 10.2

Confidential, NH

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 13.10 to 14.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), MicroStrategy 10.2

Confidential, VA

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 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, 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, VA

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 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,, 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, VA

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)Projects handled at Intel India Pvt. Ltd.:

Confidential, OR

Application Developer, ETL Developer, BI Architect, Teradata DBA (latest)

Responsibilities:

• Worked closely with the business analysts to understand the report requirements to ensure that the appropriate schema objects are developed
• Writing ETL procedural code to upload data into EDW from source systems using Teradata loading utilities: Fast Load, TPump, and Multi-load
• 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
• Prepared a LRDM (Logical Reporting Data Model) for project
• Implemented the core schema in MicroStrategy, which would be used by report developers to develop reports very effectively
• Be part of MSTR code and design reviews and provide architectural inputs
• Created and maintained required documentation (Design documentation, Development Checklists, Report settings, custom code)
• Designed and developed reports
• Analyzing the reports that have bad performance and come up with optimal reporting solution by recommending simplification options like aggregate tables, relationship tables etc.
• Managed Schema object development to schedule
• Tracked and prioritized schema object development to meet the report development schedule
• Responsible for applying SQL optimization techniques like creating indexed views to improve the query performance
• Responsible to co-ordinate with EDS(Enterprise Data Solutions) team for migration of reports from the Test to the Production environment
• Responsible for importing or exporting code from one environment to another using DTS (Data Transformation Services) utilities
• 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
• Developed CDW reports using Cognos Impromptu tool to support Intel’s capital business needs across the globe
• Monitored DW load cycles

Technologies: MicroStrategy Desktop 6.5/7.5.1/8.0 MicroStrategy Web, MicroStrategy Administrator, MS Visio, SAP R/3, Business Objects Enterprise 6, Teradata V2R5 Suite, SAP R/3,SQL Server 2000, Sybase 7.0, Cognos Impromptu 7.x, and Power Play 7.xBusiness Objects Enterprise 6.mptu 7.x, and Power Play 7.x