Sql Server Data

Sruthi Mobile: +1-425-***-****

SQL Analyst/BI Developer Email: ***********@*****.***

Professional summary:

A Technology individual with 5+ years of experience including academic and professional for delivering database projects on a variety of domains.

Excellent knowledge in Relational Data Base Management System concepts.

Expertise in various Data analysis and design.

Experience in data modeling and dimensional modeling.

Experience in Migrating Data from various sources like Flat Files, Excel, MS Access, Oracle and older versions of SQL Server to New versions of SQL Server.

Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS (2008 / 2012) Packages with proper control & data flow elements.

Good understanding of Normalization/De-normalization, Normal Forms and database modeling.

Experience is using SQL Profiler, Execution plan, Performance monitoring, query tuning, Index tuning, DBCC commands for troubleshooting.

Strong RDBMS and BI Developer Skills including writing T-SQL, Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Triggers, cursors, BCP and BULK Insert.

Experience with various Microsoft Technologies like Microsoft Azure, SQL, SQL Azure, C#, ASP.Net

Developed Pipelines, Activities, Linked Servers to load data from various traditional data sources like SQL, SQL Azure, into Microsoft Azure Data Lake Storage and BLOB Storage.

Experience in working with Product and Marketting departments to optimize corporate websites by analyzing user behaviour, tracking conversions and revenue and making recommendations for site updates and additions.

Competent and experience in using IBM utilities, and other third party tools like DB2 tools.

Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs.

Management of schemas, Data Modeling, objects & partitioning the tables & indexes.

Proficiency in creating different types of reports such as Ad-hoc, Cross-Tab, Conditional, Drill-down, Interactive, Summary, Form, Interactive and Sub reports with conditional formatting in SSRS.

Worked extensively with DW Architect team for Designing New Data-Warehouse.

Experience in working with SQL Azure and Windows Azure VM’s in deploying code and also fetching data from azure.

Experience in creating dashboards in Power BI service.

Extensively used PBI desktop for creating data models for the supporting reports.

Well versed in data transformation and ETL in Teradata.

Performed DM, DDL Operations as per the Business requirement.

Experience and understanding of SSAS, OLAP Cubes, slowly changing Dimensions, KPIs and Architecture

Experience in Advanced Tools like PowerView, Power BI, Power Pivot.

Experience in C#, ASP.NET, ADO.NET, Microsoft Visual Studio 2008/2010/2013/2015, LINQ, SQL server 2005,2008,2012,2014, VB.NET, N-tier web based and Client/Server Technology

Administrative skills including Creation, Backup, Restore and maintenace of Databases. Manging the servers for drive space.

Managed iterative requirements pipeline in an agile software development model.

Involved in SDLC Requirements gathering, Analysis, Design, Development and Testing of application using Agile model.

Creating documentation and diagrams explaining detailed process flows.

Experience in Version Controlling, using various tools like SourceTree, VSTF, TFS, StarTeam etc.

Knowledge on using Atlasian products like JIRA, Stash and Confluence.

Technical Skills:

Programming Languages: T-SQL, C#, ASP.Net, PL/SQL.

Scripting Languages: Windows PowerShell

Database Technologies: MS SQL Server (2014/2012/2008/2005), MS Access, Oracle 10g, MySQL, DB2 and PostgreSQL.

ETL Tools: DTS and SSIS.

Reporting Tools: SSRS and Crystal Reports.

Analytical Tools: SSAS

Web Technologies: VB.Net, Servlets, ASP. Net, HTML, CSS and XML.

Operating Systems: Windows Vista/XP/7/10, and Mac.

Packages/IDEs/Tools: MS Office, SSDT, Visual Studio, and Toad.

Modeling Tools: MS Visio.

Certification:

Certified AWS Developer-Associate Level

Professional Experience:

Expedia, Inc., WA Sep 2015 - Current

SQL BI Developer/Data Analyst

Responsibilities:

Highly involved in designing of BI solution in complex multi user environment.

Analyzing Email response data and tying all the underlying events for reporting purposes.

Designed and implemented for processing NRT (Near Real Time) Data from flat files and XML files using command shell, PowerShell, SSIS and SQL Server partitioning.

Wrote T-SQL statements using DML and DDL for retrieval of the data.

Implemented ETL automation for downloading, loading them in to SQL and uploading different types of files from and to FTP.

Developed ETL’s for data refresh from PostGres and MySQL using ODBC drivers.

Worked on analyzing and validating Data quality and to ensure Data Completeness.

Evaluated all upstream and downstream Dependencies and available Data sources.

Created Source to Target Data Mappings for whole data by analyzing all the Core Business Fields and Key Reporting Metrics.

Implemented DAX formulas in tabular models and PBI desktop using various DAX functions.

Solid experience in development & design of various web forms using ASP.NET, HTML and CSS for the user interface presentation layer of various applications.

