We provide IT Staff Augmentation Services!

Sr. Msbi/sql Server/teradata Developer Resume

Birmingham, AL

SUMMARY:

  • Over 7 years of experience in Design, Implementation, Administration and Support of Business Intelligence, OLTP, OLAP, ETL, Data Warehousing, DBMS and Data Modelling using SQL Server 2008/2008 R 2/2012/2014/2017 and SQL Server Business Intelligence tools - SSIS, SSAS and SSRS.
  • Proficient in gathering Business Requirements from business stakeholders, analyzing documenting System Requirement specification, Functional Requirement specifications and maintaining Requirements.
  • Used various transformations like Sort, Multicast, Union All, Script Component, Conditional Split, Lookup, Merge Join, OLE DB Command and Aggregate to transform data.
  • Created and expanded SSIS packages based on specifications driven by changing business requirements.
  • Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing CUBES using MDX.
  • Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP.
  • Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Bulk Insert, BCP, XML).
  • Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports and drill down reports in SQL 2012 Reporting Services.
  • Experience in developing Custom Report 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).
  • Experienced in Cognos 8.4, with Report Studio, Framework Manager, Query Studio, Analysis Studio, and Cognos Connection.
  • Experience in building Workflow solutions, Data integration and Extract, Transform and Load (ETL) Solutions for Data warehousing using DTS/SSIS packages from multiple sources like Teradata, DB2, Oracle, MS Access, Flat files, SQL Server etc., and loading them into target databases.
  • Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
  • Experienced in writing SQL Query with Temporary Tables, Creating an inline table-valued function, Table Variables And Common Table expressions (CTE).
  • Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
  • Experienced in Teradata utilities like BTEQ, Fast Load, Multi Load, Tpump, Fast Export and Teradata SQL.

TECHNICAL SKILLS:

Programming Skills: T-SQL, C, HTML, CSS, ASP.NET, VB, C#

RDBMS: MS SQL Server 2016/2014/2012/2008/2005/2000 , MS Access, Teradata.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables. SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013 Crystal Reports, AX

Operating Systems: UNIX, LINUX, Windows7 Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Systems familiarity: OLTP,DSS,OLAP,MDX

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, AL

Sr. MSBI/SQL Server/Teradata Developer

Responsibilities:

  • Responsible installation and configuration of SQL Server 2017, SQL Server Management Studio (SSMS), Microsoft Visual Studio 2017 and SQL Server Data Tools.
  • Creating and Modifying Tables, Joins, Sub-Queries, Stored Procedures, Views, Indexes, User-defined Functions and triggers as required.
  • Used T-SQL statements as recursive CTEs and ranking functions to clean duplicated records in database for data clean.
  • Developed SQL queries, optimized stored procedures and sub queries for faster retrieval of data.
  • Created and deployed SSIS packages for data extraction, transformation and loading (ETL) from staging tables to partitioned fact tables with incremental load.
  • Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle database, DB2 and Teradata database, Excel, Flat files into the SQL 2012 Server target staging database.
  • Scheduled ETL packages and automated database tasks by SQL Server Agent.
  • Configured and tuned packages by updating statistics and reorganizing the indexes to improve the server efficiency in SQL Server
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
  • Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
  • Worked with control flow tasks like Containers, Precedence Constraints and Execute SQL Task in SSIS.
  • Created customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and performing data blending in reports.
  • Worked with various transformations in data flow. Some of the transformations include Lookup, OLE DB Command, Multicast, Union All, Conditional Split, Derived Column, Row Count and Aggregate.
  • Worked with parameters, variables, error handling, expressions in SQL server and SSIS. Also, worked on RDBMS concepts for creating database objects such as tables, views, functions, indexes etc.
  • Implemented slowly changing dimensions methodology (Type 2) and developed mappings to keep track of historical data
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Worked on Power BI reports using bar charts, scattered plots, combo charts, doughnut charts, pie charts, funnel charts, KPI, geographical maps, gauge charts using show me functionality.
  • Published reports into Power BI Service and schedule the datasets and dashboards, providing row level security.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), MS SQL Profiler, SSAS, SQL Query Analyzer, SQL Server Index Tuning Wizard, Teradata, MDX, Erwin v4.1, MS Office 2013

Confidential, New York City, NY

Sr. MSBI/SQL Server/SSIS/ETL Developer

Responsibilities:

  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers..
  • Directly involved into requirement gathering and understanding business functions with the end users.
  • Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
  • Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
  • Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
  • Integrated Custom Visuals based on business requirements using Power BI desktop.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Developed complex calculated measures using Data Analysis Expression language (DAX).
  • Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
  • Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
  • Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
  • Responsible for creating datasets using T-SQL and Stored Procedures and involved in Data visualization.
  • Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), MS SQL Profiler, SSAS, SQL Query Analyzer, Teradata, Erwin v4.1, MS Office 2013

Confidential, Atlanta GA

MSBI /SQL Server/SSIS/ETL Developer

Responsibilities:

  • Developed ETL Packages using SSIS (Integration Services) for Complex Data Transformations.
  • Designed and Developed SSIS packages in order to migrate and transform the data across various servers (Databases) based on business rules.
  • Report Development in SSRS (Reporting services) and delegate work to track the progress.
  • Developed system integration and test plans and conducted integration testing for user acceptance.
  • ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
  • Involved in creating ETL packages in SSIS to integrate data into Enterprise Data Warehouse (EDW).
  • As a Microsoft SSIS developer used its powerful concept of Merge statement and transformed data from staging Environment to OLAP.
  • Developed a process that loads weekly incoming Inpatient and Outpatient Claims .DAT files that contain claims data for both MEDICARE and MEDICAID for different Markets into SQL database using SSIS packages and generated Control reports using SSRS for different Health Plan Markets.
  • Extracted Provider data from Healthcare FACETS using SSIS and loaded into SQL tables, to validate if the rate calculator records in the control report were for active providers or inactive providers.
  • Analyzing the Requirement Specifications and discussions with the client to understand the correct scope of this project and clarifications.
  • Worked on Informatica power center tool - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer.
  • Used various tasks like scripts task, Dataflow, Control Flow in creating various packages according to the requirements.
  • Responsible for allocating responsibilities and coordinating ETL efforts among team members to ensure best practices are used.
  • As a SSRS developer generated various reports like Tablix, Matrix, Graphs Reports and parameterized reports in SSRS 2008.
  • Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL and Improved Report Performance and performed unit testing at time of integration.
  • Involved in extracting data from FACETS to various destinations like SQL Server, Excel and flat file.

Environment: SQL Server 2005/2008 Enterprise, SSIS, SSRS 2008 R2, MS VISIO, VB .NET.

Confidential

Sr. MSBI/SQL Server Developer

Responsibilities:

  • Efficiently used Microsoft SQL server 2005/2008/2008 R2 SQL server management studio
  • Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Prepared BRDs (Business Requirement Documents) supporting documents containing essential business elements, detailed definitions, & description of the relationships, to analyze and document business data requirements.
  • Documented ETL processes and prepared project status report updates/audit reports/ list of issue items that need to be reviewed.
  • Designed DTS/SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server 2005/2008 environment
  • Generated reports using SQL server Reporting Services, and created user friendly templates, indexes, using xml.
  • 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.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Extensive use of T-SQL DDL and DML commands for various applications.
  • Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
  • Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system.
  • Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.
  • Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), MS SQL Profiler, SSAS, SQL Query Analyzer, SQL Server Index Tuning Wizard, MDX, Erwin v4.1, MS Office 2013

Confidential

MSBI Developer

Responsibilities:

  • Participated in requirement gathering meetings with business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
  • Documented required technical metadata such as source and target definitions.
  • Developed Informatica Mappings with Reusable Mapplets, Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank), Workflows with Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Time.
  • Assignment, Worklet, Control).
  • Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction.
  • Implemented Type II slowly changing dimensions using date-time stamping and Created reusable transformations and mapplets to reuse while creating ETL mappings.
  • Generated different kinds of reports using the Cognos Report Studio 8.4 as per the user’s requirements and Dimensional modeling in Cognos Frame work Manager and Created list reports & cross tab reports using Cognos 8.4.
  • Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio.
  • Experience in developing Framework Manager Models and analysed those models in analysis studio.
  • Created prompts for user defined conditions, pre defined conditions which allow the users to pre select a condition value when they are running the queries.
  • Responsible for unit testing and fixing the issues.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), MS SQL Profiler, SSAS, SQL Query Analyzer, SQL Server Index Tuning Wizard, MDX, Erwin v4.1, MS Office 2013

Confidential

SQL Developer

Responsibilities:

  • Work with the direct client and oversee the system development process including systems analysis, technical design, coding, testing, and turnover to production of the application.
  • Preparation of the Functional Specification Document and Design Document.
  • Discussions with the client to understand the correct scope of this project and clarifications.
  • Responsible for the IA Reporting System and OLAP Module across all the applications.
  • Provide technical leadership to technical resources and customers to meet project deadlines and ensure project objective are met.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Developed system integration and test plans and conducted integration testing for user acceptance.
  • Work with the Onsite lead, offshore lead and Program manager to manage and oversee the system development process including systems analysis, technical design, coding, testing, and turnover to production of the application.
  • Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service Worked with handling the xml data and worked with querying the xml, and export/import xml data integration with SQL server.
  • Developed Query for generating drill down reports in SSRS 2005.
  • Looked at the reports and fixed bugs in stored procedures.
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: SQL Server 2005, SSIS, SSRS (Reporting services), SSAS (Analysis services)

Hire Now