Sql Server Data

SUGNESHWAR SHATOOR

PROFESSIONAL SUMMARY

Highly motivated SQL server Developer with over Ten Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005, SSIS and SSRS.

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/2008/2005/2000.

Experienced in client requirement Analysis, design, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008/2005/2000, SSIS, SSAS and SSRS 2005/2008/2012.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

Worked Extensively on ETL process using SSIS package.

Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.

Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.

Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

Good understanding of Health care, and Retail domains.

EDUCATION

Bachelor of Engineering from Osmania University, India

Diploma in Computer Applications

Member of TDWI - The Data Warehousing Institute

Member of DAMA - Data Management Association.

SKILLSET:

SQL Server 2012/2008/2005/2000, MS-Access, OLE-DB, SSAS and OLAP, Transact SQL, VB.Net, ASP.Net, C/C++,SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, SQL Server Integration Services (SSIS), Import Export Data, SQL Server Reporting Services (SSRS), Microsoft Excel, Crystal Reports, Windows 95/ 98/NT/2000/XP/Vista.

PROFESSIONAL EXPERIENCE

EXECA, DE July 2017 – Till Date

Role: SQL Server/ Data Analyst/BI Analyst

EXECA is a Professional Services Automation software is an On Demand, integrated front office and back office solution with an adaptable business architecture and far-reaching functionality, meeting demanding needs of today's organizations. EXECA improves all aspects of your business: workflow, tracking and controlling. Easy-to-implement, web-based solution increases organizational efficiency, maximizes resource utilization, facilitates team collaboration, fosters individual responsibility and productivity.

Responsibilities:

Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.

Created and Presented Agenda’s, BRD’s, Functional Specifications, Project task lists and plans

Worked with the Human Resources database.

Developed SQL Server and MS Access databases for various usages.

Performed upgrade from Access 2007 to 2010.

Performed data collection, analysis and interpretation, provided data management, and created reports.

Designed and imitated project, and designed, analyzed, and tested system.

Created tables, data modeling, queries, forms and reports.

Regularly conducted Knowledge transfer sessions with Analysts, Developers, QA’s

Responsible for running Daily, Weekly, Monthly reports from both SQL Server and Oracle databases

Primary contact for one of the Vendor regarding compliance and data related check points for one of the process

Downloaded data sets from other databases into MS-Excel spreadsheet. This data was then imported into MS-Access database tables, created queries and Reports including graphical representation of data.

Utilized Advanced Excel skills (pivot tables, graphs, vlookup, if statements) in working with Excel.

Utilized VLOOKUP and Pivot table to perform detailed analysis of Human Resources data.

Generate context filters and use performance actions while handling huge volume of data.

Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.

Monitored user activity on a weekly basis for benchmarking adaptability and usability of reports.

Environment: Tableau (Desktop/Server), SQL Server, Java API, Microsoft office Suite (Word, Excel, PowerPoint)

Client: Med Assurant, Herndon, VA Mar 2015 - April 2017

Role: SQL Server SSIS/SSRS Developer

Med Assurant Company focuses on developing tools that enable rapid health care data aggregation and validation from medical facilities for clients that include health-insurance plans, hospitals, pharmaceutical companies and regulatory agencies. Med Assurant uses the aggregated data to help customers to manage risk and identify more cost-efficient care options. Med Assurant focuses on four main areas of operation, which include claims and payment integrity, disease management, clinical and quality outcomes and health care data intelligence.

Responsibilities:

Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the application

Developed Physical data models and created DML scripts to create database schema and database objects

Performed Debugging on the Stored procedures for the requirement to handle the errors

Employed Transparent Data Encryption, a new feature of SQL Server 2008 to store the data securely by encrypting the database files.

Development of custom scripts and stored procedures for data import and manipulation

Implemented Full Text Search for fast and efficient querying when large and unstructured data is encountered.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts

Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Implemented Incremental load, used Event Handlers to clean the data from different data sources

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Developed Reports for business end users using Report Builder and Power BI with updating Statistics.

Developed Power BI reports using query logic based on business rules, and visuals selected by stakeholders

Developed various operational Drill-through and Drill-down reports using SSRS

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate a report from two different Data Sets.

Involved with Query Optimization to increase the performance of the Report.

Developed Reports for business end users using Report Builder with updating Statistics.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005

Interacting with the Database Administrator to maintain the database used DBCC Statements to perform maintenance tasks before backing up the databases.

Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.

Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.

Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema

Environment: SQL Server 2000/2005/2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows 95/NT/2000/2003, XML, MS Excel, MS Access, MS visual Studio, BIDS. BI Reporting Tools: Power BI, Tableau and MicroStrategy.

Client: TechInsurance, Allen, TX Aug 2013 - Feb 2015

