SUMMARY:

• Around 6 years of strong experience with demonstrated success in the Database Design, development and deployment of large - scale enterprise applications and Networking Services.
• Expert in MS SQL Server 2012/2008r2/2008/2005 suite of products like SSRS, SSAS, and SSIS.
• Expertise in providing Enterprise Reporting solutions using SSRS 2012/2008r2/2005
• Strong Experience in the design, development, configuration, testing, deployment, support and/or maintenance of new applications and SQL Server Reporting Services.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2005/2008/2008 r2
• Analyze report, script and stored procedure performance and identify areas for improvement and Develop and enhance scripts to automate routine administration tasks.
• Prepared estimation/assessment documents for modifying existing and developing new reports.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS.
• Expert in Deployment solutions into various environments including production, design and develop future solutions to optimize system performance, resource usage and management overhead.
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Good Understanding of Data marts, Data warehouse, Operational Data Store (ODS), OLAP, Data modeling like Dimensional data modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensional table using SSAS.
• Experience in building complex calculated members, named sets using MDX expression for specific OLAP requirements.
• Have experience in working on AWS cloud and databases.
• Performed root cause analysis to identify data flow issues/system performance issues and/or data discrepancy issues and addressed issues as necessary and work with concerned team to implement correction plan.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Direct interaction with business process owners to understand and provide solutions as per their needs across several client applications.
• Extensively worked on SSAS Tabular model and multi-dimensional cube development and SSIS packages designing.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in Implementing High Availability Solutions such as for Log Shipping, Mirroring, and Replication in MS SQL Server Environments.
• Gathered business requirements and Converting them into technical requirements and Implementing by using SSRS.
• Extensive knowledge in T-SQL queries (DDL and DML).
• Maintain and Monitoring of Various SSRS reports, SQL code, store procedures and Solving Tickets on Daily Basis for Production Issues.
• Have in-depth knowledge and experience with TFS and Bit Bucket source controls.
• Experience in retrieving data from Amazon AWS server.
• Monitor company-wide trouble ticket queues.
• Implemented and maintained firewall, series switches and security appliances.
• Documented all server and network problems and other unusual events in detail.
• Experience in providing 24 x 7 production support. Excellent communication skills, organizing skills, highly punctual and an excellent listener.
• Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment.
• Ability to work in a team and as an individual with minimal supervision.

AREAS OF EXPERTISE:

• Data Warehousing
• Business Intelligence
• Enterprise Architecture
• Design Modeling
• Strategic Planning
• Software Development
• Quality Assurance
• Implementing High Availability Solutions
• Agile Scrum
• Security, Governance and Compliance
• Enterprise Reporting
• Data Base Administration
• Performance Tuning

TECHNICAL SKILLS:

• SQL Server
• MS BI Stack (SSIS, SSAS, SSRS)
• AWS
• Performance Point (BI tool)
• Tableau (BI tool)
• SQL Server Tuning Tools
• Star Schema and Snow Flake Schema
• SharePoint
• MS Visio
• Power BI
• SSIS Buffer Architecture
• TFS, Red Gate, Bit Bucket
• C#
• Kimball Methodology
• Power View (BI tool)

PROFESSIONAL EXPERIENCE:

BI Developer

Confidential, Florida

