We provide IT Staff Augmentation Services!

Sr. Bi Developer/ Business Intelligence Engineer/data Engineer/pm Resume

5.00/5 (Submit Your Rating)

Redmond, WA

PROFESSIONAL SUMMARY:

  • 9+ years of experience in analysis, design, and development of Business Intelligence solutions. Expert in developing Confidential SSIS package to Extract Transfer and Load data between databases and different external data sources using T - SQL, SSIS, XML and SharePoint. Extensive experience in creating reports using SSRS.
  • 9+ years of experience in SQL Server Database design, development, maintenance, and administration in all major versions of Confidential SQL Server in OLTP and OLAP environment.
  • Strong relational database administration and multidimensional cubes capabilities using SQL Server 2005/2008 using Business Intelligence Studio and SQL Server Management Studio.
  • 5+ years of experience in development and testing Confidential SharePoint Server 2007/2010 with in depth technical background with the SharePoint MOSS platform and WSS 3.0, including users and permissions, content types, web parts, workflows, layout and master pages.
  • Excellent in developing T-SQL (DDL, DML) queries, T-SQL programming, stored procedures, views and triggers using all major SQL Server versions.
  • Expertise in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS).
  • Excellent experience in designing Use Case, Class, Sequence, Collaboration, State, Component, Deployment, Activity diagrams using UML.
  • Experience in Object Oriented Design and Analysis, Rational Unified Process (RUP), Confidential Visio, UML, and Rational Rose.
  • Experience in creating Test Plan, Test Cases, running test cases and document the result.
  • Reliable, efficient and experienced in working with medium to large scale on site and offshore teams.
  • Fast learner, work well with teammates, good communicator, passionate to self-learn new technologies and open to feedback.
  • Ability to work well in a team in collaboration with developers, testers, project managers, and customers.
  • Experienced in Confidential BI stacks and other technologies.
  • A strong track record of successful project delivery for large projects.

AREAS OF EXPERTISE:

SQL Server, SSRS, SSAS, SSIS, Power BI, ETL processes, Tableau, R, Azure ML, Azure Data Factory, Confidential Excel/Excel Services and SharePoint, MS Access, C#, Hadoop/Hive, Big Data, Object Oriented Design and UML, MS Project, Visio, Excel, Confidential PowerPoint, SCRUM, Scrum Master, Product Owner, Sprint Planning

CAREER PATH:

Confidential, Redmond, WA

Sr. BI Developer/ Business Intelligence Engineer/Data Engineer/PM

