SUMMARY:

Professional IT consultant with more than 16 years of experience and proven drive to succeed. Over 3 years of experience as Tableau Developer / consultant to work with prestigious clients. 8+ year’s overseas on - site experience to work with US clients. Handled projects in various technologies like Tableau, Data Analytics, UDB DB2, Teradata, IBM DB2 and Mainframes.

TECHNICAL SKILLS:

Databases: UDB DB2, IBM DB2, Microsoft Sql server / 2005

Development tools: Sql server Management Studio 11.x / 10.x, IBM DB2 UDB Query Manager and SQL Development Kit, Teradata Studio

Reporting tools: Tableau

Programming: MVS Cobol, JCL, VSAM, CICS

Data modeling tool: MS Visio

Project Mgmt. tool: MS Project

Office tool: Office / 2010 and earlier versions

Version control: Changeman

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Tableau Developer and Data Engineer

Responsibilities:

• Design and develop dashboards in Tableau
• Analyze and identify data patterns
• Analyze complicated manual spreadsheets to identify the data patterns

Environment: Tableau, MS Office, Microsoft Sql server 2008/2012, Oracle 11g

Confidential, NY

Senior UDB DB2 Developer/Technical Architect

Responsibilities:

• Technical Architect on-site for backend / Database design, ETL processes and jobs.
• Working with on-site team and client on requirements.
• Designing Logical and Physical data models (OLTP).
• Design and develop Stored procedures and functions in UDB DB2.
• Working with the UI and Services team to design interface parameters.
• Analysis of vendor application
• Working with off-shore team and UI team to integrate the Web application with the backend objects.
• Create and maintain the Design documents at SharePoint site.

Environment: UDB DB2, Microsoft Visio, MS Office

Confidential, NY

Technical Analyst/QA Tester

Responsibilities:

• Analysis of Data Mapping documents
• Development of Test strategies for Conversion Program
• Data analysis and validation of business rules
• Design of Reconciliation reports
• Development of Reconciliation reports
• Integrations of various data sources like z/OS DB2, SQL Server and flat files
• Create and maintain the Design documents at SharePoint site.

Environment: SQL Server 2008/2012, Microsoft Visio, DB2, MS Office, Quality Center

Confidential

Project Manager

Responsibilities:

• Project manager for Statements 2.75 team (Onsite/Offshore) and Project lead for Confidential (Offshore)
• Working with the customer and team on project requirements, planning and execution. Working with Confidential customer on project requirements, planning and execution.
• Design the data model for the target application
• Design and develop interfaces and templates for migration from z/OS mainframes to Teradata
• Validation of Business rules
• Design and develop of Test Strategies
• Manage Monthly releases (Continuous development to mimic the output and introduce new features)
• Design and Development of enhancements for Confidential project
• Design and develop of Test Strategies for Confidential project
• Project Management
• Production Support

Environment: Teradata, MVS COBOL, DB2, MS Office, MS Project, JCL, VSAM, Changeman, File aid, SORT

Confidential

Technical lead

Responsibilities:

• Working with the team on Technical proposals
• Working with the various project teams and providing feasible solutions

Environment: DB2, Teradata

Confidential, North Carolina

Technical lead

Responsibilities:

• Worked as technical lead using DB2 and MVS COBOL.
• High level analysis of Business requirement
• Preparation of estimates based on requirement
• Preparation of technical design documents
• Review technical design documents with the business analyst team
• Review of code
• Review of Test plan and Test result documents
• UA Support - Co-ordination with offshore team to handle UA users
• Project Management

Environment: MVS Cobol, JCL, DB2, VSAM, Changeman, SORT, File aid, Xpeditor, SORT

Confidential, NJ

Technical lead

Responsibilities:

• Project Management
• Project planning, scheduling and status reporting
• Enhancement to the existing system and solving production issues
• Analyzing Business requirements and conducting Business requirement walk through
• Preparation of detailed design and system specifications documents
• Design of CICS screens
• Configuration management using Changeman
• Code Review
• Review of Test Plan and Test result documents
• Onsite-Offshore co-ordination.
• QA and UA Support
• Production Support

Environment: MVS COBOL, JCL, DB2, VSAM, Changeman, SORT, File aid, Xpeditor

Confidential, NJ

Technical analyst

Responsibilities:

• Project Management
• Project planning, scheduling and status reporting
• Enhancement to the existing system and solving production issues
• Analyzing Business requirements and conducting Business requirement walk through
• Preparation of detailed design and system specifications documents
• Design of CICS screens
• Configuration management using Changeman
• Code Review
• Review of Test Plan and Test result documents
• Unit Testing and Integration testing using Hiperstation
• Onsite-Offshore co-ordination.
• QA and UA Support
• Production Support

Environment: MVS COBOL, JCL, DB2, VSAM, Changeman, SORT, File aid, Xpeditor, Hiperstation