We provide IT Staff Augmentation Services!

Sr. Sql Bi Developer Resume

Miami, FL

SUMMARY:

  • 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008R2 /2005/2000 with various business domains like Healthcare, Insurance, Finance and etc.
  • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2008.
  • Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions, synonyms, collections, Exception handling, Query Tuning using query optimizer.
  • Experience in writing T - SQL objects, stored procedure in SQL Server 2005 to SQL Server 2008.
  • Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
  • Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
  • Successfully implemented indexes on tables and views for optimum performance tuning .
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
  • Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked Extensively on ETL process using SSIS packages.
  • Excellent 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.
  • Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
  • Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
  • Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 Databases.
  • Migration of SSRS reports from SQL 2005 to SQL 2008. Migration experience with DTS to SSIS 2008. Extensive experience with data modeling techniques, logical and physical database design.
  • Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports and formatting them using both SSRS 2005/2008.Very good knowledge in scheduling and deploying reports on report manger.
  • Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Good communication with the project team throughout all stages of design, managing time effectively, and work on multiple project timelines simultaneously in a demanding deadline driven environment.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012, 2008 R2, 2008/2005/2000, Oracle 8i/9i/10g, MS-Access 97-2007

ETL Tools: SQL Server Integration Services (2005/2008), Data Stage, DTS

OperatingSystems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 8/10

Programming languages: C#, C, C++, VB.NET, Visual Basic for Applications (VBA) and ASP.NET.

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Sr. SQL BI Developer

Responsibilities:

  • Created database objects like tables, complex Stored Procedures, Functions, Views, Triggers, Indexes and T-SQL queries (DDL and DML) to meet the business requirements using T-SQL.
  • Created Joins and sub-queries for complex queries involving multiple tables.
  • Used DDL and DML for writing Triggers, Stored Procedures, and Data manipulation.
  • Involved in writing SQL Stored Procedures to access data from MS Access. Developed SQL queries to check the database.
  • Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
  • Pulling the data from T-SQL stored procedure to make the parameterized reports.
  • Hands on MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC using SQL Server Profiler, Execution Plan and Performance Monitors.
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
  • Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 Databases.
  • Experience in providing Logging and Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS) version.
  • Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
  • Used event handlers for accepting handling in SSIS packages. Involved in scheduling and administering the SSIS packages .
  • Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow of SSIS package.
  • Backing up, Restoring system & other databases as per requirements, and also scheduled those backups.
  • Developed Query for generating drill down, drill through, parameterized, cascaded reports in Crystal Reports 2011.
  • Worked on SQL Server Reporting Services (SSRS) and Report Builder Model to generate custom reports.
  • Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
  • Created and Managed OLAP Cubes using SSAS.

Environment: : SQL Server 2012, T-SQL, Crystal Reports 2011, MS SQL Server Integration Services (SSIS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling. ASP.NET Framework 3.5/4.0, C#, Visual Studio 2012, AJAX, WCF, ADO.NET,

Confidential, Austin, TX

Sr. SQL BI Developer

Responsibilities:

  • Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
  • Extensively used joins and sub queries to simplify complex queries involving multiple tables. Developed views using complex split week logics.
  • Performed Data Modeling in the initial stages of the project.
  • Worked in AGILE methodology using SQL Server 2008 R2.
  • Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
  • Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
  • Successfully implemented indexes on tables and views for optimum performance tuning .
  • Involved in query optimization and performance tuning.
  • Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
  • Implemented error handling in several existing Stored Procedures using Try Catch blocks.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
  • Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
  • Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
  • Handled complex financial data and large databases.
  • Used ADO.NET for retrieving, querying, storage, and data manipulation.
  • Implementation of client side validations using ASP.NET validation controls.

Environment: : SQL Server 2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling, ASP.NET, C# 3.5/2.0, .NET Framework 3.5/2.0.WebService, ADO.NET, HTML, CSS,

Confidential, Livingston, NJ

Consultant, Operations SQL/SSIS Developer

Responsibilities:

  • Actively participate in gathering of user requirement and system specification.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and SSIS.
  • Increased query performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process. Indexed views, dimensions and stored outlines for optimal performance.
  • Check the performance of each and every query using SQL Profiler, Index Tuning Wizard and Estimated query plan optimize the performance tuning of SQL queries and stored procedure.
  • Created partition table for very large database for good performance.
  • Reviewed and developed data models and database designs with development teams.
  • Backups and Restoration / Database Recovery, Resource allocation / Monitoring
  • Involved in Data Migration from SQL Server 2000 to SQL Server 2005 Databases.
  • Deployed SSIS packages and Reports to Production Servers.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
  • Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS ).
  • Reported all events and requirements through established reporting mechanisms in SSRS.
  • Designed and developed OLAP using MS SQL Server Analysis Services
  • Created complex business components in C# using .NET Class Library assemblies while migrating and implementing them in a multi-tier environment suitable for .NET Remoting, XML Web Services, Microsoft Transaction Server (MTS) and COM+ to address application infrastructure issues associated with building scalable enterprise level applications for multiple clients.

