Project Data
Resume:
Debayan Maitra
adbny5@r.postjobfree.com
San Bruno, California
Professional Summary:
** ***** ** ********** ** Data Warehousing/Business Intelligence using majorly Informatica PowerCenter for ETL, Oracle/SQL Server/Teradata as Database and Denodo for data virtualization.
Extensive experience in implementation of Data Analysis and Data Warehousing architecture and design.
Hands-on experience in configuring, developing, monitoring, debugging and performance tuning of Data applications using Informatica, Talend and Datastage.
Scheduled jobs in ControlM integrating Informatica and Oracle DB. Also FIletransfer between servers though the same tool
Hands-on experience in VDP setup, developing and performance tuning in Denodo.
Spearheaded requirement gathering, data analysis, data profiling and data modeling. Defined the framework for development standards and processes.
1 year of experience in Data virtualization through Denodo
Extensive experience in Change Data Capture through IBM CDC
Ingested diverse data coming from several kinds of sources through Denodo
Architecture definition, system design and database normalization
Code review using In-house code review tool and also manual code review
Extensive knowledge in Agile Process methodologies (Scrum and Kanban)
Database programming including stored procedures and query optimization
Requirements validation and use cases definitions
Extensive knowledge in Perforce as a Revision Control system
Experience in SAP Business Objects
Overseas experience in end to end project implementation as onshore lead
Experience in working with multiple teams/vendors across geographies
Technical Skills:
Operating System
Windows, Red Hat Linux
Technology
Informatica PowerCenter(8.6, 9.1.0, 10.1), Denodo, IBM CDC
Databases
Oracle, SQL Server, Teradata, MySQL
Code Review tool
In-house Informatica code review tool
Strategic planning tool
Rally, Jira
Revision Control System
Perforce
Workload Automation System
Control-M, Tidal
Reports
SAP BO
Education:
Title of the Degree with Branch
College/University
Year of Passing
Bachelor of Technology in Computer Science and Engineering
Netaji Subhash Engineering College, Kolkata, West Bengal
2007
Employment History:
Name of the Company
Designation
From
To
Duration
Perficient
Senior Technical Consultant
Sep 2019
Till date
1 years
Accenture
Team Lead
May 2008
Sep 2019
11 years
Project Profile 7:
Project Title
Best in Class
Duration
Sep 2019
Location
San Francisco, California
Technology Stack
Informatica
Database
Oracle, Netezza
Team Size
5
Project Description:
Best in Class is an Insurance information aggregation project which provides the end client the extracts on various insurance categories such as member, Provider, Account, Eligibility etc to facilitate executive analysis and decision.
Roles and Responsibilities:
This is a project started from scratch. Understood the business ask and criteria in the initial Business meetings and worked closely with solution architects to develop STTMs
Responsible for the entire Development, deployment and post production cycle of this project
Acted as a sole person responsible as the co-ordinator between QA team-UAT team-Dev Team- Architects
Provided sign offs on every code that goes into Production from dev team.
Project Profile 6:
Project Title
CAPITAL DATAMART
Duration
May 2019 – Sep 2019
Location
San Jose, California
Technology Stack
Informatica, Tidal, BO, Midas
Database
Oracle, MSSQL
Team Size
8
Project Description:
CAPITAL DATAMART is primarily an operation support project, which deals with earning data sourced from multiple heterogeneous databases and publishing it to BO and Tableu for business consumption.
Roles and Responsibilities:
Understood a 12 year old system in a quick amount of time and was able to provide critical solutions within 2 weeks of joining
Responsible for the entire production environment for CAPITAL DATAMART
Turnaround time for Issue response and resolution was appreciated by client
Provided sign offs on every code that goes into Production from dev team.
Lead the support team of 9 and closely collaborate with the DEV/QA team.
Project Profile 5:
Project Title
ETL CONSOLIDATION
Duration
November 2018 – April 2019
Location
Saint Petersburg, Florida, USA
Technology Stack
Informatica, SSIS
Database
Oracle, MSSQL, Teradata
Team Size
9
Project Description:
ETL CONSOLDIATION is a project for which we had to convert SSIS jobs upto 7 years old, to Informatica and replicate the inherent logic. This project serves as a singular window for the client decision makers to gain more insight on their customers’, cardholders’ spending pattern, fraudulent alerts, and overall predictive analysis.
Roles and Responsibilities:
Provided tangible and robust solution on the technological mplementation of DW and DM
Suggested many improvements on Informatica power center coding logics. These were appreciated by client as addon services.
Led the design walkthrough sessions with client Team
Provided sign offs on every code that goes into Stage and Production from dev team.
Lead the Dev team of 9 and closely collaborate with the QA team.
Project Profile 4:
Project Title
RevMart
Duration
December 2013 – October 2018
Location
California, USA
Technology Stack
Informatica, IBM CDC, Denodo
Database
Oracle, SQL server
Team Size
8
Project Description:
The RevMart project architects the revenue reporting model for the client. The intent is to create a robust process for absolutely accurate revenue reporting to the Wall Street, incorporating mergers/acquisitions, Geography specific tax alterations and a new subscription model. It also validates business rules specific to the institution / plan configuration, formatting the reports to an agreed upon format and send the required data to downstream applications.
Roles and Responsibilities:
Worked on data analysis and spearheaded architectural meetings to deliver an agile solution.
Created base architecture design for two modules.
Created base views and combination views for Denodo to be consumed downstream by Web Services
Worked with Aggregate views and VQL in Denodo
Led the design walkthrough sessions with client Team, obtaining sign-offs on various stages of development
Developed of Data Virtualization Views, Base Views, Derived Views, Projection, Selection, Union, Minus, Flatten Views, Interface, Associations
Performed Cache database configuration at server and database level
Performed Import and Export data virtualization database
Created Solution design for each of the modules catered by the project.
Developed ETL structure with Informatica as ETL tool and Oracle/SQL server as Database.
Worked with BO developers to clarify the business need and made sure the exact requirement gets reflected.
Efforts estimation, task breakdown, user stories as per Agile methodology
Oversaw the overall QA activity
Was involved in Code reviews, Defect fixes, deployment and software configuration management
Worked on tools like Perforce for revision control and Rally for Task management.
Responsible in analyzing requirements, prepared Solution Document with Architects to represent Data flow, Architecture Changes, Impacted Systems/services and Context diagram.
Collaboration with multiple vendors/teams across different geographies
Followed Agile software development practice paired programming and Scrum framework.
Project Profile 3:
Project Title
AXAODS
Duration
July 2013 - December 2013
Location
Kolkata, India
Technology Stack
Informatica
Database
Oracle
Team Size
4
Project Description:
AXAODS was an Informatica migration project by which Accenture helped the entire client code base to move to a server located in another country. The main challenge with this project was to take care of the modified connection properties and the post go-live validation activity with vendors participating from three countries. This project also designed client’s Disaster Recovery framework
Roles and Responsibilities:
Keeping in daily contacts with Accenture (HK) and Client (HK and China), and gather the requirements.
Get the network (FW) settings applied in the client side of the business.
Post migration, with the aid of Informatica administrator make sure the entire system is up and running.
Preparing Disaster Recovery procedure and do a simulated run of the DR.
Sign off on the related documents and send them to Client.
Project Profile 2:
Project Title
Internal Sales
Duration
September 2011 - May 2013
Location
Kolkata, India
Technology Stack
Informatica, UNIX shell scripting
Database
Oracle
Team Size
15
Project Description:
Internal Sales is a project which processed Sales data of client from various country. This process will provide a single tracking system which will combine data from different country specific sources and integrate it with information systems from other divisions. This would flow into the datamart from which client reporting team creates dashboard as per client requirements
Roles and Responsibilities:
Worked with business users and business analyst for requirements gathering and business analysis.
Converted business requirement into high level and low level design.
Designed and customized data models for Data warehouse supporting data from multiple source.
Extracted data from different sources like Oracle, flat files, MS Excel and transformed the data based on user requirement using Informatica Power Center and loaded data into target.
Scheduled the workflows, worklets and sessions.
Worked on Informatica Power Center - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also tuned mappings for better performance.
Created reusable mapplets and Transformations .
Created Shell scripts for file operations.
Created sequential batches and concurrent batches for sessions.
Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
Project Profile 1:
Project Title
VendorMax
Duration
October 2008 - August 2011
Location
Mumbai, India
Technology Stack
Informatica, Control-M
Database
Teradata
Team Size
6
Project Description:
VendorMax project is a multifaceted data warehouse project that enables client management and sales team to analyze the business over an extended period of time. Budgeting and forecasting decisions are based on the reports produced using this data warehouse.
Roles and Responsibilities:
Analyze client requirements.
Created Dimension Tables and Fact Tables based on the warehouse design.
Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates
Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema
Created the Source and Target Definitions in Informatica Power Center Designer
Created Reusable Transformations and Mapplets to use in Multiple Mappings
Developed and updated documentation of processes and system.
Assembly Test entire flow.
Professional Accolades:
Awarded Quarterly ACE Award recognition for delivery and client satisfaction.
Ranked 1st by Accenture as the ASE Topper of the Batch for BI Stream.
Appeared in National IT Aptitude Test and scored among top 2% in India.
Contact this candidate