Senior Sql Server Etl/bi Developer Resume
Cedar Rapids, IA
SUMMARY
- 8+ years of Professional IT experience as Microsoft SQL Server BI/ETL Developer in diverse Sectors and Experience in Software Development Life Cycle (SDLC) phases like Requirement Gathering, Analysis, Design, Development, Integration and Testing, and Implementation.
- Experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012/2008R2/2005/SQL Server Integration, Reporting & Analysis Services.
- Extensive Knowledge on Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
- Excellent understanding of Relational Database Systems, Normalization, De - normalizing logical and physical data modeling.
- Excellent knowledge in Creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
- Good hands-on experience in using all kinds of SQL Server Constraints, Writing Transact SQL (T-SQL) Queries & Dynamic-queries.
- Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
- Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
- Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
- Experience in migrating DTS Packages from .
- Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
- Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
- Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services
- Experience in administrating the reports and assigning permissions to the valid users for executing the reports.
- Experience in creating Power View reports with the help of Power BI Designer and integrated these reports into SharePoint 2010 server
- Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using ERwin Tool and Microsoft Visio.
- Experience in doing Forward/Reverse Engineering and creating ERwin Data Modeler to a Physical Data Model on the actual SQL Server database and also have experience in doing Reverse Engineering with the help of ERwin tool.
- Extensive experience in creating SQL Server Analysis projects using MS SQL Server 2008/2012.
- Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor.
- Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
- Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
TECHNICAL SKILLS
Languages: C, T-SQL, PL/SQL, Power Shell
RDBMS: SQL Server 2012, 2008, MS-Access, DB2.
Version Controlling Tools: Serena PVCS Version Manager, Tortoise SVN
SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services, Data Quality Services, SharePoint Server, Power View
Data Modeling Tool: ERWIN 4.0,\7.2,Visio 2003\2010
Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7
Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization
Scheduling Tools: SQL Server Agent, Control-M
PROFESSIONAL EXPERIENCE
Confidential, Cedar Rapids, IA
Senior SQL Server ETL/BI Developer
Responsibilities:
- Involve in complete SDLC requirement specifications, analysis, design, development and testing the user stories.
- Created tables and database objects like Procedures, Functions, Packages, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
- Created appropriate Triggers to assist efficient data manipulation and data consistency
- Created trace files on the queries and optimized the queries which were running slowly
- Written complex SQL statements using joins, sub queries and correlated sub queries.
- Created SSIS packages to extract data from different systems and Scheduled Jobs using SQL Agent/Control-M to call the packages and Stored Procedures.
- Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
- Designed incremental load packages with the help of CDC Control Task, CDC Source and CDC Splitter
- Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
- Involved in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
- Created reports using Microsoft SQL Server 2012 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and deployed on SharePoint and report server.
- Generated matrix reports, drill down, drill through, sub reports, multi parameterized reports.
- Created complex Stored Procedures for better performance to generate reports.
- Created Power View reports with the help of Power BI Designer and integrated these reports into SharePoint 2010 server
- Developed AdHoc SSRS reports for the users for analysis purpose
- Used Serena PVCS-Version Manager for Version Controlling.
- Troubleshooting performance issues and fine-tuning queries and stored procedures.
- Revisit the created production objects to improve the performance and implement the best practices.
- Implemented agile project methodology to provide estimations for each Sprint, and present status and highlight if any road blocks in Scrum meetings.
Environment: MS SQL Server-2012 Enterprise Edition, SSIS, SSRS, T-SQL, Power BI Designer, SQL Profiler, PowerShell, Control-M, Serena PVCS-Version Manager, Office-2010, MS Excel, SQL Server Agent, IBM ClearQuest
Confidential - Collegeville, PA
SQL Server BI Developer
Responsibilities:
- Experienced in Creating simple to complex queries involving Joins, Correlated Subqueries and Stored Procedures as per business requirements.
- Active participation in and gathering requirements from workgroup meetings and making changes to existing logic as per business requirements.
- Experienced in Analyzing the Data that is stored form the UI into the databases. Creating a detailed report using MS Excel.
- Experienced in Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow and Data Flow Tools and then verifying it. .
- Wrote the ETL scripts to load the data into database from various source files.
- Worked extensively with SSIS transformations such as lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and send mail task.
- Created new tables, Constraints, altered the existing table-columns for the process of ICD conversion.
- Updated master ICD lookup table by modifying existing codes or adding new codes with the help of SCD of type 2(Historical attribute with date)
- Created new reports and updated the existing reports to take new ICD 10 codes which help in understanding the trends and performance of entities depending on Time and Area granularities.
- Integrated and validated changes to upstream and downstream applications to receive/send the feed having ICD10 codes with the help of SSIS data transfer and FTP packages.
- Participated in data testing for sales portal application to make sure these ICD10 codes reflect to all entities that are eligible to diagnose.
- Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
- Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
- Involved in Unit Testing and Integration testing in SSIS, SSRS
- Involved in the continuous enhancements and fixing of production problems.
- Monitored SQL and fine-tuned the queries on a case by case basis.
Environment: SQL Server 2008 R2, SSIS, SSRS, T-SQL, Visual studio 2005/2008, Tortoise SVN, SQL Profiler, Office-2010, MS Excel, SQL Server Agent, HPSM
Confidential, Jersey city, NJ
SQL Server ETL/BI Developer
Responsibilities:
- Core member of project team who worked in all stages of the project, from requirement gathering to production which includes deployment, defining requirements, project planning, development, testing, and production implementation.
- Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Defaults and complex SQL statements
- Developed standards and guidelines to maintain and develop SSIS packages and Data Flow Diagrams
- Created SSIS packages and automated jobs to monitor, backup, import/export data to INFO-Factory data warehouse from PARIS ODS.
- Worked on Performance optimization of the SSIS packages that are built to load large flat files to the database tables.
- Implemented parallel processing in SSIS packages to reduce the package run time.
- Created Data Modeling, Multi-Dimensional Modeling & created Star Schema and Snowflake dimensional schema using ERwin tool.
- Transformed a Logical Data Model from ERwin Data Modeler to a Physical Data Model on the actual SQL Server database and also did ERwin Forward Engineering/reverse Engineering
- Developed complex stored procedures and functions to extract the data.
- Managed Linked Servers to transfer data between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
- Developed, and scheduled variety of reports like Parameterized reports, Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals, List, Matrix and Sub Reports with in SSRS 2008.
- Created SSRS reports using stored procedure. Involved in scheduling, creating snapshot and subscription for these reports.
- Acted as single point of contact for support of SSIS packages in production. Collaborated with external teams and partners to resolve production issues
- Designed and worked with cubes having star schema, Snow flake schema for future and current reporting using SQL server Analysis Services (SSAS).
- Manage and schedule SQL Agent jobs to import and export terabytes of data to external data warehouse from Mainframe systems
- Promoted database objects to development, test, and production environments Played Key roleSQL Developer in building Enterprise Data Warehouse
- Extensively worked in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Database Engine Tuning Advisor.
Environment: SQL Server 2008/2008r2, T-SQL, SSIS, SSRS, Data Transformation Services (DTS), IBM-Lotus Notes, Query Analyzer, Control-M, PowerShell, SQLProfiler Enterprise Manager (SEM), Microsoft BI Studio 2008
Confidential
SQL Server BI Developer
Responsibilities:
- Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
- Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
- Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).
- Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
- Created simple stored procedures and functions to support efficient data storage and manipulation.
- Monitored the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
- Monitored the performance of SQL Server using SQL Server Profiler.
- Worked with Application Teams on creating a productive Development, Test and Production environment for Application Databases.
- Helped in designing and developing the database using normalization techniques.
Environment: SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Integration Services (SSIS), Query Analyzer, Enterprise Manager, Business Intelligence Development Studio
