SSAS Developer Resume Samples

A SSAS Developer is a SQL server analysis service developer who works with Data Warehouse projects. The job description entails developing solutions and supporting the business with robust solutions and providing data and reports that support numerous functions including metrics, dashboards, and data discovery. Other key responsibilities are listed on the SSAS Developer Resume as – developing and improving solutions that surround spanning data processing activities; developing and improving MS Analysis Services Cubes; collaborating with other teams within the organization; mentoring colleagues and devising technical solutions; maintaining documentation for all process implementation, and adhering to and suggesting improvements for coding standards and improving best practices.

Top-most skills that can highlight a resume include – experience in installing MSSQL server, skillful in developing constraints, defaults, and triggers; excellent knowledge of analyzing data warehouse; solid knowledge in developing cubes using partitions, KPI’s and in extraction migration of data; and knowledge of writing complex logical algorithms in Macros using VBA. A degree in computer science or IT is commonly required.

 

SSAS Developer Resume example

Ssas Developer Resume

Summary : Over 7+ years of strong experience in the IT industry as a MS SQL Server Developer/BI Developer. Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation. Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server Skillful in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Skills : ETL, OLAP, OLPT, SQL Server.

Description :

    1. PNC provided its services in Retail Banking, Asset Management Group, Corporate & Institutional Banking and Residential Mortgage Banking.
    2. Provided risk management, investment system outsourcing, and financial advisory services to a growing number of institutional investors.
    3. Project involved automation of PNC's Liquidity Coverage Ratio (LCR) calculation projected to be reported daily.
    4. Created complex Stored Procedures, functions, tables, temp tables, views and using T-SQL and PL/SQL.
    5. Created complex SSIS packages to extract data from Oracle and Teradata sources using Attunity adapters.
    6. Extensively used variables and expressions to change values at runtime.
    7. Used system and user variables for logging package and task level information and displayed the status in a Java application.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors


Sr. Ssas Developer Resume

Headline : 6+ years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Health Care and Insurance. Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions. Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.

Skills : T-SQL, Query Analyzer, DTS Designer, SAS Clinical.

Description :

    1. Fully integrated suite of hosted products and sales support services are custom designed for the needs of the clients, leveraging the vast industry experience to meet current and future needs.
    2. Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
    3. Involved in installation and configuration of MS SQL Server 2012.
    4. Created and modified complex TSQL batches/stored procedures.
    5. Defined Check Constraints, functions, indexes, synonyms and views.
    6. Involved in creating new stored procedures and optimizing existing queries and stored procedures.
    7. Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Electrical Engineering


Jr. Ssas Developer Resume

Summary : Developer to drive, implement and architect the SSRS/SSAS report environment for our client. This is a contract to hire opportunity which allows the candidate and the client to get comfortable with one another.

Skills : ETL, OLAP, OLPT, SQL Server, SSRS,SSIS.

Description :

  • Ability to demonstrate an understanding of business requirements & business concepts.
  • Experienced working with a team using Git.
  • Experienced with Build/Release Pipelines in Azure DevOps.
  • Responsible for analysis, design, development, deployment and support of enterprise systems such as EDW and BI on multi-tier environment.
  • Designed and developed Data Models using different modeling techniques.
  • Designed and Developed ETL processes and maintain data integrity.
  • Facilitated Data exchanges and Business Intelligence (BI) needs.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Ssas Developer III Resume

Headline : Help the client design, build, stabilize and deploy a Microsoft Business Intelligence solution for a large 12 million record flat file using SQL Server, SSIS, SSAS, SSRS, Participate in customer team meetings and conversations with client personnel to understand business and technical requirements including requirements definition, schema design, ETL (SSIS), cube design and development (SSAS), end-user presentation (via analytic reports, graphs, scorecards, etc.), testing, deployment, and post-deployment support.

Skills : ETL, OLAP, OLPT, SQL Server, SSRS,SSIS.

Description :

    1. Interacted with SME's and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
    2. Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
    3. Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
    4. Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
    5. Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
    6. Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
    7. Developed and maintained sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Ssas Developer II Resume

Summary : Over 6+ years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Health Care and Insurance. Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions. Very good understanding of SQL Server Architecture design and Data-Warehousing Concepts.

Skills : T-SQL, Query Analyzer, DTS Designer, SAS Clinical.

Description :

    1. Fully integrated suite of hosted products and sales support services are custom designed for the needs of the clients, leveraging the vast industry experience to meet current and future needs.
    2. Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
    3. Involved in installation and configuration of MS SQL Server 2012.
    4. Created and modified complex TSQL batches/stored procedures.
    5. Defined Check Constraints, functions, indexes, synonyms and views.
    6. Involved in creating new stored procedures and optimizing existing queries and stored procedures.
    7. Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelor Of Electrical Engineering

Ssas Developer II Resume

Objective : Bachelors degree and 14 years of related experience; Masters degree and 12 years of experience; or 18 years of experience will satisfy degree and experience requirements, ETL developer with 3+ years demonstrable experience using SSIS , T-SQL with SQL Server 2008 - 2012

Skills : SSAS, Data modeling.

Description :

  • Created and maintained a variety of related artifacts (e.g., requirements, process models or diagrams, data matrices, project deliverables).
  • Planed for and conducted implementation activities.
  • Demonstrated strong oral and written communication skills, with the ability to communicate technical topics to management and non-technical audiences, as well as interface with the customer and Northrop Grumman management on a daily basis and compile periodic reports.
  • Became knowledgeable on the HIPAA policies and procedures for the program and ensure awareness of HIPAA breach process. Understand your role in HIPAA compliance and be able to execute that role in an effective manner.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
  • Developed, analyzed, and evaluated information/data to create and maintain business intelligence that supports the strategic objectives of the outreach team.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Ssas Developer I Resume

Summary : Dynamic IT Professional with more than 8 years of experience in system analysis, design, development and implementation of Database and Data Warehousing systems using SQL Server R2/ 2012, SSIS, SSRS and SSAS. Experienced in developing client/server Business intelligence (BI) database application. Experienced in designing, developing, documenting, and testing of ETL jobs in Data Warehouse and Data marts.

Skills : SSAS, Data modeling.

Description :

    1. Operated the world famous fashion shopping search website: Shopstyle.com.
    2. Created, maintained, and optimized data objects like indices and schemata.
    3. Developed logical and physical model for schemas.
    4. Created standard data documentation, such as ERD and Flow Diagram.
    5. Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
    6. Created copies of operational Databases using the replication of the database on to the new database using the wizard.
    7. Created Stored Procedures, Triggers, Tables, Views and other T-SQL code ensure efficient data retrieval.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Assistant Ssas Developer Resume

Summary : Work on a team helping to define and develop requested business intelligence deliverables, Work on a team to synthesize business intelligence and trend/benchmarking data to generate standard or custom reporting that supports recommendations for action readily consumable by business owners. Maintain and update business intelligence methods, databases, dashboards, tools or systems, Work with SSAS 2014-2016 to build and extract data from data cubes.

Skills : SQL Business Intelligence, Data warehousing, SQL server Database Programming.

Description :

  • Provided technical support for existing business intelligence tools and systems.
  • Performed application testing, configuration management, and documentation.
  • Performed SQL Server Administration and scripting.
    Develop ETL processes for data warehousing and automated tasks.
  • Built SSRS dashboards and reports using Visual Studio and/or Report Builder.
  • Developed Real Time and specific reporting for Outreach.
    Communicate technical report conclusion and data driven strategies to Field employees and Executive level data consumers.
  • Developed data mapping strategies and CRM navigation.
  • Developed and adjust relationships between business processes, data collection and data analysis for efficiency and accuracy.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Ssas Developer/Admin Resume

Summary : Over 8 +Years of extensive IT experience as a Microsoft SQL Server Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Finance and HealthCare.

Skills : SQL Business Intelligence, Data warehousing, SQL server Database Programming.

Description :

    1. Served the needs of the community and the City, COA work in partnership internally and with other departments' IT business units across the organization to deliver and sustain state-of-the-art technology solutions.
    2. Designed and created Data Warehouse to develop reports.
    3. Created SSIS packages to pull the data from Oracle in to Data Warehouse.
    4. Created packages to do the incremental loading twice a day in to the data warehouse.
    5. Created DB objects like stored procedures, tables, views etc.
    6. Converted DTS jobs to SSIS packages.
    7. Used new features available in SSIS, improved the process and performance of DTS Jobs.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

Ssas Developer/Analyst Resume

Summary : Server Analysis Services (SSAS) Developer will develop solutions required to support the business with robust solutions that provide data, analytics, and reports, which support numerous functions including metrics, dashboards and data discovery. Designs, analyzes, develops, codes, tests, debugs and documents solutions to satisfy business requirements. Proficient in data warehouse development skills spanning multiple design techniques.

Skills : SQL Business Intelligence, Data warehousing, SQL server Database Programming.

Description :

  • Headquartered in Pittsburgh, Pennsylvania Responsibilities: Created DB Objects like Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
  • Worked on Performance point server and created management reports.
  • Monitored SQL jobs to increase the performance at job level and CPU usage level and also involved in the performance tuning of Indexes.
  • Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel spreadsheets, flat files and vice versa.
  • Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages.
  • Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived (not limited).
  • Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors