EXPERIENCE SUMMARY:

• Having 12+ Years of experience in Information Technology. Played different roles such as Project Manager, Project Lead, Release Builder, Release Manager, Technical Architect, Systems Analyst, Oracle Designer, DWH Developer, Database Developer during my tenure.
• Over 3 years of Project Management Experience in Managing various Data Warehouse, OS Migration Projects. Having very good understanding of Project Life cycle. Involved from Project Initiation to Project Closure. Expertise in Project Planning, Execution, Controlling, Maintenance and Closing projects. Delivering business value and delighted stakeholders. Involved in project initiation to produce Delivery Proposal Reports using estimation techniques like Function Point and expert judgment. Good working knowledge of MS Project.
• Over 9 years of Technical experience in Teradata Programming (Teradata SQL Assistant - FLOAD, MLOAD and BTEQ scripts), Oracle PL/SQL Programming (SQL scripts, PL/SQL Procedures, Functions, Triggers and Packages), SQL Server 2008/2012 programming(SQL scripts, Procedures, Functions, Triggers and Packages), Informatica mappings, maplets, Sessions, Workflow, SSIS sessions and Workflows, SSRS Reports, Business Objects Designer & Reports Manager, Usage of MOLAP Cubes and Creation of D2K Forms and Reports.
• Expertise in STAR and Snow-Flake Schema Dimensional Modeling. Very good hands-on experience in handling multi-dimensional data marts (13 dimensions), SQL Performance tuning.
• Expertise in Database Design (ER Diagrams) & Reverse Engineering Knowledge using Oracle Designer.
• Expertise in Preparation & Execution of System Integration Test cases in Quality Center, Visual Source Studio team foundation server and Test manager
• Involved in Unit Testing, System Integration testing and Business Acceptance Testing User Acceptance Testing, Performance testing.
• Directly interacted with Client Business users, Client Business analysts, IT Project/Business Managers and developers in analyzing business requirements and Translating requirements into Functional and technical specifications.
• Very good people management skills .i.e., proven ability to mentor, motivate and lead successful project teams.
• Strong relationship-building, presentation and negotiation skills with technical staff, resource managers, project managers, senior managers
• Good Release Management or Configuration skills/ Version control Management using Revision Control System (RCS), IBM Clear case tool on UNIX, Team Foundation Server in Visual Source Studio on Windows
• Having domain knowledge of i2 SCM(Supply Chain Management) and i2 FP(Factory Planner), Banking and Insurance.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.0.1/8.6/8.1/7.1, Power Center, SSIS

RDMS: Oracle 10g/9i/8i/8.x, SQL Server 2008 and Teradata SQL Asst

Teradata Utilities: BTEQ, Fast Load, MultiLoad, Fast Export, Tpump

Languages: SQL, PL/SQL, C, C++, Perl, Shell Scripts

Data modeling tool: ERWIN 3.5.2, Oracle Designer6.0

Reporting Tools: Business Objects, SQL Reports, SSRS, and MOLAP Cube Reports

OS: UNIX (Sun Solaris, AIX), MS WINDOWS 2000/9x/NT, Windows 7Protocols:Ftp, Telnet

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Systems Analyst / Teradata Developer/ Project Lead

Responsibilities:

• Understand the business requirements (DLR - Detail Level Requirements)
• With very good system knowledge translating the Business requirements into Technical Analysis and Design Documents
• Get the sign-off from Business Analyst and Application Owners
• Handover the requirements to Developers for Development
• Preparation of System Test cases, Integration Test cases, reviews with Application owners, Test Manager for signoff.
• Upload Test cases into Quality center and execute.
• Involved in Business Acceptance Testing, User Acceptance Testing
• Prepare DAY1 Checkout scripts.
• Responsible for builds in Release.
• As a adhoc task, created SSIS packages to pull data from Teradata (EDW) environment to DSS (Data mart) .
• Loading data from various data sources and legacy systems into Teradata production anddevelopment warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics
• Refreshed the data by using fast export and fast load utilities
• Identified potential bottlenecks with queries from the aspects of query writing
• Responsible to Manage the team of 15 in size
• Responsible for team deliverables.
• Responsible for Team appraisals and Promotions
• Responsible for Team Time Sheets & Leaves Approvals
• Involved in Internal/ External resource recruitment.
• Responsible in sending Weekly status reports with Resource Utilization, Metrics (Monthly, Quarterly, and Release Wise).

