We provide IT Staff Augmentation Services!

Sql Ssas Resume

Tinley Park, IL

SUMMARY

  • Has been working as MS SQL Data warehouse/BI developer with experience in development, analysis, administration, database migrations, reporting analysis and data base maintenance.
  • Expertise in the implementation of MS SQL Server 2000 infrastructure & MS SQL Server 2005/2008/2012 Infrastructure.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert ,BCP, Mirroring and Replication.
  • Expertise in using SQL reporting tools with SQL Server 2000, SQL Server 2005 and SQL Server 2008/2012
  • Performed analysis as per business requirements using SSAS.
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Very strong Transact-SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTE’s, Cursors, Views, Indexes, Triggers and Functions.
  • Experienced in writing MDX queries for multidimensional Analysis.
  • Experienced working with MS SQL Server 2005 Service Broker for Database applications.
  • Configured various Publishers and Subscribers for Snapshot and Merge replications.
  • Experienced in the migration and implementation from other databases to MS SQL Server.
  • Expertise in establishing and managing of all standards, processes, artifacts, relative to the practice of Configuration Management.
  • Experienced in working on logical and physical data modeling.
  • Expertise in developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of the products to various developments.
  • Experienced in Using BO for Universe Designing and reporting.
  • Expertise in support tasks involves developer support as well as troubleshooting DB failures
  • Good knowledge of configuration management concepts, release management, changes management concepts, Industry standards and best practices.
  • Migrating and Tuning SQL scripts, indexes, stored procedures and views Fine tuning and optimization of SQL queries and Stored procedures using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updated statistics
  • Several years of innovative and resourceful work with strong administration, analysis, design, development, testing, presentation and implementation experience using SQL Server Databases, Windows NT/2000 and Windows XP
EDUCATIONAL QUALIFICATION
  • Bachelor of Technology in Engineering
  • Post Graduate in Computer Applications
TECHNICAL SKILLS

Language:

SQL, PL/SQL, My SQL, Transact SQL,JAVA

Tools:

SQL SERVER 2000/2005/2008/2012, SQL Enterprise Manager, SQL Profiler, Query Analyzer, ERWIN ,Analysis Manager DTS Import/Export Wizard, SSIS, SQL Reporting Services (SSRS), BO

Applications:

Microsoft Office, Excel, Adobe Photoshop, Acrobat reader /writer

OS:

Windows NT/95/98/2000/XP

EXPERIENCE PROFILE


Confidential,Tinley Park, IL Jan 2012 – Till Date

Role: SQL SSAS Developer/BI Developer
Responsibilities:

  • Created T-SQL scripts for RDBMS applications.
  • Experienced in loading data into relational database using ETL tool.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert ,BCP, Mirroring and Replication.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
  • Maintenance of security standards, facilitate requirements and gathering meetings with clients.
  • Created Stored Procedures for report processing.
  • Performed analysis as per business requirements using SSAS
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Experienced in writing MDX queries for multidimensional Analysis.
  • Experienced working in E-commerce Industry.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Experienced working with MS SQL Server 2005 Service Broker for Database applications.
  • Experienced in writing C# code for Implementing ETL operations.
  • Experienced in designing Data warehouse applications.
  • Experienced working on XML for web applications.
  • Experienced in using BO for Universe designing and reporting.
  • Worked on performance tuning of SQL cluster.
  • Experienced in writing PL/SQL code for Implementing ETL operations.
  • Generated various reports according to business requirements using Reporting Services.
  • Experienced in developing Graphical and Tablix reports using SSRS.
  • Experienced in working on logical and physical data modeling.
  • Used Informatica tool for extracting the source data and loading it into the target after applying the required transformation.
  • Update the SSRS reports with different location and period hierarchy.
  • Development and production support for various databases, DTS and SSIS packages.
  • Managed SSIS and DTS packages quality assurance.
  • Monitor the SQL server Agent jobs and fix the jobs on failure.
  • Experienced in writing My SQL code for Data warehousing applications.
  • Schedule and resolve the issues during the BI development of data warehouse operations.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Experienced working on QA testing.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures
  • Programmed SQL Server 2008 Reporting Services using Microsoft Visual Studio 2005.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Created monthly reports using reporting wizard with Visual Studio
  • Assign Reports to Report Folders in SQL Reporting Services
  • Involved in Scheduling backups and maintenance.
  • Create backups and restore of the databases.
  • Used data conversions to convert different data types
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
  • Optimized SQL queries for improved performance and availability
  • Reorganize database structures as needed, automate procedures at regular intervals.
  • Creating and Maintaining all types of Backups and recovery strategies and set up jobs
  • Involved in requirement gathering, analysis, design, development, change management, deployment and user training
  • Designed, analyzed and upgraded databases.
  • Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
  • Successfully implemented database connectivity from front end
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Actively participated in interacting with different departments regarding their access to the database system and creating views to facilitate the same.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.
  • Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.

