We provide IT Staff Augmentation Services!

Sql Developer/ssis/ssrs/ssas Resume

CA

SUMMARY

  • 8+ Years of experience in IT, as MS SQL Server Database Developer in Windows environment. Microsoft Technology Specialist in Business Intelligence and SQL Server 2012/2008R 2/2008/2005.
  • Extensive experience developing and implementing Business Intelligence tools Microsoft SQL Server integration services (SSIS), Microsoft SQL Server Analysis services (SSAS), Microsoft SQL Server Reporting Services (SSRS) and MDX for data warehouse and data mart solutions.
  • Extensive experience in TSQL development which includes creating complex business Stored Procedures, Databases, Tables, Sub - Queries, Joins, Cursors, Views, Triggers and User Defined Functions and Indexes using T-SQL.
  • Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
  • Expertise in Analyzing Query Plans, Managing Indexes and Locks, Troubleshooting Deadlocks.
  • Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
  • Experience in creating packages to transfer data between MS Access, Excel and Flat files to SQL server using SSIS.
  • Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (SSIS), Bulk Insert, BCP, and XML.
  • Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Well versed in data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS) for data migration.
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS. (slightly related to SSAS/data warehouse data load)
  • Experience implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages
  • Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement. Expert in creating Ad-Hoc reports, Linked reports, Snapshot reports, Cross-Tab, Conditional, Top N and Sub reports using SQL SSRS.
  • Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
  • 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, Ad hoc and Sub Reports.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
  • Good understanding ofMicrosoft ReportingService(SSRS)with Report authoring, Report management, Report delivery andReport security.
  • Experience in developingUser reports and management reports using MS SQL Server Reporting Services (SSRS).
  • Good Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.
  • Experience using SQL Server Analysis Services (SSAS) in building OLAP Cubes, defining Referenced Relationships and creating Hierarchies in SSAS
  • Worked in Data modeling, creating star and snowflake schemas in SSAS.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008R 2/2008/2005. , Oracle10g/11g.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, SSIS, Microsoft Visual Source Safe, SQL Query Editor, Performance Point Server 2007

Languages: T-SQL, SQL,C,C#,vb.net

Operating Systems: Windows 2010/2008/2007/2003/ Windows Vista, Windows XP

Web Technologies: HTML, XML, XSL

Data Modeling: Erwin 8/8.2,Star Schema Modeling, snow-flake schema modeling, FACTDimensions Tables, Physical and Logical Data Modeling

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

  • Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
  • Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server
  • Actively designed the database to fasten certain daily jobs, stored procedures.
  • Written T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
  • Pulled data from various tables and databases to generate reports using different types of joins.
  • Involved in merging existing databases and designed new data models to meet the requirements.
  • Create joins and sub-queries for complex queries involving multiple tables.
  • Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports OLAP reporting, dashboards, and scorecards.
  • Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system and CSV Files and load into staging tables
  • Designed and developed efficient SSIS packages for processing fact and dimension tables transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension, Aggregate, sort and derived column etc
  • Designed SSIS packages to Extract data from different sources like SQL server 2012/2008R2,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS .
  • Developed SSIS packages using For Each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
  • Created the SSIS packages and scheduled them using SQL Server agent.
  • Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
  • Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
  • Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
  • Used Vb.net and C# in Script task of SSIS Packages
  • Performing data transfer/migration using Export/Import and Data Transformation Services.
  • Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
  • Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2 and Attained legacy data to use as a source to develop new reports previously compiled
  • Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
  • Developed Query for generating Drill Down and Drill Through Reports in SSRS Microsoft visual studio(MSVS)
  • Created sub reports and pass through parameters from main report to the sub reports.
  • Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
  • Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
  • Created snapshots of reports to reduce the load on the server using SSRS
  • Created Crystal Reports using Crystal Reports formulae, Grouping, Parameters, Selection criteria.
  • Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.

Environment: MS SQL Server 2012, SQL server Reporting Services, SSAS, SQL Integration Services 2012/2008R2, Microsoft Visual Studio 2013/2012, MS Excel, T-SQL, Visio.

