Sql Server Data

VISWA SAMANA

Contact: 216-***-****

Email ID: *****.*******@*****.***

PROFESSIONAL SUMMARY

Highly motivated Business Intelligence Professional with over 7 years of extensive experience in Databases and BI Solutions using SQL Server 2005/2008 R2/2012/2014 and Microsoft Technologies across various Engineering, Financial, Banking, and Health Care Domains.

Strong Knowledge in all phases of Software Development Lifecycle (SDLC) and design through programming, documentation, project management, configuration management, installation and implementation.

Expertise in Database design and development of applications using MS SQL Server 2000/2005/2008/2012/2014, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), OLAP Cubes, Star and Snow flake schema.

Extensive hands-on experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server 2000/2005/2008/2014.

Involved in Database Design, Data Modeling, Development, Programming, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2012/2014.

Experience in logical & physical Data modeling, data architecture design, Normalization and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema) using DM tools like ERWIN, Visio, SQL Diagrams.

Developed numerous financial models, BI reports, defined built countless key metrics, KPIs, scorecards chart rich reports using complex excel functions, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map, OLAP cubes, MDX.

Highly experience in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, and Unique Key), Indexes, Defaults rules, synonyms, and assemblies.

Extensive experience in writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Joins, heavy stored procedures, Batch Scripts, Triggers, Functions, and Views using SQL.

Experience in tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes with Efficient Coding standards.

Data migrating (using ETL tools like DTS, BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.

Highly experienced in whole cycle of DTS/SQL Server Integration Services (SSIS 2005/2008/2012/2014) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.

Expertise skills in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008/2014), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.

Extensive experience in basic and advanced report creation with thorough knowledge of reporting services architecture. Experience in creating various types of reports (table, chart, list, matrix and parameterized reports).

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2014.

Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services (SSAS)

Good Knowledge in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008) using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

Experience in developing cubes using Partitions, KPI’s, and Perspectives, slowly changing dimensions and created various user roles.

Experience in writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Hands on experience in Creating and Managing user roles and assigning necessary permissions.

Good knowledge in Creating Dashboard/Scorecard pages in SharePoint Server/MOSS 2007/Performance Point Server that use different types of web parts and excel services for reports.

Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.

Excellent communication and interpersonal skills and has ability to handle multiple tasks which can take initiative to handle responsibilities independently as well as a proactive member of a team.

Good team player with problem solving, troubleshooting capabilities, Software Installations, Server Configurations, documentation and follow up skills.

Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

OPERATING SYSTEMS

Windows XP/2000/2003/2008/Vista, Win7, Win 8, Win 10, MS-DOS, UNIX.

RDBMS

MS SQL Server 2000/2005/2008/2012/2014, MS Access 2000/2003/2007, Oracle10g/11i, IBM-DB2.

LANGUAGES

T-SQL, PL/SQL, MDX, C, ASP.net, CSS, VB.net, SCOPE, C# (.NET).

WEB TECHNOLOGIES

HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0).

TOOLS AND PACKAGES

MS SQL Server Management studio(SSMS)

MS SQL Server Business Intelligence Development Studio (BIDS)

MS SQL Server Reporting Tools (SSRS)

MS SQL Server Integration Services (SSIS)

MS SQL Server Analytical Services (SSAS)

Enterprise Manager

Profiler

DTS

Visual Studio 2010/2012/2014

Crystal Reports 9.0

COSMOS-Scope Studio

Team Foundation Server(TFS)

MS Visual Source Safe

POWER BI

InfoPath

Autosys

Maximo

Maestro

Sqlizer, DDL, SS Export

APPLICATION PACKAGES

Microsoft Performance Point Server 2007, Microsoft Office 2007/2010/2013, SharePoint Server (MOSS) 2007/2010, Microsoft Project Server 2007/2010.

PROFESSIONAL EXPERIENCE

Client : MICROSOFT CORPORATION, REDMOND (WA)

Role : SQL/BIG DATA/POWER BI DEVELOPER

