Profile

• More than 8 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Successfully managed BI projects in onshore and offshore locations.
• Extensive experience in design and delivery of large datawarehousing projects.
• Led the Ab Intio Center of Excellence for TCS
• Trained in Ab Initio architecture and latest product suite from Ab Initio Corp. UK.
• Experience in conducting Ab Intio training including development of training materials
• Strong experience in Software Design and Development primarily in various Data warehousing/Business Intelligence projects.
• Has been involved in Design, Development, and Implementation of Business Applications under UNIX.
• Strong expertise in ETL development, analytics and Data warehousing concepts
• Experience in several RDBMS environments
• Developed a utility in Perl for ensuring better deliverables by checking the code for redundancies and compliance with standards.
• Extensive experience in banking TD Bank, Amex, Citi Group, JPMChase, Barclays and telecom AOL, British Teleom sector. Worked in Insurance Standard Life sector.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Skill Set

• ETL: Ab Initio 3.0.3 GDE, COOP, EME, Data profiler, BRE , Informatica
• RDBMS: Oracle 10g, MS-SQL Server 6.5/7.0, Teradata, Netezza, Redbrick
• Languages: C, Shell, Perl, Oracle SQL,
• O/S: Windows NT/2000 Server, HP-UX 11.1, Linux, Sun Solaris
• Scheduler: Autosys, Maestro
• Modelling: Erwin, Visio
• Processes: IBM's QMS Quality Management System

Professional Experience

ETL Lead Confidential

• Confidential is working as ETL Architect and Lead for MBNA phase 1 project in London, Ontario for TD Bank. He is involved from the inception of the project. Initially he was involved in the planning and estimation and requirement specifications. Currently he is working on the low level design and architecture for ETL and leading the team of offshore designers and developers. Here Ab Initio GDE 2.15 and Coop is being used. The project is an integration of acquired MBNA business with existing TD process. As a part of this project, his assignment included the following activities:
• Responsible for leading a project team in delivering solution to the customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing estimation, scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in BI and ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Ab Initio GDE and Coop 3.0.3, Web Services, EME, BRE, Metadata Hub, Oracle, Foxpro, SQL Server and AIX.

Team Size : 20

ETL Lead Confidential

• Confidential is working as ETL Architect and Lead for Standard Life Solvency 2 project in Edinburgh. He is involved from the inception of the project. Initially he was involved in the feasibility study and preparation of high level funcational specifications. Currently he is working on the low level design and architecture for ETL and leading the team of offshore designers and developers. Here Ab Initio GDE 3.0.3 and Coop is being used as well as other products like BRE and Data Profiler and Metadata Hub. PDL and metaprogramming features of Ab Initio is extensively used in this project. As a part of this project, his assignment included the following activities:
• Responsible for leading a project team in delivering solution to the customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing estimation, scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in BI and ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Ab Initio GDE and Coop 3.0.3, Wed Services, EME, BRE, Metadata Hub, Oracle, Foxpro, SQL Server and AIX.

Team Size : 20

ETL Lead Confidential

• Confidential is working as ETL designer and Lead from Barclays Technology Centre. Here Ab Initio GDE 1.15 and Coop 2.15 is being used as well as other products like BRE and Data Profiler. PDL and metaprogramming features of Ab Initio is extensively used in this project. As a part of this project, his assignment included the following activities:
• Responsible for leading a project team in delivering solution to our customer in the Finance sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in BI and ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Key projects handled so far include UKRB-FSCS, Customer Matching SCV

Environment: Ab Initio GDE 1.15, COOP 2.15, EME, BRE, Teradata, Tivoli, HP-UX

Team Size : 12

TCS is a leading software consulting and services company catering to most of the big companies.

Integration Analyst Confidential

• Confidential was managing the Integration BI team for CITI-Symphony from onshore - Baltimore. There was a sizeable development team offshore, having ETL developers, Cognos reporting developers and data modellers. This was an integration project where features of Ab Initio like Continuous flows, XML parsing and Queue processing were used. As a part of this project, his assignment included the following activities:
• Work with Business in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization Analyze product impact
• Interaction with CRM and Legacy teams and creating the functional requirements.
• Delivery management in Agile Methodology.
• Present and defend product designs and architecture to clients
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
• Communicate activities/progress to project managers, business development, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: Ab Initio GDE, EME, Coop, Continuous Flows , TIBCO, Chordiant, Oracle, Teradata, Erwin, Cognos, Unix

Team Managed : 20

Architect/BI Project Lead Confidential

• The scope of this Data Warehousing project is to provide various data warehousing solutions according to the business requirements of the Student Loans Corp of CITI Group. ETL was used to load the data into the datawarehouse using daily and monthly batch processes. Reporting was done using SAS to cater to the business. Student Loans is a line of business within CITI having an entity of its own, with CITI having a majority a majority stake in it.
• Soumya was leading the ETL, Reporting and the Application Support Team of this project from onshore. Main responsibilities included
• Handled Multiple roles and responsibilities Lead architect, Designer, project manager in the BI project as well as one data migration project.
• Outside the BI requirements, implemented integration and migration of heterogenous databases into Oracle using Ab Initio as the data migration tool.
• Spearheaded the whole effort and successfully migrated Ab Initio environment from 2.13 to 2.15.
• Delivery and resource management
• Designed and developed ETL codes. Involvement in architecture, design and review as well as data modelling.

Environment: Ab Initio, Linux, SAS, SQL Server 2005, Oracle, PL/SQL, Autosys, Erwin,SAS

Team Managed : 15

• Confidential Ab Initio Centre of Excellence was one of the various product CoEs of the BI practice in TCS. It was an internal group to provide presales, solutioning and delivery support to internal and external customers.
• Soumya was leading the Ab Initio CoE in TCS.

As a part of this assignment he was involved in

• Liaison with Ab Initio Corporation
• Conducting various trainings and workshops in and out of TCS.
• Asset development
• Engaging in presales support, working with RFPs
• Providing delivery support to various projects.
• Consulting assignments in various client locations
• Taking interviews, mentoring and helping in resource development.

Environment: Ab Initio GDE, EME, BRE, Coop, Data Profiler

Team Managed : 5

Confidential

• Soumya was working as the ETL designer in this project. Responsibilities involved
• The scope of this Data Warehousing project is to generate an internal performance review dashboard as per the customer experience for British Telecom UK. 21st Century Customer Experience Dashboard gathered customer feedbacks from various systems, integrated them and presented a dashboard for the management.
• Creating the ETL design documents
• Design and code review
• Effort estimation
• Interacting with modeling and reporting team to finalize the design

Environment: Ab Initio, Linux, OBI, Oracle

• Confidential Soumya was initially involved in business discussions and knowledge transition from Virginia US. Then he was working in the Mumbai office in the AOL project and ETL lead. He was involved in
• Development and unit testing of Ab Initio graphs
• Code reviews and peer reviews
• Creating technical design documents

Environment: Ab-Initio, Unix.

Confidential

• Soumya was a part of this project from offshore and onshore, and his assignment included the following activities
• preparation, code review, string testing, integration testing and regression testing .
• The scope of the project includes the high level design, detail technical design, development of Ab Initio graphs, development of AutoSys scripts for job scheduling and testing test strategy test case
• The development environment consists of Ab Initio Graphical Development Environment GDE v1.13 installed in developer's desktops which directly connects to the remote Ab Initio CoOperating system v2.13 installed in an 8 / 16-processor blade server located at the client location in USA. The connectivity is established through VPN over IBM's Global Resource Network GRN . Enterprise Meta Environment EME of Ab Initio is being used for metadata and configuration management.
• is the world's leader in interactive services providing consumers with valuable, convenient, relevant, and enjoyable online experience. The project is part of an Enterprise Data Warehousing EDW initiative for improved customer analytics, product performance management and click stream analysis. Ab Initio is being used as Extract, Transform and Load ETL tool for transforming and loading terabytes of data out of the internet browser log files binary and ASCII , telecom switches and Sybase operational databases into the normalized and star-schema created in IBM's Redbrick, Oracle 9i databases and state-of-the-art Netezza Performance Server.
• Development and unit testing of Ab Initio graphs
• Code reviews and peer reviews
• Creating technical design documents

Environment: Ab-Initio, Unix, Redbrick, Netezza