Responsibilities:

  • Designing and deployed Marketing Data BI platforms for Customer Insights, Partner Insights and Predictive Analytics
  • Coordinated with customers and Business Analysts to determine business data reporting and analysis requirements.
  • Led business report generation to internal and external customers for business decision making.
  • Developed scalable enterprise data warehouse for Marketing data team to support internal and external BI Reporting using Confidential SQL server and BI stacks.
  • Supported SQL Server Database Administrators and Developers to build data warehousing systems for business intelligence, reporting and analytics.
  • Helped in data administration, modelling and integration activities in data warehouse systems.
  • Developed and deployed reporting dashboards using Confidential Power BI.
  • Led reporting platform as scrum master, implemented and deployed several data onboarding and clean up ETL.
  • Implemented business intelligence solutions to achieve data reporting and analysis goals.
  • Supported the development of business intelligence standards to meet business goals.
  • Coordinated with the business units to identify new data requirements, analysis strategies and reporting mechanisms.
  • Assisted design and generation of reports in timely and accurate manner, worked with the business units to improve business operations.
  • Trained and guided the junior engineers in data reporting, ETL development and analytical skills.
  • Provided enhancements and modifications to optimize business intelligence processes.
  • Addressed business intelligence queries and issues in a timely fashion.
  • Maintained documentations for all business intelligence processes
  • Worked as part of the Marketing Data team to define the Next Generation enterprise data platform in order to support the company's strong internal data growth and requirement for flexible business practices.
  • Led for end-to-end vendors and client engagement management, right from requirement gathering to solutions delivery.
  • Built robust analytics publisher to support model publishing with APIs that can be used across SMIT to make models scores available on Global Marketing Execution Database(GMED), which is externally managed data platform that enables centralized campaign targeting/execution of the Worldwide Marketing universe.
  • Architect and design Analytics Publisher to host hundreds of predictive Model scores and BI platform.
  • Work with data scientists, business analysts and other stakeholders to develop data integration specification documentation that detail data sources, data mapping, validation steps, and exception handling for integration solutions.
  • Work in Confidential Visual Studio 2008/2012 project environment to create dynamic metadata driven SSIS packages for source data extracts and destination system updates.
  • Perform unit and system testing to verify data integration workflows, data integrity, and data quality validation rules.
  • Perform source data analysis, data profiling, and data transformation mapping for heterogeneous systems environment.
  • Built earlier version on Hadoop on premises using Isotope and later successfully migrated the content and process into Azure HDInsight to process Digital models
  • Built meta data driven SSRS reports so to eliminate manual report building and hosting process and deployed it successfully.
  • Built Meta data driven SharePoint reporting platform that can saves time and resources for the Advanced Analytics.
  • Led the design and development, enhancement and refresh process of Partner Account Targeting (PAT) tool using 2000+ data mining models crunching data and turning data into business insights and shares cross-sell/upsell/upgrade propensity
  • Lead the team working on Analytics Portal from pure SSRS to fully SharePoint integrated site with very interactive and Meta data driven HTML5 reports.
  • Implemented analytical process to refresh model portfolio and data infrastructure to achieve great operational efficiency, automated analytics model refresh process.
  • Implemented Analytics Explorer to facilitate analytics model reports search on Analytics Portal.
  • Led migration of analytics modeling platform from on premises SSAS to cloud based Azure ML and ADF.
  • Determines marketing data structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
  • Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
  • Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
  • Interact with cross functional business leaders in implementing statistical models and interactive tools to help sales and marketing teams prioritize their customers and develop processes to acquire data ongoing from various input points
  • Implement data analysis techniques and generate meaningful insights from the data Identifying opportunities
  • Analyze customer and operational data and produce analytical predictive models which are accurate and can be relied on to a high level of confidence
  • Supported as a consultant to campaign managers to explain insights from predictive analytics.
  • Design prioritization framework to score proposed initiatives against Business Strategy and Customer Satisfaction impact.
  • Managed creation and enhancements of customer data self-serve data sets leveraged by sales and marketing programs teams
  • Work closely with Platform team, data source providers for data knowledge, data quality issue reporting
  • Lead identification, selection, verification and cleansing of internal and external data process and ensure that all relevant data is gathered, recorded correctly and stored in such a way that analysis can be done in the simplest and most time efficient manner
  • Proven ability to build relationships with business partners to understand data needs in order to execute with excellence on documented user requirements and prototypes
  • Manage Operations and development team and ensure that all identified gaps in information are filled
  • Developed analytics platform on cloud to scale analytics and evangelize it across new/potential customers
  • Built relationships with business partners to understand data needs in order to execute with excellence on documented user requirements and prototypes
  • Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
  • Provides database support by coding utilities, responding to user questions, and resolving problems.

Confidential, Bellevue, WA

Sr. Business Intelligence Consultant

