Senior Informatica Developer/Data Architect
Resume:
SAYAK GHOSH
************@*****.***
CHICAGO, IL
LINKED IN URL: https://www.linkedin.com/in/sayak-ghosh-informatica-dwbi/
SUMMARY
Over NINE Years of Experience in Designing, Development and Implementation of Operational Data Stores, Master Data Management, Data Warehouses & Data marts using Informatica Power Center, Informatica IDQ and Informatica Cloud.
Have created multiple subscription data models using Informatica DIH for data warehouses and external vendors.
Accomplished creating many data integration projects using Informatica involving multiple types of data sources both on-premise and cloud. The cloud sources have been MS Dynamics and SalesForce.
Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, testing, implementation and post-implementation review.
Possess wide range of IT industry experience with Pharma Domain (Sales and Marketing), Travel and Hospitality Domain (Real Estate) etc.
Good knowledge of XML mappings, xsd schema definitions and xml sources and targets.
Worked using Power Exchange to pull data using Web Services from application built of SAP, Salesforce.com etc and used SOAP requests in WSDL transformation and source to pull data.
Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.5.1/9.1/8.6/8.5/8.1.1.
Proficient in Extracting, Cleaning, Transforming and Loading the data using all the Transformations in the ETL tool Informatica.
Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
Involved in Debugging and Performance tuning of targets, sources, mappings and sessions
Extensive experience in developing reusable transformations and mapplets embedding the business logic. Installed different IDQ services in Informatica 91.
Extensive experience on using informatica to load data to Netezza using Informatica power exchange for netezza utilities.
Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables.
Involved in preparing migration documents to move the mappings from development to production repositories. Good Knowledge on using scheduling tools to automate running of Informatica workflows. Involved in UNIX shell scripting, FTP and file management in various UNIX environments
Team player and self-starter with good communication skills and ability to work independently and as part of a team.
Sound knowledge of Microsoft Visual Basic (VB and VBA Excel).
Excellent in developing macros in VB Excel.
Sound knowledge in development projects of Informatica.
Excellent communication skills, strong problem solving skills, good team player and self-starter.
Involved in full lifecycle of several projects including requirements gathering, analysis, design, development, testing and debugging.
Experience in writing Integration and System Test Scripts.
EXPERIENCE
Project #1:
Organization
Cognizant Technology Solutions
Project Title
Property Master Data Management
Duration
03/23/2015 – present day
Location
Lombard, IL, USA
Tools
Informatica Power Center 9.6.1 hotfix, Informatica Developer 9.6.1 hotfix, SQL Server 2012, Control M
Operating Systems
Windows 2008
Programming Languages
SQL/PL-SQL, Windows Batch Script
Project Description:
Property Master Data Management is a in house application which stores and Property and Contract data for all clients coming from different sources like Work Order, Lease Agreement, CRM and stores as a single version of truth. This is a very vital part of data management because company’s entire data reporting revolves around this Master Data.
Client Description:
JLL is a financial and professional services firm that specializes in commercial real estate services and investment management.
Roles and Responsibilities:
Senior ETL Developer and Data Architect:
Developed complex maps to cleanse incoming properties data
Used Informatica Address Doctor to cleanse addresses and find the health of the incoming data
Used Bing and Google geo coding location APIs to enrich the data with proper geocodes of the properties
Used Informatica Data Quality to generate web services and read Soap and RESTful APIs
Created Subscriptions with DIH
Developed Error Handling Methods in case a property address is not up to the business standards
Developed dynamic email notification system to send proper information to the concerned parties who are the stewards of the incoming data
Lead a group of four people which included developers and testers
Extensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
Actively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
Used deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
Developed ETL process which audit’s ETL loads, passes incremental parameters and deletes bad data in the case of partial runs
Project #2:
Organization
Tata Consultancy Services Limited
Project Title
PayerRx
Duration
April 2013 - 03/23/2015
Location
Indianapolis, IN, USA
Tools
Informatica 9.1, Netezza, Linux, SSAS, Tableau,Quality Center and WA
Operating Systems
Linux
Programming Languages
SQL/PL-SQL, Linux Shell Script
Project Description:
Design and Development of an analytics platform on the Medical Payers and their relationship with pharmaceutical company where business can make decisions based on Lives, Formularies and Rx of any product. The design involved creating a data warehouse to bring in facts like Formulary status, Lives and Sales and delivering requested extract for various reporting purposes.
Client Description:
Client is a leader in the pharmaceutical industry. The company employs more than 31,000 people worldwide and markets its medicines in 179 countries. Client has major research and development facilities in 9 countries and conducts clinical trials in more than 30 countries. The Client is a pharma giant in United States who has created numerous drugs mainly in areas like Diabetes, Growth Hormones, Men’s Health etc.
Roles and Responsibilities:
System Architect:
oUsed Data Transformation Studio to configure and deploy data transformation service required to load HL7 messages from message queue to relational tables
oResponsible for installing and maintaining OHADI (Oracle Healthcare Analytics and Data Integration) repository and required ETL components
oDeveloped error handling strategy which was implemented enterprise wide as a standard to process data from all source systems, the process uses a re-usable Informatica code which uses custom SQL queries to populate the errors from source system
oLead a group of four or more junior and senior developers on a variety of development projects which involved moving data from different sources to Health care Data Warehouse
oExtensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
oActively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
oPart of Code review and design review boards responsible for making sure the codes adhere to the UPMC standards and signing off the Informatica solutions before development, respectively
oUsed deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
oLead Informatica developer on the project which loads patient encounters originating from Medipac source system, the process used several background log tables to covert the incoming message event feed into data with value
oWorked extensively on developing re-usable logics which are used in multiple projects
oDeveloped ETL process which audit’s ETL loads, passes incremental parameters and deletes bad data in the case of partial runs
Project #3:
Organization
Tata Consultancy Services Limited
Project Title
Specialty Data Analytics
Duration
Jan 2014 – Dec 2014
Location
Indianapolis, IN, USA
Tools
Informatica 9.1, Netezza, Linux, SSAS, Tableau,Quality Center and WA
Operating Systems
Linux
Programming Languages
SQL/PL-SQL, Linux Shell Script
Project Description:
Design and Development of an analytics platform for Specialty Drugs. Specialty Drugs are those drugs which needs a specific usage, and storage mechanism. The administration of those drugs are monitored and patients are taught on the usage.
Client Description:
Client is a leader in the pharmaceutical industry. The company employs more than 31,000 people worldwide and markets its medicines in 179 countries. Client has major research and development facilities in 9 countries and conducts clinical trials in more than 30 countries. The Client is a pharma giant in United States who has created numerous drugs mainly in areas like Diabetes, Growth Hormones, Men’s Health etc.
Roles and Responsibilities:
System Architect:
Developed and SDA2 type data warehouse model where Specialty Drugs data would come from different sources.
Developed error handling strategy which was implemented enterprise wide as a standard to process data from all source systems, the process uses a re-usable Informatica code which uses custom SQL queries to populate the errors from source system
Lead a group of four or more junior and senior developers on a variety of development projects which involved moving data from different sources to Health care Data Warehouse
Using SSAS, developed and analytical model to slice and dice the data
Using Tableau, generated reports over the SSAS cube
Project #4:
Organization
Tata Consultancy Services Limited
Project Title
Profit Loss Operation Tool (PLOT)
Duration
June 2012 – March 2013
Location
Noida, U.P., India
Tools
Informatica 9.1, Netezza, Linux, SSIS, Tableau,Quality Center and WA
Operating Systems
Linux
Programming Languages
SQL/PL-SQL, Linux Shell Script
Project Description:
Profit and Operation Tool (PLOT) was a major development project. In order to improve business ownership, sales leadership acumen and accountability among the Sales leadership in US affiliate, Client’s US affiliate management have expressed the need for a system that will allow viewing P&L (Profit and Loss) reports at territory level, providing flexibility to analyze OPEX (Operational Expense) leveraging an allocation scheme where territory level OPEX doesn’t exist, and ad-hoc capabilities to analyze sales and resource allocation information.
Client Description:
Client is a leader in the pharmaceutical industry. The company employs more than 31,000 people worldwide and markets its medicines in 179 countries. Client has major research and development facilities in 9 countries and conducts clinical trials in more than 30 countries. The Client is a pharma giant in United States who has created numerous drugs mainly in areas like Diabetes, Growth Hormones, Men’s Health etc.
Roles and Responsibilities:
Understand and analyze Business, Functional, Technical and requirements for Profit and Loss Operations Tool.
Designing Powercenter Informatica Mappings and Workflows as a solution with equal focus on business requirements and performance and the data quality.
Track and prepare the report of development activities.
Understand the testing effort and keep track of the new requirements / change in requirements of the project.
Create the Test Plan, Test Scenarios, Test Cases, Test conditions and expected results for Unit and Integration testing
Create Test Scenarios, Test Cases, Test conditions and expected results for module, integration and system testing.
Perform Testing for the code developed by other team members.
Check / Review the Test Cases documents prepared by other team members.
Coordinate offshore activities of the project and ensure the timely delivery of different deliverables.
Implementing and monitoring process improvement and quality assurance processes.
Applications related Issue Tracking & Resolution using help of TCS Experience Based KM (Knowledge Management) tool.Recording solutions of recurring errors/problems in Consult Repository.
Project #5:
Organization
Tata Consultancy Services Limited
Project Title
Demand Sales Legacy
Duration
Oct 2009 – May 2012
Location
Noida, U.P., India
Tools
SQL Server 2008, VBA Excel
Operating Systems
Linux
Programming Languages
SQL/PL-SQL, VB Script
Project Description:
IN Demand Sales Legacy, Incentives were generated every quarter based on the sales of the drugs. The Incentives were calculated based on series of rules which was stored in form of data tables.
Client Description:
Client is a leader in the pharmaceutical industry. The company employs more than 31,000 people worldwide and markets its medicines in 179 countries. Client has major research and development facilities in 9 countries and conducts clinical trials in more than 30 countries. The Client is a pharma giant in United States who has created numerous drugs mainly in areas like Diabetes, Growth Hormones, Men’s Health etc.
Roles and Responsibilities:
Gather account sales data from a third vendor using Informatica and process the data using SAS, run various extracts from the data for other functions in Sales Legacy. This process is done on a weekly or monthly basis.
Process alignment data for various sales representatives with different geographies. This process is done on a monthly basis to check what are the changes in alignment of the Sales Rep are and notify clients in form of reports.
Align sales rep data with all other physicians and accounts.
Process and design sales data in SQL-SERVER and VBA using alignment data to fix quota/goal for the sales representatives for forthcoming quarters. This is a quarterly process and all the necessary reports needed to deduce the future goals for Sales Rep are send in form of reports.
Process data in SQL-SERVER and VBA using sales data from physicians, accounts, alignment data and payment curves provided by client to generate Incentive Reports for Sales Representative. These reports are generated monthly and are used by Sales Rep and their managers to see how much incentives are they liable to get paid.
Process Change Requests using REMEDY tool in any of the above using SLA.
In addition to these, I was also responsible for maintenance of the applications, make changes in the application as per business changes through Change Requests.
Project #6:
Organization
Tata Consultancy Services Limited
Project Title
CARS Data Staging
Duration
May 2009 – Sep 2009
Location
Indianapolis, IN, USA
Tools
Informatica 8.6, Netezza, Linux, Quality Center and WA
Operating Systems
Linux
Programming Languages
SQL/PL-SQL, Linux Shell Script
Project Description:
Chargeback and Rebate System (CARS) data needed to be loaded in data warehouse using SCD 2 method for reporting purpose.
Client Description:
Client is a leader in the pharmaceutical industry. The company employs more than 31,000 people worldwide and markets its medicines in 179 countries. Client has major research and development facilities in 9 countries and conducts clinical trials in more than 30 countries. The Client is a pharma giant in United States who has created numerous drugs mainly in areas like Diabetes, Growth Hormones, Men’s Health etc.
Roles and Responsibilities:
Developed complex mapping to load file data into stage layer
Used parameters and variables to capture the date of loading
Project #7:
Organization
Tata Consultancy Services Limited
Project Title
Clinical Data Management
Duration
Dec 2007 – Apr 2009
Location
Indianapolis, IN, USA
Tools
Inform, Clintrial
Operating Systems
Windows
Programming Languages
SQL/PL-SQL, VB Script
Project Description:
The webpages and back end data capturing tables were created for all the clinical studies that were done on humans.
Client Description:
Client is a leader in the pharmaceutical industry. The company employs more than 31,000 people worldwide and markets its medicines in 179 countries. Client has major research and development facilities in 9 countries and conducts clinical trials in more than 30 countries. The Client is a pharma giant in United States who has created numerous drugs mainly in areas like Diabetes, Growth Hormones, Men’s Health etc.
Roles and Responsibilities:
Developed VB codes as rules which were called to check the sanctity of data when fed by any used during Clinical Trials
Developed PL/SQL to cleanse and organize the data which was then sent for reporting
EMPLOYMENT HISTORY
Name of the Company
Designation
Address of the employer
From
To
Cognizant Technology Solutions
Senior Associate
500 Frank W Burr Blvd,
Teaneck, NJ 07666
Mar 2015
Present
Tata Consultancy Limited
Assistant Consultant
7361 Calhoun Pl #340,
Rockville, MD 20855
Aug 2007
Feb 2015
EDUCATION
Title of the Degree with Branch
College/University
Year of Passing
B.E.
B.V.B. Engineering and Technology, Karnataka
2007
XII
Science College, Bihar
2002
X
St. Karen’s High School, Bihar
2000
Skills
Technical Skills
Tool:
- Informatica 9.6.1
- Informatica Data Quality
- Informatica Analyst
- Informatica DIH
- Informatica B2B
- Toad 11.0
- Toad for DA
- SSMS
- AGINITY
- WA Scheduler
- Control M
Programming Languages:
-SQL/PL-SQL
-Unix/Linux
-DOS
Scripting Language
- Unix/Linux
- VB Scripting
Database:
- IBM Netezza
- Oracle
- MSSQL
- SQL Server
Utilities:
-VM Ware
-MS Office Suite
-Toad
-SQL Developer
-REMEDY
-Quality Center
-Visio
-VSS
OS:
-Unix/Linux
-Windows Vista/XP
Soft Skills:
-Dressing Grooming
-Articulation skills
-Basics of Business
-Effective Meetings
-English Edge
-Global Effectiveness
-Group Discussion
-Learning to Learn
-Personal Effectiveness
-Presentation Skills
-Professional Practices
-Speak up
-Written Communication skills
Contact this candidate