Sr. Sql Bi Developer (ssis, Ssrs, Ssas) Resume
Johns Creek, GA
SUMMARY
- Over Eight (8) years of extensive experience in database design, development, and administration with MS SQL Server versions 2012/2008R 2/2008/2005/2000 using SSIS, SSRS, SSAS in Financial, Retail and Insurance industries.
- Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
- Strong experience in logical and physical database design and development, Normalization and data modeling using CA Erwin and MS SQL Server Enterprise manager.
- Strong expertise in Data modeling using Erwin 9/8/7.2 and MS Visio with good understanding of Relational Database Management System (RDBMS).
- Extensive experience in MS SQL Server 2012/2008R2/2008/2005, Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
- Involved in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2008/2005.
- Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS and DTS (Data Transformation Services) utility.
- Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
- Strong experience in designing and developing large number of reports in SSRS using the data from ETL Loads.
- Worked in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
- Involved in creating, configuring and fine-tuning ETL work flows designed in DTS and MS SQL Server Integration Services (SSIS).
- Worked in Creating and Deploying SSRS Reports on the portal for user accessibility.
- Excellent in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
- Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
- Efficient in up-gradation and migration from SQL Server 2000 to SQL Server 2008/2005.
- Involved in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
- Excellent inter personal skills and communication skills and ready to take challenges with proven ability.
- Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Excellent Experience in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
- Expertise in using Team Foundation Server (TFS), SVN and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
TECHNICAL SKILLS
Databases: SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Access, Oracle 9i/10g/11/11g, MySql, data warehouse.
Database Tools: SS Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL.
Languages: T-SQL, C, VB 6.0, VB.NET, PL/SQL, ASP.NET 2.0, Java, HTML, UML, XML, XMLA, JavaScript, MS SharePoint, MS windows
BI Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP, Cognos, Tableau
Operating Systems: Windows NT Server, Windows Server 2003, Windows XP, UNIX, Agile, Linux
PROFESSIONAL EXPERIENCE
Confidential, Johns Creek, GA
Sr. SQL BI Developer (SSIS, SSRS, SSAS)
Responsibilities:
- Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
- Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
- Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2012.
- Designed and deployed Reports with Drop Down menu option and Linked reports.
- Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
- Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
- Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
- Experienced in implementation of strong referential integrity and auditing by the use of triggers.
- Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle
- Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
- Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
- Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
- Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQLServer Agent job and windows Scheduler.
- Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
- Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
- Involved in Reports Development whenever required by business using SSRS.
- Worked with Transactional and Snap-shot Fact-Tables.
- Optimized existing stored procedures to achieve improved performance
- Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
- Developed Cross-Tabbed and Sub-Reports in SSRS 2008.
- Generated reports using the Crystal Reports and Reporting Services 2008Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008.
- Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment
- Designed user defined hierarchies in SSAS including parent-child hierarchy.
- Created complex SSIS packages using various transformations.
Environment: MS SQL Server 2012, Windows Server 2003, Informatica, Enterprise manager, MDX, Query Analyzer, SSIS, SSAS, SSRS, DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.
Confidential, Dallas, Texas
SQL Server Developer
Responsibilities:
- Involved in Creating and maintain databases after logical and physical database design in SQL Server 2008.
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
- Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
- Optimized data retrieval and data modification queries that deal with Tables containing huge amount of data and created indexes to improve the query performance.
- Worked with SQL Server Analysis Services (SSAS) that delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications.
- Migrated data from legacy Databases in SQL 2000 to SQL Server 2005 using SSIS.
- Design, develop, and deploy new reports and enhancements to existing Crystal Reports, for various applications as assigned using SQL server reporting service 2005
- Developed complex stored procedure using T-SQL to generate Ad hoc reports using Business object and SSRS.
- Developed Web portal for accessing the required reports for users from different countries using .NET.
- Involved in Design and Development using .NET Framework 2.0, ASP.NET, C#, VB.Net, SQL Server 2005, Win Forms, Web Forms and Web services Used typed/Untyped datasets, Data Grids, Grid View, user controls, web controls. Wrote connection manager class to manage database connections most efficiently.
Environment: SQL Server 2005/2008, SSRS, SSIS, SSAS, Visual Source Safe, MS Excel, MS Project and MS Share Point.
Confidential, Houston, TX
SQL BI Developer
Responsibilities:
- Created tables with Cluster/Non-Cluster Index, Stored Procedures, and Triggers; programmed and designed reports off transactional databases
- Monitored performance and optimized SQL queries; and created and modified T-SQL stored procedures.
- Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
- Scheduled batch jobs; ran daily SSRS reports
- Developing SSIS packages to extract transform and load the data from multiple flat files, excel files.
- SQL performance tuning by modifying SQL.
- Configuring SSIS packages using package configuration wizard to allow packages run on different environments.
- Developed and Maintained MS Access Database.
- Created views, SQL joins DTS packages and statements for applications
- Develop SSIS packages to load the data into data marts.
- Extensively using SSIS for Transformations, Aggregations and Lookups.
Environment: MS SQL Server 2008/2005, MS Access, SSRS 2008/2005, SSIS 2008/2005, SQL Query Analyzer, SQL Profiler, SQL Alerts, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Word, Excel, PowerPoint, Access, Visio, Outlook
Confidential
SQL BI Developer
Responsibilities:
- Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
- Successfully installed and configured MS SQL Server 2005 on the production server.
- Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
- Generated assessment reports to analyze the scope and complexity of the migration projects.
- Converted the Oracle DB objects to MS SQL Server 2005 DB objects like tables, views, and stored procedures.
- Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
- Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
- Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
- Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
- Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
- Defined referential relationships with the measure groups and fact tables.
- Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
- Defined granularity within a measure group and drill through actions.
- Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
- Defined the browsing perspectives and browsing translations since most transactions were online.
- Documented the development work and production release for future reference.
Environment: MS SQL Server 2005/2000, SSIS, SSRS, T-SQL, Crystal Reports 10, Visual Studio 2005, MS SQL Profiler, MS Office 2007.