Environment: SQL Server 2008 R2/ 2008/2005/2000, Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2000/2003 Server, Visual Basic .Net, SQL Server Data Tools, Query Analyzer, SQL Server Profiler

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

  • Installation, configuration of MS SQL Server 2005/2008.
  • SQL server Upgrade from 2005 to SQL 2008.
  • Designing and creation of tables and stored procedures with E-R diagrams.
  • Merging 2 different versions of databases to one single database and upgrading to SQL 2008.
  • Designed the Dimensional modeling of the Data warehouse using Erwin.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
  • Extensively involved in designing (Logical and Physical) of customer database.
  • Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
  • Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
  • Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
  • Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases.
  • Ensured developers coordinated their efforts in managing and maintaining different application databases.
  • Reduced systems downtime risk through automatic offsite backup and recovery over network.
  • Data Warehousing using Data Transformation Services Package (SSIS).
  • Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Environment: MS SQL Server 2005/2008, Windows 2003 Server, SQL Query Analyzer, SSIS, TSQL, C#,ASP.NET.

Confidential, NJ

SQL Server BI Developer

Responsibilities:

  • Gathered Functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
  • Actively involved as a part of a team for gathering and analyzing the User Requirement.
  • Modified existing database to fit new business requirement by adding tables and relationships.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Upgraded SQL Server 2000 databases to SQL Server 2005.
  • Managed the legacy data in the data warehouse from various data sources.
  • Created Indexed View to optimize query performance by facilitating easy user interface implementation.
  • Created Linked Server to retrieve data from other databases.
  • Worked on SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server.
  • Documented different Stages of Data Transformation, procedures and scripts.
  • Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
  • Performed Backups and Restore of the databases.
  • Upgraded DTS Packages to SSIS Packages.
  • Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
  • Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
  • Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
  • Created jobs using SQL Server Agent and generated SSRS (SQL Server Reporting Services) reports as a part of each job.

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, T-SQL, DTS, BIDS, SSIS, SSRS.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in Physical and Logical design of the databases.
  • Developed DTS Packages to transfer the data between SQL server database and files.
  • Created and maintained Data Transformation Service (DTS) packages for migrating data.
  • Scheduled Jobs for DTS packages.
  • Used BCP/Bulk Insert to publish table output to text files.
  • Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
  • Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
  • Used all Declarative Constraints for maintaining Data Integrity.
  • Created Views to restrict access to data in a table for security.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Implemented Auditing using triggers.
  • Created schema objects, rules and granted roles to the users.
  • Used SQL Profiler to debug T-SQL and slow running queries.
  • Monitored the Database Performance using execution plans and Index tuning.
  • Optimized the query performance with modifications in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.
  • Involved in scheduling backups of databases and logs and restoring them when necessary.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 server, Windows NT 4.0.

Hire Now