SUMMARY

• An IT professional with 9.5 years of strong experience in all phases of SDLC, focusing on conceptualizing business needs and translating them into viable technical solutions.
• With 5+ years of experience in Teradata, currently working as a data modeler.
• Enormous experience in application development.
• Excellent experience in ETL using Teradata utilities BTEQ, FASTLOAD, FASTEXPORT.
• Proficient in other Teradata tools SQL Assistant, SQL administrator, Teradata viewpoint, Teradata Visual Explain, MULTILOAD, TPT, TPump.
• Expertise in Teradata system development in mainframe and UNIX platforms.
• Experience in UNIX shell scripting.
• Worked extensively on Mainframe technologies JCL, VS COBOL, CICS, VSAM, DB2, IMS DB, MQ SERIES.
• Experience includes business analysis, system design, Agile, Scrum and SDLC methodologies.
• Proficient in code optimization and performance improvement on both database and application.
• Enthusiastic and passionate about building excellent software and building great teams.
• Worked on different retail mainly in CRM.
• Good experience in managing an onsite/offshore project (Co - ordination, Estimation, project planning and allocation, preparing SOW, driving the project)
• Worked on multiple projects at the same time and worked directly with business on daily basis to support their day to day activities.
• Responsible for giving the technical, implementation details for entire team (10) for all the development activities
• Exceptional ability to quickly grasp and master new concepts and technologies, adapt easily to new environment.
• Work effectively with diverse groups of people either as a team member or individually.
• Possess good analytical skills and communication skills.

TECHNICAL SKILLS

Data warehouse Methodology: Teradata DB

DWH Tools: Teradata utilities like BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TPT, TPump,SQL Assistant, SQL administrator, Teradata viewpoint, Teradata Visual Explain.

IBM Technologies: Mainframe, JCL, VS COBOL, CICS, VSAM, MQ SERIES

DBMS: DB2 (RDBMS), IMS DB (HDBMS)

Development Tools: Expeditor for debugging, vi editor for Unix shell scripting

Languages: C, VS COBOL, SQL, Windows batch scripting, UNIX Shell Scripting.

Design tools: MS Visio

Operating Systems: Windows, UNIX, Z/OS, OS/390

Version Control: Merant Version Manager, Eclipse for Mainframe

Scheduling tools: Control-M

Areas/Applications: Software Systems applied to Retail / Customer Relation Management (CRM) & Insurance.

Methodologies: Agile, Lean

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Project Lead - Teradata Data Modeler

Environment: Teradata DB, UNIX

Tools: SQL Assistant, SQL administrator, Teradata viewpoint

Responsibilities:

• Understanding current system
• Performance tuning.
• Create business functional diagram and documentation.
• System high level design
• Create ER diagrams
• Design of Teradata tables, views, macros and sub routines.
• Detail level design for batch process.
• Code review and UAT
• Implementation

Confidential, Bensalem, PA

Project Lead

Environment: Teradata DB, UNIX, Windows

Tools: SQL Assistant, SQL administrator, Teradata viewpoint

Responsibilities:

• Understanding current system
• Gathering business requirement
• Effort estimation & Planning
• Performance tuning.
• Create business functional diagram and documentation.
• System high level design
• Create ER diagrams
• Design of Teradata tables, views, macros and sub routines.
• Detail level design for batch process.
• Code review and UAT
• Implementation

Confidential, Bensalem, PA

Project Lead

Environment: Teradata DB, Mainframe, UNIX, Windows, C# .Net

Tools: and Utilities: SQL Assistant, SQL administrator, Teradata viewpoint, BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD

Responsibilities:

• Gathering business requirement
• Effort estimation & Planning
• Create business functional diagram and documentation.
• System high level design and data model
• Create ER diagrams
• Design of Teradata tables, views, macros and sub routines.
• Detail level design for batch process.
• Coordinating offshore team (10).
• Project management activities.
• Code review and UAT
• Implementation

Confidential, Bensalem, PA

Technical Lead

Environment: Teradata DB, Mainframe, UNIX, Windows, DB2 UDB, JCL, COBOL

Tools: SQL Assistant, SQL administrator, Teradata viewpoint, BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD

Responsibilities:

• System analysis
• Effort estimation and planning.
• Write tactical and strategic queries.
• Ad-hoc request fulfillment
• ETL using utilities FASTLOAD, BTEQ, FASTEXPORT.
• System high level design and data model
• Working with outside vendors for different campaign related process.
• Regular system maintenance activities.
• SQL performance tuning
• Design of Teradata tables, views, macros and sub routines.
• Detail level design for batch process.
• Coordinating offshore team.
• Project management activities.
• Code review and UAT
• Implementation

Confidential, Boston, MA

Technical Lead

Environment: Mainframe, JCL, Cobol, DB2, IMS - DB, CICS, Teradata

Responsibilities:

• Technical Lead for supply chain
• Production support
• Coordinate team of 10
• Track the issues and resolve them on priority basis
• Distributing the work among the team
• Design documents for enhancement projects
• Code review
• Implementation
• Execute ad-hoc request from users.

Confidential, Bentonville, AR

Developer / Sr. Developer

Environment: Mainframe, JCL, Cobol, DB2, IMS - DB, CICS, REXX, EXPEDITOR, FILE AID

Responsibilities:

• Analysis of the programs
• Technical documentation for changes
• Coding
• UTP preparation & Testing
• Implementation documentation

Confidential, Boston, MA

Developer

Environment: Mainframe, JCL, Cobol, DB2, IMS - DB, CICS, EXPEDITOR

Responsibilities:

• Production Support
• Analyze the work packets and estimate the efforts.
• Prepare Impact Analysis documents.
• Coding, code review.
• UTP preparation, review and Unit testing.
• Prepare Quality documents.
• Implementation and Coordination.
• Holiday Scheduling Co-ordination with other downstream systems.