Senior Reporting/Data Analyst Resume New York, NY - Hire IT People

TECHNICAL SKILLS:

Microsoft: SQL Server 2008 & 2012, T - SQL, Stored Procedures, Views, Triggers, Functions, Optimization, Indexes, Backup/Restore, SQL Server Agent

Database technologies: AWS Aurora, DynamoDB, RDS, Redshift, PostgreSQL, NoSQL

Cloud Technologies: AWS, S3, EMR, Microsoft Azure, Blob Storage, Docker

Reporting: SQL Reporting Services (SSRS), Microsoft Excel, PowerBI, Tableau, SharePoint

Data Integration: Integration Services (SSIS), ETL

Analytics: SQL Analysis Services (SSAS), Python

Database Design: Database Modeling, Schemas, Normalization/De-normalization, Optimization

Programming Languages: VBA, Python

Integrated Developments Environments: Visual Studio, Visual Studio Team Foundation Server (TFS), GitHub

Operation Systems: Windows, Linux

PREFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Reporting/Data Analyst

Responsibilities:

Designed and developed stored procedures, queries, and views necessary to support SSRS reports.
Developed and tested extraction, transformation, and load (ETL) processes.
Coordinated and monitored various projects progress to ensure the timely flow and complete delivery of the project.
Worked directly with clients to document future state processes for Incident Management, Change Management, Knowledge Management, and Service Request Management.
Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
Created the SSIS package to load, change and clean the data from various data sources to the database.
Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
Enabled clients to align BI initiatives with business goals to facilitate competitiveness and productivity.
Developed ETL framework for processing and monitoring import of flat files in SSIS for key client.
Understanding of IT Service Management (ITSM) and ITIL business process.
Developed reports to maintain Service Level Agreement (SLA) and monitor SLAs workflow.
Good knowledge of Data Governance, Data Management.
Good knowledge of CMDB and asset management services.
Developed global reports using client based Business Objects and ServiceNow data sources to assist global and regional managers on how to better serve the client.
Core competency areas include IT Service Management using ServiceNow Tool.
Review business activities and assist client to define current state processes.

Confidential, Brooklyn, NY

Data Analyst

Responsibilities:

Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Analyzed raw data, drawn conclusions and developed recommendations.
Monitor and review existing Data Remediation working practices and procedures in order to support management in identifying any areas for possible improvements.
Developed complex stored procedures to create various reports.
Designed databases, stored procedures, reports, and data input interfaces using SQL Server 2012.
Responded to complex client data requests.
Developed internal data QC tools, created documentation, and created advanced T-SQL scripts within MS Query Analyzer.
Deliver standard and custom client-facing SSRS reports, created custom T-SQL queries and performed data-mining in the MS SQL Server environment.
Communicated heavily with other groups and internal customers within Confidential to complete tasks and fulfill requests with strict turnaround times.
Advised on the suitability of methodologies and suggesting improvements.
Developed ETL solutions using SSIS and designed and processed OLAP cubes with SSAS.
Performed root cause analyses, and investigated implementations of new Microsoft technologies.
Produced deliverable estimates, served as an escalation point for production ETL/application issues.
Designing, developing and implementing new functionality.

Confidential, Brooklyn, NY

Jr. Data Analyst

Responsibilities:

Manipulating, cleansing & processing data using Excel, Access, and SQL.
Responsible for loading, extracting and data validation of client data.
Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative .
Performed root cause analysis on failures. Resolve performance tuning related issues and queries.
Performed data modeling for transactional databases, created reports from data marts, and resolved database performance issues.
Analyzing raw data, drawing conclusions & developing recommendations
Participated in client-facing meetings and email communications as a technical resource, while contributing to technical standards and process improvement efforts.

We provide IT Staff Augmentation Services!

Senior Reporting/data Analyst Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship