We provide IT Staff Augmentation Services!

Sr. Sql Bi Developer Resume

5.00/5 (Submit Your Rating)

San Ramon, CA

SUMMARY:

  • MS Certified IT Professional with 8+ years of expertise in data modeling, database design, programming, development & implementation of Client - Server Applications & Database systems using MS SQL Server 2012, 2008, 2005.
  • Extensive experience in using Microsoft BI Studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
  • Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
  • Highly experienced as MYSQL Developer with proven record of strong database.
  • Good knowledge in Data integration using ETL tools like SSIS (Microsoft BIDS) and Informatica.
  • 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.

TECHNICAL SKILLS:

  • Microsoft SQL Server 2012/2014
  • Periscope Dashboards
  • PL/SQL
  • Agile Methodology
  • SQL Server Integration Services 2012(SSIS)
  • SQL Reporting Services 2012 (SSRS)
  • MYSQL Workbench
  • SQL Server Analysis services 2012 (SSAS)
  • Crystals Reports 2011
  • Microsoft Excel 2016

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon, CA

Sr. SQL BI Developer

Roles & Responsibilities:

  • Involved in daily scrum meeting and effectively followed Agile Methodology
  • Extensively worked on architecture, software development, Project management and debugging.
  • Involved in debugging issues between various browsers and resolving them
  • Worked with XML, Web logic, JDeveloper, ODSI, OSB to build service oriented architecture
  • Configured and maintained MySQL database servers.
  • Worked on Development and deployment of MS SQL Server Integration Services packages.
  • Configured, tuned and maintained MySQL Server database servers.
  • Developed the service oriented architecture using Model, Overlay builders as per the requirement
  • Worked with some documentation required for development of the application.
  • Developed the service oriented architecture using Model, Overlay builders as per the requirement
  • Done testing using TDP for developed stories.
  • Worked on creating visualizations reports using Power BI
  • Developed reports with SSRS and Power BI
  • Worked on Installation, configuration and maintenance of SQL Server.
  • Worked on query optimization & performance tuning (used SQL Profiler, Execution Plan, Performance Monitor)
  • Applied patches and service packs to keep the database at current patch level.
  • Responsible for General DBA, Query Performance tuning.
  • Worked on Backup recovery schedules, Backup scripts.
  • Install, configure and upgrade MS SQL Server.
  • Developed dashboards and key performance Indicators(KPI) with Power BI and deployed Dashboards onto share point
  • Involved in supporting the backend database data of ISAAC Project.
  • Extensively involved in ETL Processes development, support and
  • Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
  • Wrote T- SQL code/Stored procedures to create datasets for SSRS reports.
  • Created Views to store aggregated values for reporting purpose.
  • Developed ETL Packages using SQL Server 2012 Integration Services to populate data from different sources, for example flat files/SQL/Oracle Server to the Staging Database and then into the Data Warehouse.
  • Performed testing using TDP for developed stories.
  • Coordinated with other product lines and Software Quality Assurance (SQA) team.
  • Worked on some part of the manual testing of the stories which developed.
  • Performed the Creation, manipulation and supporting the SQL Server databases.
Confidential, Irvine, CA

SQL Server BI Developer with Power BI

Roles & Responsibilities:

  • Installed SQL Server 2012 on Development and Production Servers, Setting up databases, users, roles and permissions.
  • Created Dashboards using Power Bi
  • Used Index tuning wizard to redesign and created the indexes for better performance.
  • Reviewed DB scripts before releasing them into production.
  • Installation, configuration and maintenance of SQL server 2012.
  • Troubleshoot problems using SQL Profiler.
  • Used system monitor to find bottlenecks in CPU, disk I/O and memory devices and improved the performance.
  • Worked with business owners and analysts to define and implement new requirements for a more scalable and stable data processing application.
  • Wrote Stored Procedures for both Online and Batch requests handling business logic and Functionality of Various modules.
  • Involved in writing various DB Objects like User defined functions, Views, Instead of triggers, Usage of Indexes for accomplishing various tasks.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
  • Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
  • Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party Tools.
  • Configured, Installed and Administered Reporting Services 2008/2012.
  • Handled all Report requests for Crystal Reports/SSRS and/or SQL based reporting needs.
  • Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
  • Worked on SSRS to generate hierarchical reports, drill down and drill through reports and tested using Management Studio in SQL server 2012/2014.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Modified numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report)
  • Created various Dashboards for business users using Periscope Dashboard
  • Created Dashboards for data Inventory Locations for Business Partners
  • Created many reports using QlikView
  • Worked as a QlikView Technical Consultant for a wide variety of business applications.
  • Converted query based crystal Report s to query/stored procedure based SSRS Reports

