We provide IT Staff Augmentation Services!

Sql/ssis/ssrs Developer Resume

2.00/5 (Submit Your Rating)

Plano, TX

PROFESSIONAL SUMMARY:

  • Highly motivated in SQL Server technology with 5+ Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2016/2014/2012, SSIS and SSRS.
  • Expertise working with SQL Server /2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS. Proficient in Database Administration, Design and Development using SQL Server.
  • Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Data Cleansing, Data Scrubbing and Data Migration
  • Strongly experienced in Data Modeling, Data Normalization up to 3rd NF and Dimension Modeling using Star and Snowflake Schemas
  • Expertise in database programming in writing and tuning Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, Sub - queries, Joins, CTEs and Batch Scripts using T-SQL.
  • Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
  • Experience in Data Migration by using side-by-side upgrade process Management.
  • Experience in creating and managing database objects like tables, views, stored procedures, Triggers, Joins, user defined data types and functions. Implementing SQL Server security and Object permissions.
  • Involved in Data Warehousing and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
  • Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all etc.
  • Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
  • Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources
  • Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, and SQL Server Destination.
  • Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill Through reports, using SQL Server Reporting Services (SSRS).
  • Evaluated database performance and performed maintenance duties such as Tuning, Backup.
  • Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
  • Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data.
  • Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases.
  • Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.
  • Expertise working with SQL Server tools such as Management Studio, Query Analyzer, SQL Profiler, SQL Server Agent.
  • Hands on experienced in creating cubes and dimensions, handling multi-dimensional reports.
  • Experience in Crystal Reports, Reporting Services for MS SQL Server, and SQL Server Agent in Support Services.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports, and creating stylish report layouts in SSRS
  • Skilled in sorting the data and defining subtotals for the reports.
  • Experience in Documenting Existing Process, Creating and Analyzing Business Requirements, Functional and Technical Documents.
  • Flexible, enthusiastic, and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
  • Self-motivated, diligent with the ability to quickly adapt to new environments and changes

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0, HTML, XML,Databases Server 2016/2014/2012, Oracle 9i, DB2 MS Access

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

Databases: SQL Server 2016/2014/2012, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

Other Software: MS Office- 2013/2010, Adobe Professional

Methodologies: Logical and Physical Database Design, UML

Operating Systems: Windows XP/Vista/7/10 Windows Server 2012, 2012 R2 and 2016

Database tools: SQL S Plus, TOAD

PROFESSIONAL EXPERIENCE:

SQL/SSIS/SSRS Developer

Confidential: Plano TX

Responsibilities:

  • Developed Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes and Rule.
  • Programmed T-SQL statements using DML and DDL for retrieval of the data from source system in full and incremental manner.
  • Developed complex stored procedures, triggers, and cursors as per given business requirements in SQL Server.
  • Extensively Involved in Designing (Logical and Physical) of Databases.
  • Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Created & managed the Database Users, Login Ids and Security.
  • Design and implementation of database maintenance plan
  • Perform database consistency checks at regular intervals.
  • Imported Data from MS-Access Database and XML to SQL Server Database.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
  • Set Database access privileges for different Users and User Groups.
  • Developed inline view queries and complex SQL queries and improved the query performance for the same.
  • Configured various EMS queues, topics, bridges and routers using TIBCO EMS Administrator tool.
  • Designed and configured many TIBCO Business Works (BW) processes and sub-processes as part of the overall design/development phase.
  • Using SQL to query Databases Performing various validations and mapping activities
  • Check the performance of every query usingSQL Profiler, Index Tuning Wizard and Estimated query planoptimize the performance tuning of SQL queries and stored procedure.
  • Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Extensively worked on ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source
  • Created Datawarehouse Cubes inSQL Server Analysis Service (SSAS).
  • Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
  • Raising defects where discrepancy found in the database and reporting it to the development team.
  • Reported all events and requirements through established reporting mechanisms inSSRS.
  • Reviewed and developeddata models and database designswith development teams

Environment: Environment: SQL Server 2016, SSIS, SSAS, SSRS, MS PowerPoint, MS SharePoint, MS Project, Windows Server 2016.

Mid-Level SQL/ETL Developer

Confidential : Jacksonville Beach, FL

