SUMMARY:

An experienced IT professional with more than 10+ years of experience in Information Technology, including over 5+ years of experience in managing multiple projects on data warehousing and business intelligence.

PROFESSIONAL EXPERIENCE:

Confidential

Project Support

Responsibilities:

• Providing Technical Architecture and Data Architecture leadership in establishing conceptual & Logical data model, with Data Quality, Data Validation, Data Definitions, Metadata processes, BI Reporting and Remediation
• Work with the business stakeholders, business analysts to perform detailed data analysis to customize the logical and physical data model for the enterprise data warehouse based on organization requirement.
• Establish and executes enterprise data governance strategies in line with the organization s strategic plan and objectives.
• Develop and institute best practices methodologies and standards with regard to Enterprise Data Warehouse, Data Governance, Data Design and Data Masking.
• Collaborate for Tactical Reporting and Dashboard to surface Data situations to C - Level Executives Performing
• Technical Lead in the Design and Implementation of Teradata, Informatica and SAS technology for Risk Data Warehouse solution/EDW project
• Worked on various project management methods such as Agile(JIRA) and Kanban for EDW and Enterprise Data Management
• Manages project activities, tracking deployments in production, change management process, ownership, issues resolutions and provide mitigation plan for issues based on severity. Work with various vendor partners for project execution including onshore and offshore model
• Understand business requirements for DW and BI applications and translating these to specific DW Model and technical design (TRDs).
• Act as DW and BI SME for various clients and suggest/implement Best practices, guidelines and architecture proposal.

Confidential

Operational Support (Production Support)

Responsibilities:

• Monitoring the System performance, CPU, IO usage, Node availability through Teradata viewpoint or SWS
• System initialization (sysinit and BAR config) for setting up DR site and later used as TEST environment
• Alert configuration and setup using Teradata viewpoint
• Automatic statistics collect Portlet setup and automate stats refresh for IDW tables
• Contribution on Teradata naming standard and adhering the standard
• Role setup for managing permissions based minimum level of access
• Backup configuration using DSA setup which used Teradata viewpoint Portlet and Netback up
• Operationalizing backup for Prod and Test env
• Allocating perm/ spool space, monitoring database / table space usage
• Generating weekly Space/ CPU and I/O utilisation reports
• Development to Production and Production to Testing
• Diagnose and collect statistics on database objects as per requirement or recommendation
• Collect document, user’s requirements and provide technical solution for respective subject areas
• Work with vendor for latest patch upgrade or cert list

Confidential

Responsibilities:

• Work on full life cycle development project.
• Experience with proven project methodology tools
• Create and maintain data model repository and act as gatekeeper and ensure the data modelling standards are followed.
• Performed Architecture Reviews for all work, including hosting regular Architecture Review
• Able to leverage all communication options - continually track status of project tasks
• Build and maintain a project plan and task list and baseline for milestone dates and share with team and stakeholders
• Followed on PMP and SDLC guideline while delivering project and task
• Maintain operational and project documents for better project and production support
• Build business cases and creating presentations for executive stakeholders/Steering Committees
• Created PCRs or change the health status of a project based on defect or business requirement
• Manage cost and budget(estimating, tracking, forecasting) and project resource planning
• Tracking multiple projects already in progress
• Followed Microsoft Project and MS Office - PowerPoint, Word, Excel for schedule tracking
• Build integrated data mart for Confidential Bank for analyzing customer score. We have feed data to SAS application for their processing and decide customer credit score and based on that application team can issue credit card to the customer.
• Participate in guiding projects through full life-cycle, including performing technical management, guiding clients through the development cycle and overseeing project teams.
• Work with Hadoop/SAS team on this project. Integrate data from heterogeneous data sources and build dashboard, adhoc report for customer segmentation, predictive analysis and marketing campaign.

Confidential

Responsibilities:

• Work on full life cycle development project.
• Experience with proven project methodology tools
• Able to leverage all communication options - continually track status of project tasks
• Build and maintain a project plan and task list and baseline for milestone dates and share with team and stakeholders
• Followed on PMP and SDLC guideline while delivering project and task
• Maintain operational and project documents for better project and production support
• Build business cases and creating presentations for executive stakeholders/Steering Committees
• Created PCRs or change the health status of a project based on defect or business requirement
• Manage cost and budget (estimating, tracking, forecasting) and project resource planning
• Tracking multiple projects already in progress
• Followed Microsoft Project and MS Office - PowerPoint, Word, Excel for schedule tracking
• Work on customer loyalty program, deliver timely reports for customer rewards point and making sure system follows SLA. Looking after operational system maintenance, performance, bottleneck and manage incident and change request with the help of support team and vendor. Deliver under the Opex allocated for operational support, support business stakeholder and reduce hops for smooth and efficient operational support.

Confidential

Responsibilities:

• Work on full life cycle development project.
• Experience with proven project methodology tools
• Able to leverage all communication options - continually track status of project tasks
• Build and maintain a project plan and task list and baseline for milestone dates and share with team and stakeholders
• Followed on PMP and SDLC guideline while delivering project and task
• Maintain operational and project documents for better project and production support
• Build business cases and creating presentations for executive stakeholders/Steering Committees
• Created PCRs or change the health status of a project based on defect or business requirement
• Manage cost and budget (estimating, tracking, forecasting) and project resource planning
• Tracking multiple projects already in progress
• Followed Microsoft Project and MS Office - PowerPoint, Word, Excel for schedule tracking
• Supporting operational and adhoc reporting for financial data. Actively participate in troubleshooting any data lineage, data quality and issues or incident reported by business stakeholder and resolve them based on criticality and priority

