Report Analyst Resume Long beach, CA - Hire IT People

TECHNICAL SKILLS:

Languages SQL, PL/SQL, TSQL, Java, C#, C:

Databases ORACLE 9i/10g, MS Access, SQL Server, NetezzaWeb Technologies HTML, CSS, XML, Java Script, ASP.Net

Data warehousing Tools Informatica Power center 9.5, 9.1, 8.x, 7.x, SSIS, SSRS

WORK EXPERIENCE:

Confidential, Long beach, CA

Report Analyst

Responsibilities:

Work with users and collect the requirements to develop reports supporting their departments.
Load data into reporting server from different data sources using SSIS.
Design, develop, deploy and maintain reports using SSRS, SQL, Netezza SQL, MS Excel and Share point.
Research and analyze data and processes to find, fix issues and improve them.
Schedule processes and provide production support.
Coordinate with different teams to resolve issues.
Test and validate code for quality assurance.
Work with team members to improve technical and non - technical skills.
Follow team coding standards and support best practices.
Peer review code
Automated manual processes.
Document report requirements and code.
Worked on Inbound and outbound Encounter KPIs, Netezza EDW conversion projects.

Confidential, Boston, MA

Database Developer

Responsibilities:

Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica, DMExpress, SSIS and DTS packages.
Generation of reports using SSRS.
Develop real time Power Exchange-Power Center mappings.
Maintain metadata for auditing, logging and error handling.
Involved in debugging and performance tuning at various levels.
Always meet the SLA and improving the performance of loading data from key data sources.
Maintain facts and dimension tables using Star Schema and snowflake schema.
Develop T-SQL procedures for incremental loads in SQL Server. Performance improvements to the database by building partitioning and Index organized tables.
Coordination with campaign and reporting team for the change requests and availability of data.
Work with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives.
Prepare/maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
Developed campaigns according to the requirements in T-SQL
Provide on call developer support for data update processes on weekends and nights.