SUMMARY

• Overall 6 years of experience in designing, development, implementation and administration of MS SQL server 2008, 2012, 2014, BI tools like SSIS and SSRS
• Around 4 years experience in business Intelligence tools like SSIS and and 2 year in SSRS.
• Experience in working with agile methodologies and fast - pace development project.
• Experience in design of SSIS packages for data transformation into various databases server.
• Experience importing and exporting data from non-sql data-sources such as Excel, XML, and delimited flat files.
• Experience in designing data modeling for Star Schema.
• Great expertise in processing data and flowcharting technique.
• Working knowledge with XML and JSON files.
• Hands on experience in added features in SQL-2008, 2012, 2014 ( CTE, MERGE, Pivot, Unpivot, OUTPUT COLUMN, Output Parameters, Sequence).
• Experience on Stored procedures, Functions, Views, dynamic query and Triggers.
• Experience on Query through multiple servers.
• Plan for the use of proper Index.
• Plan, design, and implement application database code objects
• Perform quality assurance and testing of SQL server environment.
• Monitor entire application development and execution.
• Optimization of query
• Building SSRS Report Tabular, Parametrized, Drill Down, Drill Through, Cascaded Parametrized
• Hands on experience in maintaining application database.
• Hands on experience in Data integrity.
• Managing Active-Active cluster.
• Good understanding of Setting up and Maintenance of replication which is used for PR and DR database.
• Hands on experience for data mirroring and Log shipping.
• Working knowledge of linked servers.
• Creating users and giving appropriate permissions.

TECHNICAL SKILLS

RDBMS: SQL Server, MySQL

BI Tools: SSDT(SSIS & SSRS), Pentaho

Big Data: Hive, MongoDB

Operating System: Windows XP/2003/2007, Windows Server 2003/2008, UNIX

Language: SQL, HTML, Java, C#

Productivity Tools: MS Word, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Austin, Tx

SQL Server Developer and ETL Developer

Responsibilities:

• Worked with Agile methodology.
• Participate in daily Scrum in Agile methodology.
• Hands on experience with Microsoft TFS for maintaining Source code and Technical Document.
• Managing Toll Database of Kentucky and Indiana State specially Ohio River Link Bridge.
• Closely work with Business Team to understand business logic.
• Developing Data Model
• Extensive use of stored procedures, writing new stored procedures and modifying existing ones.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Tune existing queries to reduce blocking and performance issues.
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat files or excel files.
• Data transferring to various team in form of XML, CSV.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards, design / implement common ETL strategies (CDC, SCD, etc.), and create reusable/maintainable jobs
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Doing Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations .
• Used Soap web service with SSIS to get information from various system.
• Responsible for performance tuning of SSIS packages to ensure scalability demands are satisfied and will be responsible for monitoring the production jobs, and other database activities.
• Developing various SSRS Reports such as Parameterized, drill down, drill through for business and customer services team.
• Perform SQL Server administration activities (backup, restore, Link server, DBCC commands, indexing, shrink)

Confidential, Cleveland-OH

Graduate assistant

Responsibilities:

• Office of Coordinator of Computing Services involved me with troubleshooting technical problems and fixing them.
• Managed user domains, resource sharing and permissions, group policies, virtual storage drive access.
• Provided phone support with remote user access in urgent situations as application or system failure.
• Setup of computer lab and related software for courses offered to students

Confidential

SQL Developer/SSIS/SSRS

Responsibilities:

• Involved in project handover activity.
• Gathering requirement from the business team in order to create different queries.
• Assisting with QA review process.
• Generated SQL Scripts for copying/migrating databases and database objects.
• Gathered data for validation and populate them into tables using stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Extensive use of Stored procedures, writing new stored procedures and modifying existing ones and tune them such that they perform well
• Involved in designing various reports to flat files generated via SSIS.
• Create Stored Procedures, Triggers, Views, joins and Functions for the Application
• Create, debug, and execute T-SQL scripts and stored procedures
• Extensively involved in error handling stored procedures
• Imported various Sources, Targets and Transformations using Transact-SQL Server.
• Actively involved Normalization & Denormalization of database
• Extensive Testing on the Performance of the Stored Procedures.
• Worked closely with Application Developers and Business Analysts to produce all required documentation for development.
• Identified, tested and resolved database performance issues to ensure database optimization.
• Created complex views, partition views for the application to increase the performance and reduce server load.
• Write complex T-SQL statements for retrieval of data.
• Testing the Performance of the database and fine-tuning is also done for complicated queries that take time to carry out, Analyzing and creation of appropriate indexes to optimize application performance
• Create joins and sub-queries for complex queries involving multiple tables.
• Created Reports by using Reporting tool SQL Server Reporting Services (SSRS).
• Managing Active-Active Cluster.
• Good understanding of Setting up and Maintenance of Different type of replication which is used for Primary and Secondary database server.
• Involve in various Database Server Migration.
• Working knowledge in Linked server.