Environment: SQL Server 2008, TeraData, SAP, Visual Source Studio, Excel UI & Macros, SSIS SSRS Packages, Cognos Reports, OLAP Cubes.

Confidential

Project Manager

Responsibilities:

• Responsible to Manage the team of 20 in size
• Responsible from Project Planning to Project Closure
• Understanding the requirements, Preparing the WBS (Work Break down structure), Identifying the RAID (Risks, Assumptions, Issues, and Dependencies) and monitoring till the closure.
• Preparation of the Project Plan in Microsoft Project Management software and execute WBS & monitor RAID.
• Keep track of Resource Utilization and Controlling the budget and report planned vs actuals on Dashboard.
• Monitoring the Project team to deliver the tasks on time, Schedule Scrum calls as and when required.
• Regular client interactions on weekly basis to brief about project status, issues, risks and dependencies.
• Responsible to produce Weekly Project Status Report (WPSR) to all Project stake holders.
• Responsible to raise Change requests/Work requests/Incidents to request external team (Configuration Management Team, DBAs, Business Team Involvement, Batch Management Team, Unix/Linux Administration team, Application support team) help.
• Verify and validate the code migration process from DEVELOPMENT to PRODUCTION.
• Responsible to Prepare Implementation plan and back-out plan during the Implementation phase.
• As a mentor, providing technical guidance to the team, reviewing Technical Design Documents, Involved in Internal Quality Audit of code, and Test cases to ensure the high quality of deliverables.
• Adhere to TCS Policies, procedures related to Quality, and Appraisal process for Team Members
• Holding meetings with Legal & General Ops Managers/Sponsers to review the SLA Performance and gather feedback.
• Drive continuous Improvement plan through regular meetings, metrics Analysis and compilation
• Conduct Annual Appraisals, Mid Term appraisals for Onsite and Offshore Team.

Environment: Oracle SQL, PL/SQL, DB2, Ab Initio, Business Objects XI.

Confidential

Business Analyst/Project Leader

Responsibilities:

• Manage the team of 7 in size.
• Manage the Level 2 and Level 3 Support and adhering to SLA target of 100%.
• Requirements gathering, analyzing the solutions, Designing the solution, Creation of Test Plans, Involved in SIT and UAT
• Prioritize the Change requests and co-ordinate the development and release management process.
• Manage stakeholder forums to proactively work on the issues and concerns.
• Manage incidents and Crisis meetings related to the application
• Provide weekly dash board reports to the senior management
• Build the team’s confidence and identify the needs for team members
• Adhere to TCS Policies and Procedures related to quality, and appraisal process.
• Holding Meetings with Motorola Ops Managers/Sponsors to review the SLA performance and gather feedback
• Drive the continuous improvement plan through regular meetings via metrics analysis and compilation.

Environment: SQL, PERL Scripting, i2 Factory Planner.

Confidential

DWH Technical Architect

Responsibilities:

• Understanding the current system
• Finding the faults in the current design
• Recommendation/Improvements for the current design and Implementation.
• Future load performance improvement
• Rationalizing the Indexes, Partitioning the Tables etc for better performance
• Suggestions to upgrade the current system

Confidential, Irvine, CA

Integration Consultant

Responsibilities:

• Understanding the existing environment
• Configuring the SCP (Supply Chain Planner) engine
• Writing the SQL Queries to generate the reports using VB/EXCEL Macros
• Validation of AS/400 data
• Designed Technical Design documents

Environment: Oracle SQL, Excel VB programming, Supply Chain Planner, AS/400

Confidential, CA