Responsibilities:

  • Consultant on Design, development and deployment of Best Practice Campaign management system
  • Designed Business intelligent system to consolidate variety of data sources to come up with dashboard to be used by Marketing audiences in the company
  • Follow industry best practices, design and develop new ETL processes to support various BI/Analytics reporting and application used by marketing audiences.
  • Extensive experience in creating Database, Data Modeling, Schema and Database Management.
  • Analyze & validate data in partnership with the business owners to identify trends, problems areas, and opportunities for improving customer experience.
  • Extract Transform and Load data from the relational database and prepare reports using SQL Server 2005/2008 Reporting Services.
  • Extensive experience in full life cycle of SSRS (Authoring, Managing and Delivery reports)
  • Create several Stored Procedures, triggers, user defined functions ( Confidential ) to implement the business logic.
  • Involved in Creating and manipulating ETL calls through SSIS using stored procedures and complex queries and make automated.
  • Create a staging database and apply the business logic using T-SQL scripts.
  • Design and develop Fact tables and Dimensions based on the business logic.
  • Experience in creating executive summary report using SSRS 2008.
  • Design and Develop cubes.
  • Work on data modeling design based on the business request from cubes and OLTP.
  • Prepared stored procedure, views, scripts and triggers to be pivoted and executed for the reporting purpose.
  • Involved in creating different reports based on the business request and adhoc requirements using SSRS 2005/2008.
  • Create scorecard and dashboard using PerformancePoint server and SharePoint.
  • Work on analyzing of data to prepare Executive summary report using charts, Graphs and Gadgets.
  • Create SharePoint portal site for reporting purpose.
  • Publish reports into SharePoint portal site from SSRS 2005/2008.
  • Create dashboard and scorecard systems using Performance point server.
  • Created a custom Report Viewer Web Part in a SharePoint application that can display data from CCMS data source.
  • Re-engineered various features to improve product reliability and compatibility.
  • Implemented and ran tests to exercise the report stored procedure functionalities.
  • Identified performance bottlenecks in script execution.
  • Performed upfront performance and stress testing on real customer scenarios.
  • Improved code quality through peer code review.
  • Successfully helped our partner’s gain an in-depth understand of this project.
  • Created and customized internal SharePoint site to track project specific activities. Created a web template and site pages, and also customized the layout of Web Part zones.

Confidential, Redmond, WA

Sr. BI Developer/Administrator

Responsibilities:

  • Create Executive and detailed BI reports based up on client’s requests.
  • Defining business requirements into technical spec,
  • Define and develop business intelligence solutions, create KPI data to identify trend analysis.
  • Manage recurring reporting requests and project deliverables, including ad-hoc reporting requests.
  • Create score card systems and dashboard using SSRS and SharePoint to display live data and trends.
  • Extensive experience in creating Database, Data Modeling, Schema and Database Management.
  • Extract Transform and Load data from the relational database and prepare reports using SQL Server 2005/2008 Reporting Services.
  • Experience in full life cycle of SSRS (Authoring, Managing and Delivery reports)
  • Involved in Creating and manipulating ETL calls through SSIS using stored procedures and complex queries and make automated.
  • Create a staging database and apply the business logic using T-SQL scripts.
  • Design and develop Fact tables and Dimensions based on the business logic.
  • Involved in creating executive summary report using SSRS 2008.
  • Design and Develop cubes.
  • Work on data modeling design based on the business request from cubes and OLTP.
  • Prepared stored procedure, views, scripts and triggers to be pivoted and executed for the reporting purpose.
  • Involved in creating different reports based on the business request and adhoc requirements using SSRS 2005/2008.
  • Work on analyzing of data to prepare Executive summary report using charts, Graphs and Gadgets.
  • Create SharePoint portal site for reporting purpose.
  • Publish reports into SharePoint portal site from SSRS 2005/2008.
  • Create dashboard and scorecard systems using Performance point server and SharePoint.
  • Set up and administer MS SQL Server databases for production, QA, and development.
  • Created new stored procedures, T-SQL, Stored Procedure, View, User Defined Function ( Confidential ) and Trigger. Modified existing ones and tuned them such they perform well.
  • Customized and developed reports using Confidential SQL Reporting Services (SSRS 2005, 2008).
  • Developed SSIS with logging, event handling and error tracking to support the BI processes.
  • Created package configurations, deploy Integration Services projects and schedule SSIS packages via jobs.
  • Converted C# application into SSIS package to load/transform data.
  • Addressed performance issues associated with stored procedures and fix them.
  • Supported all production operation activities, with focus on integration and development of new and existing products and services.
  • Build models for new database development and/or changes to existing ones.
  • Analyze and monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Monitor, optimize and allocate physical data storage for database systems.
  • Plan and coordinate data migrations between systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Support creation of required reports in response to business user needs.
  • Perform database transaction and security audits.
  • Establish appropriate end-user database access control levels.
  • Lead and/or provide guidance to junior members of the team.
  • Analyze and fix ETL integration related data quality impacts

We'd love your feedback!