We provide IT Staff Augmentation Services!

Sql Server Developer/bi Resume

2.00/5 (Submit Your Rating)

Fairfield, CT

PROFESSIONAL SUMMARY:

  • Around 8+ years of IT experience in Database Design, Development and Administration with MS SQL Server 2016,2014, 2012, 2008R2, 2008, 2005.
  • Expert in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2014/2012/2008 R2/2008/2005 databases.
  • Extensive knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Methodologies like Agile, Spiral and Water Fall Model.
  • Personally explored on new features of SQL Server 2016 over 2014 and 2012.
  • Extensively worked on DDL/DML techniques, Common Table Expression (CTE), passing variables to Stored Procedure, looping, Dynamic SQL.
  • Extensively used Joins and Sub - Queries to simplify complex queries involving multiple tables and established relationships between tables.
  • Experience in analyzing execution plan, I/O statistics, index tuning for SQL queries and involved in high transactional database.
  • Designed, Developed Tables, Views and properly maintained relationships using Primary Key and Foreign Key Constraints.
  • Good experience in using popular databases like MS SQL Server, Oracle, Db2, Sybase, and MS Access and worked on integrating data from different File formats (flat files, .CSV, COBOL, EXCEL and XML).
  • Extensive experience and in depth working knowledge in various SQL Server tools and IDE to work with Database, reporting and business intelligence based applications like SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer.
  • Diagnosed performance tuning, query optimization, client/server connectivity, and running database consistency checks using DBCC.
  • Expertise in creating and managing Conceptual, Logical, Physical Data Models, Data Mapping, Data Normalization, databases and data warehouse (OLTP/OLAP) using tools like ERwin, MS Visio.
  • Implemented Third party tools Litespeed, IDERA SQL, Red-gate, SpotLight.
  • Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, Windows scheduler, FTP and SMTP.
  • Experience in design and implementation of OLTP for a high transaction environment, Data Cleansing and Data Migration.
  • Experience in High Level Design of ETL Packages for integrating data using OLE DB and Flat File connection from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations.
  • Proficient in usage of SSIS Control Flow items like ForEach Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task and transformations like Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast.
  • Extensively worked in creating and integratingMicro-Strategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
  • Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP).
  • Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Specialized in creating various types of reports such as Complex drill down and drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
  • Experience in generating reports using SQL Server Reporting Services, Crystal Reports, WEBI Reports and MS Excel spreadsheets and Power Pivot.
  • Extensively used SAS / Macro facility to provide reusable programs that can be conveniently used to update reports.
  • Experience in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Good Knowledge on administrative tasks like Database Backup recovery, Restore (simple, bulk, full), Replication, AlwaysOn Availability, Log Shipping, DTS servers and security management like assigning logins, server, database roles and server permissions.
  • Knowledge in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQLServer Analysis Services.
  • Hands on experience in design and implementation of Database Schema and building Stored Procedures on SQL Azure.

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL/SQL, CSS, HTML, XML,C#.NET,VB.NET

Databases: SQL Server 2014/2012/2008 R2/2008/2005, Oracle 10g/11g/12c, DB2, MS Access, Sybase, Informatica

BI Tools: SSIS,SSAS,SSRS, Crystal Reports, Tableau

Data Modeling: ERwin, MS Visio

Microsoft Tools: Microsoft Office 2013/2010/2007, Visual Studio 2015/2012/2008, TFS

Operating Systems: Windows Server 2012R2/2012/2008R2/2008, Windows Vista/7/8/10

SQL Server Tools: Database Tuning Analyzer, SQL Server Management Studio, SQL Server Profiler, Business Intelligence Development Studio.

Methodologies: Logical and Physical Database Design, Database Design, Agile, Waterfall model, Spiral.

PROFESSIONAL EXPERIENCE:

SQL Server Developer/BI

Confidential -Fairfield, CT

