We provide IT Staff Augmentation Services!

Sql Server/ Ssis/ Ssrs/etl Developer Resume

Scotts Valley, CA

PROFESSIONAL SUMMARY:

  • Highly motivated SQL server Developer with around 8+ Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development, Data Analysis and Reporting using SQL Server 2016/2014/2012/2008 r2, SSRS and SSIS.
  • Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Performance Tuning, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2016/2014/2012/2008 r2.
  • Experienced working in Agile and Waterfall Methodology with Scrum call and Daily Standup meetings.
  • Experienced working in Data Migration, Data Warehousing projects and performed many GAP analyses between source and target systems.
  • Hands on experience working with many sources like Flat File, Excel,, XML, SQL Server, Oracle, Teradata, PostgreSQL, MySQL, SAP BW, SAP SD, DB2 and AS400.
  • Proficiency in Database design, Coding and Implementation. Hands on Experience in optimizing the queries by creating various clustered, non - clustered indexes and indexed views.
  • Experienced working on data migration from Access, Legacy SQL and SAP to Centralized BI solution implemented in SQL Server.
  • Worked on Creating Dashboards using QlikView/ Qlik Sense using different data sources like Oracle, SQL Server, QVD files, text files, excel and generated adhoc Qlik Sense Apps as per the user requirement.
  • Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs), Ranking Functions and Complex Queries on Microsoft SQL Server 2016/2014/2012/2008 r2.
  • Knowledge of QlikView Server, QlikView Publisher, and QlikView Enterprise Version.
  • Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column. Extensive knowledge in Tuning T-SQL queries to improve the database performance Wrote VB.Net code for various SSIS Packages.
  • Proficient in the use of majority of the SSIS transformations, Containers, Tasks, migration of data from various source DB’s like, Access, Excel, Flat File to SQL Server 2016/2014/2012/2008 r2 package configurations, logging, checkpoints, master and child packages, package deployment, variables and expressions, error handling and troubleshooting.
  • Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing reports in SSRS.
  • Integrated .Net with SSRS reports and integrating them with SQL server Database. Possessed excellent skills in Data Modeling to create Star and Snowflake Schemas using Erwin.
  • Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS), which make use of multiple value selection in parameters, pick list, cascading prompts, matrix reports, Drilldown reports, Drill through Reports, Adhoc Reports, Parameterized reports, Sub reports and filters, charts in SSRS.
  • Expertise in generating reports using SSRS and Microsoft Access & Excel.
  • Experienced in creating dashboards using PowerBI.
  • Work with different version controls such as TFS and worked in an agile environment.
  • Confident in work independently and proactively. Strong leadership, good communication and excellent interpersonal skills, problem-solving and multi-tasking abilities.
  • Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure

TECHNICAL SKILLS:

Servers/Databases: MS SQL Server 2016/2014/2012/2008 r2, MySQL, SAP BW, DB2, Oracle

OS: Windows XP/7/8/10, Linux/Unix.

Tools: /Environment: Microsoft Visual Studio, MS-Office, Microsoft SQL server Management Studio, MS-Access, Outlook, Power BI, Tableau, Erwin Tool, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler, MS Visio, MS Excel, Agile

Language: TSQL, ORACLE, MYSQL, SAS, C#, HTML, .net

PROFESSIONAL EXPERIENCE:

Confidential, Scotts Valley, CA

SQL Server/ SSIS/ SSRS/ETL Developer

Roles & Responsibilities:

  • Participated in requirement gathering and understanding business/functional requirement.
  • Prepared data dictionary, data mapping document by doing reverse engineering on existing Access database to maintain business rule required for data migration to new data warehouse solution.
  • Wrote several script for data profiling and performed GAP analysis between current and proposed solution.
  • Participated in the full life-cycle development process from definition and design to production delivery.
  • Participated in daily stand up and scrum calls for daily project updates to achieve biweekly deliverables.
  • Developed Complex SQL queries to support many adhoc request and excel reports. Developed T-SQL objects such as stored procedures, Views, triggers and user-defined functions for DML operations.
  • Identified weaknesses in T-SQL code and then improved those weaknesses for future release.
  • Created unit test cases and technical documentation, perform detailed code reviews, and create automated build, data Analysis and deployment.
  • Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Exception Handling & Reject Recycling, Data Lineage, ETL Auditing, etc.
  • Transferred data from various data sources/business systems including MS Excel, Flat Files to SQL Server using SSIS various features such as multicasting, conditional split, union all, merge, lookup, fuzzy lookup, data conversion, Derived Column.
  • Configured SSIS packages using configuration wizard to allow packages run on different environments.
  • Deployed SSIS packages using new SSIS DB catalog features like Project and Package Deployment.
  • Deployed SSIS packages using file system deployment methodology to simplify deployment for production admin teams.
  • Implemented customer error handling using scrip component and .Net scripting in SSIS for job success and failures.
  • Created SSIS package templates for Historical and Delta loads for data mart load from various sources.
  • Implemented custom audit functionality to manage ETL audit for performance monitoring, schedule and data delivery on time.
  • Analyzed data requirements for the business applications; Developed data models and planned data migration/conversion strategies for internal and externally hosted applications.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Performed quality checks on reports and exports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.
  • Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer
  • Created complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
  • Migrated the existing MS Access reports to SSIS/SSRS and developed new SSIS/SSRS packages to meet business needs.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Expert on creating multiple kinds of Power BI Reports and Dashboards.

