Sql Server Data
Resume:
THAPASYA M
SQL BI Developer
*************@*****.***
PROFESSIONAL SUMMARY:
5+ Years of IT experience in the design, development, support and migration of Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005 database in Finance, Manufacturing and Healthcare industries
Strong SQL Server developer Skills including writing user defined functions, views and query writing
Strong knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
Solid Knowledge of Data warehousing (Star Schema and Snow Flake Schema)
Proficient in MS SQL Server suite of products like SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, and SQL Server Reporting Services SSRS of MS SQL Server
Experience in developing ETL (Extract Transfer Load) interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions & features in Business Intelligence
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, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot)
Strong experience in creating dashboards, KPI’s and scorecards using gauges and charts for analysis using SSRS 2016/2014/2012/2008 R2 and SharePoint 2013
Experience in SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports
Created and deployed data driven, user specific and parametrized drilldown reports using SSRS, Tableau and SAP crystal reports
Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS)
Excellent Knowledge on architectures of Business intelligence tools MSBI, Pentaho, Tableau, SAP BI, Microsoft Power BI and Crystal Reports
Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2, XML and Flat file using Bulk Copy Program (BCP), Bulk Insert & Data Transformation Services (DTS) utility
Good Knowledge and Experience in building Multidimensional OLAP cubes and Info cubes in SQL Server
Extensive experience with Transact-SQL (DDL & DML) statements, Data Integrity (Constraints), Rules, and Validation issues
Proficient in Implementing & Developing RDBMS concepts such as Table, Stored Procedures, User Defined Functions, Indexes, Triggers, Nested Queries, Joins, Cursors, Views, CTE’s, Pivot, and Table Variables
Good knowledge in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
Good knowledge of Data modeling, E/R diagrams, normalization and de-normalization and physical database schema design using CA Erwin data modeler as per business requirements
Good knowledge on creating Runbooks in Azure Automation
Good knowledge of Scheduling Jobs and Alerts using SQL Server Agent
Good experience working in both Inmon and Kimball methodologies
Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2/2005
Worked extensively on system analysis, design, development, testing and implementation of projects SDLC (Software Development Life Cycle) and Agile Methodologies
Working experience in a Scrum team as a Scrum Master to facilitate the communication between Product Owner and other Scrum team members as well as ensuring sprints were accomplished in a timely manner
Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high-pressure environment
TECHNICAL SKILLS:
Operating Systems
Windows vista/XP/2003/Windows7/Windows 8, Unix
Tools & Packages
SQL Server Management Studio, Enterprise Manager, SQL Profiler, Index Tuning Wizard, SQL Server Data Tools, SQL Server DBA Dashboard, Toad for SQL, Data Quality Services(DQS), Master Data Services(MDS), Query Analyser
BI Tools
SSIS, SSAS, SSRS, Microsoft Power BI, Tableau 10.0, Pentaho Data Integration (Kettle), Excel 2010, Cognos 8.3/8.4, QlikView
Databases
MS SQL Server 2005/2008/2008R2/ 2012/2014/2016, Oracle 12c/10G/9i, Teradata
Developmental Skills
SQL, Transact SQL (T-SQL), PL/SQL
Programming Language
C, C#, HTML, XML, MDX
Application Packages
MS Office Suite, MS Outlook, Windows SharePoint 2010/2013
EDUCATION:
Vellore Institute of Technology (VIT), Bachelor of Technology Tamilnadu, India
Major: Computer Science and Engineering GPA: 3.5 May 2012
University of Bridgeport, Master of Science GPA: 3.8 Bridgeport, CT, USA
Major: Technology Management Minor: Database Management December 2016
PROFESSIONAL EXPERIENCE:
Client: Parallon Jul 2017 - Dec 2017
Location: Nashville, Tennessee
Role: SQL BI Developer
Responsibilities:
Involved in project planning, requirement gatherings, technical designs and documented functional requirements
Involved in complete Software development life cycle SDLC of the project
Designed, developed and managed SSIS packages for the extraction of data from different data sources like Oracle, CSV files, Flat Files and load them on to respective data marts
Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.,
Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS). Designed various operational, drill-through, drill-down, sub reports and parameterized reports and developed these reports using the Global variables, Functions.
Delivered intuitive and innovative Data visualisations using Tableau and SSRS
Worked closely with the development and support to trouble shoot any technical issues on SSAS/SSIS/SSRS and Tableau dashboards
Designed the new DWH in Azure by creating the cubes with measures for analysis, decision making based on historical data
Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports
Maintained and Supported Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and reports
Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
Developed MDX queries against SSAS Cubes to generate reports for analysis
Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshotting via SharePoint User Interface
Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions
Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning
Have developed processes for the new Implementations, support activities and Change requests and to update the Business Process Management (BPM) document accordingly
Co-ordinated with project control teams and DBA for the Weekly production deployments and testing
Effectively worked with the team members, while handling change requests, issue tickets
Documented User-end manuals and provided user-end training for the ad-hoc analysis, SSRS and Tableau
Environment: Microsoft SQL Server 2016, SQL Server Integration Services SSIS 2016, SQL Server Reporting services SSRS 2016, SQL Server Analysis Services SSAS 2016, Tableau 10.4, Excel 2013, Windows 8, Oracle 12c, SQL server profiler, Visual Studio 2013, Share point 2013, PerformancePoint Services, TFS, Power BI, Tableau 10.2
Client: Silgan Plastics Jan 2017 - Jul 2017
Location: Chesterfield, MO
Role: SQL BI Developer
Responsibilities:
Designed and implemented the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.
Designed SSIS ETL packages to extract and load from different data sources including SQL Server, Flat Files, Excel Files, and XML Files etc
Developed packages using Control Flow Task like For Loop Container, for Each Loop Container, Sequence Container, Execute SQL Task and Data Flow Task to load the Data
Created deployment utilities to deploy the package using File System Deployment and SQL Server and Implemented Error handling using Event Handlers and Schedule the SSIS packages through SQL agent jobs
Designed and Developed Business Intelligence data model using SSAS and created Dimension and Fact table in Data Warehouse systems
Worked on Kimball methodology to develop data warehouse
Generated Ad-hoc reports and designed attractive report pages based on clients' request
Developed matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using SSRS
Created Matrix Reports with all aggregate functions and expressions, dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server
Developed T-SQL stored procedures, functions, Views and data load scripts for the product development team
Created reports in Power BI preview portal utilizing the SSAS Tabular and prepared dashboards using Tableau to make it more attractive
Followed agile development methodology for development and conducted Scrum meetings
Environment: MS SQL Server 2014, T-SQL, MS Excel 2013, SQL Server Management Studio (SSMS), Visual Studio, SQL Server Integration Services (SSIS 2014), T-SQL, PL/SQL, Query Analyzer, Tableau 10.0
Client: (m)PHASIZE Aug 2016 - Dec 2016
Location: Westport, Connecticut
Role: MSBI Developer
Responsibilities:
Installed SQL Server 2014 with the latest service packs
Migrated Database from SQL Server 2008R2 to 2014
Created tables, indexes and designing constraints
Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse
Worked with ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers
Enhanced and deploying the SSIS Packages from development server to production server
Wrote stored procedures for report generation in SQL Server 2014
Created Alerts for successful or unsuccessful completion of Scheduled Jobs
Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI
Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
Developed custom visuals using Power BI based on user requirements
Administrated the created Reports by assigning permission to the valid user for executing the reports
Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache
Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2014
Created and Maintained Database Maintenance Plans
Environment: Microsoft Business Intelligence Studio, SQL Server 2014, SQL Server 2008R2, Oracle 11g, SSAS 2014, SSIS 2014, SSRS 2014, C#, Windows server 2008, Power BI, MS Excel 2010, SQL server profiler.
Company: Cognizant Technology Solutions Inc, Mar 2013 - Jul 2015
Client: CNA Insurance
Location: Bangalore, India
Role: SQL BI Developer
Responsibilities:
Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data
Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables
Designed ETL SSIS packages to process data to target databases
Develop the Documents for Logging/Error Handling for SSIS Packages
Developed Stored Procedures to support ETLs and Reporting
Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users
Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2012 as assigned
Wrote T-SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views
Developed Query for generating drill down reports in SSRS 2012. Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts
Created insert and update script to fix data problem, created database objects like View, Stored Procedures, and Functions.
Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 20012 as assigned
Designed Enterprise reports using SQL Server Reporting Services (SSRS 2012) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
Worked on build star schema and snowflake schema in Analysis Services (SSAS)
Environment: Microsoft Business Intelligence Studio, SQL Server 2012, SAS Enterprise studio, SSIS 2012, SSRS 2012, SSAS 2012, T-SQL, MS Excel 2010
Company: Cognizant Technology Solutions Inc, May 2012 – Feb 2013
Client: Prudential Financial Inc.
Location: Bangalore, India
Role: MSBI Developer
Responsibilities:
Actively involved in creating SSIS 2008 packages to transform data from OLTP database to respective data marts
Performed ETL capabilities on SSIS 2008 like develop new packages, configure packages, deployment of the packages from development to production, scheduling and debugging
Configured and maintained huge OLTP and OLAP databases
Querying and manipulating multidimensional cubes data through MDX Scripting
Migrated data from Oracle to SQL Server data warehouse and developed OLAP cubes using SSAS 2008 and make them available for the end-users and reporting services
Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL
Loading data from various sources like flat files, Oracle database, Access, mdb files to SQL Server database Using SSIS Package
Using SQL server reporting services (SSRS) delivered different types for all functional groups
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
Improved the performance of the ETL process and reports by tuning the SQL database, SSIS packages and SSAS cubes
Environment: Microsoft Business Intelligence Studio, SQL Server 2008, SAS Enterprise studio, SSIS 2008, SSRS 2008, SSAS 2008, T-SQL, Windows server 2008, MS Excel 2007, SQL Profiler, SQL Query Analyzer, Replication, Backup/ Recovery
Company: BlueBook Inc Nov 2011 – April 2012
Location: Hyderabad, India
Role: MSBI Intern
Responsibilities:
Worked on SQL Server 2008 Management Studio
Created multiple join statements to retrieve data from several tables and views
Developed complex T-SQL Queries and SQL Scripts for efficient data load, based on complex Business rules
Created several SSIS jobs and packages and executed tasks based on client requirements
Develop dynamic reporting solutions using SQL Server 2008 Reporting Services and validated them
Extensively worked on drill-down and drill-through reports and created Charts, Pie-Charts, Bar-graphs, series in SSRS
Worked on building Dashboards in SSRS
Experience working with Change Data Capture
Developed Income statement and other financial reports using SSRS
Worked Interactive sorting on reports
Extensively worked on expressions and filters
Deploying reports into SharePoint and involved in subscriptions
Experienced in troubleshooting and repairing SharePoint failures from the server side
Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008, T-SQL, PL/SQL, SSIS 2008, SharePoint.
Contact this candidate