Responsibilities:

  • Involved in the Requirement Analysis, Design phase and Development phase of Agile Software Development Life Cycle model.
  • Managed index, statistics, Tables, and optimizing queries by using execution plan for tuning the database.
  • Experienced in writing complexSQLQueries, Constraints, DDL, DML, stored-procedures, cursors, Common Table Expressions (CTE) and User Defined scalar valued and table valued Functions to implement the business logic making the system more modular, secured and extensible.
  • Extensively worked with T-SQL using temporary tables, table Variables, Pivots, complex scripts and Joins, sub-queries in queries that retrieve data from multiples tables.
  • Created, managed SQL Server AZURE Databases.
  • Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools.
  • Created various reports like Tabular reports and Matrix reports in Power BI.
  • Worked with loading data from different source like DB2, SQL server, XML, flat files and Excel using SSIS.
  • Created package to validate, extract, transformation and load data to centralizeSQLServer using OLEDB providers from existing diversified data source.
  • Working knowledge in Agile/Scrum Environment and used TFS (Team Foundation Server).
  • Developed new database Maintenance plans which involves Create statistics, Update statistics, rebuilding the Indexes, Database Integrity checks for all the newly built SQL Server 2014/2012 servers.
  • Worked with Data Modeling Tools like ERwin, MS access and Microsoft Visio.
  • Development of different types of reports like Parameterized reports, Drill down reports, Snapshot reports and Sub reports.Involved in using Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.
  • Worked with Report builder to build report models for Ad-hoc reports.
  • Set-up Enterprise Gateway and SSAS Connector on Azure VM for Power BI Report Deployments.
  • Defined report layouts for formatting the report design as per the need.
  • Experience in SSIS script tasks, look up transformations and Data flow tasks using T-SQL, C# and Visual Basic scripts.
  • Created report subscriptions and scheduled it for email delivery and network drive delivery options.
  • Troubleshooting and Performance tuning using SQL Profiler, Quest Performance Analyzer and Database Tuning Advisor (DTA) to diagnose historic data as well as current ones.
  • Reduced the usage of blocking transformations such as SORT, PIVOT, and MERGE etc,.
  • Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
  • Used various Query Hits like Hash Join, MAXDOP number of processors and Table Hints like NOLOCK, ROWLOCK.
  • Created Workbooks and dashboards for analyzing statistical billing data using Tableau.
  • Good knowledge over Disaster Recovery planning by configuring Clustering, delivering solution that guaranteed recovery performance and high availability.
  • Extensively used SQL Loader and import/export toolbar to load the data from excel files into Oracle.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS AnalysisServer(SSAS).
  • Created SSRS reports fromSQLServer Analysis Services (SSAS) cubes by implementing MDX scripts for querying the data from OLAP cubes.
  • Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions.
  • Worked with Power BI for creating dashboards, graphs and reports for analysis from different data base sources like SQL, Azure, SSAS, Oracle, and Excel, CSV, text files.
  • Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
  • Performed regular Database Maintenance task, checking the disk Defragmentation procedures in Development environment.
  • Running DBCC consistency checks, and fixing data corruption in databases.

Environment: MS SQL Server 2014/2012, SSRS, Oracle 11g, SSAS,SSIS, Power BI, Database Tuning Advisor, Visual Studio 2015/2013,TFS,ERwin, SQL Server Management Studio (SSMS), Azure, SAS, Dashboards, SQL Profiler, Performance Monitor and Tableau, Windows Server 2012/2012R2 and MS Office, Jira, Git .

SQL Server Developer/BI

MetLife - Greenville, SC

