SUMMARY

• Having around 6 years of SQL Server Development experience in SQL Server 2000/2005/2008/2012 with an emphasis on design, development, enhancement, automation, tuning and optimizing databases for high Availability, Performance and Security.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2008/2012/2014 ) Packages (Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T - SQL/PL-SQL
• Expert in designing various reports like table format, matrix, dashboards and creating subscriptions using SQL Server Reporting Services (SSRS 2008/2012/2014 ) and BI tools like Excel, Power Pivot/ Power Query and Power BI.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Worked on performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008, 2012.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs.
• Experience in Performance Tuning and Query Optimization.
• Experience with SQL Server Security and SQL Server Auditing.
• Created different types of encryptions and decryptions in SQL Server as per the client requirement to secure the data and also use it in flexible ways by a group of users.
• Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experience in Designing and Building the SSAS Cubes, Dimensions and data source views SSAS Data mining Models and Deploying and Processing SSAS objects.
• Experience in migrating DTS packages and reports from SQL server 2000 to SQL server 2005.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.
• Prepared documentation for the SQL Server 2005 Replication.
• Created backups and restore of database and schedule to run.
• Experience in database programming languages like T-SQL (SQL Server)
• Experience with Database Modeling tool MS VISIO.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions using SQL Server Integration Service (SSIS).
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Exchange 2003, Linux, Unix.

Databases: MS SQL Server 2012R 2/ 2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access 97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Data Modeling Tools: Erwin, Red gate, Light speed, foglite.

Languages: T-SQL, C, Java, PERL, java script, Visual Studio 2012/2005/2003, XML,HTML,Python, C#.Net

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. SQL Server Developer

Responsibilities:

• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Trouble Shooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs.
• Setup and maintained cross database data transfer using advanced technologies such and SQL SERVER replication.
• Built and deployed data-warehouse using SSIS, Setup and managed reporting services using SSRS.
• Introduced and implemented analytics using PowerBI.
• Experienced in installing and maintaining MS SQL Server 2008/2012/2014 .
• Deployed packages to SQL Server and file system in 2012 and also used the new Project based Deployment introduced in 2014 SQL Server Data Tools (SSDT) to deploy the 2014 packages.
• Configured and deployed the SSIS 2012 projects to the new Integration Services Catalog. Set the Environment and managed configurations using the Package and Project variables.
• Developed Query for generating drill down reports in SSRS 2008/2012/2014 . Prepared AD HOC reports through report builders.
• Involved in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Involved in building and maintaining dimensional cubes with SQL Server Analysis Services (SSAS) and used MDX script for querying the data.
• Worked on Data migration project by validating three source data row by row and field by filed
• Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
• Worked on development of SSIS package to generate excel reports individually and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users
• Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
• Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using SSIS.
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Worked on development and implementation of SSAS cube dimensions and their deployment and production support.
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
• Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
• Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
• Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

Confidential, VA

SQL Server Developer

Responsibilities:

• Responsible for Design, Development and testing of SSIS Packages to load data from various Databases and Files.
• Data migration (import & export - BCP) from Text to SQL Server.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
• Implemented data partitioning to improve the performance of large table reduces contention and increases availability of data.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Check Points, logging to send the result files to the clients and vendors.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup, check DB and weekly rebuild and scheduling jobs on daily/weekly basis.
• Monitoring Event Viewer, SQL Error logs for errors.
• Implemented batch processing using Jobs and DTS.
• Designed the user interface screens and implemented application logic under the Microsoft .NET framework using C# to use .NET features powered with CLR.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS and Created calculate member in OLAP cube using MDX in SSAS.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SSAS and DAX was used to create calculated measures and calculated fields.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Developed various dashboards using Power BI to facilitate informed decision making.
• Involved in Mock testing, Unit Testing and Integration testing in SSIS, SSAS.

Environment: MS SQL Server 2014/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Power BI, Power Query, SSMS, Team Foundation Server (TFS), SQL Server Data tools, Business Objects, SharePoint 2012.

Confidential, Austin, TX

SQL Server Developer

Responsibilities:

• Working as SQL Server Analyst / ETL Analyst using SQL Server 2008
• Source Controlling using IBM Rational Clear Case
• Developing and Management Database for Collateral Management and Hedging
• Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL, and Create and maintain physical structures.
• Working with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Create / Manage Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Design and Deploy SSIS Packages & Produce CSV, utilize CSV files as part of ETL Process
• Used .Net Scripts in SSIS & Produce XML Files for Tibco (Real Time Data Transfer)
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Code deployments / configurations/ config management in various environments
• Implement Security, Roles, Logins, and Permissions
• Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
• Maintain Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autosys, writing JIL Scripts
• Enhance existing applications to meet new business requirements
• L3 Production Support on Rotation basis & Deploy the code in various environments i.e. DEV/SIT/UAT
• Create and maintain DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, Pre-Prod)
• Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.
• Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).
• Involved in error handling of SSIS packages by evaluating error logs.
• Successfully extracted transformed and load data into data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports (SSRS) according to business requirement.
• Created reports by dragging data from cube and wrote MDX scripts.
• Used SSIS 2008 to create ETL packages ( dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases
• Improved the performance of long running views and stored procedures.
• Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.
• Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.
• Worked with Erwin data modeling tool
• Created Database objects including Tables, Views, Stored Procedures and UDF.
• Developed User defined functions, stored procedures, indexes, Triggers.
• Extensively involved in writing database scripts.

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

Confidential

SQL Developer

Responsibilities:

• Monitoring day-to-day operations, maintaining Table spaces and CRD files.
• Involved in full database export/import
• Involved in reviewing the Investments application and interacting with business users to understand the user requirements and involved in all phases of SDLC.
• Created and maintained database mapping document which mapped the old tables to the new ones.
• Developed stored procedures, user-defined functions, triggers, indexes and views.
• Involved in query optimization for faster processing of queries.
• Created allocation and other reports using SQL Server Reporting Services (SSRS).
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Loaded flat files into SQL Server tables and vice versa using SSIS.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, and Expression.
• Created XML configuration files to dynamically alter package properties.
• Developed error handling routines for packages using both script tasks as well as in the error handling tab.
• Developed Unit Test Plans for SSIS packages.
• Responsible for allocating responsibilities and coordinating ETL efforts among team members to ensure best practices are used.
• Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
• Documented ETL processes and prepared project status report updates/audit reports/ list of issue items that need to be reviewed.

Environment: Visual Studio 2005, MS SQL Server 2005/2008/2008 R2 SQL Server 2005/2008, SSRS 2005, SSIS 2005, BIDS, MS Visio.

Confidential

SQL Developer

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed SSIS packages using various transformations such as Conditional Split, Aggregations, and Multicasting.
• Generated SSRS Enterprise reports from SQL Server Database (OLTP) and SQL Server and included various reporting features such as drilldowns, drill through, sub-reports, navigation reports.
• Created different Parameterized Reports (SSRS 2008R2/2005) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked on N-Hibernate concept in ASP.NET
• Designed Database Model using MS VISIO.
• Worked on Reporting Services (SSRS) and SSIS Infrastructure that pulls data from data sources and provides a simple to use reporting environment.
• Performed data migration from SQL server 2005 to SQL Server 2008.
• Created SSRS reports for the provider and vendor and making sure the payments were processed correctly
• Scheduled multiple jobs for SSIS packages and which performed integration from different flat files/excel files into the database.
• Created SSIS packages to validate, extract, transform and load data into the database and make necessary actions by keeping the stored procedures in the execute SQL tasks.
• Executed data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).

Environment: SQL Server 2008, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#. NET, ASP.NET.