Confidential

Responsibilities:

• Work on full life cycle development project.
• Experience with proven project methodology tools
• Able to leverage all communication options - continually track status of project tasks
• Build and maintain a project plan and task list and baseline for milestone dates and share with team and stakeholders
• Followed on PMP and SDLC guideline while delivering project and task
• Maintain operational and project documents for better project and production support
• Build business cases and creating presentations for executive stakeholders/Steering Committees
• Created PCRs or change the health status of a project based on defect or business requirement
• Manage cost and budget (estimating, tracking, forecasting) and project resource planning
• Tracking multiple projects already in progress
• Followed Microsoft Project and MS Office - PowerPoint, Word, Excel for schedule tracking
• Work on vendor finance reporting and agent reporting. Support production operational and analytical reports.

Confidential

Responsibilities:

• Work on full life cycle development project.
• Experience with proven project methodology tools
• Able to leverage all communication options - continually track status of project tasks
• Build and maintain a project plan and task list and baseline for milestone dates and share with team and stakeholders
• Followed on PMP and SDLC guideline while delivering project and task
• Maintain operational and project documents for better project and production support
• Build business cases and creating presentations for executive stakeholders/Steering Committees
• Created PCRs or change the health status of a project based on defect or business requirement
• Manage cost and budget (estimating, tracking, forecasting) and project resource planning
• Tracking multiple projects already in progress
• Followed Microsoft Project and MS Office - PowerPoint, Word, Excel for schedule tracking
• Work on vendor reporting and agent billing reporting.

Confidential

Senior Teradata DBA

Responsibilities:

• 24 X 7 monitoring of the System Work-Load using Teradata-Manager and Viewpoint
• Monitoring Sessions/ Node & AMP performance, resolving performance issues e.g. removing transactional/ HUT locksIdentifying high CPU-skew sessions and suggesting tuning methods
• Perform system level check including check table, scan disk, block and locks for effective system management
• Extract high resource intensive query based on CPU consumption or IO and provide best solution for bottleneck queries
• Data collection and administration policy, and data access rules
• Develop policies and procedures for network access and usage and for the backup and recovery of data.
• Good DBA skills in Teradata DBMS production DBA support
• Having experience with Teradata utilities like BTEQ, Fastload, Multiload and TPT
• Create Database, user, Role, Profile as per the best practice to manage the system effectively
• Provide access to database users based on their business function and adhere security administration
• Skilled in diagnostic statistics and implementing statistics collection process
• Hands on performing backups using Teradata arcmain, NetBackup tool, TARA-GUI
• Skilled on UNIX environment and standard tools such as VI, UNIX commands, utilities etc.
• Design, develop database, construct, modify, implement and test data models
• Good exposure in Oracle 10g and Oracle 9i
• Created different layers in DEV/QA for testing purpose and integrate in UAT env for Production release
• Using reverse engineering feature of Erwin defined physical data model for Teradata database
• TASM settings through view point: Define concurrency thresholds to load utilities, Define rules and filters to stop run-away and bad queries. Analyze TDWM tables to estimate the system capacity
• Tune the long running queries raised by application teams. Analyze DBQL tables data. Generate weekly report which contains expensive queries (which are taking more system resources), and work on fixing those queries using query tuning techniques. Prepare reports with tuning gains.
• Extensive experience in Enterprise Database Integration experience in developing ETL mappings and shell scripts using Teradata ETL tool ( FastLoad, MultiLoad, Tpump, Bteq and TPT ) and Informatica PowerCenter using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.

Environment: Teradata 12,Viewpoint, TASM, Oracle 10g, SUSE Linux 10, 6+2 node config

Confidential

Senior Teradata DBA

Responsibilities:

• Monitoring the System performance, CPU, IO usage, Node availability through Teradata manager, performance monitor etc
• Creating/Modifying Teradata objects like Databases, Users, Profiles, Roles, Tables, Granting & Revoking Database/ User privileges through Roles & Profiles.
• Performing Table-Rebuilds/ Multi-Value compression on table objects/ ensuring effective use of PPI, creation of Join Indexes
• Allocating perm/ spool space, monitoring database / table space usage
• Generating weekly Space/ CPU and I/O utilisation reports
• Development to Production and Production to Testing
• Diagnose and collect statistics on database objects as per requirement or recommendation
• Design Database to accommodate new projects, Create/modify database objects based on the requirement
• Collect document, user’s requirements and provide technical solution for respective subject areas
• Worked on Informatica PowerCenter 8.6 tool including Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Developer and Workflow Manager
• Provided production support by monitoring the processes running daily
• Identified the bottlenecks and improved overall performance of the sessions
• Designed, developed the database, constructed, modified, implemented and tested data models
• Conducted research and provided advice to other information systems professionals regarding the collection, availability and suitability of data

Environment: Teradata 12, SUSE Linux, EDW appliance

Confidential

EDW Production/Development Support - DW/BI Consultant

Responsibilities:

• Responsible for CDR management using ETL jobs monitoring and management
• Provided capacity management recommendation
• Implemented a new project for DW/BI and stored historical data for CDR
• Provided consulting for upstream and downstream jobs
• Monitored the system and managed User, profiles and roles
• Developed ETL code and tested for a new application
• Investigated space usage and monitored the growth of the databases
• Resolved database storage management issues

Environment: Teradata