Responsibilities:

  • Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.
  • Used Microsoft Azure infrastructure as a service to build, deploy and administer reports.
  • Optimized the query performance with modification in T-SQL queries and by analyzing Index, Statistics.
  • Used DAX (Data Analysis Expressions) functions for the Reports and Tabular Models
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Increased the performance for statistical reporting by 25% after worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
  • Automated SSIS packages using FTP servers to download the files and load into database on daily basis.
  • Implemented Logging mechanism in packages for various events like pre-execute, post-execute and captured data in SQL Server. Created SSIS Packages using Slowly Changing Dimension Transformation, Lookup, Derived Columns, Condition Split, Execute SQL Task, Script Task, Send Mail Task, Data Flow Task, and Execute Package Task.
  • Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, CSV, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
  • Managedthe up gradation ofDTS packages to SSIS packagesand fillingDimension, Fact tablesintoData WarehouseandData Marts.
  • Worked on Power BI Dashboard to make some changes on behalf of Business requirements.
  • Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.
  • Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
  • Imported the spreadsheet data into the SASusing Proc Import procedure then generate the reports.
  • Extensively worked on MS-SSRS, SSIS and Slowly Changing Dimensions (SCD) for type 1, 2 and 3 for loading and maintaining historical data.
  • Enhancements for the previous iteration Informatica Mappings to load data from Source systems to Staging tables and then to Data Mart.
  • Configured SSRS reports for snapshot and cache settings for increasing report performance.
  • Created action filters, hierarchies, groups, and calculated sets for preparing dashboards and worksheets using Tableau.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Worked on administration tasks like backup (Full/ Differential/ Transactional) & recovery.
  • OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
  • Uploaded their monthly transaction to an Azurebased web portal and then data is evaluated on multiple rules, data analysis is performed and then data is published to private AzureVM IIS based website.
  • Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user accounts and connections/locks etc,.

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS), Power BI, SAS, Database Tuning Advisor, Azure, SQL server Data Tools(SSDT), MS Office, Informatica 9.6, SQL Server Management Studio (SSMS),Dashboards, SQL Profiler, Performance Monitor and Tableau.

SQL Developer/SSIS/SSRS

Confidential - Columbus, OH

Responsibilities:

  • Involved in Installation and Configuration of MS SQL Server 2008R2.
  • Implemented Stored Procedures, Triggers for automating tasks and Views to maintain security of customer data.
  • Improved the Package performance by removing the indexes on the tables before processing and rebuilding the indexes on load of the data.
  • Used Common table expressions (CTE), PIVOTS in complex querying for data retrieval and data manipulations.
  • Worked with SSRS Reporting web services in ASP.NET web and Windows forms applications using C#. NET to generate the reports in different rendering formats such as PDF, EXCEL etc
  • Defined and designed the data sourcing, data flows and data quality analysis.
  • Maintained referential integrity, domain integrity and column integrity by using the constraints.
  • Experience in RDBMS Concepts, Data Mapping, Table normalization, Data Modeling and creating ER Diagrams using MS Visio.
  • Analyzed business requirements and build logical, physical data models that describe all the data and relationships between the data using ERwin.
  • Improved SSIS Package performance by controlling Rows per Batch and Maximum Insert Commit Size to control the Temp database usage and DB Transaction log.
  • Used Package level MaxConcurrentExecutable for concurrent executions to control the threads on the SSIS Task based on the server specification limitations and configured Engine threads in dataflow task.
  • Worked with hierarchical SSRS reports using various levels of Row Grouping and column grouping
  • Worked with conditional formatting and report expressions for dynamic display of SSRS report fields
  • Worked with Data Driven subscriptions by passing report parameters to the SSRS Reports based on the subscription query.
  • Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through RESETLOGS.
  • Created partition function, schema and file groups for fact tables.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and PowerMap to visualize reports.
  • Reduced the SSIS overhead successfully by avoiding unnecessary transformation like aggregate, lookups by using the SQLorder by, TOP, union commands etc. in certain Queries.
  • Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
  • Working experience with SCOM to monitor the Server.

Environment: MS SQL Server 2008R2, SSIS, SSRS, ERwin, Power BI, Microsoft Visual Studio 2008, SQL Profiler, Database Tuning Advisor, C#, ASP.Net, .Net Framework 2.0/3.0 and MS Office.

SQL Server Developer/ ETL

Confidential - Albany, NY

Responsibilities:

  • Experience in collecting the user requirements and documenting by creating use case and flow activity
  • Setting up new MS SQL Server instances and databases.
  • Involved in the migration of SQL Server 2005/2008 to sql server 2008R2
  • Created temporary tables and table variables while creating complex queries in SQL Server 2008
  • Worked on T-SQL programming, user-defined functions, cursors, triggers, views setup and management of linked servers to Non-SQL-Server databases.
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Used joins, sub queries, set operators, string functions, date time functions and several othersqlstatements.
  • Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
  • Deployed SSIS packages in to SQL Server and used command line DTEXEC utility by dynamically passing command line arguments as parameters to the SSIS Package during runtime
  • Troubleshooting ODBC driver issues used for migration of data from the Top Speed database to SQL Server.
  • Performed the task of data transfer from files in remote server to folders in another server using FTP.
  • Extensively used various SSIS Objects such as Foreach Loop, Sequence container, File system Tasks in Control Flow Elements and Derived Column, Merge, Merge Join in Dataflow Components.
  • Created indexes for speeding up the querying process and on scheduling Email trigger jobs to raise an alert to download the files when an email attachment triggers the mail box.
  • Involved in debugging SSIS Packages using break points and configured checkpoints.
  • Worked with Bulk copy program (BCP) using BCP Utility and loaded large data into staging tables for ETL processing.
  • Developed Report Models usingreport builderand distributed reports in multiple formats using SQL ServerReporting Services (SSRS)inBusiness intelligence development studio (BIDS).
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP using SSIS.
  • Created several SSIS packages to load data from different sources like Oracle, Informix to SQL server database.
  • Monitoring SQL server performance using SQL Profiler to find performance bottlenecks, blocking and deadlocks.

