We provide IT Staff Augmentation Services!

Bi/sql Developer Resume

Secaucus, NJ

OBJECTIVE:

Seeking a position as SQL/MSBI Developer where I can effectively utilize my expertise and efficiency

SUMMARY:

  • Over 6+ years of experience in RDBMS technologies like SQL Server, MySQL and PL/SQL
  • Worked with end users and business analysts to understand business requirements, recommended technical solutions and documented functional requirements
  • Experience in Extracting, Transforming and Loading (ETL) data flow among different source and destination files formats
  • Experienced in SQL Server 2008, 2012 and 2014
  • Experienced with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting business requirements, Design, Development & implementation
  • Worked with T-SQL, DDL and DML Scripts, Joins and established relationships between tables using Primary Keys and Foreign Keys
  • Experienced in MSBI using Business Intelligence Development Studio (BIDS) and SQL Server Development Tools (SSDT) to create packages SSIS and SSRS
  • Strong in Analyzing Business Specifications and in developing appropriate Test Plans, Test Scripts and Test Cases based on customized needs
  • Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger
  • Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation
  • Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision
  • An excellent Inter-personal skill with ability to develop creative solutions for challenging client needs using design pattern

SKILLS:

  • Proactive with decent written and spoken skills
  • Interacting with different technical meet up groups
  • Superior documentation and organization skills
  • Self-motivated and detail-oriented
  • Expert in documentation, designing and developing database

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, TSQL

Data Modeling: MS Visio, Visual Paradigm

RDBMS Servers: MS SQL Server 2014/2012/2008/2005/ , Oracle 11g/10g/9i/8i, MS Access, MySQL

BI Tools: SQL Server Integration Services (SSIS), DTS Import/Export, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tableau, Crystal Repot

IT Service Management Software: JIRA, SharePoint, Team Foundation Server

Operating Systems: UNIX (Solaris 8/2.x, Red Hat Linux 7.x/6.x), Windows NT.

Web Technology: HTML, XML, JSON

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NJ

BI/SQL Developer

Responsibilities:

  • Used SQL Server Reporting Services (SSRS) for all reporting purposes, creation of new and modification of existing reports
  • Planned, Defined and Designed data based on business requirement and provided documentation
  • Gathered data and documenting it for further reference and designed Database using Erwin data modeler
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access
  • Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
  • Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS
  • Developed several SSRS management pipeline reports, which helped the management to process the pipeline loans effectively
  • Generated parameterized reports, sub reports, tabular reports using SSRS 2012
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012
  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio
  • Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Multi-valued parameters and also understanding of the tablix control and Dashboard reporting, Share Point with Power View tool etc
  • Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision

Confidential, San Francisco, CA

BI/SQL Developer

Responsibilities:

  • Actively participated in interaction with users, team lead, DBA and technical manager to fully understand the requirements of the system
  • Scheduled Complex Stored Procedures using SQL Server Agent
  • Monitored and modified Performance using execution plans and Index tuning
  • Involved in project planning, also schedule for database module with project managers
  • Responsible for writing T-SQL code for creating cursor and handling data validations
  • Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for the project
  • Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio
  • Created SSIS Packages user data from the Flat files on monthly and weekly basis
  • Created Database objects views, and functions and developing procedures for implementing application functionality at the database side for performance improvement
  • Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
  • Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
  • Created datasets, data source and involved in deploying the reports in to the report server
  • Created reports using SQL Server 20012(SSRS) and integrated into the web front end
  • Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance

Confidential, Burlingame, CA

SQL Database Developer

Responsibilities:

  • Writing queries for retrieving data from the database
  • Developed solutions for ETL systems, data models, and reports
  • Experience in writing complex stored procedures, user defined functions, triggers, views and indexes
  • Efficient in creating joins and sub-queries for complex queries involving multiple tables
  • Worked with different teams such as DBAs and Data owners during the business rules and data validation process
  • Experienced in creating SSIS package to extract and load data from the different sources and destination
  • Worked on creating ad hoc reports creating and running SQL queries and providing reports out to different departments in Excel and Access
  • Gathered requirements to identify and create database objects such as tables, views, triggers and indexes
  • Involved in Normalization of the database and bringing it to 3NF
  • Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity
  • Created ER diagrams using Visio
  • Created Views to enforce security and data customization
  • Created Non-Clustered indexes to improve query performance and query optimization
  • Involved in the performance tuning and optimization of T-SQL queries
  • Created Stored Procedures for commonly used complex queries involving join and union of multiple tables
  • Developed user requested reports using Crystal Reports and Excel

Confidential, San Francisco, CA

Jr. SQL Developer

Responsibilities:

  • Extensively worked on querying and debugging SQL scripts including DDL, DML & TCL commands
  • Created stored procedures, table valued functions, triggers and views using base tables
  • Worked on transactional queries and prevented dirty reads, non-repeatable reads, phantom reads and deadlocks using isolation levels
  • Used SQL server profiler for performance tuning of queries for better execution plans
  • Performed database integrity checks using DB utilities and maintenance plan configuration wizard
  • Used DB and ALTER statements to check and manage database consistency, index fragmentation/rebuilding, statistics
  • Updated Error Logs and documented the resolutions
  • Moved files between the File Groups and partitioned the tables to improve the performance
  • Monitored SQL server performance using profiler to find performance
  • Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA)
  • Created and maintained SQL objects like Tables, Constraints; User defined Functions, Indexes, Views, Stored Procedures and SQL scripts, T-SQL queries for developer applications
  • Used SQL Indexes for improving query performance, lower storage and maintenance
  • Created Jobs for database maintenance Index fragmentation, database statistics
  • Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL joins and other statements for various applications
  • Performance tuning of the stored procedures user defined functions and long running queries

Hire Now