We provide IT Staff Augmentation Services!

Sql Developer (ssis/ssrs/ssas) Resume

New York, NY

SUMMARY:

  • SQL Developer with 5+ years of professional IT experience in design, development, implementation, maintenance and Testing in MS SQL Server 2017/2016/2012/2008 R2/2008.
  • Involved in the SDLC (system development life cycle) of a data warehouse and responsible for designing, coding, testing, implementing, supporting the ETL processes for data warehouse solutions/data marts and implementing the reporting requirements.
  • Working skills in MS SQL Business Intelligence tools as SSIS, SSRS and SSAS.
  • Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS) as a back end developer in financial, health care, insurance and retail companies.
  • Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin.
  • Experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins.
  • Experience in writing T-SQL queries and Rank functions.
  • Hands on Work experience in developing SSIS Packages to Load data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
  • Created views for dimension and fact tables and built Tabular model (SSAS) on top of those views based on the business requirements.
  • Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
  • Hands on experience in creating Configuration files and deploying into file system and SQL Server database.
  • Experience in report building using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Chart Reports.
  • Experience in Creating and Deploying SSRS Reports on the portal for user accessibility.
  • Experience in the field of Unit testing, have tested codes of T-SQL and SSIS Packages in the testing environment.
  • Knowledge in Backup and Restore.
  • Strong working experience in the Data Analysis, Data Profile, Data Quality, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
  • Experience in creating SQL Server Maintenance Plan.
  • Experienced in creating Indexes, planning and implementing Server Security and authentication.
  • Experienced in using tools like MS SQL Profiler, Index Tuning Wizard, and Red Gate Data Generator.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Languages: SQL, C, C++, T-SQL, PL/SQL, C#, .Net

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), SSRS, SSAS

Web Technologies: SOAP, Servlets, HTML, CSS, JavaScript, XML, XSLT, WSDL, Struts, Hibernate, And Spring.

OOAD/UML, MS: Visio, Rational Rose, RUP, J2EE Patterns

Application Server: BEA Web Logic, IBM Web Sphere, JBoss, Apache Tomcat

Oracle, MS: SQL Server, DB/2, MySQL, MDM, Mainframes

Operating Systems: Windows 2003/2000/NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Built Data marts (Fact and Dimension tables) from the warehouse tables.
  • Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
  • Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Understand user requirements and Data Model defined and developed by the business analysts and data architects.
  • Created SSIS Packages according to the requirements.
  • Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
  • Stage (Extract) the source data from files, SQL server, Oracle, DB2 sources.
  • Worked with Flat Files (Pipe Delimited) sources and implemented error handling routines.
  • Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.
  • Created OLAP Dimensions, Measures and Cubes using SSAS.
  • Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
  • Constructed OLTP and OLAP Databases.
  • Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
  • Wrote custom functions to produce the derived fields using the source table fields for each record from source
  • Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
  • Worked with Date/time manipulations in SQL Server built in functionalities as well as Data Integrator Date functions.
  • Generated Parameterized/dropdown SSRS Reports.
  • Validated (ETL/OLTP) MS-SQL Server SSIS, SSRS, Stored Procedures and use of Data Modeling for the creation of Technical Data flows (Data Modeling) Documentation for all the various processes
  • Created views for dimension and fact tables and built Tabular model (SSAS) on top of those views based on the business requirements.
  • Involved in deployment of Tabular Model to various clients’ Analysis Services Databases (SSAS) & processing in production.
  • Used Script task in SSIS to write custom code using C# .Net to send HTML emails.
  • Implemented history preserving using Table comparison, History Preserving and Key generation transformations in warehouse /dimension workflows.
  • As a part of optimization: Used MAP operations to route UPDATE and INSERT records in warehouse workflows
  • Ran stats on all tables. Right choice of transformations & right design in data flows. Implemented incremental load process.
  • Handled the cross schema (Warehouse, Data mart) challenges between the different environments (Development, QA and Production) by granting permissions on tables using Database functions in scripts before running work flows.
  • Prepared ETL design documents for implemented work flows and loaded the documents in the project share point site.

Environment: SQL Server 2008/2012/2016/2017 , Query Analyzer, SSIS, T-SQL, Excel, Microsoft SQL Reporting Services (SSRS), SSAS, Oracle 10g. Analysis Services (SSAS), DTS, T-SQL, C# .Net, Windows 7, XML, MS Excel, MS Access, Team Foundation Server (TFS).

Confidential, Columbus, OH

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Experience in creating T- SQL Scripts and stored procedures to implement the business needs and to support the frontend application.
  • Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2008.
  • Migrated the entire schema as well as data into MS SQL Server 2008 and validated the migration process to ensure that it has been successfully migrated.
  • Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.
  • Designed ETL SSIS packages for data migrations, alerting notifications for various processes and developing automation process for efficiency purposes.
  • 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.
  • Generated occasional reports in view of the factual investigation of the information utilizing SQL server Reporting services (SSRS)
  • Experience on creating basic dashboards in tableau connected to Azure SQL database for client reporting.
  • Hands on experience in working with Applications Migration and App Development in AZURE.
  • Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
  • Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
  • Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
  • Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
  • Created Views, Materialized Views to get the values dynamically using joins and other SQL queries from the multiple tables.
  • Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
  • Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.

Environment: SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T- SQL, ASP.NET2.0, C#.NET, .NET Framework, EXCEL2007, Windows 2003 Server.

Confidential

SQL Developer

Responsibilities:

  • Actively participated in interaction with users, team, DBA’s and technical manager to fully understand the requirements of the system.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
  • Expertise in enhancing and deploying the SSIS Packages from development server to production server.
  • Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
  • Creation, manipulation and supporting the SQL Server databases.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Used ETL tool like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
  • Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Relocation of Databases from one server to another server using attach and detach databases.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding the indexes at regular intervals for better performance.
  • Involved in Weekly Change Management, in which code developed by developers is being run on production server.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Installation of new SQL Server databases and upgrades.
  • To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2012, SSIS, .NET, Microsoft Excel, Microsoft PowerPoint, SQL Server 2008 R2, Windows Enterprise Server 2010, MS Office 2010.

Hire Now