Sql Server Manager
Resume:
Sindhura Atta
Sr. SQL Developer
****@***********.***
Professional Summary:
10+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2/2005/200 in Production, QA and Development Environments.
Strong experience with T-SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
Ability to work in all stages of System Development Life Cycle (SDLC).
Experience in Error handling and debugging coding issues and troubleshoot production problems.
Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
Expertise in SQL Server 2005/2008 Reporting Services (SSRS), SQL Server 2005/2008 Integration Services (SSIS) and in SQL Server 2005/2008 Analysis Services (SSAS) in Business Intelligence (BI).
Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2).
Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
Experience in Managing Security of SQL Server 2005/2008 R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
Experience in .NET/C# application development environment to use SQL Server Databases.
Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
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 MS Analysis Services.
Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
Skilled in design of logical and physical data modeling using Erwin data modeling tool.
Worked with Business Analysts, Web development team, and users on database solutions.
Education:
Bachelor of Technology in Information Technology
Technical Skills:
Tools &Packages
SQL Server Management studio, Enterprise Manager, Profiler, SQL
Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0,
HP QC, ProClarity 6.2,SharePoint 2007, Team Foundation Server
BI Tools
SSIS, SSAS, SSRS.
Databases
MS SQL Server 2000/2005/2008/2012, MS Access 97/2003/2005/2008.
Language
T-SQL, PL/SQL, MDX,C, VB.net, C# (.NET)
Operating Systems
Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.
Application Packages
MS Office Suite, MS Outlook, Windows SharePoint Services.
Data Modeling Tools
MS Visio, Erwin
Professional Experience:
Jewelers Mutual Insurance, Neenah, WI Jun 2015 to Present
Sr. SQL Developer
JMI is an insurance company that provides insurance to the jewelry purchased by the people for any occasions. It provides insurance to all kinds of the jewelry purchased. Worked in the department to help maintain and provide effective solutions to manage the data.
Responsibilities:
Responsible for the design, construction, optimization, and operational support of extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and reporting solutions including SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Performance Point, and SharePoint. Have been Work in translating the business and functional requirements into detailed technical designs and delivers ETL and reporting solutions according to the specifications.
Responsible for extracting data from multiple operational and financial sources and assemble them into meaningful business intelligence
Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server stored procedures within MS SQL Server environment.
Develop and maintain complex reports, multidimensional cubes and flexible dashboards.
Create and maintain data flow diagrams for existing and future ETL processes.
Create and maintain detailed source-to-target ETL mapping specifications.
Assist in the definition of the database requirements; analyze existing models and reports.
Evaluate alternate solutions and design processes and systems which include user impact considerations, cost and benefit analysis, and processing specifications.
Develop optimized SQL Server stored procedures, functions, and database views.
Translate business requirements into BI application designs and solutions.
Performance monitoring, tuning and capacity planning.
Develop ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.
Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 & 2005,MS Visio 2007,TortoiseSVN.
Blue Cross Blue Shield, Newark, NJ Jan 2013 to May 2015
Sr. SQL Developer
BCBS is a health care company which provides different health insurance solutions from health management, monitoring to diagnosis. It also provides many health care products which treat infections, disorders and provide remedy for chronic and solutions to clinical care. Work revolved around the department which acts as liaison between the government and the health care receivers.
Responsibilities:
Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
Involved in database Schema design and development.
Migrated Database from SQL Server 2005 to 2008.
Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
Executed stored procedures using BATCH files.
Developed stored procedures and functions for designing various reports.
Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
Used Batch Files to Import Data from other Data Base.
Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
Enhancing and deploying the SSIS Packages from development server to production server.
Administrated the created Reports by assigning permission to the valid user for executing the reports.
Environment: SQL Server 2005/2008/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#,VB.Net, XML, Visual Studio 2008 & 2005,MS Visio 2007,TortoiseSVN.
The Private Bank, Chicago, IL Jun 2011 – Dec 2012
Sr SSRS Developer
This Project is to create integrated standalone Statements from Project One. Initially these statements were generated via a different product processor. Now after incorporating them in project one system, it will enable the Private Bank to provide a consistent look and feel to statements for yet another product category.
Responsibilities:
Conduct meeting with clients/business analysts to gather requirements for new developments or change requests.
Developed datasets to perform reporting and created interactive Drill Down, Drill Through, Tabular, Cross Tab, Parameterized, Cascaded and Sub-reports using SSRS 2008/2005.
Implemented SSAS Cubes, Facts and Dimension tables to perform analysis and deploy OLAP cubes on Development server.
Managed the historical data in the data warehouse from various data sources and generated various drill down, drill through, matrix and chart reports from SSAS cubes using SSRS 2008.
Developed/modified Stored Procedures, Views for different reports and performed optimization techniques for these database objects to improve the performance.
Responsible for fixing all the Production defects logged by the business users
Responsible for Report Deployment, documenting changes on VSTS for each onsite delivery
Document test cases and perform Unit testing for every change requests/new developments.
Knowledge transfer [Functional/Process flow] to the new team member
Responsible for maintaining the different report versions using Team Foundation Server (TFS)
Extensive use of Visual Studio Team System (VSTS) for bug tracking
Environment: MS SQL Server 2008 R2/2005, BIDS 2008/2005, MS SQL Server Integrated Service (SSIS), MS SQL Server Analysis Service (SSAS), MS Visual Studio Team Suite, Team Foundation Server (TFS)
Genuine Parts Company, Atlanta GA Oct 2009 – May 2011
Sr MS SQL SSRS Developer
Genuine Parts Company (GPC) is a service organization engaged in the distribution of automotive replacement parts, industrial replacement parts, office products and electrical and electronic materials. Project objective was about gathering requirements from end users, troubleshooting report failures, create and review cubes, and prepared various reports for management.
Responsibilities:
Implemented Complex Stored Procedures and automated them using SQL Server Agent
Experienced using Sharepoint to enhance collaboration among the team members.
Programmed Triggers (Instead Of and After) for Auditing Purpose
Played role in design of scalable, reusable, and low maintenance ETL templates.
Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions
Managing the security of the servers, creating the new logins and users, changing the roles of the users.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Environment MS SQL Server 2008, T- SQL MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), VB, VB.NET, Microsoft SQL Server Analysis Services (SSAS),SQL Server Data Tools.
AIM Specialty Health, Deerfield, IL Dec 2008 – Sep 2009
MS SQL Server Developer/ SSRS Developer
AIM Specialty Health is a system in Illinois offering full services of care for several clients around the country. This is a Web based application which is designed to benefit different health care clients. It has several new products which have been launched recently such as Sleep Management System, Radiology and Oncology. It offers two types of web services; Call Center and Provider Physician.
Responsibilities:
Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
Created OLAP models based on Dimensions and Facts for efficient loads of data.
Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
Implemented perspectives and KPI using calculated measures based on requirements.
Identified and defined the datasets for Report generation.
Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.
Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel.
Dell, India Aug 2007 – Nov 2008
SQL Server Developer
Dell Inc is one of the largest computer hardware companies. It is one of the most admired companies in United States of America. The order management dashboard is the tool used by Dell Project Managers and customer care agents to check the status of multiple customer orders. Using this dashboard, customer care agents were able to track and manage order status of all customer purchases with visibility from order to delivery in a near real-time manner.
Responsibilities:
Installed SQL Server Management tools using SQL Server Setup Program.
Tested the Installation of SQL Server.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
Worked on replication server and managed.
Worked on making on the enterprise-wide use of XML applications, content management systems, taxonomies, and search engine optimization.
Environment: SQL Server 2000 Enterprise Edition, T-SQL, Java, C#, VB.Net, ASP.Net, Oracle, Pl/SQL, Enterprise manager, VBS, MSOffice & Windows 2K platform.
Contact this candidate