Livecareer-Resume
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Summary
  • Around 4 years of experience as a SQL Server Developer and BI Developer (SSIS/Azure Analysis Services /SSRS/Power BI). Worked in various business domains like Retail, Banking, and Healthcare.
  • Experience in Analysis, Design, Development, Testing and Implementation of data, reporting and analytic solutions.
  • Sound knowledge in Relational and Multi-Dimensional databases, Data Migration, System & Data Integration, Reporting, Analytics and Data Management.
  • Experienced in developing, implementing, documenting and maintaining the data warehouse extracts, transformations and ETL process in various industries like Financial, Health Care, Retail etc.
  • Extensive professional experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications.
  • Expert in creating and using Stored Procedures, Views and User Defined Functions.
  • Good in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Used TFS for bug tracking and bug fixing.
  • Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
  • Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin.
  • Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Skills
  • Databases: SQL Server (2012 R2/2017), Oracle 11g, Azure DW, Azure Analysis Services.
  • Database Tools: SQL Server Management Studio 2012/2017, SQL Server Data Tools
  • Development Skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI, Alteryx, Tableau, Microsoft Azure
  • Languages: VB.net, C#, SQL, PL/SQL, HTML
  • ETL Tools: SSIS (SQL Server Integration Services), Informatica, COMOS, Kettle
  • Reporting Packages: SQL Server Reporting Services, Power BI, Tableau, MS Excel.
  • Tools/Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall, VB.net, Logging, SQL PLUS, Microsoft SQL Server
Education and Training
Northwestern Polytechnic University San Francisco, CA, Expected in 12/2016 Master of Science : computer science - GPA :
SCSVMV University Chennai, Expected in 05/2015 Bachelor of Science : Electronics and Communications - GPA :
Experience
University Hospitals - SQL/SSIS/SSRS/POWER BI Developer
City, STATE, 01/2019 - Current
  • Participated in full application development lifecycle projects including design, development, unit testing, functional testing, deployment and ongoing support for Clinical Relationship Management and other business applications running on Microsoft platform to help in application to store patient data that is highly confidential and encrypted.
  • Develop requirements and specifications in coordination with Database Administration team and UH (University Hospitals) Architects for data marts and data warehouses to support clinical and business analytics.
  • Gather appropriate specifications for data collection and transformation requirements and build report prototypes rapidly and accurately.
  • Writes data retrieval programs to import, extract, transfer, and load (ETL) data from heterogeneous data sources throughout the organization to support ad hoc reporting.
  • Designs, develops and supports self-service reporting options (i.e.
  • Building tabular data models).
  • Work with management, strategic planning & analysis staff and end-users to create and manage complex workflow rules, data validation, and triggers and create automate workflows.
  • Proactively identifies and addresses scalability and performance bottlenecks to support data volumes.
  • Create functional and technical documentation including "as-built" documents, dashboard design specifications, operating manuals, release notes and security requirements for reports created and maintained.
  • Update documentation on an annual basis or when changes occur.
  • Utilize SSRS to develop various dashboards and reports.
  • Utilize SSIS to automate report generation.
  • Configured SSIS jobs to automate data migration and integration.
  • Create and document requirements by working together with those involved in the development of program enhancements and changes including program staff, programmers, strategic planning and analysis staff and/or outside consultants as needed.
  • Write documentation and class designs for various architectures used for building SSIS components.
  • Assist with the testing process, which includes devising test plans, establishing protocols, and configuring appropriate testing environments.
  • Keep abreast of new Microsoft features and functionality and provides recommendations for process improvements.
  • Assist with providing technical support to end users.
  • Participate in the development of technical documentation of existing and future applications.
  • Perform quality assurance testing of reports and dashboards and facilitate user acceptance testing (UAT) sessions.
  • Ensure quality of the reports prior to releasing to production.
  • Checking the code into TFS (Store Procedures, Views, Tables, Schema) for the deployment process for the production environment.
  • Designed and implemented SSAS Tabular Cube as the analytic layer.
  • And Used DAX scripting to access data from Tabular Model.
  • Support multiple multi-faceted development initiatives utilizing Microsoft technologies.
  • Tools: Microsoft SQL Server 2012/2017, T-SQL, SQL Server Integration Services 2017(SSIS), SQL Reporting Services 2017 (SSRS), Microsoft Azure, Power BI 2019, Alteryx 2019, SQL Server Analysis services 2017 (SSAS), Crystals Reports 2011, Microsoft Excel 2016.
