SUMMARY

• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in MSSQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, loading data fromSQL Server, Access, Excel, Flat Files and XML using, SSIS.
• Experience in migrating SSIS packages to Azure environment.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in creatingSQL Server Reports using SSRS
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill down and Sub reports and formatting them.
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Expertise inSQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in Creating, Modifying Measures, Dimensions Attribute relationships and Hierarchies.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Experience in managing Alerts, Operators and Scheduled Jobs throughSQL Server Agent.
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL), Cognos 10, Impromptu and Powerplay.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers.
• Experience in code optimization and improving efficiency in databases including re-Indexing, updating statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. SQL Server BI Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Worked on Agile/SCRUM methodology for iterative and incremental development for financial department.
• Studied the data requirements and the impact analysis on the existing schema.
• Responsible for design, develop and maintain SSIS packages
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Worked on performance tuning on existing SSIS packages.
• Building and managing SSRS, Tableau, PowerBI reports.
• Generated various reports like Cascade type reports, Tabular reports, Drill down, Drill through and sub reports on request of client.
• Developed complex stored procedures using T- SQL to generate Ad hoc reports withinSQL Server Reporting Service (SSRS).
• Connecting PowerBI to different data sources -SQL databases, Cubes, Web services, Web trends, Excel, Azure.
• Managed and coordinate with remote user for change request and optimization of application.
• Scheduled jobs, alerts and designed and implemented user log in and security.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Actively participated in the meetings to meet the goals.
• TestedSQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Developed data ware house using Kimball methodology.
• Normalized and De-normalized entities for the Data Warehouse.
• Recognized the fact and dimension tables from the OLAP database.
• Developed approaches for data warehouse implementation and data acquisition.
• Used Microsoft Azure infrastructure as a service to build, deploy and administer reports.
• Explored Erwin for Data Mapping and Modeling.
• Optimized the embedded application T- SQL code as well as the stored procedure that is used to feed reports.
• Design, coding, testing, debugging and documentation of applications.
• Working with QA team for testingSQL codes.

Environment: MSSQL Server 2017,SQL Server Integration Services (SSIS),SQL Server BI Reporting Services (SSRS),SQL Server Analysis Service (SSAS), TFS, Visual Studio 2016, ASP.Net 4.0/4.5, Microsoft Azure, Salesforce, Microsoft Office SharePoint, PowerBI, QlikView, Tableau

Confidential, Bentonville, AR

SQL Server BI Developer

Responsibilities:

• Actively collaborate with users, Team leads, and technical managers to fully understand the requirements of the system.
• Migrated data from Heterogeneous Data Sources and legacy system (Oracle, DB2, Access, Excel) toSQL Server databases usingSQL Server Integration Services (SSIS) and SSMS to overcome transformation constraints
• Build the process using SSIS to load data from different files (Excel, text) toSQL Server and create various reports.
• Worked on highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components.
• Designed / developed several Reports in SSRS, PowerBI and tableau usingSQL Server tables and SSAS Cube.
• Developed various Dashboard, Charts and Graphs like Bar Chart (Side by Side, Stacked, Combination of bar and line chart), Line graphs, Pie Charts in PowerBI and Tableau desktop.
• Worked as a Designer anddeveloper matrix and tabular reports with drill down and drill through report using SSRS.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS, Tableau.
• Working on Highly complex parameterized reports (One parameter is depending on other parameter with help of different store procedures, filtering the records) in SSRS.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Wrote complex MDX queries for calculated members and measure groups.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on reports modification like Parameters changes, Store procedures, Data sets and Expression.
• Developed complex T- SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Worked on Unit testing for SSRS Reports, SSIS Packages and T- SQL Scripts.

Environment: MSSQL Server 2012, Microsoft Visual Studio 2012, T- SQL, SSRS, SSIS, SSAS, MS Excel, Microsoft Azure, Visual Safe Source, TFS, SVN, MS Visio, Tableau, PowerBI.

Confidential, Livingston, NJ

Sr. BI Developer

Responsibilities:

• Design and develop SSIS packages for data movement between Oracle andSQL Server via Denodo.
• Develop stored procedures/functions based on business rules
• Perform data analysis and address the data gaps
• Developed SOX validation check in SSIS for data by reconciling the data between source and destination
• Responsible for daily and monthly jobs which populates facts and dimensions.
• Create tabular and matrix SSRS reports on top of OLAP
• Created dashboard to show performance metrics ofSQL Server from perfmon counters.
• Create an SSIS package for automating metadata driven regression testing.
• Enhanced SSIS packages to handle exceptions by sending an excel attachment in an email with the error rows.
• Optimized a table valued function by analyzing fragmentation and statistics used in the query
• Migrated legacy file system deployment to SSIS catalogs.
• Working on a data store (single source of truth) that serves as a data source for multiple downstream systems
• Work with technical lead to understand requirements.
• Create technical mapping documents.
• Responsible for meeting daily SLA for data to be available and communications
• Managed offshore team and coordinated work for 24-hour productivity cycle
• Following lean software development in Agile

Environment: MSSQL Server 2012, (SSIS)SQL Server Integration Services, T- SQL, Oracle, PowerBI, TOAD for Oracle, SharePoint 2012, TFS 2013, Denodo, Agile, Control M, attunity connector for oracle, Denodo VQL, Squirrel, Agile, Team FoundationServer 2013