PROFESSIONAL SUMMARY:

• Over 7 years of experience as a SQL Developer in the IT industry with Microsoft SQL Server 2014/2012/2008 R2/2008, SSIS/SSRS.
• Extensive experience with SQL Server in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational dbase models.
• Expertise in writing T - SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures and cursors.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing and debugging new and existing client-server based applications).
• Experience with Backup and Recovery of MS SQL 2014/2012/2008 Server Databases.
• Good Experience in using Microsoft BI studio for implementation of ETL methodology.
• Worked in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in performance tuning in SSIS packages by using row, block, and unblock transformations.
• Experienced in creating few types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in designing enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012 .
• Wrote parameterized queries for generating reports in SSRS 2012/2008.
• Experienced in creating complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Worked on KPI's, Partitions, Perspectives, and Calculated Measures.
• Responsible for designing and developing Data Warehouses and Data marts using Star and Snow Flake Schemas .
• Cooperative person and self-starter with phenomenal relational abilities, capacity to work autonomously or as a piece of group and equipped for grabbing new aptitudes rapidly.
• Good at using shared and global variables across crystal reports.
• Can generate Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Few responsibilities include getting requirements from the user, developing Crystal Reports maintaining proper documentation of the reports for future reference.

TECHNICAL SKILLS:

Operating Systems: Windows (All Versions), Unix, Linux.

Databases: MS SQL Server 2014/2012/2008 R2/2008, MS Access, Oracle 8i & 9i, MS Access 97/2000/2003/2007 , MYSQL.

RalphKimball Methodology, Bill: Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling.

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) Data Transformation Services (DTS), Visual Studio.

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Business Objects, Crystal Reports 9.0, Web Services, XML, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS).

Languages: C, C++, HTML, XML/XSLT/.Net/C#,Core Java, Python,VB.NET

PROFESSIONAL EXPERIENCE:

Confidential, TN

SQL Server Developer/Analyst

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Responsible for working with complex information systems and develops or modifies existing systems through analysis of business and user needs.
• Working in Teradata and Enterprise Data Warehouse environment.
• Populating datasets using different SQL queries and subqueries involving joins etc in Teradata environment on the customer’s data.
• Identifying the data sources and defining them to build the data structure and model.
• Exploring cost/benefit analysis, risk assessment and methodologies.
• Identified the data source and defining them to build the data source views.
• Looked at the reports and fixed bugs in stored procedures.
• Extracting data by researching and documenting in accordance with the life cycle of the project.
• Extensively worked on views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Monitored scheduled jobs and alerts.
• Responsible for gathering/refining requirements from the customer for developing reports.

Environment: MS SQL Server 2012/2014, SQL Server Integration Services (SSIS 2014), Windows 2010, MS Excel, SQL Server Profiler.

Confidential, WA

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code for experience.
• Involved in unit testing, user acceptance testing to check whether the data is loading into target, which was extracted from source systems.
• Experience in creating database objects like procedures, functions, triggers and indexes.
• Created functions to provide custom functionality as per the requirements.
• Designed and written the queries in the query builder for retrieving the data.
• Worked extensively with SSIS to import, export and transform the data from XML and text files.
• Created and managed event handlers, package configurations, logging, system and user-defined variables for SSIS packages.
• Worked with various SSIS control flow tasks and data transformation tasks like data conversion, derived column, look-up, and fuzzy look-up, conditional split etc. as part of ETL.
• Created checkpoints and configuration files in SSIS packages.
• Used merge command as alternative to small SSIS packages in dimension and fact load.
• Deployed SSIS packages with minimal changes using XML configuration file.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export data, bulk insert and BCP utilities.
• Used SQL profiler to optimize stored procedures.
• Created various SSRS reports involving variety of features like charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters.
• Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Created Crystal Reports for different teams and groups in the organization to fulfill their business needs.
• Designed and developed Crystal Reports, the Cross Tab Reports, and Top N Reports for displaying vital data and summary reports with drill-down capabilities.
• Developed various charts and graphs like bar chart side by side, stacked, line graphs, pie -charts etc. by using chart expert of Crystal Reports.

Environment: Microsoft SQL Server 2008 R2/ 2012, MS Access, ETL Packages (SSIS 2012), SQL Server Reporting Services (SSRS 2012), .Net, HTML, Visual Studio, T-SQL, XML.

Confidential, CO

SQL Developer

Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Created Database objects - tables , views , and functions .
• Rebuilt Indexes and Tables as part of performance tuning exercise.
• Implemented physical database design in SQL Server 2008R2 .
• Queried Triggers and Stored Procedures and T-SQL Queries to capture updated and deleted data from OLTP systems.
• Expertise in Using different Transformations like Lookups , Derived Column , Merge Join , Fuzzy Lookup , For Loop , For Each Loop , Conditional Split , Union all , Script component etc.
• Analyzed database population routines ( ETL ) and ensure quality of production load processes.
• Wrote T-SQL queries using inner join , outer join , and self joins , merge join . And also implemented functionality for removing duplicate records like using CTE and ranking function.
• Worked collaboratively with DBA to Improve Performance of the database by creating Stored Procedures , Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler .
• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server.
• Worked on Huge Data Transfers from and to SQL Server Databases using SSIS , and used Configuration Files and Environment Variables for production deployment.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.

Environment: MS SQL Server 2014/2008, SSIS, Query Analyzer, T-SQL, Windows Server 2008, SharePoint server, SQL Profiler, Teradata, SQL Profiler, MS Excel 2010, MS Word 2010,Power point 2010.

Confidential

SQL Developer

Responsibilities:

• Identified the data source and defined them to build the data source views.
• Responsible for transferring the data using SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Created complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using control flow tools and dataflow tools and then verify it.
• Developed, monitored and deployed SSIS packages.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Designed and applied entity and attributes description and definition for the models.
• Monitored scheduled jobs and alerts.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Generated reports using global variables, expressions and functions for the reports.
• Designed and implemented stylish report layouts.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: MS SQL Server 2008 Enterprise Edition, SSIS, T-SQL, VB, XML, MS Excel, MS Access, SQL Server Management Studio (SSMS), SQL Profiler