SUMMARY

• Over 7 years of IT experience in SQL development, requirements gathering, analysis, configuration, deployment, and administration of enterprise databases and BI applications.
• Highly - proficient with MS SQL Server 2014/2012/2008 R2/2008 and BI stack (SSIS/SSAS/SSRS) within multiple industries such as healthcare, finance, insurance, and technology.

TECHNICAL SKILLS

SDLC: Agile, Scrum, Waterfall, and Spiral

Databases: MS-SQL Server 2008, 2008R2, 2012,2014 T-SQL Programming, Dynamic SQL

Data Modeling: ER-win, MS Visio

Business Intelligence Tools: Power BI

Collaboration Tools: SharePoint

Integration Services: SSIS

Analysis Services: SSAS, OLAP Cubes

Reporting Services: SSRS, Report Builder

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia PA

SSRS Analyst

Environment: SQL Server 2012/2014, T-SQL, SSMS, MS Excel, Erwin, SSRS, SharePoint, TFS, DTA, SQL Profiler.

Responsibilities:

• Gathered business requirements for facilitating planning and implementation phases of a data warehouse.
• Collaborated with other team members for creating reports, understanding the system and Domain specific knowledge.
• Designed system requirement gathering documents based on extensive JRD and JAD sessions.
• Analyze multiple user requirements and develop specifications for database applications.
• Modified existing databases with tables and relationships to support the online system.
• Utilized Joins and sub-queries for complex queries involving multiple tables.
• Analyzed and optimized database by creating multiple clustered, non-clustered indexes and indexed views.
• Utilized try-catch blocks, raiserror for implementing error handling options in procedures and scripts.
• Implemented T-SQL queries for populating data sets and use data-sources while designing reports utilizing SSRS.
• Utilized SSRS and Excel Spreadsheet with Power pivots for designing various SSRS reports such as drill through, drill down, linked, and parameterized reports.
• Solved Incidents/problems of the already existing reports and maintained the status of the report.
• Designed various ad hoc reports for different department with in deadline time.
• Analyzed and optimized performance utilizing techniques such as cascading parameters and filters in SSRS.
• Designed Infusion, Disruption, Claims, Prescription and Medical, Prescription, Dental and Vision Claims and Census reports as per business requirement.
• Designed reports in SSRS with a multitude of features such as conditional formatting, actions, and interactive sorting.
• Involved in implementing TFS for BI application and SQL code source control.

Confidential

SSAS/SSRS Developer

Environment: SQL Server 2012/2014, T-SQL, SSMS, MS Excel, Erwin, MDX, DAX, SSAS, SSRS, SharePoint, Power BI, Power View, TFS, DTA, SQL Profiler

Responsibilities:

• Collaborated with the business analyst and stakeholders to gather requirements and cross-functional implications.
• Performed GAP analyses of business rules, business/system flows, user administration, and requirements.
• Ensured all artifacts were properly implemented in accordance with corporate SDLC policies and guidelines.
• Worked as a liaison between security analysts, subject matter experts, management, and IT teams to improve processes.
• Developed functional/technical specifications such as business scope documents and high level design documents.
• Managed SSAS cubes to facilitate the reporting of the business based on historical and current data.
• Created complex calculated members in SSAS cubes to boost query performance utilizing MDX.
• Created hierarchies and aggregations with DAX in SSAS tabular models.
• Optimized cubes utilizing the aggregation wizard and usage-based optimization.
• Created visually-rich dashboards utilizing Power BI, delivering actionable insights for strategic decision-making.
• Improved data visualization on reports utilizing power pivot, power view, and performance point services.
• Generated reports utilizing SSRS and Excel Spreadsheets with Power pivots and Power View and deployed them in SharePoint Server.
• Identified and defined datasets for report generation and added report parameters.
• Optimized performance utilizing techniques such as cascading parameters and filters.
• Developed SSRS reports such as drill through, drill down, linked, and parameterized reports.
• Generated SSRS reports from relational databases, the data warehouse, and OLAP cubes.
• Created analytical reports and dashboards with Power View to identify critical KPIs.
• Deployed SSRS reports to the reporting server and assisted with troubleshooting deployment problems.

Confidential, San Diego, CA

MS SQL/SSRS Developer

Environment: Microsoft SQL Server 2008R2, BIDS, SSMS, T-SQL, MDX, DAX, SSRS, SSAS, ER-Win, Power Pivot, SharePoint, TFS, DTA

Responsibilities:

