msbi bi senior business intelligence architect resume example with 15+ years of experience

Jessica Claire
, , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
Home: (555) 432-1000 - Cell: - - -
Professional Summary

Versatile IT Professional Experience in Azure Cloud Over 5 working as Azure Technical Architect /Azure Migration Engineer, Over all 17+Years Years in IT Experience. in Software Development, Analysis Datacenter Migration, Azure Data Factory (ADF) V2. Managing Database, Azure Data Platform services (Azure Data Lake(ADLS), Data Factory(ADF), Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight /Data bricks, NoSQL DB),SQL Server, Oracle, Data Warehouse etc.

Hands on experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005, SSIS, SSRS and SSAS.

Solid understanding and Development experiences in Data Warehousing, Business Intelligence, Data Migration, Data Integration, using various RDBMS (Oracle, MS - SQL Server, DB2, MySQL)

Expertise includes Data Analysis, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Data import/Export, Conversion using ETL tool like SSIS and SSRS.

Experience as a Data Visualization, Data Exploring, Statistical Analysis on Data using Python.

Thorough understanding of Python 3.x/2.x basic concepts like Lists, Strings, Indexing, Slicing, Tuples and Dictionaries.

Familiar with Python Object Oriented concepts like creating classes, constructors, overloading and modules.

Familiar with NumPy, Pandas and Mathplotlib .

Advanced topics like iterators, generators, dynamic code execution, regular expressions in Python

Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.

Expertise in Power BI, Power BI Pro, Power BI Mobile. Experience in various visualization tool like Tableau etc. Experience in Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.

Hands on Experience in working with ecosystems like Hive, Sqoop, Map Reduce.

Successfully loaded files to Hive and HDFS from Oracle

Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL

Expertise at Oracle 9i/10g server (PL/SQL) and MS SQL-Server 2008, SQL, PL/SQL, SQL*Plus, SQL*Loader, configuring client-server connectivity, Query Optimization, Stored Procedures and Triggers and strong knowledge of relational databases. Clever Migration Specialist provides optimized plans and designs to eliminate downtime and reduce costly data management mistakes. Drafts comprehensive and polished data policies and processes to exploit available resources and secure new and existing assets. Dedicated to helping customers leverage digital resources to increase profits and reduce waste.

  • BI Tools: MSBI (SSIS, SSRS, SSAS), Power BI , Business Objects Enterprise XI R2Crystal Enterprise 10 & Markit EDM (CADIS) ( 10.5)
  • RDBMS and Database access : SQL Server 2005 , 2008, 2012, 2014 and 2016,Oracle 10g/11g,MS Access, Hadoop(Hive Database),Netezza
  • Analytics tool/Big data: HDInsight, ProClarity, Google Web Analytics
  • Reporting and Visualization : Tableau, SSRS, ,Crystal Reports XI, Actuate ERD Pro, Crystal Reports 9,Crystal XI Celsius, Business Objects Data Integrator XI (BODI Excel ),Power View
  • DWH: SSAS – Multidimensional and Tabular model PowerPivot - model
  • Methodology and Development Tools: Waterfall, Agile, Scrum
  • Source Control Tracking : VSTF, Visual Studio Test Manager, GitHu
  • Finance Application: Fundsation Application, Recon Plus Application, FSR (Fund Services Reporting)
  • Domain Expertise: Banking & Finance,Capital Markets, Health care, Insurance
Work History
12/2015 to Current
  • Leading Conversion/Interface team (Onsite/Offshore) of various fields like I-Series, ETL (SSIS SQL Server) and SAP
  • Supervising the whole conversion process for all rehearsals/cycles as Data Migration/Integration lead
  • Transferred data from various data sources/business systems including DB2, MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc. Created derived columns from the present columns for the given requirements.
  • Used SQL Server to load tables in support of de-coupled, pluggable architecture to manage data flows between service providers and LIPA.
  • Created SSIS packages to get data from different sources, consolidated and merged into one single source.
  • Created detailed design and requirements documents with logic to help team members understand the requirements and design.
  • Designed and implemented relational databases, data marts and developed reports to allow users to easily access data.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
  • Involved in usage of various SSIS components like Slowly Changing Dimension, Conditional Split, Merge, Merge Join, Multicast, Union All, Sort, Derived column, SQL execution task, Variables, and Error Handling before loading data into the Data warehouse.
  • Designed custom Dimensions and Facts Tables to extend data warehouse.
  • Worked on the project that involved development and implementation of a data warehouse.
  • Created SSIS packages and involved in Package Configurations and deployments between Development and QA and Production servers so that various properties like variables, connection managers could be changed when moving the Package from one environment to another.
  • Involved in Code Review, Unit testing, logging and Custom Logging in SSIS Packages, Query verification in SSIS and Stored Procedures.
  • Conducted system tests, troubleshoot customer issues and correct database defects.
  • Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks.
  • Use customer requirements to improve functionality (speed, performance / usability).
  • Created, tested and implemented SQL backup strategy based on the business needs, utilize the combination of full, differential and transactional log backup to ensure all necessary business data is properly backed up.
  • Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.
  • Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
  • Worked on knowledge transfer and documentation of various jobs developed and deployed into production.
  • Coordinated/Involved in deployment/migration of change requests to testing (System Integration Testing) and production environment.
  • Supported performance related issues in production database and optimized stored procedures/queries with the help of different Microsoft tools.
  • Researched and resolved complex issues discovered during migrations
  • Collaborated with internal teams and customer representatives to determine data migration requirements prior to accepting projects
  • Coordinated data migration activities for ongoing projects to confirm alignment of progress with prescribed timelines and execution milestones
  • Created data mapping documentation for use in migration efforts
  • Assigned data migration roles and responsibilities for new projects to support successful execution of individual migration tasks
  • Led data migration projects, data file analyses, and platform validation
