SRIMOYEE BAGCHI

Email: ac8n6w@r.postjobfree.com

Current Location: TORONTO, ON, CANADA

Cell: +1-647-***-**** CANADA WORK PERMIT HOLDER

EXPERIENCE (Summary)

IT Experience: 9+ Years

I have always been at the forefront of value creation for my customers and company. I have consistently articulated strategic direction and vision as well as develop and execute plans aligned with desired business outcomes

I have extensive Data Analytics experience across the following domains: Logistics, Marketing and have strong hands on experience in Base SAS, Macro Facility, SAS-SQL, experience in generating periodic and ad hoc reports for various projects

I have extensive project delivery /business analysis and client engagement experience for a major Logistics companies in North America and strong domain experience in Marketing Campaign as well as Marketing Analytics

I have experience in working in multi-vendor environments and has shown excellent leadership skill with proven excellence in managing teams in onsite-offshore model

As part of my assignments, I have been involved in Data Analysis Implementations, enhancement and supports, capturing business requirements, building gap analysis, authoring required designs, customer demos and Support and Enhancement. I have also worked managing projects in the capacity of tracking and estimations, in additions to Business as Usual Onshore support.

Achievements / Certifications:

BASE SAS Certification

Advanced SAS Certification

Recipient of the best performer award in Bridgetree

IELTS Score : 7.5

Latest Trainings Attended

Advanced SAS Course from SAS Institute

CAREER PROFILE :

Company

Bridgetree Consultancy Private Ltd.

Period

Sep 2006 till Feb 2016

Designation

Project Manager, Data Analysis Unit

Responsibilities

•Analysis of Change Requests and defects from Business on customer and transactional data management

•Coordination among various team during Deployment, Coordination with the Infrastructure team to fix the defects and post release support for Business Sanity

•Maintaining and updating database, matching among database, Report Management, Mailing/Email/Phone Campaign parts of the customers in SAS Projects

•Weekly and Monthly Status Update to Stake Holder

•Coordination Defect Triage and Defect Review Board across all IT and business stakeholders

•Coordinating the Testing Activities with QA and Business Users respectively

•Fine tuning and resolution of Reporting Performance Issues along with close coordination with related stake holders

Work location

KOLKATA, INDIA AND UNITED STATES

PROJECTS EXECUTED:

Title

Lowe’s Pro Mailfile and Pro Grand Opening Mail File and other ad hoc& regular Mail files

Period

November 2012- Feb 2016

Position

Data Analyst, SAS Lead

Responsibilities

Being the Lead Data Analyst and SAS lead, my main responsibility was the following:

•Design and develop the programming from scratch according to Client’s requirement

•Co-ordinate among Client team, Business team and my data team. Participating in Touch

•Base meetings regularly

•Development and design unique solutions for client which client can use for their vast customer database and solving issues from UAT logs

•Maintaining and updating Customer database

•Doing various testing and reporting for client approval

•Post campaign Responder Analysis to evaluate the efficiency of the mailing campaign

Project Background

Lowes is one of the biggest Home Improvement Company in US and in Canada.

1. In Pro Mailfile project they want to encourage their Business consumers to buy more in bulk amount by giving them special substantial discounts in specific office and building products.

Lowes wanted Bridgetree to make a list of consumers who will likely appreciate the offers and increase their respective sales amount.

2. In Grand Opening Mailfile Lowe’s wanted Bridgetree for creating campaigns to select prospective customers for the new opening stores.

This was done in two steps. First a call list is made from nearby Business customers. From the call list, selective consumers are chosen for mailfile.

As part of this programme carried out the following activities

•Gathered business requirements

•Wrote Design document for customer approval and proceed with technical piece of work

•Developed SAS codes to meet the requirements

•Used Task scheduler to generate automated reports weekly

•Used SAS Macro for the development and SAS SQL to access client Database

•Worked in a tight schedule and submitted within deadline without fail

•Used Statistical and other methods for through testing

•Made many Demographic profile reports to decide the mailing criteria for the mailfiles.

Special Software

SAS 9.3, Mailers, Mail Manager

Database

Teradata, Lower database

Work location

KOLKATA, INDIA, United States

Title

Lowe’s Sales Specialist Planning Tool

Period

December 2012- Feb 2016

Position

Data Analyst, SAS Lead

Responsibilities

Being the Data analyst and SAS lead, my main responsibility was the following:

•Understanding the basic Client requirements and taking data lead to launch the tool

•Design and develop the programming from scratch according to Client’s requirement

•Co-ordinate among Client team, Business team and my data team. Participating in Touch

•Base meetings regularly

•Maintaining and updating Customer database

•Doing various testing and reporting for client approval

Project Background

Lowes is one of the biggest Home Improvement Company in US and in Canada.

In this project Lowe’s wanted Bridgetree to make a tool by which the performances of their sales specialists as well as stores can be visualized and can be compared to their goal performances.

As part of this programme carried out the following activities

•Gathered business requirements

•Developed SAS codes to meet the business requirements

•Used Task scheduler to generate automated reports weekly

•Used SAS Macro for the development and SAS SQL to access client Database

Special Software

SAS 9.3

Database

Teradata, Lower database, SQL Server

Work location

KOLKATA, INDIA, United States

Title

Chamber of Commerce database

Period

December 2014- Feb 2016

Position

Data Analytics Lead

Responsibilities

•Scrapping raw data from various from Chambers of Commerce.

•Data Hygiene and construction of database

•Maintaining and updating Customer database

•Doing various testing and reporting for client approval

Project Background

This is an in-house project. Our goal is to make a database of local business names and contact information and to sell it as per requirements.

•As part of this programme carried out the following activities

•Developed SAS codes to meet the requirements

•Used SAS Macro for the development and SAS SQL to access client Database

•Many manual inspections and testing, managing a big group

Database

Bridgetree Database

Special Software

SAS 9.3

Work location

KOLKATA, INDIA AND United States

Title

Abbott Pharmaceuticals and Nutrition

Period

Jan 2010-September2012

Position

Data Analyst, Assistant Lead

Responsibilities

•Assist to develop the codes per client demand

•Co-ordinate among Client team, Business team and my data team. Participating in Touch

•Base meetings regularly

•Development and design unique solutions for client which client can use for their vast customer database

•Maintaining and updating Customer database

•Doing various research works for client

•Generating numerous reports weekly for client approval

Project Background

Abbott is one of the big multinational Pharmaceuticals and Nutrition company. They have many popular brands like Similac, Pediasure, Pedialyte, Zone Perfect etc. Abbott wanted us to maintain their database for US, i.e., adding new data to database, removing bad data, marking inactive and Government aided people data, removing duplicates etc. Abbott also wanted us to manage their Recall Mailing.

As part of this programme carried out the following activities

•Compilation of raw data from various sources. Data Hygiene

•Database maintenance

•Used SAS Macro and SAS SQL to access client Database

•Worked in a big group with chain work system and very tight deadline

Database

Client database

Special Software

SAS 9.3

Work location

Kolkata, India

Title

Yellow Pages

Period

Jan 2010 – Dec 2013

Position

Data Analytics Lead, SAS

Responsibilities

•To develop the SAS codes according to client requirement

•Co-ordinate among Business team and my data team

•Updating Customer database

Project Background

Yellow Page is a US based Directory which keeps name and address information of the local Business and Non-Business contacts for different market area.

They wanted Bridgetree to collect the required contacts from our own consumer and Business database and categorize them in Consumer and Business segments, Cleaning and deduping data, marking new data from that year. As part of this programme carried out the following activities

•Compilation of raw data from various sources. Data Hygiene

•Database maintenance

•Used SAS Macro and SAS SQL to access client Database

•Many manual inspections and testing, working in a big group, submitted with very high accuracy

Database

Bridgetree Database

Special Software

SAS 9.3, Mailers, Mail Manager, Excel

Work location

Kolkata, India

Title

Bailey Tobacco Corporation

Period

January 2007- December2009

Position

Data Analyst

Responsibilities

Being the Data analyst, the main responsibilities included:

•Assist to develop the SAS codes according to client requirement

•Updating Customer database

•Assisting to make mailing lists

•Making statistical analysis to compare the client performance to competitor’s performances

Project Background

Bailey is an US based tobacco company. They wanted to manage their database as well as preparing regular mailing lists. They also wanted us to compare their sales to that to their competitors.

As part of this programme carried out the following activities

Compilation of raw data from various sources. Data Hygiene.

Database maintenance.

Prepare Mailing lists.

Many manual inspections and testing, working as a team member

Database

Client Database

Special Software

SAS 9.3

Work location

Kolkata, India

ACADEMIC BACKGROUND:

MASTER OF SCIENCE in Statistics from Calcutta University, India in 2006 with 60%

B.Sc. in Statistics (Hons) from Ashutosh College, under Calcutta University, India in 2004 with 63.5%

Contact this candidate