Environment: SQL Server 2005/2008/2012, Reporting Services, Bo, Excel, T-SQL, PL/SQL, MS Access, SSIS, SSRS Windows 2000/XP, Visual studio2005

Confidential,St Louis, MO Aug 2011– Dec 2011

Role: SQL SSAS Developer/BI Developer
Responsibilities:

  • Created T-SQL scripts for RDBMS applications.
  • Experienced in Warehouse Management System in controlling the movement and storage of materials within a warehouse.
  • Experienced in loading data into relational database using ETL tool.
  • Generated various reports according to business requirements using crystal reports.
  • Design and create the tables, store procedures, triggers, indexes basing on requirements.
  • Experienced working on XML for web applications.
  • Experienced working with offshore team.
  • Performed analysis as per business requirements using SSAS
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Experienced in writing MDX queries for multidimensional Analysis.
  • Experienced in using BO for Universe designing and reporting.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Experienced in writing PL/SQL code for Implementing ETL operations.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
  • Used Informatica tool for extracting the source data and loading it into the target after applying the required transformation.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Resolve the issues during the BI development of data warehouse operations.
  • Maintenance of security standards, facilitate requirements and gathering meetings with clients.
  • Created Stored Procedures for report processing.
  • Experienced working with MS SQL Server 2005 Service Broker for Database applications.
  • Created reports with complex calculation fields.
  • Generated reports by using Crystal Reports and Excel spreadsheets.
  • Experienced in developing Graphical and Tablix reports using SSRS.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
  • Optimized SQL queries for improved performance and availability.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Created monthly reports using reporting wizard with Visual Studio.
  • Experienced working on QA testing.
  • Performed analysis as per business requirements using SSAS
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Assign Reports to Report Folders in SQL Reporting Services.
  • Optimized long running Stored Procedures & queries for effective data retrieval.
  • Performed and analyzed the calculations for various KPI of the company.
  • Actively participated in interacting with different departments regarding their access to the database system and creating views to facilitate the same.
  • Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.
  • Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
  • Worked with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Environment: SQL Server 2005/2008, Crystal Reporting Services, BO,Query Analyzer, Excel

Confidential,Chicago, IL Aug 2010-Apr 2011

Role: SQL Data warehouse/BI Developer
Responsibilities:

  • Created T-SQL scripts for OLTP and ETL application development on sql server and Teradata.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert ,BCP, Mirroring and Replication.
  • Experienced in loading data into relational database using ETL tool.
  • Experienced in Warehouse Management System in controlling the movement and storage of materials within a warehouse.
  • Performed migration of data from teradata Server to SQL Server.
  • Performed migration of data from Oracle to SQL server using SSIS. In SSIS packages written PL SQL code to bring data to SQL server destination.
  • Generated reports according to business requirements using crystal reports and reporting services 2005.
  • Designed physical and logical modeling of databases for data warehouse applications.
  • Created daily, weekly and monthly SSRS dashboard reports for sales and profit analysis.
  • Update the SSRS reports with different location and period hierarchy.
  • Development and production support for various databases, DTS and SSIS packages.
  • Create and alter various applications including stored procedures, views using TSQL.
  • Managed SSIS and DTS packages quality assurance.
  • Experienced working with MS SQL Server 2005 Service Broker for Database applications.
  • Monitor the SQL server Agent jobs and fix the jobs on failure.
  • Design and create the tables, store procedures, triggers, indexes basing on requirements,
  • Reviewed many T-SQL issues using management studio for better performance.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading using TSQL statements.
  • Developing the applications and perform tuning using SQL profiler and query execution analysis.
  • Schedule and resolve the issues during the BI development of data warehouse operations.
  • Participated in re-design and development of back-end SQL Server database applications.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
  • Maintenance of security standards, facilitate requirements and gathering meetings with clients.
  • Scheduled Jobs and Alerts using SQL Server Agent for SSIS and DTS packages.
  • Using SSIS Performed Migration of databases from SQL 2005 to SQL2008
  • Moved the static data from various heterogeneous sources like Oracle, MS Access, and MS Excel and text files to SQL Server 2005 database using BCP and dynamic DTS/SSIS packages
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Created T-SQL scripts for OLTP and ETL application development.
  • Performed analysis as per business requirements using SSAS
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.

