Data Power
Resume:
Padma T
SQL/BI Developer
adkgd8@r.postjobfree.com
US Citizen
Professional Summary
Over 5 years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008R2 using SSIS ETL.
Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
Hands on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.
Hands on Experience in using tools like SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions and features.
Good understanding of Normalization / De-normalization, Normal Form and database design methodology.
Expertise in writing SQL Queries, Dynamics, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.
Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, Qlikview, and Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.
Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.
Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, Bulk Insert and BCP.
Developed, monitored and deployed SSIS packages.
Experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
Excellent inter personal skills and communication skills and ready to take challenges with proven ability.
Experience in Deploying SSIS packages using the Legacy deployment model as well as deploying SSIS packages using the new Deployment model (Project deployment Model) from SQL server 2012 using SSISDB catalog, configuring project parameters and environments.
Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards.
Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts, KPI’s in power BI reports.
Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
Strong team player with great verbal, written communication and interpersonal skills.
Education:
Bachelor`s
Technical Skills:
Data Warehousing & BI
SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)
Reporting Tools
SSRS 2016/2014/2012/2008, Excel, Tableau, Power BI.
Database
MS SQL Server 2016/2014/2008/2005, Oracle, MS-ACCESS.
Programming
C, C++, TSQL, DAX, MDX
IT Processes
Software Development Life Cycle (SDLC), Project Management
Productivity Applications
MS Word, MS Excel, MS Access, MS Project, Visio
Operating System
Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.
Application Servers
Microsoft IIS 6.0/5.0/4.0, Apache.
Professional Experience
Client: Trellance, Florida
Role: SQL Server/Power BI Developer Mar 2019 – Present
Responsibilities:
Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using Erwin Data Modeler.
Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
Installed and configured Power BI Desktop.
Created Power BI Visualizations and Dashboards as per the requirements.
Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2012 and Flat files.
Installed and configured and maintained Power BI Report Server.
Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.
Created reports on Power BI Desktop and published on Power BI Report Server.
Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
Created SSIS packages to integrate the data coming from flat files
Migrated SSIS Packages from 2008 to 2012 during data migration.
Optimized queries by looking at Execution Plan for better tuning of the database.
Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
Created SSIS packages for loading data from SAP BW/BI to SQL Server.
Performed database backup and deployment to the production server.
Worked Extensively with MS SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
Used BCP utility and Bulk Insert to load data from different data sources to SQL Server.
Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
Tools and Technologies: MS SQL Server 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intact, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.
Windows Server, Windows NT, Erwin
Client: WellCare, Florida Jan 2017 to Feb 2019
Role: SQL Server/BI Developer
Responsibilities:
Wrote complex queries using T-SQL to create joins, sub queries, functions and correlated sub queries to retrieve data from the database.
Worked on Data warehouse development, which would store all the EDI 837 Format information.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
Created/Updated database objects like tables, views, stored procedures, function, packages.
Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server
Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
Created mapping tables to find out the missing attributes for the ETL process.
Created SQL Jobs to schedule SSIS Packages, Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
Created VB.Net, C# Script for Data Flow and Error Handling using Script component in SSIS.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
Used SQL Server Profiler to trace the slow running queries and the server activity.
Automated and enhanced daily administrative tasks including database backup and recovery.
Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
Preparing reports using calculated fields, parameters, calculations, groups, sets and hierarchies in SSRS.
Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
Migrated reports from SSRS to PowerBI.
Created multiple reports Power BI in Drill mode using tables, financial tables, crosses tabs and chart.
Create reports in Power BI preview portal utilizing the SSAS Tabular.
Published Power BI Desktop reports created in Report view to the Power BI service.
Transformed and combined the data using Query Editor in the Power BI
Tools and Technologies: MS SQL Server 2014/2016, SSRS, T-SQL, SSIS, Win 2008 Advanced Server, Erwin v8.0, ASP.Net, C#, MS Access 2010
Client: NSF, VA.
Role: SQL/SSIS/SSRS Developer Sep 2014 to Dec 2016
Responsibilities:
Wrote queries using T-SQL to create joins, sub queries and correlated sub queries to retrieve data from the database.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
Translating business requirements into technical design specifications
Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2012
Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models
Created access for users to use the SSRS reports on the web and across mobile devices.
Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column
Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints
Designed and developed Tabular Model Cubes using SSAS 2012. Developed calculated columns and measures using DAX
Used Microsoft Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets
Created/Updated database objects like tables, views, stored procedures, function, packages.
Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
Involved in table and index partitioning for performance and manageability.
Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
Used SQL Server Profiler to trace the slow running queries and the server activity.
Automated and enhanced daily administrative tasks including database backup and recovery.
Created different views using SSRS that were published the business stake holders for analysis and customization using filters and actions.
Created Bar Charts which is complied with data sets and added trend lines and forecasting on future projections.
Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
Tools and Technologies: MS SQL Server 2012, SSIS, SSAS, SSRS Oracle11g, Visual Studio 2008, VSS 2005, Erwin 7.3, Windows NT/2003, Microsoft .NET framework 3.5, C#, ASP.NET, XML.
Contact this candidate