Puja Roy

Data Warehouse Analyst Data Modeler ETL Developer Report Developer

Email: ac59mi@r.postjobfree.com Contact No.: +1-848-***-**** 1 Rustic Ridge Rd, Little Falls, NJ 07424

Master of Science (M.S.) in Analytics - Concentration in Forecasting with Machine Learning Cover Letter:

Dear Hiring Manager

My profile reflects almost 6 years of IT experience of extensive in-depth knowledge and hands-on experience in Software Requirement Analysis, Estimation, Documentations, Extract, Transform and Load

(ETL) development on T-SQL using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Data Modeling, Business Intelligence (BI), Implementation/Deployment, Support/Enhancement and Maintenance on various platforms in Banking and Financial domain along with Stakeholder management, Inter-facing with Customers and skilled in DWH/ETL Platform. I had worked for General Electric through Tata Consultancy Services Ltd. for almost 6 years. During this tenure I was in General Electric London office for nearly 1year handling one of their critical projects. As a Data Warehouse Analyst / Data Modeler / SQL Developer / ETL Developer,

I specialize in technical activities focusing on business architectural design, systems architectural design, upgrades with emphasis in rendering complete solutions to evolving business needs during implementations, upgrade, data conversions and systems integration.

Provides leadership in the design solutions, implementation, and maintenance of Data Warehouse solutions. Provides technical oversight for database object creation, performance, monitoring, tuning and capacity planning.

Coordinate with development teams and other data warehouse SMEs to determine data modeling and transform process requirements.

Provide data models and actionable information to support organization initiatives in reporting, querying, and analytics.

Provide support for reporting toolsets, data modeling toolsets, and legacy data warehouse as needed.

Designed conceptual data model based on the requirement, interacted with non-technical end users to understand the business logics.

Modeled the logical and physical diagram of the future state, Delivered BRD and the low-level design document.

Discuss and develop Data model, data flow and data mapping with the application development team.

Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.

Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.

Identify data sources required to build the reports, dashboards or analytics applications. After reviewing the requirements for the position, I am applying as a qualified candidate. I am confident that I can make a strong contribution to your team. I feel that my experience demonstrates a strong record of accomplishment in these areas.

Thanks & Regards,

Puja Roy

1 Rustic Ridge Rd, Little Falls, NJ 07424

848-***-****

Puja Roy

Data Warehouse Analyst Data Modeler ETL Developer Report Developer Email: ac59mi@r.postjobfree.com Contact No.: +1-848-***-**** 1 Rustic Ridge Rd, Little Falls, NJ 07424

Master of Science (M.S.) in Analytics - Concentration in Forecasting with Machine Learning PROFESSIONAL SUMMARY:

Worked as an IT Analyst at Tata Consultancy Services Limited since March 2012 to Dec 2017. Have end-to-end experience in Software Requirement Analysis, Estimation, Documentations, ETL Development, Execution and Management, Defect Resolution, BI Reporting, Implementation/Deployment, Support/Enhancement and Maintenance.

Have in-depth knowledge in Extract, Transform and Load (ETL) development using SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).

Designed conceptual data model based on the requirement, Interacted with non-technical end Users to understand the business logics.

Modeled the logical and physical diagram of the future state, Delivered BRD and the low level Design document.

Discuss and develop Data model, data flow and data mapping with the development team.

Discuss and Develop Conceptual Data Model

Integrate multiple data Models and create a Single Unified Model

Translated and assembled business requirements into detailed, production-level technical Specifications, detailing new features and enhancements to existing business functionality.

Experience in database design which includes the concept of fact and dimension.

Experience in debugging, fixing, query optimization and performance tuning.

Software Development Life Cycle -Waterfall and Agile Methodologies

Unit Testing of T-SQL code by creating test data.

Experience in reporting using SAP Business Objects and SAS Enterprise Guide.

Troubleshooting of Production issues within SLA.

Excellent oral and written communication skill.

Adaptable to change, Strong Attitude, Creativity and Analytical approach to problem solving and Highly task oriented.

Ability to handle multiple assignments with critical deadlines and changing priorities.

Create and refine data visualization and interactive dashboards using QlikView, Tableau, Power BI, SQL Server Reporting, and other software.

Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

Engaged in data profiling to integrate data from different sources and Performed the gap Analysis and impact analysis.

Assisted DBAs on support needs and provided guidance on architectural issues.

Participate in the maintenance and development of online web reporting capabilities.

