Sql Server Developer Ssis/ssas Resume
Richardson, TX
SUMMARY
- Having 8 years substantial IT experience with Entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI, SDLC from Prototyping to Deployment.
- Experience in working with HealthCare Insurance, Telecom, Software Enterprise, Financial Domains.
- Experience in Optimizing Code and Improving Efficiency in Databases including Re - Indexing, Updating Statistics, Recompiling Stored Procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
- Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems.
- Good Experience in Data Architecture, Design and Creation of MS SQL Tables, Views, Stored Procedures, Triggers, Functions and other objects using T-SQL.
- Excellent in Creating 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.
- Hands-on Experience in Design and Development of ETL Solutions for Data Warehouses and Data Marts, using different Architecture, Design Techniques in SSIS and Deploying the SSIS Packages from Development Server to Production Server.
- Worked Extensively on ETL Process using SSIS Package and Data Migration from different SQL Versions.
- Experience in Delivering BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau, Crystal reports and MicroStrategy.
- Excellent Knowledge of Designing, Developing and Deploying various kinds of Reports using SSRS with Relational and Multidimensional Data.
- Experience in Troubleshooting Report Processing, Delivery and Configuration Problems in SSRS.
- Develop Reports using Complex Formulas and to query the Database to generate different types of Ad-hoc Reports using SSRS.
- Experience in Analyzing, Designing, Building &, Testing of OLAP Cubes with SSAS and in adding calculations using MDX.
- Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
- Experience in creating Perspectives, Partitions and Design Aggregations in Cubes using SSAS also Expertise in Creating Dashboard Reports to Support End Users using SSAS.
- Experience in Microsoft Power BI Query to Extract Data from External Sources and Modify Data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
- Good Experience with Erwin Data modeler, MS Visio Data Modeling Techniques.
- Used Power BI, Power Pivot to Develop Data Analysis Prototype, and used Power View and Power Map to visualize reports.
- Experience working with Microsoft Azure SQL Database Deployment, Migration, Backups, Azure settings using PowerShell.
- Excellent knowledge in Dealing with Assemblies, User Controls and Custom Controls in ASP.NET, Shell Scripting and C#.
TECHNICAL SKILLS
Languages: SQL, T-SQL, PL/SQL, Shell Scripting, C#
SQL Server Tools: Management Studio, BI Development Studio, SQL Server Data Tools, Enterprise Manager, Query Analyzer, Profiler.
Databases: SQL Server 2016/2014/2012/2008 R2/2008, Oracle 9i/10g
Operating Systems: Windows Server 2012/2012R2/2008, Windows 8/7, UNIX
ETL: SSIS, BCP, Import/Export Wizard
Data Modeling: Erwin Data modeler, ER Studio, MS Visio
Web Technologies/ Tools: HTML, XML, Visual Studio, MS Front page
OLAP Tools: SSAS, MS Excel
Reporting Tools: Visual Studio, Report Builder, SSRS, Crystal Reports, Tableau
Web Servers: IIS, APACHE Tomcat
PROFESSIONAL EXPERIENCE
Confidential, Richardson, TX
SQL Server Developer SSIS/SSAS
Responsibilities:
- Worked on Administration Tasks such as Data Loading, Batch Jobs, Data Unloading, Backup & Recovery, User and Application Table Management, Upgrades, creating Databases/File groups/Transaction logs etc.
- Created Databases, Tables, Views, Indexes, Functions, Stored Procedures and Maintained Roles and Database users in SQL Server.
- Gathered Business Requirements, Defined and Designed the Data Sources, Data Flows, Data Quality Analysis, worked in conjunction with the Data Warehouse Architect on the development of Logical Data Models in SQL Server.
- Created logs 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.
- Used XML and Environmental Variables in the Package Configuration for Deploying SSIS packages.
- Used SSIS to create ETL Packages to Validate, Extract, Transform and Load Data to Data Warehouse Databases, Data Mart Databases, and Process SSAS Cubes to Store Data to OLAP Databases.
- Expertise in creating various Parameterized, Cascaded, Linked, Cross-Tabs, Drill-down and Sub-Reports, Drill-through and Drill-down reports using SSRS.
- Created Region Level Security in Reports to prevent users of one region from seeing Data of a different region and Implemented Subscriptions for Reports using SSRS.
- Created Jobs Performance Report that Queries System Tables to Track the Duration of each job and Weekly-Average Duration using SSRS.
- Discussed the Data model, data flow and Data Mapping with the application development team.
- Involved in Dimensional Modeling by Identifying the Fact and Dimension Tables based on the user & Reporting requirements.
- Implemented business logic as .NET Framework assemblies (C#).
- Experience in Agile Scrum Methodology as the Development Process for the Project Implementation.
- Created Power BI Dashboards on Cloud Connecting to Sales Force Data to be able to Drive Dashboard Reporting.
Environment: MS SQL Server 2016/2014, Windows Server 2014, SSMS, BIDS, SSRS, SSIS, SSAS, Erwin, Team Foundation Server, FTP, MS-Visual Studio, Unix, XML, XSLT, ADO.NET.
Confidential, Fort Worth, TX
SQL BI Developer
Responsibilities:
- Wrote Stored Procedures, Triggers, and Constraints to ensure Data Integrity, Data Consistency and to meet the Business Rules in SQL Database.
- Converted various T-SQL Statements into Stored Procedures Thereby Reducing the number of Database accesses.
- Worked in Application Development and provide necessary SQL Scripts using SQL and PLSQL.
- Scheduled SQL Server Agent Jobs to Monitor Data Transformation and Database Updates.
- Monitored Performance and Optimizing SQL Queries for Maximum Efficiency.
- Transformed data from various Data Sources using OLEDB Connection by Creating various DTS packages in SSIS.
- Design and Developing SSIS Packages to Import Data from various large volume Encrypted Files into SQL Database for Data Warehouse.
- Processed and Maintained the Cubes on a Schedule directly in SQL Agent through SSIS Analysis Services Process Task.
- Built different types of Reports usingSSRSfor the Business Requirement like column chart, Pie Charts etc.
- Developed Reports using Complex Formulas and Query the Database to generate different types of Ad-hoc Reports using SSRS.
- Scheduled and Monitored SSRS Report Subscription and Deliveries such as Email Delivery and File Share Delivery as required.
- Involved in creating SSAS Cubes using Multiple Dimensions, Perspectives, Hierarchies, measures groups to Analyze Marketing Efforts and Prospective Customers.
- Active participation in Software Development Life Cycle (SDLC) specifically Agile Scrum Methodology.
- Worked with team in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, Fact and Dimensional Tables and Operational Data Store (ODS).
- Involved in the Analysis of the Existing Claims processing system, Mapping phase according to functionality and data conversion procedure.
- Experience in Monitoring overall SharePoint Usage Reporting.
- Experience in Analyzing, Designing, Building &, Testing of OLAP Cubes with SSAS and in adding calculations using MDX.
- Created Web Forms using ASP.NET, MS Visual Studio .NET, C#, XML, HTML.
Environment: Microsoft SQL Server 2014/2012, Management Studio (SSMS), ETL, Integration Services (SSIS) 2012,2014 Reporting Services (SSRS) 2012/2014, SPL/PL SQL, Power BI, TFS, SQL Profiler, SQL Server Query Analyzer, Windows Server 2014, Tableau.
Confidential, Raleigh, NC
SQL Developer
Responsibilities:
- Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-Defined functions and Cursors for Application.
- Involved in the SQL Data Warehouse Design and Development.
- Created T-SQL Queries, Dynamic-Queries, Sub-Queries and Complex Joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
- Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
- Designed ETL Packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Done Mappings using SSIS Look Up/Aggregation Transformations to match the needs of the Business.
- Developed Drill Down Reports in SSRS and Generated daily, weekly and monthly Reports.
- Involved in Scheduling, Creating Snapshots and Subscriptions for the Reports using SSRS.
- Involved in Developing Numerous Ad-hoc Reports using SSRS.
- Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.
- Involved in Designing Logical and Physical Data Models using ERWIN.
- Worked with team in Designing Dimensional Modeling using SSAS packages for End-User.
- Extensively used and developed SQL scripts/queries in Backend Testing of Databases.
- Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
Environment: MS SQL Server 2012/2014, Enterprise Edition, MS Analysis Services 2014/2012, SSIS, T-SQL/PL SQL Erwin 4.1, MS Access
Confidential, Iselin NJ
BI Analyst
Responsibilities:
- Worked on System Analysis & Design of the Enterprise Data Warehouse Implementation, Requirements gathering and understanding the Business Flow.
- Analyzed Data Flow and Business Requirements to create High Level Design Document.
- Interacting with the users and Troubleshooting the problems involved with the Development of Stored Procedures, Triggers and problems related to the privileges in SQL.
- Involved in Interacting with Business users for Requirements Gathering and Analyzing Source Data for Reporting.
- Optimized queries using SQL Profiler and Database Engine Tuning Advisor.
- Creation of Database Tables and Procedures to Update and clean the old data in SQL Database.
- Responsible to Tune ETL Procedures and Schemas to Optimize load and query Performance in SSIS.
- Transferred data from Flat Files, Excel Spreadsheets and Heterogeneous data to SQL Server using SSIS.
- Created document for Self-Service Deployment and Execution process for SSIS packages.
- Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server.
- Used SSRS to create Reports, Customized Reports, On-demand reports, Ad-hoc reports and involved in Analyzing Multi-Dimensional Reports in SSRS.
- Scheduled and Monitored SSRS report Subscription and Deliveries.
- Participated in Creating Time Dimensions on OLAP Cubes using SSAS.
Environment: Microsoft SQL Server 2012/2008R2/2008, MS Access, SSAS, SSIS, SSRS, PL/SQL, Visual Studio 2012/2008, ERWIN, Windows server 2012, DTS, TSQL, Oracle 10g, SQL Profiler, DTS, Team Foundation Server, CITRIX.
Confidential
Business Intelligence Developer
Responsibilities:
- Worked Extensively on Installation, Upgrade and Configuration of Databases/SQL Servers.
- Implementation of Point in Time Backup and Recovery Plans of all Databases and Maintain Documentation.
- Schedule the Administrative Tasks like Database Integrity checks and maintenance plans.
- Extensive Exposure to Creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), Transact-SQL, and SQL Server Agent and SQL Server Profiler.
- Experience in Planning and Implementing the Replication of MS SQL Server Databases and Databases Backup Recovery Strategy.
- Very Good Experience in the Maintaining Production Servers, Monitoring Performance Issues, Troubleshooting and Solving Production Issues.
- Experience on Working with BRP (Business Recovery Plans) and EPP exercises (Emergency Prepared Plans)
- Creation and Maintenance of Users Security Permissions and Migrating the Entire Database Objects from one Server to another Server and Database to another Database.
- Worked with team and Developed, deployed, and monitored SSIS Packages.
- Used ETL (SSIS) to Develop Jobs for Extracting, Cleaning, Transforming and Loading Data into Data Warehouse.
- Designed SSIS Packages to Transfer Data from Flat Files to SQL Server using Business Intelligence Development Studio.
- Involved in Designing Reports, Graphs and Deployment of Reports to Web Applications using SSRS.
- Created SSRS Reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
- Exposure to Microsoft analysis Services(SSAS)
Environment: SQL Server 2008/2008R, SSIS, SSRS, DB2, Windows 2000/XP, IIS 5, Oracle 9i, ODBC.
Confidential
SQL Developer
Responsibilities:
- Created Complex Stored Procedures and Functions to Support the Front-End Application.
- Created Database Triggers to Implement Business Requirements.
- Participated in Developing Logical Model and Implementing Requirements on SQL Server.
- Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
- Successfully Created Schema Change Scripts to Existing Objects to Synchronize with changing b\Business Rules.
- Optimize SQL queries for Improved Performance and Availability.
- Configured and Monitored Database Application.
- Worked with Quality Assurance to Develop Test Plans and Test Cases to conduct System Testing.
- Involved in Performance Tuning of the Database and T-SQL queries.
- Involved in Preparation of Project Documentation.
- Preparation of Test Plans for Assembly testing & System Integration testing.
- Worked on various Data Extract, Transform and Load(ETL) Processes in SSIS.
- Worked with team in Creating and Deploying SSIS Packages.
- Exposure to Reports Development to generate Daily, Weekly, Monthly, Quarterly, Yearly Reports using SSRS.
Environment: SQL Server 2005/2008, SSIS, SSRS, DB2, Windows 2000/XP.