SUMMARY

• SQL Server/ BI Developer with 7+ years of professional experience in the MSBI stack: Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Good experience as a SQL Developer in MS SQL Server in Production, Quality & Development environments.
• Interacted with the client for requirement gathering, system study & analysis.
• Strong experience in designing and implementing ETL packages using SSIS for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all.
• Hands on Experience in Installing,, Managing, Monitoring and Troubleshooting SQL Server.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
• Experienced in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Developed Dashboard Reports using Performance Point Server on SharePoint, SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Performed Database Normalization to avoid data redundancies.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experience working in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of seven days) called "sprints".
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-Normalized Schemas with respect to query and analysis requirements.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor.
• Experience in working at various levels of software development cycle such as Analysis, Designing, Developing, and Testing & Implementation of business applications in Client Server / Relational Database Management environment for Windows Platform.
• Worked with Database backups and disaster recovery procedures.
• Experience in Software Development Life Cycle (SDLC) including requirements gathering, writing technical specifications and Production support/Maintenance Activities.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access andMicrosoftVisio.
• Managed slowly Changing dimensions (SCD) and optimized fact table inserts.
• Experience in creating and maintaining database and its objects.
• Extensive knowledge in SQL Server 2012/2014 Developer Skills including writing user defined functions, views, query writing.
• Used Control-M to respond to trigger events and to schedule workloads
• Possess exceptional communication and relationship management skills coupled with analytical and mathematical skills.
• Generate and compile simple ad hoc reports and data extraction including multiple tables and ODBC.
• Created SSAS Tabular semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and calculated measures using DAX as per business requirements
• Used Power BI to create interactive reports and to pull data from various data sources like SQL Server, O Data feeds, etc.,
• Good knowledge in creating and managing Event Handlers, Package Configurations, -Logging, System and User-defined Variables for SSIS Packages.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Languages: T-SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, HTML, CSS.

Databases: SQL Server 2016/2014/2012/2008 R2/2008/2005, MS Access

ETL Tools: SSIS, SSAS, SSRS, Power BI, Biz talk.

Data Modeling Tools: Erwin, MS Visio

Operating Systems/Other Software: Windows XP/Vista/7/8

Database Tools: SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor/Analyzer, and SQL Server BIDS, SQL Diagnostic Manager.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

SQL Server Developer/Data Analyst

Responsibilities:

• Practiceddataanalysisworkflow from SQL to Excel.
• Prepared noisy information from given database by performing SQL queries.
• Analyzed the extracteddatawith pivot tables, lookups, conditional formatting, and more.
• Created effectivedatavisualization that addresses the problem.
• Worked with Business Team (End Users) and gathered all the BI Reports requirements.
• Responsible for reviewing BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects and suggested any changes to these, from Data Integrity perspective.
• Extensively usedSQLto generate the required output.
• Developed stored procedures, Triggers, user defined functions for database operation in MSSQL server 2016.
• Performed in depth analysis of data & prepared periodic reports using MS Excel, Power Pivot.
• Experience in creating multiple kinds ofPowerBIReports and Dashboards, so that the reports on cloud are more accessible.
• Experience in writing reports based on the statistical analysis of the data from various time frame and division using Power Pivot,PowerQuery,PowerView,and PowerBI.
• Experience in TuningT-SQLqueries & improving the performance of the queries.
• Audited and cleaned data with Conditional Split, Derived Column, andFuzzyLookup transformation tasks.
• Created Cherwell tickets when data found corrupt, also managed the ticket created by the teammates and maintained a log.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, and User defined data types, Cursors and Indexes using T-SQL.
• Created Drill Down, Drill through, linked and sub reports using SSRS.
• Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.
• Used a verity of transformations in SSIS like conditional split, data conversion, aggregate, fuzzy look up depending on the requirement.
• Performed data cleansing and scrubbing in the staging database.
• Proactively resolve issues to drive quality and system performance improvements across the application.
• Worked with the business to understand the scope of the data warehouse an implemented business rules in ETL (SSIS) andOLTPsystems.
• Used SSIS jobs for extracting data from the flat files and loading into the Databases as per requirement.
• Good knowledge on Normalizing and De normalizing the table structures.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Translates requirements into physical database structures that integrate with existing or proposed database structures.
• Developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views to implement the business rules and transformations.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.

Environment: SQL Server 2016,2014 SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, Jira, TFS, GIT, Cherwell, XML, Power BI, Excel.

Confidential, New Jersey

SQL Server Developer/MSBI Developer

Responsibilities:

• Experience in Designing and modeling SQL Server Database, creating tables and views.
• Writing T-SQL, Stored procedures, functions, views and common table expressions.
• Designing and developing new SSIS (ETL) packages and enhancing existing SSIS packages.
• Automating the ETL executing process through jobs and creating notifications for failure and success.
• Created various SSIS packages for Daily run, weekly run and monthly run for both incremental load data and fully load data to SQL Server, from Flat files or excel spreadsheet, CSV, XML.
• Involved on migrating SQL Server databases to SQLAzureDatabase using SQLAzureMigration Wizard. Deployed application toAzureCloud.
• Performed customization and configuration work onOLTPdatabases, tables, stored procedures, SSIS packages and other objects.
• Developed data model,SQLQueries,SQLQuery tuning process and Schemas.
• Experience in loading the data through Import, Export wizard activities in SQL Server for one time load.
• UsedBiz-talkserver to integrate existing applications and to perform specific transformations according to the business requirements.
• Designed ETL strategies usingVisioshowing Data Flow to peerdevelopersand Lead.
• Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema in SSAS.
• Used Control-M to respond to trigger events and to schedule workloads.
• Created Drill down, Drill through, sub reports through SQL Server Reporting Services and creating subscriptions for automating the process.
• Created complex SSIS Packages for Data Migration and Transformation to and fromSQL, Flat files, Excel Sheets using SSIS.
• Gained proficiency in usingSQLServerand T-SQLand in creating Store procedures, Triggers, Tables, User defined Functions, Views, Indexes, Data dictionaries,SQLjoins and Performance based query writing.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Performed data analysis to generate various trend reports.
• Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.
• Studying business requirement, entering code, implementing functions, and testing applications.
• Conducted release testing, bug verification and software testing.
• Experience in working Development, Testing and Production Database servers.

Environment: SQL Server 2012/2008 Enterprise Edition, SQL Server Data Tools, MSVisio, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Florida

SQL Server Developer/MSBI Developer

Responsibilities:

• Collaborated with business analysts and developers to identify requirements and develop database applications.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, RDBMS,CSV, XML, Excel and Text file from Client servers and through FTP.
• Experience in Normalization and building Referential Integrity Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• WrittenDynamicSQL, Cursors, Triggers, Views and Functions.
• Created database objects such as tables, indexes, views, stored procedures, triggers, and user defined functions.
• Gained knowledge in performing code reviews from other team and made possible changes to improve performance of the code.
• Implemented database standards and naming conventions for the database objects.
• Converted and loaded data from multiple databases and file structures.
• Created indexes, constraints, and rules on database objects for optimization purposes.
• Monitored, tuned, and analyzed database and allocating server resources to improve performance.
• Gained Experience in developing reports using BizTalk BAM.
• Wrote, revised, and verified test cases for testing future software versions and ensuring quality consistency.
• Queried data and created on-demand reports utilizing Report Builder in SSRS.
• Wrote complex stored procedures and views to generate drill-through, parameterized, and linked reports with SSRS.
• Responsible for identifying and defining Data Source and Data Source view extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
• Implemented graphical presentations such as chart and dashboard metrics in SSRS.
• Designed claim status reports, chart reports (line and column), and parameterized performance reports for analyses.
• Developed report backup and delivery schedules by configuring subscriptions and snapshots respectively.

Environment: SQL server 2008/2008R2 Microsoft Share point Portal Server, Log Explorer, VSS, SQL Diagnostic Manager, c#, Biz talk, crystal reports, SQL Lite Speed.

Confidential, Pennsylvania

SQL Server Developer/MSBI Developer

Responsibilities:

• Involved in Designing the ETL for incremental load to keep old and new applications in sync.
• Worked with Change Data Capture (CDC) tasks in SSIS packages to achieve incremental loads.
• Translates requirements into physical database structures that integrate with existing or proposed database structures.
• Developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views to implement the business rules and transformations.
• Involved in creating complex stored procedures, nested stored procedures, triggers, views, indexes and functions.
• Good knowledge on SQL Administration tasks like backups, restore, performance tuning, replication and working with deployments.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Created SSIS packages from scratch to transfer data from source to destination using all required transformations applied.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS.
• Created parameterized reports using charts and sub reports.

Environment: SQL server 2008, Windows 2008R2 Standard Edition, Asp.net, SSIS, SSAS, SSRS, SQL Diagnostic Manager, ETL

Confidential

SQL Server Developer

Responsibilities:

• Involved in Data modeling, designing and building relational databases.
• Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement with MSVisio.
• Created Database Diagram utilizing ER-win as Data Modeler tool.
• Ensured data consistency by creating primary key, foreign keys and appropriate constraints.
• Designed complex ETL (SSIS) packages to migrate data from flat files and Excel toSQLserver.
• Implemented error handling in SSIS packages utilizing event handlers, row redirects, and checkpoints.
• Performed Database Normalization to avoid data redundancies.
• Performed Key Role in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MSSQLServerEnterprise manager.
• Created T-SQLscripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Implemented checkpoints in SSIS packages that enables to rerun a SSIS package from the point of failure
• Maintained referential integrity, domain integrity and column integrity by utilizing constraints.
• Monitored SSIS packages that are scheduled, running completed and failed and advised team on approaches for failed packages.
• Experienced in creating Tables, Views, Indexes and otherSQLjoins and query writing.
• Developed SSIS script task, look up transformations and data flow tasks using T-SQLand Visual Basic (VB) scripts
• Analyzed execution plans and optimized some complex queries by creating indexes and using someSQLbest practices.

Environment: SQL Server 2005, MS Excel 2003, MS Access 2003, MS Visio, MS SQL Query Analyzer, SQL Profiler.