Role: SQL Server SSIS/SSRS Developer

TechInsurance is an America's leading Web-based e-agent that provides business and professional, Property and Liability insurance for Clients in various businesses Classes (IT industry, manufacturing, consulting, Healthcare, Financial and Brokerage services) different types of policies like General Liability, Professional Liability, Workers Compensation and Errors and Omissions etc.

Responsibilities:

Played an active role during the requirements gathering, analyzing and designing of the system.

Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

Created logical data model using ER/Win 4.0.

Development of large-scale test databases and associated maintenance scripts.

Development of custom scripts and stored procedures for data import and manipulation

Configuring, tuning, and optimizing SQL Server 2005.

Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.

Proactive and Reactive tuning of databases in every stage of the project.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Created horizontal partitioning of data for different file groups.

Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.

Production support, troubleshooting and debugging in a high volume transaction processing environment utilizing a lot of XML.

Configured and trained users to use Reporting Services.

Create parameterized Reports using Charts, Cross-Tab and Sub-report types.

Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).

Environment: Windows 95/NT/2000/2003, Microsoft SQL Server 2000, Microsoft Excel, ODBC, XML, SQL Query Analyzer, DTS, Erwin, Visual Source Safe, Reporting Services(SSRS), BIDS.

Reliance Group, India Feb 2010 - Jul 2013

Telecommunications & Retail Division

Role: SQL Server SSIS/SSRS Developer

In this project, we used SQL server 2008 tools, SSIS for ETL Process, SSAS for making cubes, SSRS for creating reports in different environment. My main role was to work on ETL process. This project is about to develop DSS for sales module, purchasing module, accounting module, logistics module using Business Intelligence technology like Integration service packages, analysis cube and reporting.

Responsibilities:

Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases

Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of operational systems

Created, maintained, modified, and optimized SQL Server databases, database security and auditing.

Wrote stored procedures for report generation in SQL Server2005.

Successfully deployed reports in various sources like XML, Web browser and PDF.

Administrated the created Reports by assigning permission to the valid user for executing the reports.

Created and Maintained Database Maintenance Plans.

Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.

Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances

Created scripts and SQL jobs to facilitate database backup and recovery, server and data processing monitoring and alerting

Worked with developers to setup databases and coordinate the schemas and procedures deployment on staging and production.

Maintain disaster recovery strategies for the database and failover methods.

Environment: SQL Server 2000/2005, Windows Server 2003, Windows NT, .NET, DTS, BIDS.

BirlaSoft / Aditya Birla Group, India Feb ’2006 to Aug ’2010

Role: SQL Server/Data & QA Analyst

Responsibilities:

Conducted functionality, usability, interface, compatibility and security testing of the web application developer.

Defined the test scenarios (testing the bounds, validations) for the web application, identified and reported bugs to the development team.

Additionally performed bug fixes for the application, as part of the development team.

Developed and maintained checklists to ensure development was aligned with clients specifications and requirements.

Maintain medical records.

Worked on various billing and coding procedures.

Assisted in preparing user stories in the product backlog after the collection of functional requirements from system users and prioritized the requirements in product backlog.

Provided support to QA team.

Creation and Execution of the Functional Test Cases.

Responsibilities of site feasibility assessment for business, improvements on site draw backs, and focus on new techniques for low CAPEX and maintenance. His major contribution was on systems setup, QA/QC processes, data warehouse management which enabled smooth transition of various tasks with zero snags. Also involved in Vendor Management.

Managed all surveillance projects as per contract documents and ensured compliance to all requirements.

Prepared reports for all Projects and Warehouse in/out Transactions of all business units across India.

Environment: SQL Server 2000/2005, SQL, Oracle, Windows Server 2003, Windows NT, .NET, DTS, BIDS, QTP, WinRunner, LoadRunner, Unx

Vanasu Constructions, India Jan’1995 to Jan ’2006

Data Analyst, Quality Analyst, Support Engineer, Eng. Intern

Responsibilities :

Used various types of date for Site selection for prospective business.

Provided IT CAD, CAM designs for development with concern Architects and Engineers.

Administered and performed various certified civil engineering database activities.

Documented project activities for all new construction projects using MS Office

Assisted in renovation and recommend improvements to all real property data.

Assisted in various new construction projects and recommend changes.

Managed all procurements as per required time lines and ensured compliance to all requirements.

Managed the sales data of space commercial and Residential proceeds

Developed all cost estimates for projects and utilized various estimate tools for all projects.

Complete the project in stipulated time and cost with approved standards

Involved in Manual testing in all phases of the project.

Environment: Oracle, SQL, SQL Server, MS Access, MS Excel, Flat Files, Miscellaneous Data, CAD, CAM, Windows, Windows NT, Unix, Manual Testing, Third Party Tools

Contact this candidate