Sr Sql- Bi Developer Resume
VA
SUMMARY:
- Having 10+ years of competitive experience in software life cycle process and agile process which includes Analysis, Database Design, BI Development, SQL, Production Support and Implementation using Data Warehousing technologies MSBI (SSIS, SSRS and SSAS), SQL Server and Power BI stack.
- Extensive Data modelling designing and data base programing experience using SQL Server 2014.
- Hands on experience with Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
- Having strong of experience in SQL Server Analysis Services (SSAS) 2012 and 2014 for designing and develop Tabular OLAP Cubes.
- Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2014 Analysis Services.
- Expertise in Extract Transform Load (ETL) development using SQL Server 2008, 2012 Integration
- Services (SSIS). Worked extensively on data extraction, cleansing/data integration, and loading from different data sources using SSIS.
- Extensive experience in SQL programing with complex SQL logic (using Joins, SPs and UDFs.) and analytic ability.
- Experience in creating Databases, Tables, Complex Stored Procedures, DDL/DML Triggers, Views, Index, User defined data types, Functions, Expertise in Performance Tuning and Query Optimization Cursors and Indexes using T - SQL.
- Experience in creating SQL Logins, Cube Roles as a part of security policies for various categories of users.
- Expertise in designing and developing Power BI Dashboards in to rich look.
- Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layouts sub reports using Global variables, Expressions, Sorting the data. Grouping functionality and sub reports for the reports using SSRS 2008/2012.
- Worked on Microsoft internal Cosmos Bigdata platform.
- Involved in Business Analysis of the OLTP and OLAP data in decision support.
- Working experience in MS.Net technologies (Asp.Net, C# and Webservices)
- Involved for installing, configuring, applying patches, maintaining security and troubleshooting issues related to database.
- Strong investigative, troubleshooting and Performance tuning skills.
- Reviewing data model and dashboard scripts during deployment of files to UAT/Production.
- Ability to bridge gap between technical and non-technical persons.
- Capable of forming and maintaining positive and productive working relationships in Internal and External and team environments.
- Microsoft Certified Professional
TECHNICAL SKILLS:
MSBI Technologies: SSIS, SSRS and SSAS
Bigdata: Cosmos, Scope Scripts, I Scope.
Databases: SQLServer 2008 R2/ 2012, MS Access, Oracle, DB2 and Vertica.
Data Modeling: TOAD data modeler.
Technologies: C#, ASP.Net, WebServices, XML, HTML and JavaScript.
Reporting Tools: SSRS, QlikView and Power BI
Languages: T-SQL, PL/SQL, DAX
Versioning Tools: VSS, TFS and Source Depot of Microsoft corp.
MS engineering Tools: WTT, Product studio.
Framework: .Net 3.5/4.0
PROFESSIONAL EXPERIENCE:
Confidential, VA
Sr SQL- BI Developer
Technologies: SSAS Tabular model, SSIS, SQLServer 2014, DAX, Power BI and Cosmos.
Responsibilities:- Gather the requirements with the help of data/business analysts and understanding of the same.
- Design Database and Staging tables to load the data from various Cosmos streams and sources.
- Design and Develop Data model by Mart (Fact and Dimension) tables with relevant Key relationships.
- Wrote strong logic queries in SQL, SPs, UDFs and Views for forecasting of shipments calculated.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Design and Developed DTSX packages to extract, transform and load into the Campaign database from OLAP cubes and various Cosmos streams using of SQL Server Integration Services (SSIS).
- Created the mappings using transformations such as the Derived Column, Lookup, Aggregate, Merge joins, Conditional Split and Audit.
- Created jobs, alerts to run SSIS packages and cube process periodically. Created the automated processes for the activities such as database backup processes SQL Server Agent job.
- Develop the datasets in COSMOS using Scope scripts.
- Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2014 Analysis Services (SSAS).
- Design and develop SSAS Tabular model using DAX queries
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Created Stored Procedures for various process of data load and manipulation.
- Generated high interactive dashboards using Power BI & Defined Calculated using DAX in power Bi.
- Create test cases for data validation and perform unit testing and data validation
- Configured Workspace, Enterprise gateway and security content for dashboard view.
- Responsible for documentation of system related activities and technical documentation.
- Create/document deployment and operational procedures.
- Perform knowledge transfer to end users and Support Team and prepare KT documents.
Confidential
Technologies: SSAS Tabular model, SSIS, SQLServer 2014, DAX, Power BI and Cosmos.
Responsibilities:- Gather the requirements with the help of data/business analysts and understanding of the same.
- Design Database and Staging tables to load the data from various Cosmos streams and sources.
- Design and Develop Data model by Mart (Fact and Dimension) tables with relevant Key relationships.
- Wrote strong logic queries in SQL, SPs, UDFs and Views for forecasting of shipments calculated.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Design and Developed DTSX packages to extract, transform and load into the Campaign database from OLAP cubes and various Cosmos streams using of SQL Server Integration Services (SSIS).
- Created the mappings using transformations such as the Derived Column, Lookup, Aggregate, Merge joins, Conditional Split and Audit.
- Created jobs, alerts to run SSIS packages and cube process periodically. Created the automated processes for the activities such as database backup processes SQL Server Agent job.
- Develop the datasets in COSMOS using Scope scripts.
- Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2014 Analysis Services (SSAS).
- Design and develop SSAS Tabular model using DAX queries
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Created Stored Procedures for various process of data load and manipulation.
- Generated high interactive dashboards using Power BI & Defined Calculated using DAX in power Bi.
- Create test cases for data validation and perform unit testing and data validation
- Configured Workspace, Enterprise gateway and security content for dashboard view.
- Responsible for documentation of system related activities and technical documentation.
- Create/document deployment and operational procedures.
- Perform knowledge transfer to end users and Support Team and prepare KT documents.
Confidential
Technologies: SSAS Tabular model, SSIS, SQLServer 2014, DAX, Power BI and Cosmos.
Responsibilities:- Gather the requirements with the help of data/business analysts and understanding of the same.
- Design Database and Staging tables to load the data from various Cosmos streams and sources.
- Design and Develop Data model by Mart (Fact and Dimension) tables with relevant Key relationships.
- Wrote strong logic queries in SQL, SPs, UDFs and Views for forecasting of shipments calculated.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Design and Developed DTSX packages to extract, transform and load into the Campaign database from OLAP cubes and various Cosmos streams using of SQL Server Integration Services (SSIS).
- Created the mappings using transformations such as the Derived Column, Lookup, Aggregate, Merge joins, Conditional Split and Audit.
- Created jobs, alerts to run SSIS packages and cube process periodically. Created the automated processes for the activities such as database backup processes SQL Server Agent job.
- Develop the datasets in COSMOS using Scope scripts.
- Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2014 Analysis Services (SSAS).
- Design and develop SSAS Tabular model using DAX queries
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Created Stored Procedures for various process of data load and manipulation.
- Generated high interactive dashboards using Power BI & Defined Calculated using DAX in power Bi.
- Create test cases for data validation and perform unit testing and data validation
- Configured Workspace, Enterprise gateway and security content for dashboard view.
- Responsible for documentation of system related activities and technical documentation.
- Create/document deployment and operational procedures.
- Perform knowledge transfer to end users and Support Team and prepare KT documents.
Confidential
Technologies: SSRS, SSIS, SSAS Tabular model, SQLServer 2014, DAX, Power BI.
Responsibilities:- Part of design of the complete database infrastructure.
- Created Database and Staging tables for all 3rd Market share synergy data, Enterprise Telephony data and SFB Sales units and data on Quarterly wise.
- Created the Data model and tables with relevant Key relationships and Indexes.
- Wrote strong logic queries in SQL, SPs, UDFs and Views for forecasting of shipments calculated.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Developed DTSX packages to extract, transform and load into the Campaign database from OLAP cubes and 3rd Party synergy database using of SQL Server Integration Services (SSIS).
- Created the mappings using transformations such as the Derived Column, Lookup, Aggregate, Merge joins, Conditional Split and Audit.
- Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS.
- Created jobs, alerts to run SSIS packages and cube process periodically. Created the automated processes for the activities such as database backup processes SQL Server Agent job.
- Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2012 Analysis Services (SSAS).
- Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Created Stored Procedures for various process of data load and manipulation.
- Generated high interactive dashboards using Power BI & Defined Calculated using DAX in power Bi and Tabular Cube measures as well for trend Calculations.
- Configured Workspace, Enterprise gateway and security content for dashboard view.
- Responsible for documentation of system related activities and technical documentation.
Confidential,Herndon, VA
Sr SQL BI Developer
Responsibilities:- Part of design of the complete database infrastructure.
- Created Database and Staging tables for accommodating the raw data flowing from SAP Sources like Business Warehouse, Velocity and Fusion.
- Created the Data model and tables with relevant Primary, Foreign relationships and Indexes.
- Wrote strong logic queries in SQL, SPs, UDFs and Views for forecasting of shipments calculated.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
- Created the mappings using transformations such as the Derived Column, Lookup, Aggregate, Merge joins, Conditional Split and Audit.
- Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
- Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2012 (SSAS).
- Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2012 Analysis Services (SSAS).
- Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
- Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2012(SSAS).
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Created Stored Procedures for various process of data load and manipulation.
- Generated several drill down and drill through reports using SSRS.
- Responsible for documentation of system related activities and technical documentation.
Appreciation: Received the best Innovative contributor award from the customer side for the skill, shown dedication and commitment and a will to win.
Confidential
Technologies: SSRS, SSIS, SSAS, SQLServer2008/2012
Responsibilities:- Responsible for getting, understanding the business specs, preparing technical Specs, Report development.
- Wrote strong logic queries in SQL, SPs, UDFs and Views.
- Created the Data model and tables with relevant Primary, Foreign relationships and Indexes.
- Created PowerShell script codes to extract information from SAP Sources like Business Warehouse. Completely automated the process using PowerShell and VB Script, SQL Jobs.
- Created Database and Staging tables for accommodating the raw data flowing from SAP Sources like Business Warehouse, Velocity and Fusion.
- Created the Data model and tables with relevant Primary, Foreign relationships and Indexes.
- Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
- Created the mappings using transformations such as the Derived Column, Lookup, Aggregate, Merge joins, Conditional Split and Audit.
- Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
- Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2012 (SSAS).
- Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2012 Analysis Services (SSAS).
- Involved in writing MDX Scripts for the OLAP CUBES.
- Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
- Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2012(SSAS).
- Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS). Created Stored Procedures for various process of data load and manipulation.
- By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
- Responsible for developing the SSRS drilldown and Drill trough reports and testing them with UAT and sign off duly done.
- Technical and User Documentation has been prepared and signed off the project for Live.
Confidential,Redmond, Bellevue,WA
SDE SQL BI Developer
Technologies: SSRS, SSIS, SQLServer2012, Dynamics AX, SQL, SSAS
Responsibilities:- Work on assigned tasks as planned by manager for every iteration.
- Involved in writing SQL queries
- Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
- Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2012(SSAS).
- Involved in writing MDX Scripts for the OLAP CUBES.
- Analyzing the requirements and discussed with managers and leads on the functionality.
- Provided the training in SSRS framework for developers which helped to them to create migration tool for Legacy AX reports to SSRS.
- Involved in integrating SSRS reports with Dynamics AX.
- Involved in SSRS cascading/parameterized report development and drilldown and drill through reports for final output of AX reports.
- Involved in Implementing Data Access Layer and BLL using c#, AXProxies.
- Perform coding and unit/integration testing.
- Responsible for getting, understanding the business specs, preparing technical Specs.
- Involved in writing SQL queries
- Created the Data model and tables with relevant Primary, Foreign relationships and Indexes.
- Analyzing the requirements and discussed with managers and leads on the functionality.
- Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
- Creation of packages by using required transformations in SSIS.
- Creating jobs for scheduling the SSIS packages.
- Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
- Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
- Getting data from different data sources.
- Created the mappings using transformations such as the Derived Column, Aggregate. Merge joins, Conditional Split and Audit….Involved in creating the Cubes by using Sql Server 2008 Analysis Services.
- By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
- Perform unit testing\integration testing of the packages
- Identifying of performance bottlenecks, Performance tuning of packages.
- Analyzing the traditional database (OLTP) of the client, Loading appropriate dimensional tables as well as Fact tables for constructing the Data warehousing.
- Identifying the business process requirements.
- Involved in writing SQL queries using T-SQL.
- Created the Data model and tables with relevant Primary, Foreign relationships and Indexes.
- Identifying the grain of fact and dimensional tables and according to that
- Loading data into fact and dimension tables by creating SSIS packages.
- Creation of packages by using required transformations in SSIS.
- Worked with simple MDX queries
- Created the mappings using transformations such as the Derived Column, Aggregate. Merge joins, Conditional Split and Audit…. Involved in creating the Cubes by using Sql Server 2008 Analysis Services
- By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
- Identifying of performance bottlenecks, Performance tuning of packages.
SDE SQL Developer
Confidential
Technologies: SQLServer, C# and AX
Responsibilities:- Involved in Data model designing and tables with relevant Primary, Foreign relationships and Indexes. Responsible for creating appropriate loaders and relational writes to load the Data from SSIS.
- Involved in writing SQL queries
- Developed C# Libraries for the application wide reuse and trained the rest of the team members about the usage.
- Prepared & executed robust GUI Test cases using UI/ App Logic Automation feature of Silverlight Unit testing framework and C#.
- Writing Test cases to achieve functional level scenarios
- Fixing Bugs. Enhancements if the table data changed.