Sr.sql Bi Developer Ssis/ssas/ssrs Resume
Spokane, WA
PROFESSIONAL SUMMARY:
- Over 8 years of IT Experience as SQL Server Database and BI Developer using SSIS, SSAS, SSRS ( SQL Server 2005/2008/R2/2012):
- Experience in design and development of Business Intelligence tools like SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
- Worked with large data size up to 20 million of data rows at Confidential
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
- Experience in Data Warehouse Design and analysis of various approaches to maintain Dimensions and Facts in the process of building a data warehouse application cubes using SSAS 2012/2008 R2/2008.
- Performed data extraction from OLTP to OLAP for decision making using SSIS.
- Extracted large volumes of data from different data sources (SQL, DB2, Flat, Excel) and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
SKILLS:
Databases: SQL Server (2012/2008 R 2/2008/2005/2000 )
Business Intelligence: ETL, SSIS, SSRS, SSAS (Integration Services, Reporting Services, Analysis Services), Business Intelligence Development Studio (BIDS), Migration of data, Data extraction.
PROFESSIONAL EXPERIENCE:
Confidential, Spokane, WA
SR.SQL BI DEVELOPER SSIS/SSAS/SSRS
Responsibilities:
- Worked with Business users to understand the requirements and translated them as technical specifications related to Paper Manufacturing Speed, Inventory, Distribution, Marketing, Invoices, Orders, Production, Shipment, Safety etc.,
- Design the data models and data definition dictionary for development by working along Subject Matter Experts and Onsite manufacturing personnel’s.
- Created ETL Packages using SSIS to extract data from different Data sources to staging tables to partitioned tables with very little transformation or interferences.
- Views are used to load the data to new database and the health of data is checked.
- Created Stored Procedures, Views, Triggers, Indexes and Constraints on various database objects to obtain the required results.
- Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
- Developed, monitored, deployed, scheduling jobs, alerting and maintaining SSIS packages.
- Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
- Created complex SSAS cubes with multiple fact measures groups, calculated measures are defined using MDX and multiple dimension hierarchies based on the OLAP reporting needs.
- Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub - reports, Parameterized Reports
- Build dashboards, automated reports and report templates, while developing reports from Cubes also used the KPI’s for decision making.
- Support Microsoft Power Pivot and Power BI infrastructure including server security, troubleshooting and general system maintenance
- Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV), Cubes using the identified Fact and dimension tables.
- Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
- Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
- Experience in Report Builder in SSRS 2012 and 2008 R2. Involved in creating, structuring, formatting using Report Designer and Report Builder.
- Scheduled and subscribed Reports based on a particular Day and sent them through Email in required format (Excel, PDF)
Environment: MSSQL Server 2008/2008 R2/2012/2014, Integration Services (SSIS 2008/2008 R2/2012), Analysis Services (SSRS 2008/2008 R2/2012), Visual Studio 2008/2010. Reporting Services (SSRS 2008/2008 R2/2012), Business Intelligence Development Studio (BIDS), MS Office 2007/2010/2013 , Visio, Power Pivot
Confidential, Los Angeles, CA
SR.SQL BI DEVELOPER SSIS/SSAS/SSRS
Responsibilities:
- Worked with Business users to understand the requirements and translated them as technical specifications related to different groups like Commercial Business Intelligence with respect to Policy, Premiums, Claims, Commissions, Deductions, Net pay, Contract value etc.
- Design the data models for development by working along Subject Matter Experts and Accounting Business.
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Transferred data to various data sources systems including MS Excel, MS Access, Text Files, Flat Files to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
- Created Stored Procedures, Views, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
- Tested and optimized the stored procedures to decrease the process execution time.
- Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
- Developed, monitored, deployed, scheduling jobs, alerting and maintaining SSIS packages.
- Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports
- Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV), Cubes using the identified Fact and dimension tables.
- Involved in Development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
- Migrated data from different data sources to SQL Server.
- Created Stored Procedures, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
- Tested and optimized the stored procedures to decrease the process execution time.
- Tested the data with complex queries, joins and sub queries.
- While developing reports from Cubes also used the KPI’s for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.
- Identified and Defined Key Performance Indicators in SSAS.
- Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
- Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
- Experience in Report Builder in SSRS 2008 and 2008 R2. Involved in creating, structuring, formatting using Report Designer and Report Builder.
- Scheduled and subscribed Reports based on a particular Day and sent them through Email in required format (Excel, PDF)
- Scheduled the backups for Databases and Transaction log. Performed restoration operations.
Environment: MSSQL Server 2008/2008 R2/2012, Integration Services (SSIS 2008/2008 R2/2012), Visual Studio 2008/2010. Reporting Services (SSRS 2008/2008 R2), Business Intelligence Development Studio (BIDS), MS Office 2007/2010, MS Access, ETL, Visio, Toad, MS Excel.
Confidential, Franklin, TN
SR.SQL BI DEVELOPER SSIS/SSRS
Responsibilities:
- Worked with Business users to understand the requirements related to Health plans and Claims translated them as technical specifications with guidance from SME’s.
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Developed, monitored and deployed SSIS packages, also responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Transferred data from various data sources systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
- Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
- Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
- Tested and optimized the stored procedures to decrease the process execution time.
- Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports
- Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
- Created Tabular, Charts, graphs and sub reports etc as per customer requirements using SSRS.
- Experience in Report Builder in SSRS 2005 and 2008. Involved in migration and Conversion of Reports from SSRS .
- Migrated Data from SQL Server .
- Migrated DTS packages to SSIS using DTS Exchange.
- Tested the data with complex queries, joins and sub queries.
- Experience in DQ Analyzer for data profiling and to identify data issues before they become critical business issues.
- Involved in creating, structuring, formatting using Report Designer and Report Builder.
- Scheduled and subscribed Reports based on a particular Day and sent them through Email in required format (Excel, PDF)
- Collected business requirements from users and translated them as technical specifications and design documents for development.
- Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
Environment: MS SQL Server 2005/2008, Reporting Services (SSRS 2005/2008), Business Intelligence Development Studio (BIDS), Integration Services (SSIS 2005/2008), Visual Studio 2005/2008, MS Office 2007, DQ Analyzer, MS Access, ETL, Visio, Toad, MS Excel.
Confidential, Arlington, TX
SR. SQL DEVELOPER/SSIS/SSRS/SSAS
Responsibilities:
- Migrated the data from SQL Server 2000 to SQL Server 2005.
- Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
- Documentation for all kinds of reports and DTS and SSIS packages.
- Developed Cubes using SQL Analysis Services (SSAS).
- Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
- Created stored procedures, triggers, UDFs, views, tables and generated T-SQL script for application.
- Implemented logical design into physical design.
- Maintained design structure (Schema) by directing implementation of SQL standards and guidelines.
- Created a virtual machine and migrated databases.
- Migrated DTS packages using DTS editor wizard in SSIS, validated and tested all packages on development server.
- Migrated data from different data sources to SQL Server.
- Created indexes for better performance.
- Created log shipping on servers for disaster recovery.
- Created packages for database maintenance and to migrate data from different data sources to data warehouse.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
- Involved in development & deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
- Used VB script in script component for data transformations.
- Managed Package Configurations in XML files to efficiently promote Unit Testing.
- Data migration (Import & Export using BCP) from text to SQL Server2005.
- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Created report model for Ad-hoc reporting, generate report in XML format.
- Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV), Cubes using the identified Fact and dimension tables.
- Bulk data migration using SSIS from flat files.
- Identified the measures and dimensions from Excel sheets.
- Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
- Deployed the generated reports directly on the client’s workstation.
- Created complex stored procedures for better performance to generate reports.
- Deployed reports on share point performance server.
- Used VB.Net to create user define functions in SSRS.
- Created standard and data driven Subscription, used report manager for securities.
- Used KPIs for decision making while developing reports from Cubes.
- Implemented Cube Partitions and debugged data connections, data sources and Data Source Views.
- Identified and Defined Key Performance Indicators in SSAS.
- Used Team Foundation Server (TFS) for version control, source control and reporting.
- Executed back-up database task, check database integrity, rebuild indexes, update statistics task for maintenance.
- Developed dimensional model, DTS solution, Analysis Services cubes and ProClarity
Environment: SQL Server 2005, SQL Server Analysis Services (SSAS), Query Analyzer, Index Tuning Wizard, MS Access, MS Excel, Erwin, MS Visio, Windows Server 2003 Enterprise Edition, Share point performance server, Performance Point Server 2007, ProClarity.
Confidential, Atlanta, GA
SQL DEVELOPER/SSIS/SSRS
Responsibilities:
- Implemented error handling and roll back process in ETL load.
- Performed data extraction from OLTP to OLAP for decision making using SSIS.
- Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Deploying SSRS Reports across multiple environments including Test, Production and supporting environments.
- Participated in development efforts to analyze client server applications using Visual Basic 6.0 as front-end tool and MS SQL Server Database.
- Actively involved in analyzing the old database system and creating an environment and performed mappings to SQL Server 2005.
- Involved in converting existing PL/SQL stored procedures, triggers, functions and script to T-SQL.
- Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved.
- Performed Data validation Checks during Staging, and then loaded the data into the Data warehouse.
- Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
- Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
- Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
- Created ad-hoc reports, drill down, and drill through reports using SSRS.
- Scheduled Reports based on a particular Day and sent them through Email in formats of Excel, PDF.
- Worked in the complete life cycle of the project, from the beginning i.e. Planning Stage to final i.e. giving the codes to production side.
- Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.
Environment: MS SQL Server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Data Analyzer, Visual Studio 2005.
Confidential, Los Angeles, CA
SQL SERVER DEVELOPER/SSIS/SSRS
Responsibilities:
- Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.
- Migrated databases from SQL Server 2005 to SQL Server 2008.
- Installed and maintained MS SQL Server 2008.
- Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
- Involved in designing the Logical and Physical data models for the data warehouse using Erwin 7.0.
- Created tables, stored procedures, views, functions, and triggers using T- SQL.
- Involved in database designing using Normalization.
- Created the clustered/non-clustered indexes on tables, and traced out for any table required any indexes and determine the type of index on it.
- Created triggers to enforce complex business rules and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
- Used various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- Involved in Requirements Gathering to define data requirements for reporting warehouse.
- Responsible for creating batch files and scheduling the jobs.
- Developed cubes for reporting based on the business requirements using SSAS 2008.
- Identified KPIs and created different scorecards and dashboards.
- Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
- Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008.
- Developed complex stored procedure using T-SQL to generate ad-hoc reports using SSRS.
Environment: MS SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, DTS, T-SQL, OLAP Service, Visual Studio 2005, SQL Server Profiler, Erwin Data Modeler 7.0, Windows Sever 2000/2003/2008 , SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS).
Confidential
SQL DEVELOPER/DBA
Responsibilities:
- Installation, configuration of the MS SQL Server 2000 and maintenance of servers in various environments.
- Performance Tuning of SQL servers and application issues related to migration.
- Testing of applications for performance, data integrity and validation issues.
- Data Transfers between various servers using BCP and Managing Disk space on NT systems
- Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
- Complete automating on NT so that the tasks are run without user monitoring.
- Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
- Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
- Administrative and Production support for various applications in all environments.
- Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.
Environment: SQL Server 2000, Win 2000 Server
Confidential
SQL SERVER DEVELOPER/DBA
Responsibilities:
- Coded the SQL Server stored procedures for the enhancements.
- Tuning and optimization of the stored procedures.
- Created databases, tables, relationships, constraints. Wrote SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
- Enhancement involved implementation of SQL Server with the usage of Stored Procedures, SQL Execution Statistics / Plans, Optimizer and SQL Profiler for back end.
- Planning & organizing the work structure, configuration, risk and delivery management.
- Administered various applications like Maintenance Management and Financial Account System.
- Maintained the client's policies and customer databases and tuning of the database instances.
- Worked with all database objects, including tables, clusters, indexes, views, and procedures.
- Troubleshoot problems concerned with the databases, applications, and development tools.
- Created new databases for users as required. Checking the alert logs daily for oracle errors.
- Tuning of I/O to reduce disk contention by distributing I/O.
- Data modeling, normalization, de-normalization, physical database design, and relational models.
- Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup & Recovery strategies.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Creation of logins and user ids and setting up privileges and procedures for protection of data. Designed screens and reports layout.
Environment: SQL Server 2000, Windows 2000, VB Script, IIS, HTML, CSS, MS Visio.