Sr.reporting Advisor Resume
Fort Mill, SC
SUMMARY
- Experienced SQL Developer with over 8 years of experience with SQL Server and T - SQL in constructing Tables, Triggers, User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
- Experienced in developing database scripts (DML/DDL), Stored Procedures and other database objects necessary to accomplish project objectives
- Good knowledge throughout database development for both OLTP (batch processing and online processing) and OLAP Systems (SSRS, SSIS and SSAS) using SQL Server
- Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat File and Oracle to MS SQL Server by using BCP utility, DTS and SSIS services
- Extensive ETL experience using DTS/SSIS for data extractions, transformations and loads
- Good experience in developing complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with the ability in generating Drill Down and Drill through reports with Drop down menu option
- Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running database consistency checks using DBCC.
- Good knowledge in scripting T-SQL Queries, complex Stored Procedures, User Defined Functions (UDF) and database Triggers.
- Experienced in Oracle supplied packages, dynamic SQL, records and PL/SQL tables
- Extensive experience in Tableau in enterprise environment
- Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence process for data integration and migration services.
- Experienced in high-level design of ETL packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat File and Text Format Data) by using different transformations
- Good experience in creating SSIS Packages to manage SQL Server databases and SQL Server objects between instances of SQL Server
- Extensive knowledge in designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data
- Strong experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
- Expertise in creating perspectives, partitions and design aggregations in cubes using SSAS
- Expertise in creating dashboard reports to support end users using SSAS.
- Experienced in developing OLAP cubes using SSAS for data mining and created reports from OLAP cubes using SSRS and Report Builder 3.0.
TECHNICAL SKILLS
Languages: C, T-SQL, PL/SQL, JavaScript, C#, VB.Net, .Net, VBA RDBMS SQL Server MSAccess and MySQL, SQL Plus.Frontend MS Visual Basics 6.0, Web Technologies HTML, XML, JavaScript, PHP, Shell Scripting and PowerShell 2.0. Version Control Visual SourceSafe and Clear Case.
SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS and Data Transformation Services.Data Modeling ERwin and MS Office Visio
Operating Systems: Windows 2000, Windows Server 2003, Windows NT, Windows XP/Vista/7/8 and Linux Methodologies Logical and Physical Database Design, Star Schema, Snow Flake Model, UML Database Design and Normalization
PROFESSIONAL EXPERIENCE
Confidential, Fort Mill, SC
Sr.Reporting Advisor
Responsibilities:
- Expertise in database activities likeData Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
- Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema
- Configured and trained users to use Reporting Services.
- Documented and maintained database system specifications, diagrams, and connectivity charts.
- Involved in Design of Business requirement documents as per the client Business requirements
- Provided 24 X 7 dedicated Support for Production, QA & Development environments.
- Evaluated database performance and performed maintenance duties such as tuning,backup, restoration and disaster recovery.
- Organize professional with excellent Oral and written communication skills.
- Ability to work on fast paced work environment.
- Development ofcustom scripts and stored proceduresfor data import and manipulation Proactive and Reactive tuning of databases in every stage of the project.
- Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
- Used cascaded parameters to generate a report from two different Data Sets
- Involved with Query Optimizationto increase the performance of the Report.
- Developed Reports for business end users usingReport Builderwith updating Statistics.
- Involved inUATand Integration testing withQAteam.
- Involved in the creation of different scripts and functions usingPL/SQLin ORACLE
- Involved inPartitioningfor increase in Performance and availability of data.
- Good knowledge in developing and designing reports throughSSRSandExcel
- Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize
- Performance, implementing technology solutions, and /supporting end users.
- Experience in creating schedulingJobs, Alerts, andSQL Mail Agent
- 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).
- Created horizontalpartitioningof data for different file groups.
- Production support, troubleshooting and debugging in a high volume transaction processing environment utilizing a lot ofXML.
- Created Data Dictionaries Documents for clients
- Involved inUATand Integration testing withQAteam.
- Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
- Experienced in Database design, Coding, unit testing and Implementation.
- Proficient in creatingIndex, Views, Complex Stored Proceduresand appropriateUser defined functions.
- To Run the Card Reports for SLA & KPI Insights on Daily basis and Monthly basis as per the Requirement’s
- Involved for Daily Tasks as per the super Agile process
- Supported on New products Launch to handle the creation of the DTA/IBR /Mapping Document.
- Supported FFA data feed during the New Product Launch.
- Ownership on Designing and implementing automated deployment system which is been used for deployments on all enterprise environments
- Created and Resolving the services tickets been opened for Report or portal issues
- Experienced in Review of Test plans for approval, Responsible for creation of CAB forms
- Experienced to validate /Raise the installs, updating the status of Work items on daily basis at Team Foundation Server (TFS) and SharePoint.
Confidential - Charlotte
SQL Server BI Developer/SSIS/SSRS/SSAS
Responsibilities:
- Used SSIS to migrate data from databases such as Oracle and SQL Server database, flat files to centralized IT destination and built SSIS Packages to pull data from Teradata.
- Developed monitored and deployed SSIS packages and created dynamic configuration packages in SSIS.
- Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008/2005 environment, and deploy data.
- Used Event Handlers for exception handling in SSIS Packages
- Developed incremental data logic to load data into SQL Server using SSIS from Teradata
- Developed Report Models using Report Builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
- Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel PowerPivot table based on OLAP cubes.
- Identified and worked with multivalve parameters for parameterized reports in SSRS.
- Developed monitored and deployed SSIS packages and created dynamic configuration packages in SSIS.
- Conducted error handling in SSIS (ETL) using Event Handlers
- Designed and built dimensions and cubes with Star Schema using SQL Server Analysis Services (SSAS).
- Trained the end-users to access OLAP cube using Excel Powepivot
- Developed and supported client facing ASP.NET web applications that use SQL Server as a backend that meet functional and information requirements of the user community.
- Used Teradata SQL Assistant to extract data from Data Warehouse
- Wrote VB.NET (Framework) code, according to the requests
- Developed and maintained old and new VB.NET environments.
- Experienced in programming in VB.NET Framework, VBA and SQL
- Developed Excel templates (VBA, Macros) that retrieved information
- Developed VBA programs to export and import data
- Developed Access/VBA programs to convert Excel data into XML format
- Used JSON objects to communicate between request and response, pass as the parameters.
- Created documentation on each step in database and execute quality assurance test plans.
Environment: MS SQL Server 2008R2/2008, SQL SSIS, SQL SSRS, PowerPivot, T-SQL, Oracle, PL/SQL, SQL Plus, Visual Studio 2012, .NET (C# and VB), VBA, Windows Server 2012, MS Office 2010. SQL Server Management Studio, MS Excel, Teradata and Erwin
Confidential
SQL Developer
Responsibilities:
- Conducted performance tuning/MS SQL Server development - SQL Profiler, SQL scripts, Stored Procedures, Triggers, Functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
- Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
- Created and developed Stored Procedures and Triggers to handle complex business rules, history data and audit analysis.
- Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager
- Created and administered multiple development, and production databases.
- Developed and created data dictionary, advanced queries, views, indices and functions for databases.
- Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
- Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
- Data migration (import & export - BCP) from Text to SQL Server
Environment: SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2005, Windows Enterprise Server 2003, ADO.NET, Team Foundation Server (TFS), XML, HTML and ERwin.