Resume

Sign in

Sql Server Data

Location:
Rahway, New Jersey, 07065, United States
Posted:
March 07, 2018

Contact this candidate

Cover Letter:

To

The Hiring Manager,

My profile reflects 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 TCS for 6 years. During this tenure I was in General Electric London office for 1 years handling one of their critical project.

As a Data Warehouse Analyst / Data Modeler / Data Warehouse Analyst / 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 on-call after-hours support when necessary to maintain data warehouse integrity and availability to end-users.

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.

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 track record in these areas. I am very interested and enthusiastic about the possibility of joining your organization. I look forward to speaking with you, and to the next steps in the interview process.

I am pursuing Master of Science (M.S.) in Analytics degree from Harrisburg University, PA USA. Iā€™m eligible to work full time without sponsorship from May-2018 in Curricular Practical Training (CPT).

Thanks & Regards,

Puja Roy

1555 Main Street Rahway, NJ ā€“ 07065

848-***-**** 201-***-****

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).

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.

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.

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

I have worked in Waterfall and Agile methodologies of Software Development Life Cycle

Domain Experience

Mortgage Loan Business, Banking

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, PA USA.

PROFESSIONAL CERTIFICATION:

Year

Title

Exam Code

Completion Status

2015

Microsoft Certified Professional

70-461

Successful

2016

Big Data & Hadoop

2016

BI SAS Foundation

2017

Cloud Computing

PROJECT DETAILS:

General Electric through Tata Consultancy Services Ltd. From Mar 2012 to Dec 2017

Position: Data Warehouse Analyst, ETL Developer & Application Administrator

Responsibilites:

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 analyze and document business data requirements.

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

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.

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 ETL activities by creation of jobs

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

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

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.

Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources in order 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 SLA.

EMPLOYMENT SUMMARY:

Dates

Organization

Role

March, 2012 ā€“ Dec, 2017

Tata Consultancy Services Ltd.

IT Analyst



Contact this candidate