SUMMARY

• Over 6 Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2014/2012/2008 R2/2005 in Production, QA and Development Environments.
• Experience in installing, configuring, managing, upgrading, migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2014/2012/2008 R2/2005.
• Experience in Managing Security of SQL Server 2014/2008/2005/2000 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005/2008/2012 Reporting Services (SSRS), SQL Server 20052008/2012 Integration Services (SSIS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits, Event Handlers and Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) ( 2005/2008/2012 ).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Expertise in Reporting tool Tableau and Analytical tool Datameer.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports. Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in configuring and maintaining Report Manager and Report Server for SSRS. Also Deployed and Scheduled the Reports in Report Manager.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Worked with Business Analysts, Web development team and users on database solutions.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, Windows 2000 Enterprise/Advanced Server, Windows 2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX.

Databases: MS SQL Server 2014/2012/2008 R2/2005/2000, MS Access, My SQL

Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, XML, C#, VB.NET, MDX Word, Excel, PowerPoint, Access, Visio, Outlook.

Business Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL

Database Tools: Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2005/2008 R2, Tableau and Datameer

ETL Tools: DTS, SSIS

Data Modeling: Erwin v 4.0, Visio 5.0

MS Tools: Management Studio, Visual Studio.

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP,TCP/IP

PROFESSIONAL EXPERIENCE

Data Warehouse Developer

Confidential, Austin, TX

Responsibilities:

• Used MySQL Workbench tool in Extraction and implemented Transformation and Loading process by pulling large volume of data from various data sources using SSIS.
• Created Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Optimized the T-SQL query performance by creating Clustered and Non Clustered Indexes on tables and also by Identifying the performance bottlenecks and tuning the problematic queries.
• Integrated data into data warehouse from different sources such as SQL Server, Google Analytics (Avro Schema), MySQL, etc. into Hadoop & EDW.
• Created several Hive queries to perform aggregations on the existing data in Hive and also used DBVisualizer to query the hive tables.
• Used Google’s querying language BigQuery to load the Google Baklava data into Apache Hive and SQL Server.
• Created several Export and Import Jobs on a Framework, which is used to transfer data between BigQuery, Hadoop, Hive and SQL Server
• Implemented partitioning on several fact tables in data warehouse using Clustered Column Store indexes
• Worked on Job Asynchronous ETL Framework where multiple processes are executed Asynchronously
• Published updates to existing database from Database Project to database server, using Microsoft Visual Studio
• Designed and developed Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Deployed different SSIS packages on test and production servers for the SSAScubes.
• Created Linked Servers to retrieve data from other databases.
• Involved in code review and preparing unit test cases.
• Created Data Links, Workbooks and Connections to load data into Datameer for analysis, integration, preparation and operationalization.
• Used Marketing Automation tool Eloqua for Email Marketing Campaigns.
• Loaded data into Eloqua for Marketers to be able to visualize and report attribution.
• Worked on Tableau to build reports as per business requirements.
• Experience in version control tools like GitHub, SVN and JIRA.
• Worked in Agile environment and with business for gathering requirements.

Environment: SQL Server 2014 Enterprise Edition, T-SQL, SSIS, MY SQL Workbench, DB Visualizer, BigQuery, Apache Hive, Jira, GitHub, SVN Tortoise, Eloqua, Datameer, Tableau.

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Confidential || MD

Responsibilities:

• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Extensively worked on OLAP cubes using SSAS.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent Integration Services (SSIS 2012/2008), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, ETL, Performance Point Server 2007, MS Excel.

SQL Server/BI Developer (SSIS, SSRS, SSAS)

Confidential || Columbus, OH

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint/Moss2007 integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develops and unit test SSIS load processes for performance check.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created various complex reports and managed them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008,SQL BI Suite (SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003.

SQL Server Developer

Confidential

Responsibilities:

• Involved in various stages like development, system Analysis &design, and creating stored Procedures.
• Designed and developed Interfaces which were used for connecting to SQL Server database.
• Validated and coded the application using VB.
• Debugged and fixed the bugs.
• Designed the Logical and Physical databases of SQL Server.
• Performed database testing & maintaining the data by using the procedures.
• Designed and validated the forms according to client requirement by using VB.
• Imported and Exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in T-SQL.
• Maintained SQL Script for creation of Database Objects.

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, VBScript.