Sql Server Data
Resume:
Santosh Muthya
SQL BI Consultant
acrsbj@r.postjobfree.com
PROFESSIONAL SUMMARY:
* ***** ** ********** ** SQL Server database development and administration, extensively worked in OLTP, OLAP, Client-Server & Enterprise Data warehouse Environments.
Hands-on experience in Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach.
Expertise on Business Intelligence Tools (SSIS, SSRS AND SSAS).
Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
Extensive experience in designing, developing and deploying SSIS 2008 packages.
Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
Extensive experience in migrating DTS packages to Integration Services Packages.
Excellent experience in developing Reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Experience in defining Queries for generating drill down and drill through reports in SSRS2008.
Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
Good knowledge and experience in SQL 2008 new features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
Experience in installing, configuring and monitoring MS SQL Server 2008/2005/2000 installations.
Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Execution Plan.
Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
Strong knowledge in implementing Transactional, Merge and Snapshot replications.
Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes.
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
Extensive knowledge of Normalization and Database Design Concepts.
Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
Experience in data modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
Experience in developing front-end for the site written in ASP.NET, MS Visual Studio .NET, C#, VB.NET, XML, VBScript, HTML, DHTML, JavaScript, Dreamweaver.
EDUCATION & CERTIFICATION:
Bachelor of Technology in Computer Science
Microsoft Certified in Administering and Managing SQL Server 2005 (MCTS 70-431)
Microsoft Certified in Business Intelligence-Implementation & Maintenance using MS SQL Server 2008(MCTS 70-448)
TECHNICAL SKILLS:
SQL Server Tools
SSMS,BIDS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor
Monitoring & compliance Tools
LiteSpeed, Spotlight, SCOM, SQL secure
ETL& Reporting Tools
SSIS, SSRS, SSAS, Crystal Reports, Business Objects
Databases
MS-SQL Server 2008/2005/2000, MS Access 97/2000, Oracle
Programming Languages
SQL,T-SQL,PL/SQL,C,C++,JAVA,C#,VB
Operating System
Windows 95/98,NT,Windows XP/2003/2000,
Web technologies
HTML,XML,VBScript, JavaScript
Tools
Erwin, Visual Studio 2008/2005,Visio,Visual Source Safe
PROFESSIONAL EXPERIENCE:
Wells Fargo, New York City,NY June 2013- Present
Sr.SQL Server BI Developer
Wells Fargo & Company is an American multinational banking and financial services holding company. It is the fourth largest bank in the U.S. by assets and the second largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards. In 2011, Wells Fargo was the 23rd largest company in the United States.
Responsibilities:
Extensive work on creation of SSIS packages for ETL
Worked with SSIS Variables, SCD, Scripting, event-handlers, package configurations and deployment.
Responsible for analyzing/gathering the user requirements to generate the reports using SSRS 2008.
Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
Identified the Data Sources and defining them to build the Data Source Views.
Performed complex SSIS ETL operations to validate, cleanse, transform and load data to SQL Server 2008.
Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS2008
Involved in SSAS Cubes design by creating measure groups, facts, dimensions, aggregations from huge dataset using SQL Server 2008 Analysis Services (SSAS).
Designed, planed, and developed programs to optimally extract, transform, and load data between data sources.
Created complex SQL queries, stored procedures, functions, joins and SSIS packages.
Developed an ETL High Level Design and created SSIS Standards for the SSIS-ETL Developments.
Working knowledge with tools such as VEEVA CRM, AUTOMATE9.
Custom logging using script tasks and event handlers in SSIS packages.
Active part in building Star schema and Snow flake schema based on the business requirements
Environment: Windows Server 2008R2 & 2012,SQL Server 2008R2, SSIS, SSAS, SSRS, T-SQL, ETL, MS Access, MS SharePoint, VEEVA CRM, AUTOMATE 9
Bank of America, Hope well, NJ Mar 2011- May 2013 Sr.SQL Server BI Developer
Bank of America is one of the world’s largest financial institutions, serving individual consumers, small and middle business and large corporations with a full range of banking, investing, asset management and others financial and risk management products and services.
Responsibilities:
Developed SSIS Packages to migrate data from Oracle, Access, flat files and ExcelintoRepository for further Data Analysis and Reporting using multiple transformations
Responsible for developing, monitoring and deploying SSIS packages.
Created complex SSIS packages using proper control and data flow elements
Involved in SSAS Cubes design by creating measure groups, facts, dimensions, aggregations from huge dataset using SQL Server 2008 Analysis Services (SSAS).
Created complex SQL queries, stored procedures, functions, joins and SSIS packages.
Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
Custom logging using script tasks and event handlers in SSIS packages. Active part in building Star schema and Snow flake schema based on the business requirements
Configured and managed data sources, data source views, cubes, dimensions, roles and hierarchies.
Created SSRS reports from Analysis Services using MDX and DMX Queries.
Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
Deployed the SSIS Packages from development server to production server using package configurations.
Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
Developed reports in SSRS using Analysis services as data source.
Maintained developed source code in the repository for all databases and kept all build programs up to Date.
Environment: Windows Server 2008R2, SQL Server 2008R2, SSIS, SSAS, SSRS, T-SQL, Oracle, ETL, MS Access, MS SharePoint
Union Pacific, Omaha, NE Jan 2010 –Feb 2011
SQL Server BI Developer
The Project involved me to work as a SQL Server Data Analyst/Developer with analysis, manipulation and cleansing of data to produce clear and defined transformed data. Responsibilities include conversion of client data to standard formats using SSIS and T-SQL Queries. Involved in moving historical data to SQL server 2008 from Legacy Databases in the form of excel files. Worked as a database developer for the SQL Server Consolidation Project, wrote complex T-SQL Queries, SSIS Packages and Data Modeling. Provide training to the new SSRS2008 business users and prepared documentation. Other duties being essentially maintaining database consistency, generating custom reports using SSRSand populating data warehouse and data cleansing using SSIS.
Responsibilities:
Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
Responsible for performance tuning and optimization of SQL queries and indexes.
Performed database design by analyzing business requirements.
Reviewed applications and database design for compliance with best practices standards.
Developed an ETL High Level Design and created SSIS Standards for the SSIS-ETL Developments.
Developed SSIS2008 Packages to migrate data from Oracle, Access, flat files and ExcelintoSQL server 2008 for further Data Analysis and Reporting using multiple transformations.
Performed complex SSISETL operations to validate, cleanse, transform and load data to SQL Server 2008.
Developed custom transformations with VB.NET code to load data from Oracle to SQL Server.
Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.
Developed, deployed and monitored SSIS Packages.
Developed custom reports and deployed them on server using SSRS2008.
Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
Identified the Data Sources and defining them to build the Data Source Views.
Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS2008.
Formatted reports using Global Variables, Expressions and Functions for the reports.
Created dashboards with gauges and charts in SSRS2008 in native mode.
Created Report Models to be used by business users for ad-hoc reporting.
Uploaded reports on to the report manager and organized them into folders.
Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
Environment: - MS SQL Server 2008,Windows Server 2008,.NET 2.0, DTS, T-SQL, SSIS, SSRS, SSAS, MDX, OLAP, PPS, MS SharePoint, C#, ASP.NET, VB.NET, ERwin 4.0, ETL, Erwin, MS Access, XML, Excel, Visual Studio 2008.
Hitachi Data systems, Santa Clara, CA Oct 09 – Dec 10
SQL Server Developer (SSIS/SSRS/SSAS)
The Project involved me to work on SQL Server 2005 for the data migration project using SSIS, my major roles and responsibilities included developing SSIS Package for integrating data from Excel, CSV, Oracle, flat files into SQL Server 2005.Involved in source data analysis, transformations and performance tuning of ETL Operations. The project involved me to work more as an SSRS developer to create reports for analysis, SSAS developer to build facts and dimension tables for efficient analysis and reporting and also as a DBA to monitor client’s databases on production server. The project also involved the setting up new instances of SQL Server 2008.
Responsibilities:
Developed and Optimized database structures, stored procedures, Triggers and Functions for the application.
Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
Involved in Performance tuning the Stored Procedures to by removing unnecessary cursors
Responsible for DTS to SSIS Migrations, designing and maintaining SSIS packages.
Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2005
Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support.
Responsible for developing, monitoring and deploying SSIS packages.
Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
Designed and populated reporting tables, views and stored procedures.
Responsible for analyzing/gathering the user requirements to generate the reports using SSRS 2005.
Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
Identified the Data Sources and defining them to build the Data Source Views.
Developed Query for generating drill down and drill through reports in SSRS 2005.
Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
Created SSAS Cubes using snow-flake schema with Facts, Measure Groups and dimensions.
Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
Created SSRS reports from Analysis Services using MDX and DMX Queries.
Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
Involved in implementation of replications like Snapshot and Transactional.
Designed logical and physical data models using Erwin.
Environment: MS-SQL Server 2008/2005, Windows Server 2003/XP,T-SQL, SSIS, DTS, SSRS, SSAS, MDX, OLAP, ProClarity 6.1, C#, VB.NET,ASP.NET,MS Access 97/2000,Oracle, XML,Excel,ERwin4.0,MS SharePoint, Visual Studio 2005
Asian Paints Mumbai, India April 07 – Sep 09
SQL Server Developer
Served as a Software Programmer for the development of automation of Construction projects using SQL Server 2000 and Visual Basic and .NET as front-end tools. This project consists of various modules pertaining to customer maintenance, stock monitoring (construction wear n tear), and printing bills and generating reports.
Responsibilities:
Actively participated in gathering of User Requirement and System Specification.
Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2000.
Succeeded migrating old data from legacy system into SQL Server 2000 using DTS and Backup and Restore option.
Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
Created Users and Roles, and managed security and permission of database.
Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.
Actively participated in User Acceptance Testing, and debugging of the system.
Environment: SQL Server 2000 Enterprise Edition, .NET, VB, Crystal Reports
Contact this candidate