Resume

Sign in

Sql Server Data

Location:
Irving, Texas, United States
Posted:
February 05, 2018

Contact this candidate

SATISH

ac4cl4@r.postjobfree.com, Mobile: 972-***-****

SUMMARY:

Over 7+ years of Experience in Software Development Life cycle (SDLC), Agile Methodology with Extensive experience in Microsoft Database Technologies that includes Database Design and Development of SQL Server 2014/2012/2008/2005 in domains like Life Insurance, Finance, Technology.

Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles, SQL joins, CTEs, Cursors, DDL, DML Scripts, data modeling.

Experienced in strategically implementing indexes such as Clustered index, Non-clustered index, implement index appropriately to achieve faster data retrieval.

Proven ability in Performance Tuning, Query Optimization for improved database performance.

Experience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) for high performance Data Integration, Data Migration and report generation.

Extract data from one server to other servers using Control flow tasks like Bulk insert, Bulk Copy Program (BCP) for OLTP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2014/2012/2008).

Experience in creating SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) and SQL databases by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All, Lookup, Derived columns, Row count, For loop container, For each loop container, Sequence container.

Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points, Transactions and Expressions for SSIS Packages.

Experience in creating administrative functions such as backing up and restoring databases, copying SQL Server database objects.

Experience in administering SSIS packages such as Scheduling package execution, backing up and restoring packages, monitoring integration services performance and activity, and implementing security considerations for SSIS Packages.

Experience in creating Report Models for building Ad hoc reports using SSRS.

Excellent understanding of Relational Database Systems, Normalization/de-Normalization.

Hands on experience in Creating Star Schema and Snow Flake Schemas.

Worked in Logical modeling using the Dimensional Modeling techniques. Data modeling, creating star and snowflake schemas in SSAS.

Proficiency in creating diverse types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary and Sub reports, and formatting them.

Experienced in creating Queries using global variables, expressions, and functions for the reports.

Excellent understanding of database structures, principles, theories and practices

Great communication skills that enable discussion of ideas, designing solutions, accurate understanding of requirements from Business.

Great problem solving and analytical skills.

EDUCATION:

Master of Science, Melbourne Institute of Technology, Australia Aug 2011-May 2013

CERTIFICATIONS:

Microsoft Certified Professional in SQL Server (461 Querying Microsoft SQL Server 2012/2014,463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014)

Information Technology Infrastructure Library (ITIL® V3 Foundation).

TECHNICAL SKILLS:

Operating Systems

Windows, Unix and Linux

ETL Tools

BI Development Studio, SSIS, SSRS, SSAS, DTS, DSS, Import/ export wizard, Bulk Insert

Reporting Tools

SQL Server Reporting Services (SSRS), Report Builder 1.0/3.0, POWER BI, Excel, Crystal Reports 12

Database Tools

BIDS, SQL Server Management studio, Visual Studio, Configuration Manager, SQL Query Analyzer

Databases

SQL Server 2014/2012/2008, Oracle 11g/10g, My SQL

Networking

LAN, WAN and Configuring network printer

Problem and Incident Mgmt

JIRA, BMC remedy

PROFESSIONAL EXPERIENCE:

Liberty National Insurance Apr 17- Present

Role: SQL/BI Developer

Dallas, TX

Project: Universal Modular System (UMS)

Liberty National is a life insurance company that provides life insurance products for individuals and worksite groups. UMS is designed to create/approve groups (e.g. Unions), life insurance contracts for the groups, and to extend the automation and centralization of print and mail management process handled by organization to include cost management and status tracking of printing. UMS also distribute life insurance leads to the agents, facilitates adjustments of the leads, distribution of leads depending on the territory and generates business reports.

Responsibilities:

Developed business logic workflows in SQL Server using store procedures, UDFs, views, temp tables, table variables, For loops, CTEs.

Identified various data sources, designed and developed data models (physical/logical data models) based on the given specs and requirements.

Performance tuning on database Objects to achieve optimal data retrieval/updates using SQL Profiler, Execution plan.

Created database objects – Tables, Views, User defined functions, Store procedures, Joins, Dynamic SQL, Indexed Views, Daily Jobs and Workflow objects.

SSIS packages are created to transform and load data from Mainframe system to SQL Server.

For Loop container, For Each Loop container, Execute SQL Task and Data Flow Tasks were used extensively as part of ETL packages.

Error handling, SMTP emails, package scheduling is done as part of SSIS tasks.

SSRS reports are created to show agent related data to home office managers.

Defined the report layout in SSRS and generated drill down reports, parameterized reports.

Round Robin method was implemented in assigning leads to the agents.

Debugging, troubleshooting, and tuning store procedures and function.

Monitoring daily database jobs, data loads and proactive resolution of issues to ensure maximum uptime/availability of database for reporting.

Scheduled, enabled/disabled jobs using SQL server job agent for daily, weekly and monthly loads.

Created couple of Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.

Deployed SSIS packages on development, test and production servers. Involved in Change management process to deploy data objects on servers.

Environment: SQL Server 2012, Windows Server 2008, Visual Studio 2012, TFS, SSRS, SSIS, Power BI, Agile, Scrums.

HD Vest Mar 16 – Feb 17

Role: SQL/BI Developer

Dallas, TX

