Sql Server Data

SANGEETHA

Email id: *********.*****@*****.***

Phone:973-***-****

C2C or CTH

Professional Summary:

●Developer with 8+ years of experience on MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS) with Microsoft SQL server 2012/2008-R2/2008/2005 in development, testing & production environment and as well as Tableau, data discovery, data visualization, data analysis, report development.

●Gather business requirements and conversant with all phase of Software Development Life Cycle (SDLC).

●Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snow Flake Schema.

●Strong experience in Stored Procedure, User Defined Function, TSQL coding, Performance Tuning and Query Optimization.

●Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, Relational Database models, Data integrity, query writing and SQL joins.

●Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.

●Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogeneous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.

●Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.

●Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.

●Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

●Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.

●Develop the Documents for Logging/Error Handling for SSIS Packages

●Worked with ER Modeling For OLTP and Dimension Modeling for OLAP.

●Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.

●Scheduled Jobs and Alerting using SQL Server Agent.

●Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and Monthly running processes, and maintain the database for future reference.

●Provided consultative support and created technical solutions to business challenges.

●Expert in evaluating data models to design Tableau solutions.

●Experienced in Data Blending, Data Extracting, Incremental Extract, from different data sources (Flat File, MS Access, SQL Server, Oracle, Cloudera Hadoop and many more.)

●Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.

●Created solution driven dashboards by various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Bump Chart, Waterfall Charts and Geographic Visualization

●Involve in development of Interactive Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.

●Implemented actions, other local and global filters according to the business/client requirement to make workbook and dashboard more interactive.

●Recommending Dashboards per Interactive Tableau Visualization features and delivering reports to Business team on timely manner.

●Experience in designing data visualizations to provide consultative support and technical solutions.

Education:

Master of Science in Information Technology

Technical Skills:

Tableau Desktop 7/8/9, Tableau Public, Tableau Reader, Microsoft SQL Server 2014/2012/2008-R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), T-SQL, PL-SQL, OLAP, OLTP, Erwin Data Modeler v7.0/v4.x, Microsoft Visual Studio 2010/2008/2005,Microsoft Access, Microsoft Office(MS Word/ Excel/PowerPoint), MS Project, HTML, XML, Java, C++, C#, Visual Basic 6.0, Visual Basic.Net, Microsoft Office Visio, Windows 2008/2003/2000 Advanced Server, Windows NT/95/98/2000/XP/7, Ultra Edit Text Editor, Visual Safe Source 2005 (VSS).

Professional Experience:

Client: Barclays, Whippany, NJ

Duration: Sep 2014 – Present

Role: Tableau/SQL Server/SSIS Developer

Project was involved BI developing, maintaining database and data and creating quantitative and qualitative reports based on assets under management, automated customer account transfer, sales and revenue.

Responsibilities:

●Planned, Defined and Designed data based on business requirement and provided documentation.

●Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.

●Created extensive joins and data blending from several different data sources.

●Developed metrics, attributes, filters, reports, dashboards,storyboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.

●Used multiple Measures like Individual Axis, Blended Axis and Dual Axis.

●Create complex formulas and calculations within Tableau to meet the needs of complex business logic.

●Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

●Created Bar Charts which is complied with data sets and added trend, reference lines and forecasting.

●Experienced advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.

●Tested Dashboard for data accuracy and Functionality.

●Created data views from different data sources like Oracle, DB2, SQL Server.

●Involved in reviewing business requirements and analyzing data sources from Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

●Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

●Converted charts into Crosstabs for further underlying data analysis in MS Excel.

●Created Bullet graphs to determine top advisor by using measures and dimensions data from Oracle, SQL Server and MS Excel.

●Participated in implementing the logical design to the physical design by creating tables.

●Created stored procedures, views, triggers, user defined functions to incorporate the flow of business.

●Modified the existing SQL queries according to the requests and executed them to check the performance.

●Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.

●Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

●Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users

●Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS.

●Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

●Modified the existing SSIS packages to meet the changes specified by the users.

●Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.

●Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

Tools & Technologies:

Tableau Desktop 9, MS SQL Server 2014/2012, MS SQL Server Integration Services, Visual Basic.Net, MS Visual Studio 2010, Microsoft Office Visio, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, C#.

Client: Bank Of America, NYC, NY

Duration: Apr 2013 – Aug 2014

Role: SQL Server/SSIS/Tableau Developer

The project was mainly on migration data by utilizing SSIS from database sources and creates reports for customer management and information team about campaign data.

Responsibilities:.

●Actively participated in gathering Business Requirements and System Specification.

●Collaborate with end users, project stakeholders and support partners to identify needs, goals, business and security models and implemented them.

●Performed daily tasks including backup and restore by using MS SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

●Created stored procedures, views, triggers, user defined functions to incorporate the flow of business.

