SUMMARY:

• More than 7 Years of IT experience in Analysis, Designing & Development, Implementation & Maintenance of Database and BI Applications using MS SQL Server 2012, 2008R2, 2008, 2005 and 2000 in Development and Production Environments.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements to prepare Business Requirement Document (BRD).
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• 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 using SQL Server.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics and Index Tuning Wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Hands on experience in creating end to end ETL strategies that will include data profiling as well as extracting transforming, conforming and loading data warehouses/ data marts for reporting purpose.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings) and securing packages secured packages with Encryption in conjunction with passwords.
• Created package configurations to provide an easy solution to migrating packages from different business environments.
• Adept knowledge in creating calculated members and KPI's using basic MDX expressions.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Proficient in configuring the Report Server and Report manager to set up roles and security on the reports.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS.

TECHNICAL SKILLS:

Data Modeling: ER-Win, MS Visio.

Database: SQL Server 2000/2005/2008 , 2008 R2/2012.

BI Tools: BIDS/SSDT, SSIS, SSAS, SSRS, Power Pivot, Power View, Tableau Desktop 6.x/7.x/8.x, Tableau Public, Tableau Reader, Tableau Server, Tableau Online, Micro-Strategy Analytics, Micro-Strategy Mobile, Micro-Strategy Cloud.

Languages: T-SQL, C, C++, C#.Net.

Web Development: HTML, DHTML, XML, IIS, LINQ, Asp.Net

Operating Systems: Windows XP, Vista, 7, 8, Windows Server, Tableau Server

SDLC: Spiral Model, Waterfall, Agile, Scrum.

Others: MS Dynamics, CRM, TFS, VSS, SharePoint Dashboard.

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto, CA

Senior SQL Server ETL/SSIS/SSRS Developer

Responsibilities:

• Data warehouse design using Top-down and bottom-up and Data Mart design using Star Schema and Snow-Flake schema.
• Responsible for making weekly backup databases by using SQL Server 2012 and restore these databases in different server.
• 0.2Responsible for data analysis, data designing, data mapping, data quality, business and MDR (Minimum data requirements) gathering, Technical Specification writing, project management.
• Created and refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools like SQL Profiler and Database Tuning Advisor (DTA).
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used C#.Net to write Script in SSIS tasks like Script Task and Script Component.
• Written Code in C#.Net to make Web Application and connect with Backend (SQL Server).
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per the business rules.
• Created SSISDB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated the ETL process by scheduling SSIS package execution by creating jobs.
• Developed SQL-based test and audit scripts to validate SSIS packages and data loads, SSRS reports and report stored procedures.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Designed and implemented Tabular model using SSDT 2012 and enrich the model by adding relationships, calculated columns, measures, KPIs, and hierarchies.
• Created tabular models and reports that retrieve data and aggregates directly from a relational database system, usingDirect Query mode.
• Partitioned the Tabular models for optimized processing and secured to the row-level by using role based security.
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Generated reports using SSRS and Excel Spreadsheets with Power pivots and deployed them in SharePoint integrated mode.
• Used Power View and created various analytical reports andDashboards from Tabular Models tohelp managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.

Environment: ER-Win, SQL Server 2008R2/2012, SQL Server Agent, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SharePoint, TFS, Power Pivot, Windows Server, Tableau (Desktop, Server).

Confidential, SAN FRANCISCO, CA

Senior SQL Server ETL/SSIS/SSRS Developer

Responsibilities:

• Used various approaches to collect the business requirements and worked with the business users for ETL application enhancements by conducting JRD sessions.
• Used Erwin to design the ‘Dimensional Model' of the Data mart with team.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.
• Developed SSIS Packages for ETL process to load and transform the data from multiple sources into the data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used checkpoint to make the package more robust and reduce the time for subsequent execution.
• Implemented transactions at package level and task level to meet the business requirements.
• Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.
• Used package configurations to make the package dynamic and work in different environments like DEV, Q&A, UAT and PRODUCTION.
• WroteSQLqueries to validate data on staging tables and data warehouse tables to validate the data results.
• Created several calculated members, KPI’s as well as perspectives in support of analytical applications and dashboards.
• Created perspectives, partitions, drill through actions to enhance Cube’s utilization.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships, aggregation KPIS’s for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Implemented MOLAP cubes on SQL 2008 Server Analysis Services.
• Designed different types of reports using Report Designer for analysis and validating the information inserted to the data mart.
• Created complex reports that include multiple data sources and stores procedures with nested tabular and matrix forms and formatted the reports using the Global variables and expressions (conditional formatting).
• Involved in Report generation using SSRS and Excel services, Power Pivot and deployed them on SharePoint Server.
• Used Power Pivot and created various analytical reports andDashboards from Tabular Models tohelp managers to identify critical KPIs and facilitate strategic planning in the organization.
• Designed and developed the most suitable User Interface such asDashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Developed User Interface for users on Tableau Dashboards with parameters, global filters and prompts.
• Developed solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau.

Environment: ER-Win, SQL Server 2008R2/2012, SQL Server Agent, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, SharePoint, TFS, Power Pivot, Windows Server, Tableau (Desktop, Server).

Confidential

ETL/Reports Developer

Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modeling tool.
• Created database projects for staging database and data warehouse in visual studio 2008, to store all related objects at one centralized location.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Created different kind of reports like parameterized reports, drill down reports, and sub reports to support business needs and involved in report deployment and report security.
• Developed complex reports like Drill capabilities, Complex freehand SQL queries, Functions, Master Detail, and Cross Tab with multiple breaks.
• Created Ad-hoc reports using Report Models (.smdl) files and deployed it on Report Manager to create reports on the fly for the people who are less adept with technical skills.
• Configured deployment of SQL Server Reporting Services to work with deployment of Microsoft SharePoint Integrated mode.
• Optimized the performance of reports by using various techniques like optimizing data-sets, making use of less number of input parameters along with caching and taking snapshot of reports.
• Implemented security on reports at Server Level, Report Level and Item Level according to the hierarchy in the organization and business requirement.
• Administered interface to organize reports and data sources, schedule report execution, delivery and track report history.

Environment: SQL Server 2008, Transact-SQL, SQL Server Integration Services (SSIS), SSRS (Reporting Services), Erwin, Windows Server.

Confidential

ETL/ SSIS Developer

Responsibilities:

• Created ER diagrams and performed normalization on them to ensure faster querying.
• Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.
• Designed staging database as intermediate stage for population recovery Data Mart to perform various ETL data massaging operations such as data profiling, data cleansing and data verification.
• Created ETL process using SSIS for populating data store in SQL Server.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2008R2 using SSIS.
• Filtered bad data from legacy system using Derived column, lookup, Fuzzy Lookup, Fuzzy Grouping and Conditional Split.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Created Complex SSIS Packages implementing Master-child packages with properties like package configurations, SSIS loggings as well as custom loggings (using Event handlers).
• Involved in implementing proper package configuration features and finally securing the packages by using password and encryption methods.
• Implemented transactions in SSIS by appropriately setting Transaction Option property to Supported, Not-Supported and required based on the type of strategy being implemented.
• Enabled Checkpoints on already implemented transactions to optimize entire ETL strategy so as to start the package execution from latest point of failure.
• Created the design documents for the entire project including table structures and design logic of stored procedures, packages and Reports.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• 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.

Environment: SQL Server 2008, T-SQL, BIDS, SSIS, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), MS Excel, ER-Win, Access, Flat Files, Visual Studio