Livecareer-Resume

Ssis Etl Ssrs Report Developer Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
, , 100 Montgomery St. 10th Floor
Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Summary

A professional business intelligence developer with over 7+ years of experience in SQL and BI reporting tools such Tableau, SSRS, SSIS and as a Business Analyst. Currently seeking growth -oriented opportunities in Business intelligence in industries like Manufacturing, Health, Education, Logistics, Retail etc.

Enthusiastic team player, dedicated to streamlining processes and efficiently resolving project issues with experience and understanding of SDLC

Skills
  • OLTP/OLAP System, Analysis and E-R modeling
  • Developing Database Schemas like Star schema, Snowflake schema used in relational, dimensional, and multidimensional modeling
  • Tableau Desktop and Tableau Server
  • Oracle Database, Teradata, AS400,
  • Microsoft SQL Server
  • Toad, SQL Developer, DB Visualizer, SSMS, Winscp
  • Microsoft Word, Access, PowerPoint, Outlook, Visio, Ernwin
  • Conflict Resolution/Troubleshooting
  • Planning/Scheduling
  • Technical Support
  • Data entry and Word processing
Experience
01/2019 to Current
SSIS ETL/SSRS Report Developer McKesson City, STATE,
  • Developed SSIS packages to load data from multiple sources to data warehouse.
  • Scheduled SSIS packages to run using Control-M.
  • Produced Ad-hoc SSRS Dashboard based on user requirements.
  • Utilized best practice approaches to data preparation.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in importing/exporting data between different sources like Oracle/Access/Excel etc.
  • Using SSIS/DTS utility.
  • Experience in ETL processes involving migrations and in sync processes between two databases.
  • Experience in maintaining one to many and many to one relationships while moving data between two databases.
  • Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
  • Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports.
  • Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SSRS.
09/2013 to 08/2018
Tableau/SSRS Report Developer Shoprite Store City, STATE,
  • Work directly with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality.
  • Good database knowledge and experience writing Oracle SQL and Microsoft SQL server SQL queries.
  • Extensive experience in Tableau Server and Tableau Desktop in various versions of Tableau.
  • Tableau design, development and process documentation to produce required reporting, analytics, and visualization deliverables.
  • Ability to perform data analysis, troubleshoot data integrity issues and trend data analysis in Tableau.
  • Development of new Reports / Dashboards/Story using Tableau and relevant data sources (Oracle, Excel, SQL Server, Teradata, Data warehouse etc.).
  • Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations.
  • Develop Tableau desktop/ server reports and dashboards.
  • Create Tableau data extracts.
  • Consult with business and technology partners on data visualization options and best practices.
  • Drive Tableau adoption across a broader array of business and technology areas.
  • Troubleshoot Tableau related issues and queries.
  • Relevant Tableau Desktop Experience Tableau dashboards, visualizations, and performing advanced analytics to analyze data.
  • Engage client to gather software requirements/business rules, and ensure alignment with development teams.
  • Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
  • Identify and reconcile errors in client data to ensure accurate business requirements.
  • Draft and maintain business requirements and align them with functional and technical requirements.
  • Facilitate monthly meetings with clients to document requirements and explore potential solutions.
  • Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
02/2008 to 11/2011
Business/System Analyst Legon Centre For International Affairs And Diplomacy City, STATE,
  • Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' condition.
  • Engage users and stakeholders to gather software requirements/business rules and ensure alignment with development teams.
  • Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user stories, user cases, workflow/process diagrams, flowcharts and model diagrams.
  • Identify and reconcile errors in client data to ensure accurate business requirements.
  • Draft and maintain business requirements and align them with functional and technical requirements.
  • Lead stakeholder meetings and JAD sessions.
  • Prepares documentations and stores them on the organizations shared drive or share points.
Education and Training
Expected in 10/2013
Master of Arts: Development and Governance
University Of Duisburg-Essen - Duisburg, Germany,
GPA:
Expected in 06/2011
Master of Arts: International Affairs
Legon Centre For International Affairs And Diplomacy (LECIAD), University Of Ghana - Accra, Ghana,
GPA:
Expected in 06/2009
Bachelor of Arts: Social Work With Psychology
University Of Ghana - Accra, Ghana,
GPA:
Publication

The BRICS States and the Responsibility to Protect Norm: Dynamics of State Power and Self-Interest

(Lambert Academic Publishing)

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

82Good

Resume Strength

  • Formatting
  • Length
  • Measurable Results
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended
  • University Of Duisburg-Essen
  • Legon Centre For International Affairs And Diplomacy (LECIAD), University Of Ghana
  • University Of Ghana
Job Titles Held:
  • SSIS ETL/SSRS Report Developer
  • Tableau/SSRS Report Developer
  • Business/System Analyst
Degrees
  • Master of Arts
  • Master of Arts
  • Bachelor of Arts