Confidential, NY

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
  • Designing and developing SQL Server 2012 Databases, Tables, Indexes, Views.
  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Written complex SQL statements using Joins, Sub queries and correlated sub queries.
  • Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
  • Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
  • Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
  • Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS
  • Migrate the data from an Access database to SQL Server 2012
  • Developed web application for reporting portal using .NET, ASP.NET, C#, VSS
  • Used VB.Net Code to create embedded functions in SSRS.
  • Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
  • Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
  • Developed, deployed and monitored SSIS Packages including upgrading SSIS to SSIS.
  • Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Design, deploy, and maintain various SSRS Reports in SQL Server 2012
  • Designed and implemented Parameterizedand cascading parameterized reports using SSRS.

Environment: MS SQL Server 2012, Visual Studio 2012, VB.Net, C#, SSIS, SSRS, Report Builder, Team Foundation Server (TFS), Office, Excel.

Confidential, CO

MS SQL Server SSRS/SSIS Developer

Responsibilities:

  • Analyzed business recovery requirements and maintained strategies and plans for critical databases.
  • Developed, designed and documented tables, view, stored procedures, advanced queries.
  • Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
  • Improved performance of slow running queries and Stored procedures using Execution Plan and SQL Profiler.
  • Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
  • Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
  • Involved in designing ETL (SSIS) as a part of Data warehousing and loaded data in to Fact tables using SSIS.
  • Deployed and scheduled SSIS package to run Daily, Weekly and Monthly jobs using Sql Server Agent.
  • Created different type of SSRS reports including Cross-tab, Conditional, and Drill-down, OLAP and Sub reports.
  • Experience in building reports through REPORT BUILDER and REPORT DESIGNER.
  • Experience in creating reports using REPORT MODEL and applying row level security filters..
  • Excellent report creation skills using Microsoft Reporting Services (SSRS).
  • Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
  • Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS

Environment: SQL Server 2012, OLTP, ETL, MS Visual Studio, T-SQL, SSRS and SSIS

Confidential, TX

SSIS/SSRS/SSAS/SQL Developer

Responsibilities:

  • Created SSIS packages and used Analysis Services processing task to update the cube with current data.
  • Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning on it
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
  • Extract Transform and Load (ETL) source data into respective target tables to build the required Data marts.
  • Created SSIS packages to load data into Sql Server using various transformations in SSIS.
  • Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
  • Identified the dimension, fact tables and designed the data warehouse using star schema.
  • DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions. Deployedand processedOLAP Cubes.
  • Developed Aggregations, partitions and calculated members for cube as per business requirements.
  • Defined appropriate measure groups and KPIs & deployed cubes.
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
  • Created report snapshots to improve the performance of SSRS.
  • Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Designed Dimensional modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: SQL Server 2008R2, Windows 2008/2010,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2008, Visual Studio 2005

Confidential

MS SQL Server Developer

Responsibilities:

  • Developing T-SQL queries, triggers, functions, cursors and stored procedures.
  • Responsible for logical and physical design of SQL Server databases.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Created views to restrict access to data in a table for security.
  • Expert in extracting data using SSIS from OLTP to OLAP.
  • Performed Bulk data migration using SSIS and SSIS from flat files.
  • Designed and optimized all the SSIS packages.
  • Created SSIS packages to Export data from text file to SQL Server Database.
  • Designed and implemented stylish report layouts.
  • Identified and defined the Datasets for report generation and also included report parameters.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Implemented full and differential backups and also created and managed DB objects.
  • Make recommendations for File group Creation and Placement.
  • Scheduling backups and automating weekend maintenance tasks.
  • Created users and roles for login authentication and validating permissions.
  • Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: MS SQL Server 2008, T-SQL, MS Integration, Analysis and Reporting Services, Query Analyzer, Windows 2003 Server.

Confidential

SQL Server SSIS Developer

Responsibilities:

  • Experienced in rebuilding and transferring new database
  • Created Database Maintenance Plans for the performance of SQL Server, which covers Database Integrity checks, update database Statistics and Re-indexing.
  • Managed database security and implemented encryption/compression for sensitive data in the database
  • Troubleshoot Third party Data migration, SSIS, Backups and restore, tune up systems, upgrade
  • Performed Database Search and Query Strategy design, implementation, testing, and optimization.
  • Performed Stored Procedures development and testing, as well as Database Report design and implementation
  • Export data in Excel to SQL Server via SSIS
  • Run daily, weekly and monthly reports for management consumption.
  • Wrote optimized T-SQL stored procedure to improve performance.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: Windows 2007, SQL Server 2008, SQL Profiler, SSIS, T-SQL, BCP, Replication.

Hire Now