Environment: SQL Server 2005/2008,Reporting Services, Query Analyzer, Excel (pivot tables) SSIS, SSRS, JAVA, Teradata, T-SQL, c#, Visual basic, Business Objects, Visual studio2005, Windows 2000/XP

Confidential,IL. SEP 2009-JUNE 2010

Role: SQL Data warehouse/BI Developer
Responsibilities:

  • Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity for BI and OLTP operations.
  • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert ,BCP, Mirroring and Replication.
  • Experienced in loading data into relational database using ETL tool.
  • Experienced In Warehouse Management System in controlling the movement and storage of materials within a warehouse.
  • Performed migration of data from Oracle to SQL server using SSIS. In SSIS packages written PL SQL code to bring data to SQL server destination.
  • Worked with SSIS to design the packages for ETL Support.
  • Experienced working in E-commerce Industry.
  • Generated T-SQL scripts for application development.
  • Created Stored Procedures and User Defined functions.
  • Created Indexes to speed up the queries.
  • Design many tables for efficient performance of applications and data pull.
  • Create roles and permissions for the data warehouse applications.
  • Moving and promoting the data from development to production.
  • Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedures.
  • Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2005.
  • Used complex expressions to filter and parameterize, and format the contents of a report.
  • Performed Migration of databases from SQL 2000 to SQL2005 using SSIS
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation
  • Scheduling Jobs and Alerting using SQL Server Agent
  • Involved in ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Performed analysis of cubes using SSAS for store ops data of SEARS and KMART.

Environment:SQL Server 2000/2005, Query Analyzer, Excel (pivot tables) SSIS, SSRS, T-SQL, Visual studio2005, Windows 2000/XP

Confidential,AR JUNE 2008 – AUG 2009

Role: Data warehouse/ BI developer
Project: Telecom customer database
Description: Confidential, is owner and operator of the nation\'s largest wireless telecom network and has more than 11 million wireless customers a key member of the Marketing Technologies and development team.
Responsibilities:

  • Written T- SQL codes for the project.
  • Created Stored Procedures for Batch Processing.
  • Experience in controlling the movement and storage of materials within a warehouse.
  • Developed stored procedures, triggers and functions and added / changed tables for data extraction and transformation, and data loading (ETL).
  • Develop and modify the SSIS packages for ongoing data support.
  • Added/Changed Tables, columns, triggers using TSQL.
  • Worked with Business Objects and SSRS.
  • Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
  • Developed, maintain, and support the enterprise data warehouse using SSIS and SSRS system throughout the SDLC.
  • Deliver SQL server reports to SharePoint to enhance team collaboration
  • Generated reports according to business requirements using crystal reports and reporting services 2005.
  • Experienced working in E-commerce Industry.
  • Created monthly reports using reporting wizard with Visual Studio.
  • Assign Reports to Report Folders in SQL Reporting Services
  • Involved in Scheduling backups and maintenance.
  • Upgrade DTS packages to SSIS.
  • Created indexes to improve the performance of the queries
  • Create backups and restore of the databases.
  • Used data conversions to convert different data types
  • Created Views for Extracting Data using TSQL.
  • Performed Migration of databases from SQL 2000 to SQL2005
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables. Configured various Publishers and Subscribers for Snapshot and Merge replications using TSQL.
  • Created Distributed Partitioned Views, Troubleshooting Stored Procedures, and upgrading existing ones. Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
  • Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.

Environment: MS SQL 2000/2005,Sharepoint Windows NT/2000/XP,SSAS,SSIS, SSRS, Crystal reports Visual studio 2005, ASP 3.0,Business Objects, ORACLE 10g, MS Excel(Creating reports), SQL Query Analyzer, Enterprise Manager, MS Access.

Hire Now