SUMMARY:

• 10+ years of professional experience as a SQL Developer in Health Care Industry. 7 years of experience in Agile with the entire project life cycle of Business, Design, Development, Testing, Implementation and Enhancement of Applications in Healthcare Industry
• Quick learner, highly adaptive and possess very good inter personal skills and work ethics. Experienced in designing, modeling, developing &Integrating with Microsoft SQL Server SSIS/SSRS.
• Created stored procedures for generating reports using SQL Server Reporting Services.
• Experience in working with multiple cross functional teams under strict deadlines. Efficient in creating joins and sub - queries for complex queries involving multiple tables.
• Demonstrated experience in writing complex T-SQL queries as per requirements.
• Experienced in optimizing SQL code by understanding execution plans, using SQL Profiler, DMVs, Index tuning wizard and other tools.
• Incorporated complex business logic into functions and stored procedures for reusability. Experienced in creating database objects such as tables, views, indexes, triggers etc. as needed.
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions.
• Knowledge 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.
• Experience 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.
• Proficient in SSIS package designing/development/deployment/documentation.
• Skilled in Designing, Development and Deployment of Reports in Business Intelligence Development Studio (BIDS).
• Strong experience in assigning permissions to the valid users for executing the reports & deploying reports to report servers.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica PowerCenter 9.6.1/9.1/8.6, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server).

Databases: Oracle 11g/10g/9i/8.0, Greenplum PostgreSQL),,, MySQL, SQL Server 2005/ 2000/2008

Programming: SQL, PL/SQL, Unix, Shell Scripting

Tools: TOAD, SQL Developer, Hive, Hbase, Pig, Sqoop, Map Reduce, pgAdmin, agility,autosys

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

PROFESSIONAL EXPERIENCE:

Sr. SQL Developer

Confidential - Brentwood, TN

Responsibilities:

• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Monitored and managed DB2 thread and locking issues.
• User/group maintenance in both production/development environments. In-house process control initiatives including IT Services Management, worked with LDAP integration for a single log on purpose.
• Proactively monitored and performed daily maintenance activities.
• Created database data mart mappings. Data Mart and database design for OLAP cubes.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL joins for applications.
• Extensively used T- SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Used Chef Recipes to create a Deployment directly into Amazon EC2 instances.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Extensively used SSIS to move data from text files to SQL Server.
• Views using T- SQL in Development and Production environment for SQL Server 2008.
• Experience installing GreenPlum (GP) database on 1/4, 1/2, Full RACK servers on RHEL.
• Vendor Coordination (EMC) and Raising SR.
• Integrating Oracle/SQL Server data using Talend, Attunity and HVR replication tool to GreenPlum DB.
• Responsible for Security Planning and disaster recovery for the server and the Data Warehouse.
• Created ETL process from the OLTP database to the Data Warehouse and loading Data Marts to support several reports.
• Created Organizations, Business units, Teams and their relationships.
• Worked in WAMP (Windows, Apache, MYSQL, and Python /PHP) and LAMP (Linux, Apache, MySQL, and Python /PHP) Architecture.
• SQL Workflow System, using Python created an adapter allowing communication between SharePoint lists and SSIS packages. This system provides users the ability to create complex automation workflows.
• Created windows virtual machines and supported windows workloads using with ARM portal and Powershell.
• Developed frontend and backend modules using Python on Django including Tasty pie Web Framework using Git
• Used different tools from IDERA suite like SQL Diagnostic manager for monitoring 24/7 Performance measures, SQL Defrag Manager to effectively manage the hot fixes, SQL Virtual Database to access data in SQL backup files without restoring.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs. Created on 2014 SSRS.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Configuring/Installing/Troubleshooting Apache and PHP.
• Worked on converting Hive/SQL queries into Spark transformations using Spark RDDs, Python, and OOP with Python.
• Design and implement disaster recovery for the PostGreSql Database.
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Created basic reports using CSV files as source to fetch the data in Power BI.
• Experience in creating master and child packages, using package configurations (SQLServer) and SSIS logging.
• Patch, Upgrade and keep the PostGreSql DBs current. Develop and enhance scripts to automate and execute various DBA tasks.
• Utilized SQL Server Integration Services (SSIS) as an ETL Tool and created packages for the extraction of data from disparate sources (SQL Server, Flat Files, Excel Source files, XML Files etc.) and loaded the data into target tables by performing data validation and cleansing using various transformations.
• PostGreSql Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostGreSql 8.2 to 9.5.
• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Understanding and analyzing the Oracle pl/sql code logic and implementing the same in GreenPlum PostGreSql.
• Created and implemented ARM templates from a deployment, deployed the template using the portal, Powershell, and using Azure quick start templates.
• Optimized T- SQL scripts used to feed reports and implemented ETL logic for faster loading and processing.
• Developed, documented, maintained and approved SQL Server Stored Procedures, SSIS Packages, Powershell Scripts.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF's Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors.
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Identifying, and documenting ETL Standards and best practices for the development team.
• Participated in creating data conversion and migration strategy, conversion design and conversion development documents. Participated in Data Modeling Sessions.
• Configured the scale up and scale down VM sizes, created virtual machine scale sets, configured the modify the VM scale set capacity with Powershell script.
• Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Implemented framework for Reference/Lookup data changes, Automation of Applying Database Change Request scripts to the target DB.
• Worked with Managers to prepare WBS for SSIS/Database development work.
• Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.
• Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created and configure SSIS logging to capture log-enabled events that occur at run time.
• Developed staging tables to house the data and developed exception/error handlers to prevent issues with data being written to the new DB within SQL SERVER SSIS.

