We provide IT Staff Augmentation Services!

Sql Server Ssis, Tableau,ssrs Developer Resume

CA

PROFESSIONAL SUMMARY:

  • Over 8 years of IT experience in Capital Markets Banking / Financials/ Mortgages, Medical and Retail sectors as a SQL server Developer that includes Database Design and Development of SQL Server 2012/2008/2005/2000.
  • Involved in Database Design,Data modeling,Development, Implementation, ETL and Reporting in SQL Server 2000/ 2005/20 08/2012 .
  • Extensive experience in Database development for bothOLTP (Batch Processing, Online Processing)&OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2000/ 2005/20 08/2012 .
  • Expert in providing Enterprise Reporting solutionsusing SSRS 2000/2005, Crystal Reports, Performance Point Server, ProClarity and SharePoint Services.
  • Extensive ETL experience using DTS/SSIS forData Extractions, Transformations and Loads.
  • Expertise in developing application using.NET, C#, SQL Server.
  • Data Modeling - Hands on Data warehousing and Data Modeling tools like Erwin 4.0,Visio 5.0/ 2002.
  • Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
  • Experience in monitoring MS SQL Server databases and performance tuning using IndexTuningWizard, SQLProfiler, and WindowsPerformanceMonitor for optimal Performance.
  • Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent, AutoSys.
  • Data Transformation Services/ Integration Services (DTS/SSIS):
  • Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
  • Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
  • Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
  • Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
  • Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
  • Expertise in creating Report Models for building Ad hoc reports using SSRS.
  • Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
  • Expertise in Report writer.
  • Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
  • Expertise in upgrading or migrating Analysis Services.
  • Proficient in building Star schema and Snow Flake schema depending on business requirements.
  • Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
  • Expertise in creating Cell Level Security in cubes using SSAS.
  • Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/ 2005/20 , MS Access, Oracle 9i/10g, Sybase.

Programming Languages: T-SQL, PL/SQL, C#, VB scripts, Oracle and Batch Scripting.

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL,Business Objects XIR2/XIR1/6.X/5.X, Informatica, Visual Studio .NET, SunGardiWork sProcede 8.6.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008/7/10.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica 8, ProClarity OLAP tools, Performance Point Server 2007, MS Visio, Erwin, Crystal Reports 9.0/XI.

Web Technologies: XML, XPath, HTML, XSL, JavaScript.

Data Modeling: Visio 5.0 and Erwin 4.1.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS).

Version Control: VSTS, TFS, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, CA

SQL Server SSIS, Tableau,SSRS Developer

Responsibilities:

  • Involved in User Requirement Gathering and Technical Specification Documentation.
  • Analyzed business requirements and built logical and physical data models that described all the data and relationships between the data
  • Extract, Transform and Load source data into respective target tables to build the required data tables.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
  • Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations
  • Improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
  • W orked on complete SSIS life cycle in creating SSIS packages, building, and executing the packages in both the environments (Development and QA)
  • Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
  • Implementing Event Handlers and Error Handling in SSIS packages.
  • Developed SSIS packages not only for Initial Data Loads but also for incremental/delta load.
  • Created Partition Tables based upon Partition Functions and Partition Schemas.
  • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
  • Analyzed all the Jobs That Includes SSIS, SSRS, Tableau Jobs as a part of Optimization and developed a report for all the jobs which includes dependencies and failure data
  • Developed code for various packages in Visual Basic .NET.
  • Expertise in reviewing/analyzing Software Requirements Specification documents SRS , Business Requirement Documents BRD
  • Designed and developed Tableau dashboards using stack bars, bar graphs, scattered plots, and Gantt charts.
  • Performed Unit testing for the screens and code in Visual Basic .NET and SQL Server 2012.
  • Managed different versions of complicated code and distribute them to different teams in the organization utilizing TFS

Environment: Windows Server 2007, SQL Server 2008/2012, Visual Studio 2008/2012, SSRS, SSIS, MS Office, C#, SharePoint, Tableau, C#, Asp.NET, TFS, JIRA, Autosys

Confidential, IL

SQL SSIS, SSAS,PowerBI Developer

Responsibilities:

  • Created Technical Specification document.
  • Extract, Transform and Load source data into respective target tables to build the required data tables.
  • Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
  • Designed analytical reports and dashboards utilizing Power BI Desktop to identify critical KPIs per business requirements.
  • De signed, Developed, Tested, Published and maintained PowerBI Functional reports, Dashboards based on user requirements
  • Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory.
  • Created PartitionTables based upon PartitionFunctions and PartitionSchemas.
  • Created various kinds of reports using Power BI and Tableau based on the client's needs.
  • Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
  • Published reports and dashboards designed in PowerBI utilizing PowerBI services and shared it across through Microsoft Office 365.
  • Created databases on SQL Azure.
  • Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
  • Expertise in reviewing/analyzing Software Requirements Specification documents SRS , Business Requirement Documents BRD
  • Responsible for testing to optimize the procedures and triggers to be used in production. Involved in project planning also schedule for database module with project managers.

Environment: Windows Server 2003/2008/2012 , MS SQL AZURE, Server 2005/2008/2012 , Visual Studio 2008/2012, SSRS, SSIS, SSAS, MS Office, C#, SharePoint, PowerBI.

Confidential, VT

Data Warehouse/ETL/Reports Developer

Responsibilities:

  • Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
  • Defined report layouts including report parameters and wrote queries for drill down reports as per client’s requirements using SSRS 2008.
  • Generated multiple Enterprise reports (SSRS/Crystal) from OLTP which included various reports
  • Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
  • W ritten complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
  • Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
  • As a part of optimization: Used MAP operations to route UPDATE and INSERT records in warehouse workflows
  • Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
  • Reviewed the SQL for missing joins & join constraints, data format issues, miss-matched aliases, casting errors.
  • Responsible for Design, Data Mapping Analysis, Mapping rules
  • Responsible for Development, Coding & testing.
  • Used various transformations like Expression, Filter, Sorter, Aggregator, Lookup, Update Strategy, Router, Union, Joiner, Normalizer, XML Generator, DB2 and Web Services Consumer.
  • Designed Reusable Transformations using the Transformation Developer & created Mapping Parameters and Variables.
  • Worked with Database Admins to setup and create connection to Teradata / Oracle / SQL Server Database with Data stage.
  • Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
  • Interacted with the Business Analysts and the testing team for the testing of the ETL processes.

Environnent: SQL Server 2012/2016 Enterprise Edition, Enterprise Manager, JavaScript, DAX, Informatica, ERWIN, UML, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, SSIS, SSRS, SSAS

Confidential, Richardson, TX

Sr. SQL SSRS/SSAS Analyst

Responsibilities:

  • Extract, Transform and Load source data into respective target tables to build the required data marts.
  • Having strong Healthcare domain knowledge in Provider and Payer HIPPA EDI transactions such as 834, 837 and Pharmacy Claims.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Constructed OLTP and OLAP Databases.
  • Creating SSAS Assemblies written in C#.NET and MDX Development
  • Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2011
  • Wrote parameterized queries for generating reports in SSRS 2012/2008.
  • Strong working experience in Developing reports on SSAS & SSRS on SQL Server … Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Designing SSAS cube to hold summary data for dashboards. Developed Cube with Star Schema.
  • Involving in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Designed and developed various analytical reports from multiple data sources by blending data from different sources on a single worksheet in Tableau Desktop.
  • Enhanced our existing development base on Reporting and Analysis Services tabular model
  • DAX is used to create Dashboards for data analysis/business needs
  • Created reports for various members of staff for analysis that included market sizing, products, and regional analysis using MS Excel or Tableau.

Environment: Oracle Server 2005/2008, MS Access 2000, Performance Point Server 2007, Dax,, MS SQL Analysis Services 2005, Tableau, Business Objects 6.5.1/ XI r2, XML, Java, ActiveX, MS Excel, Visual Studio 2008, Windows Server 2003, Oracle, AWS RED SHIFT, Crystal Reports, Excel.

Confidential, Grapevine, TX

SQL Server Developer

Responsibilities:

  • Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitor the size of the transaction log.
  • Tuned the performance of SQL queries and Stored procedures using SQL Profiler. Involved in database and log backups & restoration, backupstrategies, scheduling.
  • Provided back-end support for performance testing and functional testing using use case testing methodologies.
  • Developed packages using SSIS and controlled its execution, by implementing the infrastructure that enables execution order, logging, variables, and event handling.
  • Created Stepped and Blocked reports using SSRS.
  • Generated multiple Enterprise reports (SSRS/Crystal) from OLTP which included various reporting features.
  • M igrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
  • Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, JavaScript, DAX,ERWIN, UML, MS Project, Windows2003 Server, .NET, C#, ASP.NET, SSIS, SSRS, SSAS

Confidential, CA

SQL Server Developer

Responsibilities:

  • Partially involved in system study and database designing.
  • Installation of SQL Server 2000 in Windows 2000.
  • Creation of database objects.
  • Configured SQL Server Environment.
  • Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
  • Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
  • Performed job scheduling in the SQL Server Environment.
  • Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
  • Created views consisting of computed columns to facilitate easy user interface.
  • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
  • Designed and implemented user log in and security.
  • Developed stored procedures, triggers, row level audit tables in SQL Server.
  • Developed cursors and views to improve performance in data transactions.

Environment: SQL Server 7.0, SQL Server 2000, C#, Oracle, MS Access, Erwin, T-SQL, Windows 2000 Server, Visual Basic.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Interacted with end users to gather Requirements. Created technical, user documentation.
  • Studied and designed the system.
  • Install, Update, Configure and Maintain the MS SQL Server.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
  • Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
  • Written Java Script for different validations
  • Used SQL Statements to Present Query responses.

Environment: MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Access 2000 & Windows NT platform, Reporting Services, DTS, Business Objects 4.0/6.5, Windows Active Directory.

Hire Now