Sql/bi Developer Resume
Jersey City, NJ
SUMMARY
- Microsoft SQL/BI/Azure professional wif over 6 years’ expertise in Data Warehouse and DataMart methodologies, including a comprehensive knowledge of OLTP/OLAP technologies.
- Experienced wif all phases of teh SDLC utilizing agile/scrum, waterfall, and spiral methodologies wifin various industries such as financial, insurance, real estate, and banking.
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
Programming Languages: Java, C/C++, MatLab 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 (Blobs, Tables, Queues) Backup/Recovery Azure Data Factory Azure Data Warehouse
SDLC: Agile, Scrum, Waterfall, and Spiral
Collaboration Tools: SharePoint 2013/2010
PROFESSIONAL EXPERIENCE
Confidential, Jersey City, NJ
SQL/BI Developer
Environment: SQL Server 2012, SSDT, Erwin, TSQL, SSIS, SSAS, SSRS, Azure SQL, Power BI, Tableau, TFS, SharePoint.
Responsibilities:
- Collaborated in gathering system specification requirements for teh project.
- Collaborated in creation/review of functional requirement specifications and supporting documents during data modeling process.
- Created complex stored procedures wif proper error handling, transactions and performance tuning features.
- Redesigned indexes to speed up query performance and utilized database engine tuning advisor for further suggestions.
- Created Triggers to enforce user defined integrity as per teh business logic.
- Created tables, views, stored procedures, functions, CTEs and indexes in support of various databases and ETL applications.
- Studied existing OLAP system(s) and created facts, dimensions and star schema representation for teh data mart and warehouse systems.
- Created staging database to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
- Designed teh end-to-end ETL process involving teh access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources.
- Developed complex mappings utilizing SSIS to transform and load teh data from various source systems such as Oracle, Excel and Flat files into teh SQL 2012 Server target staging database.
- Implemented various SSIS tasks such as conditional split, derived column for data scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
- Identified slowly changing transformation, to maintain historical data in data warehouse.
- Implemented Master/Child packages so only teh master package needs to be scheduled which will in turn trigger teh execution of other packages.
- Implemented debugging of packages using Breakpoints, Checkpoints, Event Handlers and Loggings.
- Configured data source & data source views, dimensions, cubes, measures, partitions, KPIs & MDX Queries utilizing SQL Server Analysis Services.
- Managed very large reports that return a large volume of records and optimized their performance utilizing techniques such as cascading parameters and filters.
- Designed several scorecards and dashboards utilizing Power Pivot and Tableau to display information needs by other departments and upper management.
- Deployed SSRS reports to teh reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
- Designed and developed standalone data migration applications to retrieve and populate data from Azure Table / BLOB storage to an on-premises SQL Server instance.
- Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve teh response times and reduce traffic to teh report server.
- Collaborated TFS (Team Foundation Server) for code check-in and check-out and manage different versions of complicated code and distribute them to different teams in teh organization.
Confidential, Minneapolis, MN
SQL/MSBI Developer
Environment: SQL Server 2012, T-SQL, SSDT, SSIS, SSRS, MS Excel, Erwin, TFS, MS Excel, SharePoint.
Responsibilities:
- Collaborated agile/scrum methodology in teh SDLC for teh implementation of teh project.
- Created database documentation for table and column dictionaries and other reference materials.
- Wrote T-SQL queries, stored procedures, UDFs and optimized their performance in support windows, web and front end applications.
- Interacted wif teh business users for ETL application enhancements by conducting JRD sessions as well as User Acceptance Testing to sample BI applications.
- Involved in teh design of data marts utilizing star schema and Kimball methodology.
- Managed teh entire ETL process involving teh extraction, analysis, transformation, loading and presentation of information to teh end users.
- Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS in staging database from MS Access, Flat Files and Excel.
- Implemented Type 1 and Type 2 Slowly Changing Dimensions for Incremental load.
- Filtered bad data from legacy system utilizing Derived column, Lookups, Fuzzy Lookups, and Conditional split.
- Incorporated error redirection during ETL Load in SSIS packages.
- Implemented teh master child package technique to manage big ETL Projects efficiently.
- Created report snapshots and caches to improve performance, deployment, scheduling of reports.
- Created drill down, drill through, cascaded, sub, and parameterized reports in SSRS by utilizing MOLAP and ROLAP environments.
- Optimized reports by modifying embedded queries and/or altering stored procedures.
- Created data factory utilizing pipeline and sync component in MS Azure environment.
- Rendered reports to several file formats such as PDF, Image, and Excel according to teh needs of management.
- Deployed multiple types of reports on Share Point 2010 and created dashboards.
Confidential, Boston, MA
SQL/BI Developer
Environment: SQL Server 2008R2, Transact-SQL, BIDS, SSIS, SSRS, SSAS, MDX, TFS, Erwin, TFS.
Responsibilities:
- Designed logical and physical model of teh database utilizing Erwin.
- Created complex SQL Stored Procedures, triggers and user defined functions to manage incoming data as well as to support existing applications.
- Supported advanced efficient data retrieval and manipulation by creating indexed view wif triggers.
- Successfully implemented indexes on tables and views for optimum performance tuning.
- Supported some business specific relationships, and advance constraints by embedding triggers on tables.
- Executed test cases that were used for validating teh converted system.
- Wrote, revised, and verified test cases that were used for future testing of teh software, ensuring that future releases maintained teh same level of quality, and ensuring quality consistency.
- Designed SSAS cubes and created attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
- Created jobs and alters to execute SSIS packages automatically as well for reporting services.
- Created different roles and users for reporting services; created jobs for subscriptions to deliver reports to higher authorities.
- Interacted wif business users and managers and gathered teh database needs of teh various business groups for reporting purposes.
- Redesigned various reports, chart reports (line and column), parameterized reports for performance analysis.
Confidential, Los Angeles, CA
BI Developer
Environment: SQL Server 2008R2, SSMS, SQL Profiler, SSRS, SSAS, SSRS, BIDS, Erwin, TFS.
Responsibilities:
- Created critical staging procedures for loading data marts and reporting databases wif proper error handling, transactions, and performance tuning features.
- Implemented transactions wif multiple isolation levels and locks technique to avoid dirty reads and deadlocks.
- Maintained indexes, created backups, and optimized query performance utilizing execution plan and parameter sniffing.
- Implemented performance tuning and optimizations on SSIS to improve issue resolutions in large-scale production environments.
- Generated reports utilizing SSRS and Excel wif power pivots; deployed reports wifin SharePoint integrated mode.
- Created dashboards, sub-reports, drilldown reports, summary reports, and matrix reports in SSRS.
- Implemented report delivery and backup schedules by configuring subscriptions and snapshots respectively.
Confidential, Plano, TX
SQL Developer
Environment: SQL Server 2008, BIDS, T-SQL, SSRS, Erwin
Responsibilities:
- Created SQL scripts to analyze historical data; extracted required data to support management decisions.
- Created complex stored procedures to perform incremental loads utilizing timestamp techniques.
- Successfully implemented indexes on tables and views for optimum performance tuning.
- Implemented error handing techniques (such as try catch and error functions) to create robust T-SQL code.
- Collaborated wif teh senior architect and DBA to develop data validation procedures.
- Optimized reports by optimizing teh embedded queries, or optimized teh stored procedures that generate them.
- Generated reports in SSRS wif advanced calculations; deployed reports on teh SharePoint server.
