Sr. Sql Server Bi Developer Resume
Cleveland, OhiO
SUMMARY
- 5+years of strong experience with demonstrated success in the Database design, development and deployment of large - scale enterprise applications.
- Expert in MS SQL Server 2012/2008R 2/2008/2005/2000 suite of products like SSRS, SSAS, and SSIS.
- Good knowledge in Data integration using ETL tools like SSIS (Microsoft BIDS).
- Extensive knowledge in T-SQL queries (DDL and DML).
- Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/ 2005/2008/2008 R2/2012.
- Good knowledge in healthcare domain claim adjudication rules and provider matching and member matching rules.
- Experience in healthcare applications like FACETS data model and FACETS online claim processing.
- Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
- Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
- Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
- Extensive knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
- Created and managed Indexes and optimized queries using query execution plan.
- Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
- Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
- Experience in using T-SQL in SQL Server 2000/ 2005/2008/2008 R2 platform
- Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
- Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
- Experience in using Try Catch block for error handling in SQL introduced in SQL Server 2005.
- Hands on 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).
- Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports, Matrix reports and Charts.
- Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
- Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
- Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
- Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms
- Extensive knowledge in ETL Process &Progressive knowledge in using DTS/ETL/SSIS utilities
- Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
- Involved in migration of DTS/ETL Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, DB2 to MS SQL Server by using Import Export Wizard, DTS/ETL SSIS, BCP & Bulk Insert utilities
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow moving dimensions etc and created various user roles.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
- Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
- Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
- Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.
TECHNICAL SKILLS
SQL Server/BI Tools: SQL Profiler, Query Analyzer,BIDS,Export&Import (DTS), SQL Server Reporting Services (SSRS)SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS)
Databases: MS SQL Server2012/2008R 2/2008/2005/2000 , MS Access
Languages: C,TSQL,VisualBasic6.0,C#,XML,HTML,ASP(.NET),C++,PL/SQL.
Tools: Visual Studio 2005/2008/2010 , Erwin 7.2, Tableau
Application Packages: MS Office, MOSS 2007, PPS 2007
Architecture: RDBMS, OLAP, OLTP
Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003
PROFESSIONAL EXPERIENCE
Confidential, Cleveland, Ohio
Sr. SQL Server BI Developer
Responsibilities:
- Developed stored procedures and adding/changing tables for data load and transformation and data extraction.
- Performed performance tuning to optimize SQL queries using query analyzer.
- Implemented custom error handling in SQL stored procedures using Try catch block, transactions and RAISERROR.
- Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
- Developed SSIS packages (.dtsx files) to ETL data to data warehouse databases, data mart databases.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to users.
- Worked in data extraction, transformation and loading into staging tables validate the records on staging tables and load into data mart.
- Implemented different types of constraints on tables.
- Created and deployed reports using SQL Server Reporting Services.
- Managed index, statistics and optimizing queries by using execution plan for tuning the database.
- Performed Unit Testing and system integration testing on the completion of development and deploying into production environment.
- Documented of all processes involved in maintaining the database for future reference.
Environment: MS SQL Server 2012/2008/2008 R2, OLTP, Visual Studio 2008/2010,Windows 2007, T-SQL, SSIS
Confidential, Denver, Colorado
Sr. SQL Server BI Developer
Responsibilities:
- Worked extensively on FACETS 5.01 data base and gained good knowledge on FACETS data model.
- Created data mappings to load and transform the data from XML, Flat files, and CSV files. Extracted data into delimited files and fixed width files
- Developed ETL packages using multiple data sources and data destinations (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS transformations.
- Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
- Develops an expertise in provider data, reporting, fee schedules, contracts, capitation, vendor setup and member assignments in the QNXT claims platform.
- Coordinate with QNXT implementation analyst on validating provider rates and reimbursement methodologies.
- Worked on EDI 837 and 835 files.
- Worked on custom claim tables data modeling.
- Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
- Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
- Extensively worked with SVN tortoise and TFS to keep track of all changes made in the project.
- Provided documentation about database/data warehouse structures and Updated functional specification, technical design documents and Unit test cases.
- Created and deployed reports using SQL Server Reporting Services 2008R2 (SSRS).
- Created Parameterized, Ad hoc and drill down reports using Report Designer.
- Used various report items like tables, sub report and charts to develop the reports in SSRS 2008R2.
Environment: FACETS 5.01, MS SQL Server 2012/2008 R2, OLAP, ROLAP, Visual Studio 2008/2010, Windows 2007, T-SQL, XML, SSRS, SSIS
ConfidentialBI/SQL Developer
Responsibilities:
- Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
- Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
- Creating dashboards for different departments.
- Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month.
- Bulk data migration using SSIS from flat files.
- Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
- Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
- Created different Parameterized Reports with SSIS 2005 which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
- Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
- 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. Linked reports are created in the Report Server to reduce the repetition the reports.
- Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
Environment: MS SQL Server 2008, Sybase, Excel, TSQL, Microsoft Visual Studio 2008,SQL Reporting Services, SQL integration services, C#, VB.Net.
Confidential
SQL Server Developer
Responsibilities:
- Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
- Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
- Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
- Implemented Exceptional Handling
- Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
- Creating and automating the regular Jobs.
- Tuned and Optimized SQL Queries using Execution Plan and Profiler
- Rebuilding Indexes and Tables as part of Performance Tuning Exercise
- Involved in performing database Backup and Recovery
- Worked on Documentation using MS word
Environment: Windows 2000 Server, SQL Server 2000,Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.
