We provide IT Staff Augmentation Services!

Sr. Sql Server Ssis/ssrs/t-sql Developer Resume

Los Angeles, CA

SUMMARY

  • Over 7+ years of in - depth experience in database design, development, support, and maintenance of SQL Server 2016/2014/2012/2008/2008 R2 large scale databases.
  • Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, User functions, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes and Appropriate Triggers to facilitate efficient data manipulation and data consistency.
  • Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on Data Transformation Services (DTS), Data Cleansing and Data Migration.
  • Highly proficient in creating and analyzing Database Diagrams from SQL Databases
  • Strong experience with ETL using SSIS packages to support application and reporting environments
  • Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, SSIS and ETL Development with MS SQL 2016/2012/2008/2008 R2.
  • Proven experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access, and AWS RDS.
  • Strong knowledge and experience in upgrading SQL Server databases from one version to another.
  • Proficiency in creating different types of Reports such as Crosstab, Drill-down, Summary, Parameterized, Paginated, Collapsible, Sub reports and formatting them using SSRS.
  • Strong Knowledge in Enhancing and Deploying SSIS Packages from Development Server to Production Server.
  • Highly proficient in the use of SQL Server and T-SQL in constructing relational database models and data integrity, SQL joins.
  • Expert in Applying graph database to model many-to-many relationships for better performance of queries
  • Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, CSV file, DB2 to MS SQL Server by using Import-Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
  • Extensively worked in Data Warehouse methodologies and technologies as well as proficiency in OLTP/OLAP environments.
  • Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
  • Expert in using Data Factory to easily construct ETL and ELT processes code-free within the intuitive visual environment or write code.
  • Strong proficiency in Azure system configuration, database migrations, backup and recovery, geographic data replication.
  • Experience in Implementing High Availability (HA) technologies which include Log shipping, Database Mirroring, and replication.
  • Proficient in Cloud based report generation, development and implementation using power BI.
  • Well experienced in moving customers’ SQL Server databases to AWS cloud using SQL Server on Amazon EC2, Amazon Relational Database Service (RDS), Amazon Elastic Block Store (EBS)
  • Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
  • Proficient in Conceptual, Logical and Physical Modeling
  • Experience in Using sqlcmd to run a Transact-SQL script file
  • Experienced with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
  • Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
  • Experienced in designing, developing, and deploying SQL Server SSAS cubes.
  • Experienced in Developing Power BI reports & effective dashboards after gathering and translating end user requirements
  • Recreating existing application logic and functionality in the Azure Data Lake, SQL Database and SQL data warehouse environment
  • Developed dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
  • Configuring SQL Azure firewall for security mechanism
  • Experienced in database server performance tuning and optimization of Complex SQL queries.
  • An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
  • Flexible and versatile to adapt to any new environment, technology, and work on any project.
  • Detail-oriented and excellent problem-solving and communication skills.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/ 2008/2008 R 2/ 2012/2014/2016/2019 , DB2, Oracle, MS Access

Database Tools: SSIS, SSAS, SSRS, Crystal Report, power BI

Languages: VB.NET, ASP.NET, MVC, java, C#, C++, T-SQL, E-SQL, HTML, CSS, Bootstrap

IDE: Visual Studio 2003-2017, SSDT 2013/2012/2017 , Eclipse, MS Project 2013, Visual Studio code, PyCharm, Sublime text, Jupiter notebook

Operating Systems: Windows Server (2000, 2003, 2008, 2012), Windows 7/8/10, Linux

Case Tools: MS Visio, Erwin

Version Control Tools: TFS, Git

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles, CA

Sr. SQL Server SSIS/SSRS/T-SQL Developer

Responsibilities:

  • Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse from SQL Server 2012/2014/2016 MS Excel and Flat files.
  • Used various transforms in SSIS to load data from flat files to the SQL databases.
  • Created ETL packages using SSIS to extract data from relational database and then transform and load into the data mart.
  • Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse from heterogeneous databases/data sources.
  • Prepared Visio diagrams/documents to track and implement the blueprint of the ETL dataflow/process implementation from Initial phase, Ongoing, Deployment to Production Environment.
  • Created SSIS packages to mitigate into the data warehouse database from heterogeneous databases/data sources.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
  • Worked on Design and implement row level data warehouse security.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
  • Run packages deployed to Azure on the Azure-SSIS Integration Runtime
  • Generated several drill-down and drill-through reports using SSRS.
  • Involved in designing, developing, debugging, and testing of reports in SQL Server Reporting Services (SSRS).
  • Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
  • Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes, and Functions using T-SQL for SQL Server 2012.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Created SSIS packages for Data Conversion using data conversion transformation.
  • Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
  • Used Visual Team Foundation server for version control, source control and reporting.
  • Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
  • Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views using T-SQL code and SQL joins for applications.
  • Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2012
  • Designed paginated reports and vivid visualizations using SSRS.
  • Published reports to any mobile device and access the reports online or offline.
  • Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services.
  • Defined Key Performance Indicator metrics to create scorecards.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
  • Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Created Azure SQL database, performed monitoring and restoring of Azure SQL database.
  • Performed migration of Microsoft SQL server to Azure SQL database
  • Created and modified UNIX Shell Scripting according to the changing needs of the project and client requirements.
  • Supported application written in Oracle PL/SQL and converted into T-SQL packages.
  • Created data extraction ETL jobs using SSIS, DTS, extracting data from MS ACCESS, Oracle and MS Excel and loading into SQL Server Databases.
  • Participated in Databases Architecture and data modeling design.
  • Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
  • Involved in designing, developing, debugging, and testing of reports in SQL Server Reporting Services (SSRS).
  • Inspected the reports and fixed bugs in stored procedures and tuned Reporting Services to the T-SQL.
  • Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).

