We provide IT Staff Augmentation Services!

Sql Bi Developer Resume

2.00/5 (Submit Your Rating)

West Chester, PA

SUMMARY

  • Around 7 years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of various software applications to support ETL, Reporting and Analysis of data using MS Business Intelligence initiatives.
  • Exceptional hands on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) for 2014, 2012, 2008 R2.
  • Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
  • Possess solid understanding of logical and physical data modeling techniques for both relational and dimensional models.
  • Expertise in scripting T - SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
  • Extensive experience in Performance Monitoring and Tuning of SQL Statements, Sub Queries, Joins and Functions.
  • Well versed in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
  • Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
  • Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
  • Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Experienced in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
  • Better understanding of how to handle environmental related issues and to capture data related errors in custom logging process for SSIS/ETL Packages.
  • Experienced in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
  • Expertise in developing reports using SQL Server Reporting Services and MS Excel spreadsheets.
  • Experienced in creating several types of Parameterized, Tabular, Matrix, Drill-Down, Cross Tab, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) 2014, 2012,2008 R2 in Business Intelligence Development Studio (BIDS).
  • Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
  • Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Involved on administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, File groups, Transaction logs, Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re-Indexing.
  • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
  • Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/2008/2008 R2, Oracle 9i/10g, My SQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, Business Intelligence Development Studio(BIDS) (Data Tools), SQL CMD.

Languages: T-SQL, PL/SQL

Reporting Tools: MS SQL Server Reporting Services (SSRS), Crystal Reports 9.0, OLAP

Change Management Tool: Team Foundation Server (TFS)

Operating Systems: Windows 10.0, Windows 8.1, Windows 7, Windows XP

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

SQL BI Developer

Responsibilities:

  • Involved in gathering business requirements, definition and design of the data sourcing and data flows, data quality analysis.
  • Created Stored Procedures, Functions, Cursors, Tables, Views and used SQL joins for applications in SQL Server 2014.
  • Used SQL Server Integration Services (SSIS) and created complex SSIS packages to validate, extract, transform and load data from various sources (SQL Server, Flat Files, Excel source files, XML files etc.) and mapped the data into destination tables by performing various kinds of transformations.
  • Developed standalone SSIS packages to extract data from various sources like SQL Server, Flat Files, Excel, Oracle, and Sybase transform and load the data onto required databases.
  • Used SSIS transformations and filtered bad data from various sources using Derived Column, Lookup, Fuzzy lookup and Conditional split.
  • Implemented error and event handling: precedence Constraints, Break Points, data grid and Logging in SSIS packages.
  • Involved in creation of Technical Specs, Design Documents, Implementation Documents, and Unit testing/Test case /test plan documents and maintained Issue logs.
  • Created dynamic SSIS packages through Variables and Script task components and scheduled the packages using SQL Server Agent to process and load the data.
  • Scheduled the package based on the Enterprise Calendar through SQL Server Agent. Created several one-time and recurring jobs for package scheduling.
  • Created XML file for package configurations and implemented parent-child package configuration in SSIS packages.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • Used SSRS to develop multiple types of reports which includes Sub Reports, Parameterized and Drill down Reports with global variables, expressions and functions based on the requirements provided.
  • Deployed SSRS .rdl reports on to the report server and created time driven subscriptions on the deployed reports.
  • Resolved and closed production incident tickets generated because of failure of Daily Jobs.
  • Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
  • DevelopedMulti-Dimensional Objects(Cubes, Dimensions) using SSAS 2014.
  • Involved in creating Tabular Cubes using SQL Analysis Services (SSAS).
  • Used Tabular cubes since there are important calculations based on distinct count measures and complex calculations based on many-to-many relationships.
  • DesignedDimensional ModelingusingSSASpackages for End-User.CreatedHierarchiesin Dimensional Modeling.
  • Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.
  • Responsible for Query optimization and Performance tuning. Performing query plans and making sure every query is using appropriate useful indexes.
  • Performed tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Fine-tuning of Stored Procedures to improve performance was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.

Environment: Microsoft SQL Server 2014/2012, SQL Server Integration Services (SSIS) 2014/2012, SQL Server Reporting Services (SSRS) 2014/2012, T-SQL, Windows Server 2008

Confidential, North Carolina

SQL Server BI Developer

Responsibilities:

  • Involved in business analysis and technical design sessions with business and technical staff to develop dimensional models, requirements document, and ETL specifications.
  • Created database objects like Procedures, Functions, Triggers, Indexes and Views.
  • Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
  • Worked with various SSIS control flow tasks and data transformations like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL. Worked with Change Data Capture Task.
  • Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files.
  • Used SQL Profiler to estimate the slow running queries and Database Tuning Advisor for performance tuning purpose.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.
  • Expertise in Deploying SSIS Package to Production and used several types of Package configurations to export various package properties to make package environment independent.
  • Created checkpoints, Break Points and configuration files in SSIS packages.
  • Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.
  • Wrote complex SQL Queries using multiple joins for creating Ad hoc reports using Report builder based on the requirements.
  • Created several types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
  • Published reports in PDF, Excel, CSV formats in the Report Server and saved them to TFS for storing versions and published them in SharePoint.
  • Created subscriptions to provide reports on daily basis. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Actively involved in Normalization & De-normalization of database.
  • Optimized Stored Procedures and long running queries using query-optimization techniques.
  • Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: Microsoft SQL Server 2014/2012, SQL Server Integration Services (SSIS) 2014/2012, SQL Server Reporting Services (SSRS) 2014/2012, T-SQL, BIDS, SSDT

Confidential

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC).
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Involved in upgrading from SQL Server 2008 to SQL Server 2012.
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
  • Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also, implemented checksum SCD method to load the data into data warehouse.
  • Designed and architected OLAP cubes to support business reporting and forecasting processes.
  • Responsible for updating, staging the dimensional database and rebuilt the Dimensions and cubes.
  • Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
  • Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
  • Experience in Designing, building the Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
  • Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
  • Created dash board to show the business performance.
  • Created partitions and designed aggregations and configured security levels for the Cubes.
  • Designed KPI’s in SSAS and imported them to Excel.
  • Calculated measures and dimension members using multi-dimensional expression (MDX).
  • DefinedCalculated members,named sets, and executed other script commandsusingMDX
  • Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
  • Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
  • Developed a High-level dashboard using SSRS 2012.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
  • Developed several types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
  • Defined Key Performance Indicator metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.
  • Problem identification, troubleshooting, resolution, and index tuning of databases.
  • Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
  • Diagnosing and tuning the server optimal performance using SQL Profiler and Database Engine Tuning Wizards.
  • Deployed the databases from old servers to new servers based on the business goal.

Environment: SQL Server 2012/2008R2, SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), SQL Server Integration Services (SSIS) 2012/2008 R2, SQL Server Reporting Services (SSRS) 2012/2008 R2, T-SQL

Confidential

MS SQL Server Developer

Responsibilities:

  • Wrote complex SQL statements using joins, sub queries and correlated sub queries.
  • Involved in creation of data modeling techniques.
  • Analyzed complex queries and tune the same to optimize application and system performance.
  • Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
  • Optimized long running Stored Procedures and Queries for effective data retrieval.
  • Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
  • Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
  • Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.
  • Created reports from database onto excel spread sheet using DTS.
  • Designed and developed monthly, quarterly and yearly reports.
  • Involved in creating maintenance plans in SQL Agent to back up the database.
  • Involved in setting up of SQL Server configuration settings.
  • Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
  • Worked with development teams in the design of physical databases and in modification.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, T-SQL, BIDS, SSDT.

We'd love your feedback!