Environment: Microsoft SQL Server 2012/2014, Periscope Dashboards, PL/SQL, Agile Methodology, SQL Server Integration Services 2012(SSIS), SQL Reporting Services 2012 (SSRS), MYSQL Workbench, SQL Server Analysis services 2012 (SSAS), Crystals Reports 2011, Microsoft Excel 2016

Confidential, Orlando, FL

SSIS, SSRS and MS SQL Developer

Roles & Responsibilities:

  • Understanding the report design Requirements and Constraints.
  • Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Configured and Maintained MYSQL Servers
  • Worked on advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
  • Design and implementation of Security Model, Policies and Procedures.
  • Performed MYSQL query plans and making sure each and every query is using appropriate useful Indexes
  • Worked on creating and modifying T-SQL Stored Procedures/Triggers for validating the integrity
  • Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
  • Rebuilt Indexes and Tables as part of performance tuning exercise.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
  • Created database objects like Pivot Tables
  • Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Promoted RDLs to Reporting Service Server (SSRS).
  • Created Adhoc reports and data exploration using Power View.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Defined appropriate measure groups and KPIs & deployed cubes

Environment: MS SQL Server Management Studio 2008/2005, PL/SQL, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), Agile, MYSQL Workbench, MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe

Confidential, NYC, NY

SSIS, SSRS and MS SQL Developer

Roles & Responsibilities:

  • Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Involved in creating and updating Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
  • Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
  • Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
  • Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
  • Used Script task for Data Flow and Error Handling in SSIS.
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2008.
  • Wrote sub reports and parameterized Queries for generating reports in SSRS 2008.
  • Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients.
  • Reviewed and developed data models and database designs with development teams.
  • Interacted with the Business Admin and gather the requirements and analyzed them.
  • Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2008.

Environment: MS SQL Server 2005, 2008 R2, 2012, Windows 7 Enterprise Edition, SQL Server Management Studio, Business Intelligence Development Studio (BIDS) 2008, Agile, Microsoft Visio, MS Visual Studio

Confidential, NYC, NY

MS SQL Developer

Roles & Responsibilities:

  • Created Store Procedures to transform the data and worked extensively in T-SQL for various needs of transformations while loading the data.
  • Used SQL Server Profiler to trace the slow running queries and the server activity.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Used various SSIS tasks such as Conditional Split, Derived Column, Data Conversion, Fuzzy lookup, merge, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Imported and Exported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
  • Automated the SSIS jobs and email alerts using SQL server agent job for daily, weekly and monthly loads.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
  • Used reporting objects like Tabular, Matrix, Sub report, Charts, Parameterized and Cascading parameterized reports using SSRS-2008.

Environment: Microsoft SQL Server 2008 R2, SSIS, SSRS, SQL Server Profiler, UNIX, Perl, MS Excel, Edit plus, WordPad, PL/SQL

Confidential, Dublin, OH

MS SQL, SSIS, SSAS and SSRS Developer

Roles & Responsibilities:

  • Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views and Queries with best execution plan
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into the Staging Data base.
  • Created projects to transfer data from MS Excel to SQL Server in SSIS.
  • Extensively worked in ETL and data integration in developing ETL mappings and scripts.
  • Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
  • Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
  • Built SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Created Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
  • Worked on SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
  • Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
  • Worked with DCL, DDL, DML Scripts and established relationships between tables using Primary Keys & Foreign Keys.
  • Created and managed Indexes and optimized queries using query execution plan.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Environment: MS SQL Server 2008 R2, Windows 2003, SQL Server Management Studio, Business Intelligence Development Studio (BIDS) 2008

Confidential, Chantilly, VA

MS SQL, SSIS, SSAS and SSRS Developer

Roles & Responsibilities:

  • Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
  • Updated Clustered and Non Clustered Indexes to keep up the SQL Server Performance.
  • Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).
  • Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
  • Worked on control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
  • Used Script task for Data Flow and Error Handling in SSIS.
  • Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients
  • Extensively worked in migrating office writer reports to SSRS-2008.
  • Participated in Databases Architecture and data modeling design.
  • Interacted with the Business Admin and gather the requirements and analyzed them.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Source Safe, MS Excel, Performance Point Server 2007

Confidential

MS SQL Server Developer

Roles & Responsibilities:

  • Effectively 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
  • Rebuilt Indexes and Tables as part of Performance Tuning Exercise
  • Involved in performing database Backup and Recovery
  • Worked on Documentation using MS word
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Tuned and Optimized SQL Queries using Execution Plan and SQL Profiler

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler

We'd love your feedback!