SUMMARY

• Strong skills in Data Architecture, Data Modelling, Design, Requirement Analysis, Data Analysis, and Data Mapping for ETL processes.
• Very good in database application development using Teradata, SQL Server, Oracle and DB2 databases. Strong in OLTP and OLAP designing.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Very good in database application development and ETL processes using Teradata, SSIS and Informatica.
• Extensively worked on data extraction, transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Well experienced in the domains of Banking, Insurance, Health Insurance, Automotive, Financial, Welfare, Legal and Manufacturing.
• 16 years of experience in Information Technology.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views. Well versed in UNIX shell scripting
• Experience in database programming in Teradata Macros / ETL Utilities, PL/SQL (Stored Procedures, Triggers and Packages) and DB2 Stored Procedures.
• As a Canadian Citizen, I can work in US (TN Visa) and Canada.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Excellent interpersonal, analytical and communication skills.

TECHNICAL SKILLS

RDBMS: Teradata, Oracle 9i/11g, SQL Server 2000/2008, DB2, IMS DB, MS Access

BI: Informatica - Power Centre, Power Exchange CDC, PL/SQL, Teradata Utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport; DTS, SSIS, DB2 - BMC Utilities

Tools: Teradata SQL Assistant, Erwin Data Modeler, TSO, ISPF/PDF, Endevor, PANVALET, Xpediter, File-Aid,, $AVRS, PRO/JCL, DFSORT, SyncSORT, DB2 SPUFI, MS-Visual Studio, IIS, SQL Developer, PL/SQL Developer, Query Analyzer, Lotus Notes, Visual Source Safe, MS Outlook, WinCVS, MS-Office, MS-Project Plan, MS-Visio, MS-Access, LibDev Images, MQ Series, ISMP, WebSphere, Acu-Bench, Multi-Edit, UML, Primavera

OLTP: CICS, ASP, ASP .Net, Centura/2000, D2K, Acu-Cobol, Clipper, Delphi, Speedware, IMS DC

Languages: JCL, MS Cobol, VS-Cobol II, MVS Cobol, OS/390 Cobol, Enterprise Cobol, Acu-Cobol, MF Cobol, ASP, VB .Net, Java Script, VBScript, VB 6.0, HTML, XML, SAS Mail, SAS, PL/SQL, C++, Clipper, Delphi, Centura 2000, Gupta SQL, Eazytrieve++, HPUX-MPUX UNIX Scripts

OS: Win NT/98/2000/XP/7, MVS/ESA, OS/390, z/OS, MS DOS, HP-UX

PROFESSIONAL EXPERIENCE

Confidential, MI

Data Architect - EDW / BI

Responsibilities:

• Liaised with business and technical teams and identified the technical solution. Coordinated to derive technical design documents and reviewed the deliverables.
• Developed Data Model and Database Design documents. Estimated the efforts required.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN. Developed Logical and Physical Data Models.
• Developed strategies for data acquisitions, archive recovery, and implementation of a database.
• Ensured the organizational standards in Database objects design and implementation.
• Modified / Implemented BI solutions. Designed PL/SQL application structures. Standardized documentation in System Wiki with related business rules.
• Worked with OLTP / OLAP designs and dimensional models.
• Documented and maintained critical source to target mapping documentation and related business rules.
• Generated DDLs for tables with partitions and also created indexes, views, constraints, triggers, synonyms, database links, table spaces, roles etc. in different schemas.
• Generated system and integration test cases by coordinating with QA and business teams.
• Ensured on time delivery of modules planned with quality standards.

Environment: Oracle 11g, TOAD, PL/SQL, SQL Developer, PL/SQL Developer, Erwin Data Modeler, Informatica PowerCenter 9.5.1, Perl, TortoiseSVN, Suse Linux, Java Script, ASP.Net 3.5, VB.Net, ADO.NET, XML, HTML, IIS, MS-Visio, MS-Office

Confidential, MI

Data Architect / Data Modeler / Tech Lead

Responsibilities:

