We provide IT Staff Augmentation Services!

Sql / Bi Resume

Richmond, VA

Profile:

  • 7+ Years of IT Experience.
  • 7+Years of SQL Server Experience.
  • 4+Years of (SSIS/SSAS/SSRS) Experience

Summary:

  • Over 7+yearsof experience indesign, development & analysisofSQL Server 2005/2008andSQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
  • Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creatingDatabase Objectslike tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
  • Expertise in writingT-SQL Queries, Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Extensive Experience inRDBMSconcepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables andStored Procedures.
  • T-SQL Programming usingDDL, DML, DCLcommands for various business applications
  • Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications
  • Extensive experience in usingSQL Server Profilerto monitor the SQL server fordeadlocks, long running queries and tune the same to improve performance.
  • Evaluated database performance and performed maintenance duties such asTuning, Backup, RestorationandDisaster Recovery.

Integration Services (DTS/SSIS):

  • Proficient in usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, send mail task)and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
  • Experience in buildingSSIS packages (.Dtsx)involvingETLprocess, extracting data from variousflat files, Excel files, legacy systemsand loading into SQL server.
  • Hands on experience working with SSIS, for ETL process ensuring proper implementation ofEvent Handlers, Loggings, Checkpoints, Transactionsandpackage configurations.
  • Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
  • ETL implementation using SQL Server Integration Services(SSIS).
  • Transformed data from one server to other servers using tools likeBulk Copy Program(BCP),Data Transformation Services(DTS) andSQL Server Integration Services(SSIS) (2005/2008).
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages usingSSIS/DTS, Import and Export Data

Reporting Services (SSRS):

  • Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
  • Expertise in designing complex reports likeDrill-Down Reports,Drill-ThroughReports,and ParameterizedReports using SQL Server Reporting Services(SSRS)based onclient requirement.
  • Created variousSSRS Reportsinvolving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
  • Built effective queries for high-performance reports and rendered them toHTML, XML, PDF and Excelformats usingSSRS.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, Form,OLAP and Sub reports, and formatting them.
  • Worked with report manager for deploying the reports across all the environments.

Analysis Services (SSAS):

  • Experience in Designing, Creating,DeployingandProcessing of CubesusingSSAS.
  • Wide experience in creatingOLAP cubes,identifyingdimensions,attributes,hierarchiesand calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
  • Experience inDevelopingandExtendingSSASCubes, Dimensions and data source viewsSSAS-Data Mining ModelsandDeployingandProcessingSSAS objects.
  • Good Knowledge on creatingscorecardsanddashboardsusing MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

Education:

  • Bachelor’s in Information Technology

Technical Skills

Relational Databases

SQL Server 2008/2005/2000, Oracle 10g/9i/8.0, MS Access, DB2,MS Excel, DB2, Teradata, Sybase.

Tools and Packages

SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, Lite speed, MDX, Visual Studio .Net, ProClarity, DB Pro, Visual Source Team Foundation

Languages

T-SQL, PL/SQL, V.B6.0, MDX, C, C#, ASP.Net, VB.Net.

Operating Systems

Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies

HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages

MS Office, MS Outlook (Microsoft Office Suite)

BI Tools

SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

Professional Experience:

Confidential, Richmond, VAJan’11 – Till Date
SQL / BI Developer

Responsibilities:

  • Designed theFunctional Requirements andMapping Technical Specificationson the basis of Functional Requirements.
  • CreatingDatabase objects– Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Design and implementation of Security Model, Policies andProcedures.
  • Performingquery plansand making sure each and every query is using appropriate useful Indexes
  • Creating and ModifyingT-SQL Stored Procedures/Triggersfor validating the integrity
  • Used Performance Monitor andSQL Profilerfor Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Deployed thecreated SSIS packagesin Development and Testing environments.
  • UsedSSISto create ETL Packages to validate, extract, transform and load data todata warehouse databases, data mart databases
  • Generated packages using different Transformationslike Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script componentand etc
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
  • VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package
  • Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in usingReport Designeras well asReport Builder.
  • Developedcustom reportsand deployed them on server usingSQL Server Reporting Services (SSRS).
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Drill-down, Parameterized and Sub-Reports using RDL.
  • Designed and developed Datamart using SSAS.
  • BuildCubeson Enterprise Date Warehouse (EDW).
  • Analyzed and created MultidimensionalCubesinFacts and Dimension TablesusingSSAS.
  • Scheduled Backups and performed Restore operations for system test data.

Environment:MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, C#.net.

Confidential, Sun Prairie, WisconsinNov’09 –Dec’10
SQL / BI Developer