Environment: SQL Server 2012/2008R2/2005 Enterprise, Windows Enterprise Server 2012/2008R2, T- SQL, SSIS, SSAS, SSRS, NetBackup and Spotlight

SQL Developer

Confidential - Conway, SC

Responsibilities:

• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Highly experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server.
• Worked on Element Tree XML API in Python to parse XML documents and load the data in database.
• Utilized Python libraries wxPython, NumPy, Pandas, Twisted and matplotlib.
• Installed, configured, and managed the AWS server.
• Worked on Python -based test frameworks and test-driven development with automation tools.
• Developed entire frontend and backend modules using Python on Django Web Framework with GIT
• Creating ETL packages in SQL Integration services (SSIS) for various data loads and extracts from different types of sources like SQL Server, Text, CSV flat files, like SQL server, Text, CSV flat files.
• Deployment of SSIS packages to the conversion server and create and schedule SQLServer Agent jobs to automate the run of SSIS packages on a weekly basis.
• Implemented high availability using Portal, Powershell on Azure Resource Manager deployment models.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostGreSql databases within the organization.
• Responsible for all backup, recovery, and upgrading of all of the PostGreSql databases.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Created data extracts as part of data analysis and exchanged with internal staff.
• Managing SQL server using PowerShell scripts.
• Managing SQL server using PowerShell scripts.
• Managing Monitoring GreenPlum DCA using Command Center.
• Configuring ESRS & Dial home with GreenPlum DCA.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Monitored and managed DB2 thread and locking issues.
• Setup, Configure and Administer 18 (Netapp) Network Appliance 30xx Systems running on Ontap 7.2+ in Richmond, VA while mentoring a group supporting 8 Netapp Appliances in Plano TX. Combined Storage is over 150tb worth of data, SAN and NAS.
• Developed Tabular and Chart Reports in SSRS.
• Worked on advanced dimension Design and Cube design.
• Transformed new Gen Tax users from novices to experts by instilling confidence in performing every day.
• Designed cubes in star schema using SQL Server Analysis Services (SSAS).
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Developed cubes with various Perspectives and deployed those cubes in development, integration, validation and production servers of SSAS.
• Refactoring of data warehouse schema to remove unused or obsolete database objects and improve design.
• Responsible for keeping system and databases up-to-date by making necessary changes.
• Optimized Stored Procedures and long running queries using query-optimization techniques.
• Tuning SQL Queries by Coordinating with team members.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process Cube Partitions and Dimensions.

Environment: SQL Server 2008/2005, T-SQL, Microsoft Framework 2.0, Erwin, MS Visio.

SQL/ MSBI Developer

Confidential - Englewood, CO

Responsibilities:

• Performed in configuring DR sites using Database Mirroring technology on SQL server 2008R2/2008/2005 with a witness server or without witness server to configure automatic failover.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008/2008R2 databases.
• Successfully designed and implemented the disaster recovery with High availability solutions like Failover Clustering, Mirroring, Log Shipping and Replication.
• Used different tools from IDERA suite like SQL Diagnostic manager for monitoring 24/7 Performance measures, SQL Defrag Manager to effectively manage the hot fixes, SQL Virtual Database to access data in SQL backup files without restoring.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Configuring/Installing/Troubleshooting Apache and PHP.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• Used Python to write data into JSON files for testing Django Websites. Created scripts for data modelling and data import and export.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging and Configuration Files.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Experienced in Installing, configuring and maintaining multi node (2-node, 4-node) clusters running SQL Server 2008R2/2008 in Active/Active, Active/Passive and Active/Passive mode.
• Worked on installation, configuration and deployment of SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Worked with different methods of logging in SSIS.
• Cleaned data and processed third party spending data into maneuverable deliverables within specific formats with Excel macros and Python libraries.
• Used Python libraries and SQL queries/subqueries to create several datasets which produced statistic statistics, tables, figures, charts and graphs.
• Experience in logical & physical Data modeling, data architecture design, Normalization and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema) using DM tools like ERWIN, Visio, SQL Diagrams.
• Worked on installation, configuration and deployment of SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Performed in configuring DR sites using Database Mirroring technology on SQL server 2008R2/2008/2005 with a witness server or without witness server to configure automatic failover.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008/2008R2 databases.
• Highly experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server.
• Experience in logical & physical Data modeling, data architecture design, Normalization and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema) using DM tools like ERWIN, Visio, SQL Diagrams.
• Managed the troubleshooting, planning and migration activities in line with the company's requirements. Performed Database Integrity Checks.
• Updated Database Statistics and performed Re-indexing through Maintenance Plan.
• Managed the troubleshooting, planningrequirement and migration activities in line with the company's s. Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Plan.
• NAS administration consists of data migration (Snapmirror and NDMPCopy), creating and maintaining CIFS, Quotas and DFS structure.
• Setup and Support the SAN and Backup environment that connects to (8) Brocade 4900 Switches. Exchange 2003, VM 4.0 and NBU 6.0 - Data Domain environments run on SAN. Netapp SAN

Environment: SQL Server 2012/2008R2/2005 Enterprise, Windows Enterprise Server 2012/2008R2, T- SQL, SSIS, SSAS, SSRS, NetBackup and Spotlight.