SUMMARY

• Around 8 years of experience in the IT industry, involved in complete SDLC including requirements gathering, client interaction, analysis, design, development, testing, implementation, debugging, maintenance & documentation of business applications in the client/server environment.
• Delivered responsibilities as Software Developer & Programmer.
• In depth Knowledge of load utilities of Teradata - BTEQ, FastLoad, MultiLoad, Fast Export and exposure to Teradata Parallel Transporter.
• Implementation and Auditing of databases to ensure accurate and appropriate use of data.
• Experienced in database design & Capacity planning.
• Proficient in Shell scripting, Performance tuning and Query optimization.
• Good understanding and hands on experience in logical data modeling and data warehouse concepts
• Strong experience in SQL, SQL*Loader, Import, Export and Tuning SQL Scripts.
• Very Strong Debugging and Development skills on Teradata.
• Experience in modulating system requirements to technical specifications.
• Conversant with Data Modeling Concepts.
• Extensively worked on Teradata database and developed SQL, Stored Procedures, Views, Indexes and Constraints, Query Optimizer.
• Experience in handling Client Interactions and ability to quickly adapt to new environments and learn new technologies.
• Experience in onsite coordination, providing ideas and solutions.

TECHNICAL SKILLS

Languages: COBOL, JCL, SQL, C

Technologies: Mainframe and Data warehouse

Operating Systems: OS/390, Windows 2000/XP/NT/9X, MS DOS

Databases: Teradata, MSAcess, Oracle, Peoplesoft

Tools: and Utilities: TOAD, Citrix, Teradata Viewpoint, Teradata Manager, Teradata Administrator, BTEQFastload, Multiload

Configuration: Visual Source Safe, CA Harvest, Clear Case

Management: CVS, PVCS, Mercury Test Director, HP Quality Center, Peregrine, Teamsite, Endeavor, Serena Changeman, File Aid.

Data Modeling: MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Technical Analyst

Responsibilities:

• Responsible and involved in Setting up the Oracle database, users, Roles and Profiles.
• Profiling of the Entire data model for compliance to Oracle database.
• Estimating the current requirement of Space and future capacity planning
• Classifying the data for identification of Indexes and segregation of confidential data for compliance norms.
• Defined Permanent space limits both at the database and user level for different business scenarios.
• Highly experienced in working with Oracle support team for Opening and tracking incidents for Oracle issues.
• Applied the security norms required for organization compliance and audit standards and enforced the security through roles.
• Experienced in Loading, archiving and restoring data Duties.
• Implementation of database and database design changes from Erwin model.
• Performance tuning of SQL’s
• Performed extensive support in the maintenance of the Bank’s Associate and contractor’s information, Sensitive data like the payroll and incentives paid to the employees.
• Pro-actively found data conversion issues to be added as an impact on the responsible release.
• Designed new views and changes to existing objects used by the reporting team.

Environment: Teradata, Mainframe (COBOL and JCL), Oracle, SQL, Changeman, TOAD, Mercury Quality Center, TFS

Confidential, Charlotte, NC

Technical Analyst

Responsibilities:

• Detailed Analysis of user requirements and creation of requirement specifications.
• Preparing the design, functional and technical specifications.
• Query tuning for optimal performance to save production time.
• Estimating data size and database table size requirements.
• Working with data models on building relations and refining physical data model.
• Requirement analysis and resource allocation on Teradata.
• Regular Housekeeping tasks like monitoring system for optimal performance at business hours.
• Resolving Contention of Resources due to inefficient jobs with poorly coded SQL.
• Responsible for ensuring the delivered product was defect free.
• Written Stored Procedures to improve system performance.

Environment: Teradata, Mainframe (COBOL and JCL), SQL, Changeman

Confidential, Charlotte, NC

Technical Analyst

Responsibilities:

• Active involvement in the SDLC.
• Design and Development of new feature enhancements.
• Developing SQL scripts for the required modules.
• Data profiling
• Performance tuning
• Implementation of Application based Solutions.
• Involved in Bug Fixing.
• Modifying existing reports based on changes required by user.
• Active involvement in Effort Estimation.
• Provided Valuable Suggestions to solve Critical Issues.

Environment: Mainframe, Teradata, Peoplesoft, Tessaract, MSAccess.

Confidential, Charlotte, NC

Technical Analyst

Responsibilities:

• Involved in requirement gathering from the client, understand their requirements and worked actively with the development team in preparation of High Level Design Document (HDD) and Low level Design Document (LDD) for coding of the system.
• Regular Interaction with the client to get the sign-off of the documents.
• Analyzed more than 3000 interfaces and more than 100 tables/views to find the impacted Company number field list.
• Thorough Impact Analysis and to document all references.
• Code development of the identified changes for the impacted 35 interfaces and 30 tables/views.
• Prepared the test cases and performed unit testing.
• Review after every stage of design, coding, test plan and deployment.
• Testing of the changed and existing application.
• Executed a plan for deploying the changes in Production and make sure there are no Business impacts.
• Received a Spirit Card Award from Bank for the successful implementation without any defects.

Environment: Teradata, Mainframe (COBOL and JCL), SQL, Changeman, HP Quality Center

Confidential, Jersey City, NJ

SCM Analyst

Responsibilities:

• Perform extensive coding across test, pre-production and production environments using version control tools such as Changeman, Endeavor, Harvest and VSS.
• Spearhead package approval process in Harvest and Changeman ZMF for code promotions to pre-production and production. Coordinated deployment of code on Harvest in test environments and led approval process to promote code into production.
• Facilitate weekly meetings with code migration team, development team, support team, CICS group, and DBA group, client representative, testing team, release manager and project managers to discuss and rapidly resolve open issues.
• Critically analyze implementation plan, provide sign-off for code promotion, Supervised and educated development team, testing team and other stake holders, define and document processes related to content management and code promotions.
• Actively participated in setting up code repositories for new projects by partnering with Administrators and served as primary contact for version management tools, upgrades, changes and migration plans.
• Efficiently processed security requests for role changes within CA Harvest and Changeman and seamlessly coordinated Knowledge Transfer with offshore team.
• Apply sharp analytical skills toward conducting audits on company policies, procedures, systems and operations, completing associated work papers, and administering quarterly and monthly periodic access reviews for Harvest and Changeman.
• Exhibited outstanding organizational and technical expertise in compiling in-depth Software Configuration Management Plan (SCMP) for many projects.

Environment: Mainframe, ChangeMan, CA Harvest, VSS, PvCS, Peregrine, Mercury Test Director and HP Quality Center