SUMMARY:

• 11+ years of Software Development and System Engineering experience, with 8+ years of Data modeling, Technical Lead experiences in Teradata Data Warehouse development.
• Extensive experience in Agile Software development methodologies like scrum & XP.
• Have work experience in all phases of SDLC, focusing on conceptualizing business needs and translating them into viable technical solutions.
• Extensive experience in Data Modeling, Design, Development, Implementation, Maintenance and Tuning of Large Data Warehouse in Retail and Telecom industries.
• Expertise in developing and deploying Teradata scripts using Teradata utilities such as BTEQ, FLoad, Mload, FastExport, TPump and Teradata Parallel Transporter.
• Expertise in conceptual, Logical and physical data modeling, metadata, Data cleansing, Data governance, Data profiling and Master Data management.
• Hands - on experience in ETL process and source to target mapping documentation.
• Identified potential bottlenecks with queries from the aspects of query writing, Skewed redistributions, join order, optimizer statistics, and physical design considerations (PI, NUPI and USI, NUSI and JI etc.).
• Expertise in creating Teradata stored procedures and macros.
• Strong working experience in planning and carrying out of Teradata system extraction, Loading Process and Data warehousing, Large-scale Database Management and Reengineering.
• Extensive knowledge in INFORMATICA workflows using power center 9.6, UNIX shell scripting and version control tools such as GitHub and SVN.
• Developed Teradata External loader connections such as MLOAD, UPSERT and UPDATE while loading data into the target tables in Teradata Database.
• Strong work experience in Python3.4 using Flash and aiohttp frameworks and Pivotal Cloud Foundry.
• Extensive knowledge and experience in COBOL, JCL, SQL, DB2, VSAM, CA7 (Scheduler) and FTP.
• Excellent experience in managing an onsite/offshore project (Co-ordination, Project Estimation, project planning and allocation, driving and delivering the project)
• Possess sound interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
• Proficient in code optimization and performance improvement on both database and application
• Significant experience working with customers, Project Managers and technical teams for securing and executing concurrent multi-technology projects.

SKILL:

Operating System: Windows, UNIX, IBM Z/OS

Databases: Teradata 14.10, DB2, Oracle 11g

Teradata utilities: BTEQ, FastLoad, MultiLoad, FastExport, TPump, TPT, SQL Assistant, Teradata viewpoint, Teradata Visual Explain

IBM Technologies: Mainframe, JCL, COBOL, VSAM

ETL Tools: INFORMATICA Power Center 9.6

Design tools: MS Visio

Development tools: Pycharm, vi editor for UNIX shell scripting

Languages: Python3.4, COBOL, SQL, UNIX shell scripting

Version control: GitHub, SVN, Endevor

Scheduling tools: CA7, IBM Tivoli Maestro

Business Area: Retail Supply Chain and Telecom applications

Methodology: Agile

PROJECT EXPERIENCE:

Confidential, Maryland Heights, MO

Lead Developer

Environment: Teradata 15.10, UNIX, Teradata SQL, SVN, ONE Automation, and COIN

Tools: Teradata SQL Assistant, Teradata viewpoint

Responsibilities:

• Part Charter Business Intelligence Agile team which builds DataMart’s for various reporting in Sales and Service Delivery vertical.
• Involved in various scenarios related to Data Modeling, System/Data Analysis, Design and Development for both OLAP and Data warehousing environments.
• Prepared Technical design doc for existing/New Jobs & Procedures for Development team.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Involved in development phase complex mapping between dimension & fact tables for all complex business scenarios to match WM data.
• Designed new Teradata tables participating in the reviews with the data architects and database administrators.
• Designed complex loading strategies and Procedures. Worked with Type 1 and 2 dimensions, fact tables, star schema design, Operational Data Store (ODS) and other data warehouse concepts.
• Created unit Test Plans, Regression test plans and integrated test plans and conduct testing in different environments for various business Intelligence based applications.
• Involved in various complex SQL Query tuning and provided tuning recommendations, time/CPU consuming queries.
• Code review for all components & meeting with Client for weekly status.
• Implement and support new and existing data, ETL, and reporting solutions implemented in Teradata and Micro strategy
• Collaborated with business analysts and developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.
• Collaborate with other Business Intelligence teams to design and develop solutions to business problems.
• Design and build data analytics scripts to meet specific objectives of audits and see if they can be reused on a continuous basis to strengthen the system of internal controls.
• Produce ad-hoc reports to answer business questions quickly and thoroughly.
• Created process flow and data flow diagrams using MS Visio representing how various upstream systems feeding into Teradata.
• Designed GAP analysis documents for comparing new systems data model to existing physical model.
• Developed technology documentation to support ongoing maintenance of reporting and data solutions.