• Gathered business requirements and held multiple discussions with teams to finalize the requirements for PCII project. Currently GCAT consists of North America system. PCII project integrates Europe, Asia Pacific and South America systems into the current GCAT system.
• Developed Data Model and Database Design documents.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN. Developed Logical and Physical Data Models.
• Developed strategies for data acquisitions, archive recovery, and implementation of a database.
• Ensured the organizational standards in Database objects design and implementation.
• Designed 3rd Normal Form OLTP Databases / Models.
• Designed multiple Teradata stored procedures and macros and iimplemented Teradata applications. Extensively used Teradata Utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport for business solutions.
• Implemented many shell scripts and created daily and weekly UNIX jobs to load the data into data warehouse tables. Worked with OLTP / OLAP designs and dimensional models.
• Designed PL/SQL application structures and SSIS packages. Documented and maintained critical source to target mapping documentation and related business rules.
• Generated DDLs for tables with partitions and also created indexes, views, constraints, triggers, synonyms, database links, table spaces, roles etc. in different schemas.
• Generated system and integration test cases by coordinating with QA and business teams.
• Ensured on time delivery of modules planned with quality standards.

Environment: Teradata, Oracle 11g, SQL Server 2008, TOAD, PL/SQL, SQL Developer, PL/SQL Developer, Enterprise Manager, Erwin Data Modeler, Informatica PowerCenter 8.6,,Suse Linux, Java Script, ASP.Net 3.5, VB.Net, ADO.NET, XML, HTML, IIS, TI/SQL, SSMS/BIDS, MS-Visio, MS-Office

Confidential

Data Architect / Data Modeler / Tech Lead

Responsibilities:

• Liaised with the team and prepared requirements for HP-Transition projects.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements using ERWIN. Developed Logical and Physical Data Models.
• Developed Source to Target Design documents for developers to code the programs/mappings that load into the Enterprise Data Warehouse.
• Integrated data from multiple source systems into the ODS and designed data architecture to support business intelligence and application integration requirements.
• Developed strategies for data acquisitions, archive recovery, and implementation of a database.
• Ensured the organizational standards in Database objects design and implementation.
• Designed 3rd Normal Form OLTP Databases / Models.
• Designed PL/SQL application structures and SSIS packages. Documented and maintained critical source to target mapping documentation and related business rules.
• Worked with performance tools for improving performance of many queries used in applications and data warehousing reports. Worked with OLTP / OLAP designs and dimensional models.
• Created ad-hoc packages and used Import/Export utility to load data from QA to Dev Server, Dev to QA Server and Prod to QA for testing packages and validating Data.
• Performed Customization on existing Forms Appearance, Validation Logic, Behaviour and Incorporated new Functionalities.
• Developed many shell scripts and created daily and weekly UNIX jobs to load the data into data warehouse tables.
• Maintained quality documents. Liaised with development team and business team.
• Analyzed and provided solutions to service requests and production issues.

Environment: Oracle 9i, Oracle 11g, Oracle DOA, SQL Server 2008, TOAD, PL/SQL developer, TI/SQL, SQL Developer, Enterprise Manager, Informatica PowerCenter 8.6, Teradata, Mediator, MS-Visio, MS-Office

Confidential

Sr. Programmer Analyst / Team Lead

Responsibilities:

• Led and co-ordinated in the design and development efforts in implementing the applications, and mentored the Development team, DBA, Verification and validation team, Risk team and Senior management to work through the various challenges.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements. Prepared the technical requirements. Designed the database structures. Coded, tested and integrated the applications.
• Developed multiple Teradata stored procedures and macros.
• Coded, tested and implemented the Teradata applications.
• Extensively used Teradata Utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport for business solutions.
• Created low level design documents for developers. Documented various application standards to be followed which include both DB2 and Oracle Design standards.
• Developed tables with partitions and also created indexes, views, constraints, triggers, synonyms, database links, table spaces, roles etc. in different schemas.
• Extensively used Joins, Packages, Stored Procedures and Functions in Interaction with backend database using PL/SQL
• Provided the production support to application systems. Performed reviews and quality assurance tests.
• Conducted user training on critical applications. Prepared user manuals. Created test plans and coordinated the testing process. Assisted UAT team.
• Performed problem solving activities. Liaised with business and development teams. Maintained quality documents.
• Projects: Anti Money Laundering (AML). Oman National ID Integration, Salary Pre-paid Card-VISA, SOA-Internet Banking-Phase-I., Credit Card Management System with CTL, Baituna Home Loans, ROP Pre-paid Card-VISA, Automated Clearing House (ACH), Real Time Gross Settlement (RTGS), Fixed Asset Module Implementation.

Environment: Teradata utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport, COBOL, DB2, BMC Utilities, JCL, VSAM, ASP, ASP. Net, XML, HTML, Endevor, File-Aid, Xpediter, CICS, Sort utilities, MS Office, MS-Visio, ISMP, Oracle 9i, PL/SQL Developer, SQL Developer

Confidential

Analyst / Team Lead

Responsibilities:

• Analyzed the user requirements. Prepared the technical specifications. Developed and integrated many applications. Coded, tested and implemented the Teradata applications.
• Developed multiple Teradata stored procedures and macros.
• Generated database design documents with thorough analysis.
• Extensively used Teradata Utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport for business solutions.
• Liaised with the technical team at offshore (India) and business team at onsite (US).
• Performed production support, enhancements, reviews and requirement analysis. Resolved multiple database performance issues.
• Completed the multiple enhancements (Development & Modifications) with flawless deliveries
• Created test plans and coordinated testing process. Assisted UAT team. Conducted knowledge sharing sessions.
• Performed problem solving activities. Prepared user manuals.
• Projects: COBRA, LOOT- Personal Markets and Commercial Markets, Re-Insurance System for Commercial Markets, LDW-Loss Data Warehouse of Property, Auto Liability and Workers Compensation, Enterprise COBOL Conversion, SAS Mail Conversion, Decision Analyzer Conversion, Sarbanes-Oxley(SOX) Compliance, Reconciliation system of Ontario

Environment: Cobol, JCL, VSAM, DB2, Teradata utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport, BMC Utilities, CICS, Endevor, File-Aid, Sort utilities, Decision Analyzer, $AVRS, WinCVS, MS Office, Xpediter, SAS Mail, SAS, Pro/JCL, Centura/2000.

Confidential

Analyst / Senior Programmer

Responsibilities:

• Supported to Employer Services, Employer Registration and Security systems of Employer Information System (EIS) department
• Analyzed the user requirements with impact analysis. Provided technical solutions to client needs. Developed and integrated the applications. Prepared the technical requirements.
• Developed multiple Teradata stored procedures and macros. Coded, tested and implemented the Teradata applications. Extensively used Teradata utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport for business solutions.
• Prepared database design documents with complete requirements.
• Provided the production support and resolved many issues. Prepared user manuals.
• Prepared technical specifications. Coded, tested and implemented different applications.
• Performed problem solving activities. Created test plans and coordinated testing process. Assisted UAT team. Maintained quality documents.
• Implemented the projects: Employer’s quarterly statement of account, DBC application security system enhancement, 8-digit telephone number implementation (expansion) in Security system., Employer’s history information., Migration of SQL Windows 5.0.4 to Centura 2000, Multiple batches for cross year contribution and bypassing tertiary institute student details, Tightening of controls between Run Series.

Environment: Cobol, JCL, VSAM, DB2, IMS, Teradata utilities - BTEQ, ITEQ, Fastload, Multiload, Fastexport, BMC Utilities, CICS, Endevor, File-Aid, Sort utilities, PANVALET, $AVRS, MS Office, Xpediter, Eazytrieve+, C++, Gupta SQL, Centura/2000, Lotus Notes, SAS, MQ Series, SQL Developer

Confidential

Senior Programmer / Programmer / Systems Analyst

Responsibilities:

• Developed and maintained various systems for production departments
• Supported automation department, wire rod mill, and electro-technical laboratory departments’ systems
• Performed requirement analysis, design, coding, testing and deployment. Prepared technical requirements.
• Provided technical solutions specific to company environment. Created test plans and coordinated testing process.
• Maintained quality management system standards.
• Conducted / participated in knowledge sharing sessions. Performed problem solving activities.
• Prepared user manuals.
• Implemented the projects: Breakdown Analysis Information System, Sub-stores Management System., Wire-rod Mill Production Planning and Control System, Hire Charge Database Maintenance System, Maintenance of Purchase & Payroll Systems, Management Information SystemManagement Information System

Environment: Cobol, JCL, VSAM, DB2, CICS, Endevor, Sort Utilities, MS-Office, Lotus-123