Work closely with clients from academic and administrative units to define requirements and Solutions and provide decision support consultations.

Partner with IT staff to develop efficient data structures, provide access to data and participate in Data conversion and data migration efforts.

Collaborate with financial analysts on complex analyses.

Document best practices, processes, utilities, and reports.

Experience working in JIRA, Confluence, Service-Now.

Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.

Collaborated on the data mapping document from source-to-target and the data quality Assessments for the source data.

EDUCATIONAL QUALIFICATION:

Bachelor of Technology (B-Tech) with specialization in Electronics and Communication Engineering from WBUT, Kolkata India.

Pursuing Master of Science (M.S.) in Analytics degree from Harrisburg University of Science and Technology, PA USA.

Puja Roy

Data Warehouse Analyst Data Modeler ETL Developer Report Developer Email: ac59mi@r.postjobfree.com Contact No.: +1-848-***-**** 1 Rustic Ridge Rd, Little Falls, NJ 07424

Master of Science (M.S.) in Analytics - Concentration in Forecasting with Machine Learning TECHNICAL SKILLS:

Software

SQL Server Management Studio (2005 & 2008 R2), Microsoft Business Intelligence Development Studio (2005, 2008 R2 & 2012), SAP Business Objects XI 3.1, SAS Enterprise Guide 9.1, and SAS Enterprise Guide 9.4

Tools Analytical Tool + ETL Tool + Reporting Tool - SQL Server Management Studio (2005, 2008 R2 & 2012)

ETL Tool - Microsoft Business Intelligence Development Studio (2005, 2008 R2 & 2012) Reporting Tool - Microsoft Business Intelligence Development Studio (2005, 2008 R2 & 2012), SAP Business Objects XI 3.1, SAS Enterprise Guide 9.1, and SAS Enterprise Guide 9.4 Methods Waterfall and Agile methodologies of Software Development Life Cycle Domain

Experience

Mortgage Loan Business, Banking

PROFESSIONAL CERTIFICATION:

Title Exam Code Completion Status Year

Microsoft Certified Professional 70-461 Successful 2015 Big Data & Hadoop 2016

BI SAS Foundation 2016

Cloud Computing 2017

PROJECT DETAILS:

1) GE Money Servicing Limited, UK – Watford, Feb 2017 to Dec 2017 Position: Data Warehouse Analyst & Lead SQL Developer (Offshore) Responsibilities:

Offshore lead role where actively participated in Requirement gathering from different Business users, project planning, effort estimation, design, and development of ETL framework and Quality assurance.

T-SQL programming through SQL Server Management Studio

Reporting by SQL Server Integration Services (SSIS).

Requirement gathering and coordination with Client and team

Attend daily status call and provide inputs on day to day activities and share thoughts on important decisions.

As a Data Warehouse Analyst, the responsibility was to assume a key role in day-to-day support of Business Intelligence tools, Decisions and Reporting solutions, Business Objects, and underlying ETL framework.

Involved in analysis and cleansing of data. Developed reporting tools for use by other Transmission staff.

Reviewed the logical model with application developers, ETL Team, DBA's, and testing team to provide information about the Data Model and business requirements.

Prepared Logical Data Modelling using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyse and document business data requirements.

Responsible for analysing huge data sets with basic statistical methods, interprets results, and provides written summaries of data analysis.

Collaborated on the data mapping document from source-to-target and the data quality assessments Puja Roy

Data Warehouse Analyst Data Modeler ETL Developer Report Developer Email: ac59mi@r.postjobfree.com Contact No.: +1-848-***-**** 1 Rustic Ridge Rd, Little Falls, NJ 07424

Master of Science (M.S.) in Analytics - Concentration in Forecasting with Machine Learning for the source data.

Database programming in T-SQL through SQL Server Management Studio which includes the concept of Join, Cursors, Ref-cursors, Procedures, Functions, Partitioned Tables, Triggers, Table Indexing for Extract, Transform and Load (ETL) of source data.

Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.

Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked with bridge tables.

Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.

Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.

Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

2) GE Money Servicing Limited, UK – Watford, May 2016 to Jan 2017 Position: Data Warehouse Analyst & Lead Onshore Developer (Onsite Role at Watford UK) Responsibilities:

Worked as a Lead Onshore Developer actively participated in Requirement gathering from different Business users, project planning, effort estimation, design, and development of ETL framework and Quality assurance

Development on development on T-SQL programming through SQL Server Management Studio