Confidential, Atlanta, GA

Technical Lead

Environment: Teradata 14.10, UNIX, Teradata SQL

Tools: Teradata SQL Assistant, Teradata viewpoint, Pycharm

Utilities: BTEQ, FastLoad, MultiLoad, FastExport, TPT, Pytest

ETL Tool: Informatica

Language: Python

Responsibilities:

• Part of Agile IT product team, which controls the inventory, policies, forecast, promos and purchase order.
• Design, develop and implement ETL process to load ORE data warehouse using Teradata tools and utilities like FastLoad, MultiLoad, Teradata Parallel Transporte(TPT), FastExport and Tpump
• Developed python services using aiohttp to expose parameter to other products such as Purchase Order Management (POM) and python batch to process the DC receipt files.
• Designed and Developed Teradata stored procedure to replace third party applications in replenishment product.
• Interact and work directly with the business team and product team on project issues.
• Developed BTEQ, FastLoad scripts to consume staged master data into the domain tables.
• Design; develop Informatica mappings, created pre-session, post session, pre-sql, and post-sql commands in Informatica.
• Design and Development of Informatica workflows/worklets/sessions associated with the mappings across various sources like flat files and Oracle/DB2 tables.
• Documentation of the Web Services using Swagger API.
• Experience in Logical, Physical Data Modelling and Dimensional modelling using star and snowflake.
• Have worked in creation of UNIX shell scripts, which are wrapper for invoking BTEQ and TPT scripts.
• Have done several performance tunings of complex SQL queries and stored procedures in Teradata
• Maintained the version control of the source code using Sub Version and now using GitHub.
• Deployed python applications on Linux server and Pivotal Cloud Foundry.
• Well versed in the use of TWS maestro scheduling and creating schedules and involved in the testing and implementation of schedules in production.
• Involved in the implementation of code migration activities in production Linux boxes, Teradata server and PCF.

Confidential, Atlanta, GA

Technical Lead

Environment: Teradata 14.10, UNIX, Teradata SQL

Tools: Teradata SQL Assistant, Teradata viewpoint, Pycharm

Utilities: BTEQ, FastLoad, MultiLoad, FastExport, TPT, Pytest

Language: Python

Responsibilities:

• Work directly with the business team and project management to address project issues.
• Involved in analysis of existing application and translate to technical requirements.
• Developed python services using aiohttp to post the order detail to the core ordering systems.
• Design and development of ETL process to load master data from the assortment tables using Teradata tools and utilities (TPT, MLoad, FLoad, Fexport, and TPump).
• Created high-level flow for the new process, Involved in Data analysis, Data model designs and staging table creations.
• Provided solution for critical performance issues. Prepared producer and consumer contracts. Own deployment and product support.

Confidential, Atlanta, GA

Technical Lead

Environment: Teradata 14.10, UNIX, DB2, Teradata SQL

Tools: Teradata SQL Assistant, Teradata viewpoint

Utilities: BTEQ, FastLoad, MultiLoad, FastExport, TPT

Responsibilities:

