SUMMARY

• Having 9+ years of experience as SQL developer and experience in all phases of SDLC including requirement analysis, application design, and development of multitier applications, testing, implementation and maintenance.
• Expertise inSQLserver development, designing Stored Procedures/Transact - SQLcoding, Business Intelligence and experienced in designing, modeling, developing & Integrating with Microsoft SQL Server SSIS/SSRS.
• Experienced working with Microsoft cloud's bigdata Cosmos, ADL (Azure Data Lake) and ADS (Azure Data Storage).
• Experienced with leveragingHadoopeco-systems components such as Hive and Pig, for data analysis, sqoop for data migration, Oozie for scheduling and MongoDB and HBase as a NoSQL data store.
• Experienced in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools and demonstrated experience in writing complex T-SQL queries as per requirements.
• Experienced in Handling BLOB files from AZURE BLOB and load intoSQLdatabase using SSIS Azure File System Tasks.
• Incorporated complex business logic into functions and stored procedures for reusability and experienced in creating database objects such as tables, views, indexes, triggers etc. as needed.
• Very Good knowledge and experience of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
• Expertise in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Experienced in Extracting, Transforming and Loading data from various data sources like excel, flat file and Oracle to SQL Server databases using SSIS SQL Server Integration services.
• Experienced in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and user defined Variables for SSIS Packages and proficient in SSIS package designing/development/deployment/documentation.
• Skilled in Designing, Development and Deployment of Reports in Business Intelligence Development Studio (BIDS) and strong experience in assigning permissions to the valid users for executing the reports & deploying reports to report servers.
• Experienced in creating Power Pivot data models to provide the data to Power View dashboard and created and implemented cubes, transaction to reporting solutions with SQL Server Analysis services (SSAS).
• Extremely efficient in writing T-SQLscripts to develop complex Stored Procedures, Triggers, Tables, Views, User Functions andSQLjoins.
• Strong experience in SQL Server Database Administration, Management, Upgrading, Migrations and Development in Production\Nonproduction environment and clustered environments.
• Experience in planning and implementation of Microsoft SQL Server Security and Database permissions and experience with Database Backup, Recovery and Disaster Recovery Procedures and experience with Installation and Configuration of MS SQL Server … and in planning and implementation of MSSQL Server Security and Database permissions.
• Experienced in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server … in OLTP environments.
• Experienced in Microsoft.net technologies using C#, … ADO.NET, Language integrated Query (LINQ), WCF, WPF, Windows Forms, Windows Controls, XML, JavaScript, Web Services, Web controls, Web Forms, and Visual … .
• Extensive work experience with Database Backup, Recovery and Disaster Recovery Procedures and in configuring Database High Availability techniques like Database Mirroring, Log Shipping, Clustering and Recovery on SQL Server.
• Experienced in DBA activities such as backups, restores, replication of data and SQL Server OLAP database development including KPIs, Data mining, working with slowly changing dimensions (Fixed, Changing and Historical).

TECHNICAL SKILLS

Programming Languages: - SQL, PL/SQL, C, C++, Python, Java, VB, .NET Tools/Utilities - SQL*Loader, SQL*Plus, SQL Developer, Putty, Forms, Toad, Autosys, Erwin Data Modeler, Tableau.

SQL server tools: -Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint.

Office Tools: - Microsoft Word, Excel, Outlook, Access, PowerPoint Operating Systems - Windows 95/98/NT/XP/Vista, UNIX

Databases: - DB2, Oracle Database Enterprise Application Server, MS SQL Server 2016, 2014, 2012, 2008 R2, 2005, SQLCMDData Modeling - Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake schema, Fact tables, Dimensional tables), Entities, Attributes, E-R Diagrams.

Hadoop and Cloud Tools: Hive, Pig, HBase, MongoDB, Sqoop, Azure, AWS S3, and AWS Redshift.

PROFESSIONAL EXPERIENCE

Confidential, Mentor OH

Senior SQL developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for the applications
• Performed Data mapping for extraction and loading and responsible for Disaster Recovery, backups, database optimization.
• Designed, Developed & maintained databases on Microsoft's cloud computing platform ofSQL Azure.
• Used SSIS to transform data into SQL database via FTP from Text files, MS Excel as source and manage security, assign permissions, roles and designed scripts to automate the maintenance tasks and heavily involved in query optimization and troubleshoot long running queries.
• Implementing windows cluster across multiple availability zones and ImplementedSQL Server 2016 Always On high availability inAWS and involved in lunching EC2 InstanceSQLServer in Amazon web services (AWS) cloud across multiple availability zones.
• Wrote a script and placed it in client side so dat the data moved to HDFS will be stored in temporary file and tan it will start loading it in hive tables.
• Administer and troubleshoot SQL SERVER AGENT jobs and wrote complex stored procedures, triggers and functions.
• Use of SSIS 2016 Azure components to Upload or Download files and wrote complex SSIS packages as ETL to extract data from ERP to SQL server.
• Involved in data migration activities from Oracle Exadata toHadoopusing Python.
• Scheduling Jobs and Alerting using SQL Server Agent and used Performance Monitor and SQL Profiler to optimize queries
• Deploying SSIS packages inAWSCloud environment (EC2 Instance) and scheduling jobs usingSQLAgent
• Developing the Hive scripts in order to make the interaction between Pig and MySQL Database.
• Enhanced the performance of database servers and worked on deadlocks issues and minimized the occurrence of these situations and created different stored procedures for performance enhancement.
• Created ADL subscriptions within the ADF (Azure Data Factory) for storing the bigdata inside the cloud.
• Worked on MongoDB and other NoSQL systems, leveraging expertise onSQL, SSIS with the help of C# and Python.
• Involved in partitions of Hive tables and creating Hive tables to store the processed results in a tabular format.
• Worked on SPARKSQLand export data to MySQL to fast access and get the accurate results and HIVEintegration with SparkSQLfor adhoc queries.
• Heavily involved in creating datamarts and responsible for delivering datamarts to 50+ clients within SLA and administered and troubleshoot FTP jobs.
• Worked on SSRS to handle Ad-hoc requests and collaborated with WEB team, ERP team and Reporting team and help improve the business process.
• Design of SSIS packages to fetch data from on premise to AZURE BLOB and vice versa.
• Developing incremental load pipelines usingSQL, SSIS and ADF and usedAzureanalysis service to build measures and required calculations.

Environment: DB2, Java, SQL, Oracle 12c, SQL Server 2016, PL/SQL, T-SQL, Azure, Erwin, SSIS 2016, SSRS, SSAS, ERP, Teradata, Teradata SQL Assistance, Python, Hadoop, AWS, AWS Redshift, AWS S3, Hive, MongoDB, HBase, Kafka, Sqoop, Pig, HDFS, Spark, Scala, Synergy ware, UNIX Shell Scripting, I navigator, Data studio, Windows, Linux, C++, service now.

Confidential, Dallas TX

Sr. SQL Developer

Responsibilities:

• Contributed from design to implementation and maintenance phase of the application in AGILE environment/ methodology.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and created packages with override functions dat could be utilized by other systems dat interface with this application.
• Development activities involved developing & designing pages ( including UI), writing packages, uploading & downloading files inAWSbucket using PL/SQL, integrating Google Analytics, charts and downloadable excel ( using PL/SQL) & PDF.
• Analyzed data using complex SQL queries, across various databases and created materialized views dat refresh data from other databases, via DB Links.
• Developing the DWH/ Database/ Procedures inSQLServer 2016 and developing ADF pipelines to move data from On-PremiseSQLDB toAzureBlob Storage.
• Provided assistance and support to programming team members as required and asssisted quality assurance team with any functional and regression testing efforts.
• Developing theAzureDF pipelines using copy activity, hive activity and stored procedure activity.
• Implemented and designed propriety data solutions by data correlation using NoSQL andSQLwith the help of Kafka.
• Performed data analysis primarily identifying data sets, source data, source Metadata, data definitions and data formats.
• Responsible for migration of existing system to AzureSQL and replacing Informatica with Microsoft SSIS packages.
• Designed physical and logical data model and data flow diagrams using Erwin 9.5 Tool.
• Worked on various tables to create Indexes to improve query performance and involved in writing several queries and procedures and worked with several tools to access and perform several operations on database and used joins, indexes TEMPeffectively in where clauses for query optimization.
• Co-ordinate with multiple application development teams, since the application interfaces with multiple systems and created huge volumes of test data to test heavy data loads across multiple systems / databases.
• Worked inSQLdatabases like MYSQL, Oracle, DB2 & MSSQLserver and NOSQLDatabases like HBase and MongoDB.
• Developed ETL Packages to load data from various Sources toSQLServer andSQLAzure
• Involved in creating tables, partitioning, bucketing of table and creating UDF's inHive.
• Performed extensive GAP analysis in the project as their were numerous 'As-Is' and 'To-Be' conditions and involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Involved in creating tables, partitioning, bucketing of table and creating UDF's inHive.Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server and created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Parsed and compiled large amounts of data using Python andSQL.
• Developed Tableau visualizations and dashboards using Tableau Desktop and developed Tableau workbooks from multiple data sources using Data Blending.
• Azureautomation to automate whole process of processing the tabular model and scaling theAzure SQLdata warehouse.

