Sql Server Data
Resume:
Krishna
Sr.SQL BI (SSIS, SSRS, SSAS) Developer
E-mail: *************@*****.***
Mobile No: 484-***-****
SUMMARY:
Around 6+ Years of IT Experience in Business Analysis, Database Analysis, Data Modeling and Microsoft Business Intelligence Stack (SSIS, SSRS, SSAS).
Good knowledge in Business Modeling and Data Modeling.
Very good T-SQL Programming skills.
Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
Experience with logical and physical data modeling, FACT and Dimensional tables and database design.
Experience in debugging, maintenance of ETL packages and ETL optimization using SQL Server best practices.
Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
Strong understanding of relational database concepts and vision, with proven ability in writing complex and efficient SQL queries.
Experience in creating stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
Experience in writing complex SQL queries involving multiple tables, inner and outer joins, views and synonyms.
Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
Used SQL Profiler, Execution Plan, Performance Monitor to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
Worked with different Clients/Business to get the user requirements and developed different kinds of SSRS reports based on their requirements.
Experience in using variables, expressions and functions and also defining Query for generating reports in SSRS.
Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
Experience in creating Jobs, Alerts and scheduling SSIS Packages.
Developed excel reports through Power pivot and Pivot tables.
Good Knowledge in creating Matrix Reports, Drill-Down Reports, Chart Reports and Sub Reports. using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
Experience in SSAS with all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
In depth knowledge in creating, modifying, deploying and browsing the cubes with multiple measures and multiple dimension hierarchies in SSAS.
Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
Involved in all the stages of Software Development Life Cycle mainly in Database design, data access and development using MS SQL Server 2012/2008R2/2008, Oracle 11g/10g and Web Applications development.
Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
Involved in DBA activities such as backups, restores, replication and creating Logins, Roles on different databases.
Good exposure in understanding the Business needs and rapid ability to changing environments.
Good at managing all the IT operations and capable on completing the tasks with the ability to work with priorities under tight deadlines.
Good domain knowledge in developing the reports and worked with Inventory management, health care, Production, Finance and Costing.
Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.
TECHNICAL SKILLS:
Databases Tools
SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Data Tools, SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS)
ETL Tools
SQL Server Integration Service (SSIS), Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS)
Reporting Tools
SQL Server Reporting Services (2005/2008 R2/2012), Report Builder 3.0, OBIEE
Data Modeling tools
Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports8.5,10, XI, R2, Business Objects
Database
MS SQL Server 2008R2/2008/2005/2012, MS Access, Oracle11g/10g/9i, PL/SQL
Portal Technologies
SharePoint 2010, Microsoft Office SharePoint Server 2007, Office 2010, Share Point Designer2010.
Applications
Microsoft Business Intelligence Development Studio 2010, Report Builder, Share point 2010, Power Pivot.
languages
C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX, RDBMS, SQL Server 2000/2005/2008R2/2012 T-SQL, Oracle 11g/10/9i Pl/SQL
PROFESSIONAL EXPERIENCE:
Client: Comcast, PA Oct 2015 - Present
Sr. SSRS Report Developer/OLAP Developer
Description: Comcast is a leading provider of information, entertainment and communication products and services. It provides services such as High-definition video, High-speed internet, Digital Voice, Wireless High-speed Internet and communication solutions. The aim of the project was to create Data Warehouse from Comcast's existing database and to create reports to provide business decisions to users.
Responsibilities:
Interacted with the Business/Customers about the reports and gathered requirements from them to enhance the reports and worked hard to meet their business needs.
Designed, modified database objects such as tables, views, indexes, Stored Procedures, defaults, user defined data types and functions.
Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
Implemented performance tuning T-SQL queries, Stored Procedures and SSIS Packages, Peer reviewed T-SQL code/SSIS packages.
Examined execution plans, created covering indexes and filtered indexes when necessary for Tuning SQL queries.
Developed Parent - Child packages to load data, ensuring restart ability anytime without having to manually delete partially loaded data from the destination tables.
Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.
Performed unit integration and functional testing of the SSIS packages, T-SQL and Stored procedures.
Implemented SQL Server Service Broker (SSBS) to keep data in sync between tables across different databases.
Created database snapshots, restored databases from snapshots in Cert environment.
Designed, developed, debugged and tested SSIS packages, SSRS reports and T-SQL Stored Procedures.
Extracted and transformed data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS into destination tables as per the business requirements.
Converting already existing SSIS packages which are pointing to SQL Server to Oracle.
Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle.
Created/Modified multiple SSIS packages. SSIS packages were used to bring the application data from SQL Server to oracle and to text files as extracts/reports. Also used SSIS packages to store data on third party FTP sites.
Administered, monitored and supported SSIS Packages and ETL process. Wrote support documentation for SSIS packages/SSRS reports and stored procedures.
Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server.
Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes.
Wrote production implementation documents and provided Production support when required. Implemented MS SQL Server Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
Wrote MDX queries for OLAP cube.
Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
Deployed the reports to Share Point Server and worked on different kinds of environments like Development, Production and Testing.
ENVIRONMENT: Windows server 2008, MS SQL Server-2012/2008 R2 Enterprise Edition, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Microsoft Power pivot, Excel Pivot Tables, Oracle11g.
Client: Lincoln Financial group, IN April 2015 -Oct 2015
Sr. MS BI Developer
Description: Lincoln Financial Group is the national leader in redefining insurance, retirement and financial security for its customers. The project aim was to create a web-based application that displays the clients that are held in various reports. The application takes the Clients Social Security Number or name and displays their holdings.
Responsibilities:
Interacted with the Business/Customers about the reports and gathered requirements from them to enhance the reports and worked hard to meet their business needs.
Involved in the complete SDLC by analyzing the requirements, designing the model and creating a complex set of reports based on the User’s Criteria.
Worked efficiently on OLAP Data Warehouse, Design, Model and Implementation.
Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
Designed and developed stored procedures and views which are necessary to support SSRS reports.
Experience in creating calculated measures, partitions and worked with different dimension hierarchies in MDX for developed reports through Reporting Services.
Involved in analyzing the OLAP Cubes to pull the data in order to build the different types of reports.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
Using SQL server reporting services (SSRS) delivered enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
Created Excel reports through writing MDX Queries with Power Pivot and even used Pivot tables to create different kinds of excel reports by writing the formulas.
Generated various Report models on Views and deployed them on to the production server.
Used checkpoints to implement the restart ability of the packages in SSIS.
Implemented custom logging in SSIS using event handlers and execute SQL task.
Making Enhancements to the reports and analyzing the data in a much focused manner to get the accurate results.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment.
Deploying the reports to Share point Server and sending the reports to Business for testing.
Created different Parameterized reports, Drill-through, Drill-Down, Linked and Sub Reports through Analysis Services.
Created cube structure for the analysis of business condition and for creation of report using SSAS.
Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005 (SSAS).
Deeply analyzing SSAS cubes data in order to match with the data which the Business has been using.
ENVIRONMENT: SQL Server 2008 R2, SSAS, SSIS, SSRS, T-SQL, Crystal Reports, MDX 2.0/4.0, OLAP, OLTP, Excel, HTML, CSS, Oracle 10g.
Client: Capital One, VA Feb 2014- Mar 2015
SQL Server Developer (SSIS/SSRS/SSAS)
Description: Capital One Financial Services is one of the top credit card issuers in the United States. The company offers Visa and Master Card plastic with a variety of annual percentage rates, credit limits, finance charges, and fees. The project involved developing sales reports and statistics to cover weekly, monthly, quarterly and annual historical information for the Sales department database and creation of the data warehouse using SSAS.
Responsibilities:
Involved with business and functional people to collect and gather requirements
Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
Involved in writing queries for Stored procedures, clustered and non-clustered indexes.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
Creating complex SSIS packages using proper control and data flow elements.
Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
Designed and implemented Parameterized and cascading parameterized reports using SSRS.
Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
Implemented Mock report layouts before the actual report implementation.
Designed cubes with Star Schema using SQL Server Analysis Services 2008R2 (SSAS).
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
ENVIRONMENT: Windows server 2008, MS SQL Server-2008 R2 /2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Oracle 9i, Performance Point Sever.
Client: Complete Healthcare Communications, PA Jan 2013- Nov 2013
SQL Server Developer (SSIS/SSRS/SSAS)
Responsibilities:
With project planning, participating in client meetings for understanding functional and business prospective of the project.
Created databases, tables, views, Joins, triggers, functions, union, Merge, indexes, constraints, stored procedures and SSIS packages based on business requirements.
Experience in creating complex SSIS packages using proper control and data flow elements.
Worked with different methods of logging in SSIS.
SSIS packages build with OLEDB data sources from Mainframe SAS files and loaded the data into target SQL Server database by performing different kinds of transformations like Lookup, derived Columns, conditional split.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Worked on Tidal Job scheduler for scheduling batch files which contains the SSIS packages using DTExec command.
Deployed the SSIS Packages to DEV and QA Environments and then deploy into Production.
Created SSRS reports for Payroll system with using Tabular, Matrix reports, Charts and graphs as per HR Management requirement.
Involved building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
For understanding the existing SSAS cubes.
Involved and implemented facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008/2012 that maintained data.
Hands on experience in Creating Star Schema and Snow Flake Schemas.
For creating documentation on the entire Project that we developed and validate the information that we took from other team and also useful for giving demos to higher management.
ENVIRONMENT: Windows server 2008, MS SQL Server-2008 R2/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin, OLAP, OLTP, Performance Point Sever, Office-2007, MS Excel.
Client: value labs, Hyderabad, INDIA Nov 2010- Dec 2012
Jr. SQL Server Developer
Responsibilities:
Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
Created and Modified Stored Procedures, Triggers, Views according to the business.
Developed various reports to validate the data between source and the target systems.
Experience in Database Backup, Recovery and Disaster Recovery procedures.
Extensive use of T-SQL DDL and DML commands for various applications.
Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
Worked with SQL and PLSQL to create Tables, Views, and Triggers and stored Procedures.
Normalization and De-Normalization of tables.
Designed and developed DTS packages for transferring data from flat files and Access files.
Good understanding of Data warehousing concepts, OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
Extract Transform Load (ETL) development Using SQL 2008R2 Integration Services (SSIS).
Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
Involved in designing, developing, debugging and testing the reports in SQL Server Reporting Services (SSRS).
Used SSIS to unite data from existing system and performed transformations on MS SQL 2008R2.
Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Prepared daily and weekly status reports and collaborated with other team members.
ENVIRONMENT: MS SQL Server-2008 /2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, MS Access, MS Excel.
Client: METASUN Telecom pvt. Ltd, Hyderabad, INDIA Jul 2009- Nov 2010
Jr. SQL Server Developer/ DBA
Responsibilities:
Involved in creating Stored Procedures, views, tables, constrains.
Created stored procedures and triggers for Data consistency.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
Rebuilding the indexes at regular intervals for better performance.
Using log shipping for synchronization of database
Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Moved files between the File Groups and partitioned the tables to improve the performance.
Monitoring SQL server performance using profiler to find performance.
Wrote complex stored procedures to process employee’s requirement and generating.
Worked on complex T-SQL statements, and implemented various codes and functions.
Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
ENVIRONMENT: MS SQL Server 2008/2005, Enterprise Manager, MS Access, MS Excel, MS Word, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports, VMware, RedGate, Clustering.
Contact this candidate