We provide IT Staff Augmentation Services!

Sql/etl Developer Resume

Charlotte, NC

PROFESSIONAL SUMMARY:

  • Around 7 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2008/2012/2014 in Development, Test and Production Environments on various business domains like Financial, Healthcare, Insurance and Manufacturing.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server2005/2008R2/2012/2014.
  • Expertise in SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services(SSAS).
  • Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks) and worked extensively on ETL process using SSIS package.
  • Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SSIS
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
  • Successfully extracted Data from Different Databases like Oracle, DB2, and Sybase, Teradat platforms.
  • Experience in using T - SQL in SQL Server 2005/2008/2012 and 2014 platforms.
  • Experience in Performance Tuning and Query Optimization.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • 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 .
  • Strong Knowledge on concepts of Data ModelingStar Schema/Snowflake modeling, FACT&Dimensions tables and Logical & Physical data modeling.
  • Extensive reporting experience using Crystal Reports andParameterized Reports .
  • Well Experienced in Generating parameterized reports in SSRS 2012/2014.
  • Developing reports on SSRS on SQL Server (2005/ 2008/2012/2014 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS and Cognos Reporting.
  • Designed the functional and technicaldocuments, reporttemplates and reportingstandards for the developers to work on the reportdevelopment.
  • Well versed in Performance Point Server 2010. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
  • Excellent working knowledge of Data Mining Models (Classification, Association Rule Mining, Clustering, Genetic Algorithms)
  • Extensive experience using Data Mining tools Microsoft Analysis Services.
  • Good Knowledge and experience on SharePoint.
  • Experience in .NET framework and handling events in C#.NET
  • Experience in working with variables, functions, objects in C#.NET
  • Performed Database Search and Query Strategy design, implementation and optimization.
  • Responsible for software implementations, upgrades, configuration, support and day-to-day maintenance of various clinical and non-clinical hospital applications.
  • Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a Good team player.
  • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

SQL Server Tools &Packages/BI tools: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, MDX, ETL, SSIS, SSAS, SSRS, Micro strategy, Erwin Data modeler, IBM Rational Rose, Crystal Reports 11, Tableau.

Languages: T-SQL, My SQL, VB.NET, C# ASP. NET, HTML, XML, C/C++, CSS, DHTML

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2008R 2/2008/2005/2000

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)

Scripting: Shell Scripting

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2010/2012, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0, CSS, HTML, XML, ASP.Net

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.

Other Software: MS Office 2007/2003/2000, Adobe Professional, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SQL/ETL Developer

Responsibilities:

  • Provides analytical support in EIT activities related to multiple Compliance Control Functions.
  • Gathers and organizes the data in order to track, report and monitor the effectiveness of controls and the tracking, monitoring and escalation of the risk related issues to management.
  • Investigates data attributes within the various operational and reporting databases.
  • Builds logics for automated data extraction and validation for EIT testing.
  • Created ETL packages using SSIS to extract data from relational database and then transform and load into testing platform like Triton.
  • Debugging multiple SSIS packages to migrate data from heterogeneous sources and converting the data to upload into testing environments.
  • Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files.
  • Coordinated with front-end for implementing logic in Stored Procedures and functions.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Involved in code review, writing Unit test case, creating a platform to run the samples and validate these Test cases.
  • Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
  • Work with the standards and regulations of sampling methodologies.
  • Thoroughly documents operating procedures for sampling executions.
  • Worked on the SQL server, DB2, Teradata, Oracle databases to pull the data for testing requested by Control functions.
  • Worked on Production environment and handling day to day transmissions and supporting the development of new tests.
  • Performed validations on the tests to ensure the data which has been pulled is correct.
  • Implemented logics to pull the data from Teradata and Oracle databases.
  • Worked on large complex data sets, formatting and presenting the spreadsheets and have good Knowledge on Excel.
  • Deployed and managed reports on Share point server.
  • Used SharePoint site to request the access for different data sources, databases and many reporting tools.
  • Worked on Teradata SQL Assistant and Toad.

Environment: MS SQL Server 2010, Teradata SQL Assistant, Excel, Toad, DB2, Oracle, Teradata Express Studio, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, SharePoint 2012, Report Builder, MS Access

Confidential, Vancouver, WA

SQL Server /BI Developer