Environment: SQL Server 2008R2/2012/2014 Enterprise Edition/2016 2019, Microsoft Visual Studio 2012/2015/2017 MDX, T-SQL, Oracle PL/SQL, MS Access, MS Excel, Windows 2008/2010 Server, OLAP, Visual basic .NET, UNIX shell scripting, Visual studio Code, SSDT 2015/2017, power BI and Power BI Desktop platforms.

Confidential - Los Angeles, CA

SQL Server SSIS/SSRS/ T-SQL Developer

Responsibilities:

  • Involved in Planning, Defining and Designing database based on business needs for insights & analytics.
  • Studied in-house requirements and conducted Joint Requirement Development (JRD) session to analyze the database requirement in detail.
  • Developed C# scripting for packages using Scrip task
  • Gathered Requirements, Analysis and Documentation for creating reports. Analyzed complex technical requirements and made determinations for modifications of existing programs/modules.
  • Developed conceptual, logical and physical data models for creating schemas using MS Visio. Created Star/Snowflake Schema for Data Marts.
  • Involved in creating UNIX Shell Scripting.
  • Maintained Alerts, notifications, Jobs, Job schedules
  • Developed Shell Scripting to automate repetitive database processes.
  • Designed, Created and managed primary objects such as tables, triggers, database links, indexes, and privileges, based on logic design model. Developed all the required stored procedures and user defined functions and worked with stored procedures for data set results in reporting services to reduce report complexity and to optimize runtime.
  • Designed extract, transform and load (ETL) packages to load business retail data received from different stores and other locations into data marts using Data Flow Task, Execute SQL Task, Lookups, Fuzzy Lookups, Conditional Split, Derived Column and Execute Package Task.
  • Designed and implemented data structures for new functionality and restructured existing data structures to increase performance by writing queries and stored procedures.
  • Created SSIS packages to automate maintenance, database backup and restoration, update statistics, re-build indexes as well as create error log for event during data load.
  • Used MDX queries for pre calculated measures and created reports model on SSAS cubes as well as changing default configuration on existing cubes. Created perspectives, partitions, and Designed aggregations in cubes using SSAS.
  • Manipulated database security by creating authentication on databases. Created Window users, Work Group and SQL Server logins based on various security requirements. Created Cell Level Security in cubes using SSAS.
  • Researched and resolved complex issues and implemented longer-term solutions to frequent occurring issues.
  • Conveyed problems, solutions, updates and project status to peers and management. Developed and maintained clear and succinct documentation.

Environment: MS SQL Server 2008/2008R2/2012, SSDT 2012/2013, C#, Oracle 11, PL/SQL, Microsoft Visual Studio 2012/2013, MS Excel., MS Visio 2013, UNIX shell scripting.

Confidential

MS BI Developer

Responsibilities:

  • Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
  • Created SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel and Access to SQL Server.
  • Developed C# scripting for packages using Scrip task
  • Involved in upgrading packages from SQL server 2005 to SQL server 2008
  • Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
  • Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Generated Sub-Reports, Drill-down reports, Drill-through reports, and parameterized reports using SSRS.
  • Created reports to retrieve data using Stored Procedures that accepts parameters.
  • Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
  • Involved in creating OLAP cubes and dimensions for the analysis using SSAS.
  • Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI's, using SSAS.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
  • Used SQL Server profiler for auditing and analyzing the events, which occurred during a particular time horizon and stored in script.
  • Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
  • Used "SQL Profiler TSQL Duration" template for tracking execution time of TSQL Statements.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2005/2008/2008 R2/2012, BIDS 2008, SSDT 2010/2012, C#, Oracle 11, PL/SQL, Microsoft Visual Studio 2008/2012, MS Excel., MS Visio 2013, UNIX shell scripting.

Hire Now