Sql Server Data
Resume:
SAIKRISHNA
SQL BI DEVELOPER
***.************@*****.***
PROFESSIONAL SUMMARY:
Over 5+ years of extensive experience in Database design, development and administration of applications with MS SQL Server versions 2014/2012/2008R2/2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
Involved in all the stages of Software Development Life Cycle including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
Hands on experience in installing, configuring, managing, monitoring SQL Server 2008/2005/2000
Experience with Fragmentation and Query analyzer for SQL Server 2005/2008/2012/2014 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
In depth knowledge in T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
Experience in Database Backup, Recovery and Disaster Recovery procedure.
Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Reporting, Designing logical/physical databases and Troubleshooting.
Experienced 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/2005.
Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
Experience in Migrating DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
Experience in Integrating SQL Server Reporting Services (SSRS) with Microsoft Office Share Point Server (MOSS 2007).
Good understanding in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling, Fact and Dimensions Tables using MS Analysis Services.
Experience with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models.
Good team player with strong analytical skills.
TECHNICAL SKILLS:
Programming Skills
T-SQL, C, HTML, CSS,, ASP.NET, VB, C#
RDBMS
MS SQL Server 2014/2012/2008/2005/2000, MS Access.
Database Design Tools and Data Modeling
MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables. SQL Query Analyzer, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server.
BI Tools
SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013
Operating Systems
UNIX, LINUX, Windows7 Vista/XP/2003/2000, NT & Windows 9x and MS-DOS
Systems familiarity
OLTP,DSS,OLAP
Tools and Utilities
SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)
Methodologies
Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling
PROFESSIONAL EXPERIENCE:
Client: AON INTEGRAMARK, Atlanta, GA March ‘14 - Present
Sr. MS SQL BI Developer
As part of Aon, Aon involves Debt cancellation based programs, offer lenders new opportunities to add value to their consumer lending businesses. These programs provide lending customers with new power and control over their finances, especially in tough times that can affect anyone. The Aon debt cancellation experts work hard to build a stable marketplace for both lenders and borrowers to benefit from these programs. I have been involved in developing and supporting a lender's debt cancellation program with a team of BI Developers, and end-to-end solutions that deliver results.
Responsibilities:
Developed all the required stored procedures, user defined functions, triggers using T-SQL.
Creation and maintenance of SSIS Packages (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL.
Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
Prepared technical documents like High Level Design
Involved in Business Analysis & Requirement collection. Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS.
Migrating Databases to Azure SQL Database by generating the scripts from the existing
database.
Migrate the data from an Access database to SQL Server 2008.
Developed web application for reporting portal using .NET, ASP.NET, C#, VSS
Used VB.Net Code to create embedded functions in SSRS.
Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
Understanding Customer requirement via interaction and writing functional specification.
Wrote complex stored procedures and cursors to implement various business logics as per the client requirements
Optimizing existing queries and fixing query performance issues using SQL Optimizer, SQL Profiler.
Actively interacted with end user to gather business requirement, system specification and enhancement.
Environment : MS SQL Server 2014/2012, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9 i/ 10 g; DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Windows XP, C#, ASP.NET, BizTalk Server, JavaScript, XML, Erwin v4.1, MS Office 2013
Client: EY, Dallas, TX OCT‘12 – FEB ‘14
Role: SQL Server Developer (SSIS/SSRS)
Affordable Care Act: A federal statute that was signed into law in March, 2010. Its goals are to increase the quality and affordability of health insurance. Coverage under ACA ends pre-existing condition exclusions on health plans, keeps young adults under the age of 26 covered under their parents’ health plan, covers preventative care at no cost, guarantees your right to appeal denials, and ends lifetime limits on coverage.
Responsibilities:
Performed server installation and configuration using SQL server2012.
Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
Involved in XML Development and XML File Parsing in SSIS and SSRS.
Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
Created automated stored procedures for day end operations using SQL server agent.
Coordinated with front-end for implementing logic in stored procedures and functions.
Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSAS and SSIS.
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition
Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base
Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
Created Packages that Transfers Databases from One SQL Server instance to Another Instance and Scheduled the SSIS package for migration of data from old system to MS SQL 2012
Using SSIS, loaded XML data to the Database tables and Extracting Data using SSIS into Excel Files for Marketing purpose
Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, and 2000.
Worked in Enterprise Manager for job scheduling and batch queries.
Monitored performance and optimized SQL queries for maximum efficiency.
Implemented fine tuning of database objects and server to ensure efficient data retrieval.
Managed and monitored the use of disk space.
Planned Backup strategy based on projects requirements.
Worked with DTS packages and MS OLAP Services.
Maintained the consistency of the client’s Database using DBCC.
Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
Responsible for testing to optimize the procedures and triggers to be used in production.
Involved in project planning also schedule for database module with project managers.
Environment: MS SQL Server 2014/2012, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9i/ 10 g; DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Windows XP, C#, ASP.NET, BizTalk Server, JavaScript, XML, Erwin v4.1, MS Office 2013.
Client: VeLink Software Solutions, India Jan ‘11– Aug ‘12
SQL Server Developer
The VeLink Software Solutions provides best Web Portal development solution and Portal Maintenance Service for B2B, B2C portal development, E-Business & E-Commerce solutions. The VeLink Software Solutions also provides Outsourcing for Portal design and Offshore Portal Maintenance. Over the past several years developers at The VeLink Software Solutions have developed numerous portals for its clients located in various countries of the world.
Responsibilities:
Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
Responsible for Design and Normalization of the database tables.
Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
Worked with customers on Application rollouts and server migrations.
Responsible for Performance and tuning of SQL servers and application issues related to migration.
Gathered requirements for the creation of Data Flow processes for the SSIS packages.
Used various Control Flow Tasks in the development of various complicated packages.
Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
Contact this candidate