SUMMARY:

• 8+ years of Experience in Analyzing, Designing and implementing end - to-end Business Intelligence solutions using SQL Server 2012/ 2008/ 2008 R2/2005 in Production, Staging and Development environments.
• Extensive experience in Software Development Life Cycle (Agile, Scrum, and RUP) methodologies for gathering business requirements.
• Experience in database design with T-SQL through conceptual Entity Relationship Diagrams and Erwin.
• Expertise in creating database objects such as Stored Procedures, Tables, Constraints, Indexes, Views, Indexed Views, and Triggers on SQL 2005/2008/2008 R2/2012
• Good experience in automating administrative tasks using SQL agent, event notifications, and scheduled maintenance plans according to Microsoft best practice.
• Performed ETL operation using SSIS.
• Has used most of the control flow and data flow tasks in SSIS.
• Experienced on setting up schedules for push and pull delivery methods for SSRS reports.
• Experience in creating report model deployment of report model.
• Designed drill down, parameterized reports, linked, and cascaded parameterized reports using SSRS 2005/2008.
• Experience using many of the SSIS transformations like Audit, Aggregate, Lookup, Fuzzy Lookup, Conditional Split, Derived Column, and Multicast.
• Expertise in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings.
• Experience in deploying and enhancing the SSIS Packages from development server to production server.
• Excellent experience designing, developing, testing and optimizing BI solutions with user experience in mind as well as organizational ROI.
• Experience in defining, developing and deploying Cubes using fact, dimension tables, identifying KPI’s and measures using MS SQL Server 2005/2008/R2 Analysis Services (SSAS).
• Experienced in writing MDX to create calculated member, named set, retrieve data from multi-dimensional Level
• Experience with reports such as Tabular, Matrix, Parameterized, Sub Reports, Drill Down/Drill Through reports from Relational databases and OLAP Cubes using Reporting Services.
• Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Utilized Report Manager to secure the reports with windows user groups and roles for individual reports and also reports folders.
• Administered Report execution based on Caching and Snapshot as well as managed report delivery using standard and data driven subscriptions.
• Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server.

TECHNICAL SKILLS:

• SQL Server 2008/2008 R2/2012
• Management Studio, Profiler, ER-Win
• BIDS/SSDT, SSIS/SSAS/SSRS
• Windows 2000, XP, 7
• SharePoint
• Data extraction, Transformation, and Loading
• T-SQL
• Oracle, Java, JavaScript, HTML, PHP
• Water Fall Model, Spiral Model, Agile, SCRUM, Tabular Model

PROFESSIONAL EXPERIENCE:

Confidential, Santa Ana, CA

SQL/OLTP Developer

• Interacted with business analysts and users by attending JAD sessions.
• Created technical design documents for Projects and Work Requests.
• Worked closely with QAs on various internal/production defects and break fixes.
• Provided BA support for production issue and user inquiries.
• Implemented complex business logic using database objects like stored procedures, functions, triggers, indexes with T-SQL.
• Developed SQL-based test and audit scripts to validate use cases and deployment.
• Wrote complex SQL queries using scalar and table variables which hold user inputs and perform business logic.
• Implemented error handling techniques including RAISERROR, system variables, and try-catch in SQL
• Optimized queries with execution plan analyses, DMV queries, SQL debugger, SQL Profiler, and DTA.
• Implemented Isolation levels, locks, and transactions to avoid blocks/deadlocks.
• Created Ad-hoc Reports per request as well as scheduled reports using UC4 automation tool.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created complex calculations in SSRS reports including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Designed different types of reports, managed reports such as drill Down, drill through, sub and linked reports using the SSRS.
• Created report models from cubes and data warehouse to create ad-hoc reports and chart reports using report builder.
• Worked on the development of dashboard reports for the Key Performance Indicators for the top management.
• Maintained version and source control utilizing team foundation server (TFS).

Environment: MS SQL Server 2012/R2, T-SQL, BIDS/SSDT, SSRS, Erwin, Access, TFS, Report Builder, Tabular Model, SharePoint, Profiler

Confidential

SQL/OLTP Developer

• Involved in analyzing business requirements that will facilitate the planning and the implementation phase.
• Created database objects like Procedures, Functions, Triggers, Indexes, and indexed Views using T-SQL to create complex scripts and batches.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Developed all the required stored procedures, user defined functions using T-SQL to feed reports for better latency performance.
• Created and deployed Tabular Model on Analysis Services for reporting Applications.
• Generated various reports like parameterized and linked reports from the cubes.
• Generated various reporting services RDLs using reporting services for Account Aggregation reports.
• Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly.
• Created Sub-Reports, Drilldown-Reports, Summary reports, parameterized reports, cascaded reports in SSRS by linking aggregate data to support summarized view as well as detailed view.
• Used different layout such as matrix, tabular, chart, Tablix to display data in a grid format, with layout possibilities ranging from simple tables to advanced matrices.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Designed performance reports with integration of EPM Dashboards into the SharePoint-based PerformancePoint
• Generated reports using SSRS and Power pivots that pull data from Tabular Model with expanded data capacity, advanced calculations and deployed them on SharePoint Server.
• Managed Team Foundation Server for check-in, check-out, and code collaboration between environments.

