SUMMARY:

• Detail - oriented IT Professional with an experience of 6 years in Database Design, Development and Business Intelligence of Microsoft SQL Server in the development, test and production environments with various business domains
• Merit of designing dynamic SSIS Packages to transfer data across multiple platforms
• Experience of implementing error handling procedures in SSIS packages with event handlers, row redirects, checkpoints, and loggings
• Complete knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Comprehensive knowledge of System Development Life Cycle (SDLC)
• An effective communicator with excellent analytical, interpersonal and presentation building & interpersonal skills.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2012, 2008R2, 2008, Azure SQL

Database Programming: T-SQL Programming, Dynamic SQL

Data Modelling: ER-win, MS Visio

BI Tools: Power BI, Tableau

Integration Service: SSIS

Analysis Services: SSAS, OLAP Cubes

Reporting Services: SSRS, Report Builder

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

Cloud Technology: Microsoft Azure, PowerShell, Backup/Recovery

Cloud Services: PaaS & IaaS

Azure SQL Database: PaaS

Azure Storages: Blob, Tables, Queues

SDLC: Agile, Scrum, Waterfall, and Spiral

Collaboration Tool: SharePoint

WORK EXPERIENCE:

Confidential, Dallas, TX

SQL/BI Developer

(Technical Environment: SQL Server 2012, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, Erwin, Power BI, SQL Profiler, DTA, MS-Azure)

Responsibilities:

• Participated in the creation of functional requirement specifications and supporting documents for business systems.
• Contributed in collecting business and technical metadata and maintained naming standards for database objects.
• Maintained data consistency and data integrity utilizing constraints such as Unique, Check, Primary Key, and Default.
• Worked on SQL scripts using local/global temporary tables, table variables, Common Table Expression as per the requirement and convenience.
• Identified slow running queries and stored procedures, and implemented optimization utilizing different techniques such as indexes and SQL Profiler.
• Participated in designing data mart with fact and dimension tables for analytical and reporting requirements.
• Formulated SSIS packages for migrating data from SQL Server and Excel to the staging area.
• Performed slowly changing transformations with SSIS to maintain historical data in the data mart.
• Enhanced the performance of SSIS packages with non-blocking transformations and multiple properties.
• Debugged SSIS packages with error log details, checkpoints, breakpoints, and data viewers.
• Build SSAS cubes with dimensions, perspectives, hierarchies, measure groups, and KPIs to analyse business units.
• Utilized Power BI for creating attractive dashboards with different visualization such as map, bar chart, and pie chart.
• Created new columns, measures and expressions utilizing DAX functionalities in Power BI desktop.
• Formulated reports with multiple options with report designer and report builder in SSRS.
• Designed drill through, sub reports and parameterized reports in SSRS according to business requirements.
• Produced on-demand and scheduled reports with SSRS for business analysis and managerial decisions.
• Involved in establishing cloud environment utilizing MS-Azure with resources such as storage, Azure SQL database and data factory.

Confidential, Irvine, CA

MSBI Developer

(Technical & Environment: SQL Server 2012, Erwin, SSDT, SSIS, SSAS, SSRS, Power BI, T-SQL, Erwin, MS Excel, TFS, DTA)

Responsibilities:

• Collaborated with team members in JAD sessions for understanding business needs utilizing Agile methodology.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis.
• Implemented database objects such as views, triggers, procedures and indexes for supporting OLTP and OLAP operations.
• Integrated dynamic SQL for developing customizable queries utilizing batches, stored procedures and UDFs.
• Administered system and user defined functions to improve the functionality of T-SQL code.
• Planned SQL Server Agent job files to initiate SSIS package execution and report generation.
• Designed STAR schema for the detailed data marts involving confirmed dimensions.
• Implemented data cleansing with SSIS transformations such as data conversion, fuzzy lookup, derived column and lookup.
• Formulated SSIS packages to log data pertaining to errors, package executions, and variable values.
• Established full and daily loads (incremental) with timestamp and checksum techniques in SSIS.
• Administered cubes and objects such as calculated members, KPIs and worked on cube optimization.
• Mapped new aggregations by creating hierarchies; pre-calculated aggregations utilizing aggregation wizard in SSAS.
• Integrated the latest features in Power BI such as sync slicers, bookmarks, drill down effect for user friendly and interactive reports.
• Formulated donut charts and implemented with customized tooltip in Power BI reports.
• Created various Tablix and matrix reports for different departments utilizing complex SQL scripts and stored procedures.
• Utilized caching, snapshot and stored procedures for dataset in SSRS for improved report performance.
• Created and delivered reports in multiple formats with subscription functions in SSRS.

Confidential, Temple, TX

ETL/BI Developer

(Technical Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, SQL Profiler, Erwin, DTA, Windows Server)

Responsibilities:

• Collaborated with business analysts and the project manager to gather business requirements.
• Outlined and developed logical/physical dimensional models of the data mart with Erwin.
• Formulated user defined functions for providing custom functionalities according to the requirements.
• Incorporated error handing techniques such as 'Try Catch' to create robust T-SQL code.
• Utilized complex SQL structures such as while loops, if…else, case statements including temporary objects.
• Reviewed and configured SSIS packages for dynamic execution.
• Designed and developed SSIS packages to extract data from multiple data sources and loaded data into destination tables.
• Developed parent-child architecture in SSIS to populate data into dimension and fact tables.
• Restarted the package execution from the latest point of failure utilizing checkpoints on control flow tasks.
• Built and developed SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting.
• Advised on appropriate storage mode to the cube such as MOLAP, HOLAP and ROLAP based on various factors.
• Rendered reports to several file formats such as PDF, Image, and Excel according to the requirements of the management.
• Produced on-demand reports for business analysis and management decisions with SSRS.
• Designed, tested and deployed SSRS reports to Report Server database.

Confidential, Corpus Christi, TX

BI Developer

(Technical Environment: SQL Server 2008 R2, T-SQL, SSIS, SSRS, BIDS, SQL Profiler, MS Visual Studio, Erwin, MS Excel)

Responsibilities:

• Analysed standards and specific business requirements with the help of JRD session.
• Maintained referential, domain, and column integrities with available options such as constraints.
• Created stored procedures, views, and UDFs for automating data entry by a front-end application.
• Designed new database objects such as tables, procedures, functions, indexes and views utilizing T-SQL.
• Created SSIS packages for data profiling, and data cleansing operations utilizing different transformations.
• Utilized script task and script component in SSIS for customized business logic during ETL process.
• Contributed in the migration of SSIS packages from development to production environments with package configurations (XML and SQL Server).
• Administered the execution and security of SSIS packages on the Integration Services Server.
• Formulated drill down, drill through, cascaded, sub, and parameterized reports in SSRS.
• Designed and developed report templates, bar graphs, and pie charts in SSRS based on OLAP data.

Confidential, Irving, TX

SQL Developer

(Technical Environment: SQL Server 2008R2, T-SQL, SSMS, BIDS, SSRS, SQL Profiler, DTA, Windows Server, TFS)

Responsibilities:

• Participated in the complete Software Development Life Cycle (SDLC) process by analysing business requirements.
• Contributed in the maintenance of referential, domain, and column integrities with available options such as constraints.
• Designed a partition scheme and a partition function to enhance the performance of queries and availability of data.
• Established joins and created indexes whenever necessary based on requirement.
• Improved the execution performance of stored procedures by recompiling them and utilizing efficient SQL logics.
• Identified dimensions and facts to be included in target data mart through analysis of multitude of OLTP data sources.
• Conducted data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.