We provide IT Staff Augmentation Services!

Sr. Sql Bi Developer Resume

Atlanta, GA

PROFESSIONAL SUMMARY:

  • Dedicated, team player self - motivated IT professional with development and support skills coupled with a "can-do" attitude having around 9+ years of IT Experience.
  • Extensive knowledge as a Database engineer using MS SQL 2008/2012/2014/2016 , BI Stack in various industries
  • Extensive knowledge dealing with Relational Database Management Systems (RDBMS), OLAP, OLTP systems.
  • Experience in creating various SQL server Objects like Tables, Views, Stored Procedures, User Defined Functions.
  • Experience in BI Development, Deployment & Maintenance of SSIS packages.
  • Involved in various phases of BI development projects during the tenure that includes Scope Study, Requirements Gathering, Design, Development, Implementation and Acceptance Testing for end-to-end IT solution offerings.
  • Experienced in writing Complex T-SQL scripts to support Ad-hoc needs.
  • Very good knowledge in fine tuning long running T-SQL scripts by breaking down complex scripts to simple once, Creating Indexes, Updating statistics and so on.
  • Hands-on experience in Database Administration Operations like Backup, Recovery, Installing, Configuring, Managing, monitoring and using SQL Profiler.
  • Designed and developed ETL-SSIS packages with various transformations, stored procedures, configuration files and tables.
  • Expert in Extracting and transforming data (ETL) from various heterogeneous sources and loading them into various heterogeneous sources.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Experience in creating complex SSIS packages which contains several control flow tasks like Execute SQL Tasks, Script Tasks, Data Flow Tasks, For Each Loop, and so on.
  • Experience in transforming data using Data Flow Tasks like Derived Column, Data Conversion, Row Count, Merge Join, Union All, etc.
  • Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages.
  • Experience in various kinds of SSIS Deployments like Catalog Deployment, File Based Deployment, and SQL Server Deployment.
  • Involved in creating the report subscriptions and user security in SSRS.
  • Experience in creating various complex reports in SSRS (tabular, drill down, drill through, matrix, chart, and parameterized) per requirements.
  • Experience in creating various kinds of Subscription Reports, Linked Reports, Cached Reports in SSRS.
  • Wide experience in Creating OLAP Cubes using SSAS.
  • Experience in identifying dimensions, attributes, hierarchies, calculating measures and dimension members in SQL Server Analysis Services (SSAS).
  • Good Knowledge in writing test cases for testing. Involved in writing the test cases for manual testing.
  • Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models and E-R Diagrams.
  • Proficient in OLTP, OLAP and Data Warehouse Design concepts.
  • Very good knowledge in various kind of schema’s in OLAP like Start Schema, Snow Flake Schema.
  • Expertise in writing complex DAX functions in Power BI
  • Hands on experience in designing DW Databases using Inmon, Kimball methodologies.
  • Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
  • Hands on experience in designing databases using tools like VISIO, ER Studio.
  • Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), and Tableau
  • Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation.
  • Experience in SCRUM & Agile Process.
  • Experience in Service Management (which includes Incident, Change and Problem) and well versed in handling issues in Production.
  • Demonstrated ability to identify root causes of problems, considering both the long and short-term impact of proposed solutions and develop workable solutions.
  • Good Knowledge in Application support process with SLA (Service Level Agreement).
  • Basic knowledge in Share point 2010 like Creating lists, Libraries, Alerts, People access, etc.

TECHNICAL SKILLS:

Operating Systems: Windows XP/2007/2010

RDBM/Databases: MS SQL Server 2008/2012/2014/2016 , MS Access 2010, MySQL

Programming Languages: T-SQL, Dynamic SQL, DOS Scripting

Data Modeling: MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access

Data Design Tools: MS Visio, Smart Draw

BI Tools: SQL Server Reporting Services (2008/2012), SQL Server Integration Services (SSIS 2008/2012), SQL Server Analytical Services (SSAS 2008), BIDS

Tools: /Database Utilities:: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS)

Application Packages: MS Office, Microsoft SharePoint Server

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. SQL BI Developer

