Poornima Anandaraj

Phone: +91-984******* E-mail: add7fj@r.postjobfree.com

Qualification Summary

5+ years experienced Data Analyst with professional focus in identifying KPIs, coming up with practical solutions, reports using various SQL associated & Business Intelligence (BI) software such as Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, VB .NET, C#, Sage 300/ AccPac, Crystal Reports, Monarch, Iman, MS Access, InfoTools and troubleshooting.

Proficient in the data warehouse concepts and methodologies, including ETL.

Rich experience in preparing the Weekly Status Reports (WSR), Daily Status Reports, maintaining the Release Dairy, pulling various reports from Servicenow, Clarity PPM (Project & Portfolio Management) for managers as part of Team Management & delivering within project timelines.

Good experience in using tools like AQT, Putty, Excel, SharePoint, winSCP and Beyond Compare.

Expert experience using SQL in SSMS, DB2, Oracle, MS Access and Teradata.

Proficiency in speaking English (UK- certified by the University of Cambridge (ESOL Exam) and US)

Expertise in using Microsoft Office products (Word, Excel, PowerPoint, Outlook mail)

Excellent organizational skills, detail oriented, strong analytical and problem solving skills with a consultative approach in defining solutions.

Worked effectively in a dynamic, multi-tasking environment with competing deadlines while paying strong attention to details and analytics.

A Team Facilitator with the ability to deal with people diplomatically.

High degree of initiative and ability to learn and adapt to new tools and technologies

Effective Communication skills.

Technical Experience

Languages : PL/SQL, MySQL, VB .NET, C#, Java, VBScript, Excel Macros, VBA

Tools : SSMS, Visual Studio, SSIS, SSRS, InfoTools, Sage 300 / AccPac, Crystal Reports, Monarch, IMAN, HP QTP, HP ALM/QC, Servicenow, Clarity PPM, Putty, Excel, SharePoint, winSCP, Beyond Compare, Microsoft Office products, Informatica PowerCenter 9.0.1, Business Objects

Methodologies : Waterfall, Agile

Databases : SSMS, Oracle, DB2, Teradata, MS Access

Education

Bachelor of Engineering in Computer Science 2008 - 2012

Anna University, India

Work Experience

Data Analyst – Vendor Management System June.2018– Present

Metro 360, Toronto, Canada

Environment and Tools: Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, VB .NET, Sage 300/ AccPac, Crystal Reports, Monarch, Iman, MS Access, InfoTools.

Responsibilities:

Gathering requirements and Key Performance Indicators (KPIs) from the Client Business partners.

Designing data logic and building statistical analysis models on large data sets using SSMS.

Data clean up (ETL) and Data management using SSIS based on the data availability and practices of various customers through data modeling / data profiling to maintain Data Quality. Data Extraction from various clients inputs such as Flat Files, Invoices in Excel, pdf, csv, etc. Monarch Model Extraction (852 POS files, 820 Payment Files, 832 files).

Analysing Business data and financial data to indicate expansion of existing opportunity through probability and create new opportunity for the business across Canada through pattern and trend identification.

Successfully interpreted data to identify key metrics and draw conclusions by data mining.

Created various tables, views and logical Stored procedures incorporating complex mathematical calculations through cursors to prevent manual intervention for business reports, customer reports, payment reports and analysis.

Weekly Invoicing (EDI & 810 file creation), Vendor payment processing, monthly reconciliation (using 812 files), reporting through SQL (coding & automation).

Create live reports suitable to the business using SQL, SSRS, Sage 300 and Crystal Reports, InfoTools Dashboards and Excel. Responsible for creating customized ad-hoc, weekly, monthly and quarterly reports, financial, payment and reconciliation reports.

Providing timely and effective answers to customer queries through thorough retail and stock data analysis.

Set up SQL database Alerts to notify managers in case of Space insufficiency as part of risk management.

Developed Tools and stored procedures to optimize data quality (Data QA).

Proposed solutions to improve system efficiencies through query tuning, leading to better performance & faster results. Also, created Excel Macros for quick data clean ups using VBA.

Identified Automation opportunities to reduce manual intervention, saving resource time and effort.

Built various customized Visual Studio Console applications such as the AccPac Billing Data Files Archiving System that runs Daily and Scheduled the job using the Task Scheduler. This system also alerts the project manager and the networking team in case of space insufficiency.

Suggested to business, the best payment processing methods to clients based on financial analysis and processing. It reduced customer payment enquires and helped business to build a better rapport the clients.

Coordinated with the accounting team to release payments.

Worked closely with the company to identify customer needs and demands.

Data Analyst – Pega CRM Nov. 2014 – Jul 2015

TalkTalk, Chennai, India

Environment and Tools: Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, VB .NET.

Responsibilities:

Primary responsibility to lead the integration, data cleansing, governance, and usage of data to support the Pega CRM Application.