Environment: Oracle 11g, TOAD, PL/SQL, UNIX, Shell Scripting, Tableau server versions, UNIX Linux, Windows, Java, Control-M, SSIS, SSAS, SQL, T-SQL, Hadoop, Hive, Pig, Azure, HDFS, MongoDB, Hbase, AWS S3, AWS EMR, AWS Redshift, Python, Spark, Scala, Teradata, SQL Server 2014, DB2 and Netezza.

Confidential, Harrisburg, PA

Sr. SQL Developer

Responsibilities:

• Analyzed data by creating simple SQL queries and identified fact and dimension tables and designed mapping using various transformations such as source qualifier, expression, joiner, sorter, union, etc.
• Performed data analysis primarily identifying data sets, source data, source Meta data, data definitions and data formats and designed Physical and Logical Data model and Data flow diagrams.
• Designed, constructed, and tested ETL processes and created SSIS packages to extract data from the transactional and/or operational databases, transformed the data according to analytical / reporting business needs, and loaded the data into a data warehouse or data mart.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder and involved in creating parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2012 and extract Transform Load (ETL) development Using SQL server 2012, SQL 2012 Integration Services (SSIS).
• Generated several drills down and drill through reports using SSRS and expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS and utilize templates to create Perl scripts dat are used to schedule the workflows as per business requirement.
• Use Control-M job scheduling tool to execute the workflow and create Unit test documents and process flow documents using Business Requirements and Design flows.
• Co-ordinate with data architects team, to import required source and target tables from specific database schemas and create test data, dat can be used in Unit testing most TEMPeffectively and perform load testing, with huge amounts of data to validate the performance of mapping.

Environment: MS SQL Server2012/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows 2012 Server, UNIX, Informatica 9.x, Web Services, Control-M, SQL, PL/SQL, T-SQL, Erwin, Teradata SQL Assistance, Metadata, Java, Perl script.

Confidential

SQL Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan and rewroteSQLqueries to upgradeSQLServer performance usingSQLServer 2008/2012.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible and defined Check constraints, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimizeSQLqueries for maximum efficiency usingSQLProfiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed physical data models using ERWIN/ VISIO and created DDL scripts for database schema and objects.
• Developed Query for generating drill down and drill through reports in SSRS 08/12 and uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports and designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
• Responsible for scheduling the subscription reports with the subscription report wizard and used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Written T-SQLStored Procedures and queries for accessing Data from Teradata Database
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS and created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Extensively involved in designing and maintaining the SSIS packages to export data of Excel spreadsheets and flat files sources toSQLServer Database
• Optimization of stored procedures inSQLServer to improvise the speed of the application to display the data
• Designed, Developed and Deployed reports in MSSQLServer environment using SSRS 2008
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS)
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes and created Linked Servers to connect OLE DB data sources and providers.
• Administered theSQLserver by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS and managed the migration ofSQLServer 2005 databases toSQLServer 2008.

Environment: MSSQLServer 2008/2012, DTS, Windows 8, SSMS, Business Intelligence Development Studio (BIDS) 2008/2012, Erwin, MS Visual Source Safe, MS-Visual Studio, Oracle 10g, UNIX, MDX Scripting.

Confidential

SQL Developer

Responsibilities:

• Going through the requirements and developing flat file reports for transaction, card, merchant activity and merchant money settlement reporting Using PL/SQL and Informatica.
• Global IT services and solutions company providing value propositions to the clients in the areas of Banking and Financial services (BFSI) to redefine and impact the core of their businesses.
• Loading Incremental Data to fact and dimension tables and built the PL/SQL (Procedures, Functions, Triggers, and Packages) and Informatica processes to summarize the data to populate summary tables which will be used for generating reports with performance improvement.
• Registration of new forms, creation of concurrent executable and concurrent programs for reports, opening up descriptive flex fields was done.
• Analyzed, developed, tuned, tested, debugged and documented processes using technologies SQL, PL/ SQL, Informatica, UNIX, and Control-M.
• Tuned the application with functional Indices, Temp tables, right partitioning, data in sequence storage and avoid nulls, converting views into snap shots/tables, daily analyzing tables, with clause, window functions and avoiding full table scans, hints and explain plan and monitoring database.

Environment: Oracle 10g, 11g, TOAD, SQL Developer, Forms&Reports6i, PL/SQL, UNIX, Informatica 8.x/9.x, UNIX Linux, Windows, SVN, Control-M.