LiveCareer-Resume

ssrs developer resume example with 12+ years of experience

Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Professional Summary

With Over 7 years of IT experience in Data warehousing and Business Intelligence across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

  • Experienced in Software Development on working as Data warehouse and BI consultant involving implementation of large scale Data Warehouse, Data Migration Strategy and Implementation and Multidimensional Cube Design.
  • Strong experience in Design and Build cubes using SSAS, Dimensional Data modeling (Kimball Methodology), Cube optimization, Aggregation design and Partitioning, Hierarchy handling (ragged), and MDX Querying.
  • Good experience in Data Migration Implementation, Handling complex SCD, Late Arriving Dimensions, Package Development and code review, Source system data analysis and Data Profiling, Implementing Data Governance.
  • Strong experience in T-SQL query optimization and developing ETL processes on data extraction, cleansing/data integration, and loading from different data sources using SSIS.
  • Proficient in using T-SQL for developing complex Stored procedures, Triggers, Index, Views, User Functions, Relational Database Systems following Data Integrity and normalization
  • Maintaining the Log and Audit information in SQL tables, Experienced in providing Logging, Error handling by using Event Handler for SSIS Packages
  • Good experience in Designing, Maintaining & tuning various RDBMS like SQL server, Ms Access Database, Teradata and strong knowledge of SDLC principles.
  • Designing and Deployment of Reports for the End-User requests using BIDS.
  • Good Knowledge in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler and PerfMon.
  • Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the ETL jobs using wrappers.
  • Experience in handling the System Testing Phase of the ETL system and Test Plan Creation and Test Case Development.
  • Experience in projects with 24/7 production and implementation support.
  • Exposure to delivery models including Onsite / Offshore model.
  • Self motivated, quick learner and extremely versatile, excellent critical thinking ability, good interpersonal and communication skills.
Skill Highlights
  • SSIS, Datastage 8.1,Informatica
  • SQL Server, UNIX Shell scripting, Python
  • SQL SERVER 2005/2008/2012, MS-Access ,Oracle and Teradata
  • Management Studio, Query man, Toad, BIDS
  • Clear Case, Remedy 8.0, SVN
  • Windows server, Linux
  • SSRS, Cognos, Tableau
Education
, Expected in Master of Science : Advanced Computer Networking - GPA :
Career Accomplishments
  • Appreciation for completing and delivering the Sunrise project successfully.
  • Received appreciations for Delivery Excellence of MNP and ICR projects.
  • Team Award for Optimization and Stabilization of BI-DWH Operations
  • Received Q3 Bronze Award from CISCO(2019-2010)
Experience
Vornado Realty Trust - SSRS Developer
, , 08/2014 - Current
  • Directly Interacted with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
  • Used SSRS to create reports, customized Reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Implementation and delivery of BI platform solutions to develop and deploy ETL, Reporting on SQL Server 2012 using SSRS.
  • Involved in Installation, Configuration and Deployment of Reports using SSRS
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Maintained scheduling the subscription reports with the subscription report wizard.
  • Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server reporting Services (SSRS) based on client requirement.
  • Developed and optimized database structures, stored procedures.
  • Performed Capacity planning to accommodate the new tables.
  • Involved with Query Optimization to increase the performance of the Report.
  • Involved in writing Stored Procedures and Functions, handle database automation tasks
  • Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SSRS based on Relational databases.
  • Raised Change requests using Remedy 8 for all the deployments.
  • Responsible for creation of Unit test plans and System test plans.
  • Involved in creating and reviewing the ETL test cases for both Unit and System testing
  • Prepared implementation plans and provided walkthrough to all the key business stake holders to get their approval before implementing the code in production
  • Addressed all the live issues/incidents on time during the project warranty phase to ensure that there are no business impacts due to the implementations.
  • Providing knowledge transfer to offshore team and assist them in creating technical designs and in build activities.
Cognizant Technology Solutions - SSIS DEVELOPER
, , 2013 - 07/2014
  • Created new SSIS/ETL packages to cleanse and transform data into the Warehouse.
  • Involved in building Data warehouse whose primary source of data comes from external vendors and corporate sources which includes the data from various source system like Oracle 10g, Flat files, and Microsoft Excel file, XML files.
  • Creation of complex stored procedures for reporting and database development needs.
  • Automation of manual data insertion/manipulation processes by writing stored procedures and scheduling jobs.
  • Working with teams around the world and prioritizing tasks both for reporting and development objectives.
  • Participating in weekly meetings with clients to deliver the high standard support in their reporting needs.
  • Active participation in decision making and QA meetings and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design
  • Scheduled Jobs and Alerts using SQL Server Agent.
  • Participated in design of Staging Databases and Data Warehouse/Data mart database using Star Schema/Snowflakes schema in data modeling.
  • Maintaining & enhancing the existing codes as per the requirement.
  • Follow complete quality process for implementation and Implemented code changes for optimization.
  • Involved in performance tuning for better performance and to reduce the load.
  • Created Understanding documentation and Release Testing documentation on the tickets handled, and documented the issues in a central repository.
  • Answer the support queries regarding business logics maintained in report or any difficulty faced.
  • Troubleshoot production issues and provide resolution for same
  • Mentored the offshore throughout the development & unit testing phase to understand the project functionality and monitored the development progress and conducted code reviews to ensure the quality of the code.
  • Provided support for the code during system testing phase.
Vornado Realty Trust - SSRS DEVELOPER
, , 04/2010 - 10/2012
  • Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2008 and MS SSRS 2008/2005.
  • Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
  • Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
  • Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
  • Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
  • Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
  • Delivered reporting content utilizing SSRS and SSAS
  • Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS.
  • Provided SSRS and SSAS support for internal IT projects requiring report development.
  • Assisted with documentation and code deployments from Development, QA and Production environments.
  • Converted MS SSRS 2005 and Excel based reports to MS SSRS 2008 based reports.
Cognizant Technology Solutions - SSIS DEVELOPER
, , 05/2008 - 02/2010
  • Design and develop ETL processes using SQL Server Integration services, which is used for gathering and manipulating with data across different platforms and systems later used for building business reports.
  • Writing documentation and specification for the developed SSIS Packages, stored procedures and database schema.
  • Worked with business users/Analytics team, data architect to identify the business requirements and developed designed document for ETL flow, analysis of database architecture
  • Using FTP task, Execute Process task, File System task, For each Loop Container, unzip the folder from particular web location and copy it on the Local Server.
  • Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.
  • Created dynamic package Configuration using Environmental Variable and SQL Server configuration to make package portable and created Event handlers for handling package error by using a Custom Logging.
  • Performed unit testing at various levels of the ETL and actively involved in team code reviews, Design/Develop Test Plans, Test Cases and documentation of various processes involved.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

Job Titles Held:

  • SSRS Developer
  • SSIS DEVELOPER
  • SSRS DEVELOPER
  • SSIS DEVELOPER

Degrees

  • Master of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: