Sr. Sql Bi Developer (ssis/ssrs/ssas) Resume
New York, NY
PROFESSIONAL SUMMARY:
- Over 7 years of IT experience in Database Design and Development on Microsoft SQL Server 2008/2005/2000. Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
- Domain knowledge in Healthcare and Banking.
- Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
- High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).
- Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de - normalization.
- Extensive experience with T-SQL, Functions, Views. Created complicated SQL procedures to meet the requirements of the systems being developed.
- Experienced in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
- Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
- Implemented cursors for rebuilding indexes.
- Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
- Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
- Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
- Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.
- Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
- Experienced in performing Incremental Loads and Data cleaning in SSIS. Managed Error handling, logging using Event Handlers in SSIS.
- Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix Reports, Tabular Reports, Charts/Graphs using SSRS in Business intelligence development studio (BIDS).
- Experience in writing Expressions in SSRS and Expert in fine tuning the reports.
- Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
- Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
- Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
- Involved in developing OLAP dimensions, cubes, measures, and calculated members with SQL Server Analysis Services 2005/2008.
- Worked in OLTP & OLAP environments that include QA, Production and development, implemented and maintained database schema and Entity relationship diagrams from business requirements.
- Experienced on Performance monitoring using SQL Profiler scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
- Knowledge of SQL Server solutions including Log shipping, database mirroring, Replication and clustering.
- Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation
- Managed all database servers in development, staging, test and production environments.
TECHNICAL SKILLS:
Languages: T-SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.
RDBMS: SQL Server 2008/2005/2000, Oracle 11g/10g/9i/8i and MS Access 2003/2000/97
Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization
DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.
Tools & Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP.
Operating Systems: Unix, Windows NT/XP/2003/2000,Windows 9x and MS-DOS
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Sr. SQL BI Developer (SSIS/SSRS/SSAS)
Responsibilities:
- Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
- Experience with working in Microsoft Visual Source safe.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
- Generated reports using Expressions and Functions using SSRS.
- Generated various reports like Matrix reports, Tabular reports, and Chart reports, link Reports, Drill down reports.
- Creating a multi-server query SSRS report using Central Management Servers.
- Involved in XML Development and XML File Parsing in SSIS and SSRS.
- Involved to optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
- Created automated stored procedures for day end operations using SQL Server agent.
- Coordinated with front-end for implementing logic in stored procedures and functions.
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
- Implemented failure alerts using email in SSIS.
- Created and used extended stored procedure in SSAS.
- Snapshot Replication was been used to synchronize the data between their Different Stores.
- Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
- Involved in SQL Server Mirroring and Database optimization.
- Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
- Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
- Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
- Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
- Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
- Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
- Created Windows Logins and privileges to User Accounts/Groups and objects.
- Used DBCC commands to troubleshoot issues related to database consistency.
- Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
Environment: MS SQL Server 2008/2012, SSIS/SSAS/SSRS 2008/2012, T-SQL, Visual Studio 2008/2010, vb.NET, ASP.NET, SQL Server Profiler, Erwin Data Modeler 7.2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).
Confidential, Quincy, MA
SQL BI developer (SSIS/SSRS)
Responsibilities:
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Successfully migrated data from CRM Saratoga to Pivotal component using SSIS.
- Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
- Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2012 using SSIS.
- Created and when required, modified already existing stored procedures, triggers, views, indexes.
- Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
- Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
- Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
- Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
- Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Created SSIS packages to retrieve data from Legacy sources, retrieve user data from the Flat files on monthly and weekly basis, File Transfer from one location to the other using FTP task.
- Used Kimball methodology to create data warehouse using SSIS
- Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
- Designed Dashboards using web Focus
- Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008 R2.
Environment: MS SQL Server 2008R2/2012, SQL server Reporting Services 2008R2, SSIS, SSAS, PL/SQL, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, CRM Saratoga and Pivotal.
Confidential, Hartford, CT
SQL BI Developer
Responsibilities:
- Gathered functional requirements and Business requirements and written the technical specifications.
- Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
- Designed and developed data load jobs usingSSISpackage and scheduled in SQL Agent.
- Developed T-SQL and PL/SQL stored procedures and User Define scalar Functions (UDFs) to be used in theSSISpackages and SQL scripts.
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
- Developed, deployed, and monitored SSIS Packages.
- Requirements and design goals ofdata warehouse.
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
- Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
- CreatedSSISpackages for File Transfer from one location to the other using FTP task.
- Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports.
- Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.
- Designed dashboards using Tableau.
- Helped the production team in analyzing bugs & resolving them.
- Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
- Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
- Traced long running queries and deadlocks using SQL Profiler
- Installed and configured SQL Server Reporting Services.
- Experience in using Joins and Sub-Queries to simplify complex queries involving multiple tables.
- Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volume of data.
- Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
- Managed logins, roles, assigning rights and permissions.
Environment: SQL server 2005/2008/2008R2, IIS, Visual Studio, T-SQL,SSIS,SSRS, SSAS, Oracle10g/11g, Crystal Reports, Framework Manager, Tableau, BIDS and SSMS, TFS, PL/SQL, SQL Profiler, SharePoint10.
Confidential, Denver, CO
SQL BI Developer (SSIS/SSRS)
Responsibilities:
- Involved in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Worked with SSIS for transferring and reviewing data from heterogeneous sources like (Oracle, Excel, CSV, flat file, XML, Text Format Data).
- Prepared technical design/specifications for data Extraction, Transformation and Loading.
- Involved in analysing theICD 9andICD 10for the data mapping fromICD 9 - ICD 10andICD 10- ICD 9in source and target level.
- Used SSIS and T-SQL, PL/SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
- Prepared the completedata mappingfor all the migrated jobs using SSIS
- Involved in building and maintaining SSIS Packages to import and export the data from various data sources (Oracle, Excel etc.) using BIDS based on the design data models.
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Used subversion to control the SSIS packages.
- Participated actively in client meetings daily and produced detailed level design document for the customer portals.
- Published Workbooks by creating user filters so that only appropriate teams can view it.Embedded Tableau views in to SharePoint
- Analyzed the source data and handled efficiently by modifying the data types.
- Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.
- Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Adhoc reports usingSSRS 2008 R2.
- Created SSIS packages for File Transfer from one location to the other using FTP task.
- Generated SSRS Reports using Global Variables, Expressions and Functions for the reports.
- Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
Environment: MS SQL Server 2008R2/2012, SSIS, SSRS, PL/SQL, Oracle 11g, VSS, Microsoft Visual Studio, SQL Server Management Studio, T-SQL,TFS, Toad, Unix
Confidential
SQL Server Developer
Responsibilities
- Installation and configuration of SQL Server 2005.
- Created Tables, indexes and constraints.
- Created and maintained Database Objects.
- Created T-SQL stored procedures, functions, tables, views and SQL joins and other statements for various applications, maintained referential integrity and implemented business logic.
- Created backups for databases.
- Created Drill down reports, Ad-hoc Reports and Drill through reports using SSRS.
- Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
- Optimized SQL statements for customer summary reports.
- Client side implementation and testing.
- Partly involved in Performance Tuning.
- Monitored user accounts, user permissions and backup.
- Involved in analysis and Design Documentation, User Requirements and maintained good documentation.
Environment: SQL Server 2005, T-SQL, Crystal Reports, Business Objects, SSRS 2005, MS Access, MS Excel, HTML.