• Analyzed business requirements and provided Database requirements and Design documents.
• Build logical and physical data models that describe all the data and relationships between the data.
• Responsible for designing and creating a staging database for temporary processing of data, consolidating data and loading data to central repository using SQL Server Integration Services (SSIS).
• Created stored procedures to load data using incremental loading techniques.
• Involved in applying data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using SQL Server Profiler and Index Tuning Wizard.
• Responsible enhancement and maintenance of database using innovative methods like use of temp tables, stored procedures, MVC, vertical partitioning (TD columnar feature).
• Developed complex data extracts and ad-hoc queries as requested by internal and external clients using SQL and SSIS.
• Developed complex mappings using SSIS to transform and load data received from clients into the central repository.
• Used various SSIS tasks such as Conditional Split, Derived Column, script task using visual basic which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Databases.
• Enabled Check points in SSIS package. Created break points to view the status of data, variables and over all status of SSIS package.
• Experience in building complex calculated members, named sets using MDX expression for specific OLAP requirements.
• Have experience in working on AWS cloud and databases.
• Created stored procedures to retrieve data periodically that was used in SSIS and SSRS.
• Elicited requirements and generated ad-hoc and custom reports for executive reporting and business analysis using SQL Server Reporting Services (SSRS).
• Integrated SQL Server 2005 reporting services (SSRS) with Microsoft Office Share point Server to automatically deliver reports to the Share Point portal.
• Developed and analyzed business performance multilevel parameterized reports and provided notations of performance deviations and anomalies using SSRS.
• Involved in creating calculated members, named set, advanced KPI'S for SSAS cubes.
• Create Power BI reports using different visualizations like a bar chart, Pie chart, heat map, Map, Donut, Gauge, table matrix, etc.
• Extensively worked on Bit Bucket Source control as well as TFS.
• Design data architecture structures necessary to support BI initiatives to support Power BI reporting.
• Create reusable database models for reporting.
• Create, Maintain or Enhance the Power BI reports using advanced DAX and SQL.
• Develop a detailed project plan to monitor and track progress.
• Highly proficient in T-SQL in building, queries, Stored Procedures, Views, joins, User Defined Functions, Indexes, data integrity, temporary tables, CTEs.
• Develop, implement and optimize stored procedures and functions using T-SQL.

BI Developer,

Confidential, Los Angeles, California

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather.
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions, and calculated members for cube as per business requirements and technical standards.
• Defined appropriate measure groups and KPIs &deployed cubes.
• Created Parameterized reports, Cascaded Reports, Cross-Tab reports, drill down reports& Summary reports by using SSRS and designed reports using Crystal Reports.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

SQL Developer/ Jr. DBA

Confidential, California

• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Wrote complex Stored Procedures to meet the business requirements.
• Created tables, relationships, triggers and indexes for enforcing business rules.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designed and built data load procedures, using MS SQL Server.
• Prepared and Scheduled for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases.
• Implementing MS SQL Server Security and database Permissions.
• Created roles and set permissions to ensure that company’s security policies are enforced and in effect.
• Created reports using SQL Server Reporting Services and report manager.

Project Engineer

Confidential

• Monitor company-wide trouble ticket queues.
• Proactively participated in gathering Business requirements to implement functional and technical specifications.
• Created data extracts and reports based on business requirements.
• Design and develop SQL procedures, views, functions, and triggers to fetch data from different tables by using joins.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Implemented and maintained security system, series switches and security appliances.
• Reviewed logs for all networking devices for unresolved abnormalities and problems.
• Troubleshot and maintained all networking devices and infrastructure across the enterprise including switches, routers and firewall.
• Tested and evaluated CSS software to improve performance and usability.
• Communicated with vendors to resolve network outages and periods of reduced performance.
• Documented all server and network problems and other unusual events in detail.
• Diagnosed system hardware and software problems using advanced root-cause analysis.
• Designed and implemented networks in collaboration with project engineers.
• Providing Static Routing Configuring & Troubleshooting BGP.
• ITIL framework.

Trainee Engineer

Confidential

• Experience with Development and Testing of Restful Services based on Specifications.
• Analyzing different user requirements and coming up with specifications for the various database applications.
• Created Request/Response classes to abstract the underlying database model from the API payloads.
• Created reports in SSRS.
• Worked in creating different organization content pack, and service packs.
• Expertise in creating reports from importing, Direct Query and Live data from several data sources.
• Worked in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created PL/SQL module which was used to integrate the existing data from third parties and on to the database
• Writing Unit test across the layer including API controllers.
• Used TFS (Team Foundation Server) to share all the work, code, to sort out the exceptions raised during work.
• Provided daily Status Updates on work completed and the progress.