Responsibilities:

  • Actively participate in gathering of user requirement and system specification.
  • Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems. Maintain historical data in data warehouse used ETL to implement the slowly changing transformation.
  • Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Views, Cursors, CTE's, schemas, used DDL, DML commands. Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports
  • Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Effectively used various properties in SSIS package to improve the performance.
  • Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS-SQL Server by using DTS and SSIS services. Created ETL SSIS packages both design and code to process data to target databases.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
  • Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications
  • Developed custom calculated measures using DAX in Power BI to satisfy business needs
  • Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
  • Used various SSIS task such as conditional split, derived column, which did data scrubbing, including data validation checks during staging before loading data to data warehouse and data marts.
  • Scheduled Automatic refresh and Scheduling refresh in Power BI service
  • Created Drill Down, Drill Through, linked, matrix, Charts, lists, Sub reports using SSRS and managed their subscriptions. DBA activities like creating users, roles and granting and revoking privileges.
  • Deployed and uploaded the SSRS reports to Report Manager and organized them into folders for the end users and involved in enhancements and modifications.

Environment: T-SQL, MS SQL Server 2016/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Team foundation Server(TFS), SharePoint, MS Excel

Confidential, Atlanta, GA

Sr. SQL BI Developer

Responsibilities:

  • Involving in Designing phase and Development Phase for every Project within billing and financial department.
  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for several types of information consumers.
  • Gather and understand business requirements to set functional specifications for reporting applications.
  • Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
  • Created joins and sub-queries for complex queries involving multiple tables.
  • Scheduled SQL Server Agent Jobs to monitor data transformation and database updates.
  • Identified Fact tables and Dimension tables, and created data marts for various subject areas as required.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model. Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Increased cube usability by adding named calculations, defining display folders, modifying composite Key Columns, attribute relationships, and adjusting properties such as Discretization Method using SSAS.
  • Designed and implemented Row Level Security and Roles for SSAS Tabular Model & Multidimensional Cubes. And deployed into SQL SERVER ANALYSIS SERVER 2016.
  • Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs. Hands on experienced developing dashboards and reporting visualization.
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs for data warehouse purposes.
  • Created Database Objects like tables, views, Store Procedures, User Defined Functions, Triggers, index and roles.
  • Created SSIS Packages to load the data into data warehouse from the various Sources.
  • Worked on various levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
  • Troubleshoot of various SSIS ETL packages and its performance tuning, implemented failure alerts using in SSIS.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Experience in using various sources to pull data into Power BI such as Oracle, SQL Server, Teradata, SQL Azure, and etc..
  • Performed transformations like conditional split, sorting and included data about the environment using audit transformation. Expert on creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
  • Designing, Constructing, and Testing of ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transforming the data according to analytical / reporting business needs, and loading the data into a Data Warehouse or Data mart.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
  • Created SSIS packages to transfer data, from flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment

Environment: Microsoft Visual Studio 2015, Team Foundation Server (TFS), MS SQL Server 2012/ 2014, MS SQL Integration Services 2008 R2/ 2012/ 2014, MS Access, OLAP, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, MS Excel, SQL Server Agent, SQL Server Reporting Services (SSRS), T-SQL

Confidential, Plainville, CT

Sr. SQL BI Developer

Responsibilities:

  • Excellent report creation skills using Microsoft SQL Server 2014/2012/2008 R2 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Created SQL Server Reports based on the requirements using SSRS 2014/2012.
  • Involved in analysis of Report design requirements and actively participated and interacted with Team Lead Technical Manager and Lead Business Analyst to understand the Business requirements.
  • Experience in Modeling and designing SSAS Analytics Multidimensional cubes.
  • Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
  • Responsible for developing and maintaining Tableau dashboards.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created multiple reports with drop down menu option having complex groupings within the report.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
  • Worked in Agile/Scrum Methodology with daily stand up meetings and vast knowledge in TFS (Team Foundation Server) 2010. Execution of SQL queries to extract data from DB2 tables for running test scripts.
  • Performed Testing, Debugging and Migrating ASP.Net Website from Visual Studio 2005 to Visual Studio 2010.
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle).
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Environment: MS Access 2007, MS SQL Server- 2014/2012/2010/2008 R2 Enterprise Edition ANSI SQL, Visual Studio 2008, ETL, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin

Confidential, Seattle, WA

Business Intelligence Developer

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
  • Managed customer expectations for project outcomes to ensure full understanding of risks, trade-offs and scope alterations. Developed User Defined Functions for giving Scores and views for the application.
  • Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database. Involved in identifying the project stakeholder goals and defining project scope.
  • Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Maintained Batch logging, Error logging tables and handled errors using Event handlers.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes. Identified business objectives and the corresponding business requirements.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Created Roles for SSAS Tabular Model provide additional Security at the row-level by using row-level filters Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. Created Business Use Cases and corresponding Atomic Use Cases.
  • Designed Perspectives and Hierarchies in SSAS Tabular model. Writing complex DAX functions in Power Pivot.
  • Deployed Power Pivot model to SQL server Analysis services tabular instance.
  • Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS. Formatted the reports using the Global variables and expressions.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler. Used various sources to pull data into Power Pivot model.
  • Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future .

Environment: MS SQL 2008/2012, T- SQL, PowerPivot, MS Excel 2007/2010, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS)

Confidential, Kansas City, KS

SQL Developer/ SSIS Developer

Responsibilities:

  • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2008 environment.
  • Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database. Involved Automation of Back Office project and Migration of SQL.
  • Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
  • Developed application for business to create Internal Rate of Return (IRR) reports for Private Equity using C#.net plugin for Excel, Excel and Access VBA and SQL Server.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Maintained Batch logging, Error logging tables and handled errors using Event handlers.
  • Created SSAS Cubes and Dimensions and defined the d Relationships with the measure groups and fact tables. Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Involved in designing Partitions in Cubes to improve performance using SSAS and implemented calculations to aggregate physical measures. Formatted the reports using the Global variables and expressions.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Create Net Asset reports and charts in Excel using VBA.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once
  • Perform reverse engineering in existing legacy financial applications written in Excel and Access VBA to analyze the impact of huge data source migration project coming forth.
  • Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Environment: MS SQL Server 2008R2, MS Excel 2010/2007, MS Excel 2010/2007, MS Access 2010/2007, Microsoft SQL Server Reporting Services (SSRS) 2008R2, Microsoft SQL Server Analysis Services (SSAS) 2008R2, MSSQLServer 2008 Management Studio, SQL Server Business Intelligence Development Studio, Windows server, Star Team Version Control tool)

Confidential, San Francisco, CA

MS SQL Developer

Responsibilities:

  • Implemented Complex business logic with User-Defined-Functions, Index Views and created User Defined Data type, Clustered & Non-clustered Indexes
  • Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases.
  • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
  • Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards. Managed database portioning across multiple disks.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases. Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards.
  • Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties. Knowledge of Database Performance monitoring tools.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
  • Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
  • Created SSIS packages to retrieve data from Legacy sources and to retrieve user data from the Flat files on monthly and weekly basis. Created ETL SSIS packages both design and code to process data to target databases.
  • Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
  • Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
  • Created jobs to collect status information from various servers and feed them to the Master Server.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc. Implement automated Index Maintenance strategy run as SQL Jobs daily.
  • Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server. Resolving any dead locks issues with the Databases/Servers on a real-time basis.
  • Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor. Created Snapshots, Subscriptions and Transactions using Replication services.
  • Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio

Confidential

SQL Developer

Responsibilities:

  • Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
  • Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases. Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
  • Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
  • Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor. Provided and defend conclusions and recommendations to customer based on results of analysis.
  • Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
  • Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
  • Assisted organization in performing data compilation, mining and analysis required to evaluate the given data.
  • Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.
  • Research, investigate key business problems through quantitative analyses of utilization, health and cost data.
  • Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements. Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
  • Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2005/2008, Windows 2003/2007 server, Teradata, ODE, OLTP, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.

Hire Now