SUMMARY

• 3+ years of experience as Database Administrator, Report Developer, and Data Analyst.
• Advanced SQL, Access, and Excel skills. High comfort level with consolidating and joining data using Left and Right Outer Joins, Inner joins, creating formulas.
• Develop queries to retrieve and analyze data from multiple tables in the database. Find tables using Database diagrams in SQL server, establish relationship in multiple tables using Primary and Foreign keys.
• Perform ad - hoc analytical request using SQL for internal and external parties.
• Analyze and interpret data to understand business impact, correlations/discrepancies, explain variance analysis, budget analysis and propose changes and /alternate solutions.
• Experience in Creating Tables, Views, CTE's, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Developed Detail and Summary reports, Parameterized Reports, Drill through and Drill down reports using SSRS for the QA department. Explain results to QA and Compliance managers using templates, graphs, Power points and Pivot charts.
• Deploy and upload SSRS reports to SharePoint Server and Report Manager for the end users and involved in enhancements and modifications. Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extract, transform, and load data (ETL) from various sources to various destination using SSIS.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Understanding of systems development life cycle including issue, risk and scope management.
• Experienced in documenting business, process and data flows.

TECHNICAL SKILLS

Operating Systems: UNIX and Windows; AS400, 2000/NT/XP/2008/2012 server.

RDBMS: MS SQL SERVER 2014/2012/2008 R2/2008.

Database Tools: SQL Query Analyzer, SQL Management Studio, SQL Server 2005, Query Editor, Reporting Server, MS - Access, T-SQL, SSAS, Visual Studio, Power pivot, OLAP, ASP.NET, OLTP applications.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS).

BI Tools: MS SQL Business Intelligence, Business Objects.

Microsoft: Word, Excel 2016, Power view, VLOOKUP, HLOOKUP, PowerPoint, Publisher, Outlook. SharePoint 2013/2010, Report Builder 3.0, SPSS, Minitab, PeopleSoft, LPS, Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Denton TX

Business Intelligence Developer & Data Analyst

Responsibilities:

• Used tools (Excel and SQL) to analyze, query, sort and manipulate data according to defined business rules and procedures.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Utilized SSRS Reports from different source formats and satisfying clients by representing reports and presentations.
• Produced parameter driven, matrix, sub-reports and integrated report hyperlink functionality to access external applications.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports.
• Developed parameterized dashboards and reports with SQL Server Reporting Services (SSRS).
• Responsible for developing and optimizing reporting solutions using SSRS to author, manage, and deliver dynamic, interactive, drill-down web-based reports.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Produced dashboard SSRS Reports under report server projects and publishing SSRS Reports to the reports server.
• Integrate data from various sources using SSIS, validate data and create reports.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, Merge and Merge join, Union All, Lookup, and Send Mail task etc.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created data dictionary for managerial references.
• Optimized SSIS packages and stored procedures that improve the processing speed of large files.
• Carried out edit checks to edit data based on certain conditions like filtering records with nulls, bad/incomplete SSN, incomplete phone numbers and zip codes.
• Worked in an Agile (sprint and scrum) environment.
• Compiled data from multiple sources, which may include simple data mining and imports data into Spreadsheets/ Databases.
• Translated business needs into technical code.
• Utilized query and reporting analysis tools to develop MS Power-Pivot Solutions.
• Centralized data collection by developing methods for database design and validation reports.
• Presented monthly and quarterly projects and reports to management team utilizing MS-PowerPoint.

Confidential, Akron OH

Data Base Developer/Data Analyst

Responsibilities:

• Worked with internal or external business partners to recommend business intelligence solutions.
• Migrated MS Access, MS Excel shared workbooks & QuickBooks tables into SQL Server 2008R2.
• Created database objects, complex queries and stored procedures to support the ETL process of loading data files received from clients.
• Automated the ETL process from T-SQL queries to SSRS for dynamic reporting using SSIS.
• ETL Development, Database design, data storage and management of data that can be used for analysis and presentation.
• Designed efficient ETL processes using Microsoft SQL Server stored procedures & SQL Server Integration Services that imports Claims data from various sponsors.
• Identified cause for ETL job failures and rectify the issues.
• Optimized SSIS packages and stored procedures that improve the processing speed of large files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, Execute SQL task, Sequence containers etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer. Implemented Event Handlers and Error Handling in SSIS packages.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Utilized Pivot tables to summarize and analyze large amounts of data in lists and tables.
• Utilized VLOOKUP and HLOOKUP in sorting and organizing large data set.
• Presented monthly and quarterly projects and reports to management team utilizing MS-PowerPoint.

Confidential

Human Resources Manager &Data Analyst

Responsibilities:

• Identified data process improvements and leverage technology to automate and streamline existing processes.
• Worked closely with Compliance Managers to develop graphs, Matrix reports, drilldown, drill through, sub reports, dashboards and presentations for quality activities, patterns or trends and operational metrics.
• Wrote queries to develop new, ad hoc and modified existing reports in SSRS and Excel using charts, graphs, tables and matrices.
• Used SQL to analyze, query, sort and manipulate data according to defined business rules and procedures.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Utilized Pivot tables to summarize and analyze large amounts of data in lists and tables.
• Identified cause for ETL job failures and rectify the issues.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Develop conceptual, logical, and physical data models for some of the large and complex data warehouses and data marts.
• Interviewed and recruited new employees.
• Analyzed and implemented policies.
• Revamped and delivered training to existing and new employees