Professional Summary:

• Over 8 years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Retailers, Insurance, Telecommunications and Pharmaceuticals.
• Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications using SQL Server 2000/2005/2008/2012, DTS, SSIS, SSRS and SSAS 2005/2008/2012.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions CTEs, Relational Database Models and Data Integrity, SQL joins and Query Writing
• Expertise in performing most of the SQL server enterprise manager and management studio functionality using T-SQL scripts and batches.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experience in using Change Data Capture for track DML Operation on Database level.
• Strong in creating table Partition for better performance for Database and creating Partition Function and Partition Scheme
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Experience in Logical and Physical Database design development, Normalization and Data modeling using Erwin data model.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services SSIS .
• Extensive experience in data extraction, transforming and loading ETL using SQL Server Integration Services SSIS , DTS, Bulk Insert and Bulk Copy Program BCP .
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created many complex SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split etc.
• Great Expertise in Creating and managing event handlers, Package Configurations, Logging, Checkpoints, Package Securities and User Defined Variables for SSIS Packages.
• Proficiency in Developing and Extending MS SQL Server Analysis Services 2005 SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services SSAS .
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services SSAS .
• Strong in optimizing MOLAP cubes by partitioning them, designing aggregations and implementing hierarchies. Created calculated measures and dimension members using Multi-Dimensional Expressions MDX .
• Proficient in calculating measures and dimension members using multi-dimensional expression MDX , and user defined functions.
• Experience in writing MDX queries in Analysis Services and Reporting Services
• Worked on administration tasks such Backup and Recovery, user and application table management, upgrades, user authorizations, Database creation, tables, and indexes
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Expertise in design and create multidimensional functions, multidimensional cube using SSAS.
• Good command in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008/2005 SSRS .
• Accomplished 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.
• Experts in designing and handling SQL Reports, Sub Reports and Drill down Reports. Crosstab report Proficient in designing report layout, sorting the data, defining subtotals for the reports using SSRS 2008/2005.
• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Deadlocks and Long running queries.
• Expertise in Microsoft Reporting Service SSRS with Report authoring, Report Management, Report formatting, Report distribution, Report delivery and Reportsecurity.
• Excellent understanding of full Software Development Life Cycle SDLC .
• Hands on experience in web designing using HTML, CSS and JavaScript to display reports on the server.
• Strong team player with great verbal, written communication and interpersonal skills.
• Proven ability to approach problems effectively, prioritize and complete multiple tasks.
• Excellent communication / analytical skills

Technical Skills:

Projects Summary:

Confidential

Role: MS SQL Server/SSIS/SSRS/BI Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Created Stored Procedures, Functions, Indexes, Tables, and Views and wrote T-SQL code and SQL joins for applications.
• Developed complex programs in SQL, writing Stored Procedures, Views, Triggers and Queries with best execution plan in SSMS
• Improved the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Created C Script for Control Flow and Check File existence using Script task in SSIS
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Created SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Created SQL jobs to scheduling the SSIS packages.
• Created SSIS packages to transfer CSV and excel files date into Database tables.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application.
• Create and maintain SSIS packages to load daily data generated from sales transactions and product delivery reports into the developer database.
• Wrote a script for different connection like share point link, shared drive and SFTP for sources within SSIS packages.
• Performance monitoring, tuning and troubleshooting various database malfunctions and SSIS package errors.
• Work in import and export of SSIS packages in MSBD of the integration services to roll into the production.
• Design SSIS packages with for each Loop for task automation.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Used Reporting Services SSRS to generate Reports in PDF, Excel, and CSV format.
• Used MS SQL Server reporting services SSRS to use daily report basis with client-server application.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Develop various reports using SSRS solutions such as dashboards, charts/graphs, drill-downs, drill through, sub reports and dynamic reports to meet information needs.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Environment: T-SQL, Query Analyzer, SQL Profiler, Windows XP, SQL Server2012/2008R2/2008, Windows 2003 advance server, SQL Server Integration services SSIS 2008, SQL Server Reporting Services SSRS 2008, SQL Server Management Studio SSMS , MS Access, Visual Studio 2008.

Confidential

SQL/SSIS/SSRS/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Responsible for maintenance of SQL server 2005/2008 including installation, configuration, security and service pack upgrades.
• Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.
• Obtained and analyzed the informational business requirements from various clients.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disk.
• Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized and cascading parameterized reports.
• Heavily involved in optimizing stored procedures by re-structuring the existing code and identifying the dependencies in nested procedures.
• Knowledge in designing and developing Data Warehouses, Data marts and Business
• Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes using MDX.
• Developed Drill down Tabular, Matrix and List Reports of the project given by Tech
• Lead/Manager using SSRS.
• Created reports using SSRS from SSAS and DB2 after analysis of data.
• Experienced working with SSAS data analysis
• Developed Ad-hoc report using report model, with ability to create multiple reports by non-technical managers by just using drag and drop functionality in report builder.
• Developed Sales report, financial report, Policy report and Premium reports for the company.
• Designed scheduled data synchronization approach, utilizing Microsoft DTS for Extract, Transform, and Load ETL steps.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica power center.
• Designed and developed business rules to generate consolidated fact/summary data identified by dimensions using Informatica ETL Power Center tool.
• Successfully worked in all the phases of report development Authoring, Designing and Rendering.
• Provided technical support to move databases from development to test and production for multiple applications.
• Good Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services SSAS .
• Created a SSIS package and also windows services to monitor FTP.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading ETL tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Developed SSIS packages to Extract, Transform and Load ETL data into the SQL Server database from the legacy mainframe data sources.
• Developed packages using SSIS from different data sources like SQL Server, Flat Files and Excel etc and performed different kinds of transformations.
• Wrote queries to produce reports using SQL Server 2008 and Reporting service SSRS .
• Worked with SQL server profiler to generate traces.
• Developed SSRS reports that are related to the packages based on the business needs using SQL Server Reporting Services2013 and deployed the reports to report server.
• Used Script tasks, execute SQL tasks, Sequence container, different source and destination connection managers etc while developing the packages.
• Developed SSRS reports that are related to the packages based on the business needs using SQL Server Reporting Services2013 and deployed the reports to report server.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS
• API development experience in C , C / .NET.
• Developed ASP.NET C application to interface with accounting system.
• Experienced in Web Applications in C , ASP.NET using latest technique like WPF, WCF.

Environment: T-SQL, Query Analyzer, SQL Profiler, Windows XP, SQL Server2012/2008R2/2008, Windows 2003 advance server, SQL Server Integration services SSIS , SQL Server Reporting Services SSRS , SQL Server Management Studio SSMS , MS Access, Visual Studio 2008.

Confidential

Role: MS SQL Server / BI Developer

Responsibilities:

• Analyzing the business requirements and building logical and physical data models.
• Creating high level design of the ETL process
• Creating three step ETL process to get the files from the server and load the data into database.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions and Hierarchies.
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Excellent report creation skills using Microsoft Reporting Services SSRS with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services SSRS .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Successfully Extracted transformed and load data into data warehouse

Environment: T-SQL, Query, Windows XP, SQL Server2008/2005, Windows 2003 advance server, SQL Server Integration services SSIS 2008/2005 ,SQL Server Management Studio SSMS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Data modeling , MS Access, VB Macros, Visual Studio 2008/2010, Waterfall development, Team foundation Server 2008/2010