Reporting by SQL Server Integration Services (SSIS).

Requirement gathering and coordination with Client and offshore team

Attend daily status call and provide inputs on day to day activities and share thoughts on important decisions.

As a Data Warehouse Analyst, the responsibility was to assume a key role in day-to-day support of Business Intelligence tools, Decisions and Reporting solutions, Business Objects, and underlying ETL framework.

Involved in analysis and cleansing of data. Developed reporting tools for use by other Transmission staff.

Reviewed the logical model with application developers, ETL Team, DBA's, and testing team to provide information about the Data Model and business requirements.

Prepared Logical Data Modelling using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyse and document business data requirements.

Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.

Database design/Data warehousing which includes the concepts fact and dimension tables.

Responsible for analysing huge data sets with basic statistical methods, interprets results, and provides written summaries of data analysis.

Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.

Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked with bridge tables.

Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing.

Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.

Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

Puja Roy

Data Warehouse Analyst Data Modeler ETL Developer Report Developer Email: ac59mi@r.postjobfree.com Contact No.: +1-848-***-**** 1 Rustic Ridge Rd, Little Falls, NJ 07424

Master of Science (M.S.) in Analytics - Concentration in Forecasting with Machine Learning 3) GE Money Servicing Limited, UK – Watford, From Mar 2012 to Apr 2016 Position: Data Warehouse Analyst & SQL Developer (Offshore Role) Responsibilities:

Database design/Data warehousing which includes the concepts fact and dimension tables.

Database programming in T-SQL through SQL Server Management Studio which includes the concept of Join, Cursors, Ref-cursors, Procedures, Functions, Partitioned Tables, Triggers, Table Indexing for Extract, Transform and Load (ETL) of source data.

For reporting of source data by SQL Server Integration Services (SSIS), SAP Business Objects XI 3.1, SAS Enterprise Guide 9.4

Automation of daily, monthly, and quarterly ETL activities by creation of jobs and streamlined the entire load process.

Built the DW environment using SQL server tables with Terabytes of Data. Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.

Modeled the logical and physical diagram of the future state, Delivered BRD and the low-levels design document.

Discuss and develop Data model, data flow and data mapping with the application development team.

Discuss and Develop Conceptual Data Model

Experience in Query Optimization, Debugging, and Tuning for improving performance.

Reviewed basic SQL queries and edited inner, left, and right joins by connecting live/dynamic datasets.

Attend daily status call and provide inputs on day to day activities and share thoughts on important decisions.

Collaborated on the data mapping document from source-to-target and the data quality assessments for the source data.

Database programming in T-SQL through SQL Server Management Studio which includes the concept of Join, Cursors, Ref-cursors, Procedures, Functions, Partitioned Tables, Triggers, Table Indexing for Extract, Transform and Load (ETL) of source data.

Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.

Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked with bridge tables.

Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems.

4) GE Money Servicing Limited, UK – Watford, From December 2012 to October 2015 Position: Application Administrator & Data Warehouse Analyst (Dual Offshore Role) Responsibilities:

User creation for SAS Enterprise Guide 9.4 and SAS Enterprise Guide 9.1

Library creation both ODBC and Flat file for SAS Enterprise Guide 9.4 and SAS Enterprise Guide 9.1

Creation of jobs in SQL Server Management Studio, SQL Server Integrated Services and SAS Enterprise Guide.

Creation of Web Intelligence Report by creation of object (Dimensions and Measures), universes in SAP Business Object.

Worked extensively as a data analyst. Worked extensively with the business users to gather requirements.

Puja Roy

Data Warehouse Analyst Data Modeler ETL Developer Report Developer Email: ac59mi@r.postjobfree.com Contact No.: +1-848-***-**** 1 Rustic Ridge Rd, Little Falls, NJ 07424

Master of Science (M.S.) in Analytics - Concentration in Forecasting with Machine Learning

Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources to integrate in the data warehouse, Full and Incremental loads.

Designed scalable, flexible, and affordable Data warehouse models, created surrogate keys, and worked with bridge tables.

Worked extensively on troubleshooting different production issues within Service Level Agreement

(SLA).

Prepared knowledge documents of the daily, monthly, quarterly daily load process.

Automated different processes by eliminating manual intervention and streamlined it.

Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project. EMPLOYMENT SUMMARY:

Dates Organization Role

March 2012 – December 2017 Tata Consultancy Services Ltd. IT Analyst

Contact this candidate