T-sql\bi Developer Resume
SUMMARY:
- 9+ years of IT experience in Data Design and Development on Confidential SQL Server 2016/2012/2008/2005 , T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
- Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008
- Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
- Good understanding in database and data warehousing concepts (OLTP & OLAP).
- Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
- Hands on Experience in MDM implementations using SQL Server Master Data Services 2012 (MDS 2012)
- Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2016/2012/2008/2005 .
- Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
- Experience in Performance Tuning and Query Optimization.
- Experienced in using ETL tools in (SSIS) MS SQL 2008/12/16
- Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
- Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
- Data analysis and data migration by transferring them using SSIS packages.
- Experience with logical and physical data modeling and database design using Erwin.
- Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
- Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
- Experience in modifying MDX Cubes and Dimensions in SSAS.
- Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
- Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
- Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
- Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
- Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
- Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
- Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
TECHNICAL SKILLS:
SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008/2012/2016 , SQL Server Management Studio 2005/ 2008/2012/2016 , DTS, SSIS, SSRS, SSAS, Power BI
Database: MS SQL Server 2012,2016,2008,2005, MS-Access, Oracle, MySQL, HDFS
Language: C, C++, C#, T-SQL, VB, DAX
Operating System: Windows 7/10, Linux, Windows Server 2008/2012
Tools: SQOOP, Confidential Visual Studio 2013/2008/2005 , BIDS, SSDT, TFS, TortoiseHg
Reporting Tools: SSRS 2008/2012/2016 , Crystal Reports, Power BI, Tableau 9.0
ETL Tools: SSIS 2008/2012/2016 , Informatica Power Center 9.1/8.6, DTS
PROFESSIONAL EXPERIENCE:
Confidential
T-SQL\BI Developer
Responsibilities:
- Developed various SSIS packages for migrating the Provider, Claims and Member data from Coventry to Confidential .
- Provided application support for different applications that support Providers, Member, Enrollment, Claims and Commissions Data.
- Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
- Migrating existing SSIS packages from SSIS 2012 to SSIS 2016
- Migrated data from legacy systems like (flat files, excel and access) using SSIS and Stored procedures to SQL Server
- Written Complex SQL Queries by joining multiple tables, dynamic SQL and Subqueries in T-SQL
- Developed Power BI model used for reporting claim and Membership data
- Designed and documented the entire Architecture of Power bi POC
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
- Used various sources to pull data into Power BI such as Sql Server, excel, text files etc.
- Created Workspace and content packs for business users to view the developed reports.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
- Weekly presentation to the business users about the reports and their changes as required.
- Worked on drill down and drill-up reports.
- Worked on different types of transformations that are available in Power bi query editor
- Created stored procedures and SQL queries to pull data into power pivot model.
- Worked on different Break-fix SRs for different applications to resolve any issues
- Worked with offshore team to provide 24*7 support to client
Confidential, Denver, CO
SQL BI Developer
Responsibilities:
- Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
- Migrated existing ad- hoc SSRS reports to Power BI and created new dashboards in Power BI.
- Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
- Expertise in writing complex DAX functions in Power BI and Power Pivot.
- Used various sources to pull data into Power BI such as Sql Server, My SQL, Oracle etc.
- Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
- Weekly presentation to the business users about the reports and their changes as required.
- Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
- Provided continuous maintenance and development of bug fixes for both SSRS and power Bi reports
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
- Creating Reports as per user requirements using MS Reporting Services 2008/2012.
- Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
- Worked in developing queries in MySQL using MySQL workbench
Environment: MS SQL Server2008/2012, MySQL, TortoiseHg, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Tableau 9.0, Visual Studio 2008/2013, T-SQL
Confidential, Denver, CO
SQL Developer
Responsibilities:
- Worked in Horton Works Framework 2.2 HADOOP
- Worked in SQOOP to import and export from SQL Server 2008/2012 to HDFS file system
- Queried HDFS tables using HIVE/PIG SQL
- Worked with Business Analysts in gathering requirements and translating them to technical specifications.
- Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
- Worked in implementation of MDM using SQL Server Master Data Services 2012 (MDS 2012)
- Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
- Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
- Optimized the database by creating various clustered, non-clustered indexes and indexed views.
- Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
- Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports
- Developed Power Bl reports and dashboards from multiple data sources using data blending.
- Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
- Performed data quality analysis using advanced SQL skills.
- Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
- Explored data in a variety of ways and across multiple visualizations using Power Bl. Strategic expertise in design of experiments, data collection, analysis and visualization
- Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
- Contributed in the development of knowledge transfer documentation.
- Designed Power Bl data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
Environment: MS SQL Server2008/2012, Informatica Power Center 9.0.1, Team Foundation Server, (SSIS) SQL Server Integration Services, Power BI, Visual Studio 2008/2012, T-SQL
Confidential
T-SQL/BI Developer
Responsibilities:
- Migrated Data from Oracle Siebel CRM to GSX/PSX applications
- Created database structure that corresponds to the data that was migrated to PSX application
- Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
- Created various SSIS packages for moving the data from Oracle (Excel, Access etc.,) to SQL Server
- Optimized the database by creating various clustered, non-clustered indexes and indexed views.
- Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
- Created Alerts for successful or unsuccessful completion of Scheduled Jobs/ System Monitoring jobs.
- Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
- Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
- Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
- Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
- Creating Reports as per user requirements using MS Reporting Services 2005/2008/2012.
- Created different types of reports such as Cross-Tab, Drill-down, Drill-through, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
- Designing and implementing data warehouse ETL using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views)
- Performance tuning, deploying and processing SSAS cubes
- Writing complex MDX queries
- Troubleshoot/research data issues that arise during cube development and validation.
Environment: MS SQL Server2008/2012, Team Foundation Server, Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, SSAS, Visual Studio 2005/2008, Windows 7/8, T-SQL
Confidential
T-SQL\BI developer (SSRS/SSAS)
Responsibilities:
- Worked with Business Analysts in gathering requirements and translating them to technical specifications.
- Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
- Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
- Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
- Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
- Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
- Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
- Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
- Used Script task to write custom code using Vb.net
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
Environment: MS SQL Server2005/2008, Team Foundation Server, Confidential SharePoint Server, Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, VB.Net
Confidential
T-SQL\BI Developer
Responsibilities:
- Migrated SQL server 2005 to SQL Server 2008 R2.
- Created efficient scripts for taking backups of databases
- Developed T-SQL queries and stored procedures with multiple parameters to created data Sets for reports
- Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2008
- Created subscriptions in SSRS to deliver reports to a shared file.
- Created User-defined functions, Triggers, Views for Audit and security purposes.
- Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod
Environment: SQL Server 2005/2008, T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, SQL Profiler, MS Visio, Visual Studio 2008