BI DEVELOPER

Sowjanya

732-***-****

adm01t@r.postjobfree.com

SUMMARY:

•Having 10+ Years of Database Administration and Development experience on MS SQL SERVER 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments

•Experience in installing MS SQL SERVER 2014, 2012, 2008 R2, 2008, 2005 and updating with hot fix and service packs

•Strong exp in Always On Availability Groups.

•Strong understanding of RDBMS concepts as well as Data Modeling Concepts

•Extensive experience in implementing HADR solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines

•Experienced in developing Power BI reports and dashboards from various Data Sources like Cube, Databases, Excel files.

•Good Experience in database design, data modeling, development, implementation, ETL and reporting in SQL Server 2016/2014/2008 R2.

•Reporting Services (SSRS), Analysis Services (SSAS) & Power BI (Power View, Power Pivot)

•Practical understanding of data modeling (dimensional & amp; relational) concepts like star-schema modeling, snowflake schema modeling, and fact and dimension tables.

•Used Power BI to prepare dashboards to create attractive visualizations.

•Experience and skills in Behavior Modeling, Predictive Modeling for Insurance.

•Experience in handling business and technical issues & communicating with both business users and technical users.

•Good experience in building reports with Business Objects XI 2/XI3/4.0/4.1 and Tableau desktop. Good knowledge in Spark Apache.

•Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.

•Knowledge in writing T-SQL (DDL, DML, and DCL) statements

•Migrated DTS 2000 packages to SSIS packages in 2005 using Migration Wizard

•Experience using SQL SERVER 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)

•Experience and working knowledge with Microsoft Azure Infrastructure as a Service platform, including planning, configuration, optimization and deployment. Understands unique differences in customer/departmental needs.

•Worked on Data Integrity, Performance Tuning, Query Optimization

•Providing on call support 24/7 on rotational basis for production database on mission critical systems

•Developed reports using Microsoft Power BI (Desktop, Service, Mobile)

•Developed dashboards with Power BI which display key KPIs for business analysis and decision making

•Implementing CR (Change Request) and CA (Change Amendments) requested by users

•Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources

•Work closely with other departments within Fidelity and act as interface bet the DB2 group and the other technical teams coordinating their upgrades/projects/ deliverables

•Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis

•Experience in Client/Server Connectivity, Database health Check, Indexing and Updating Statistics.

•Used Jira as a ticketing tool to work on the assigned tasks

•Azure PaaS Solutions like Azure Web Apps, Web Roles, Worker Roles, SQL Azure and Azure Storage

•Expert in Implement deploy and configure Azure websites, configure diagnostics, monitoring and analytics on Azure Platform along with scale and resilience for Azure Web sites

•Good knowledge in Snowflake Schema concepts. Created view in snowflake and pulled into power bi to create dashboards.

•Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values

•Good knowledge in SAP HCM and power Integration.

•Experience in Fog light and CIS Tools, Experience in Team Foundation Server(TFS)

TECHNICAL SKILLS:

Operating System

Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX

RDBMS

MS SQL SERVER 2005/2008/2008R2/2012/2014, DB2, MS Access

Languages

Transact-SQL, SQL and Visual Basic

Database Tools

Enterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, JIRA, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON, Quest Lite speed, SQL Safe, Red gate, Tivoli, Azure.

ETL Tools

SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools

SSAS 2005/2008/2008 R2/2012

Reporting Tools

SSRS 2005/2008/2012, Crystal Reports, BO-Universe, Web Intelligence, MS Excel, Power BI.

SAP

Business Objects Lumira, HANA

CERTIFICATIONS:

Querying Microsoft SQL Server 2012/2014 [70-461]

Administering Microsoft SQL Server 2012/2014 Databases [70-462]

Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 [70-463]

Masters in Tech in DSCE from JNTU 2008.

PROFESSIONAL EXPERIENCE:

UPS, Atlanta Sep 2020 to Present

MSBI, Power BI

Responsibilities:

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

Experience in Power BI (DashBoard Reports), Power BI using MS SQL Server and in supporting services like tabular analysis services.

Created custom dashboards and deployed using power bi

LandrumHR Dec 2019 to August2020

MSBI, Power BI

Responsibilities:

Worked on Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.

Explore data in a Variety of ways and across multiple visualizations using Power BI

Experienced in BI Development and Deployment of SSIS packages from MS - Access, Excel.

Caterpillar, IL Nov 2018 to Nov 2019

Power BI Dev

Responsibilities:

Imported data from SQL Server DB, Snowflake DB to Power BI to generate reports.

Created Dax Queries to generated computed columns in Power BI.

Generated computed tables in Power BI by using Dax.

Assurant, PA July 2018 to Nov2018

SQL DBA/BI Dev

Responsibilities:

Good Experience in SQL Database Administrator working on 2017 version.

Involved in Migration project from 2008 to 2017 changes related to sp’s, views, triggers etc

Monitoring the sql health, database changes affecting during normal conditions and at the time of migration. Prepared project plan, related activities.

GVR Greensboro, NC April 2017 to Jun 2018

BI Dev/SQL DBA

Responsibilities:

•Expert in performing installation, configuration (32bit/64bit), optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments.

•Designed, developed the customer comparison reports in MS SQL Server environment using SSRS 2012.

•Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the

ABA, New York, NY July 2016 to Mar 2017

SQL Server DBA Lead

Responsibilities:

•Regularly monitored and identified blocking issues. Worked on a procedure that continuously run on all PROD servers and notifies DBA team if any blocking, long running quires/transactions.

•Check Performance counters on all production servers and verify that all counters are within the normal range.

•Designed SSRS metrics report to review the counters for every one hour.

Medtronic, Edison, NJ Apr 2013 to July 2016

BI Dev/SQL DBA

Responsibilities:

•Installed and maintained of SQL Server 2014, 2012 on Test, Development and Production Environments, Active Directory Administration

•Regularly monitored and identified blocking issues. Worked on a procedure that continuously run on all PROD servers and notifies DBA team if any blocking, long running quires/transactions.

•Check Performance counters on all production servers and verify that all counters are within the normal range. Designed SSRS metrics report to review the counters for every one hour.

Toyota Technical Center, Ann Arbor, MI Sep2011 to Mar 2013

BI Dev/SQL DBA

Responsibilities:

•Developed complex T-SQL code for data retrieval.

•Responsible for backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

•Responsible for data retrieval by extensive use of joins normalization and views.

Contact this candidate