Sql Server Data
Resume:
*************@*****.***
Profile Summary:
Around 8+ years of hard-core experience as a SQL Developer in IT Projects involving Business Intelligence (BI), Data Warehousing and Data Conversion from Legacy to Enterprise systems using standard SDLC methodologies.
Experienced in all phases of the SDLC for Decision Support Systems including Requirements gathering, Analysis, Design, Development and Testing using MS SQL Server 2012,2008,2005 suite of products (SSRS, SSAS, SSIS, DTS)
Expertise in the usage of ETL tools including SSIS, DTS for large-scale Data warehouse implementation Projects involving conversion of data from heterogeneous data sources including SQL Server 2000/2005, DB2 and Oracle.
Expertise in the Best Practices related to the development, implementation, administration and support of ETL processes using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS packages with MS SQL Server 2000/2005.
Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
Experience in designing MDX expressions/queries for accessing SSAS cubes.
Good knowledge on Informatica.
Excellent T-SQL programming skills and experience in the development of SSIS packages using BIDS, complex Stored Procedures, Configuration Files, Tables, Views, Triggers and Functions.
Expert in Performance Tuning, handling Indexes and Query Optimization.
Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
Experience in using SQL Server Reporting Services (SSRS) for the development of role based Dashboards and Ad hoc Reports to monitor Key Performance Indicators (KPIs) and support operational and strategic reporting requirements.
Proficient in the ergonomic design of Dashboard and Report layouts for canned reports as well as Adhocs with advanced drill-down, sorting and filter capabilities.
Experience in conducting UAT sessions for obtaining sign-offs on Reports and User Training as part of the Deployment Plan for Data warehouses.
Strong problem solving and analytical skills with ability to work independently as well as in a team.
Good Experience on Agile methodologies like SCRUM using TargetProcess, Team foundation Server.
Good Basic Knowledge of Microsoft .Net Technology.
Technical Skills:
BI Tools
SSIS, SSRS, SSAS, Informatica
RDBMS Servers
MS SQL Server 2012/2008R2/2005
Operating Systems
Windows 7, Linux
Programming Languages
PL/SQL, T-SQL, .Net, C# and Java
Office Applications
MS Outlook, Visio, MS Project, MS-Excel, Power Pivot 2010, MS-Access
Configuration Tools
SQL Monitor from Redgate, SQL Profiler
Professional Experience:
Client : TMX Finance, Alpharetta, GA
Role : SQL BI Developer
Duration : June 2013 to Present
Responsibilities:
Worked with Client/Business Analysts to define data requirements for reporting warehouse.
Designing and developing SQL Server 2012 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
Written complex SQL statements using joins, sub queries and correlated sub queries.
Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and un-pivot Control Flow Transformations.
Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript.
Migrate the data from an Access database to SQL Server 2012.
Designed the packages in order to extract data from SQL DB, flat files and loaded into Oracle database.
Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
Design, deploy and maintain various SSRS Reports in SQL Server 2012.
Designed and implemented Parameterized and cascading parameterized reports using SSRS.
Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
Used ProClarity for accessing and analyzing cubes and dimensions and also worked on integration of SharePoint with SSRS.
Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio, SSIS, SSRS, SSAS, MS Excel, Teradata.
Client : McKesson, Alpharetta, GA.
Role : ETL and SSAS Developer
Duration : Feb 2012 to Jun 2013
Responsibilities:
Analyzed each Vendor system Interface and solicited business requirements from vendors.
Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with the High Point system.
Developed and scheduled DTS packages for each system Interface using SQL code in combination with VB ActiveX scripts and built-in DTS transformations.
Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor, Execution Plan and Index tuning wizard.
Created SQL Server Database objects including Tables, Views and Indexes.
Implemented Version Control with Visual Source Safe.
Resolved any deadlocks issues with the Database servers on a real-time basis.
Defined Testing strategies and designed Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.
Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
Identified and defined Key Performance indicators (KPIs) for vendor reporting.
Designed, developed and modified various interface reports using Crystal Reports 10 and Hyperion.
Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
Coordinated the activities of subordinates in the Interface Team and organized weekly status Meetings.
Designed Test cases and developed Test scripts for testing the reports using Test Partner.
Created SQL Scripts for data loads and Upgrades for data migrations and data validations.
Environment : MS SQL Server 2008R2, T-SQL, SQL Profiler, Visual Studio (2012), Team Foundation Server (2012)
Client : Tradewind Net Access, Inc. Mt.Laurel, NJ
Role : SQL Server Developer & App Support
Duration : Jan 2011 to Jan 2012
Responsibilities:
Created complex SSIS packages using proper control and data flow elements with error handling.
Responsible for keeping system and databases up-to-date with service packs and hotfixes.
Created various Jobs, scheduling & running jobs and troubleshooting the failed jobs.
Tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
Created Indexes on tables for better performance.
Created SQL Scripts for data loads and Upgrades for data migrations and data validations.
Developed Tabular and Chart Reports in SSRS.
Experience in building and maintaining Data Marts for SSRS.
Created roles for using the cubes.
Designed cubes with star schema using SQL Server Analysis Services (SSAS).
Developed cubes with various Perspectives and deployed those cubes in development, integration, validation and production servers of SSAS.
Provided 24 x 7 on call support for all the SQL application on production server.
Environment :Windows server 2003, MS SQL Server 2008/2005, SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services, MS Office 2003/2007.
Client : KPIT Cummins Infosystems Ltd, Pune, India
Role : ETL &Report Developer
Duration : Jan 2009 to Sep 2010
Responsibilities:
Gathered business requirements through interviews and JAD sessions and performed an inventory analysis followed by a first level functional decomposition of all existing legacy systems.
Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
Developed Technical Design specifications and Source to Target Mapping (STTM) specifications for each legacy system interface with Enterprise system.
Designed and developed physical and logical Data Models using ERwin and developed SQL Server Database objects including Tables, Views and Indexes.
Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into the Enterprise system SQL Server database.
Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on the fly.
Implemented Version Control with Visual Source Safe.
Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
Analyzed and designed disaster recovery and replication strategies based on business requirements.
Deploying the SSRS reports using MS reports builder.
Responsible to create the Pivot table, work books, graphs and reports using Excel reports.
Responsible to give access to those dash boards to end users.
Responsible for configuring and maintaining report manager and report server for SSRS.
Expertise in writing the complex SQL queries.
Responsible for building the reports using Reports builder.
Environment : MS SQL Server 2008/2005, SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services, MS Office 2003/2007.
Client : ERP Analyst, Hyderabad, India
Role : SQL Server Developer
Duration : Aug 2007 to Dec 2008
Responsibilities:
Installation, Configuration and Maintenance of MS SQL Server 2005.
Extensively involved in architecture of Customer Database.
Created & managed the Database Users, Login Ids and Security.
Created the Backup and Recovery policy for the databases.
Performed data transfer/migration using Export/Import and Data Transformation Services.
Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
Created and running DTS Packages for Import and Export of Heterogeneous Data.
Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
Validated backup Integrity as part of disaster recovery plan.
Created database administrative job of Security, Backup/recovery, ODBC connections etc.,
Provided support to the Application developers on the application databases.
Responsible for creating stored procedures and SSIS packages as part of the ETL process to populate the data marts.
Created the SSIS packages to import partner flat files into the OLTP.
Created complex Stored Procedures, Triggers and User Defined Functions.
Environment : SQL Server 2005, Oracle 9i, Windows 2000/2003/ NT/ XP, MS Access
Education:Bachelor of Computer Science from JNTU University
Contact this candidate