We provide IT Staff Augmentation Services!

Sr. Sql Server Bi Developer Resume

Winston Salem, NC

SUMMARY

  • 8+ 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 data administration activities for database security (creating logins, users, roles and assigning permissions to them)
  • Experience in performing administration tasks like database files management, backup/restore security management, database mirroring and synchronization.
  • Experience on high availability SQL server solutions, including replication modules (snap shots/transactional) and SQL Server clustering (active-active, active-passive)
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
  • Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). Worked Extensively on ETL process using SSIS packages.
  • Experience in using tools like SCM, VSS and CVS.
  • Experience in using tools like NEXSURE, A tool used for front end access in insurance firms.
  • Proficient in using Team Foundation Server (TFS).
  • Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling using SSAS and Teradata.
  • 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.
  • 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.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
  • Skilled in Analysis Services OLAP cube and view development in SSAS 2005/2008.
  • Experience in using cognos / Microstrategy (business objects) for reporting.
  • Worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema and Entity relationship diagrams from business requirements.
  • 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.
  • Designed business object reporting solutions on top of SAP integration kit: web space intelligence X Celsius and crystal reports.
  • Designed universes from multiple data providers by creating prompts, queries, applied context and aliases to remove loops.
  • Published crystal reports in web based environment using crystal enterprise.
  • Involved inthe designing, development and maintenance of the tracking tools using.net, C#, Visual.net, VB.net, ADO.net and ASP.net.
  • 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

Operating Systems: 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.

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor DTA)

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

Version Control Tools: Visual Source Safe 6.0, Source gear Vault, SVN, and TFS.

PROFESSIONAL EXPERIENCE

Confidential, Winston Salem, NC

Sr. SQL Server BI Developer

Responsibilities:

  • Worked extensively on NEXSURE, Analyzed the client requirements and translate them into technical requirements.
  • Maintained NEXSURE in both development and production environvents.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
  • Proficient in creating queries inTFSto validate results ofTFS reports.
  • Customized Microsoft’s Team Foundation Server according to the company’s requirements.
  • Involved in fine-tuning, trouble shooting performance issues in Stored Procedures.
  • Performance Tuning of SQL queries and stored procedures using SQL Profiler, DTA, DMV’s and DMF’s.
  • Wrote optimized SQL queries in SQL Query Analyzer for efficient handling at huge loads of data.
  • Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
  • Developed standards and guidelines to maintain develop and administrate the SQL Server database.
  • Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
  • Established and documented a complete Disaster Recovery Plan for the Database servers as a proactive team member.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
  • Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
  • Installed and configured report server in Dev and UA environments.
  • Migrated DTS packages to SSIS Packages in 2005.

Environment: SQL Server 2008, NEXSURE, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS),Team Foundation Server (TFS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling.

Confidential, Philadelphia, PA

Sr. SQL Server SSIS/Crystal Report Developer

Responsibilities:

  • Worked in AGILE environment using SQL Server 2012.
  • Worked as team lead for an offshore team from India.
  • 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.
  • Worked on support, resolve any production data quality issues and also supporting any research requests.
  • Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
  • Created and Modified T-SQL stored procedures for validating the integrity of the data.
  • 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.
  • 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.
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
  • Experience in providing Logging and Error handling by using Event Handler and Custom Logging for SSIS Packages.
  • Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow of SSIS package.
  • Hands on using tools like SCM, VSS and CVS.
  • Gathered report requirements and document technical specifications.
  • Pulling the data from T-SQL stored procedure to make the parameterized reports.
  • Formatting the existing reports as well as creating new reports with different sources.
  • Responsible for Full Report cycle including Authoring, Managing, Security and Generation of reports.
  • Worked on database security, Replication and Log shipping activities.
  • Managing the security of the servers, creating the new logins and users, changing the roles of the users.
  • 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 SAP 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.

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.

Confidential, Fort Worth, TX

Sr. SQL Server SSIS/SSRS Developer

Responsibilities:

  • Worked in AGILE methodology using SQL Server 2008 R2.
  • Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints and triggers for data consistency.
  • Performed Data Modeling in the initial stages of the project.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • 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.
  • 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.
  • 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.
  • Experience in writing VB scripts in script component task.
  • 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.
  • Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
  • 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 Store Procedures using Try Catch blocks.
  • Worked in SVN version controlling environment.
  • Handled complex financial data and large databases.

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.

Confidential, Grand Junction, CO

Consultant, Operations (SQL/SSIS/Crystal Report Developer)

Responsibilities:

  • Actively participate in gathering of user requirement and system specification.
  • 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.
  • Backups and Restoration / Database Recovery, Resource allocation / Monitoring
  • 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.
  • Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).
  • Created partition table for very large database for good performance.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • 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.
  • Reviewed and developed data models and database designs with development teams
  • Designed and developed OLAP using MS SQL Server Analysis Services

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 Server/SSIS / SSRS Developer

Responsibilities:

  • Installation, configuration of MS SQL Server 2005/2008.
  • SQL serverUpgrade from 2005 to SQL 2008.
  • Designing and creation oftablesandstored procedureswith 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.
  • 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.
  • Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
  • Database and log backups and restoration, backup scheduling the backups.Backing up master and system databases and restoring them.
  • Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
  • 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.

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

Confidential, Hartford, CT

SQL Server Developer

Responsibilities:

  • Gathered functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
  • Designed and maintained a web reporting environment including portal, dashboards, scorecards and presentations using SQL Server 2005 and ASP.Net.
  • Implemented transactional replication among different servers to have high availability of the data.
  • Created DDL, DML scripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
  • Created views/indexed views consisting of computed columns to facilitate easy user interface.
  • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
  • Done High Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat files, Text Format Data).
  • Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) 2005 that stored and maintained the data.
  • Provided technical guidance and support to end-users by developing documentations required.
  • Performed final verification procedure for SQL release to production environment.
  • Documented all database changes, followed and enforced change and release management processes.

Environment: SQL Server 2005, SSIS, SSRS, SSAS, MS-Excel, DTS, Visual Studio.Net 2005, Windows server 2003.

Confidential, Orlando, FL

SQL Server BI Developer

Responsibilities:

  • 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
  • Upgraded SQL Server 2000 databases to SQL Server 2005.
  • 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.
  • Upgraded DTS Packages to SSIS Packages.
  • Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
  • Created OLAP Cubes and Dimensions and tables using SSAS.
  • 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.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
  • Performed Backups and Restore of the databases.

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

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.
  • 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