Data Developer
Resume:
Swetha Palla
*********@*****.***
PROFESSIONAL SUMMARY:
Over 9+ years of experience in the IT industry as a SQL Server developer with specialized skills in SSRS, SSIS and SSAS. Very Strong SQL Server 2005/2008/2012 and 2016 developer and Admin skills including writing stored procedures, user-defined functions, triggers and views. Strong transact-SQL query writing skills and reporting skills including SSRS, business objects, Tableau, Qlik view, Microstrategy
Extensive experience with ETL SQL Server Integration Services (SSIS), developed several types of SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Variables Deploying, resolving complex issues and Error Handling in SSIS.
Hands on experience with SSRS, developed several types of complex reports using SSRS (ad-hoc, drill-down, pivot, tabular, etc.). Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions and performed extensive trouble shooting by cross checking the report layouts, datasets, stored procedures.
Good Knowledge of Software Methodologies and Software development Life Cycle.
Strong experience in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Functions, Cursors, Sub-queries, Joins and Indexes using T-SQL, modeling database tables, Normalization techniques
Developed normalized logical and physical database models to design OLTP system.
Extensive experience with SQL Server Analysis Services (SSAS) that delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications, created multidimensional cubes and reports using OLAP Services and Multidimensional Expression (MDX) queries.
Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS.
Created weekly and monthly partitions in SSAS cubes to process the data.
Experience in configuring Linked servers, monitoring, troubleshooting and migrating SQL Server.
Experience working with different stakeholders including data modelers/architects, business sponsors and business solutions.
Developed reports using tools such as Tableau, Power BI and Qlik view.
Designed and developed BO reports/universes accessing SQL Server database.
TECHNICAL SKILLS:
Data Base & BI Tools : SSMS, BIDS, SQL Server Data Tools, Visual Studio 2012/2013/2015/2017
Data Modeling Tools : ER Assistant, Erwin, MS Vision
OLAP Tools: Microsoft Analysis Services, Business Objects
ETL Tools: Microsoft SSIS,DTS
Reporting Tools: SSRS, BO, Tableau, Microstrategy, Power BI, Qlik view
Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML
Database Tools: SQL Server 2016/2014/2012/2008 R2/2008, MySQL, MS Access, Oracle, DB2
Packages: Microsoft Office Suite, Microsoft Project 2010
Operating Systems: Microsoft Windows and UNIX
PROFESSIONAL EXPERIENCE:
Reliable Software Resources
Honda Manufacturing, OH June 2013 to till date
Senior SQL BI Developer Aug 2011 to June 2012
Ensure that the data assets of an organization are aligned with the organization in achieving its strategic goals. The architecture should cover databases, data integration and the means to get to the data.
Developed normalized logical and physical database models to designed OLTP system in Honda environment.
Developed data warehouse using data modeling techniques like dimensional data modeling, star schema modeling and snow-flake modeling thorough understanding of normalization /de-normalization and database design methodology.
Implemented Change Data Capture (CDC) and Slowly Changing Dimensions (SCD) ETL to load the data into warehouse.
Perform preventive maintenance activities like casual analysis, restructuring program code, data problems resolution and performance tuning.
Involved in different team projects with good project implementation (SDLC), team skills, troubleshooting, presentation abilities and issue resolution capabilities.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
Maintain and troubleshoot existing SSRS reports.
Performed data migration from excel to SSRS in Honda’s Active Plant infrastructure.
Designed and developed Business Objects (BO) reports/universes accessing SQL Server database.
Created Partitions and Aggregations to improve the DataMart performance
Experience in developing Tableau workbooks from multiple data sources using Data Blending
Created ERD diagrams using MS Visio
Created Power BI dashboards for external client reporting.
Used JIRA for tracking defects, enhancements and new development.
Used TFS and Sub version for code source control.
Train off-shore operations team on the ETL (Extract, Transform and Load) processes we build.
Maintain and create documentation to describe our data management processes.
Extensively used IT service management for change management.
Experience in Agile Scrum environment, Daily Standup's, sprint planning meetings, backlog grooming meeting, retrospective and sprint demos.
Hardware/Software: MS SQL Server 2012/2016, SSIS, SSRS, Tableau, Power BI 2016, JIRA, Confluence, Visual studios 2016, Business Objects 4.2 SP7,Tableau,Microstrategy, PostgreSQL(pgAdmin III), Visio, TFS, Azure DevOps, subversion,ITSM IT service management.
Reliable Software Resources
Michigan Economic Development Corporation, MI (MEDC) Oct 2012 to June 2013
SQL Database & ETL Developer
Experience in Agile Scrum environment, Daily Standup's, sprint planning meetings, backlog grooming meeting, retrospective and sprint demos.
Experience with development and deployment of SQL Reporting services (SSRS) Reports and integration with SharePoint.
Developed Stored Procedures, User Defined Functions, Views and T-SQL Scripts for complex business logic.
Worked closely with end users, testers, business people and product managers in identifying and resolving the production on demand data issues.
Experience in Data Mapping between the SQL Server 2008 and Sales force.
Developed Extract (ETL) routines using SQL Server 2008 stored procedures to extract the data from SQL Server and load in Sales force.
Documenting any mapping issues. Ensuring the Documenting any data transformation anomalies and de-duplication concerns.
Developed Score Card report and responsible for Status, Trend, Current and Annual target fields modifications.
Created SSIS Packages using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Row Count, Script Task, Data Flow Task and Variables to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, XML files and CSV files.
Developed error and event handling using precedence Constraints, Break Points and check points.
Documented the whole design of ETL Process using Visio tool.
Used TFS for code source control.
Hardware/Software: MS SQL Server 2012/2016, SSIS, SSRS, T-SQL, Business Intelligence Development Studio (BIDS), Visual studio 2008, Sales force, FTP.
Kalven Technologies
Walt Disney Groups, Orlando, FL May 2011 to July 2011
SQL Server/SSRS Developer
Created functional and technical specifications for projects.
Involved in gathering reporting requirements from business team and users.
Identified and defined the datasets for report generation.
Created interactive reports with SQL Server Reporting Services (SSRS), using the report parameters, query parameters, filters and expressions.
Developed several complex reports using SSRS.
Designed and implemented reports security.
Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
Created ad-hoc reports, drill-down reports and parameterized reports.
Deployed reports to report manager.
Created documentation and trained end users on using report manager.
Hardware/Software: MS SQL Server 2008, SQL Server Reporting services (SSRS), Business Intelligence Development Studio (BIDS) and Visual Studio.
Adams and Garth Staffing
CFA Institute, Charlottesville, VA Oct 2010 to Dec 2010
SQL Server/SSRS Developer
Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
Developed custom reports and deployed them on server using SSRS 2008.
Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL
Server Reporting Services (SSRS).
Configured Reporting Services in SQL Server 2008.
Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
Created different chart reports, helped in analyzing performance counters using SSRS 2008.
Worked on uploading Reports from Report Server on to share point server.
Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
Created dashboards with gauges and charts in SSRS 2008 in native mode.
Created Report Models to be used by business users for ad-hoc reporting.
Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.
Hardware/Software: MS SQL Server 2008, Windows Server 2008, T-SQL, SSIS, SSRS, MS SharePoint.
Education:
Maters in Computer Science from University of Northern Virginia.
Master in Computer Application from Jawaharlal Nehru Technological University.
Contact this candidate