Resume

Sign in

Sql Server Data

Location:
Alexandria, Virginia, United States
Salary:
60/hr on C2C
Posted:
October 19, 2016

Contact this candidate

Professional Summary

Over * years of progressive experience in the software industry as a MS SQL BI/ETL Developer (SSRS, SSIS, and SSAS) in MS SQL Server 2005/08/08R2/12.

Experience with Finance, Benefits, Health, Security Services, Banking, HCM and Benefits Clients.

Proficient in writing complex T-SQL (DDL, DML), using new features like CTE, ranking functions, pivot and building referential integrity constraints.

Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.

Hands on experience in creating indexed Views, complex Stored Procedures, effective functions and appropriate Triggers to assist efficient data manipulation.

Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers

Skills and experience in using appropriate calculations, parameters, report types, dynamic attributes, sets, cubes, filters within Tableau

Experienced in Event Studio(Cognos) for scheduling and emailing reports, automate reports and generate documents using scheduler

Proficient in using Cognos Workspace and Workspace advance (Business Insight and Business Insight advance) to create dashboards

Great team building capacity with excellent communication and problem solving skills.

Experience in Software testing with expertise in writing test cases and performing unit testing, acceptance testing, regression testing and system testing.

ETL Development (DTS, Integration Services)

Created several SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split and many more.

Extensively experienced in Extraction, Transformation, and Loading tasks in SSIS while transferring the data to target destinations from various sources like Excel, CSV, Oracle, Access, Flat File, Raw File and XML File.

Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.

Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.

Experienced in using multiple Control flow and Data flow tasks to build complex SSIS Packages.

Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages.

Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.

Reporting Services/Analysis Services

Expertise creating various complex reports in SSRS 2005/08/12 including tabular reports, drill down reports, drill through, matrix reports, chart reports, sub reports and parameterized queries for generating cascading reports.

Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).

Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.

Education

Bachelors of Science in Computer Science

SKILLS AND KNOWLEDGE

Operating Systems

Windows XP, Windows Vista, Windows 2003/2007/2008

Programming Languages

Java, C/C++, Python, XML, XSLT, Java Script, Ms-SQL, T-SQL

BI and ETL tools

Microsoft SQL SERVER 2012/2008/8R2/2005,Business Intelligent Development Studio (BIDS), SQL server Data tools, Microsoft SQL SERVER 2005/2008/2012 Integration Services Toolkit (SSIS), Microsoft SQL SERVER 2005/2008/2012 Analysis Services (SSAS), Microsoft Visual Studio2010/2012, Cognos 8 and 10, Tableau

Reporting Tools

Microsoft SQL SERVER 2005/2008/2012 Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0

Relational Databases

SQL SEVER 2014/2012/2008R2/2008/2005

WORK HISTORY

OneSource Virtual Inc., Irving TX

SQL Server SSIS/SSRS Developer

Nov 2015-Till date

OneSource Virtual offers end-to-end Workday solutions, including Strategic Consulting; Workday Implementations; U.S., Canadian and U.K. Payroll Services; U.S. and Canadian Benefits Administration, Finance & Accounting Services, Workday Application Management Services and Workday Training for companies of all sizes.

Roles and Responsibilities:

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Designed number of SSIS packages for data transfer between flat files, XML, Sales Force, Oracle, MYSQL and SQL Server using different transformations such as Lookup, Derived Column, Merge Join, Fuzzy Lookup, Script Component and etc.

Created SSIS Templates for developing SSIS Packages, Implemented SQL Server configurations and error handling in SSIS Packages.

Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Collected business requirements from users and translated them as technical specifications and design documents for development.

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

Involved in deploying SSIS Packages to production from different environments and scheduling and administrating SSIS Packages, wrote best practices for deploying SSIS Package to Production.

Used SSIS 2012 to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases

Created Tables, Views, Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.

Bulk data migration using SSIS from flat files

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.

Created SSIS packages and scheduled the jobs to run automatically.

Maintained data integrity by performing validation checks.

Monitored performance and optimize SQL queries for maximum efficiency.