• Organized JRD sessions to collaborate with clients, acquiring business needs and expectations.
• Interfaced with business users to prepare and update business process requirements for new healthcare tools.
• Created and revised the business requirement document (BRD) and functional requirement document (FRD).
• Analyzed business requirements, technical designs, and associated documentation.
• Implemented logical and physical data modeling with ER-win tool.
• Created clustered and non-clustered indexes on tables to improve performance while fetching data.
• Created Tabular models to create ad-hoc reports and customized column aggregations by writing DAX.
• Developed user interface reports utilizing reporting life cycle (authoring, managing, delivering).
• Designed and deployed reports with drill down, drill through, and drop down menu options.
• Created interactivedashboardsfrom various reporting components utilizing Excel Power BI.
• Utilized dashboard designer on SharePoint server to build user interactive dashboards.
• Customized score cards, KPI’s, reports (Performance Point Services) content on SharePoint.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Developed dashboards utilizing Tableau functionality such as sets, filter, parameters, and groups.
• Scheduled and delivered on-demand reports for business analysis utilizing SQL Server Reporting Services.
• Scheduled reports utilizing SSRS to generate status reports on a daily, weekly, monthly, and quarterly basis.
• Implemented Power BI to create rich dashboards for analytical purposes and benchmarking company growth.
• Performed what-if analyses with Excel, power pivot reports, and drill through dashboards.

Confidential, Chevy Chase, MD

SQL SSRS Developer

Environment: MS SQL Server, BIDS, SSAS, SSRS, Erwin, SQL Profiler, SQL Debugger, SharePoint, Power Pivot, TFS, Excel, Windows Server

Responsibilities:

• Performed all tasks pertaining to the Agile Software development life cycle (SDLC).
• Collaborated with clients to acquire information for the development of business objects and system requirements.
• Collaborated with business analysts and end-clients for the planning and implementation phases of the data mart.
• Implemented normalization to avoid data redundancy and remove insertion, deletion, and update anomalies.
• Implemented complex business logics with SQL server objects such as stored procedures, functions, and views.
• Created complex stored procedures for data profiling, data manipulation, and report generation in TSQL.
• Optimized databases with features such as indexes, partitions, and stored procedures.
• Created aggregations and user defined hierarchies on cubes in SSAS.
• Createdparameterized, cross-tab,drill-down,and summary reports utilizing SSRS.
• Generated daily, weekly, monthly, and quarterly status reports.
• Deployed SSRS reports on company’s SharePoint server utilizing SharePoint integrated mode.
• Created analytical dashboards depicting critical KPIs with divisions utilizing Power Pivot.
• Created interactive dashboards with parameters, actions, and data visualizations withPower Pivot.
• Implemented subscriptions in SSRS to schedule reports to multiple users in multiple formats.

Confidential, Durham, NC

SQL BI Reports Developer

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSAS, SSRS, Query Analyzer, T-SQL, Excel, Visio, DTA, SQL Profiler.

Responsibilities:

• Collaborated in JAD sessions to analyze and design the BRD and functional requirement specification document.
• Conducted JAD Sessions pertaining to the application; discussing business requirements, open issues, and change requests.
• Conducted GAP analyses, user acceptance testing (UAT), and system integration testing (SIT), and SWOT analyses.
• Developed and optimized database objects (tables, stored procedures, triggers, UDFs, views, and cursors).
• Implemented indexes on tables and views to improve performance.
• Installed, configured, secured, maintained, and restored SSRS on Windows Server.
• Generated daily, weekly, and monthly reports to managers and clients.
• Managed role-based security to reports and reporting resources.
• Responsible for back up and restoration of SQL Reporting Service.
• Created schedules for report deliveries to e-mails and shared directories.
• Create analytical reports depicting critical KPIs and filters with Power Pivot.
• Worked on Team Foundation Server (TFS) to coordinate with the development team on the deliverables.

Confidential, Boston, MA

SQL Server Developer

Environment: SQL Server 2008/05, SSIS, SSAS, SSRS, SSMS, T-SQL, Windows Server, SQL Profiler, DTA.

Responsibilities:

• Tracked and maintained stakeholder requests and changes with a requirements traceability matrix (RTM).
• Implemented agile and scrum methodologies in the SDLC for the implementation of the project.
• Collaborated with the database architect to modify physical and logical data models.
• Designed standards for database tables, columns, procedures, and views.
• Implemented system and user-defined functions to enhance the functionality of T-SQL code.
• Created the data mart with the identification of multiple dimensions and facts in the dimensional model.
• Developed ETL data mapping documents and data dictionaries.
• Created linked, sub, and parameterized reports with SSRS.