SUMMARY:

• Accomplished BI Consultant with around 7 Years of experience in design and development of database and data integration applications across multiple domains such as banking, financial, Confidential, hospitality and corporation services.
• Experience in creating databases objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Comprehensive knowledge of the data modeling (dimensional and relational) concepts such as star schema modeling, snowflake schema modeling, fact and dimension tables.
• Experience with SSIS for implementing ETL strategies.
• Proficient with MDX, DAX and possess expertise in T - SQL programming and debugging.
• Excellent problem solving and interpersonal skills with proven capabilities in team building.

TECHNICAL SKILLS:

RDBMS: SQL Server 2016, 2014, 2012, 2008/R2SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS, SSIS, SSAS (OLAP Cubes, Tabular Model), SSRS

Reporting Tools: Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Programming Language: Java & C#

Cloud Services: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data FactoryPowerShell, Azure Storage

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SQL Full Stack Developer

Environment: MS SQL Server 2012/2016, TSQL, SSIS, SSAS, SSRS, Erwin, SQL Profiler, Excel, TFS, DTA

Responsibilities:

• Participate in meetings with business team to understand and gather requirements and generate BRD and FRD.
• Understand source data system and participate in database design, and Data mapping sessions.
• Implement Entity Relationship Diagrams and physical data models using MS Visio.
• Design snowflake and star dimensional models and ETL strategies.
• Assist DBA in performing administrative tasks like backup/restore and replication.
• Develop database objects like stored procedures, views and functions using SQL, and Implement constraints and triggers for database integrity.
• Use extensive experience in performance tuning, query optimization, database optimization and data integrity.
• Develop ETL packages using SSIS to gather data from various sources and populate the Data warehouse.
• Modeled complex SSIS packages with the implementation of master-child packages, loggings, and event handlers.
• Responsible for ETL deployments, and production support for any ETL issues.
• Understand the report requirements to create report specific Tables and Views, and write optimized report queries for stored procedures.
• Develop parameterized, drill down, drill through, as well as ad hoc reports using SSRS as per business needs.
• Managed TFS for source code changes, and proper production deployments.

Confidential, Wilmington, DE

ETL SSIS Developer

Environment: MS SQL Server 2012/2016, TSQL, SSIS, SSAS, SSRS, Erwin, SQL Profiler, Excel, TFS, DTA, Azure

Responsibilities:

• Collaborated with BA, project manager, SMEs to accumulate business requirements via JRD sessions.
• Participated with the development team for planning, defining, and designing functional requirements.
• Initiated stored procedures and functions for implementing the business logic for interfacing with parameterized reports
• Wrote code for preparing newer SQL Server version migrations.
• Developed data migration strategies for populating the data mart with facts and dimensions.
• Designed the logical model and defined various constraints utilizing Erwin for data mart.
• Created data mapping documents for incorporating the ETL strategy utilizing SSIS.
• Established logic for incremental load utilizing time stamp, and SQL server CDC.
• Created SSIS packages for migrating the data from SQL Server to the staging area for data scrubbing.
• Developed SSIS packages for implementing error/failure handling with event handlers, row redirects, and loggings
• Examined the performance of SSIS packages and optimized as required.
• Restored SSIS packages with checkpoints, breakpoints, and data viewers.
• Utilized parameters to configure SSIS packages, improving the migration process
• Implemented SSRS reports such as drill-down, drill-through, sub, and parameterized reports.
• Utilized Team Foundation Server (TFS) for managing source code changes.

Confidential, Dallas, TX

SQL/ETL Developer

Environment: MS SQL Server 2012, SSDT, TSQL, SSIS, SSRS, SSAS, TFS, SSMS, Erwin, DTA, SQL Profiler

Responsibilities:

• Participated with the business users and project managers for gathering system specification requirements for the project via JRD sessions.
• Collaborated with the technical team to transform the relevant/approved BRD into FRS.
• Played a key role in the normalization and de-normalization of existing tables thereby improving query processing.
• Built logical and physical data models using the Erwin data modeler tool.
• Developed database objects such as tables, views, stored procedures, and triggers.
• Improved query performance by creating a multitude of indexes such as clustered, non-clustered, and covering indexes.
• Examined inefficient T-SQL batches and procedures utilizing SQL profiler.
• Created SSIS packages for migrating data between OLTP servers and the data mart.
• Created SSIS packages for processing fact and dimension tables with complex transformations.
• Administered error handling procedures in SSIS packages with event handlers, row redirects, checkpoints, and loggings
• Fixed SSIS package errors by utilizing error logs, breakpoints, checkpoints, and data viewers
• Contributed in migrating SSIS packages from development to production environments with configurations using parameters.
• Managed and configured partition for SSAS cubes for using different storage modes, that are MOLAP, HOLAP, ROLAP for improving performance.
• Created and tested OLAP cubes in SSAS as well as added calculations with the help of MDX.
• Incorporated TFS for project version control and change management with bug tracking

Confidential, Atlanta, GA

ETL Developer

Environment: MS SQL Server 2012, SSIS, SSAS, SSDT, TSQL, Erwin, TFS, Power View, SharePoint, SQL Profiler

Responsibilities:

• Documented business requirements by participating in JRD sessions
• Created ER diagrams for the proposed data mart with the help of Erwin
• Interpreted multiple constraints in logical phase of the data modeling life cycle.
• Developed stored procedures to perform index maintenance, data profiling and generating report datasets.
• Formulated SQL scripts for analyzing historical data and extracted required data for supporting management decisions
• Created SSIS packages to extract data from sources such as SQL Server OLTP, Excel, and Flat Files.
• Modeled complex SSIS packages with the implementation of master-child packages, loggings, and event handlers.
• Developed and secured packages utilizing password and encryption methods.
• Arranged packages with parameters and deployed packages to production servers.
• Built SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting
• Modified roles and KPIs using multi-dimensional expressions (MDX).
• Generated complex reports with multiple datasets and sources in SSRS.
• Managed dashboards, multiple chart types, trends, and KPIs with Power View to support analysis.
• Managed TFS to synchronize data with various sources

Confidential, Cincinnati, OH

SQL/SSIS Developer

Environment: SQL Server 2008R2, TSQL, BIDS, Erwin, MS Access, SSIS, SSAS, SSRS, SQL Profiler, DTA, Power Pivot, DTA

Responsibilities:

• Contributed with the project team and business users for collecting business requirements
• Formulated data mapping document (DMD) by analyzing data sources and mapping to data mart schema
• Created logical and physical data models with Erwin.
• Deployed database objects such as stored procedures, triggers, indexes, views, and UDFs.
• Developed stored procedures for implementing data profiling, data validation, and verification.
• Analyzed source OLTP systems and formulated data mapping documents for the ETL process.
• Incorporated error redirection during ETL loads in SSIS packages at the control and data flow levels.
• Implemented various SSIS transformations such as aggregate, fuzzy lookup, conditional split, row count, and derived column.
• Generated reports by modifying embedded queries and altering stored procedures.
• Produced reports with standard and data-driven subscriptions.
• Created dashboards and scorecards with Power Pivot for business analysis.

Confidential, Los Angeles, CA

SQL Database Developer

Environment: MS SQL Server 2008, TSQL, Erwin, SQL Profiler, DTA, TFS, SSIS, SSMS, BIDS

Responsibilities:

• Interfaced with business users for clarifying business requirements pertaining to the database application
• Sustained referential, domain, and column integrities with available options such as constraints
• Developed stored procedures and functions for data storage and manipulation
• Created stored procedures, views, triggers per business needs.
• Conceptualized and designed standards for database tables, columns, procedures, and views.
• Implemented joins and created indexes whenever necessary, based on requirements.
• Designed SSIS packages with multiple transformations for cleansing data and applying business rules.
• Contributed in formatting SSRS reports with parameters and embedded functions with expressions.