PROFESSIONAL SUMMARY:

• Over 5 years of experience in Microsoft SQL Server and Business Intelligence development:
• Business Intelligence experience in Development, Client Analysis, Database Design, Reporting, and Presentation using SQL Server 2008R2/2012/2014, SSIS, SSAS and SSRS in an agile environment.
• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement Gathering, Design, Development, Implementation and Testing and Development experience.
• Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Involved in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key and Unique key) and Indexes
• Developed and Maintained Microsoft SSIS packages including database design, ETL and analysis integration to meet business requirements.
• Integration Service that can extract and transform data from a wide variety type of sources such as Flat files, OLEDB, Excel files and relational data sources, and load data to data warehouse databases.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created SSRS report projects in BI Visual studio and created, modified, and managed various report models with multiple objects, source fields and expressions.
• Generate a report, which a structured arrangement of information to answer business questions by presenting data in matrices, charts, tables, maps and such.
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T - SQL queries, user defined functions, stored procedures, and views.
• Wrote Complex SSRS Expressions and built the reports in Ad hoc Tool called Report Builder.
• Wrote SQL scripts and built reports in SSRS .
• Utilized derived tables, temporary tables and Common table Expressions in SQL
• Developed various types of interactive reports like drill down, drill through, gauges, pie chart, bar chart, sub-reports.
• Designed and developed data warehouse, data marts using multi-dimensional models - star schema,snow flake
• Implemented different slowly changing dimension methodologies to maintain and update historical data corresponding to

TECHNICAL SKILLS:

• SQL Server Tools.
• SQL Server Management Studio, Enterprise Manager, Query Analyzer
• Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services.
• RDBMS SQL Server 2008/2005, MS-Access VBA
• Methodologies Logical and Physical Database Design, Star Schema, Snow Flake Model, Database Design and Normalization.
• Excel manipulation of data including Pivot Tables, Index-Match and VBA macros

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

MSSQL/BI /SSRS Developer

Responsibilities:

• Used various transformations such as Derived Column, conditional split, fuzzy grouping, lookup
• Developed complex ETL Packages using SQL Server 2014/12 Integration Services to load data from various sources like SQL Server to Staging Database and then to Data Warehouse.
• Migrate a several of SSIS packages from 2008 to 2012, tested and deployed them to production
• Created Excel Services report and dashboards, set refresh schedule and appropriate security.
• Implemented Key Performance Indicator Objects, Actions, Hierarchies and Attribute Relationships for added functionality and better performance of SSAS Warehouse.
• Created database objects like tables, views, stored procedures, performance tune them to facilitate reporting
• Generate Reports like Sub report, drilldown, drilthrough also Tabular and Matrix reports in SSRS and also Publication Reports and worked on scheduling, maintaining history of reports.
• Gathered business requirement from users and involved in designing conceptual, logical and physical model of the relational databases and multi-dimensional cubes(OLTP and OLAP)

Confidential, Glendale, CA

MSSQL/ETL Developer

Responsibilities:

• Participate in sprint planning session to elicit requirement, design decisions and estimate effort required to complete a product backlog item (PBI) using agile scrum methodology.
• Generated daily, weekly and Monthly reports using SSRS 2014.
• Generate Reports like Sub report, drilldown also Tabular and Matrix reports in SSRS and also Publication Reports and worked on scheduling, maintaining history of reports.
• Created automated stored procedures for day end operations using SQL Server agent.
• Scheduled stored procedures and wrote a batch processes.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements
• Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Provided problem resolution, troubleshot issues in the database environment.
• Developed scripts to migrate data from multiple sources.
• Created databases, tables and fields for data entry, performing database capacity planning.
• Designed, added, maintained indexes, organized tables, recommended SQL changes to improve the performance of various processes for the export.
• Monitored and resolved deadlock issues within the database.
• Created packages with several Transformations in each Package making sure that the data is cleaned and confirmed before being sent to the Staging Area.
• Created complex SSIS packages to pull data from Excel and flat files to SQL server

Confidential, Los Angeles, CA

MSSQL/ETL Developer

Responsibilities:

• Used SQL Profiler to optimize queries and enhance the performance of database servers.
• Managed index, statistics and optimize queries by using execution plan for tuning the database.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Performed ETL operations using the SSIS and SQL.
• Created SSIS packages to import and export data from Excel, text files and various flat files.
• Developed various processes and automate it using T-SQL for exporting data to different systems.
• Deployed and Schedule SSIS Package for Production Support & Requirement from Client Side.
• Migrated data from SQL Server 2008 R2 to the SQL Server 2012 using SSIS as ETL tool.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.