Duration: SEP 2015 – TILL DATE

Roles and Responsibilities:

Worked on Big Data Cosmos as a source and building numerous reports on top of it using complex Scope queries and Power BI as reporting end for Universal Store BizOps team.

Supported multiple teams, developed and delivered various BI reports, operational scorecards, actionable KPIs, predictive trend analyses using complex reports like Power Pivots, Power View, Power BI, OLAP Cube, MDX to analyze efficiency performance and to predict future level of operational activities.

Involved in gathering user requirements and preparation of mapping documents for application support and development.

Developed dashboards and Key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI and deployed dashboards onto SharePoint.

Cubes were analyzed using MDX and DAX. Also, analyzed and modified data using Power Pivot, created pivot tables and charts for presentation and decision making purposes.

Involved in developing various ad-hoc business reports, Power Pivot and Power view reports for manager.

Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various databases using SSIS.

Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.

Scheduling and Maintaining SSIS Packages and batch jobs through SQL Server Agent.

Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Worked on migrating the Power BI reports from Cosmos 11 to Cosmos 15.

Worked on tuning long running T-SQL Queries by looking at Execution Plans, Index Seeks, Scans, DMVs and DMFs

Knowledge and exposure in development of the Insights Reporting.

Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.

Created cubes using respective fact and dimension tables, performed processing and deployed the cubes to SQL server analysis services database.

While developing reports from Cubes also used the KPI’s for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.

Created subscriptions to provide a daily basis reports.

Involved in peer Code reviews and promotion of code across various SDLC environments.

Environment: MS SQL Server 2014, SSIS 2014, SSRS/SSAS 2014, BIDS, MS Project, Windows-8/10 Platform, MS SharePoint 2010/2014, Visual Studio 2012/2014, COSMOS 11/15, Scope Studio, POWER BI – Power Query/Power View/Power Pivot/Power Map, Insights Reporting.

Client : IBM, BEAVERTON (OR)

Role : SQL SERVER REPORTING (SSRS) ANALYST

Duration: NOV 2014 – AUG 2015

Roles and Responsibilities:

Working in close quarters with business, application developers and production teams across functional units to identify business needs and discuss optimal solutions.

Data from the Operational systems is cleansed and transformed into the required format as defined by the business rules and stored in EDW for the purpose of analysis and reporting.

Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and work closely with Lead Business Analyst to understand the Business requirements.

Created complex reports which involve more number of groupings and multi-value parameters.

Actively involved in developing several Sub Reports, Matrix Reports, Drill down and Drill through reports, Matrix Reports, parameterized reports using SQL Server Reporting Services.

Used various types of report layout options like charts (bars, lines, pie etc images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.

Experience with stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.

Developed reports and deployed them on (DEV, UAT) environments using SSRS.

Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level.

Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.

Managing the Report subscription through Autosys.

Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).

Responsible for creating Tables, Views, Cluster/Non-Cluster Index and Constraints.

Worked on tuning long running T-SQL Queries by looking at Execution Plans, Index Seeks, Scans, DMVs and DMFs.

Involved in Trouble Shooting Complex Reports.

Extensively used Joins and CTE’s to simplify complex queries involving multiple tables.

Used Autosys for scheduling the report jobs and monitor it when any job failure.

Used Maximo for recording an Incident with any job failure.

Work front Interface to maintain all the tasks and updates.

Participated in document reviews, Code Reviews and support.

Report Development Highlights:

1.Internal Controls Foreclosure Referral Program

2.Loss Mitigation Reports

3.Delinquency Management Reporting

4.Bankruptcy Reporting

Environment: MS SQL Server 2008R2/2012/2014, Visual Studio 2010/2012/2014, SSRS 2008/2012/2014, TFS, InfoPath, Autosys, Maximo, WorkFront, MS Visual Source Safe, MS Excel.

Client : MICROSOFT CORPORATION, REDMOND (WA)

Role : MS SQL/BI DEVELOPER (SSRS/SSIS/SSAS)

Duration: JUL 2013-NOV 2014

Roles and Responsibilities:

Worked with business owners and analysts to define and implement new requirements for a more scalable and stable data processing application.

Worked on SSRS to generate hierarchical reports, drill down and drill through reports and tested using Management Studio in SQL server 2012/2014.

Designed and developed Cohort Analysis Tool for Videos and Games for US-Xbox Research & BI People using SQL Server Reporting Services 2012/2014.

Worked on various ad-hoc requests for extracting big data from Cosmos thru Scope scripting in Visual studio 2012/2014.

Involved in big data analysis and converting the request to useful information business reports.

Worked on Billing Churn data analysis for Xbox Subscription.

Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, functions, CTE’s).

Involved in writing Stored Procedures for both Online and Batch requests handling business logic and Functionality of Various modules.

Responsible for creating Tables, Views, Cluster/Non-Cluster Index and Constraints.

Extracted data from various sources like SQL server 2008/2012/2014, CSV, XML, Excel and text file from various systems and through FTP.

Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012/2014) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamic reports and other features of Reporting services.

Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS).

Worked on Key performance Indicators (KPIs),design of Star schema and Snowflake schema in Analysis Services (SSAS)

Big data aggregation using Cosmos scripts and sqlizing the data for weekly reporting.

Involved in developing ad-hoc business requests, Power Pivot and Power View reports for Manager.

Created SharePoint forms to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Worked on Performance tuning, and optimization of procedures and queries.

Environment: MS SQL Server 2008 R2/2012/2014, SSIS 2008/2012/2014, SSRS 2008/2012/2014, XML, BIDS, MS Project, Windows-8 Platform, MS SharePoint 2010, XML, Visual Studio 2010/2012/2014, COSMOS, POWER BI, Scope Studio.

Client : SELENE FINANCE, HOUSTON (TX)

Role : SR. MS SQL SERVER/BI DEVELOPER (SSRS/SSIS/SSAS)

Duration: NOV 2012 – JUL 2013

Roles and Responsibilities:

Worked directly with customers, analysts, business stakeholders, vendors, application developers, production teams and across functional units to identify business needs and discuss solution options.

Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Developed complex SQL Queries, Joins, sub queries, correlated sub queries, Stored Procedures, functions, Joins, Constraints, DDL, DML and User Defined Functions with best execution plan in SSMS to implement the business logic.

Defined & Created databases, tables, Cluster/Non-Custer Index, Views, Unique/Check Constraints and Triggers using T-SQL in Development and Production environment for SQL Server 2008/2012.

Involved in writing complex SQL queries with multiple table inner and outer joins, temporary tables, table variables.

Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.

Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary using SQL Profiler and Index Tuning Wizard.

Used CTEs for recursive functionality to bring the organization structures.

Performed security tasks like Grant, Revoke permissions for security tasks.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008/2012, Flat files and various different sources.

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services 2008/2012.

Involved in ETL architecture enhancements to increase the performance using query optimizer.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Created SSIS packages for Data Conversion using data conversion transformation.

Upgraded SSIS packages from 2012 to 2014.

Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.

Actively involved in developing several Sub Reports, Matrix Reports, Drill down, Drill through, Matrix Reports, parameterized reports using SQL Server Reporting Services 2008/2012.

Involved in monitoring and tuning report performance by analyzing the execution plan of the report.

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Built complex multi-sectional reports with charts and drill-down capabilities, created report models for AD-HOC reports when the end user wants to see the reports on fly and also created Ad-hoc reports for manager using SSRS to find all the work items open for Developers.

Report Development Highlights:

1.Loss Mit Timely 5Day/30Day – Summary & Detail Reports for tracking the Outstanding Loans.

2.Service Link CWCOT Report for Vendors.

3.Letter Recon Summary & Detail Report for outstanding Letters.

4.Timeline Report for Selene and Flagstar Letters.

5.Forbearance Report for Selene and Flagstar Letters.

6.Short Sale Denial Report for Selene and Flagstar Letters.