Project: DS-SOX

HD Vest offers tax, financial planning consultations, wealth management, and investment advisory services to its customers. Blucora, a leading provider of technology-enabled financial solutions is the parent company of HDVest and TaxAct.

DS-SOX Project was to develop data controls utilizing SQL Server, SSIS, generate reports through SSRS, and customize data controls. Around 750 data controls are monitored every day. Everyday financial transactions are tracked, ran through compliance check, control check and reports are generated.

Responsibilities:

Created new data controls with store procedures, table partitions, views, constraints, indexes.

Created and managed schema objects such as tables, views, indexes, store procedures, triggers and maintaining Referential Integrity.

Created table partitions to improve database performance on some critical data tables.

Created SSIS packages to transform data from daily feed file systems to staging database server and then to development database.

Implemented business rules depending on the financial plan that involves running rules engines, commission calculations.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Created checkpoints, configuration files in SSIS packages and Deployed SSIS packages with minimal changes using XML configuration file.

Extensively used Derived Column, Lookup, Conditional Split, Merge Join, Sort, execute SQL Task as part of SSIS packages to load data from one system to another.

Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.

Developed SSRS 2012 reports for SOX compliance, audit, operational controls on data marts and transactional data

Helped in developing Tableau reports as part of the compliance project requirement.

Designed and created Report templates, bar graphs, pie charts based on the financial data.

Actively involved in change management process to deploy database objects to QA/UAT/Production servers.

Troubleshooting, on call production support once every two weeks.

Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Created and maintained daily SQL jobs to monitor the health of SSIS packages.

Environment: SQL Server 2012, Windows Server 2008, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, MS Visual Studio, Tableau, Team Foundation Server (TFS).

Dell Nov 14 – Feb 16

Role: SQL Developer

Round Rock, TX

Project: Premier+

Premier+ is a B2B E-Commerce website where business customers login to the website and place/purchase bulk orders. Optimization of complex data objects, generating reports to monitor app health, ETL operations to migrate data among multiple application servers are some critical tasks.

Responsibilities:

•Created Stored Procedures, UDFs, Correlated Sub-Queries, CTEs, Views to support business logic.

•Created database triggers to implement business requirements.

•Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using SQL Profiler, Execution plan, and Splunk.

•Leverage Splunk, AppDynamics, and IBM Tealeaf to monitor databases performance.

•Created and updated ETL packages using SSIS to load/transform transactional data of customers and products purchased using Bulk operations

•Created, monitored and troubleshoot errors in SQL jobs that import/export data between systems.

•Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals.

•Created report models for ad-hoc reports and rendered reports in desired format by business.

•Written complex SQL queries and stored procedures for SSRS Reports

•Developed Refactoring application logic into TSQL procedures

•Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). Custom components for SSIS packages were written in C#.

•Imported source/target tables from databases by using Execute SQL Task in Control Tasks of SSIS.

•Deployment support and was involved in creating change requests to accommodate for changes that go in same release.

Environment: SQL Server 2008 R2, C# 4.0, Visual Studio 2008, TFS, SSRS, SSIS, Agile, Splunk, AppDynamics, IBM Tealeaf.

Xap Technologies Pvt Ltd Sep 13 – Aug 14

Role: SQL Developer

Melbourne, Australia

Project: kidsXap (child care management system)

Kidsxap is an end-to-end solution that manages attendance, enrolments, finances, business reports, injury reports, invoices, programming and staff rosters. A childcare software platform that encapsulates all aspects of childcare following guidelines of Australian government frameworks and bodies.

Responsibilities:

Involved in database design to create new databases that maintained referential integrity.

Generated database SQL scripts and deployed databases including installation and configuration.

Created Tables, Views, DML, DDL to facilitate easy user interface implementation.

Created new functions, triggers, store procedures, user defined functions, indexes.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Developed SSIS packages to bring data from OLEDB sources, excel and flat Files using MS Business Intelligence (BI) tool.

Generate reports with parameters, sub reports using SSRS

Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.

Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Documentation of all the processes involved in maintaining the database for future reference.

Performed unit tests, was involved in deploying database objects to test/production environment.

Environment: SQL Server 2008, Visual Studio 2008, TFS, SSRS, SSIS, Waterfall methodology.

Yash Technologies Pvt Ltd Jul 09 – May 11

Role: SQL Developer

Hyderabad, India

Project: iHire

Description:

iHire is an end-to-end plant hire application which integrates a high level of functionality with an easy-to-use interface that provides all aspects of the plant hire process from Handling customer query for a quote to invoicing the customer, automatic internal invoicing, Invoice approval at the click of a button.

Responsibilities:

Involved in ER diagrams and mapping the data into database objects, design of the Database and the Tables.

Build table relationships and wrote stored procedures to clean the existing data.

Developed SQL scripts to Insert/Update and Delete data.

Written complex SQL statements using joins, scalar and table user defined functions, views.

Worked on stored procedures and database triggers and worked.

Generated database SQL scripts and deployed databases including installation and configuration.

Experience in creating Indexes for faster performance and views for controlling user access to data.

Performed unit testing, provided bug fixes and deployment support.

Environment: SQL Server 2005, DDL, DML, Store Procedures, Views, UDFs, VSS, Waterfall methodology.



Contact this candidate