We provide IT Staff Augmentation Services!

Senior Msbi Developer Resume

Austin, TX

SUMMARY:

  • Over 8 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2005/2008 R2 and 2012 in Production, QA and Development Environments.
  • Strong experience with T - SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
  • Ability to work in all stages of System Development Life Cycle (SDLC).
  • Experience in Error handling and debugging coding issues and troubleshoot production problems.
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
  • Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL Server 2005, 2008 R2/2012 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
  • Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
  • Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
  • Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
  • Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
  • Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
  • Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Experience in .NET/C# application development environment to use SQL Server Databases.
  • Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
  • Experience in working with Database setup, partitions and maintenance.
  • Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
  • Strong knowledge on claim management process, well versed with Medicaid and Medicare services, HL7 message validation, ICD9, Electronic Health Records and Electronic Medical Records.
  • Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
  • Experience in managing large data sets on MS Excel 2013
  • Provided application security support for SQL applications with ADO.NET
  • Skilled in design of logical and physical data modeling using Erwin data modeling tool.
  • Worked with Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS:

Tools &Packages: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0HP QC, ProClarity 6.2,SharePoint 2007, Team Foundation Server

BI Tools: SSIS, SSAS, SSRS.

Databases: MS SQL Server 2000/2005/2008, 2012 MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Austin TX

Senior MSBI Developer

Responsibilities:

  • Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
  • Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.
  • Involved in performance monitoring, tuning and capacity planning.
  • Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
  • Translated business requirements into BI application designs and solutions.
  • Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
  • Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
  • Worked on analysis of the data and develop plan based on the ETL specifications.
  • Designed and Implemented plan for the moving data to various destinations.
  • Created mappings and workflows as per the business requirement.
  • Fine-tuned queries to make the reports run faster, worked on query run time analytics.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Created and maintained data flow diagrams for existing and future ETL processes.
  • Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
  • Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
  • Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.

Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#, SQL Server Analysis Services (SSAS), Microsoft Visual studio 2013

Confidential, Clearfield, UT

Sr. SQL BI Developer

Responsibilities:

  • Worked on Performance Reports of employees in Power BI which was a pilot technology to the company and have been key in helping them introduce the technology.
  • Worked on cascaded reports with multiple parameters and cube source.
  • Wrote complex T-SQL queries, stored procedures to build specific logics.
  • Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
  • Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
  • Implemented advanced features and tools such as script task, lookup, derived columns, condition split, union all, copy column, data conversion as per the business requirements.
  • Worked on group atlas travel project which was one of the critical and new domain of Confidential . Have worked from the scratch of the project and built the application based on all the business rules with direct meetings with the clients.
  • Developed reports using SSRS on statistical data during migration of data.
  • Created analysis and design documents for implementing the client specific requirements.
  • Prepared all the documentation for all the projects.
  • Generated reports in excel files using SSIS for business reviews
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them
  • Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
  • Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
  • Work with different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.
  • Responsible of processing claims data.
  • Worked on scheduling the reports as required using normal and data driven subscriptions.

Environment: SQL Server 2012/2014 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, OLAP, OLTP, MDX, C#, ASP.Net, Redgate, MS Office 2010, Performance Point Server 2007.

Confidential, Milwaukee, WI

Sr. SQL Server/SSIS Developer

Responsibilities:

  • Designed Contract Retention database using SQL Server 2008 technology
  • Designed and developed data models for the data warehouse using star and snowflake schema.
  • Developed data mapping documentation to establish relationships between source and target tables including transformation processes
  • Developed and implemented SSIS 2008 ETL processes to load data from source files to target table
  • Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated and worked with Script Task to perform a custom code.
  • Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
  • Develop DTS script to migrate data from SQL*Server database to Oracle database.
  • Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
  • Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity
  • Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
  • Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
  • Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
  • Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.
  • Created additional ad-hoc reports using MS Access for Operations Director.
  • Received MS Sharepoint 2010 application development training covering Visual Studio 2010, Sharepoint Designer 2010
  • Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also generated reports in different formats such as csv, pdf, rpt & txt etc
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, OLAP, OLTP, MDX, C#, ASP.Net, Data Mart, ETL, MS Office 2010, Performance Point Server 2007.

