Sql Database Analyst / Sql Reporting/analysis/integration Analyst/sql Bi Developer Resume
Atlanta, GA
SUMMARY:
- Highly motivated Developer with 10+ years of Experience in Database Design, Development and Support of Microsoft SQL Server 2005/2008/2008 R2/2012/2014 in Development, Test and Production Environments with various business domains like Telecom, Financial, Manufacturing, Healthcare and RMS - enabled applications.
- 7+ years of Strong experience in ETL Development, Business Intelligence Development (SSIS, SSRS, and SSAS) with extensive knowledge in Data Warehousing.
- Expertise in system analysis, design, development, testing and implementation of projects (SDLC).
- Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.
- Experience with SQL Server and T-SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
- Strong experience in Creating both UDF (User defined Functions) and System defined functions and implementing correct system defined functions. Expert in creating scalar functions and CLR functions.
- Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
- Efficient in creating joins and sub-queries for complex queries involving multiple tables.
- Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
- Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
- Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler.
- Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
- Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
- Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
- Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
- Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
- Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008 R2.
- Experience in Visual Studio Team Foundation Server, SVN repository, Visio.
- Data Warehouse and ODS (Operational data store) usage to create reports.
- Extensive experience in SQL 2005 Partitioning of Tables and Indexes, for Performance, scalability and manageability of Very large databases (VLDB).
- Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
- Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
- Performing SDLC support services, Duties include new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects and client expectations.
- Experienced in Validating Data and Profiling.
- Expertise in developing MS SQL Server Analysis Services 2012 Tabular Model
- Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
- Excellent written and oral communication skills with a results-oriented attitude.
- Knowledge on Batch Processing
- Good Knowledge of MS Access 2007/2010/2013
TECHNICAL SKILLS:
SQL Server Tools: SQL Server Management Studio(SSMS), SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE
IBM Tools: IBM DB2.
Languages: C, C++, SQL, T-SQL, PL/SQL, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, AJAX, XML, certification on (core java)
Operating Systems: Windows 95/2000/2003/ XP/VISTA/7/8/8.1,UNIX, LINUX
MS: SQL Server 2012/2008 R 2/2008/2005/2000, MS-Access 2007/2010
ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.
Scripting: HTML, DHTML, XML, Shell Scripting, Power Shell 2.0, Java Script
Reporting Tools: SSRS, SSAS, Crystal Reports, Report Builder 3.0.
DB Utilities and design tools: SQL Server Management Utility, SSAS Cubes, Tabular Model Query Analyzer, MDX scripting, DAX queries
Application Software: Visual Studio, SQL dialect, MS Office (MS Access 2007/2010/2013 )
Data warehousing tools: Agile, Waterfall Teradata
PROFESSIONAL EXPERIENCE:
Confidential- ATLANTA, GA
SQL Database Analyst / SQL Reporting/analysis/integration Analyst/SQL BI Developer
Responsibilities:
- Working in a fast paced team for performing building database architecture, Integrated DTV Merger data and helped in creating business reports for ISM project and EG group on transfers Confidential &T.
- Skilled in development and tuning of SQL queries, Stored Procedures, data extracts, Data analysis and query optimization, and other performance tuning.
- Write advanced SQL queries and stored procedures to perform complex database tasks using T-SQL and Teradata 14.0 and implemented best practices to maintain optimal performance.
- Design, develop, maintain, support and test advanced SSIS packages across Dev/UAT/Prod environments.
- Design, develop, maintain, support and test advanced SSIS packages related to the extraction, transformation and loading (ETL) process from different data sources (Oracle, Teradata, SQL Server Flat Files, Excel source files, XML files and other Legacy systems)
- Created various SSRS Reports involving variety of features like Scorecard reports, Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Reports, and also involved in Dashboard reporting, Share Point with Power View tool etc.
- Created several Ad hoc reports, linked reports using global variables, Day to day hierarchy/measures report, trend hierarchy report, matrix reports, subscription reports using store procedures and dynamic sql
- Designed and developed SSAS tabular model for data analysis using DAX queries and also multidimensional cubes analyzing the transfer measures using MDX queries.
- 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.
- Created and developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
- Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL. Worked with Change Data Capture Task
- Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
- Involved in validating data using sql queries, testing data and reports and doing UAT before production
Environment: MS SQL Server 2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, MS Access, Teradata 14.0, SQL Server Agent, SQL Server Reporting Services (SSRS), Tabular model, SVN Repository
Confidential - San Diego, CA
MS SQL Server / SSIS, SSRS/BI Developer SQL Server/ BI Developer
Responsibilities:
- Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards, and scorecards.
- Involved in business analysis and technical design sessions with business and technical staff to develop dimensional models, requirements document, and ETL specifications.
- Created ETL packages with different data sources (SQL Server Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
- 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.
- Created and developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
- Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
- Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
- Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL. Worked with Change Data Capture Task
- Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
- Deployed SSIS packages with minimal changes using XML configuration file.
- Migrated packages from legacy systems (DTS-SSIS) and deployed the packages across Dev/UAT/Prod environments.
- Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
- Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Reports, and also involved in Dashboard reporting, Share Point with Power View tool etc.
- Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems
- Wrote complex SQL Queries using multiple joins for creating Ad hoc reports using Report builder based on the requirements.
- Designed SSRS reports with sub reports, Ad Hoc reports sorting, defining data source and subtotals for the report.
Environment: MS SQL Server 2008 R2/2012, Micro strategy, MS Access, MS SQL Integration Services 2008 R2/2012, Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, IBM DB2, SQL Server Agent, SQL Server Reporting Services(SSRS),visual studio 2010
Confidential - Orlando, Florida
SQL Server BI Developer
Responsibilities:
- Designed application that collects client transaction volumes for WSS Custody and Sub-Custody products, applies unit costs, and produces a monthly export to the T&SS Costing system (CIIS).
- Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
- Created functions and developed procedures to implement application functionality Confidential the database side for performance improvement.
- Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
- Created DTS and SSIS packages.
- Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
- Created SSIS package to get data from different sources, consolidate and merge into one single source.
- Created ETL package for data conversion using various transformations tasks.
- Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
- Created dash board to show the business performance.
- Created partitions and designed aggregations in Cubes.
- Created perspectives in SSAS and configured security levels for the Cubes.
- Designed KPI’s in SSAS and imported them to Excel.
- Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
- Created Ad hoc reports using SSRS.
- Created reports that call Sub reports in SSRS.
- Created datasets for reports using T-SQL and stored procedures
- Responsible for maintaining cubes using SSAS and populate the cubes with the data.
- Responsible for Query optimization and Performance tuning
- Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS 2012.
- Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.
Environment: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, Netezza database, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel, MS Access, MS visual Studio, BIDS, MS Power Point 2012
Confidential, IL
SQL Server/ BI Developer
Responsibilities:
- Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
- Created SSIS Packages to integrate data coming from Text files and Excel files.
- Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
- Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
- Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
- Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
- Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
- Created Query Parameters and Report Parameters to control data returned by the query and filter data Confidential report level.
- Created linked, unlinked and on-demand sub Reports.
- Understood the various complex reporting requirements of company and created web reports.
- Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
- Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
- Established Inner Join, Outer Join and created Indexes whenever necessary.
- Modified report content and exported reports in multiple formats based on user input.
- Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
- Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
- Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
- Created User Defined functions for sharing formulas across multiple reports.
- Modified existing reports according to requirements of the end users.
- Gathered business requirements from customers and created status reports.
Environment: SQL MS SQL Server 2008 R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, Erwin, MS-Access 2010.
Confidential - San Francisco, CA
SSRS/SSIS/SQL Developer
Responsibilities:
- Migrated Data from MS SQL 2005 to MS SQL 2008.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL.
- Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
- Created packages to migrate data from different data sources to Data warehouse.
- Created packages for database maintenance.
- Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
- Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
- Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
- Created SQL Server Reports using SSRS 2008 for the clients.
- Created parameterized reports for the brokers and clients.
- Deployed the developed reports and upgraded the system.
- Deployment of the developed reports on to the server for the end users.
- Supported 24/7 for the production system for post deployment Reports on the server.
- Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
- Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
Environment: SQL Server 2008/2008 R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), DTS, Visual SourceSafe, OLAP, Performance Point Server, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory, DB2 (Main-Frame), Erwin 5.1,Database Diagrams, VB Script, VB.Net, Power point 2008.
Confidential
Jr. MS SQL Developer
Responsibilities:
- Created tables, views, indexes based on the requirements
- Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
- Involved in designing of Conceptual Logical Model and Physical Model.
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity .
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
- 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
- Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
- Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
Environment: MS SQL Server 2000/2005, T-SQL, DTS, Oracle 8i/9i, TOAD, Micro strategy, Microsoft Visual Source Safe, MS Visio, MS Projects