Teradata Developer

Responsibilities:

• Loading data from various data sources and legacy systems into Teradata production anddevelopment warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics
• Refreshed the data by using fast export and fast load utilities
• Identified potential bottlenecks with queries from the aspects of query writing
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fast load while loading data into the target tables in Teradata Database

Environment: Teradata SQL Asst, Informatica, Supply Chain Planner

Confidential

Tech Lead, Release Manager

Responsibilities:

• Designed STAR Schema for MP SPL DWH (Memory Products of Sales and Operations Plan Data Ware House)
• Development of oracle PL/SQL functions and procedures to Populate the Dimension and Fact table of STAR Schema
• Designed Entity Relationship (E-R Diagram) diagrams for MP SPL Reporting using ORACLE Designer. Extracted the data modeling and the business rules, which are being used
• Design documentation for MP SPL Reporting
• Understand the functionality of the existing system, Suggest functionality enhancements in the existing system
• Design of the data migration between the DPL (Demand Planning) and staging schema using Informatica, also between the ODS and SPL Staging schema using Informatica, Which facilitated migration of data across the systems with high level of accuracy and speed
• Installation of Business Objects 5i for SPL Reporting
• Generation of Business object reports for SPL .
• Automation of Build check in and Checkout process using Shell scripts
• Prepared Release Notes/Documentation for SPL Reporting
• Responsible to prepare the Build checklist and execution on different environments
• Responsible to debug the build issues and solution.

Environment: Oracle SQL, PL/SQL, SQL Loader, Shell Scripting, Informatica 6.2, Business Objects XIOracle Designer 6i, RCS, Microsoft Visio.

Confidential

Developer, Team Lead, Release Manager

Responsibilities:

• Prepared Technical design document for CM ( Corporate Model) and DMAN(Demand Manager)
• Involved & helped DBA in CM and DMAN Database setup
• Designed ER Diagrams for CM, DMAN and SCM Reporting using Oracle Designer, involved in Reverse engineering of all the applications along with Client Database Designer. Extracted the data modeling and the business rules, which are being used
• Development of oracle PL/SQL functions, Procedures and Triggers to carry out the data transformation for CM, DMAN
• Installation of Informatica, ODS, Oracle etc. the Client team on the enhanced.
• Installation of Business Objects for CM Reporting
• Designed Universes, different types of Reports using Business ObjectsXI.
• Involved in Unit testing of Backend programming and ETL mappings, tasks, sessions and Workflows, and BO Reports.
• Involved in SQL Performance tuning, BO Reports Tuning.
• Development of shell scripts for end-to-end Testing
• Automation of Build check in and Checkout process using Shell scripts
• Prepared Release Notes/Documentation for CM, DMAN, CMAN
• Responsible to prepare the Build checklist and execution on different environments
• Responsible to debug the build issues and solution.
• Providing technical support to the onsite team.
• Understand the functionality of the existing system
• Suggest functionality enhancements in the existing system
• Approval of Timesheets and leaves in the system
• Responsible for Team Appraisals, Concerns and Queries.
• Mentoring the team with Instructor Led s, Learning Sessions(WBT) to achieve their competencies.

Environment: Oracle SQL, PL/SQL, SQL Loader, Shell Scripting, Informatica 6.2, Business Objects XIOracle Designer 6i, RCS, Microsoft Visio.

Confidential

Oracle Developer

Responsibilities:

• Understand the requirement
• Prepare the technical design document
• Writing PL/SQL Stored Procedures, Functions
• Creation of Database Triggers
• Designing User entry screens using D2K Forms4.5 and writing event driven programming
• Creating D2K Reports like Master/Detail, Matrix etc.
• Involved in Design of Database Schema.

Environment: Oracle SQL, PL/SQL, Developer 2000 forms

Confidential

Oracle Developer

Responsibilities:

• Understanding the requirements
• Creation of Database Tables with necessary constraints and Indexes
• Creation of PL/SQL procedures, functions and Database Triggers
• Involved in Unit Testing