We provide IT Staff Augmentation Services!

Msbi Lead Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Total 9 yr working Experience, where MS SQL Server Developer with around 6 years of strong experience in Finance, Retail, and Insurance domains.
  • Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
  • Extensive experience in Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
  • Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
  • Proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
  • Expertise in developing and designing Reports using SSRS.
  • Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2 and MS Access.
  • Conversant in working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ DB2 databases
  • Extract data from Parallel Data Warehouse to SQL servers to consultant teams for investigational project.
  • Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services.
  • Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
  • Highly experienced in writing Parameterized Queries for generating SSRS, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2016/2014/2012/2008 R 2/2008/2005.
  • Good understanding of JAVA, .Net C, C++ language
  • Experience in creating various views and making the data more visualized.
  • Strong leadership, communication, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS

  • MS SQL Server 2016/2014/2012/2008 R2/2008
  • MS SQL Server Integration Service (SSIS)
  • MS SQL Reporting Services (SSRS)
  • Microsoft Access 2007/8.0
  • Microsoft Excel
  • Outlook
  • MS SQL Profiler
  • SQL Query Analyzer
  • Database engine tuning advisor
  • T-SQL
  • MS Visio 2005/2010
  • Team Foundation Server (TFS)
  • Git
  • HP ALM
  • Jira
  • Erwin Data Modeler

PROFESSIONAL EXPERIENCE

Confidential

MSBI Lead

Responsibilities:

  • Work on billing and payment system for various clients to create client specific payment rules.
  • Create and update stored procedure in the billing system to implement billing forms.
  • Work on NTS System to validate the billing updates made in SQL/Backend.
  • Create on demand reports for clients using SSRS.
  • Good knowledge of mortgage process and fees like ESCROW, Non-ESCROW, Delinquent, etc.
  • Support production deployments and UAT.
  • Create test scripts and test data for business validation.
  • Wrote different Validation Scripts to check the accuracy of data.
  • Work with project managers, business owners, business analysts and database users to design, build and maintain database objects to implement business functionalities.
  • Write Joins and sub-queries for complex queries involving multiple tables from different database.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for SSRS reports. Implemented different types of constraints on tables for consistency.
  • Create, modify, and maintain database objects.
  • Wrote different Validation Scripts to check the accuracy of data. Developed and deployed SSIS packages for ETL from various sources to staging and from staging to production using Data Conversion, Derive Column, Script Task, Condition Split, for each loop container, and error handling.
  • Generated Custom ETL scripts using SSIS and develops unit test SSIS load processes for performance check.
  • Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
  • Modify and maintain database objects. Database objects include tables/columns, views, stored procedure, functions, packages, and database scripts.
  • Using SSRS Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
  • Various report models with multiple model objects, source fields and expressions.
  • Work independently or in conjunction with other developers as the work requires.
  • Work on JIRA tool to track work items and issues.

Confidential

Senior SQL Server /MSBI Lead

Responsibilities:

  • Work with project managers, business owners, business analysts and database users to design, build and maintain database objects to implement business functionalities.
  • Writing Joins and sub-queries for complex queries involving multiple tables from different database.
  • Wrote different Validation Scripts to check the accuracy of data.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Experience with Visual Studio TFS (Team Foundation Server) or VSTS (Visual Studio Team Services)
  • Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for SSRS reports. Implemented different types of constraints on tables for consistency.
  • Create, modify and maintain database objects.
  • Modify and maintain database objects. Database objects include tables/columns, views, stored procedure, functions, packages, and database scripts.
  • Ensure design and development consider all aspects of technical requirements - including data quality, performance, scalability, architecture so that software is of high quality.
  • Ensure design and development consider all aspects of non-functional requirements - including customer experience, usability, maintainability, security & operations - so that software is fit for purpose.
  • Develops mapping and data processing procedures to import data from various data sources and populate the client database Generated Custom ETL scripts using SSIS and develops unit test SSIS load processes for performance check.
  • Good knowledge of Data modeling, Star schema concepts.
  • Good knowledge Data Profiling, Data, Migration
  • Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
  • Ensure source code and version control.
  • Using SSRS Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment. various report models with multiple model objects, source fields and expressions.
  • Work independently or in conjunction with other developers as the work requires.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Participated in daily agile scrum meetings to understand business logic and requirements of the company.
  • Involving in complete software development life cycle (SDLC) like Requirement Analysis and Specification, technical design and Implementation.
  • Experience with VSTS, code/configuration management, and pipeline setup
  • Writing Joins and sub-queries for complex queries involving multiple tables from different database.
  • Wrote different Validation Scripts to check the accuracy of data. Developed and deployed SSIS packages for ETL from various sources to staging and from staging to production using Data Conversion, Derive Column, Script Task, Condition Split, for each loop container, and error handling.
  • Generated Custom ETL scripts using SSIS and develops unit test SSIS load processes for performance check.
  • Successfully deployed SSIS Package into Production environment and used Package configuration to export various package properties to make package environment independent.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Good Understanding of Java, and C,C++ language .
  • Extract data from Parallel Data Warehouse to SQL servers to consultant teams for investigational project.
  • Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T-SQL code to implement business rules for SSRS reports. Implemented different types of constraints on tables for consistency.
  • Generated SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Creating reports subscriptions using SSRS to send data in PDF, Word and Excel format on Daily, weekly, monthly and yearly basis via emails and sending to shared folders.
  • Involved in designing and deploying Tabular, Matrix, List and Chart reports with Drill Down, Drop down menu option, Parameterized and Sub reports.
  • Responsible for designing, developing and deploying Drill through, conditional and dynamic reports.
  • Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multitasking.
  • Designing, deploying, scheduling and maintaining various SSRS Reports in SQL Server in test, staging and production environments.

We'd love your feedback!