Williams-Sonoma, Inc - SSIS/SSRS Power BI Developer
City, STATE, 08/2017 - 12/2018
  • Installed SQL Server 2012 on Development and Production Servers, Setting up databases, users, roles and permissions.
  • Involved in gathering the user requirements.
  • Developed reports using Microsoft Power BI (Desktop, Service, Mobile).
  • Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.
  • Used multiple transformations provided by SSIS such as Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all, etc.
  • Performed error handling in SSIS using Event Handling and logging.
  • Developed calculated columns and measures using DAX in Power BI.
  • Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
  • Worked on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
  • Used T-SQL queries to insert the complete file information and layout to MDF tables.
  • Experience in writing T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins for Data Integrity and normalization.
  • Hands-on experience working with issues relating Transactional replication.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Provided visual/graphic analysis based on data content.
  • Developed and maintained multiple Power BI dashboards/reports and content packs.
  • Monitor database performance and analyze issues, primarily with Microsoft SQL Server 2012/2014.
  • Customized columns and tables utilizing Named calculations and Named queries in SSAS.
  • Tools: Microsoft SQL Server 2012/2014, T-SQL, Agile Methodology, SQL Server Integration Services 2012(SSIS), SQL Reporting Services 2012 (SSRS), Microsoft Azure, MYSQL Workbench, SQL Server Analysis services 2012 (SSAS), Crystals Reports 2011, Microsoft Excel 2016.
Bank Of West - SQL Server BI Developer
City, STATE, 05/2016 - 08/2017
  • Created SSIS package to load data from Flat Files and SQL Server 2008R2 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Modified the existing SSIS packages to meet the changes specified by the users.
  • Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS -2012.
  • Generated Sub-Reports, Conditional, Drilldown reports, Drill through reports and parameterized reports using SSRS 2012.
  • Created reports to retrieve data using stored procedures that accepts parameters.
  • Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
  • Responsible for Monitoring and Tuning Report performance.
  • Modified numerous reports/stored procedures that were not performing properly (slow response time, inconsistent results, poor format of the actual report).
  • Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in memory in both tableau and excel.
  • Involved in creating views, stored procedures and custom SQL queries to import data from SQL server to Tableau.
  • Reviewed SQL queries and edited inner, left, right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
  • Developed storytelling dashboards in tableau desktop and published them on to tableau server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, needed information.
  • Created various database object like stored procedures, functions, tables, views.
  • Involved creation of extended dimension modeling tables like snowflake for OBIEE.
  • Configured the report viewing security for various users at various levels using Report Manager.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/ SQL Developer and SQL.
  • Plus.
  • Scheduled report and exported in PDF format.
  • Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
  • Provided documentation for all kinds of reports and SSIS packages.
  • Designed and implemented stored procedures and Triggers for automating tasks.
  • Tools: MS SQL Server 2012/2008, SSIS, T-SQL, PL/SQL, SSRS, BIDS, Tableau, VSS, SQL Profiler, Database Engine Tuning Advisor, DTS, VB script, Erwin v7.3.
Activities and Honors
Additional Information
  • Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager. Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in memory in both tableau and excel. Integration of SSRS Reports using various web parts into SharePoint and various delivery mechanisms. Experience in working on version control systems like Subversion, and GIT. Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, SQL Server, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS. Involved in performance tuning for tableau Dashboards. Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc. Created different visualizations (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements. Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent. Involved in Query Optimization and Performance Tuning using execution plans SQL Profiler and Index Tuning Wizard. Created data source views, dimensions, measures and defined measure group relationships.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

75Average

resume Strength

  • Length
  • Measurable Results
  • Personalization
  • Target Job

Resume Overview

School Attended

  • Northwestern Polytechnic University
  • SCSVMV University

Job Titles Held:

  • SQL/SSIS/SSRS/POWER BI Developer
  • SSIS/SSRS Power BI Developer
  • SQL Server BI Developer

Degrees

  • Master of Science
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: