We provide IT Staff Augmentation Services!

Ms Sql Server Developer/ssis/ssas/ssrs Resume

CA

SUMMARY

  • An accomplished SQL Server and MSBI developer, having 7 years of industrial experience in designing, developing and implementing database solutions of SQL Server 2005/2008/2008 R 2/2012/2014/2016 in Healthcare and Financial domains.
  • Extensive experience in Database Design, Data Modeling, T - SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.
  • Expertise in firing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures and cursors.
  • Demonstrated expertise in MS SQL Server and Microsoft Business Intelligence (MS-BI) tools like SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services) and T-SQL scripts.
  • Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring.
  • Experience in query optimization, running DB Consistency Checks using DBCC commands.
  • Expertise in troubleshooting SQL issues by using SQL Profiler.
  • Expertise in creating SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
  • Experience in integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
  • Organized the task flow using For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
  • Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
  • Expertise in Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Thorough understanding of Kimball’s’ theory, KPIs and Perspectives, SQL Server 2008 Architecture.
  • 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).
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Expertise in creating various types of reports using Cascading parameters, Complex drill down and drill through reports and charts in SQL Server Reporting Services (SSRS) based on relational and OLTP databases.
  • Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).
  • Created Power BI Dashboards (Power View, Power Query, Power Maps) and integrated them to share point.
  • Used DAX expressions in MS Power BI Desktop.
  • Involved in Trouble Shooting, Performance tuning SQL Server and resolving issues.
  • Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
  • Expertise in OLTP/OLAP system study, Good experience building Star schema and Snowflake schema depending on the business data requirements.
  • Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012/2008 R2/2008, DB2, MS Access, ORACLE.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, 10 BI tools (Report Studio, Analysis Studio, Query Studio,).

ETL-Tools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SQL Server Reporting services (SSRS), Power BI, Informatica

RDBMS: SQL Server 2005/2008R 2/2012/2014/2016 , Oracle 11g/10/9i.

Programming: T-SQL, PL/SQL, Dynamic SQL, MDX, C# .NET, XML, Java.

Operating Systems: Windows 10/8/7/Vista/XP/2008/2003, Windows 9x, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, CA

MS SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

  • Involved in a team of developers that successfully completed a complex data conversion project that was designed to migrate millions of records to a new system (QNXT).
  • Responsible for fixing hundreds of critical defects addressed during data conversion.
  • Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
  • Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers per business requirement.
  • Executed SQL conversion pre-validation and post-validation scripts to avoid data loss.
  • Created business reports by joining multiple tables from multiples database using complex SQL queries.
  • Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures, functions, and Complex SQL.
  • Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Created checkpoints, configuration files in SSIS packages and Deployed SSIS packages with minimal changes using XML configuration file.
  • Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services (SSAS).
  • Used to extract all the Eligibility Files like 837, 835, 999 and 834 from Facets and then used to migrate the data as per client requirement.
  • Worked on Medical Claims in process documentation, analysis and implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side, Medicaid, & Medicare.
  • Built OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
  • Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
  • Used to extract the data from plan partners or vendors and build SSIS packages and SSRS reports.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
  • Data migration and Data validation/Testing through VBA modules between MS Access and MS Excel.
  • Created parameter driven reports in Access and Excel running thru Access VBA front-end
  • Performed data profiling in the source systems that are required for RML System.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Detailed knowledge of Health Edge's, other transaction system (Facets, QNXT, etc.).
  • Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
  • Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.
  • Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).
  • Used DAX expressions in MS Power BI Desktop.
  • Hands-on experience with Agile/Scrum methodologies, playing the role of Scrum Master effectively.
  • Implemented SCRUM/Agile methodologies with enterprise-level application for development of projects using PMI-ACP, CSM.

Environment: Microsoft SQL Server 2016, MS Access, ETL Packages(SSIS), QNXT, SSRS, SQL Server Analysis Services(SSAS), .Net, VB.Net, Visual Studio, Team Foundation Server (TFS), Power BI, T-SQL, Business Objects XIR2.

Confidential, Irving, TX

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Created complex Stored Procedures and Functions to support the front-end application.
  • Created database triggers to implement business requirements.
  • Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.
  • Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
  • Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Server
  • Created SSIS package to load multilevel XML data into SQL SERVER database.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Designed SSIS packages to export and import data from SQL Server to MS Access, text files and Excel files. Used SSIS transformation for Data Cleansing to remove unnecessary data.
  • Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.
  • Created report models for ad-hoc reports using SSRS 2012.
  • Designed and created Report templates, bar graphs, pie charts based on the financial data.
  • Generated periodic reports based on the statistical analysis of the data using SSRS 2012.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and generated reports using Crystal Reports.
  • Responsible for managing daily activities of department including compliance initiatives, group practice agreements and claim strategies.
  • Applied security features of Business Objects like row level, report level & object level security in the universe to make the sensitive data secure.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports .
  • Use business tools to target and select optimal populations for chart review; partnership with Nurse Chart Review Coordinator as well as Chart Review Coordinator.
  • Used to resolve on-going maintenance issues and bug fixes ; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
  • Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
  • Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.

Environment: MS SQL Server 2014, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, ETL, MS Visual Studio 2015, Composite Studio 6.1, Oracle 12c, Team Foundation Server (TFS).

Confidential, Lincoln, RI

SQL Server Developer/ DBA, SSRS/ SSIS/ SSAS Developer

Responsibilities:

  • Written stored procedures to populate final database tables from staging tables and clean inaccurate data.
  • Created and maintained versions of SQL Scripts for Tables, Indexes, Constraints, and Views etc. for the entire project.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
  • Providing solutions to improve the existing processes and production support for various batch processes and created the schedule for newly incorporated batch programs and processes.
  • Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
  • Performed financial risk stress testing and integration of model outputs for Dodd-Frank Act Stress Testing (DFAST) Comprehensive Capital Analysis and Review (CCAR).
  • Assisted (via remote) with payroll, tax, and account processing.
  • Developed several sales, marketing, finance reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI’s.
  • Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions Architecture for SQL Server Reporting Services solution.
  • Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Developed stored procedure driven reports, building custom application on reports, formula Writing/editing in reports, Report Administration and performance tuning of reports.
  • Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
  • Actively participated in User Acceptance Testing and Debugging of the system.

Environment: SQL SERVER 2014, Microsoft Reporting Services, Toad, T-SQL, Oracle 10g, Visual Source Safe (VSS), WIN NT, Erwin and SQL Server Integration Services.

Confidential, Dayton, OH

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse, which encompasses Column Mapping, Data dictionary and Metadata.
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions.
  • Created and formatted the report layout for end users.
  • Deployment of the developed reports on to the server for the end users.
  • Involved in query optimizations and tested applications for performance, data integrity using SQL Profiler.
  • Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
  • Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
  • Designed and created views for security purposes, implemented rules, defaults, data types.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Worked on all types of report types like tables, matrix, charts, sub reports etc.
  • Created Linked reports, Ad-hoc reports etc. based on the requirement. Created Linked reports in the Report Server to reduce the repetition of reports.
  • Designed index, statistics and optimized queries by using execution plan for performance tuning.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, (SSRS)
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Created report models for ad-hoc reports using SSRS 2012.
  • Monitored Performance with SQL Profiler, Perfmon and using a monitoring tool called DB Artisan.

Environment: MS SQL Server 2014, SSIS, SSRS, T-SQL, Windows, DB Artisan.

Hire Now