Responsibilities:

  • Migrated datafrom SAS environment to SQL Server 2005 via SQL Server Integrated Services (SSIS).
  • Developed, deployedandmonitored SSIS Packagesincluding upgrading DTS to SSIS.
  • CreatedDatabases, Tables, Views, Indexes.
  • Wrote complexstored procedures, queries,triggers.
  • Managed index, statistics and optimizing queries by using execution plan.
  • Responsible for transferring the data using SSIS packages.
  • Gathered user requirements.
  • Developed Analysis Services Project.
  • Responsible for Dimensional modeling.
  • Studied the existing OLTP system(s) andCreated facts, dimensions and star schema representation for the data mart.
  • Responsible for identifying and definingData SourceandData Source views.
  • Created cubesand defined the dimensions.
  • Responsible for Understanding the world scope data feed, help design the
    target schema and develop an ingestion feed process using SSIS.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes
  • Involved in theSSAS storageandpartitions, andaggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL.
  • CreatedDimensionswith thecube wizardand also individually and Generated Named calculations and named queries.
  • Designed dimensional modeling with star and schema flakes Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
  • Experience in creatingAd-hoc reports, data driven subscription reports by usingReport BuilderinSSRS.
  • BuiltDrill Down,Drill through,linked and subreportsusingSSRS 2008.
  • Documented alldatabase objects and packagesfor future references.
  • Educated team on load process and data movement changes.
  • Analyzed and designed of software and database solutions.

Environment:MS SQL Server 2005, MS SQL Server 2000, , MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C# Oracle, T-SQL, Query Analyzer.

Confidential, KY Jun’08- Oct’09
SQL/BI Developer

Responsibilities:

  • Createdtables, views, stored procedureas per design needs.
  • Maintaineddata integrityby performing validation checks.
  • Optimized queriestuned and monitored server performance.
  • Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
  • Monitored performance and optimize SQL queries for maximum efficiency.
  • Importeddata from various sources into astaging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
  • Developed, monitored and deployed SSIS packages.
  • UtilizedSSIS(SQL Server Integration Services)to produce a Data Martfor reporting.
  • ImplementedSSIS data transformationscripts, created maintenance procedures and provided data integrity strategies.
  • Responsible forcreating the reportsbasing on the requirementsusing SSRS 2008.
  • Identified the database tables for defining the queries for the reports.
  • Gathered business requirements, definition and design of thedata sourcing and data flows, data quality analysis,working in conjunction with the data warehouse architect on the development of logical data models.
  • Deployed the generated reportson to the server.
  • Assisted in migratingdenormalized reportDB into aStar Schema design.
  • Actively supported business users for change requests.
  • Administeredand enhanced SQL Server Integration Services (SSIS) data loads.

Environment:MS SQL Server 2005, MS SQL Server 2000, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), MS Access, SQL Server Configuration Utility, SQL Query Manager, MS Visual SourceSafe, Windows XP, VB,C# Oracle , T-SQL, Query Analyzer.

ConfidentialJan’07 –May’08
SQL Server Developer

Responsibilities:

  • Worked as a developer on databases like MS SQL Server 2000, MS Access.
  • Tested to optimize theStored Procedures and Triggersto be used in production.
  • Maintained client relationship by communicating the daily status and weekly status of the project.
  • Designed and implemented theLogical and Physical modelof the database.
  • Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
  • CreatedDatabase Objects– Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
  • Developed complexT-SQL codefor the application.
  • Installed and maintained MS SQL Server 2000.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Implementedfine-tuningof database objects and server to ensure efficient data retrieval.
  • Managed and monitored the use ofdisk space.
  • Planned Backup strategy based on projects requirements.
  • Maintained the consistency of the client’s Database using DBCC.

Environment:MS SQL Server 2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.

ConfidentialMar’05 – Dec’06
Database Developer

Responsibilities:

  • Active participation in thebusiness requirementmeetings with the client
  • Created a Database and normalized the database into small tables by applying rules ofNormalization, definedCheck Constraintand applied Business Rules.
  • Written Complex and ExtendedT-SQL Stored Proceduresfor application developers and some User Defined Functions.
  • CreatedDTS Packagesfor transferring data from various sources like Oracle, MS Access, and Excel.
  • Created DTS Packages to pull data from Oracle and Flat files.
  • Handling database objects with Enterprise Manager and Query Analyzer.
  • Created After and Instead ofTriggersto enforce data consistency and referential integrity.
  • CreatedViews, Parameterized Views, Partitioned Viewsand Indexed Views.
  • CreatedClusteredandNon Clustered Indexeson tables, views, and columns
  • Developedstored procedures,triggersandfunctionsand added/changed tables for data extraction ,transformation and loading
  • Configured Server for sending automatic mails to the respective people when aDTSprocess failure or success.
  • Performeddata conversionsfrom flat files into a normalized database structure.
  • Generated reports by using Crystal Reports and Excel spreadsheets
  • Actively involved in improving System Performance by tuning SQL queries and stored procedures by using SQL Profiler, and Index Tuning Wizard.
  • Analyzing the Database Growth and Space Requirements. Handling Users, Logins or User Rights.

Environment:SQL Server 2000, DTS, Access, Excel, SQL Profiler, Import & Export Data, Windows 2000 Server.

Hire Now