Sr. Sql/ssrs/ssas Developer Resume
New York, NY
SUMMARY
- SQL Server Developer with over 8 years of experience in teh Analysis, Design, Development, Implementing and Testing, Administrating Client/Server applications using Microsoft Technologies.
- Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel and automate teh ETL.
- Experience in working with SSRS, designing different types of reports like Parameterized Reports, Cascading Parameterized Reports, Drill down Reports, Drill through Reports, Tabular Reports, Matrix Reports, Sub Reports, and Ad - hoc Reports.
- Expertise in Creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
- Extensive experience in deploying complex packages from development to production environment using proper package configuration.
- Experience in working with Normalization/De-normalization, data design methodology and building Referential Integrity for teh relational Database Model implementing as per business requirement.
- Experience in Dimensional Modeling, applying Kimball’s methodology, designing Star Schema / Snowflake Schema, FACT and Dimensional tables.
- Working knowledge in Creating Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, User Profiles using Transact SQL.
- Knowledge on Tableau Reporting tool.
PROFESSIONAL EXPERIENCE
Confidential
Sr. SQL/SSRS/SSAS Developer
Responsibilities:
- Involved in gathering business requirement and technical specifications and design documents for developing teh data warehouse.
- Experienced on writing complex queries, performance tuning and optimized SQL queries using D-SQL T-SQL, SQL Profiler in SQL Server 2012/2014/2016.
- Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
- Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
- Created and Implemented triggers in T-SQL to facilitate consistent data entry into teh database.
- Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
- Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
- Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling.
- 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.
- Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
- Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and also created Parameterized Reports which consist of report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
- Designed and architected Report Layout including both simple and complex report using SSRS 2005.
- Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.
- Created reports on both cascading and standard parameters.
- Created calculated measures using MDX implementing business requirement
- Experienced working on Star and Snowflake Schemas and used teh fact and dimension tables to build teh cubes, perform processing and deployed them to SSAS database.
- Expertise in OLAP and OLTP and Datawarehouse Concepts.
- Worked on PowerBI in creating dashboards and reports and visualizing data.
- Creating Gateway and publishing reports to users according to teh client requirement.
- Used Microsoft Power BI Power 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.
- Implemented Row level Security to restrict teh access to users.
- Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
Environment: Windows server 2007, MS SQL Server-2012/14/16 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Office-2007, MS Excel, PowerBI.
Confidential, New York, NY
SQL, SSIS, SSRS and Power BI Developer
Responsibilities:
- Vital role for ETL operations deeply into teh required stages of loading/extracting from various sources like SAP HANA and SQL Server.
- Created SSIS packages and deployed to catalog using 2016 server
- Creation of configurations for ETL packages to handle Multi server deployment.
- Involved in deployment using different Configurations like XML, Environment and SQL Server Configurations, scheduling teh process with teh SQL Server Agent.
- Good exposure in trouble shooting issues & optimization steps for teh packages.
- Creating teh reports as per client’s requirement in teh form of table, matrix, charts.
- Experience in generating drill though reports, parameterized reports, linked reports, sub reports, matrix in SSRS 2016 based on client requirement.
- Scope for teh REPORT MANAGER AND REPORT BUILDER to do report publishing activities.
- Familiar with complete data warehousing SDLC development life cycle.
- Familiar with creating SQL SERVER DATABASE objects like tables, procedures, views and T-SQL programming.
- Responsible for design methodology and project documentation.
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
- Connecting to data sources, importing data and transforming data for Business Intelligence.
- Excellent in analytical thinking for translating data into informative visuals and reports.
- Able to implement row level security on data and understand application security layer models in Power BI.
- Able to develop tabular and multidimensional models dat are compatible with warehouse standards.
- Adept in developing, publishing and scheduling Power BI reports as per teh business requirements.
- Actively involved in creating High-level Architecture documents, ETL-SPEC, mapping documents, Unit test case and peer review documents with teh project specifications.
- Good team player, strong interpersonal and communication skills combined with self-motivation, ability to think outside teh box.
- Good knowledge on version controls tools like TFS (Team foundation server) and ticketing tools like JIRA.
Environment: Windows 10, MS SQL Server 2019, SQL Server Integration Services (SSIS-2019), SSRS, SQL Query Tuning, Microsoft Excel, SQL Server Agent. Power BI.
Confidential, Virginia
SQL with SSIS/SSRS Developer
Responsibilities:
- Created and implemented complex Stored Procedures and Triggers, Functions, Indexes, Constraints, Tables, Views and Joins using T-SQL to provide definition, structure, maintain data efficiently for applications and to automate tasks.
- Reviewed data and classified teh tables/measures functions by using multiple queries, views and procedures.
- Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects. Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
- Loading data from various sources like, flat files, MS Access and Excel, to SQL Server database Using SSIS Package.
- Build high performance data integration solutions, including extraction, transformation, and load (ETL) packages.
- Using SSRS to deliver enterprise, Web-enabled reporting reports dat draw content from a variety of data sources.
- Deployed SSRS Reports in SharePoint for web based access for multiple end users.
- Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Restricted data for particular users using Row level security and User filters.
- Developed Tableau visualizations and dashboards using Tableau Desktop.
- Developed Tableau workbooks from multiple data sources using Data Blending.
- Hands on experience in Unit Test cases, Functional Testing, Manual Testing, Performance and Integration Testing.
- Experience in Database Backup, Recovery and Disaster Recovery procedures.
- Experience in ETL processes involving migrations and in sync processes between two databases.
Environment: Windows XP, MS SQL Server 2019, Query Analyzer, Enterprise Manager, SQL Server Integration Services (SSIS-2019), SQL Query Tuning, CI/CD, Microsoft Excel, SQL Server Agent. Tableau, MS Access, Teradata, Azure and AWS.
Confidential, Mooresville, NC
SQL Server BI Developer (SSRS/SSIS)
Responsibilities:
- Designing and Developed queries using Microsoft visual studio 2008 R2.
- Created Database Diagram using third party tool Erwin in beginning of teh project, identify database entities and attributes, relation among teh entities tables and enforced teh referential integrity constraints.
- Created database and database objects like tables, stored procedures, views, triggers, rules, defaults user defined data types and functions with T-SQL to facilitate data consistency.
- Created Logical & Physical Data Modes using Entity Relationship Diagrams.
- Created multiple hierarchical aggregates for faster performance.
- Created perspective of teh cube to simplify teh process of browsing for teh end users.
- Supported all production operation activities with focus on integration and development of new and existing products and services., control, and automation opportunity to improve overall access to information.
- Created report snapshots to improve teh performance of SSRS.
- Created ETL metadata reports using SSRS, reports include like execution times for teh SSIS packages, failure reports with error description.
- Involved in writing MDX Scripts for teh OLAP CUBES and Developed multidimensional Objects using MS Analysis.
- Reviewed teh Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all teh requirements are fully covered.
- Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
- Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
- Administrated teh created reports by assigning permission to teh valid user for executing teh reports.
Environment: UNIX, SSMS, 2017, 2019, SSIS 2019, Power Builder 12, SSRS 2019, Oracle 9i, SQL & PL/SSAS. Visual Studio 2019, SQL Query Tuning, CI/CD
Confidential
SQL Developer with SSIS/SSRS
Responsibilities:
- Responsible for updating and staging teh dimensional databases as well as rebuild teh Dimensions using SSIS.
- Used C# scripts in SSIS script task to run custom scripts in package flow.
- Implemented package configuration in SSIS packages dat transferring packages from one environment to other.
- Designed database schema contains over 30 tables such as users, groups, threads and posts.
- Configure TFS environment such dat SQL Reporting and SharePoint interact with each other.
- Performed Unit Testing of ETL Programs to support QA on End-to-End testing.
- Identified and involved in creation of dimension, fact tables and designed teh data warehouse STAR and SNOWFLAKE schema.
- Ability to work independently as well as work with teams having varying backgrounds on complex issues.
- Designed and Implemented Tables, CTE, Views, Functions, Stored Procedures and Triggers in SQL Server 2016
- Regression testing was performed after each new build of teh application.
- Involved in teh process of Defect logging and Defect follow up in Team Track.
Environment: SQL Server 2014,Autosys,TFS tracker &, SharePoint, SSIS 2014, Visual Studio 2014,SSRS 2014, T-SQL, Visio 2015,Enterprise Manager, Windows Server.
Confidential, Columbia, SC
BI Developer
Responsibilities:
- Worked on teh Online shopping system and several applications like Customer Catalogs, Customer Masters, and Generics etc. to retrieve teh information from respective systems. Developed various application and report using T-SQL and SSRS.
- Involve in analyzing existing complex systems to understand and document data elements, relationships, data flow, dependencies and related interfaces.
- Develop and maintain SQL Server Integration Service packages (SSIS).
- Develop procedures and scripts for data migration.
- Create views, tables, and indexes, Performance Tuning and Query optimization.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
- Modified teh existing SSIS packages to meet teh changes specified by teh users creating dashboards volume reports, operating summaries and presentations and graphs SSRS Integration to Power BI
Environment: SQL Server 2012, MS Excel 2013, MS Access 2013, MS SQL Query Analyzer, SQL Profiler, SSRS, Power BI
Confidential, Cleveland, OH
SQL Server BI Developer
Responsibilities:
- Developed T-SQL queries and Manage Large Scale Stored Procedures with multiple parameters to created data set for teh reports and tuning to reduce execution time and Work in Stored Procedures to prevent SQL Injection.
- Created several SSIS Packages to load data from various data sources including and created complex SSIS packages using various transformations and used various Control Flow and Data Flow items from Toolbox.
- Perform Error handing and version log using Event Handler.
- Work with EVENT MANAGER to manage teh whole scheduling reports and manage recipient scheduling.
- Used Lookups Transformation to get teh data from data sets.
- Provided technical assistance for delivery of bug fixes and improvements to Progress and Open Edge applications.
- Created Stored Procedures to retrieve data from CDC enabled tables to load all deltas into destinations.
- Active Directory Basic operation and integration with related application for directory entity.
- Manage Group, Role, Organizational Unit for users in Active directory.
Environment: SQL Server 2012, SQL Server 2012, SSDT 2014 (SSIS.SSRS), Control-M Manager, SharePoint.