We provide IT Staff Augmentation Services!

Sr. Sql/ssis/etl/ssrs/ssas Developer Resume

San Francisco, CA

SUMMARY:

  • Over 7.5 years of working experience in design, development and Maintenance of Business Intelligence applications, Such as SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services.
  • Experience in using Microsoft SQL Server 2005/2008/2012/2014/2016 and Microsoft Business Intelligence Suite (Microsoft SSAS, SSIS, SSRS).
  • Experience and knowledge of working in various domains such as Health Care, Retail, Financial, and Telecom.
  • Extensive experience in Microsoft T - SQL statements (DDL and DML) including features like Temporary Tables, Raking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
  • Excellent TSQL Scripting Skills in developing Efficient Stored Procedures, functions, Triggers, Indexes, applying business logic.
  • Implemented best practice in structuring SQL queries, debugging unexpected SQL results etc.
  • Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
  • Experience in Developing, Designing and Support inter active Tableau dashboards.
  • Good Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
  • Designing and creating different SSIS packages using OLE DB connection sources from different sources by making use of multiple transformations provided in SSIS.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Experience in generating Drill through, Drill down, Parameterized, Cascaded Parameterized reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
  • Good at Creating Tablix, Matrix, Graph and other type of reports using SQL Server Reporting Services (SSRS).
  • Expert knowledge in developing multidimensional databases using SSAS.
  • Experience in OLAP cubes using SSAS for data mining.
  • Experience in Dimensional Modeling, Star/Snowflake Schemas, and performance optimization of SSAS cubes.
  • Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies, Perspectives, Partitions and Designed Aggregations in cubes using SSAS.
  • Creating Partitions, Attribute Relations, Perspectives and KPIs using SSAS.
  • Good knowledge in Assurance, including System Integration Testing and Regression Testing by Load Testing Procedures, Coordinating with UAT and Validating Test Cases.
  • Creating and deploying parameterized reports using power BI and Tableau.
  • Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
  • Created and maintained Database Views available to all BI and DW applications.
  • Robust MS Access and excel skills with Power pivot, PivotTable, PivotChart, Power view, V look up functions and formulas.
  • Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance.
  • Experience in Database Backup and Restore. Good Knowledge in Full Backup, Differential Backup and Log Backup.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista

Languages: T-SQL, PL/SQL, C# .Net, ASP.Net, XML, HTML, Java Script

Tools: SQL Server Management Studio (SSMS), Query Analyzer, Business Intelligence Development studio, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, PowerBI, Tableau, ERWIN.

Databases: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000, Oracle10g/9i, MS Access, MySQL

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. SQL/SSIS/ETL/SSRS/SSAS Developer

Responsibilities:

  • Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# code as required.
  • Perform Code review of Stored Procedures and prepare for database build steps for weekly change cycle.
  • Extracted data from SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
  • Configured the SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created SSIS packages in SQL Server 2016 for sources database for Tableau dashboards.
  • Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
  • Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
  • Troubleshoot and resolve various database processes impacting production and provide root cause analysis to prevent and/or improve upon daily transactional throughput.
  • Created reporting process (SSRS) for management to get timed reports on various database counters pertaining to resource consumption.
  • Automated KPI metrics reporting using Visual Studio Team Services/PowerBI.
  • Exported or Imported data from other data sources like flat files using Import/Export through SSIS.
  • Worked on SQL server tools like enterprise manager and SQL query analyzer.
  • Implemented and managed performance tuning tasks with developers in optimizing the long run queries.
  • Implemented side-by-side migration and in-place upgrade of MS SQL Server.
  • Performed Database Upgrades from 2008R2 to 2012 and 2012 to 2014.
  • Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
  • Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
  • Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
  • Created Customized and interactive dashboards using multiple data sources.
  • Created conditional filters and Action links to filter the data on dashboard with Power BI Desktop.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Environment: MS SQL Server 2016, SSIS, SSRS, SSAS, Windows 8/8.1, Tableau, MS Office 2007/2010, T-SQL, POWER BI, Team Foundation Server (TFS).

Confidential, Oak Brook, IL

SQL/SSIS/Power BI Developer

Responsibilities:

  • Created SQL Server (T-SQL) Objectslike Databases, Tables, Stored Procedures, Normalizations, Triggers, Joins, Cursors, Views, Functions, Data Types, Indexes.
  • Analyzed and designed software and database solutions.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • DesignedSSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS).
  • Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Maintains client confidence and protects operations by keeping information confidential according to HIPAA standards
  • Worked on other packages of the SQL server 2012 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
  • Modified SSAS Tabular models with dimensions and fact tables from data sources.
  • Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
  • Developing Warehouse reporting capabilities for ACO, ACQA, PQRS, HEDIS and other industry required reporting.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2012 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies usingSSAS.
  • Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
  • Created and managed relationships between tables in Power BI to calculate accurate results.
  • Transformed and combined the data using Query Editor in the Power BI.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Published Power BI Desktop reports created in Report view to the Power BI service.
  • Worked on Power View and Power Map to visualize reports.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2012 Reporting Services.
  • Experienced inSDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, and E-R Diagrams.

Environment: MS SQL Server 2012, SQL Server Analytical Services, SQL Server Reporting Services 2012, SQL Server Integration Services, Windows 8/8.1, MS Office 2007/2010, T-SQL, POWER BI.

Confidential, Houston, TX

SQL/BI (/SSIS/SSRS/SSAS) Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Involved in gathering user requirements and system specifications.
  • Developed stored procedures, functions, and database triggers and maintained referential integrity and implemented complex business logic.
  • Designed and created views for security purposes. Implemented rules, defaults, and user-defined data types. Tested queries to optimize procedures and triggers to be used in production.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Designed and implemented parameterized and cascading parameterized reports usingSSRS.
  • Worked on creating multiple SSRS reports in Drill-through mode and Cross Tab Reports.
  • UsedSSRS Report Manager to assign roles, permissions and to create report schedules.
  • Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using this data using SSRS.
  • Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS) for the managers.
  • UsedSQL Profiler for troubleshooting, monitoring, and optimization of TSQL code.
  • Performance tuning for existing queries in SQL Server Databases to reduce Production environment time cost.
  • Improved the performance of many queries by reducing the usage of the cursors and other complex joins along with implementation of new indexes.
  • Performed Data modeling for existing Databases using Toad Data Modeler and ER Studio.
  • 24x7 support to meet the deadlines of tasks from customers.
  • Creating documentation for all databases when they are in different stages.
  • Be involved in the planning of system, development and deployment plans as well as responsible for meeting software compliance standards.
  • Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
  • Performed tuning to optimize SQL queries using SQL profiler and query analyzer.
  • Experienced in loading data into Oracle Database using Data Loader and SQL Loader.
  • Implemented named queries and created usage-based aggregations within SSAS Cubes to optimize performance.
  • Involved in Dimensional Data Modeling and Cube partitioning in S SAS.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
  • Generated and implemented schema objects and application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and templates using ETL.
  • Perform system optimization, database performance analysis, capacity planning, and system sizing.

Environment: SQL Server 2012, T- SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS).

Confidential, Warren, NJ

SQL/BI (SSIS/SSRS) Developer

Responsibilities:

  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Developed Queries for generating drill down and drill through reports inSSRS2008 R2.
  • Uploaded reports on to the report manager and organized them into folders.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
  • Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008 R2 Developed, deployed and monitored SSIS Packages including upgrading DTS toSSIS.
  • Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.
  • Created Linkedserversto connect OLE DB data sources and providers.
  • Administered the SQL Server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc. as required Worked with Installation/Management of MS Team Foundation Server and TFS Migration processes.
  • Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
  • Designed and deployed reports with Drill Down, Drill Through, Parameterized, Parameterized Cascaded and Sub-reports using SSRS.
  • Wrote T - SQL queries, Stored Procedures and used them to build packages.
  • Created automated T - SQL scripts to process summary database transactions that run off-hours.

Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services ( SSRS), Windows Server 2008, T-SQL, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2010, T-SQL.

Confidential

MS SQL Server Developer

Responsibilities:

  • Gathered functional and Business requirements and wrote technical specifications for building the Global Enterprise Data Warehouse.
  • Involved in re-designing of database to create de-normalized reporting schema for better throughput.
  • Developed new mappings using transformations like Look Up, Aggregation, Derived Column, Data Conversion etc transformations to match the needs of the business case.
  • Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files
  • Created DTSX Packages to import and export data from Excel, Access, SQL Server 2008and Text files.
  • Created SSIS Packages using Variables, Expressions and Environment Variables
  • Created Production support packages.
  • Migrated DTS 2005 packages to SSIS 2008 Packages.
  • Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.
  • Involved in accounting code module to populate general ledger code by writing complex T -SQL queries, stored procedures.
  • Developed Store Procedures and User defined functions (UDF) to access data from Data Mart.
  • Automate Maintenance processes and Backup/Recovery processes and procedures. Create plan to test recovery procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, Reporting Services, SQL Enterprise Manager, Windows XP, MS Access, MS Excel, Windows 7, HTML, Visual Source safe.

Hire Now