7.Termination Letters for Loans which are no longer active/have been de-activated and many more Reports.

Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.

Created email subscriptions for data driven reports by using Report Manager.

Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: T-SQL, Query Analyzer, SQL Profiler, MS SQL Server 2008R2/2012, SSIS 2008/2012, SSRS 2008/2012, BIDS 2008/2012, MS Project, Visual Studio 2010/2012, MS Visual Source Safe, Windows Platform, MS Excel 2007.

Client : UNIVERSAL AMERICAN LIFE HEALTH CARE INSURANCE, HOUSTON (TX)

Role : MS SQL/BI (SSIS/SSRS/SSAS) DEVELOPER

Duration: AUG 2011-OCT 2012

Roles and Responsibilities:

Involved in Data Warehouse POC and development starting from inception to implementation and ongoing Support.

Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs.

Involved in Designing architecture of the EDW, Logical & Physical Data modeling, data Dictionary mappings.

Involved in writing various DB Objects like User defined functions, Views, instead of triggers, Usage of Indexes for accomplishing various tasks.

Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.

Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns, Merge, Join, Conditional Split, Data Conversion with Multiple Data Flow tasks.

Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL Table and log files.

Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party Tools.

Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids, Debugging and

Maintenance of ETL packages and ETL optimization using SQL Server best practices.

Configured, Installed and Administered Reporting Services 2005/2008.

Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through/Drilldown Reports and Created Large Number of Report Models for users to create their own reports.

Deployed the solutions on Web Server, Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level.

Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.

Worked on Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables.

Developed OLAP Cubes by using SQL Analysis Services (SSAS) and defined Data Sources, Data Source Views, Dimensions, Measures, Hierarchies, Attributes, Calculations, KPI’s, Perspectives and Roles.

Extensively involved in the SSAS storage methods (MOLAP, HOLAP, and ROLAP), partitions, and aggregations, calculation of queries, Data Mining Models, developing reports using MDX and SQL.

Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.

Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down Reports, report models, KPI’s and Dashboard/Scorecard reports.

Created and modified Dashboard pages in SharePoint server that use Excel Web Access web parts and reporting services web parts and Used Excel Services for reports and web parts.

Used Team Foundation Server to store, run, view, edit and revert back to different versions of the design and development phases.

Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Involved in code reviews, change control and auditing procedures.

Environment: T-SQL, PL/SQL, MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), ETL, MS Excel, Team Foundation Server, Windows Server 2003/2008, Oracle9i, VBScript.

Client : EXENSYS SOFTWARE SOLUTIONS LTD, HYDERABAD (IND)

Role : MS SQL SERVER DEVELOPER

Duration: APR 2010-AUG 2011

Roles and Responsibilities:

Installation, configuration the MS SQL Server 7.0 and maintenance of servers in various environments.

Performance and tuning of SQL servers and application issues related to migration.

Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.

Wrote User Defined Functions and Stored Procedures to implement business rules.

Testing of applications for performance, data integrity and validation issues.

Data Transfers between various servers using BCP and Managing Disk space on NT systems.

Used DTS for data flow from source files like Excel, Tables, and Views to other databases or files with proper mapping.

Worked as a developer on databases like MS SQL Server 2000, MS Access.

Designed DTS package, with DTS Import/Export wizard for transferring data.

Data migration (Import & Export – BCP) from text to SQL Server.

Created Triggers to enforce data and referential integrity.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Involved in creating stored procedures, checking the code for efficiency. Routine backups and restoration.

Administrative and Production support for various applications in all environments.

Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Also, testing and implementing these procedures.

Maintained a good client relationship by communicating daily status and weekly status of the project.

Environment: MS SQL Server 2000/2005, Query Analyzer, MS Access, DTS, BCP, SQL Profiler, Windows 2000 Server, Import & Export Data.

EDUCATION

DEGREE

INSTITUTE

GRADE/PERCENTAGE

Bachelor of Technology (B.Tech) in Computer Science Engineering

JNTU Hyderabad, India

3.3 GPA

Contact this candidate