Environment: MS SQL Server 2012/R2, T-SQL, BIDS/SSDT, SSRS, Erwin, Access, TFS, Report Builder, SharePoint, Profiler

Confidential, San Bernardino, CA

SQL/OLTP Developer

• Gathered business requirements and worked in conjunction with the data warehouse architect on the development of logical data models.
• Used agile methodology in the SDLC for the implementation of the project and provided technical and functional support for the project team.
• Created database documentation for table and column dictionaries and other reference material.
• Developed Stored Procedures, Views, Triggers, XML and complex queries on SQL Server2008R2.
• Created constraints and triggers to ensure database consistency and to enforce business rules.
• Optimized existing queries with stored procedures, parameter sniffing, execution plans and statistics.
• Followed the regular reporting life cycle Analysis, Design, Development, Testing and Scheduling to develop User Interface Reports.
• Developed various data connections from data source to SSRS for report and dashboard development.
• Installed, Configured and managed Report Server and scheduled report delivery using Data Driven Subscriptions in SSRS.
• Used Power View to create various analytical reports depicting critical KPIs along with slicers and dicers enabling end-user to make filters.
• Worked on Team Foundation Server (TFS) to coordinate with the development team on the deliverables and for Version Control

Environment: MS SQL Server 2008R2, T-SQL, BIDS, SSRS, Erwin, Access, TFS, Visual Studio

Confidential, Long Beach, CA

SQL/Reports Developer

• Participated in JAD sessions with users and business clients to gather business requirements and implemented effective Data Modeling and ETL design for reporting needs.
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server 2008R2.
• Created complex SQL statements with joins, sub queries, and correlated sub queries.
• Created complex stored procedures which read data from multiple sources in multiple databases/servers.
• Improved performance with index analyses on tables and clustered and non-clustered indexes.
• Optimized stored procedures with SQL profiler to improve report latency and accelerate delivery access.
• Developed a number of reports using Report designer of SSRS 2008R2 like linked reports, drill through reports, sub reports and parameterized reports.
• Created ad hoc reports to validate the information inserted to the warehouse after refreshing it.
• Performed functional and regression validation on SSRS reports which implements drill down/drill up, Sub reports and validated the Security on SSRS reports.
• Scheduled and delivered on-demand reports for business analysis using SQL Server Reporting Services.
• Created various data driven subscriptions on a monthly and a quarterly basis for different reports based on requirements.
• Created report models from cubes as well as relational data warehouse to create ad-hoc reports and chart reports.
• Reports were deployed to dashboards report center producing different summary results based on user view and role membership.
• Collaborated with team members on project updates by checking-in and checking-out on TFS.

Environment: MS SQL Server 2008/R2, T-SQL, SSMS, BIDS, SSIS, SSRS, Erwin, Access, Windows Server

Confidential, Los Angeles, CA

SQL Developer

• Interacted with business users and managers and gathered the database needs of the various business groups for reporting purposes.
• Involved in creating logical and physical model of the database using ER-win, MS SQL Server 2008.
• Created complex SQL Stored Procedures, Triggers and User Defined Functions to manage incoming data as well as to support existing applications.
• Created different roles and users for reporting services. Also created jobs for subscriptions to deliver reports to higher authorities.
• Involved in designing of shift based reports, chart reports (line and column), parameterized reports for performance analysis.
• Set up report delivery schedules and report back up schedules by configuring subscriptions and snap shot respectively.
• Involved in creating job for database backup and recovery as well execution for stored procedures related to fragmentation of index.

Environment: MS SQL Server 2008/R2, SSMS, BIDS, SSIS, SSRS, DTA, Erwin, Windows Server

Confidential, Irvine, CA

SQL Developer

• Created Technical design specification documents based on the functional design documents and the physical data model.
• Worked on stored procedures and complex queries for achieving the business logic and reporting.
• Analyzed the historical data and extracted required data to support the management decisions.
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server 2005/08.
• Created various DB objects like views, UDF’s, stored procedures, cursors, indexes etc. for achieving desired functionality and performance.
• Responsible for developing ETL data mapping documents as well as data dictionaries.
• Imported data from MS Access, MS Excel and Text Files to SQL server 2005/08 using SSIS.
• Involved in unit testing and created test cases for the database scripting and ETL processes.
• Designed cubes from relational data warehouses and then created the KPI for the front end team.
• Created linked reports, sub reports, parameterized reports using SQL Server Reporting Services (SSRS).
• Implemented report models from cubes and data warehouse for creating ad-hoc reports using Report Builder.
• Optimized report performance by tuning underlying stored procedures and by using report snapshots and cache for better performance.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.

Environment: MS SQL Server 2008/05, T-SQL, BIDS, SSIS, SSRS, Erwin, Access, SSMS, SQL Profiler