• Gathering the requirement, analyze the existing process and derive the business logic out of it.
• Designing and implementing enterprise campaign segment for customer analytics team.
• Involved in preparing the source to target mapping documentation for table-to-table for initial load process and file-to-table for third party enrichment for data cleansing.
• Prepared detail design document for the new batch process that involves BTEQ and UNIX shell scripting.
• Used Fastexport to unload the Data into flat file for B2B transfers.
• Worked on UNIX shell scripting for file processing to third party vendor through SFTP, encryption and decryption process
• Follow standard, suggest best practices and document the same.
• Identify columns to be used in primary index, used index columns in JOIN, partitioned the tables as per the need and performed collect statistics on the required columns.
• Planning and effort estimation.
• Created data model, tables, views and stored procedures.
• Used Teradata utilities FastLoad, MultiLoad to load the Data from various third parties such Epsilon, Acxiom etc.
• Responsible for code reviews and UAT.
• Coordinated with other development teams, third party developers, testing test, analyst and project management team.
• Owned implementation of new batch process and database objects.

Confidential, Atlanta, GA

Technical Lead

Environment: Teradata 14.1, UNIX, DB2, Oracle, Teradata SQL

Tools: Teradata SQL Assistant, Teradata viewpoint

Utilities: BTEQ, FastLoad, MultiLoad, FastExport, TPT

ETL Tool: Informatica

Responsibilities:

• Interfacing with Clients for requirement gathering, analyze business requirement specifications (BRS), translate it technical specifications.
• Develop SQL to achieve the complex business requirement.
• Design, developed and tested ETL process to load DCM warehouse from various sources using Teradata tools and utilities (TPT, MultiLoad, FastLoad, FastExport and TPump).
• Developing low level and level design documentation for development team and business & management reviews.
• Provide solutions for various critical performance issues.
• Create Teradata tables, views, procedures and collect statistics on the required columns.
• Prepared source to target mapping document and effort estimation.
• Handling various technical aspects like project documentation, system design & integration, monitoring critical paths & taking appropriate actions.
• Planning and Designing of test strategies, cases and scripts/procedures for UAT activity.
• Deployment as per scheduled, coordinating post-implementation and maintenance support to the technical support team and client.
• Providing innovative & feasible solution to increase the efficiency and productivity.
• Assisting in functional testing of the new system and ensuring that it meets the user specifications.
• Prepared data mapping & transformation documents.
• Optimized queries by looking at Execution Plan for better tuning of the database.

Confidential, Atlanta, GA

Developer

Environment: COBOL, DB2, Stored Procedures, VSAM, JCL, CICS, Mainframe Web services, SORT, PLATINUM, FILEAID, ENDEAVOR, SPUFI, QMF, CA7, Bundle and Quality center.

Responsibilities:

• Involved in full project life cycle involving - Requirement Analysis, Design, Coding, Testing and Implementation phases.
• Involved in preparing the Technical Design Documents and carried out walkthrough meeting with the IT Architects & Business managers.
• Leading offshore team and fetching deliverables in timely manner.
• Maintaining quality norms throughout the development & implementation process.
• Delivering and implementing the project as per scheduled deadlines; planning and coordinating post-implementation and maintenance support to the technical support team and client.
• Providing innovative & feasible solution to increase the efficiency and productivity.
• Modified and tested COBOL, Stored procedures and JCL codes per the requests of business departments.
• Tuned the DB2 queries for the better performance and extensively worked on DB2 Load/Unload activities.
• Monitor and ABEND resolution of MVS CA-7 batch processing.
• Prepared System test cases and performing UAT activities.
• Experienced in code review and represent lead with team across all functionalities and conduct the meeting with teammates.

Confidential, Tampa, Florida

Developer

Environment: COBOL, DB2, Stored Procedures JCL, SORT, PLATINUM, FILEAID, ENDEAVOR, SPUFI, QMF, CA7, Bundle and Quality center.

Responsibilities:

• Meetings with relevant business stakeholders to understand the business requirements
• Analyzed various technologies stack available.
• Designed Solution specification document and maintaining quality norms throughout the project phrase.
• Interacting with team members to ensure smooth progress of project work.
• Handling various technical aspects like project documentation, system design & integration, monitoring critical paths & taking appropriate actions.
• Planning and Designing of test plans and strategies, test cases and test scripts/procedures, UAT activity and gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.