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