Responsibilities:

  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
  • Created cubes and dimensions and measures and calculated measures according to the business requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Processing the cubes and dimensions on a daily basis using the SSIS tasks.
  • Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
  • Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
  • Performed the task of data transfer from files in remote server to folders in another server using FTP.
  • Created database maintenance plans and deleting of history data using SSIS packages.
  • Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
  • Configured SSRS with MOSS 2010 for directly deploying the report in sharepoint 2010.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Generated tableau dashboards with combination charts for clear understanding.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
  • Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
  • Created SSIS Packages from various data sources.
  • Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
  • Extracting the data from the different sources (CSV files, oracle, and MS SQL 2012) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
  • Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
  • Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
  • Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server
  • Developed reports in SSRS 2012 and deployed reports into SharePoint Server 2010 (MOSS).

Environment: SQL Server 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, SharePoint 2007, Tableau, T SQL, Erwin, Oracle 10g, MS Excel, ASP.NET, ETL, OLAP, MDX.

Confidential, Morrisville, NC

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Gather and discuss the requirement from the client and the business team, devise the architecture and process it with the team for the final output.
  • To manage the offshore team and help them in case of any criticality and issues.
  • Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
  • Implemented end to end Replication for the real time data flow between the SQL Servers.
  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Utilized Sharepoint SSIS/SSRS, MS-Excel pivot reports to demonstrate project status and statistics.
  • Facilitated, planned and scheduled Sharepoint content migration for Microsoft TFS (Team Foundation Server).
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files.
  • Run the test cases written for integration and functional testing after the deployment of the databases on the DEVRSA environment.
  • Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
  • Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
  • Created store procedures, views, and tables and generated TSQL script for application.
  • Used Visual Team Foundation server for version control, source control and reporting.
  • Write Complex Queries, stored procedures,Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
  • Fix any bugs arising out of SIT, UAT and any other test process.
  • Involved in code review, writing Unit test case, and creating a platform to run and validate these Test cases.
  • Master deployment tools. Utilize team tools for change management. Advocate for architecture and design concepts that can enhance performance and reduce maintenance costs.
  • Mentor or act as subject matter expert in assigned technologies (e.g.: Octopus, Azure, etc.).
  • Co-ordinate with other Teams and integrate different applications on to common platform.
  • Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Mining models and deploying and processing SSAS objects.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Experience in developing reports using SSRS.
  • Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Advanced extensible reporting skills using SQL Server 2012/2014 Reporting Services (SSRS).
  • Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective.
  • Developed a High-level dashboard using SSRS 2012/2014.
  • Experienced in Designing stylish report layout.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012/2014.
  • Used Performance Point Server to identify KPI ‘S, build score boards, reports and dash boards.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports through Cognos Reporting.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.
  • Defined Key Performance Indicator metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.
  • Involved in designingWeb based ASP.NET applications.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Involved in upgrading from SQL Server 2000 to SQL Server 2005/2008.
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database.
  • Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
  • Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.

Environment: SQL Server 2008/2005, Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, MDX,OLAP, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008.

Confidential, Windsor, CT

SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.
  • Created cubes and dimensions and measures and calculated measures according to the business requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
  • Processing the cubes and dimensions on a daily basis using the SSIS tasks.
  • Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
  • Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
  • Performed the task of data transfer from files in remote server to folders in another server using FTP.
  • Created database maintenance plans and deleting of history data using SSIS packages.
  • Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
  • Worked with vb.net developers to create reports which can be accessed by portals.
  • Deployed SSIS packages and Reports to Production Servers.
  • Involved in Migration of SSRS 2008 to SSRS 20012.
  • Deployed Reports using SQL Server Reporting Services (SSRS) and ProClarity.
  • Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
  • Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
  • Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
  • Configured SSRS with MOSS 2010 for directly deploying the report in sharepoint 2010.
  • Generation of reports from the cubes by connecting to Analysis server from SSRS.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Generated tableau dashboards with combination charts for clear understanding.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
  • Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
  • Created SSIS Packages from various data sources.
  • Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
  • Extracting the data from the different sources (CSV files, oracle, and MS SQL 2012) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
  • Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
  • Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
  • Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
  • Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server
  • Developed reports in SSRS 2012 and deployed reports into SharePoint Server 2010 (MOSS).
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
  • Build database queries and test cases for the testing team to test the reports.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
  • Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQLServer 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, SharePoint 2007, Proclarity, Tableau, T SQL, Erwin, Oracle 10g, MS Excel, ASP.NET, ETL, OLAP, MDX.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

  • Installation, configuration the MS SQL Server 2005 and maintenance of servers in various environments.
  • Performance and tuning of SQL servers and application issues related to migration.
  • Testing of applications for performance, data integrity and validation issues.
  • Data Transfers between various servers using BCP and Managing Disk space on NT systems.
  • Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
  • Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
  • Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
  • Administrative and Production support for various applications in all environments.
  • Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2005, Query Analyzer, SQL Profiler, Windows 2005 Server, Import & Export Data.

Hire Now