Sr Sql/power Bi Developer Resume
Atlanta, GA
SUMMARY
- 6+ years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau
- Experience in developing the applications using T - SQL Programming (DDL, DML, and DCL).
- Conversant with various phases of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
- Proficient with SQL Analysis Services 2008/2012 such as, building multi-dimensional cubes, Dimensions, fact tables, Hierarchies, levels, roles, performed drill-up, drill-down, and drill-through and applying cube security.
- Experience in developing different types of reports usingCrystal,WebI and DeskI.
- Wrote Multidimensional Expression (MDX) queries to extract data from cubes.
- Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Experience using Microsoft .NET platform with 3-tier Development environment using C#, ASP.NET, ADO.NET, XML, Web Services, SOAP, ODBC, IIS, Crystal Reports.
- Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.
- Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
- Proficient in full life cycle design and development of Business Objects reporting Applications.
- Strong understanding ofdata warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flakedata models.
- Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
- Developed OLAP cubes using SSAS (SQL Server Analysis Services).and calculate the metrics that were revealed in the functional analysis.
- Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
- Experience in developers and advising technical groups on reporting best practices.
- Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
- Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
TECHNICAL SKILLS
Languages: SQL, Transact SQL, PL/SQL, Embedded SQL, C,C++, Java, J2EE, VBScript, C#.Net, JavaScript, ASP, HTML 4.0, DHTML,XML
Databases: SQL Server 2014/2008 R 2/2008/2005/2000 , Oracle 9i/8.x, DB2 MS Access (T-SQL/Stored Procedures/Power Pivot/Power View)
Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9
ETL Tools: SSIS (SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP), Informatica 8.6.1, Business Objects XI R2/R3, Webi
Other Software: MS Office- 2007/2003/2000 , Adobe Professional.
Operating Systems: Windows / 98/2000/2003/ XP/Vista, Agile, Linux.
Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2008 Query Editor, SQL Server Analysis Services (SSAS), TOAD
Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling
PROFESSIONAL EXPERIENCE
Confidential, Atlanta GA
Sr SQL/Power BI Developer
Responsibilities:
- Created packages using SSIS to extract the data from different flat files (.txt, .csv, .xlsx) and loaded to tables in SQL Server 2012.
- Created SSIS packages to load data to Staging and Datamart tables in SQL SSMS 2012.
- Created configuration files in SSIS 2008 to deploy packages in different environments like DEV, TST, and PROD.
- Used TFS (Team Foundation Server) to maintain all packages and reports created.
- Deployed SSIS packages to SQL 2012 and scheduled jobs to extract data from sources on daily basis.
- Created and Scheduled jobs to send the data to PCG, Destiny and Tip Web on daily basis.
- Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract, transform and load jobs.
- Developed different types of Tabular, Matrix, Drilldown, Drill Through reports to PCG and SAP team using SSRS.
- Deployed SSRS reports to 2012 report manager and exported them to desired formats like Excel, pdf etc. for end user access.
- Scheduled Reports to run the reports Hourly, Daily, and Monthly according to client requirements for the periodic analysis.
- Created tables, views, stored procedures, functions in SQL Server 2012.
- Involved in performance tuning of TSQL queries and Stored Procedures.
- Created jobs, alerts using SQL Server Agent to run SSIS packages periodically.
- Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
- Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
- Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
- Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
- Worked in Agile Scrum Methodology with daily stand up meetings and great knowledge in TFS (Team Foundation Server) 2010.
Environment: MS SQL Server 2012/2008R2/2005, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, MS SQL Server Reporting Services (SSRS) 2012/2008R2/2008,SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), T-SQL, Power BI, SharePoint, Tableau, OBIEE, Power Pivot
Confidential, Atlanta GA
SQL Server/Power BI Developer
Responsibilities:
- Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
- Used the web form to host Report Viewer in Silverlight.
- Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
- Exported reports from crystal toPDFandMicrosoft excelformats
- Implemented dashboards and scorecards with power pivot for executive management for data insights asper business requirements.
- Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
- Worked heavily on SQL Server database to extract data and build Business reports.
- Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
- Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
- Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
- Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
- Project includes extracting, transforming, loading data from ERP database in OLAP cubes
- Implementation of SQL Server Analysis Services (SSAS), design/change/deploy OLAP Cubes.
- Installed MS SQL server 2005 and MS SQL server 2008 on windows 2003/2008 servers, appliedService packs and Security fixes.
- Implementing database standards and naming convention for the database objects.
- Created complex reports using Crystal reports XI.
- CreatedSQL Scripts for data loads and upgrades for data migrations and data validations.
- Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
- Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
- Identified and added the report parameters and created the reports based on the requirements usingSSRS .
- Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
- Wrote custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server
- Built and published customized interactive dashboards utilizing Excel Power BI.
- Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements
- Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
- Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance.
- Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
- Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
- Involved extensively in designing of OLTP database
- Created schemas, keys and indexes considering the granularity of the data
- Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
- Iteration planning for new features and user stories in Agile Development methodology.
- Deployed SSIS packages and Reports to Production Servers.
Environment: SQL Server 2012/2008 R2, SSIS, SSRS, SSAS, DTS packages, Power Pivot, Visual studio 2010/2008, Crystal reports, Tortoise SVN 1.7.10, Red Gate 10.0,Window 7 Professional, Agile.
Confidential
SQL Developer
Responsibilities:
- Involved in Analysis, Design, and Development and Testing phases.
- Analyzed the business requirements from the given specifications.
- Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL.
- Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2005
- Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment
- Used the maintenance Plan for SQL Server databases to recreate indexes and statistics for the performance.
- Design and implementation of Security Model, policies and procedures.
- Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.
- Created Snapshot Replication for the Development and Testing Databases across different Servers.
- Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
- Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
- Enhancing and deploying the SSIS Packages from development server to production server.
- Performed Documentation for all kinds of reports and DTS and SSIS packages.
- Designed and developed complex SSRS reports.
- Create ad hoc complex management reports as required.
- Design and develop reports using SQL server reporting services.
- Configuration of linked servers for user to be used for data exchange.
- Created and scheduled jobs and alerts.
- Involved in version management of source code using VSS.
- Involved in designing of reports using SSRS.
- Involved in Unit testing and System Testing for the application.
Environment: Microsoft SQL Server 2005/2008, Microsoft SQL Server Management Studio 2005/2008, T-SQL, Microsoft SQL Server Reporting Services.
Confidential
SQL Server Developer
Responsibilities:
- Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
- Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
- Design and implement database logical and Physical Schemas.
- Responsible for database tuning using normalization and application tuning.
- Maintenance of Development, System test, Assemble test and Integration Servers and databases.
- Involved in Query tuning, Index Tuning and performance tuning.
- Involved in Users and user group creation and maintenance.
- Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
- Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
- Created and modified stored procedures to Create Reports.
Environment: MS SQL Server 2000/2005, T-SQL, SQL Query Analyzer, SQL Developer, DTS Designer, SQL Profiler, Index Tuning Wizard, Windows XP, MS Excel, MS Access.