●Created SSIS package to export and import data from SQL Server to Access, text and Excel file. Used Event Handlers for Exception Handling in SSIS packages

●Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.

●Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, and more. Performed ETL mappings using MS SQL Server Integration Services

●Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

●Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.

●Responsible for implementation of SSIS Logging, error configurations for error handling the packages.

●Deploying, Testing and Scheduling SSIS packages using SQL Agent

●Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines.

●Blended data from different data sources (Flat File, MS Acess, SQL Server, Oracle Teradata, Hadoop etc)

●Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.

●Created data views from different data sources like Oracle, SQL Server and MS Excel.

●Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.

●Created guided navigation links for Interactive dashboards in Tableau.

●Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

●Created Bullet graphs to determine campaign data by using measures and dimensions data from Oracle, SQL Server and MS Excel.

●Design interactive dashboards in Tableau Desktop and published them to Tableau Server.

●Design, create, and maintain a platform-wide, re-useable data extract layer within Tableau.

Tools & Technologies:

Tableau Desktop 8, MS SQL Server 2012, MS SQL Server Integration Services, Visual Basic.Net, MS SQL Server Reporting Services, MS Visual Studio 2010, Oracle 10g, Erwin r8, C#.

Client: BCBS, Philadelphia, PA

Duration: May 2011 – Mar 2013

Role: SQL Server/SSIS/Tableau Developer

The project mainly dealt with creating SSIS packages, generate reports by extracting data from the OLTP system, checking the performance tuning of stored procedures, troubleshooting and maintenance and generating report using Tableau.

Responsibilities:

●Created Advance connections, join new tables, create manage Extract and Monitor Queries.

●Used Tableau Desktop for blending databases and creating different interactive views and dashboards.

●Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.

●Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.

●Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.

●Designed data views from different data sources like Oracle, DB2, SQL Server.

●Responsible for creation of Tableau workbooks, dashboards using stack bars, Pie charts, bar graphs, scattered plots, geographical maps, Gantt charts.

●Held responsibility for integration points and the order in which these must be executed.

●Built compelling, interactive dashboards in Tableau that answer key business questions.

●Developed Tableau visualizations to support ad-hoc analyses and interacted with Business users in understanding their requirements.

●Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.

●Involved in compiling of store procedures in SQL server and troubleshoot errors.

●Created documents for code review in test and prod server.

●Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

●Provided security to ETL packages and set them as jobs to perform ETL tasks on regular intervals.

●Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

●Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

●Responsible for Monitoring and Tuning Report performance.

●Configured the report viewing security for various users at various levels using Report Manager.

Tools & Technologies:

Tableau Desktop 7, Tableau Server 6, MS SQL Server 2008 R2, Visual Basic.Net, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2008, Erwin r7

Client: BlackRock, Inc. NYC, NY

Duration: Oct 2009 – May 2011

Role: MS SQL Server/SSIS/SSRS Developer

The project mainly involved in creating new corporate database, performance tuning, creating, deploying and scheduling reports for mutual fund customers. Also it included Extract, Transfer and Loading (ETL) of data from flat file, excel sources using SSIS.

Responsibilities:

●Interacted with business users and analysts and gathered and documented the technical and business metadata.

●Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008 using SSIS Packages.

●Generated ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.

●Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.

●Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

●Created complex stored procedures and functions for integrity checks of transferred data.

●Performed unit testing and SQL performance tuning.

●Tuned SQL statements Using Indexes and stored procedures.

●Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

●Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

●Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.

●Created reports to retrieve data using Stored Procedures that accept parameters.

●Scheduled report and exported in PDF format.

●Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

●Provided documentation for all kinds of reports and SSIS packages.

●Designed and implemented Stored Procedures and Triggers for automating tasks.

Tools & Technologies:

MS SQL Server 2005, SSIS, SSRS, VB.Net, EXCEL, MS Access, ORACLE 10g, Erwin Data Modeler v7.0/v4.x.

Client: MOL America, Edison, NJ

Duration: May 2007 – Sep 2009

Role: Database Developer

This project was to extract data from various heterogeneous sources and server locations and load into SQL Server 2005 and create reports such as Aggregate Adverse Event Report, Customer Detail Report, Account Report and Reports based on the company progress.

Responsibilities:

●Interacted with business users and analysts and gathered and documented the technical and business metadata.

●Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.

●Designed database, tables and views structure for the new data mart.

●Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.

●Created complex stored procedures and functions for integrity checks of transferred data.

●Performed unit testing and SQL performance tuning.

●Helped provide end users with the ability to access and utilize the data stored in the data mart.

●Tuned SQL statements Using Indexes and stored procedures.

●Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.

●Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.

●Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Tools & Technologies:

SQL Server 2005, MS Excel, MS Access, Enterprise Manager, Management Studio, SQL Profiler and SQL Server Reporting Services.

Contact this candidate