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.

PROFESSIONAL EXPERIENCE

SQL/Big Data Developer

Confidential, Austin, TX

Responsibilities:

• Migrated data from one data mart to another for resolving data quality issues and also for building reports.
• 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 long running queries.
• Integrated data into data warehouse from different sources such as SQL Server, MySQL, etc.
• 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.
• Implemented optimized SQL queries, SPs & methods to reduce the completion time of SSIS packages used for loading Customer Experience DataMart that helped to load entire data within time to abide the service contract.
• Used Google’s querying language Big Query to load the Google Baklava data into Apache Hive and SQL Server.
• 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.
• Designed and developed Packages for loading data from text files, CSV files to SQL Server databases using SSIS. Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Deployed different SSIS packages on test and production servers.
• Migrated data from SQL server to on-premises Hadoop and AWS cloud using Spark applications.
• Used Looker visualization tool to build measures and dimension for Google Analytics data.
• Used Qubole interface to read and transform data from AWS S3 location and write to on-premises Hive location.
• Replicated data from SQL Server to S3 using spark application coded in python.
• Built a spark application using Scala which reads data from S3 bucket and creates a hive table and writes data to the table (and also converts data from avro to parquet and vice-versa).
• Built a spark application to transform SQL procedures into RDD’s using Spark SQL and write to hive.
• Designed and developed Star Schema dimension and fact tables to support data warehouse requirements for the Customer Experience and Marketing Click Stream DW
• Published updates to existing database from Database Project to database server, using Microsoft Visual Studio
• 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, Big Query, Apache Hive, Spark, Spark SQL, Looker, Scala, JIRA, Tableau, Qubole, GitHub, SVN Tortoise

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 Big Query 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 Big Query, 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.
• 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, Big Query, Apache Hive, Jira, GitHub, SVN Tortoise, Eloqua, Datameer, Tableau.

SQL Server/BI Developer

Confidential, Durham, NC

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 - Intern

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. Also, 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.