Resume

Sign in

Microsoft Office Data

Location:
Reading, Pennsylvania, United States
Posted:
August 27, 2018

Contact this candidate

Resume:

SRAVANI

+1-201-***-**** ac6txf@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 3 Years of experience in IT as SQL Developer and Analyst, involved in requirement gathering, analysis, configuration, deployment and administration of enterprise database applications

Proficient in writing Transact SQL queries involving creation of Tables, Views, Stored Procedures, Partitions, performing inserts, updates, deletes using Joins, Sub queries, Cursors and adding constraints on the tables.

Good understanding of Normalization /De-normalization, Normal Form and database design methodology.

Strong knowledge of creating different indexes like cluster and non-cluster indexes from optimization point-of-view according to the business criteria.

Experienced with the creation on SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Information Services (SSIS), Bulk Insert.

Well versed in creating Dynamic SSIS packages, using containers and variables, configuring the packages, and scheduling the packages.

Experience in deploying and enhancing the SSIS Packages from development server to production server.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent to run Stored Procedures and SSIS Packages.

Experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing.

Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts

Performed sophisticated ad-hoc or ongoing custom analyses against medical claims to support business stakeholders.

Hands on experience in designing multiple types of reports in SQL Server Reporting Services (SSRS) including Cascading Parameterized, Drill down/Drill through and sub reports.

Extensive experience in OLTP/OLAP environment and Experience in OLAP Cubes.

Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on

Relational and OLAP databases.

Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS:

Languages

T-SQL, SQL 11g, MDX, XML, HTML, DHTML, HTTP

Databases

MS SQL Server Denali,2014,2012,2008R2,2008,2005,2000

DWH / BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Crystal Reports 8/10

Database visualization Tools

Power BI, Tableau

Packages

MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Operating Systems

Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS

WORK EXPERIENCE:

United Fire Group, Iowa, USA October 2017 – Present

SQL BI DEVELOPER

Responsibilities:

Wrote complex Stored Procedures and Views to cleanse data in the ADB database before letting the data flow downstream.

Created a Parent Package which takes care of all the child packages setting configurations to help the data flow from CPMS to Staging.

Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2012/2014.

Designed high level ETL, for overall data transfer from the OLTP to OLAP with the help of SSIS.

Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

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

Experience in developing Database Schemas / Joins, Views, Indexes, Stored Procedures / Data Dictionary.

Experience and knowledge in designing and developing data visualization strategies.

Imported data from text files and excel spread sheets into SQL Server 2012 database using SSIS package.

Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Demonstrated experience in utilizing design tools, development tools, code management, regression testing and performance tuning.

Expert in Managing the relation between Visualizations in Power BI

Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

I used to Create SSIS Packages for the Query's behind the Dashboard to Table to Improve the Performance.

Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc.

Environment: Windows 7 Server, MS SQL Server 2012/2014, SSIS, SSRS, Power Pivot for Excel 2013, JIRA Ticketing system, Visual Studio, SSMS.

BSNL, Hyderabad, India May 2013 – August 2015

JR. SQL SERVER DEVELOPER

Responsibilities:

Used T-SQL to create various queries of employee data, new hires applicants, promotion, demotion, leave absence, payroll data.

Actively participated in gathering of User Requirement and System Specification.

Database Administration, Production and Development Support.

Created report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.

Created and developed the stored procedures, functions and triggers to handle complex business rules, history data and audit analysis.

OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.

Created and maintained Roles and Database users.

Performed data conversions from flat files into a normalized database structure.

Provided assistance for development teams on tuning data, indexes and queries.

Used DBCC commands for checking database consistency and fixing data corruption in user databases.

Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring, block, and dead lock.

Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

Configured securities and accesses for production databases and database servers

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Design and develop T-SQL Procedures, query performance tunings.

Ensure compliance of standards and conventions in developing programs.

Resolve and troubleshoot complex issues.

Perform data extraction from various sources and load to SQL server data base using SSIS.

Developed various reports as per requirement on regular basis using SSRS.

Environment: SQL Server 2012, T-SQL, Integration Services (SSIS), Reporting Services (SSRS), Windows 2008 Server R2, SSMS.

EDUCATION

DEGREE

• Major: Master’s in Information Systems

• Minor: Business Management

DEGREE

• Major: Bachelor of Technology

• Minor: Electronics and Communication Engineering



Contact this candidate