Responsibilities:

  • Participated in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Translated requirements, designs and functional specs into use case document, test plans and test cases documents.
  • Developed complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Optimized stored procedures and long running scripts using execution plan, temp tables, and code rewriting and indexing strategies to increase speed and reduce run time. Programmed SQL statements which include joins and functions.
  • Worked extensively on SQL System Defined Functions and User Defined Functions.
  • Worked closely with Senior DBA on Normalization of database tables, developed (DDL) and (DML) and built Referential Integrity for RDBMS
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
  • Written T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.
  • Performance tuning and optimization of procedures and queries and Involved in the tuning of the existing Database Objects.
  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
  • Designed and developed Packages on SSIS by using Different Transformations like Derived Column, Lookup, Sort and OLEDB command to Load Data into Destination.
  • Developed SSIS packages, to retrieve data from various sources like OLEDB, Excel, Flat files and used data transformation.
  • Loaded data from various sources to SQL Server database using SSIS packages.
  • Worked on various workflows like Data flow Task, Script Task, Execute SQL Task, Containers and File System Task.
  • Implemented the logging, Breakpoints, handled errors especially foreach loop and continued execution logging previous iteration error(s).
  • Developed data import from Excel, Flat file to MS SQL Server by using BCP utility.
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development. Extracted data from star schema DSS data warehouse by creating and maintaining complex SSIS.
  • Involved in building an extensiveOLAPdata warehouse onSSAS(Cubes, star schema)
  • Developed cubes and dimensions and measures and calculated measures according to the business requirements.
  • Created complex SSIS packages using proper control and data flow elements with error handling.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Used performance Point Services, SSRS, excel as the reporting tools.
  • Created various SSIS packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, data transformations, error handling, process design, logging, and Development.
  • Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.
  • Developed customized reports and ad hoc reports as per the business requirements.
  • Developed different data validation scripts for the Data analysts for verification of reports.
  • Utilized Pivot tables to provide structure to Reports in proper format like months etc.
  • Scheduled the Reports to run on daily and weekly basis in Report Manager and emailing them to director and analysts to be reviewed in Excel Sheet.
  • Involved in design, development & deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Participated in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert.
  • Created stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files to SQL server staging tables.

Environment: SQL Server 2014 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, Windows Server 2012 R2.

SQL/ETL Developer

Confidential: St Paul, MN 

Responsibilities:

  • Collaborated with Business Analysts and Client partners to understandBusiness Requirements and System Specification.
  • Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.
  • Implementation ofMS SQL Server Management studio to create Complex Stored Procedures using T-SQLto evaluate result for the reports.
  • Developed logical and physical data models for schemas using MS Visio.
  • Installed SQL Server 2016 and Management tools using SQL Server Setup Program.
  • Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Defined check constraints, rules, indexes, and views based on business requirement.
  • Developed the Stored Procedures, Views, User Define Functions and Complex Queries.
  • Utilized Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
  • Modified the current database by removing unwanted columns and adding proper constraints, rules, and defaults to tables
  • Created Indexes on tables for new database to faster retrieval of data for the Reports.
  • Created Temporary Table and Common Table Expression (CTE) for query Optimization.
  • Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
  • Designed and implemented stored procedures and triggers for automating tasks.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Actively worked on transferring data from one database to another using import export function.
  • Experience in working with different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column etc.
  • Extract Transform Load (ETL) development using SQL Server 2012, SQL 2016 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Created SSIS package to extract data from OLTP to OLAP and scheduled jobs to call the packages and stored procedures.
  • Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
  • Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
  • Developed Analysis Services Project. Developed, Deployed and Monitored SSIS Packages including upgrading DTS to SSIS.
  • Involved in development of MDXqueries for cubes inBusiness Intelligence Development Studio (BIDS), deploying them on the server through SSIS package for cube processing.
  • Troubleshoot and optimized slow running store procedure and other SQL objects as well as SSRS Reports.
  • Developed and modified custom reports using SSRS to meet the business requirements.
  • Validation of the scripts and to check in and check out the scripts like tables, views, stored procedures, and reports in TFS (Version control tool).
  • Thorough analysis and testing of database objects &T-SQLstatements before deployment to the production server.
  • Tested applications for performance, data integrity and validation issues.

Environment: SQL Server 2012, Excel, MS Access, SQL Server Data Tools for Visual Studio 2017, Query Analyzer, Windows Server 2012

We'd love your feedback!