Sql Server Data
Resume:
Sowmya Attur
*********@*****.***
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