We provide IT Staff Augmentation Services!

Sr. Sql Bi Developer Resume

Berkeley, CA

SUMMARY:

  • Specialized SQL BI Developer with 6 years of experience in reporting with strong skills in SQL development, SQL Server, data warehousing in domains such as finance, logistics, insurance, and retail.
  • Experience in all phases of software development life cycle (SDLC) from requirements gathering, design, development and support of applications.
  • Experience with waterfall and Agile development methodologies and worked with customers in prioritization and planning sprints.
  • Strong experience in requirement analysis, physical and logical design development, resource planning, coding, debugging, testing, support and maintenance of business intelligence applications using SQL Server 2008/2012/2014/2016 , DTS, SQL Server Integration, Analysis and Reporting Services
  • Experience working with business users closely in gathering business requirements and giving user training on reports and new features launched.
  • Worked on ingestion framework, migration from Teradata to Hadoop with hive and MySQL.
  • Expert in database activities like database creation and maintenance, performance monitoring, tuning and troubleshooting, disaster recovery, backup/restore and migration.
  • Strong experience with SQL Server and T - SQL in constructing joins, user defined functions, stored procedures, triggers, views, indexes, user profiles and data integrity.
  • Involved in multiple data migration projects.
  • Experience in enhancing and deploying the SSIS packages from development server to production server.
  • Strong understanding of Data Warehouse principles using Fact Tables, Dimension Tables, Star/Snowflake Schema modeling and data modeling
  • Experience in designing, developing and deploying of Cubes and creating role-based security and row level security in cubes using SSAS.
  • Good Knowledge in design partitions and aggregations for performance tuning in SSAS.
  • Experience in developing reports using Excel and SSRS, Tableau.
  • Experience in cloud computing platform like SQL Azure, involved in data migration from SQL on- Premise environment to cloud computing platform.
  • Excellent in interacting with Clients, Business Analysts and developers.
  • Expertise in Data Blending concepts in Tableau Desktop, Power BI and creating/Publishing interactive dashboards.
  • Strong mentoring skills, capable of leading and motivating individuals to maximize productivity while fostering cohesive teams in a virtual environment.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2016/2014/2012

Programming Languages: T-SQL, C, HTML, Core Java, HIVE

ETL Tools: SSIS, Import/Export Wizard, DTS

Reporting Rules: Tableau, SSRS, Excel Reporting, Power BI

Analysis Tools: SSAS

Cloud Computing Platform: SQL Azure, AWS

Methodologies: Waterfall, Agile, Software Development Life Cycle

Operating Systems: Windows, Linux

Office Applications / Workflow Tools: MS Outlook, Visio, MS Project, MS-Excel, Power Pivot 2010, MS-Access

Configuration Tools: Team Foundation Server (TFS), GIT HUB

Data Base Monitoring Tools: SQL Profiler (SQL Server), SQL Redgate Products

PROFESSIONAL EXPERIENCE:

Confidential, Berkeley, CA

Sr. SQL BI Developer

Responsibilities:

  • Worked closely with business and involved in gathering the user requirements, Analysis, Design, functional & technical specification and wrote SQL scripts for data transfer/migration.
  • Extensively worked in analyzing SQL Stored Procedures and enhancing them accordingly.
  • Responsible for writing and modifying store procedures, functions, packages and database triggers
  • Created indexes, tables and sequences as per the business requirement and views to maintain data privacy.
  • Worked with IT operations teams to troubleshoot ETL issues and optimize the database server environments.
  • Designing, Coding, Testing, scheduling and implementing project using SSIS.
  • Used SQL profiler to identify slow running queries and optimized them foe better performance.
  • Updated data in tables based on the user requirement using temp tables, with CTE ‘sand joins.
  • Worked with business analysts to provide solutions for technical difficulties and business-related issues.
  • Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions
  • Point of contact for all the production issues (both database and front end/application.)
  • Created database links and accessed the data through SQL statements
  • Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse
  • Analyzed the requirements and framed the business logic for the ETL process.
  • Responsible for scheduled job maintenance and trouble shooting.
  • Created SQL jobs and monitored them often and updated business with the successful migrations.
  • Used Scrum Development Methodology.

Environment: SQL Server 2012, 2014, 2016, SSIS, Tableau, Power BI, HIVE

Confidential, San Bruno, CA

SQL/MSBI Developer

Responsibilities:

  • Engaged in new development as well as support maintenance or enhancement of existing applications. Projects will entail complex business requirements and processes.
  • Worked closely with business and involved in gathering the user requirements, Analysis, Design, functional & technical specification and wrote SSIS scripts for data transfer.
  • Extensively worked in analyzing SQL Stored Procedures.
  • Updated data in tables based on the user requirement using temp tables and joins.
  • Extract data from Terada and create data sources using Data warehousing concepts.
  • Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Preparing workbooks using calculations, parameters in Tableau.
  • Understanding of relational database structures, theories, principles, and practices.
  • The ability to interact professionally with a diverse group, including executives, managers, and LOB.
  • Modified SSIS package for manipulating the data Source coming from As400 to Back Office system.
  • Worked extensively in migrating data from various sources such as Excel, Oracle, MS Access, MySQL, OLE DB, and flat files to different destinations using SSIS.
  • Upgraded SSIS packages from version and created indexes on tables if needed.

Environment: SQL Server 2008, 2012, 2014, SQL Server Integration Services, Hadoop technologies.

Confidential, San Rafael, CA

SQL / ETL Developer

Responsibilities:

  • Worked closely with business analysts to provide solutions for business problems.
  • Gathered requirements, Analysis, Design, functional & technical specification and wrote SSIS scripts for data transfer.
  • Worked with business users to handle issues while refreshing the excel spreadsheets pointing to SSAS cubes.
  • Handled offshore team with daily sync up call with onsite providing detailed explanation about business and individual tasks on JIRA board.
  • Point of contact for all the production issues.
  • Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculated the metrics that were revealed in the functional analysis.
  • Coordinated with Business Users to understand business needs and implement the same into a SSAS Cube as a team.
  • Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
  • Extensively worked in analyzing Stored Procedures.
  • Updated data in tables based on the user requirement using temp tables and joins.
  • Worked closely with business and involved in gathering the user requirements
  • Created database links and accessed the data through SQL statements
  • Analyzed the requirements and framed the business logic for the ETL process
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations
  • Created package to transfer data between OLTP and OLAP databases
  • Designed Cubes with star schema using SSAS
  • Created various complex reports and manage them using SQL Server Reporting Services (SSRS)
  • Responsible for scheduled job maintenance and trouble shooting the production issues.

Environment: SQL Server 2012, 2014, SSIS, SSAS

Confidential

Associate Software Engineer/ Data Analyst

Responsibilities:

  • Designed, developed and deployed data movements using TSQL, Stored Procedures and SQL Server Integration Services.
  • Collaborated with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
  • Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
  • Worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
  • Created Reports Using functionality like Drill Down, Cross tab, Master and Detail reports.
  • Created Alerts for complex Reports and prepare custom Hierarchy.
  • Extensively used calculations, Sorting, Rank, Drill down, Drill thru, Slice and Dice.
  • Created Complex/ad-hoc reports using SQL Server Reporting Services.
  • Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
  • Formatted the reports using the Global variables and expressions.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
  • Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.

Environment: SQL Server 2012, SSRS, Crystal reports, MS Access

Hire Now