Environment: MS SQL Server 2008R2, SSIS, Microsoft Visual Studio 2008, BIDS, ODBC, Oracle 11g, SQLProfiler.

SQL Developer/SSIS, SSRS

Confidential

Responsibilities:

  • Excellent knowledge of waterfall and spiral methodologies of SDLC.
  • Designed Star Schema and Snow flaked schemas in the process of data modeling using ERwin.
  • Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
  • Created, Maintained databases, tables to support the application with good normalization, indexes to have better performance.
  • Developed Transact-SQL (T-SQL) Queries, User Defined Functions, Views and Stored Procedures.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic.
  • Used Joins and sub-queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
  • Performed software installations and upgrades, monitored database performance, performed capacity planning andSQLServer clustering, managed database quality assurance including database consistency check.
  • Created logins, users in MS SQL Server and assigned proper roles to maintain the security.
  • Generated Reports using Global Variables, Expressions and Functions along with concatenating strings based on the requirements by using SSRS.
  • Optimized code and conducted Performance Tuning in databases by usingSQLProfiler, Database Tuning Advisor based on the requirement created new indexes and updating Statistics.
  • Converted existing Excel based reports and Crystal reports to SSRS reports.
  • Extensively used SSIS transformations such as Lookup, Fuzzy Lookup, Copy Column, Derived Column, Script Task, Data Conversion, Multicast and Conditional Split transformations
  • Maintained Batch logging, Error logging tables and handled errors using Event handlers
  • Developed optimal stored procedures and queries to create data sets for reports.
  • Created Operational Data Store (ODS) and provided the OLAP front end to show Drill Down, Drill through reports using SSRS.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Developed web applications in Microsoft Visual Studio using ASP.Net, C#, SQL Server 2008.

Environment: MS SQL Server 2008, SSIS, SSRS, ASP.NET,C#.NET, Microsoft Visual Studio 2008, Windows Server 2008, Erwin, SQLProfiler, Database Tuning Advisor, SharePoint and MS Office.

Jr.SQL Developer

Confidential

Responsibilities:

  • Involved in installation and configuration of SQL server 2005 on Database Servers.
  • Developed database objects like Tables, Views, User-defined Functions and Triggers to handle complex business rules, history data and audit analysis.
  • Worked with Complex T-SQL queries, Sub queries, co-related sub queries and joins to fetch the data as per the functional requirements.
  • Used Common Table expressions for hierarchical data and complex stored procedures.
  • Created various integrity constraints like Primary Key, Foreign Keys, Unique and Check to support application functionality.
  • Worked with command shell to invoke executables in SQL Stored Procedures
  • Actively participated in gathering of User Requirement and System Specification.
  • Maintained User account administration for Different domains.
  • Involved in creating SQL reports and generating emails through DB Mail.
  • Worked with loading of data from Excel using OPEN ROWSET commands.
  • Creation/ Maintenance of Indexes for fast and efficient reporting process
  • Created SSIS package to load data from Flat files, DB2 by using Lookup, Derived Columns, Data conversions and Condition Split transformations.
  • Maintained the physical Databases by monitoring Performance, space utilization and physical integrity.
  • Generating Reports as per the requirement using SSRS.

Environment: MS SQL Server 2005,Microsoft Visual studio 2005, SSIS, SSRS,DB2,Microsoft Visual Studio 2005, Windows Server 2005, Performance Monitor and MS Office.

We'd love your feedback!