We provide IT Staff Augmentation Services!

Sql Msbi Developer Resume

Redmond, WA

PROFESSIONAL SUMMARY:

  • 8 years of wide - ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting.
  • Proficiency in Confidential Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
  • Strong experience with T-SQL (DDL & DML) in implementing and developing stored procedures, triggers, nested queries, joins, cursors, views, user defined functions, indexes, user profiles, relational database models
  • Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.
  • Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
  • Extensively worked on Control Flow Tasks such as For each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.
  • Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
  • Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
  • Experience in debugging the SSIS packages using breakpoints and checkpoints.
  • Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
  • Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.
  • Strong skills in writing MDX queries to access cubes in SSAS, and creating feeds from OLTP systems.
  • Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
  • Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)
  • Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
  • Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
  • Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
  • Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
  • Good knowledge in using the Power Pivot and Power BI
  • Strong Knowledge in generating the reports using POWER BI.
  • Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non-Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
  • Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
  • Experience in Data warehouse as DataStage Designer for creating jobs flows to extract, transform, integrate and load data.
  • Strong knowledge in Excel like Pivot table, Pivot chart, Macros, VLOOKUP and Hlookup

TECHNICAL SKILLS:

Server Operating System: Windows 2003, 2008, 2012.

Languages: C, PowerShell, Pl/SQL, T-SQL

Tools: Quantrix, RIM Dashboard, QTP, Selenium, UHRS

Web Technologies: HTML, CSS, Scope, Power BI

Data bases: MS SQL Server 2005/2008/2012/2014, Oracle 10g, Teradata

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL

Development Tools: Visual Studio 2008/2012/2013/2015 Community Edition SSDT

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013, SQL Profiler, DQS, Toad for SQL server

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SQL MSBI Developer

Responsibilities:

  • Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement.
  • Involved in integrating different Database Applications using SSIS packages.
  • Creating SSIS packages that involves migration from legacy systems to centralized Database.
  • Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
  • Validate data before performing ETL transformations and load into SQL server database.
  • Intensively worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.
  • Worked with Web Service task where some of the binary files will be converted into XML element to place in Message Broker queue.
  • Implemented transformation mapping through BizTalk server with the help of Visual Studio to achieve data transformation from one type to another.
  • Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.
  • Created stored procedures, Cursors, Joins in T-SQL.
  • Manually documented each process and the flow of the package.
  • Created Drill-down and Drill- through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.
  • Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs. Also, to trigger emails about the failure using Email task.
  • Effectively used script task to perform validation of files and archiving it.
  • Designed and created Report templates, bar graphs and pie charts based on the inspection data.
  • Experience in designing, creating, processing of cubes using SSAS.
  • Excellent hands on experience in creating groups and measures, KPIs.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
  • Performed Source system analysis to identify the source data that needs to be moved into the target tables.
  • Planned, coordinated analysis, design and extraction of encounter data from multiple source systems into the data warehouse database while ensuring data integrity.
  • Experience in Dimensional Modeling.

Environment: Confidential SQL Server 2012, Confidential Excel, SSIS/SSRS/SSAS, DataStage ETL, Confidential TFS, Confidential Office, Profiler, Visual Source Safe, BIDS, Visual Studio.

Confidential, Bellevue, WA

Sr. SQL/MSBI Developer

Responsibilities:

  • Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.
  • Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
  • Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
  • Trouble shooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs.
  • Manually running some of the SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure that the input data acquired or not.
  • Interacting with Managers, Project Directors to plan and execute the project provisions and efforts estimations.
  • Worked on Data migration project by validating three source data row by row and field by filed
  • Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
  • Worked on development of SSIS package to generate excel reports individually and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users
  • Worked on the fixing the bad data in Legacy Tables in batches, Created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
  • Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS
  • Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
  • Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
  • Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
  • Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
  • Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
  • Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
  • Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
  • 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.
  • Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.
  • Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.

Environment: Confidential SQL Server 2012/2008 R2, Datastage ETL, SSDT, Confidential Excel, SSIS/SSAS/SSRS 2012/2008, Confidential Office, Power BI, Profiler, Visual Studio, Confidential TFS, BIDS.

Confidential, Neenah, WI

Sr. SQL BI Developer

Responsibilities:

  • Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Enhanced and deployed the SSIS Packages from development server to production server.
  • Wrote the ETL scripts to load the data into database from various source files. Implemented error handling and troubleshoot the scripts that fail 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.
  • 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.
  • Integrate SQL Server 2008 R2 reporting services with Confidential 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.
  • 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.
  • Administrated the created reports by assigning permission to the valid user for executing the reports.
  • Created logins, users and configuring permissions and assigning roles to users.
  • Worked on the creation of views to restrict access to data in a table for security.
  • Involved in database schema design and development.
  • Involved in Migration of databases from SQL Server 2005 to 2008 R2.
  • Involved in design and implementation of SQL Server 2012 in development, test and production environments.
  • 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, wrote T-SQL statements for retrieval of data, and involved in performance tuning of T-SQL Queries and Stored Procedures.

Environment: Confidential SQL Server 2012/2008 R2,SSDT, Confidential Excel, SSIS/SSAS/SSRS 2012/2008, Confidential Office, Power BI, Visual Studio,.

Confidential

BI Developer

Responsibilities:

  • Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Enhanced and deployed the SSIS Packages from development server to production server.
  • Wrote the ETL scripts to load the data into database from various source files. Implemented error handling and troubleshoot the scripts that fail 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.
  • 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.
  • Integrate SQL Server 2008 R2 reporting services with Confidential 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.
  • 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.
  • Administrated the created reports by assigning permission to the valid user for executing the reports.
  • Created logins, users and configuring permissions and assigning roles to users.
  • Worked on the creation of views to restrict access to data in a table for security.
  • Involved in database schema design and development.
  • Involved in Migration of databases from SQL Server 2005 to 2008 R2.
  • Involved in design and implementation of SQL Server 2012 in development, test and production environments.
  • 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, wrote T-SQL statements for retrieval of data, and involved in performance tuning of T-SQL Queries and Stored Procedures.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS).

Confidential

SQL Developer

Responsibilities:

  • Participated in developing Logical design of database incorporating business logic and user requirement and building entity relationship(ER) diagrams.
  • Created Database Objects like Tables, Stored Procedures, Functions, Views, Constraints and user defined data types.
  • Managing the credit card and debit card sales by writing the query as per branch requirements.
  • Identified relationships between tables, enforced referential integrity using foreign key constraints. Used Views, Triggers and Stored Procedures for updating and cleaning the existing data and the new data,
  • Written Stored Procedures and functions as per business requirement.
  • Created T- SQL objects & scripts used to maintain data integrity across all databases throughout database servers.
  • Defined Check constraints, Business Rules, Indexes and Views and wrote SQL procedures with optimized complex queries to extract data.
  • Assisted with any database related issues in software products.
  • Participated in system specification meetings, analyzed user requirements, coordinated with coders and team members.
  • Managing historical data from various heterogeneous data sources.
  • Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Environment: MS SQL Server 2008/2005, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, VB Script, Visual studio 2005, MS Access.

Hire Now