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