Data Sql Server

Meenakshi Pramanik

Sunnyvale, CA *****

Email: ac2aid@r.postjobfree.com Ph no: 408-***-****

DATA ANALYST

Data Analyst in professional with extensive experience in integrating business and technical knowledge to create and implement end-to-end solutions. Expert in software development projects that meet business requirements and focused on customer satisfaction, efficiency, supportability, scalability, and process improvements. Proven expertise in Data analysis on highly complex datasets, and creating reports. Involved in all phases project delivery including documentation, design, unit testing and defect fixing. Recognized team player with strong interpersonal skills, results driven, highly-focused, flexible and quick to adapt to fast paced, demanding and constantly changing project needs or environments.

Areas of Expertise

Software Development

BRD, FRD, FSD

Project Leadership

RDBMS

Tableau

Data Modelling

Database Architecture

Performance Tuning

Business Requirements

Data Migration and Integration

Unit Testing

Matlab

SQL Server

Data Warehouse

Informatica ETL tools

Excel

SSRS

MS Excel

TECHNICAL SKILLS: Business Intelligence Development Studio, Sybase ASE, MS SQL Server 2005/ 2008, Quality Centre ALM, JIRA, Windows 7, UNIX, Filezilla, Putty, WinScp, C, C++, SQL, Sybase, SQL, T-SQL, Perl, UNIX Shell Script, CA Scheduler, Serena, Tortoise SVN, Informatica Power Center 9.5.1, SAP Crystal Reports 2011, Crystal Reports XI Release 2, SQL Reporting Services 2008, MS Excel, Tableau, PPM Tool, MATLAB, Tableau, Python, ERwin Datamodeler 9.0, PowerPoint

Professional Experience

Projects

Client: Google, Mountain View, CA 12/2016 –7/2017

Employer: Artech Information Systems, CA

Data Specialist

Description:

I worked with Google Cloud Product Ops teams who are responsible for who are responsible for bringing teams together from across organizations and helps GCP Eng teams execute better by monitoring and tracking the progress of Product Life Cycle.

●As part of Plan and Prioritize team, worked on gathering cloud wide KPIs projects from different Cloud teams and consolidating and maintaining them in iCentral, monitored and tracked the progress of Cloud Critical projects based on the inputs gathered from owners and sent biweekly progress reports to product owners offering transparency in execution of projects across Cloud Platform.

●Generated (triggered from PPM tool by labeling), maintained and validated data of reporting dashboard (EPoR) which is a comprehensive one-year forecast of the schedules for major engineering and product efforts.

●As part of Product Hierarchy team, created and modified SQL script(Dremel and PLX) in proprietary tool which calculates Product Hierarchy for entire Google Cloud Organization (like corresponding total headcount, depth of hierarchy, name of resources etc). Exported data to Tableau for reporting, summarizing, created bar graphs and charts in Tableau.

●Generated weekly reports for all new launches as part of Launch team. This report is utilized by cross functional teams of Cloud Platform to determine priority launches.

●Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Client: San Mateo County, San Mateo, CA 7/2016 – 12/2016

Employer: Global IT Solutions, TX

BI Data Analyst

Description:

My major responsibilities include getting requirements from the user in the form of BRD/FSD, writing SQL Queries for reports which contains health insurance details of patient, then I was involved in designing and developing reports using Tableau Reports which covered all details of patient and then uploading reports in Avatar application. The Tableau Reports helped to represent the patient’s data in an organized manner which was easily accessible by end user.

●Performed sophisticated ad-hoc or ongoing custom analyses against medical data to support business stakeholders.

●Gathered business requirements in the form of BRD and FSD then translated the business requirements into working logical and physical data models, using Erwin data modeler.

●Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.

●Designed and Populated specific tables, databases for collection, tracking and reporting of data.

●Provided accurate and appropriate interpretation of data, applied knowledge to evaluate, analyze, and interpret data.

●Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

●Developed Tableau visualizations and dashboards using Tableau Desktop.

●Diagnosed and addressed operational data issues.

Client: JP Morgan Chase International Private Bank 1/2013 - 7/2015

Employer: Cognizant Technology Solutions, Kolkata, India

SQL ETL Developer

Description:

Main objective of this project is we are providing a system with all the information regarding transactions of JPMC banks in EMEA region. We receive the daily transaction data from all branches at the end of the day. Next day we need to validate the transactions and implement the business logic based on the transactions type. Finally need to load all historical data into Datawarehousing environment.

●Engaged in all phases of a multi-year JPMorgan Chase Data Warehousing project including analysis, requirements gathering, design and development of code to control transactions of JPMC banks in the EMEA region.

●Experience in writing complex SQL queries involving multiple tables inner and outer joins.

●Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.

●Key member of the JPMorgan Chase team utilizing DBMS experience to designing ETL mappings to extract data using Informatica Power Center tools, configuring Workflows and Sessions, and loading data into the data warehouse.

●Experience in Data Migration & Integrating Data from various sources to fetch the daily data from various sources like relational and flat file sources, Excel from the AS400 and using the Informatica tool to transfer the data to OLTP system like SQL Server.

●Wrote Perl Tree script to automate Informatica Pre-Session, Post-Session tasks and running of the ETL workflows and used CA job scheduler for scheduling these tasks in production and UAT environments.

●Applied best practices of SDLC to each assigned projects to ensure that the project ran smoothly, to improve code quality, and to meet assigned deadlines.

●Acknowledged by Cognizant for consistent performance, excellent execution, and a high degree of customer satisfaction on the JPMorgan Chase project which was selected as Project of the Year in the Banking and Financial Services Group.

Client: JP Morgan Chase International Private Bank 1/2013– 1/2014

Employer: Cognizant Technology Solutions, Kolkata, India

Data Analyst

Description:

The objective was to migrate BO Reports from Crystal Reports XI Release 2 to Tableau Reports.

●Strong RDBMS concepts and experience in creating tables, views, procedures, functions, triggers, maintaining and tuning Views, Stored Procedures, User Defined Functions and System Functions using SQL Server, T-SQL

●Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL.

●Reporting experience with tools like Business Objects Crystal Reports XI and XI R2, Tableau Reports SQL Server Reporting Services 2008.

●Expertly conducted requirements gathering and feasibility study of data to create physical and logical data models, designing tables and stored procedures from abstract data.

●Built comprehensive QnR (Report Query Schedule Reports) to run daily, weekly, monthly for Executives and Business Analysts.

●Adeptly migrated predefined Report from Crystal Reports XI Release 2 to Tableau Reports building parameterized Tableau Reports reports using tables, queries, and verified joins between them.

●Assumed leadership role in delivering a Business objects Migration project for JPMorgan Chase acting as the POC for report migration tasks for this project and accelerated project delivery before any other group by single handedly delivered 60% of the team’s work.

●Prepared test cases using excellent command of Application Lifecycle Management tools.

Client: Manulife Canada 7/2011– 1/2013

Employer: Cognizant Technology Solutions, Kolkata, India

Business Analyst

Description:

The current Nav2 Project has an existing claims management system built on PowerBuilder and Sybase. This project deals with the conversion of the existing system into a web based system using MVC and WCF. In addition, advanced reporting facilities would be provided to facilitate effective and user friendly reporting and subscriptions using Excel.

●Created management reports in Excel that captures key data related to company’s active contract for recording Insurance information of clients.

●Performed extensive data cleansing and analysis, using pivot tables, VLOOKUP, Index and match, conditional formatting, and created graph for chart manipulation to achieve analytical goals.

●Manage spreadsheets and maintain data to ensure accurate data availability for managers and decision-makers.

●Adeptly performed unit testing on all developed code.

●Used the Python language to develop web-based data retrieval systems.

●Performed text-mining on insurance claims data using Python.

Technical Skills Summary

ETL Tools

Informatica Power Center 9.5.1

Business Intelligence

Tableau Reports, SAP Crystal Reports 2011, Crystal Reports XI Release 2, SQL Reporting Services 2008, Business Intelligence Development Studio

Databases

Sybase ASE, MS SQL Server 2005/ 2008, MongoDB (JSON)

Testing Tools

Quality Centre ALM, JIRA

Operating System

Windows 7, UNIX

SSH Tools

Filezilla, Putty, WinScp

Languages

C, C++, SQL, Sybase, SQL, T-Sql, Perl, Excel

Scripting tool

UNIX Shell Script, Python

Scheduling Tools

CA Scheduler

Configuration Tools

Serena, Tortoise SVN

Education

Master of Technology

Electronics & Telecommunications, SGGSIE&T, Maharashtra, India, 2011

Bachelor of Engineering

Electronics & Telecommunications, MGM College of Engineering, Maharashtra, India, 2009

Contact this candidate