Sql Server Data
Resume:
Srikanth kairamkonda
SQL/BI Developer
********.********@*****.***
Professional Summary
Over 5 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2005/2008 R2 and 2012 in Production, QA and Development Environments.
Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
Ability to work in all stages of System Development Life Cycle (SDLC).
Experience in Error handling and debugging coding issues and troubleshoot production problems.
Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
Expertise in SQL Server 2005, 2008 R2/2012 Reporting Services (SSRS), SQL Server 2005,2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005 Analysis Services (SSAS) in Business Intelligence (BI).
Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2005/2008 R2 and 2012).
Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
Experience in developing Dashboard, Ad-hoc and Parameterized Reports, creating complex reports (ex: drill down reports using different objects) using SSRS.
Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
Worked extensively on Extraction, Transformation and Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
Good experience in creating OLAP cubes using SQL Server analysis services (SSAS).
Experience in working with Database setup, partitions and maintenance.
Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
Good understanding of Normalization/De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
Experience in managing large data sets on MS Excel 2013
Skilled in design of logical and physical data modeling using Erwin data modeling tool.
Worked with Business Analysts, Web development team, and users on database solutions.
Technical Skills
Tools &Packages
SQL Server Management studio, Enterprise Manager, Profiler, SQL
Server Business Intelligent studio (BIDS), DTS, Report Builder 9.0,
HP QC, ProClarity 6.2, SharePoint 2007, Team Foundation Server
BI Tools
SSIS, SSAS, SSRS.
Databases
MS SQL Server 2000/2005/2008, 2012 MS Access 97/2003/2005/2008.
Language
T-SQL, PL/SQL, MDX, C, VB.net, C# (.NET)
Operating Systems
Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.
Application Packages
MS Office Suite, MS Outlook, Windows SharePoint Services.
Data Modeling Tools
MS Visio, Erwin
Education
Masters
In Computer Science, San Jose CA
Bachelors
Electronic and Communication, CMR Institute and Technology, Hyderabad
Professional Experience
PayPal, San Jose, CA Sep ‘16 – Till Date
SQL Server/SSIS Developer
Responsibilities:
Designed Contract Retention database using SQL Server 2008 technology
Designed and developed data models for the data warehouse using star and snowflake schema.
Developed data mapping documentation to establish relationships between source and target tables including transformation processes
Developed and implemented SSIS 2008 ETL processes to load data from source files to target table
Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated, and worked with Script Task to perform a custom code.
Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
Develop DTS script to migrate data from SQL*Server database to Oracle database.
Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed ERP application. Reverse engineered various application to develop data mapping between the two applications and implemented PL/SQL migration scripts to load data across multiple table by maintaining data integrity
Programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic.
Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.
Created additional ad-hoc reports using MS Access for Operations Director.
Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users. Also, generated reports in different formats such as csv, pdf, rpt & txt etc.
Generated Reports using Global Variables, Expressions and Functions for the reports.
Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, OLAP, OLTP, MDX, C#, ASP.Net, Data Mart, ETL, MS Office 2010.
Plum Healthcare Group, San Marcos, CA Nov ‘15 – Aug ‘16
SQL Server/SSIS/SSRS Developer
Responsibilities:
Involved in new BANNER DB design and created ETL using SSIS from legacy systems.
Designed ETL sync bridges for Staff, Building and Department data using T-SQL and SSIS for supporting internal applications.
Created and modified already existing stored procedures, triggers, views and indexes.
Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
Tested queries to optimize the procedures and triggers to be used in production.
Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
Extensive experience in using SSIS transformations like Lookup, Data conversion, Aggregate, condition split.
Hands on experience with Variable, Script Task and Execute SQL Task in SSIS using VB Script and T SQL.
Experience in counters, error handling, and event handlers, re-running failed SSIS packages using check points and scripting with Active-X and VB.Net in SSIS.
Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
Involved in Performance tuning and Query Optimization.
Designed and implemented Parameterized and cascading parameterized reports using SSRS.
Used execution plan, SQL profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of the database.
Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
Created and managed the databases in development environment.
Environment: MS SQL Server 2012, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, MDX, ProClarity, ADO.Net, Query Analyzer, Data Mart, ETL, MS Office 2010
Idea Communications, Hyderabad May ’12 – Jul ‘15
Programmer Analyst
Responsibilities:
Created new tables, views, indexes, stored procedures and user defined functions.
Optimized query performance by creating indexes.
Created users and roles and assigned permissions to them.
Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
Involved in performance tuning of TSQL queries and Stored Procedures.
Used Profiler for studying the performance problems and tuned them accordingly.
Performed daily database backup & restoration of Database Server.
Developed complex stored procedures to create various reports by using SQL server reporting service 2000.
Environment: MS SQL Server 2005, Enterprise Manager, T-SQL, DTS, MS Visio, Windows, Query Analyzer, SQL Profiler, SQL Reporting Services 2005
Contact this candidate