Ms-sql Bi Developer/ Data Specialist Resume
Addison, Tx
SUMMARY:
- Around 7 years of experience in data modeling, database design, programming, development and implementation of client - server application & data base systems using SQL server (2014/2012/2008/2005 ).
- Solid experience in using Microsoft BI studio products like SSIS, SSRS, Power BI, Power Pivot, Tableau, SSAS. Expert in data warehousing & OLAP technology Experience in Finance, Retail, Banking, and Insurance sectors.
TECHNICAL SKILLS:
RSBMS: MS SQL Server 2014/2012/2008/2005.
Languages: T-SQL, C.
Tools: and Packages: SQL Server Management Studio, Enterprises Manager, Profiler, SQL Server Business Intelligence Development studio(BIDS),SSIS, Visual Studio .NET, Visual Source Team Foundation(VSTF), TFS.
Operating Systems: Windows Vista /XP/2003/2000, Windows Server 2000/2003/2008.
BI Tools: SQL Server Reporting Tools (SSRS), Tableau, SQL Server Integration Services (SSIS), SQL Server Analytical Service (SSAS), Performance Point Server.
Application Packages: MS Office, MS Outlook (Microsoft Office Suite).
PROFESSIONAL EXPERIENCE:
Confidential, Addison, TX
MS-SQL BI Developer/ Data Specialist
Responsibilities:
- Participated in daily and weekly scrum meetings for gathering functional requirements and provide status updates.
- Involve in creating database objects like views, procedures, triggers & functions using T-SQL to provide definition, structure and maintain data efficiently.
- Involve in restructuring existing objects like tables, functions, triggers, indexes, procedures and views.
- Involve in research/ support to identify root cause for various data integration issue and create template for individual and mass fixes.
- Performance tuning of existing database objects including views, indexes and stored procedures.
- Involve in materializing views & rebuilding indexes to reduce apparent database complexity for end user and filtering bad data accordingly.
- Create SSIS packages for extracting data to MS SQL Server database from other databases and source like MS Excel, XML Source and Flat Files (From SFTP) formats and vice versa.
- Extensive use of SSIS For each loop container, for loop container, sequence container and different task like send mail task, execute process task, execute package task, Open PGP Task.
- Implements Events Handlers & Error Handling for custom logging in SSIS package.
- Involve in SSIS life cycle in creating SSIS packages, building, deploying & executing packages in various environments.
- Create and upgrade SSIS package (Framework) for various file operation- uploading, downloading, and zipping, unzipping, compress and decompress & archive.
- Add required transformations like data conversion, lookup, derived column, merge, merge join, multicast, conditional split and union all for data cleansing and auditing.
- Collect requirements and design various report models.
- Create and modify reports using variables and expressions in SSRS.
- Create report on various Advisor/Rep status, Compliance and Business information for users in different departments in organization using SSRS and power BI.
- Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Used Tableau to visually analyze data and actionable dashboards
- Create well-formed reports and web-based reports for financial applications and transactions.
- Generate matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
- Create various reports subscriptions and Data-driven Subscriptions.
- Involve in Query Optimization to increase performance of reports.
- Involve in upgrading SQL Server 2008 R2 to SQL Server 2014.
Environment: SQL Server 2008R2/2014 Enterprise edition, SQL Server Data Tool, SSRS, Tableau, Power Bi, SSIS, SQL Server Profiler, MS Office 2013, MS Windows Server 2008 R2, MS Windows 7, MS Team Foundation Server, SQL Red Gate Tools.
Confidential, Miami, FLSQL, SSIS & SSRS Developer
Responsibilities:
- Participated in agile meetings for gathering functional requirements with Business analyst.
- Involved in redesigning existing objects like tables, functions, triggers, indexes, procedures and views.
- Involved in creating database objects like views, procedures & functions using T-SQL to provide definition, structure and maintain data efficiently.
- Involved in research to identify root cause for various integration issue and create template for individual and fixes.
- Performance tuning of existing database objects including views, indexes and stored procedures.
- Involved in rebuilding indexes to reduce apparent database complexity for end user and filtering bad data accordingly.
- Designed SQL Server Integration Services (SSIS) packages to extract data from different sources to SQL Server Data Warehouse.
- Created SSIS Packages for extracting data to MS SQL Server database from other databases and sources like MS Excel, Flat Files, and XML Sources.
- Extensive use of SSIS tasks like Execute SQL Task, File system Task, and SFTP task.
- Add required transformations like data conversion, lookup, derived column, merge, merge join, multicast, conditional split and union all for cleansing and auditing.
- Collected requirements and design various report models.
- Created and modified reports using global variables and expressions in SSRS.
- Created reports on various demographic information for users in different departments in organization using SSRS.
- Created well-formed reports and web-based reports for financial applications and transactions.
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
- Developed Tableau visualizations and dashboards using Tableau Desktop.
- Involved in Query Optimization to increase performance of report.
- Created reports using multiple data sources and datasets.
Environment: SQL Server 2012/ 2014 Enterprise edition, SSRS, Tableau, SSIS, SQL Server Profiler, MS Office 2013, MS Windows Server 2008 R2, MS Windows 7, TFS.
ConfidentialSQL BI Developer
Responsibilities:
- Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, stricture and maintain data efficiently.
- Performance tuning of existing database objects including stored procedures.
- Involved in rebuilding indexes to reduce apparent database complexity for end user and filtering bad data accordingly.
- Designed SQL Server Integration Services (SSIS) packages to extract data from different sources to SQL Server Data Warehouse.
- Created SSIS packages for migration of database to MS SQL Server database from other database and source like Sybase, MS Access MS Excel, tetra data and Flat Files.
- Performing tasks of data conversions, lookups, adding derived columns, sending results in mails is done by making use of various tasks in SSIS for data cleansing and Auditing.
- Creating reports for users in different departments in organization using SSRS.
- Designed report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.
- Scheduled reports for Daily, Weekly, Monthly Reports for various categories and regions based on business needs using Reporting Services (SSRS)
- Created and Modified Views, Stored Procedures and Functions for creating reports.
- Formatted reports using global variables and expressions in SSRS deployed generated reports on to Reporting server.
- Created horizontal partitioning of data for different file groups.
- Developed reports using complex formulas and to query database to generate different types of ad-hoc reports using SSRS.
- Support issues with reports on enterprise environments (Development, Test and Production).
Environment: SQL Server 2012/2008R2 Enterprise edition, SSDT, SSRS, SSIS, SSAS, SQL Server Profiler, MS Office 2010, MS Access 2010, .Net and MS Windows Server 2012.
ConfidentialSQL & SSIS Developer
Responsibilities:
- Participated in requirement gathering meetings for functional requirements and involved in documentation of projects
- Involved in installing SQL Server 2008 R2 and management tools.
- Provided post-implementation support.
- Preparation of High-Level and Low-Level design based on project.
- Designed and created database schemas and tables.
- Wrote scripts for database objects like stored procedures, functions, indexes, triggers and views.
- Wrote complex stored procedures for fetching records from multiple tables.
- Performance tuning of database and objects including stored procedures
- Designed, developed and implemented SSIS (ETL) packages to import data from multiple file formats.
- SSIS package include various data transformations like, Derived Column, Lookup, conditional split, merge join, union all & sort.
- Configured and tunes database and SSIS package for performance.
Environment: SQL Server 2008 R2 Enterprise Edition, BIDS, SSIS, SQL Server Profiler, Microsoft Access 2007, Microsoft Excel 2007and Microsoft Server 2008 R2.