Resume

Sign in

Sql Server Data

Location:
Plano, TX
Salary:
90000
Posted:
March 12, 2018

Contact this candidate

Resume:

Sowmya Attur

ac4scj@r.postjobfree.com

469-***-****

Professional Skills

6+ years of experience as Microsoft Business Intelligence Developer.

Technical experience with design and hands-on programming on diverse technology platforms including RDBMS, Cube design & development, ETL engines, and dashboards.

Experience in creating complex SSIS packages for ETL purposes using various transformations.

Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors

Excellent knowledge of using variables and expressions in packages.

Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements

Created & formatted cross-tab, conditional, drill-down, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports

Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports creating on demand and scheduled reports.

Proficient with data warehouse structures staging, facts, dimensions, aggregate tables, dimensional modeling, Star schemas and maintaining data integrity.

Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).

Thorough understanding of Kimball/Inman strategies, key performance indicators (KPI) Reports, and data mining structures

High proficiency in the use of T-SQL for developing complex stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.

Experience in managing alerts, operators and jobs through SQL Server Agent.

Troubleshoot slow performing queries by using SQL Profiler.

Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.

Highly motivated and competent individual with good communication and analytical skills.

Always maintained positive communications and working relationship at all levels.

Ability and willingness to learn new technology and deliver results in a timely manner.

EDUCATION / CERTIFICATIONS

Bellary Engineering College (VTU University),Karnataka, India: Bachelors in Engineering (Electronics and Communication).

Microsoft BI Certification: Querying Microsoft SQL server 2012/2014

Technical Summary

Operating Systems

Windows XP/2007/2008/10.

Database Tools

Management Studio/Enterprise Manager, SSAS, SSIS, SSRS, SQL Profiler

Web Technologies

HTML

GUI Tools

Business Intelligence Studio (BIDS), Visual Studio 2008/2012/2015

Languages

VB Script, C#, T-SQL, Teradata, C, C++, XML.

Databases

SQL Server 2008 R2/2012/2014/2016

OLAP Tools

SQL Server Reporting Services, SSIS (as ETL), Report Builder 2.0/3.0, SSAS

Office Tools

MS word, Excel, Access, Power point, MS Visio

Version Control

TFS

Professional Experience

TexasLending.com, Dallas, TX September 2015- Present

SQL Server SSIS/SSRS ETL Developer

Responsibilities

Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, Excel, flat file sources and XML sources.

Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)

Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency

Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.

Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.

Performed various Data Transformations using conditional split, data conversion, derived columns and lookups to source data to transfer data in a format as per organization needs

Organized Error and Event Handling by giving Precedence Constraints, Break Points, Logging.

Scheduled and monitored SQL Server Agent Jobs to run various SSIS packages in SQL management Studio to automate manual tasks

Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.

Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.

Created Standard Report Subscriptions and Data Driven Report Subscriptions

Created report snapshots for better performance.

Follow Agile Methodology to keep track of projects and maintaining schedule by conducting daily scrums and bi-weekly sprints.

Environment: Windows 2008/10, SQL Server 2008R2/2014, TSQL, SSIS, SSRS.

Wegmans Food Markets, Inc, Rochester, NY April 2012 - August 2015

SQL Server SSIS/SSRS ETL Developer

Responsibilities

Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, oracle, Microsoft Access.

Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency

Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.

Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.

Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.

Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.

Deployed the solutions on web server, involved in creating user security and roles in reporting services at both parent level and report level.

Environment: SQL Server 2008R2/2012, Windows 2008/XP, SSIS, SSRS.

Cognizant Technology Solutions, India Dec 2007-Nov 2009

Datawarehouse Tester

Responsibilities:

Prepared Test plan, Test cases Creation of Test Data, Creation and Effective execution of test cases, Responsible for system testing, using the Detailed Design & Technical specification documents

Involved in End to End Testing. Conducted defect review meeting on daily basis to prioritize the defects

Responsible for Regression Testing, Developed SQL queries for complex data validations

Managed the defect tracking process using QC.



Contact this candidate