SUMMARY

• Around 5 yearsin Information Technology with Experense in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, Microsoft SQL Server database management, OBIEE.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Strong T - SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio (MSBI) and SQL Server data tools (SSDT).
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS … Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS utility and extracting, transforming and loading of data using SSIS in MSBIand SSDT.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS.
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services.
• Experience in configuring, scheduling reports for subscriptions on timely basis using SSRS report manager.
• Experience in deploying created reports in various sources like Share points, Reporting servers.
• Good understanding of Data Warehouse Design aspects like Star-schema, snow flake schema.
• Performed daily tasks including backup and restore usingtools likeSQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experienced in visualization tools like PowerBI, Tableau.
• Developed various reports using Tableau best practices and different visualizations like Bars, Lines and Pies, Maps, Gantt charts, Bullets charts and Highlight tables.
• Designed and developed dashboards from worksheets created from multiple data sources using data blending in Tableau.
• Created and published Tableau reports utilizing calculated fields, table calculations, filters, parameters, sets and groups.
• Experience in designing conceptual, logical and physical database models using Erwin.
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.
• Experience in implementing SQL Server data services (SSDS) in optimizing and for Performance tuning and using SQL Profiler. Knowledge on .net framework in various projects.
• Experienced in using C# and VB.NET scripts for various tasks in SSIS.
• Experience with versioning tools like Microsoft Team Foundation Server(TFS) for version controlling of the Application.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, C, Visual Basic 6.0, VB.Net, C#, .NET ASP.NET, HTML5CSS3, JavaScript, SOAP

Databases: SQL Server 2016/2014/2012/2008 R2, MS Access, Oracle 11g

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)Tableau 9.0, PowerBI

ETL Tools: SSIS, Informatica

Data Modeling Tools: Erwin, Visio

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2012 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, MS office, JIRA, TFS

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr SQL Server/BI Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Maintaining jobs for data messaging from development server to test server for generating daily reports.
• Used data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Gantt charts, Bullets charts and Highlight tables.
• Designed and developed dashboards from worksheets created from multiple data sources using data blending in Tableau.
• Created and published Tableau reports utilizing calculated fields, table calculations, filters, parameters, sets and groups.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2014 /2012, Windows Server, SSIS, SSAS, SSRS, Excel, T-SQL, PL/SQL, MS Access, Team foundation server(TFS), Mainframe VSAM & Flat Files, Power BI

Confidential, NC

SQL Server / BI Developer

Responsibilities:

• Involved in creating extensive dynamic SQL to accommodate business requirements.
• Involved in documenting management procedures, plans and processes.
• Created complex store procedures, triggers, tables, views and other SQL joins and statements for applications using T-SQL.
• Involved in performance tuning using indexing (Clustered, Non-Clustered) tables.
• Worked on Query Optimization, execution plans, trace flags and SQL Profiler.
• Used System tables, System stored procedure, DBCC commands for database maintenance.
• Used BCP Utility in stored procedures to generate output files in text format.
• Used scripts and variables, email notifications for ETL process using Data integrator.
• Performed ETL operations to support data loads and transformations using SSIS.
• Extensively used SSIS in creating complex packages using proper control flow and data flow elements with error handling.
• Created, fixed and maintained daily, monthly jobs scheduled.
• Wrote stored procedures and user defined scalar functions to be used in SSIS packages in SQL scripts.
• Optimized ETL packages by increasing memory buffer size and by increasing Max Concurrent Executable.
• Enhancing and deploying SSIS packages from development server to production server.
• Responsible for creating MDX queries from scratch.
• Normalized and De normalized entities for data warehouse.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Monitored daily processes for different data loads and resolved issues.
• Worked on deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports.
• Created tabular, matrix, chart, drilldown, parameterized, cascaded reports and dashboards and scorecard reports.

Environment: SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Profiler, MDX

Confidential, Los Angeles, CA

Sr. SQL Server/BI Developer

Responsibilities:

• Involved in gathering, understanding and validating the project specifications.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2012.
• Developed complex T-SQL queries for the ETL packages.
• Designed packages in SSIS 2012 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Built Synchronous and Asynchronous scripting component for different modes of output.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Created packages with Ragged Right data mapping.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Designed and created views for security purposes, implemented rules, defaults, user defined data types, documented the table relationships with diagrams.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Designed Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality).
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Environment: SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Profiler, MDX

Confidential

SQL/BI Developer

Responsibilities:

• Involved in Physical and Logical design of the Databases
• Interacted with front end developers and managers to analyze the need of business requirement and developed technical specifications.
• Day-to-day incident management; Production issue handling; User follow up.
• Created Database Objects-Tables, Views, User defined functions, Triggers, Procedures.
• Used .Net provider Data Reader source to read from RDBMS Sources.
• Perform code reviews, design reviews and performance tuning
• Created SSIS packages to get data from different sources, consolidate and merge into one single source.
• Implemented different types of constraints on tables.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created levels of Data Flow Diagram using Microsoft Office Visio.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.
• Used Tag-smart for linking the files with the database and creating XML files.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Designed logical/physical data models using Erwin tool 8.0. uses of power pivot.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Optimized the performance of various stored procedures by redesigning T-SQL queries and changing connection and server level settings.
• Generated and validated different reports using Report Builder.
• Performed Administrative tasks like managing roles, users, profiles and creating scheduling maintenances and backups to database.
• Troubleshooting problems related with databases, application tools, development tools and minimizing production down issues.

Environment: SQL Server 2008/12 T-SQL, MS Visio, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), .Net, Tag smart. Erwin.