Confidential, Milwaukee, WI

Sr. SQL Server/SSIS SSRS Developer

Responsibilities:

  • Actively participated in Investors Data related meetings with users, team lead and technical manager to fully understand the requirements of the system.
  • Worked on security master which enriches data from Bloomberg and cleanses the data and run the
  • Securities data thru workflow and approval process and replicates the data to various systems in the firm.
  • Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different Databases.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Created logins, users and configuring permissions and assigning roles to users.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL Queries for improved performance and availability.
  • Created SQL scripts for tuning and scheduling.
  • Worked on programmatically connecting to all the FTP servers to download the files and load into database on daily basis.
  • Experience in downloading files from curl scripts and save them into database using C# loaders.
  • Worked on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
  • Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Converted DTS 2000 to SSIS 2012 for the new Data warehouse
  • Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
  • Involved in design, implementation of SQL Server 2012 in Dev, test and prod environment.
  • Imported and created relation between different data sources and between multiple tables using Pivot table.
  • Involved in securing DB applications with ADO.NET and C# scripting.
  • Involved in DB management for the new DW both in Dev and Prod environments.
  • Performed DB backup, restore and other data base maintenance work.
  • Generated reports using report Builder3.0 that could be used to send information to diverse group of users, clients, and managers.
  • Generated power reports in Excel 2013 for the users to as per user requirements along with BA.
  • Extensive experience in ActiveBatch V9 scheduler. Installed the tool and moved all the scheduled jobs from Prism to ActiveBatch.
  • Scheduled and maintained routine jobs, tasks, and alerts using ActiveBatch. For instance an alert would be sent to the entire Investor team, if any mismatch in the pricing entry by the trading.
  • Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

Environment: SSIS/SQL 2008 R2/2012, ActiveBatch v9, ERWIN 8 Data Modeling tool, XML Schema, FTP, BIDS, Visual Studio2010.

Confidential, Newark, NJ

SQL Server Developer

Responsibilities:

  • Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
  • Involved in database Schema design and development.
  • Migrated Database from SQL Server .
  • Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
  • Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
  • Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
  • Experience in working with Medicare and Medicaid insurance data, Medicare parts A, B, C and D. Insurance pricing, Insurance Claim Adjudication.
  • Participated in ICD 9 to ICD 10 codes mapping sessions as well as status meetings and provided necessary suggestions on challenges.
  • Executed stored procedures using BATCH files.
  • Developed stored procedures and functions for designing various reports.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Used Batch Files to Import Data from other Data Base.
  • Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
  • Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
  • Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
  • Expert in SSIS Deploying and Scheduling
  • Identified and Defined Key Performance Indicators in SSAS 2005/2008.
  • Process SSAS cubes to store data to OLAP databases
  • Integrate SQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
  • Defined report layouts for formatting the report design as per the need.
  • Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Created reports and Dash boards using Microsoft Performance Point service.
  • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
  • In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
  • Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005, MS Visio 2007, TortoiseSVN.

Confidential

SQL Server Developer

Responsibilities:

  • Understand user requirements and Data Model defined and developed by the business analysts and data architects.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Implemented different types of constraints on tables.
  • Designed and applied entity and attributes description and definition for the models.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Extract, Transform and Load source data into respective target tables to build the required data marts.
  • Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Created logging 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.
  • Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Designed SSAS cube to hold summary data for Target dashboards.
  • Developed Cube with Star Schema.
  • Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Responsible for gathering business requirements to create business user reports.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
  • Developed optimal stored procedures and queries to create data sets for reports.
  • Designed and implemented stylish report layouts.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Played a Content Manager role on report server.
  • Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), Great Plains, PL/SQL, C#, VB.Net, ASP.NET, .Net 3.5 SP1, SP2 & 3.0, HTML, IIS, Visual Studio 2008 & 2005, Visual Source Safe, DTS, T-SQL, Oracle 10G, nt scripting, VSS, TFS.

Hire Now