Environment: SQL Server 2016/2014, SSRS, SSIS, Visual Studio Team Foundation Server (TFS), Agile, Windows 10, MS Excel, and MS Access, Tableau, Power BI, Erwin, Oracle, C#, .Net

Sr. SQL Database Administrator

Confidential - Clearwater, FL

Roles & Responsibilities:

  • Implemented custom Maintenance jobs-schedule to run daily and on weekends (tasks like rebuilding. Indexes, defragmenting Databases, Shrink Database, and Database complete backup)
  • Migrated SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
  • RAC database configuration & day to day maintenance activities.
  • Migration of SQL Server 2005 to SQL Server 2008R2, SQL Server 2008/2008R2 to 2012.
  • Implemented SQL Server 2012 new features like Always on Availability Groups for high availability of multiple databases in place of database mirroring.
  • Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
  • Setup and configured Always on Availability Groups for DR and Reporting.
  • Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using PowerShell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
  • Responsible for installing SQL Server on the new build Standalone and Clustered servers .Disaster Recovery for critical database with compliance for HIPPA
  • Monitored strategies, processes, and procedures to ensure data integrity; optimized/reduced data redundancy; maintained required level of security for all production and tested database
  • Hands on experience in Install, Upgrade, Migration, Performance Tuning, Patching in all SQL Server 2008/2008R2, SQL2012/2014 and SQL Server 2016 etc.
  • Troubleshot day-to-day problems encountered on production databases and custom application issues .Proficient with infrastructure automation techniques using PowerShell
  • Provided strategic direction for the database team and functioned as the technical/project leader on projects.
  • Solid Knowledge and hands-on experience with Microsoft Azure (compute, data management, identity & access, mobile services, backup, messaging & integration, networking, storage, monitoring, custom apps, security etc.)
  • Knowledge of NOSQL and MONGODB databases
  • Migrating On-premises SQL databases to Azure cloud VM and Azure SQL
  • Configured and implemented detailed monitoring of the MS Azure cloud networks, monitoring all the different fabric of Azure.
  • Created public, private & hybrid clouds based upon Microsoft Azure technology for JRI America in different continents.

Environment: MS SQL Server 2014 Enterprise Edition, SQL Server 2014,sql server reporting services, sql server integrating services, SAP BW, T-SQL, Erwin, MS Excel, MS Access,C#,.Net, Power BI.

Confidential

SQL Server/ SSIS/ SSRS/ETL Developer

Role & Responsibilities:

  • Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2014.
  • Developed and maintained data lineage in existing ETL data flow.
  • Developed crosswalk between SAP BW and SQL Database tables to maintain mapping between two different systems required for data migration project.
  • Developed ETL to extract data from SAP BW system using mySAP business suite, which is data provider for SAP using parameters for Connection and Login details.
  • Strong understanding on SAP data warehousing concept and SAP data structure for data integration to SQL BI applications.
  • Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, Ranking Functions, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.
  • Implemented the Error handling in the Stored Procedures and SQL Objects and modified already existing stored procedures, triggers, views, indexes depending on the requirement.
  • Involved in query optimization and tuning stored procedures for better performance.
  • Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SQL Server Integration Services, Bulk Copy Program, and BULK INSERT etc.
  • Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server.
  • Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
  • Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS.
  • Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
  • Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.
  • Involved in creating ad-hoc reports Using Report Builder.
  • Identified and worked with Parameters using complex expressions for parameterized reports in SSRS.
  • Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Developed Power BI reports and dashboards from multiple data sources using data blending
  • Developed SQL queries/scripts to validate the data such as checking duplicate, null values, truncated values and ensuring correct data aggregations
  • Explored data in variety of ways and across multiple visualizations using Power BI, Strategic expertise in design of experiments, data collections, analysis and visualization.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
  • Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: MS SQL Server 2014 Enterprise Edition, SQL Server 2014,sql server reporting services, sql server integrating services, SAP BW, T-SQL, Erwin, MS Excel, MS Access,C#,.Net, Power BI.

Confidential

SQL Server/ SSIS/ SSRS/ETL Developer

Roles & Responsibilities:

  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
  • Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
  • Successfully migrated data from multiple Heterogeneous/Homogeneous Environments into SQL Server 2008 using BCP (Bulk Copy Program), Bulk Insert and SSIS Packages.
  • Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and Involved in extracting the data using SSIS from OLTP to OLAP.
  • Created stored procedure, Views, Cursors and functions to support application.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
  • Created and implemented complex SSIS package to migrate data from multiple data sources.
  • Created SSIS package to extract, validate and load data into Data warehouse.
  • Extensively worked on creating SSIS packages and have used For each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.
  • Created Event Handlers for SSIS package on Error, on Post execute.
  • Developed custom interface for executing and managing SSIS packages.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Involved in design, programming, deploy and Unit Testing of requested Reports.
  • Used Lookup transformation in SSIS to get the data from reference data sets.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
  • Created parameterized, Drill down and Drill through reports in MS SQL environment using SSRS.
  • Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also, automate deployment for SSRS reports for all the environments.
  • Involved in data warehouse development environment using Microsoft DTS, SSIS, SSAS technologies and developing system Entity Relational (ER) diagrams.
  • Improved performance for excel summery reports.
  • Implemented multiple grouping into several reports using visibility and toggle options.

Environment: SQL Server 2012 Enterprise Edition, SSRS, SSIS, Visual Studio 2012, Windows 7/8, MS Excel, Oracle 10g and MS Access, Excel, XML.

Hire Now