Creating and Modifying T-SQL Stored Procedures for validating the integrity

Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.

Environment: Windows 2003/2008 R2 Server, MS SQL Server 2005/2008 R2/2012, BIDS, SSIS, SSRS, and SSAS.

Thales Avionics Inc., Irvine CA

BI/ETL Developer

Nov 2013-Oct 2015

Thales is helping organizations everywhere meet the challenges of a complex digital age. From Aerospace, Space and Defence to Security and Transportation, Thales helps its customers to create a safer world by giving them the tools they need to perform critical tasks.

Role and Responsibilities:

Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.

Extensively used T-SQL to manipulate and architect to produce results for users.

Performance tuning of Queries and Stored Procedures.

Used SQL profiler to view indexes performance to mostly eliminate table scan.

Worked with development teams in the design of physical databases and in modification.

Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements using SSRS.

Created and developed query for Drill Down and AD Hoc Reports using SQL Server Reports Services (SSRS).

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.

Created SSIS process design architecting the flow of data from various sources to target.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.

Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.

Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.

Created ETL SSIS packages both design and code to process data to target databases.

Constructed OLTP and OLAP Databases.

Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.

Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2005, 2008, 2012, Microsoft Visual Basic 6.0, SSIS 2012, SSAS, SSRS, OLAP, Performance Point Server.

T-Mobile,Bellevue,WA

ETL Developer

Dec 2011 – Oct 2013

T-mobile is the one of the largest Telecom Companies in the USA. Joined existing onshore BI team as ETL Developer and successfully designed, developed business solutions. The project which aims in fulfilling T-mobile’s need for reporting to better understand the market trends, behavior, future opportunities and to improve there decision making process. Coordinated with the business and P&A team to understand the system requirements and then analyzing and designing ETL solutions to accomplish the same. Involved in various successful releases to accomplish T-mobile’s reporting needs under order-activation (OA) functional area.

Responsibilities:

Gathered business requirements from Business Analyst.

Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.

Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load

Installed and Configured the Informatica Client tools.

Worked on loading of data from several flat files to XML Targets.

Designed the procedures for getting the data from all systems to Data Warehousing system.

Created the environment for Staging area, loading the Staging area with data from multiple sources.

Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Used workflow manager for session management, database connection management and scheduling of jobs.

Created UNIX shell scripts for Informatica ETL tool to automate sessions.

Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center 5.1.2/7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX Shell Scripts.

HealthCare partner, Torrance, CA

MS SQL Server/ETL Developer

Sep 2010 - Nov 2011

HealthCare Partners offers strategic planning, implementation, and development of integrated delivery systems, and offers expertise in IPA and medical group formation.

Roles and Responsibilities:

Involved to work with troubleshooting the stored procedures, functions, views, triggers & part to be increasing the performance tuning.

Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.

Developed SSIS ETL packages to meet data flow needs.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.

Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.

Created Parameterized reports, Drill down and Drill through reports and thorough knowledge of report serving architecture using SSRS.

Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.

Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.

Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.

Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.

Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2/2012 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.

Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results and so on.

Environment: MS SQL Server 2008/8R2/2012, MS Access, Import & Export Data

Guide One Insurance, West Des Moines, IA

SQL Server/SSIS Developer

Jun2009-Aug2010

GuideOne Insurance offers comprehensive coverages, a broad array of risk management resources and superior church market expertise. GuideOne serves churches, educational institutions, senior living and health care centers and nonprofit organizations with commercial insurance solutions. We also help families and individuals with a wide range of auto, home owner and renter coverage.

Roles and Responsibilities:

Prepared the Technical and Function specifications based on the project requirements.

Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.

The SSIS Packages include, a Master Package, which executes a number of Child Packages. The packages created include a variety of transformations such as Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.

Set package configuration in SSIS to redirect path from test environment to production environment.

Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Modified stored procedures to meet current design and used them in SQL Server.

Developed queries in Data Warehouse in OLTP/OLAP environment.

Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.

Modified web pages to do database inserts, deletes, modify.

Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.

Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.

Environment: SQL Server 2008/2005, Integration Services 2005, Share point server.



Contact this candidate