Analyzed and monitored data and workflow processes to assess completeness, accuracy, and conformance to standards and specifications.

Scope, plan and manage business intelligence application projects including dashboard enhancements.

Created interactive dashboards using the slicers and pining the live reports to PBI dashboards and also responsible for maintaining the security of the PBI reports.1

Evaluate and document business requirements and functional specifications for technical design.

Created Complex SSIS packages for integrating data from a variety of data sources like SQL, SQL Azure, Excel Files, Flat files and XML Files involving multiple transformations tasks.

Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions etc. for better performance during package execution.

Involved in using hints to direct the optimizer to choose optimum query execution plan.

Expertize in writing T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, and User-defined Functions.

Used various String functions for extracting the values from a string formation.

Created multiple SSRS Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down Reports as well as other interactive reports according to business requirements.

Involved in design and development of SSAS tabular and multi-dimensional cubes.

Designed and developed various reports with Running Aggregations, Interactive sorting and conditional formatting.

Designed and developed dashboards in Microsoft Power BI for providing excellent analytical functionalities to various business teams.

Created custom Power BI Dashboards supporting multiple business KPIs.

Programmed, tested, and debugged remote stored procedures and COBOL-DB2 stored procedures.

Environment: Windows Server 2012, SQL Server 2008 R2/2012/2014, ER Studio Architect 10.0, Microsoft Access 2013, Visual Studio 2012/2013/2014, SQL Server Data Tools, MS Power BI, Microsoft Azure

AT&T Inc., WA Feb 2015 - Aug 2015

SQL BI Developer

Responsibilities:

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.

Involved in writing complex SSIS Packages to Load Data into both OLTP and OLAP systems.

Extensively used various control flow tasks like FTP, Bulk insert task, Transfer Jobs task etc. and different Data flow tasks like Merge Join, Look up, Data Conversion etc.

Deployed SSIS packages to QA/Pre-production environments.

Interacted with business/end users to gather requirements.

Involved in extensive Data validation process by writing complex SQL queries to authenticate Data Integrity.

Designed and deployed various complex reports using MS Reporting Services.

Prepared Documents of each process involved.

Created different types of reports based on the complex T-SQL queries from the scratch like matrix report, charts, parametric report and tabular reports with different Calculations, formatting options and grouping options.

Analyzed and tuned stored procedures in reports.

Developed Complex Packages to load data into Staging, ODS and Data Warehouse systems.

Automating SSIS Packages using SQL Server Agent Jobs, Window Scheduler.

Created Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.

Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.

Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.

Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.

Environment: MS SQL Server 2008 R2/2012, Visual Studio 2010, SSIS, SSRS, Windows 2008/2003 Server

TSYS iSolutions, Denver, CO Aug 2014 - Dec 2014

SQL BI Developer/DBA

Responsibilities:

Installed MS SQL server 2012 and MS SQL server 2008 on Windows 2012/2008 servers, applied Service packs and Security fixes. Implementing database standards and naming convention for the database objects.

Migrated databases from SQL Server 2008 to SQL Server 2012.

Implemented new jobs for the automation of backups and restored data.

Involved in data modeling, created ER-Diagrams.

Used DDL and DML for writing triggers, stored procedures and for data manipulation.

Created and managed users, logins and permissions.

Designed and implemented policies for data and application security.

Performed Performance tuning and testing on stored procedures, indexes, and triggers.

Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.

Configured Client/Server Connectivity, and Checked Database Consistency using DBCC Utilities.

Worked extensively on SSIS using ADO.NET source to access databases like SQL Server 2012/2008.

Modified database structures including tables, data dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.

Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Involved in building a strategy for star schema, snowflake schema with fact and dimension tables.

Worked with OLAP databases.

Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measure groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Fine-tuned the database objects and server to ensure efficient data retrieval

Environment: SQL Server 2008/2012, SSIS, SSRS, Visual Studio 2008/BIDS, Windows Server 2008/2012.

GenPact, India May 2012 – Jun 2014

Database Developer

Responsibilities:

Creation of Tables, Views, Triggers, Functions, and Stored procedures according to the need.

Highly involved in all phases of SDLC including Planning/Analysis/Design (30%), Development (50%) and Support (20%).

Worked with business users to understand their business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Participate in evaluating and analyzing the relational database management systems, utilities and tools offered by BI applications/tools vendors.

Designed and optimization of conceptual and logical dimensional data models for data marts to support reporting infrastructure.

Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP Cubes while adhering to enforced development methodologies.

Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.

Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.

Generated reports with dynamic grouping and dynamic sorting as well as running values.

Highly involved with developer team on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.

Environment: Windows Server 2008 R2, SQL Server 2005 / 2008 R2 (SSIS, SSRS, SSAS), MS Access, XML, MS Excel and Visual Source Safe, Visual Studio.

Education:

Bachelors in Electronics and Communication Engineering, ICFAI, India.

Contact this candidate