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.

Ssas Developer Resume Template

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


Ssas Developer Resume

Headline : Hardworking, organized, Ssas Developer professional with a proven background delivering sensible business technology solutions on time and under budget while working as a team member or team leader.

Skills : Organizational Skills, Leadership.

Ssas Developer Resume Sample

Description :

  1. Demonstrated an understanding of business requirements & business concepts.
  2. Experienced working with a team using Git.
  3. Experienced with Build/Release Pipelines in Azure DevOps.
  4. Hands-on experienced in MS SQL to write complex, highly-optimized queries across large volumes of data, database design, data warehouse design, query performance tuning and writing stored procedures.
  5. Knowledged and experienced with full SDLC lifecycle.
  6. Experienced in working in Agile teams, and working independently with Business stakeholders providing solutions and regular updates.
  7. Knowledged of data models, ETL and data warehouse processes.
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.

Jr. Ssas Developer Resume Format

Description :

  1. Ability to demonstrate an understanding of business requirements & business concepts.
  2. Experienced working with a team using Git.
  3. Experienced with Build/Release Pipelines in Azure DevOps.
  4. Responsible for analysis, design, development, deployment and support of enterprise systems such as EDW and BI on multi-tier environment.
  5. Designed and developed Data Models using different modeling techniques.
  6. Designed and Developed ETL processes and maintain data integrity.
  7. 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 : Helping 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 : Developing Skills, Testing Skills.

Ssas Developer III Resume Example

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.

Ssas Developer II Resume Sample

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.

Ssas Developer II Resume Template

Description :

  1. Created and maintained a variety of related artifacts (e.g., requirements, process models or diagrams, data matrices, project deliverables).
  2. Planed for and conducted implementation activities.
  3. 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.
  4. 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.
  5. Developed, analyzed, and evaluated information/data to create and maintain business intelligence that supports the strategic objectives of the outreach team.
  6. Experienced with SQL Querying.
  7. Experienced with Production Models & troubleshooting skills.
            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 : Managing Skills, SAS Developer.

            Ssas Developer I Resume Template

            Description :

            1. Operated the world famous fashion shopping search website: Shopstyle.
            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 : Working 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 : Business Management, Supervising Skills.

            Assistant Ssas Developer Resume Model

            Description :

            1. Provided technical support for existing business intelligence tools and systems.
            2. Performed application testing, configuration management, and documentation.
            3. Performed SQL Server Administration and scripting.Develop ETL processes for data warehousing and automated tasks.
            4. Built SSRS dashboards and reports using Visual Studio and/or Report Builder.
            5. Developed Real Time and specific reporting for Outreach.Communicate technical report conclusion and data driven strategies to Field employees and Executive level data consumers.
            6. Developed data mapping strategies and CRM navigation.
            7. 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 : Creative Skills, Developing Skills.

            Ssas Developer/Admin Resume Example

            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 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.

            Ssas Developer Resume Model

            Description :

            1. 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.
            2. Worked on Performance point server and created management reports.
            3. Monitored SQL jobs to increase the performance at job level and CPU usage level and also involved in the performance tuning of Indexes.
            4. 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.
            5. Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages.
            6. Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived (not limited).
            7. 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