Translated and documented the results of requirements gathering and KPIs into a standard format to be

used to create the appropriate Business Intelligence (BI) solution

Coordinated with the production support team for system requirements and hardware related resource.

Designed, developed, tested and implemented ETL packages using SSIS

Developed new reports using SSRS and SSMS. Delegated tasks to team members.

Used advanced Microsoft Excel built in functions like Macros, pivot table and VLOOKUPs

Preparing the daily and weekly status Report of the project.

Experience documenting detailed requirements, design documents, and workflows in support of BI

Conducted team meetings and communicated team and project issues to appropriate staff and customers. Presented findings, recommendations, and specifications. Prepared Minutes Of Meeting (MOM)

Achievement: Awarded as the Best Team on 19-Jun-2015.

Tools Developed Using Excel Macros: Data Preparation Tool sheet for easy and quick Transformation of Data.

SQL Developer – Strategic Privacy Inventory System & View Remediation Feb. 2013 – Oct 2014

Bank of America (BofA), Chennai, India

Environment and Tools: Teradata 12, Teradata SQL Assistant, Mainframe, QC, SOAP UI, beyond Compare

Responsibilities:

Inventory system analysis. This Projects deals with managing all the views present in the Warehouse and extracting the key information related to those views.

Involved in Analysis, Design and coding and implemented few hundreds of views in production with the determined privacy settings.

Transforming the (Low Level Design) LLD into code modules.

Extended the stored procedure for generation of static views to periodic views, which is semi-automated that helps in maintaining only the required number of versions of periodic views and automatically drops the previous generations based on the application specific requirement.

Made the best use of the metadata from Teradata’s data dictionary for coding this application, which is used to keep track of the privacy settings imparted to views.

Testing the code with respect to the privacy settings.

Maintenance of the inventory database system & the Periodic and Static View generator with respect to the privacy settings that is used across different departments.

Enhancement of the tools used to generate the required reports, which were used for internal verification and by the clients.

Performing the pre-requests such as execution of SQL Statements, JCL and API XML scripting.

Maintaining documents and project artefacts in SharePoint.

Tools Developed Using Excel Macros:

Maintenance of Privacy Report Tool. The views that are developed by the users need to be privacy complaint. This tool analysis the view created and provides the complete report of the status of the view.

Enhancement of View Generators Tool. A view generator system is used to generate a basic structure of views based on the needs of the users.

Business Metadata Document (BMD) Tool was developed using Excel Macros and SharePoint. The BMD was developed for users to provide view information to the clients and get approval for view Privacy settings. This document restricted access based on their role played for the privacy settings. Upon the approval of settings, they are fed into the database for the inventory system automatically.

Clarity tool – based on the project hours provided by the clients, a clarity sheet is prepared for the team members involved in the projects and their billing time.

Clarity tool Phase II – based on the project hours provided by the clients, a clarity sheet is prepared for the team members involved in the projects and their billing time. The Phase II Clarity tool contained profiles for both the clients (business users) and users (Vendors) to input values and/or derive values from with the help of on-screen tools for all working locations. Also, monitoring was quick and easy due to the built-in statistical charts.

BI Module Lead – TCS Initial Learning Program (ILP) Nov. 2012 –Jan 2013

TCS, Chennai, India

Environment and Tools: Informatica PowerCenter 9.0.1, Business Objects, Oracle

Responsibilities:

Analysis of inventory data.

Extracting data from the sources available, transforming data for load and loading data based on needs.

Setting up of Business Objects with respect to inventory data.

Generation of dashboards based on the customer requirements.

SQL Developer – Intern Dec. 2011 –May 2012

Rogers, Chennai, India

Environment and Tools: Eclipse, J2EE, Struts2, Hibernate, .NET, Oracle, SQL, PL/SQL, Oracle SQL

Responsibilities:

Analysis of employee and allocation process. Analysis of TCS Chennai One floor plan.

Generic coding for creating floor and cubicles.

Graphical Website creation of Chennai One floor plan with cubicles & associate lockers.

Testing allocation and de-allocation.

Certification & Training

Certification

SAP ABAP with Grade A from De Horizone Technologies Pvt. Ltd Aug 2012

Hadoop Fundamental 1 from Big Data University 23rd March 2013

Foundation in banking from TCS Domain Academy 18th June 2013

Hands-on & Tools Creation

Advanced experience in using MS Office products (MS Project Skills, MS Excel, MS Outlook, MS Access, MS Visio, MS PowerPoint, MS OneNote).

Advanced experience in SharePoint (coding and use), AQT, SQL Assistant and Beyond Compare.

Intermediate experience in Putty, winSCP.

Trainings

DB2 Mainframe Database Administration (Mainframe DB2 DBA) – ILT Mar 2013

Teradata – Overview Apr 2013

Plant Training on Hardware, Networking, System Administration and Software Platforms Jun 2013

HCL – Chennai, India

Contact this candidate