Sql/ Bi Developer Resume
Scottsdale, ArizonA
SUMMARY:
- Over than 6 years’ expertise in database design, analysis, development, and business intelligence application utilizing Microsoft SQL server, Azure SQL, MSBI (SSIS, SSAS, SSRS) Power BI, and Tableau within industries such as, Banking, Technology, Finance and healthcare .
TECHNICAL SKILLS:
Database: MS - SQL Server 2012/2008R2/2008/Azure SQL
T: SQL Programming, Dynamic SQL, C#.Net
Data Modeling: ER-win, MS Visio
BI Tools: Power BI, Power Pivot, Tableau
Integration Services (SSIS)
Analysis Services (SSAS, OLAP Cubes)
Reporting Services (SSRS, Report Builder)
Development Tools: BIDS, SSDT, SSMS
Source Control: Team Foundation Server (TFS)
Microsoft Azure: Cloud Services (PaaS & IaaS)PowerShell
Azure SQL Database (PaaS)Azure Storages (Blob, Tables, Queues)Backup/RecoveryAzure Data Factory
SDLC: Agile, Scrum, Waterfall, and Spiral
Collaboration Tools: SharePoint
PROFESSIONAL EXPERIENCE:
Confidential, Scottsdale, Arizona
SQL/ BI Developer
Technical Environment: SQL Server 2012, SSDT, SSIS, SSAS, SSRS, Azure SQL, Tableau, TFS, SharePoint, Power BI Desktop, Erwin.
Responsibilities:
- Collaborated with the project team and business users to gather business requirements.
- Defined multiple constraints in logical phase of the data modeling life cycle.
- Created Entity Relationship (ER) diagrams for the proposed database.
- Performed data modeling; designed and built relational databases.
- Wrote complex stored procedures for operations like data profiling, business logic, and to handle index fragmentation.
- Implemented error handling techniques such as try-catch blocks and other error functions in scripts and stored procedures.
- Optimized the performance of queries and procedures utilizing different approaches.
- Communicated and coordinated with clients to understand business needs and expectations from the ETL Process.
- Created ETL strategies to populate the data warehouse/data-mart with facts and dimensions.
- Designed dynamic SSIS Packages to transfer data across multiple platforms; validated and archived transferred data.
- Deployed SSIS packages to multiple environments utilizing project deployment model
- Designed and created OLAP cubes with dimensions and facts
- Created various cube objects such as KPI’s, perspectives and calculated members for better analysis.
- Assigned appropriate storage modes to different partitions in cubes to improve performance
- Delivered reports in different rendering formats utilizing standard and data driven subscriptions based on demand
- Created dash board reports utilizing the power BI tools such as Power View.
- Optimized report data sets to reduce the report generation time.
- Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
- Supported deployment process by checking in all DBOs with documentation to Team Foundation Server
Confidential, San Diego, CA
BI Developer
Technical Environment: SQL Server 2012, T-SQL, SSDT, SSIS, SSRS, ER Win, TFS
Responsibilities:
- Implemented database integrity per business requirement utilizing db constraints and triggers.
- Designed and optimized complex stored procedures to perform data profiling and auditing in the pre-staging database.
- Created stored procedures for index maintenance, profiling data, searching metadata, staging procedures, and reporting databases.
- Implemented error handling in SQL scripts and procedures utilizing try-catch statements, ‘throw’ and ‘raiserror’ functions.
- Implemented covering-indexes to optimize query performance.
- Implemented query performance by eliminating key and RID look up operators from the execution plan.
- Extracted and loaded data from multiple sources (Excel, CSV, flat files, SQL Server, Oracle) to the staging area.
- Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
- Deployed and configured SSIS packages to the production server with parameters in the SSISDB catalog.
- Created various SSRS reports such as drill down, drill through, and cascaded parameterized.
- Improved data visualization utilizing Tableau Desktop.
- Implanted report delivery with data-driven and standard subscriptions in SSRS.
- Collaborated with Team Foundation Server to update project documents, scripts, and packages.
Confidential, Kansas City, MO
MSBI Developer
Technical Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, SSIS, TFS, ER Win
Responsibilities:
- Coordinated with business users to clarify business requirements pertaining to the database application.
- Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
- Converted a complex business logic into SQL stored procedures and user-defined functions.
- Improved performance with index analyses on tables and clustered and non-clustered indexes.
- Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
- Created critical staging procedures to load data marts and report databases with multiple features.
- Implemented package optimization utilizing various types of concepts such as checkpoint, avoid transactions, avoid blocking transformation, delay validation etc.
- Generated Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports utilizing SSRS.
- Optimized the performance of reports by optimizing stored procedures and embedded them in reports as well as implemented caching methods for the same purpose.
- Implemented TFS (Team Foundation Server) for code check-in and check-out and manage different versions.
Confidential, Kansas City, MO
MSBI Developer
Technical Environment: SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SQL Profiler, MS Visual Studio, MS Excel
Responsibilities:
- Analyzed multiple user requirements and development specifications for OLAP applications in JAD meetings.
- Implemented multiple isolation levels with lock mechanisms to avoid deadlocks.
- Created functions to provide custom functionalities according to the requirements.
- Modified temporary tables, indexes, and lookup techniques to optimize stored procedures.
- Successfully transferred old data from various sources such as flat files, MS Access, and Excel into MS SQL Server 2008R2 utilizing SSIS.
- Enabled Checkpoints on already implemented transactions to optimize entire ETL strategy so as to start the package execution from latest point of failure.
- Created the design documents for the entire project including table structures and design logic of stored procedures, packages and reports.
Confidential, Kansas City, MO
Database Developer
Technical Environment: SQL Server 2008, BIDS, T-SQL, DTA, Flat File, Excel
Responsibilities:
- Documented database objects and SSIS packages.
- Tuned queries, assigned proper Indexes for better performance.
- Optimized Sql queries utilizing execution plan, indexes and batch processing.
- Implemented incremental load utilizing CDC and checksum/timestamp.
- Optimized poorly performing queries and procedures for optimal performance.
- Embedded complex queries and procedures in SSIS Packages based on business requirements.