03/2012 to 12/2015
Business Intelligence Architect Adyen Amsterdam, NY,
  • Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
  • Experienced in database design process and data modeling process.
  • Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
  • Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
  • Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
  • Analyzed business requirements and implemented data mart solutions for data mining and reporting.
  • Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
  • Created a report model on SSAS cubes.
  • Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
  • Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
  • Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
  • Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
  • Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
  • Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
  • Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Deployed and Tested (UAT) Reports in Multi User Environment. Created RSConfig Files and Ensure Report Security with Keys.
  • Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
  • Worked closely with QA team and helped them come up with test scenarios.
  • Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data
  • Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards
  • Optimized BI reporting capabilities for secure server environment
  • Collected data from wide-ranging sources
11/2009 to 02/2012
Technical Consultant Benz Communications Chicago, IL,
  • Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2012.
  • Generated reports using Tableau Desktop version, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
  • Designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports, bar charts, score cards, Gantt charts, and Bubble charts.
  • Created Filters, Groups, Sets on Tableau Reports.
  • Implemented data blending advanced visualizations in Tableau.
  • Worked on Dual Axes, Individual Axes, and Blended Axes concepts while working with reports.
  • Generated Dashboard with Quick Filters, Parameters and Sets.
  • Recommending optimized design and chart for specific requirement.
  • Shell scripts to dump the data from Oracle to HDFS.
  • Experimented to dump the data from MySQL to HDFS using Sqoop
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Performance tuning of Stored Procedures and T-SQL Queries.
  • Performed data conversion from flat file into a normalized database structure.
  • Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of the system
  • Actively participated in interacted with users, Technical Lead to fully understand the requirements of the system.
  • Presented business leaders with cost-benefit and return-on-investment estimations to drive project planning and execution
  • Planned and conceived computer systems using information engineering, data modeling and structured analysis
  • Recommended technology upgrades and complementary products to improve client security
  • Collaborated with client and interdepartmental peers to transform client requirements into turnkey solutions
06/2005 to 02/2009
Associate Cognizant Technology Solutions, CTS City, STATE,
  • Provided maintenance support for ETL systems.
  • Provided reporting capabilities, subject-oriented subsets of data designed to meet the business requirements of specific reporting and analysis functions using SSIS and SSRS.
  • Provided a reporting infrastructure, which includes a user-friendly interface.
  • Provided especially to the state of Wisconsin and it also handles center for Medicare and Medicaid services (CMS) and Tricare government projects, my role in here is a SQL server developer with business intelligence, dealing with the Data warehouse and Data Mart.
  • Involved in the business requirements gathering and analysis.
  • Created technical design document and ETL promotional document.
  • Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, DB2, flat file, Text Format Data, SQL Server tables and Facets systems).
  • Educated new hires on company policies and procedures by designing and developing training program.
  • Managed customer relations and customer service through daily communication and interaction.
  • Collected, arranged and input information into database system.
  • Developed reporting and insights for investor relations meetings.
  • Gathered, organized and input information into digital database.
  • Generated reports detailing findings and recommendations.
  • Created and built custom project plans and deliverables for customers to satisfy quality, time and budget.
  • Maximized productivity by keeping detailed records of daily progress and identifying and rectifying areas for improvement.
  • Worked varied hours, days, nights and weekends as business needs dictate.
  • Boosted customer experiences by delivering superior customer service, issue resolution and merchandising.
Expected in 07/1999
Master of Science: Computer Science
Anna University - Chennai,TamilNadu ,India,
Expected in 06/1997
Bachelor of Science: Mathematics
University of Madras - Chennai,Tamil Nadu,India,
  • Brain bench SQL (ANSI) - Score 3.25 (Transcript ID number ID: 8266114) - Aug 2021
  • Microsoft Certification (70-463)- Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 - Apr 2020
  • Microsoft Certification (70-778)- Analyzing and Visualizing Data with Microsoft Power BI - Apr 2020
  • NCFM - Financial Markets: A Beginner's Module(NCFM-00001197275) - Apr 2015
  • Microsoft Certified Application Developer (C#. NET, VB .NET & ASP.NET) - Apr’ 2005
  • Completed L0 Banking and Finance Services - Dec 2005

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Anna University
  • University of Madras

Job Titles Held:

  • Business Intelligence Architect
  • Technical Consultant
  • Associate


  • Master of Science
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: