Description
PROFESSIONAL SUMMARY General: * Almost 3 years of IT Professional experience with strong background in SQL server Development, SQL Server Integration Services and SQL Server Reporting Services using Microsoft SQL Server 2012/2008R2/2005 and Visual Studio 2012/2010. * Experience in the IT industry as a MS SQL Server Developer/BI Developer in domains like Banking, and Tool manufacturing. * Experience in excellent communication and Presentation skills, maintaining working relationship at all Business levels and working with Production in a (24/7) environment with excellent Work Ethics. * Excellent Analytical and Interpersonal skills with exceptional ability to learn new concepts and ideas, Fast Learner, adapts well to changes on workplace in Team Oriented or Individual project environment with Positive Attitude. * Experience in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities * Ability to work in very fast paced environment with multiple projects at the same time. * Expertise in using SVN and Tortoise SVN for version control for various SQL scripts like stored procedures, views, functions, etc. * Experience in working with Business Stake Holders, Clients, Business Analyst, Database Analyst, Application Developer and Production Team to gather the requirements/issues and discuss the possible solutions and translate it into the conceptual design and physical data models and codes. * Experience in utilizing Microsoft Dynamics to upload and extract data through SQL Server. * Expertise in LOGI Reporting services utilizing Microsoft SQL Server. SQL Server Developer: * Highly experienced in using Microsoft SQL Server 2012/2008R2/2005 in Development, Testing and Production environment. * Experience in Online Transaction Processing - OLPT and Online Analytical Processing - OLAP Databases and Data Warehousing from OLTP database to OLAP database. * Highly proficient in using T-SQL for developing and implementing complex Stored Procedures, constructing Triggers, Tables, Views, User Defined Functions and Query writing to facilitate efficient data manipulation and data consistency. * Experience in Data Warehouse architecture through its various stages of Data Source Layer (Dynamics), ETL, Data Warehouse Staging, Data Warehouse (Summary Data) and Reporting. * Highly proficient in using complex operators in SQLs like Union and Union All, System provided functions, Inner and outer joins. * Expertise in performance tuning of long running queries using Temp table, CTE and Table variables. * Experience in Creating and Managing Clustered and Non-Clustered Indexes to improve database performance and availability in tables and views. * Experienced in using Aggregate Function, Date function and Cast and Convert functions. * Experience in Backup/Restore of database using Full or Differential backup type. SQL Server Reporting Services: * Expertise in using SSRS (Reporting Services) with MS SQL Server 2012/2008R2/2005 and Visual Studio 2012/2010 in Development, QA and Production environments. * Highly proficient in using various tools in SSRS like Table, Matrix, Chart, etc. to create various useful reports to assist in business decisions. * Highly experience in using cascading parameters for report performance optimization. * Experience in Managing Standard Subscription and Data Driven Subscription through Reporting Services. * Excellent skill sets to color code various fields in SSRS directly through SSRS or through the various conditions set in MS SQL Server. * Experience in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports, Sorting, Defining Data Source, Datasets and Subtotals for reports using LOGI and Visual Studio 2012/2010 and its Reporting Services. * Experience in using MS SQL Reporting Services (SSRS) for generating Matrix, Drill down, Drill through, Summary Reports, Parameterized and Linked reports. SQL Server Integration Services: * Expertise in using SSIS (Integration Services) with MS SQL Server 2012/2008R2 and Visual Studio 2012/2010 in Development, QA and Production environments. * Experience in creating SSIS packages as per business needs utilizing various Business logics and Business Intelligence platform. * Creating SSIS package consisting of File transfer through SFTP using third party source like MOVEit Transfer. * Experience in Creating and Maintaining SSIS Packages with wide use of Error Handling and debugging for Data Storing in SQL Server Database. * Extensive experience in creating and managing the SSIS/DTS packages for Extracting, Transforming and Loading (ETL) data from SQL Server, Excel Sheet, CSV Files and flat files using control and data flow elements. * Extensive experience on SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task and Send Mail Task. * Experience in creating Jobs, Alerts and scheduling SSIS Packages using SQL Server Agent. * Experience in Deploying, Configuring, Error Handling and Trouble Shooting the SSIS Package.
Accomplishments
Highlights:
Keywords
